Message Boards Message Boards

Back

Importing table/list data from csv

Importing table/list data from csv
Answer
3/7/21 11:33 PM
I am looking for some information on working with csv tables and lists. I've tried the documentaion wasn't able to find to much. Basically I am looking to import data from an external csv into a table. Thanks.
0 (0 Votes)

RE: Importing table/list data from csv
Answer
3/8/21 1:06 AM as a reply to Ry Landry.
Hello Ry,
Can you tell us a little more about your needs?

A. Are you trying to bring in static data (that happens to be in csv format) so that you can populate a table for display purposes?
B. Do you have a CSV file that lives somewhere (internet, desktop) that needs to be loaded in by the lesson on the fly, and push that into a table?
C. Or something in between?

Let us know a little more about what you've got to work with, and we can provide more guidance. We might eventually need to take this conversation off the forum, and have you send us a copy of what you're starting with. We can return to the forum to post the method that works once we have a good solution (for anyone else trying to do the same thing).

- Nav
0 (0 Votes)

RE: Importing table/list data from csv
Answer
3/9/21 12:04 AM as a reply to Navdeep Dhillon.
Hey Nav,

Thanks for respinding. I am look to do something like B. Basically populate tables or lists from a csv file that lives in the same root folder as the index file. This way the content could be quickly updated without touching the moudle itself. The csv file will contain part numbers and prices as an example.

At this point I am starting from scratch and totally open to ideas or suggestions. Thanks!
0 (0 Votes)

RE: Importing table/list data from csv
Answer
3/13/21 1:44 AM as a reply to Ry Landry.
Hello Ry,
Here's how you can do that!

video: https://share.smartbuilder.com/public/support/load_csv.mp4

source files: https://share.smartbuilder.com/public/support/load_csv.zip

sample lesson online - https://share.smartbuilder.com/public/support/load_csv/index.htm (you don't have access to our server to overwrite the csv file, but I can change it as much as I want)

Let us know if you have any questions!

- Nav
0 (0 Votes)

RE: Importing table/list data from csv
Answer
3/14/21 2:02 AM as a reply to Ry Landry.
Fantastic! Just what I was looking for,
0 (0 Votes)