Step by step Upload Outlet into db Production - acan12/dbupload GitHub Wiki
-
Collect all new data outlets from 'data-entry-team' in excel format template , eg. id, slug, name, address1, ...etc.
-
move excel file from 'data-entry-team' into your own data entry storage eg. 'data_sources.xls'
-
Convert all data in excel format in ('data_sources.xls'/local file is up to you) into sql file
-
below are their instruction tools :
- -> pull first the tools into your local (git clone https://github.com/acan12/dbupload/)
- -> make sure your gem environment have dependencies gems (roo, spreadsheet, nokogiri)
- -> ruby update_uploader.rb // if you want to update field , modified the code 'https://github.com/acan12/dbupload/update_uploader.rb' to be able used
- -> ruby uploader.rb // if you want to add new data field , modified the code 'https://github.com/acan12/dbupload/uploader.rb' to be able used
- Check into sql file , if there still clean from strange chars or not
- dump all data production into local db, and running the script sql file into your local db.
- dump production db into abra_prod[yyyymmdd].sql // dump sql command production
- download abra_prod[yyyymmdd].sql // into your local file
- check again if there have failure data (pair with Data PIC if needed)
- after everything ok , you can upload directly to production db.
- just access to dbsite production