I want to export creatio contacts data on a daily basis to specific location
I am taking approach of using BPM tools to create a process where I can read the contact data, convert them all in uppercase and then export it to specific location.
I don't know how to export data after converting them to uppercase
You could possibly use that in a process and then attach it a record or email it somewhere to include the data you want to export. Not sure if that would help you accomplish the task or not, but wanted to mention that as a no code approach to generate an Excel file as an "export".
However, you could also read the data from Creatio via OData and write it to files somewhere as well.
After reading the description and installation part of Excel reports add-on in the marketplace, I came to know that this product will provide analysis reports in Excel file. Is there a way to have process element in process designer which directly takes data and export it in specific location?