10 Advanced Items
Power BI example with FactoryWiz data
Create a MySQL database user for by following these instructions https://kb.factorywiz.com/portal/en/kb/articles/create-readonly-user-for-large-screens Then create a System DNS on your computer by following these instructions ...
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 ...
10.3.3 Sample Excel Workbook using FactoryWiz data
Click this link to download an example Excel Workbook showcasing the types of views that are possible using ODBC Connector in Excel After you download the Excel, you should check to make sure it does not have "the mark of the web", meaning it may ...
10.3.2 Connecting Excel Desktop version to FactoryWiz
Before attempting to connect Excel to FactoryWiz database, you must install the ODBC connector. See ODBC Installation Open Excel and create a new Workbook Select DATA Tab and then select From Other Sources > From Data Connection Wizard Then select ...
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 ...
10.3.1 Connecting Excel with Office365 to FactoryWiz
Before attempting to connect Excel to FactoryWiz database, you must install the ODBC connector. See ODBC Installation 1. Open Excel and create a new Workbook 2. Select DATA Tab and then select Get Data > From Other Sources > From ODBC 3. Select ...
10.2 ODBC Installation
If you wish to connect a computer on your FactoryWiz network to the FactoryWiz database for things such as Microsoft Excel, you can use an ODBC connector. Normally we will install the 32bit MariaDB/MySQL ODBC Connector for things such as FactoryWizTV ...
10.1 DPRNT Command List
If you DPRNT information to a service for the Okuma, Hurco or Mazak (not to the FactoryWiz DNC Server), here are a list of the commands. DPRNT Command Purpose Example START Set machine status as running START FINISH Set machine as idle and increment ...