This is a collection of Windows applications for extracting product data from various customer databases.
File paths for the exported data can be configured in app.config file or *app-name*.exe.config. The defaults are set to:
C:\mvExport- fordata-index.txtandimage-index.txt, but they can be confgured separately and reside anywhere elseC:\mvExport\remote\csv- output directory for CSV filesC:\mvExport\remote\images- output directory for images
csv and and images folders have to be separate because they need to be uploaded sequentially - images first, then the csv file. If the csv files comes first you may run into a problem of images being missing because they havn't been uploaded yet.
We use winscp for uploading files to the web server.
// delete all previous CSV and image files before exporting a new lot
del c:\mvExport\remote\csv\*.csv
del c:\mvExport\remote\images\*.jpg
// run the export
c:\mvExport\mVentorySqlExporter.exe
// sync the exported files with the remote server (website)
cd C:\winscp\
winscp.com /script=sync-script.txt /log=ftp-sync-log.txt
option batch continue
option confirm off
open ftp:https://login:[email protected]/
option transfer binary
synchronize remote "C:\mvExport\remote\images" "/mvexport/remote/images" -criteria=size
synchronize remote "C:\mvExport\remote\csv" "/mvexport/remote/csv" -criteria=size
close
exit
Make sure they do not run over each other - one must stop before a new one begins. The export task will be differential and should take seconds to run.
It will force the full data export and clear any possible inconsistencies accummulated during the day. It is a crude, but reliable way of keeping the website in sync with Kudos.
https://winscp.net/eng/docs/task_synchronize_full has more info on full directory sync and its parameters.