i read some instruction of Thierry Schmitz using timestamp. i am very much interested on this.
please provide me any example of this.
i am posting the process also.
I prefer the following solution, working on request from the user :
1) the main excel sheet shows Timestamp of both Available DB from I5 and timestamp of implemented data from i5, int the following form :
Check new Update Available DB dated : 2008-02-06 13:44 Finished
Update Data Implemented DB dated : 2008-02-06 13:44
“Check New update” and “Update data” are action buttons inside excel.
“Check New update” data use a MS Query inside excel to control that :
1) I5 process is not running (if yes, update is not allowed and a pop-up message notify user to wait a bit)
2) TimeStamp of available DB is more recent than implemented one. If yes, update Timstamp of available data inside excel and visualy shows that with color.
Update data run the following process(es).
1) Clear actual data inside Excel
2) Remove Autofilters
3) Import new data
4) Synchronize Available and imported Timstamp
5) optional treament… like Pivot table regenaration…
If you put the full name of the 2 required MS Query variable inside one sheet of your excel file, you may reuse this excel file to import and make some basic B.O. application very quick.
On i5 job (assuming the data to be used in excel is generated in a batch process), the requirements are :
1)When Batch job start, flag the application with ACTIVE STATUS using Timestamp control file (will lock excel import for a while)
2) Let your update run
3) When batch stops, update the TImestamp control file and release status.
If somebody has some interest using this technique, send me a private message and i”ll prepare a example of both I5 and Excel side.
Prerequesites are ODBC link available on the machine running the excel import.
April 17, 2008 6:32 AM
April 18, 2008 7:18 AM