You can now easily automatically import data in RepZio using the same data templates you use to import data into the JuniperData or WebManager using our DataSynq Agent.
Simply install the DataSynq Agent attached to this article below and place your files into the watched folders it has created.
The Default Install Location if you leave the path empty when installing will be C:\DataSynq on a windows machine.
You must open the computer's Services. Find the DataSynq Agent. Highlight it and Start the service.
Once you have done that, the folder structure will appear.
The folder structure will be as follows created under your C:\DataSynq folder:
Drop your images into this folder and they will get processed automatically. Please note that the product MUST exist in our system before we can process an image. The images will be deleted as they are processed.
Drop your data files into this folder and they will get processed automatically. They must follow out naming conventions to get processed properly.
Please note the system WILL NOT IMPORT your files if they are named differently than the requirements outlined below.
Please refer to the import templates for the correct field structure and note that column names need to match the template column names.
Once a data file has been processed by the DataSynq system you will receive an email notification of the import results and the file will be moved to the "Processed" sub-folder in the imports folder.
File naming conventions
Excel Filename: *_import_products.xls
Tab Delimited Filename: *_import_products.txt
Excel Filename: *_import_customers.xls
Tab Delimited Filename: *_import_customers.txt
Excel Filename: *_import_inventory.xls
Tab Delimited Filename: *_import_inventory.txt
Excel Filename: *_import_shiptos.xls
Tab Delimited Filename: *_import_shiptos.txt
- Child Products
Excel Filename: *_import_child_products.xls
Tab Delimited Filename: *_import_child_products.txt
- Related Products
Excel Filename: *_import_related_products.xls
Tab Delimited Filename: *_import_related_products.txt
- Product Categories
Excel Filename: *_import_productcategories.xls
Tab Delimited Filename: *_import_productcategories.txt
- Volume Pricing
Excel Filename: *_import_volume_pricing.xls
Tab Delimited Filename: *_import_volume_pricing.txt
- Customer Special Pricing
Excel Filename: *_import_customer_special_pricing.xls
Tab Delimited Filename: *_import_customer_special_pricing.txt
Excel Filename: *_import_tags.xls
Tab Delimited Filename: *_import_tags.txt
- Customer Update/Merge
Excel Filename: *_import_customer_merge.xls
Tab Delimited Filename: *_import_customer_merge.txt
- Product Remote Image Data Processor
Excel Filename: *_import_images.xls
Tab Delimited Filename: *_import_images.txt
- Automatically Push Data Live
Text File Name:run_golive.txt
NOTE: If this file is not present your data will need to be pushed live manually from the web manager. This file does not need to have any content, it is simply a .txt file that has to be named run_golive.txt AND be placed in the DataSynq folders AFTER any files you are importing data.