
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
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.