Matics has developed a powerful tool that allows customers to seamlessly upload files and synchronize them with various data types, including jobs, products, materials, product recipes, and more. The tool supports bulk uploads, enabling users to efficiently import and synchronize multiple items from a single file, streamlining the process and enhancing productivity.
However, there are instances where file uploads do not process successfully, resulting in synchronization failures and the appearance of exceptions.
Troubleshooting Workflow
File Format Validation
Ensure the file you are attempting to upload is in CSV format.
Check Exceptions
Click on the status labeled "Failed" to open a window displaying the relevant exception details.
Review the following information:
a new window will be open with the exception:
🔑 Common Exceptions & Resolutions
Product Doesn’t Exist (e.g.,
'9887727'
)Issue: The product you are trying to sync does not exist in the Matics system.
Solution: Upload the product to the system first. Only after the product exists can you proceed to update the job.
Failed to Change Job Status (e.g.,
Fail to change job 1003329 status to 3
)Issue: The machine or mold name does not match the parameters (e.g.,
Machine ERP
/Mold ERP
).Solution: Ensure that the names of the machine or mold match exactly with the parameters listed in the system.
Missing Mandatory Fields
Issue: Required fields are missing from the manual file you are trying to upload.
Solution: Verify that all mandatory fields are present and correctly formatted in the file.
Data Mapping Errors
Issue: The data mapping is incorrect or does not match the item being uploaded.
Solution: Ensure the data mapping matches the structure of the file being uploaded.
The Manual Sync Tab includes a tool called "Data Mapping". You can use this tool in two ways:
Option 1: Manual Mapping
Copy parameter names from the tool and paste them into your sync file according to the required format.
Option 2: Automatic Mapping Verification, by upload a fil via the tool.
Upload your file via the Data Mapping Tool.
The tool will highlight any mapping issues, in addition need to compare the fields are maching:
After resolving the issues, click "Sync" to complete the synchronization process.
💡 Important Notes
make sure you choose the correct table name
if you don't see the Mapping Data option please ask from your Matics champion responsible for user management in your organization to add this to your user.
Certain special characters can cause issues during file uploading. To prevent errors, avoid using the following characters in your file names or data fields:
!
,@
,#
,$
,%
,^
,&
,*
,+
,=
For a smoother upload process, use alphanumeric characters, underscores (_), or hyphens (-) instead.