Hi,
I'm attempting to upload a CSV file to SQL server database on Appian V23.2
The database table has been an existing one for the upload process which was originally an Excel document which got converted to CSV within the process model. We're in the middle of changing this to do straight upload of CSV file.
Issue we are having is that the CSV column names are produced from a third party site (Salesforce) and cannot easily rename the column names to match the database table names.
sample CSV Column names:
sample database table names
OPPORTUNITY_ID | ACCOUNT_NAME | STAGE | OPPORTUNITY_OWNER
Using the "import CSV to Database" smart service, it seems that both have to match if the file is headered. No ability to have different csv column names to that on the database, even if the number of columns match.
I've tried setting 'File has Header' to true and leaving both 'Database Field Names' and 'CSV Header Names' blank but nothing is written to the table, no error returned either. Similarly with 'Column Names'
Is there a way to import a csv file to a database table without having to manually rename the CSV columns to be that of the database?
Thanks,
John
Discussion posts and replies are publicly visible
any luck with this smart service, i too have same error
Hi Sandya Could you a raise a new discussion please, as it was 9 months ago. Please raise a new discussion and provide the context of your issue for better understanding