automated import

Classic Servoy
1

Will it be possible (in the future) to do an automated import/export?
Like in Filemaker, where you can tell, how, when, which fields, which location etc.. are imported or exported (without a dialog)

and to do a import/exportstraight away from one to another table??

2

Maybe this is related to the issue, where the question has been asked, to do a print without the dialog!

Also here, for import and export, an option to do export or import without a dialog would be nice!

3

can this be done??

4

At this point in time it is not possible to import without a dialog. Keep in mind that in most three tier applications imports are performed on the server by processes rather than interactively by end users. We will add this feature as well as printing with no dialog to the requested features list.

It is also possible to automate the reading of files using readTXTfile

5

Hi Jan,
Do you know when automated import/export (predefined, like in Filemaker) will be implemented?

6

I know this is an old thread, but I need the functionality Harjo was requesting here, and would like to know if it is now possible.

Here is the situation:

Client A receives a bunch of CSV files with sales and product data from the Provider, according to a subscription agreement between them. Each one of these CSV files are based on a ‘template’ containing different columns and rows of data, and there are about thirty or so of these ‘templates’ in total offered by the Provider. If Client A wants some specific information and needs a new type of CSV file (containing additional sales info for reporting purposes, ie. sales by branch per quarter per product), a new CSV based on one of these ‘templates’ will be made available to them for upload. Client B may need a totally different set of CSV’s, and they only get the ones they subscribed to, and again these are based on specific Provider-supplied ‘templates’ - only the data changes in them, specific to this client.

My question is twofold:

  1. Is there any way we can let Servoy try to ‘guess’, upon import of these CSV’s, which is which, so that Servoy will ‘know’ exactly where and in what columns to import the data? In other words, if I create a record for each type of ‘template’, is there a way I could compare these records with the format of the ‘templates’ (maybe importing in a temporary table), so I could then ‘switch’ over to the right type of import and do the actual import?

  2. Is there a way to automate this whole process? I would (ideally) like the only user intervention to be the selection of the CSV to import.

Any guidance would be appreciated here.

Thanks,

Ben

7

Hi Ben,

I have said it before I know but this is going to be the near future of the Data plugin.

In fact it is half way done but needs finishing. I guess this will be available before Servoy World.

8

Great news Marcel! I’m available if you need a beta-tester… :wink:

Actually, I’m sort of waiting for such a functionality to make a proposal to one of my prospects.

Cheers,

Ben