Instructions for exporting data using MCHP Export.accdb: Difference between revisions
Ttenbergen (talk | contribs) m →sending: cleaned up to only have current info in instructions, put the past process into legacy section in the bottom. |
Ttenbergen (talk | contribs) mNo edit summary |
||
| 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''' | * edit the VBA code to '''set the date range''' | ||
** in the program, click the "Database Tools" button bar tab a the top, then the "Visual Basic" button | ** 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 | ** 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? | ||
* 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]]''' | ||