Importing data (CSV files)

Classic Servoy
1

Hi All

When importing data and having errors, there is no way to abort the import at all, because the import error dialog has only an OK and Detail >> buttons. So the only chance I have is to Force Quit Servoy - not really an elegant way!
I would like to propose at Cancel button in the import error dialog to abort the whole import process. Has anyone done that already?

I also would like to have it as selection if servoy adds (automatically) a sequence to a primary key column or no not - now it does but as I have to import data I have to unset that behaviour on importing (sometimes forgetting it and the rule #1 applies > see paragraph above and I get errors .-(

How do others handle imports.

Best regards, Robert

PS: I noticed that importing 100’000 records into a table with a dozen columns takes many hours (on 2 GHZ G5 Dual Mac). Is there a way to speed things up?

2

Hi Robert,

It seems that our data plugin is faster than Servoy import. Have a look here :Servoy Components – Plugins, Beans, Web Components, Angular Services & Servoy Developer Consulting.

You now need to script the whole thing though. Having that said we have started developing a Servoy-like import dialog and will integrate optional streaming as well. With streaming added, stopping an import will not be much of an issue anymore.

Cheers,

3

Hi Marcel

Thanks for your info!

Best regards, Robert

IT2Be:
Hi Robert,

It seems that our data plugin is faster than Servoy import. Have a look here :Servoy Components – Plugins, Beans, Web Components, Angular Services & Servoy Developer Consulting.

You now need to script the whole thing though. Having that said we have started developing a Servoy-like import dialog and will integrate optional streaming as well. With streaming added, stopping an import will not be much of an issue anymore.

Cheers,