Instructions for exporting data using MCHP Export.accdb: Difference between revisions
Ttenbergen (talk | contribs) m →sending |
Ttenbergen (talk | contribs) |
||
| Line 8: | Line 8: | ||
=== generating the export file === | === generating the export file === | ||
* open [[MCHP Export.accdb]] | * open [[MCHP Export.accdb]] | ||
* edit the VBA code to '''set the date range''' | * change extract dates if needed; actually, we don't generally change the dates, we always send 2019-01-01 to current | ||
** in the program, click the "Database Tools" button bar tab a the top, then the "Visual Basic" button | ** edit the VBA code to '''set the date range''' | ||
** edit the start_threshold and end_threshold variables | *** 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) | * accommodate any data structure changes that might have occurred since the last export (or confirm there are no such changes) | ||
** e.g. are there any new tmp projects that should be included? | ** e.g. are there any new tmp projects that should be included? | ||