This guide explains common issues like 'invalid byte sequence in UTF-8' and errors related to missing quantities when uploading files via SFTP. Learn how to identify and fix encoding problems and troublesome white space to ensure your files upload successfully to Clarus WMS.
If you see an 'invalid byte sequence in UTF-8' error, your file may not be saved with the correct encoding. It should be saved as UTF-8.
White space is a common cause of SFTP upload failures and can lead to errors such as 'Quantity is missing: order_reference'. This includes extra spaces after information, spaces between commas, or accidental extra lines.
To inspect your file for white space, go to your file explorer, right-click on the import file, select Open with, and then choose Notepad.
In Notepad, you will see the import laid out in text form. The top line contains the various fields (e.g., receipt_reference, warehouse_code). Each line below provides the information from one cell, with a comma separating data for the next cell. Empty cells will appear as a single comma.
WARNING: Any spaces after information, spaces between commas, or extra lines (which appear as a bunch of empty commas at the bottom of the file) are considered white space. You must remove these to ensure your file uploads successfully.Removing these commas at the bottom and any spaces within the file will eliminate the white space and should allow the file to upload without issue.
This error usually means the file you are trying to upload is not saved using the correct encoding, which should be UTF-8.
White space refers to invisible characters like spaces or extra lines in your file. It can cause upload failures, even if the file looks correct visually. This includes spaces after data, between commas, or entirely empty lines at the end of the file.
Even though white space might not be visible, it can interfere with how the system processes the file, leading to errors. It's the most frequent reason for SFTP files failing to upload.
REMEMBER: Always double-check your file in a plain text editor like Notepad before uploading. Pay close attention to any extra spaces after commas or data, and ensure there are no unintended empty lines at the end of the file.