Dataset Sourced from Excel File Parses Text Values as Decimal
Issue
I've created a Dataset that loads data from an Excel file. The text data columns in the Dataset are parsed as decimal values. How to parse these columns as text values?
Note: The CSV column types cannot be parsed. The uploaded file must be of .xls/.xlsx type.
Resolution
1. Download the .jar File to the Linux Host
Please contact [email protected] to get the compatible version of the .jar file for your MI version.
2. Place the Downloaded File to dataprocessor:/app/lib
For instance, to move the .jar file from the /home/user_A directory on Linux host, execute: docker cp /home/user_A/mi-insightd-4.30.1-ENG-372.jar mi_dataprocessor_1:/app/lib/mi-insightd-4.30.1-ENG-372.jar
- Note that the
mi-insightd-4.30.1-ENG-372.jarfilename is stated twice in the command
3. Restart Dataprocessor
- For MI versions prior to 6.2.4:
- Exit container:
exit - Restart the container:
sudo docker restart <dataprocessor container ID> - Wait a few minutes for changes to apply
- Exit container:
- MI v6.2.4+: Restart the
dataprocessorservice by runningservice dataprocessor restartfrom thedataprocessorcontainer
4. Run INSERT IGNORE in MySQL Dashboard Database
- Exit the
dataprocessorcontainer:exit - Access the
webcontainer:docker exec -it <container ID> bash - Access MySQL dashboard database:
mysql dashboard - Run the following command:
INSERT IGNORE INTO dp_config (param_key, value, plugin_key) VALUES ('typeFromExcelCellFormat', 'true', 'external_file');
1. Run INSERT IGNORE in MySQL Dashboard Database
- Access the
webcontainer:docker exec -it <container ID> bash - Access MySQL
dashboarddatabase:mysql dashboard - Run the following command:
INSERT IGNORE INTO dp_config (param_key, value, plugin_key) VALUES ('typeFromExcelCellFormat', 'true', 'external_file');
0 Comments
Add your comment