Cycle Data Import
Using the CSV file to upload cycle data into FactoryWiz.
You can upload cycle time and other information into FactoryWiz through the Configuration > Cycle Times option. If you have an ERP system where you track Job/Work Order data, you may
be able to export Job information from your ERP system and import it
into FactoryWiz. The data will be imported into the RefTimeData table where it will become available to various functions within the FactoryWiz system.
The following links will help you with using a CSV import file.
Preparing your CSV file for uploading into FactoryWiz.
Populating the CSV file and how to configure FactoryWiz to set the Reference Run Times from your CSV file.
How the operators can access information from the CSV file.
The following link explains the field names for each table within the FactoryWiz monitoring database.
Related Articles
10.5 Creating CycleTime Data Import File
Start by creating a CSV or spreadsheet file that contains the information you wish to import. This is usually done by exporting the from your source system (such as an ERP). Make sure that the first row of this file contains the Names or the Data ...8.2 Configuration - Cycle Times
You can upload cycle time and other information into FactoryWiz through the Configuration > Cycle Times option. When a machine registers a new part name (or job / op number, depending on how you have configured the machine), FactoryWiz will look in ...10.4 Data Dictionary
Overview of Database Tables FactoryWiz is an open system, meaning we give users full access to all data for the purpose of writing custom applications and reporting solutions, as well as integrating with other business applications such as ERP ...7.2 Data Entry - History
Under the History view, you can see previous cycles and information associated with each cycle, including each status change recorded in that cycle. By using the date picker at the top, you can filter your results by date. The History view is split ...7.3 Data Entry - Quality
The Quality tab of the Data Entry screen allows you to reject multiple parts historically. You must filter parts by Date and Part ID. Once a date has been selected, the Part Id will be populated with the Part IDs produced by the selected Machine on ...