PHI copy automation: Difference between revisions
Ttenbergen (talk | contribs) m interlinking |
Ttenbergen (talk | contribs) m Text replacement - "CCMDB.mdb" to "CCMDB.accdb" |
||
| Line 5: | Line 5: | ||
Every 60 minutes it runs the batch file [[Copy PHI.bat]]. | Every 60 minutes it runs the batch file [[Copy PHI.bat]]. | ||
It copies the PHI files exported by [[CCMDB. | It copies the PHI files exported by [[CCMDB.accdb]] during [[sending]] to {{Regionalserver|Output\_PHI}} to X:\CCMDB\PHI. Then it calls the script [[Load Data.vbs]]. | ||
The script [[Load Data.vbs]] accesses [[PHI Loader.accdb]] and runs the sub ''loadAllCSVFiles'', which calls the code that imports all csv files found within the directory. The csv loading code also moves the files again into an archive folder X:\CCMDB\PHI\PHI Archive\ to prevent duplicate processing. See [[Automatic updating of MS Access Databases using scheduled tasks]] for more info on how this works. | The script [[Load Data.vbs]] accesses [[PHI Loader.accdb]] and runs the sub ''loadAllCSVFiles'', which calls the code that imports all csv files found within the directory. The csv loading code also moves the files again into an archive folder X:\CCMDB\PHI\PHI Archive\ to prevent duplicate processing. See [[Automatic updating of MS Access Databases using scheduled tasks]] for more info on how this works. | ||