Skip to main content
M
maryl0003
July 17, 2023
Question

How to covert csv File that is uploaded by user on UI to CDT?

  • July 17, 2023
  • 2 replies
  • 0 views

Hi Experts,

I Need your help.

There is a use case where I am designing an Interface from where the user uploads a CSV file and I have to convert that CSV file data to CDT.

And once this has been converted into CDT I have to show that data in a read-only grid on the Interface.

Thank you in advance for your support!

Below is the overview of the data of my file:

2 replies

sarathkumr268295
sarathkumr268295
July 17, 2023

I think Excel tools plugin might be able to help you. You can use that plugin to store the csv data into database, query it from db and show on your UI. 

Please refer the below link for more context
community.appian.com/.../excel-tools

mikes0011
mikes0011
Brainy
July 17, 2023

Provided that the CSV file you're using will not be huge (over 1000 lines) and will have a consistent delimiter used, it looks like you can use the function "previewcsvforimport()" found in the Log Reader plug-in.

Terms & ConditionsAccessibility statement