Listed below is an example SQL script that would be generated by the RazorSQL MS SQL Server to MySQL
Generate an SQL insert statement for each row in the MS SQL Server table that can be executed Table statement for the MS SQL Server table. Inside the Database Conversion menu there are options for converting one table orĪfter clicking the convert button, RazorSQL will generate a MySQL specific create RazorSQL includes a database conversion tool that can convert one or many MS SQL Server tables to MySQL.Īccessed via the following menu option in RazorSQL: Or whether to generate an SQL script file with theĭDL and SQL insert statements for the conversion. Once the 4 tables are populated, start the REST service - RestService.Information needed on the screen includes the existing MS SQL Server table to convert, the name ofĪnd whether to execute the conversion directly on a MySQL database connection The table wo_parts should contain the historical data associating the WOs & the Parts consumed. The table parts_master should contain the Parts Master data. Since MasterList.csv contains vectors, good import tools like Navicat or RazorSQL are required to perform the import. Note that the column DuplicateSymptomsList in MasterList.csv, does not reside in the database. Import MasterList.csv & WOsAndSymptoms.csv into the tables master_symptoms & wo_symptom_cooccurence, respectively. WOsAndSymptoms.csv contains WO-Symptom co-occurrences and does not need to be edited. For a Symptom_text like "Radiator leaking", the question can be something like "Is the Radiator leaking ?". The column symptom_question should be edited to hold the question asked by the Call Center Agent during the Triage. Feel free to replace any value here with a semantically similar value from the column DuplicateSymptomsList.
Since this shows up on the UI, they should look good. This contains the Symptoms that are shown in the UI. MasterList.csv contains the Master list of Symptoms that can go wrong with the machine. Or use the sample file.īy default, the outputs, MasterList.csv & WOsAndSymptoms.csv, are written to the folder /SampleOutput.Įdit InvokePipeline.py to point to the file containing the historical data. Get some historical data containing Work Orders & Problem Descriptions, for a specific machine, in the format shown in SampleInput/IntegrationTest.csv. Usage Going from unstructured historical data to structured categorical data Install the Anaconda Environment via AnacondaEnvironment.ymlĬreate a MySQL DB Schema - as per DDL/DDL.sqlĬhange the database connection properties in SQLHelper.py
0 kommentar(er)
