Import CSV to Database smart service

Question

I am new in Appian application development. Can any one please help me to know how can I get and use the Import CSV to Database smart service ? Should I use any Plug-ins? If yes where from I can get it? I searched for it but did not get it.

baratc · Answer

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

zakarym0001 · Answer

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.