Import CSV to Database

suryanshuj0001 over 5 years ago

Getting error while putting the "Table Name" in Data tab in "Import CSV to Database".

Help me out to put the Table name in "Import CSV to Database".

Discussion posts and replies are publicly visible

Parents

0 mohamedt808 over 5 years ago

Hi, Can you share what is the error that you are seeing??

if your table name is 'employees' store the same in constant and use it in the smart service. Incase if your DB is SQL server and your table name should be added with schmea i.e.if Schema name is EOA then your table name should be EOA.employees.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 suryanshuj0001 over 5 years ago in reply to mohamedt808

Hi, After creating the constant of Table Name, i am still getting this error "???Unknown column '' in 'field list'???"
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 mohamedt808 over 5 years ago in reply to suryanshuj0001

This error states that there is an additional column in the file that is not in your DB. Please check for the same . Also ensure your column name matches the file headers.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 suryanshuj0001 over 5 years ago in reply to mohamedt808

Hi,

My Process model is run Properly but didn't get the data in database.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 mohamedt808 over 5 years ago in reply to suryanshuj0001

HI, To analyze the issue can you share your file template and table structure ?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sergiog0001
A Score Level 1
over 4 years ago in reply to suryanshuj0001

unfortunately you still have to get the errors from the OUTPUTS of the node, probably the smart service is failing but now the error is being saved on the Output variables
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 sergiog0001
A Score Level 1
over 4 years ago in reply to suryanshuj0001

unfortunately you still have to get the errors from the OUTPUTS of the node, probably the smart service is failing but now the error is being saved on the Output variables
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data