Skip to main content
simples0828
New Participant
Oct 14, 2022 1:45 PM UTC
Question

Excel generated from CSV is not importing data in table

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. 

4 replies

agamb0001
agamb0001
Participating Frequently
Oct 14, 2022 1:58 PM UTC

hi [mention:1733fc8d2e79468099ecad53fe3d384a:e9ed411860ed4f2ba0265705b8793d05]

What smart service did you use for importing CSV to Database ?

Did you try the additional columns parameter present in 'Import CSV to Database' smart service?

It should work and would remove any requirement for your excel conversion !

simples0828Author
New Participant
Oct 17, 2022 6:17 AM UTC

Hi [mention:d8b421a354554ef089fa196070da6bf2:e9ed411860ed4f2ba0265705b8793d05], Thanks for your replay. After your comment i checked plug in version and looks like we are on older version of excel tool hence don't have new column option in CSV to Database. 

I created new CSV templet from database, this time converted excel has worked. I still don't understand why it didn't worked last time as I followed same process. Anyway this is resolved now and thanks for your help. 

carlosm
carlosm
New Participant
Oct 20, 2022 5:50 PM UTC

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?

simples0828Author
New Participant
Oct 27, 2022 4:55 AM UTC

Hi [mention:7e08e9f3d5e84b9c81f492800ac53919:e9ed411860ed4f2ba0265705b8793d05] 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

Terms & ConditionsAccessibility statement