Is there a way to either generate a csv file in Nintex Workflow or convert an excel file or anything that can be done. I would like ot use Nintex to generate and email a csv file on a schedule.
Hi
Without knowing your exact data source, I can only give you general information.
As a CSV is just strings delimited by commas, you can loop through data and construct the string using create a text string action(s).
There is a Read Excel xtension in the Nintex Gallery that may be helpful.
https://gallery.nintex.com/t/read-excel-file
It returns a JSON string that you could easily turn into a CSV by basically chopping off the curly brackets using a modify string action or a Regular expression action.
Good afternoon
I am not asking the question, but I would like to add on to this since I have the same problem.
I am getting some data from the SharePoint api after which I turn it into a collection of csv rows (Basically: Title,Description..etc). I tried constructing a string, but I cannot find how to add a new line character so I gave up on that and went on to creating a template file that I can use in a Generate Document action, but that file has to be an .xlsx and it can’t be a csv so I am currently stuck on that.
How can i build the csv file if I can’t add new line characters?
HI,
Hmmm, Sorry. I forgot about the line breaks. The only other thing I can think of is to create an extension that calls a web service to do the conversion.
Hi
Has your question been answered?
Hi
I just saw this post where the user is creating a CSV file.
I think it might help with your solution.
Hi
Hi
There is nothing out of the box that can create the file.
This means you would need to find a company that provides an API to generate the file or develop and host the API yourself.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.