Instructions for exporting data using MCHP Export.accdb: Difference between revisions

Line 8: Line 8:
=== generating the export file ===
=== generating the export file ===
* open [[MCHP Export.accdb]]
* open [[MCHP Export.accdb]]
* edit the code to '''set the date range''' and accommodate any data structure changes that might have occurred since the last export
* edit the code to '''set the date range'''  
** in the program, click the "Database Tools" button bar tab a the top, then the "Visual Basic" button
** edit the start_threshold and end_threshold variables
* accommodate any data structure changes that might have occurred since the last export (or confirm there are no such changes)
** one thing to consider each time would be whether any new tmp projects should be included
** one thing to consider just the next time is to comment out the old code that exports the pre-idc10 dx/px structure, and the old tasks.
* Click the "Run MCHP Export" button
* Click the "Run MCHP Export" button
* '''delete the modules and forms, they contain [[:Category:Password | Passwords]]'''
* '''delete the modules and forms, they contain [[:Category:Password | Passwords]]'''