Upload a csv/excel and save to entity store

Question

I am new to Appian and I am evaluating the Appian. 
 I want such function depicted in the subject. 
 I searched in the "Discuss" and some threads said that I can use "Parse Excel to CDT". But I can't find such function in the community version. 
 There are also some threads saying that some plugins can support such feature. But I can't find any plugins in the community version. 
 Please anyone can confirm such functions are available in commercial version? 
 Or any other alternate way to fulfill such function in community version?

Selvakumar Kumarasamy · Accepted Answer

Hi, 
 This plug-in will be useful to import data- https://community.appian.com/b/appmarket/posts/excel-tools 
 You can import this plugin into your environment via the admin console to make use of them.

Selvakumar Kumarasamy · Answer

Yes, you can access the document by manually downloading the plug-in from the community. Inside the zip file, there will be a PDF called 'Readme' - it will contain the information about the plugin. 
 To answer your questions: 
 
 It's the data source name configured in your admin console. For cloud installations, it will be mostly jdbc/Appian 
 Yes, as per the Database table 
 You can just skip it

Selvakumar Kumarasamy · Answer

So, you're having a MariaDB connected to your Appian instance. As the error stated, this smart service will work only with MySQL database. 
 An alternate option is to use the " Import CSV to Database" smart service under the same plug-in. It also contains similar input parameters.

Upload a csv/excel and save to entity store

Top Replies