Hi All,
I am working on a use case where i need to first convert CSV to excel then import converted excel with extra column to a staging table.
Reason to use import excel to database intend of directly using csv to database is i need to dynamically add process instance id in staging table. I didn't find any option to achieve same in CSV to Database.
CSV to excel is working fine. I am able to generate XLSX file and passing it to import excel to database. My process is getting completed successfully but i don't see data in staging table.
I tried converting csv to xlsx in my local machine and used locally converted xlsx in process model, it worked but same when i am trying to achieve from CSV to excel smart service generated excel, data is not getting imported. I don't have auto generated column in my XLSX file.
Please advice what can be done resolve this issue.
Thanks in advance for your help.
Discussion posts and replies are publicly visible
I'm having issues converting CSV to Excel with the CSV to Excel plug in, could you please indicate how are you doing that conversion?
Hi carlosm Can you please elaborate what error you getting ?
Below is detail of configuration i have done,
Create New Document : True, Delimiter : ,Existing Document : pv!CSVdocument New Document Name : "ABC"Save In Folder : Cons!FOLDER_LOCATION sheet Name : Empty Source Document : pv!CSVDocument