1 / 17

CribMaster™ Advantage Data Import

CribMaster™ Advantage Data Import.

curt
Download Presentation

CribMaster™ Advantage Data Import

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. CribMaster™ Advantage Data Import

  2. CribMaster Advantage Support Optionswww.cribmaster.com/vendingftp.ecribmaster.com/pubVideos - ftp.ecribmaster.com/pub/documentation/videos/Technical Support 1-855-CRIB-CMS 1-855-274-2267CribMaster Support portal – support@cribmaster.com

  3. Data Import • 1. Supplier/Vendor Data – Usually entered manually, • not imported • 2. Employee Data – Imported • 3. Item Inventory Data – Imported • 4. Crib/Bin Data – Imported • ProStock • Toolbox • Weigh Station In order for CribMaster Advantage to function, four groups of data are required.

  4. Data Import – Concepts Template RUL file are located in C:\Program Files\Cribmaster\9.X\Data\Imports All imports are processed within CribMaster Client/Admin. (Click SYSTEM; Click DB UTILITIES; Click IMPORT) Data files for importing can start as Excel files but they must be converted to CSV (Comma Separated Values) files before importing. Certain import fields/columns are required. (Yellow) RUL files are used to tell CribMaster Admin how to import the CSV data.

  5. Data Import – Supplier(s) Usually entered Manually - Click HOME; Click SUPPLIER; Click the “Plus Sign” to add a Supplier

  6. Data Import – Employees Note that a prefix has been added to the Employee Number. Template RUL files are located in C:\Program Files\Cribmaster\9.X\Data\Imports

  7. Data Import – Items Template RUL files are located in C:\Program Files\Cribmaster\9.X\Data\Imports

  8. Bin Naming – You must use these formats when importing bin data. Data Import – Crib/Bins Weigh Station Crib-PlaceHolder-Scale Board-Scale Ex: 99-01-S0001-1 ToolBox Crib-Shelve-Bin 20-02-03 ProStock Crib-Drawer-Bin 25-128-05 Template RUL files are located in C:\Program Files\Cribmaster\9.X\Data\Imports

  9. ToolBox Bin Import Data Import – Crib/Bins

  10. Weigh Station Bin Import Data Import – Crib/Bins

  11. ProStockBin Import Data Import – Crib/Bins

  12. ProStock Bin Import – Sorted by Item Data Import – Crib/Bins

  13. CribMaster ProStock Bin Utility Data Import – Crib/Bins

  14. CribMaster ProStock Manager Data Import – Crib/Bins

  15. CribMaster ProStock Manager Data Import – Crib/Bins

  16. Stay Consistent Start your imports with the same template If the customer does not supply all data, you can not complete your imports. Avoid blanks, special characters. Save your RUL files You can not have duplicate Item Numbers or Employee IDs. Best Practices

  17. Data Import – Crib/Bins Lets do some Imports

More Related