Load CSV file in neoTable

#1 · January 28, 2020, 1:10 pm

Hi to all:-)

Is it possible to load and Show CSV file using neoTable ?

And if is, how ?

Cheers!

#2 · January 28, 2020, 9:38 pm

Yes, but you must parse the CSV data into a JSON object. It's not that hard. You can do it using NeoScript or a JavaScript subroutine (here is a sample code). I can code a whole sample for you and the whole community but need some time as I'm really busy.

CDY@44 has reacted to this post.

#3 · January 28, 2020, 10:20 pm

Hi @dglojnar,

Take a look to this link.

https://visualneo.com/forum/topic/neotablecsv

Vadim has reacted to this post.

#4 · January 29, 2020, 12:24 am

Hi !

@luishp

This will be very nice of you, just take your time :-)

@asmat

Thanks for link and video, now things are more clearly:-)

asmat has reacted to this post.

#5 · January 29, 2020, 9:26 am

@dglojnar, please take a look at the attached sample App.
CSV data is in a Container but you can also download it from an external resource.
Regards.

Uploaded files:

You need to login to have access to uploads.

Vadim has reacted to this post.

#6 · January 29, 2020, 10:01 am

@luishp

Thank you very, very much:-)

Just small question - how can I handle a external CSV file ?

I'm not too good with Java/JavaScript....sorry:\

Cheers!

#7 · January 29, 2020, 11:13 am

@dglojmar, see attached file.

Note that you must use neoPhpServer in order to test it and avoid CORS:
1) Unzip and open the sample App in VisualNEO Web
2) Project > Compile/Publish
3) Tools > NeoPhpServer (uncheck "Copy config.php..")
4) Click "Start" to start the sever.
5) Open Chrome or FireFox and navigate to "localhost"

You don't need ant JavaScript knowledge, just use the included subroutine to convert any CSV in JSON.

Regards.

Uploaded files:

You need to login to have access to uploads.

Vadim has reacted to this post.

Load CSV file in neoTable - Forum

Load CSV file in neoTable