Importing csv files

Classic Servoy
1

Hi all

in my solution i require 2 csv files (about 12000 records) to be imported to 2 different tables on a reasonably regularly basis approx (every 2 weeks) i want the user to be able to determine when they want to import these files but i want to prgrammatically handle these imports from then on. this solution was a conversion from FMP where this could be done quite easily.

Can anyone advise me the best way to handle this in servoy?

I’m aware it2be has an import plug-in for csv files, are there any other options?

2

Glad you are aware of our plugin :)

The alternative is that you write a method to do the job yourself.
You will have to take care about all ‘rules’ that csv has like how to deal with encapsulated enters, comma’s etc. but it is doable…

Why are you looking for an alternative?

Cheers,