Skip to main content
S
surajits0001
April 19, 2021
Question

Import CSV to Database smart service

  • April 19, 2021
  • 10 replies
  • 0 views

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.

    10 replies

    B
    baratc
    April 19, 2021

    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

    S
    surajits0001Author
    April 19, 2021

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

    Z
    zakarym0001
    April 19, 2021

    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

    S
    surajits0001Author
    April 23, 2021

    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.


    Z
    zakarym0001
    April 23, 2021

    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.

    Terms & ConditionsAccessibility statement