Automatic conversion of CSV, XLSX, JSON files into one Excel file for use in software Shewhart control charts PRO-Analyst +AI

The function of automated conversion of CSV, XLSX, JSON files from a user-selected folder allows you to convert all the data in them into one file Excel (*.xlsx) into the form used in our software.

This function is included in the list of parameters saved in the chart properties when saved in the list for automatic chart updates with a selected timeout or to quickly open them with updated data.

In response to requests from users of our software, we fill out a list of available converters for data files exported, for example, from:

• coordinate measuring machines, CMM (English, coordinate measuring machine, CMM);
• measuring instruments;
• databases;
• your reporting forms in the form of Excel tables;
• and other sources.

Data converters developed by your Python programmers can be built into our software. Upon separate request, we will send a list of Python libraries that can be used in the development of converters.

Figure 1. Main window of the program. A pop-up tooltip appears when you hover your mouse over the button to go to the panel by converting CSV, JSON files to an Excel file (*.xlsx) used in our software.

Figure 2. File conversion control panel window. After clicking the [Select folder] button, a system window for selecting a folder with files for conversion opens. On the right is the contents of the selected folder, representing 44 CSV files to be converted.

Figure 3. File conversion control panel window. In the [Selected folder] field, the path to the folder selected in the previous step is indicated, and the corresponding converter is selected in the [Select converter] drop-down list. A pop-up tooltip appears when you hover the mouse over the [Convert] button.

Figure 4. Data source (44 CSV files) and the result of the selected converter.

Figure 5. File conversion control panel window. Once all CSV files in the selected folder have been successfully converted, an information window appears. If the answer is positive, the [Import data from table files] window automatically opens.

Figure 6. Control panel window selecting data from a table file for plotting Shewhart control chart, histogram and scatter plot. Automatically, upon successful conversion of CSV files in the previous step, all fields of this control panel are filled in. The user only has to click on one button [Update graphs].

Figure 7. The result of constructing a Shewhart control chart for individual values ​​and moving ranges based on converted data.

To prevent envelopes that you do not use from appearing in the drop-down list of the [Select a converter:] field, change the extension of such converter files located in the [converters] folder of our software from (*.pyx) to any other, for example, to (*.txt).