Easy to Create, Easy to Change - Easy to use!


Automatic import of data


Started by George Washington
Search
You will need to Sign In to be able to add or comment on the forum!

Automatic import of data

HI there,

I am struggling with a data import problem. I have those data in another system that has to be imported regularly, let's say every hour, into DataEase. I scheduled  an appropriate task in our windows server that launch dataease: dataease when launched runs the proper procedure for importing data. The procedure uses a .dbi file. I tried two different solution:

a. The procedure use DataImport: this makes the application crash, also if I run it in a "live" session on my computer;

b. The procedure use Import: this works as long as I run it in my own computer: if I try to launch it on the server through the task scheduler it works like that:

1. DataEase is launched by the scheduler and runs the procedure (I can see that because I write a log file);

2. When the procedure arrives to the Import instruction it stucks;

3. At that point if I log into the server and look for the running processes, I see there is one dataease running;

4. I kill it;

5. After killed it, DataEase starts running (sic!): DataEase starts run continuously copies of itself and I have to kill all of them.

Is there a solution for this?

Thanks

Written by George Washington 27/04/16 at 06:39:52 Dataease [{8}]FIVE

Re:Automatic import of data

At the end of the day I found easier to create a custom function that reads the input txt file and then create / update the records; it is just few lines and gives me more control over the import e.g. create a log file and check consistencies of imported data.

Written by George Washington 03/05/16 at 09:33:51 Dataease [{8}]FIVE