Skip to main content
luzhew0001
Inspiring
December 10, 2021
Solved

a example of import csv to database

what should i fill in each blank of smart service in process model, or in interface smart service code?

    andrewh0007
    andrewh0007Answer
    Inspiring
    December 13, 2021

    You'll either need to change the table or somehow ensure the excel file doesn't exceed the limits on your table. No way around that one.

    View in thread

    32 replies

    andrewh0007
    andrewh0007
    Inspiring
    December 10, 2021

    This is part of the Excel Tools plugin (https://community.appian.com/b/appmarket/posts/excel-tools#) and a readme PDF is available in the download. As of version 2.2.16 the readme provides the following info on the inputs to the smart service.

    luzhew0001Author
    Inspiring
    December 10, 2021

    what is delimiter?

    andrewh0007
    andrewh0007
    Inspiring
    December 10, 2021

    CSV stands for Comma Separated Values as traditionally the delimiter is a comma. It doesn't *have* to be though. So it's the character (Or characters? Never tried with more than one character) that separates your values in the CSV.

    Terms & ConditionsAccessibility statement