CRIBMASTER ADVANTAGE DATA IMPORT 1 Crib Master Advantage
CRIBMASTER™ ADVANTAGE DATA IMPORT 1
Crib. Master Advantage Support Options www. cribmaster. com/vending ftp. ecribmaster. com/pub Videos - ftp. ecribmaster. com/pub/documentation/videos/ TECHNICAL SUPPORT 1 -855 -CRIB-CMS 1 -855 -274 -2267 CRIBMASTER SUPPORTAL – support@cribmaster. com 2
DATA IMPORT In order for Crib. Master Advantage to function, four groups of data are required. 1. Supplier/Vendor Data – Usually entered manually, not imported 2. Employee Data – Imported 3. Item Inventory Data – Imported 4. Crib/Bin Data – Imported Pro. Stock Toolbox Weigh Station 3
DATA IMPORT – CONCEPTS Ø All imports are processed within Crib. Master 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 Crib. Master Admin how to import the CSV data. Template RUL file are located in C: Program FilesCribmaster9. XDataImports 4
DATA IMPORT – SUPPLIER(S) Usually entered Manually - Click HOME; Click SUPPLIER; Click the “Plus Sign” to add a Supplier 5
DATA IMPORT – EMPLOYEES Note that a prefix has been added to the Employee Number. Template RUL files are located in C: Program FilesCribmaster9. XDataImports 6
DATA IMPORT – ITEMS Template RUL files are located in C: Program FilesCribmaster9. XDataImports 7
DATA IMPORT – CRIB/BINS Bin Naming – You must use these formats when importing bin data. Weigh Station Crib-Place. Holder-Scale Board-Scale Ex: 99 -01 -S 0001 -1 Tool. Box Crib-Shelve-Bin 20 -02 -03 Pro. Stock Crib-Drawer-Bin 25 -128 -05 Template RUL files are located in C: Program FilesCribmaster9. XDataImports 8
DATA IMPORT – CRIB/BINS Tool. Box Bin Import 9
DATA IMPORT – CRIB/BINS Weigh Station Bin Import 10
DATA IMPORT – CRIB/BINS Pro. Stock Bin Import 12
DATA IMPORT – CRIB/BINS Pro. Stock Bin Import – Sorted by Item 13
Crib. Master Pro. Stock Bin Utility DATA IMPORT – CRIB/BINS 14
Crib. Master Pro. Stock Manager DATA IMPORT – CRIB/BINS 15
Crib. Master Pro. Stock Manager DATA IMPORT – CRIB/BINS 16
BEST PRACTICES 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. 17
DATA IMPORT – CRIB/BINS Lets do some Imports 18
- Slides: 17