Import CSV to Database smart service

Hi SurajitSen,

Please check whether Excel Tools option is available after Expanding Integration Services Menu in the Process Model Designer.

If the plugin is not available

Please refer the below link for plugin details

https://community.appian.com/b/appmarket/posts/excel-tools

Please contact your admin for installing the plugin (for local instance). 

if you are using cloud instance, please  check whether you have access to install. else reach out to Admin,

Upon installation, you will find the Excel Tools option by Expanding Integration Services Menu in the Process Model Designer.

Please let me know if you see any challenges.

Hope This helps. Thanks

Thank you for your suggestion. I will definitely try to install it as per your instruction.

If you run into any problems along the way there's some helpful information in this discussion https://community.appian.com/discussions/f/general/18327/issue-with-import-csv-to-database-v5-smart-service

Thank you for the link provided by you.
Unfortunately I am not able to insert data to database table using this smart service. I have tried to insert data from CSV to SQL Server database as well as MySQL database. But in both case it did not work. The process also not throwing any error.
Can you please help me with an example by showing how to assign different parameters of “import CSV to Database v6" smart service of Excel Tools plugin?
Also please mention how should I assign the different column names to "Column Names" parameter because it only takes text type data and also not allows to make it Multiple.

Okay, just tested again to be sure and everything here worked.

The Data Inputs on my Configure Import CSV to Database v5 are as follows...

C S V Document: =pv!csvToImport
Charset: UTF-8
Column Names: ="firstname,lastname"
Data Source Name: ="jdbc/appianDs"
Delimiter: =","
File Has Header: true
Table Name: ="mytableforcsvimport"

Some things to check...
1. Column Names field must be provided if your File Has Header is set to true.
2. Make sure you have proper casing in both your csv header and your Column Names field. Your CDT may have camelCasing, while the table in database actually has all lowercase (one of my original problems).  Casing needs to match what is in the database
3. When choosing your file to import preview the it just to be sure everything looks exactly as expected.

Thank you very much for your help. I have able to import data from CSV to SQL Server successfully.

One question. Can you please let me know what is the maximus size of CSV file which can be handled by this smart service?

Unfortunately I do not know the answer to that question.  If you have a chance to do some testing and figure out the answer please leave another comment on this thread to let others know.

Good job and good luck!

Edit... From this thread it looks like 210,000 may be the max https://community.appian.com/discussions/f/data/18971/import-huge-csv-to-database

Hi Surajit,

Can you help me to load the data from csv to database using csv Smart service

Hi 
I am trying to save data in the Appian database through CSV in the same way

not getting any exceptions in the process model but not able to save data.

Can you please help me out?

Do we have to config in the output tab also?

Hi Yogesh,

which database you are using (Mysql,Oracle,etc)? configure the output also & see what you are getting in the output variable.