Skip to main content
SupplyOn AG SupplyOn Support Center

SupplyOn Support Center Menu

  • SupplyOn Support Center
  • SupplyOn Help Pages
  • English
    English Deutsch Français Español Italiano Português 日本語 繁體中文
Login
  1. Home
  2. SupplyOn Support Center

Error in file formatting - Format setting

SupplyOn Portal - Invoice Upload via CSV or Excel

Error in file formatting - Format setting

The following errors may occur:

  • The CSV file has been edited in Excel and leading zeros have been lost. Excel, for example, turns numbers into a number format rather than a text format. Edit the CSV file as described (Link zu CSV in Excel öffnen, bzw ANSI etc).

The format setting for date, field separator, and decimal separator must match the country setting in the user profile.

Format_Fehler_01

User profile with country settings

Format_Fehler_02

A CSV file has been uploaded. An error occurs in the file structure. Continue with 'Close'. 

Format_Fehler_03

Remove the CSV file.

format_fehler_03-2

Check and correct the incorrect CSV file. Open the CSV file in a text editor. To analyze errors, check the following

  • the UTF-8 formatting,
  • the date format,
  • the field separators,
  • the decimal separator.
Format_Fehler_04

At the beginning, commas were used as field separators in this example. Since the country setting in the user profile is Germany, semicolons are expected.

Change the text file, save your changes and upload the corrected CSV file again.

Format_Fehler_05
Was this article helpful?
Why wasn't this article helpful?

To contact the Support-Team please click here

  • Getting started
    • Benefits of Uploading invoices
    • Technical and content requirements for CSV
    • Technical and content requirements for Excel
  • Invoice Creation with CSV
    • Editing CSV files with MS Excel
    • Step 2 - Create CSV export
    • Step 1 - Example invoice
    • Step 3 - Routing data
    • Step 4 - Generate the CSV file
    • Transmitting CSV invoices
  • Invoice Creation with Excel
  • Error handling for CSV
    • Content errors
    • Error in file formatting - Format setting
    • Error in the file structure
    • Errors detected by the customer
    • Invoice number has already been used
    • Order is not valid
    • Shipping notification was not created
    • Routing triple is faulty
  • Error handling for Excel
  • Archive rules

Footer EN

  • Contact
  • Imprint
  • Legal notes
  • Privacy policy
  • Security/Certificates

© SupplyOn AG