Centralized import from Ed.mdb: Difference between revisions
Ttenbergen (talk | contribs) m Text replacement - "X:\" to "{{S:\MED\CCMED}}" |
Ttenbergen (talk | contribs) m Text replacement - "S:\MED\CCMED" to "S:\MED\MED_CCMED" |
||
| Line 9: | Line 9: | ||
* From output folder on Regional server: copy pharmacy.mdb into: mdbs_to_import | * From output folder on Regional server: copy pharmacy.mdb into: mdbs_to_import | ||
**Julie must provide a copy of latest TASKS.xls to put in mdbs_to_import folder (not the TASKS_1.mdb on server). | **Julie must provide a copy of latest TASKS.xls to put in mdbs_to_import folder (not the TASKS_1.mdb on server). | ||
* copy From '''{{S:\MED\ | * copy From '''{{S:\MED\MED_CCMED}}Pagasa\CCData\rawdata''': cc_rawdata and med_rawdata content | ||
* open centralized import from ed.mdb | * open centralized import from ed.mdb | ||
* open Modules, go to module "Import", run Public Sub Import(). | * open Modules, go to module "Import", run Public Sub Import(). | ||
* EXIT out when done (large X to right screen) | * EXIT out when done (large X to right screen) | ||
* Final Step:FROM the Ed import folder on your own desktop, copy centralized.mdb, PHI.mdb TO the centralized Front end practice folder on your desktop. | * Final Step:FROM the Ed import folder on your own desktop, copy centralized.mdb, PHI.mdb TO the centralized Front end practice folder on your desktop. | ||
*you can also copy from {{S:\MED\ | *you can also copy from {{S:\MED\MED_CCMED}}TISS28\Database\TISS28_data.mdb to the centralized Front end practice folder on your own desktop | ||
*when you open front end, there is a '''link table button''', press it to link in TISS28.accdb. | *when you open front end, there is a '''link table button''', press it to link in TISS28.accdb. | ||