CVS and Excel File Imports and Exports
Data Setup Tools
The Excel File Integration includes three main features:
These features provide clients the opportunity to integrate with WithoutWire without the initial cost of custom integration to an ERP. Below, we detail each of the Excel File Integration’s features and how to get started using them.
Importing data using the Excel File Integration is meant to be easy and fast. We have exposed the following nine major categories for uploads:
Bill Of Materials Upload
Pick Requests & Returns Upload
Purchase Order Upload
For each of the import processes listed above, we have created an import template. The import templates are Excel files containing sample data that can be imported into WithoutWire. In the picture below you can see that we have color-coded the import templates by header (blue), required columns (green), and optional columns (grey). Placing the focus in line one of the templates will tell the user what information is needed in that column.
The data upload process in WithoutWire is both an insert and an update. When you need to update an already existing item, reference that item with its key and update the fields you need to update. Keep in mind not all fields can be updated, refer to each specific upload process for a list of which fields can be updated.
Finally, it is important to note the sheet in Excel where the data is written. The WithoutWire Excel Integration process only looks for data on the page labeled “Sheet 1.” Data on any other sheet in the Excel file will be ignored by WithoutWire.
Exporting Data in the WithoutWire Excel File Integration feature is a simple process. When you are ready to begin exporting, you’ll navigate to the Data Setup page under system maintenance. From there, you will find a section devoted to Export Transactions. This section includes a date range filter and four buttons:
Export Pick Records
Export PO Receipts
Export Inv. Transactions
Export Inventory Levels
Each of these buttons represents a specific export process. By using the date range filter, you can export specific records for the date range you specify.
The date range filter is pre-programmed with standard date ranges like “Yesterday”, “This Week”, “This Month”, and “This Quarter." You also can select a custom date range.
The only export process that does not use the date range filter is the Export Inventory Levels process. Export Inventory Levels will provide a real-time snapshot of your system's inventory, but it does not use the date range filter.
The Data Reset feature does not require an Excel file, but it does relate directly to Data Setup in WithoutWire. This feature is designed to give users a way to clear their system of inventory, purchase order, and order data when it’s appropriate. For example - when transitioning from testing to live.
Be careful with the data reset feature. We have given users a lot of power with this option, be sure this is what you want to do before you commit to reset your data. The decision to clear your data is permanent.