Auto-detect file format

By default, Acho auto-detects the column delimiter and the data types (schema). If you data looks good, simply click the Upload button to start the process.

Configure a CSV file manually

In case your CSV file does not have a row that contains column names, or it has unsupported values (e.g. special characters, and reserve words), you can configure your CSV file's header manually. By unchecking the Auto-detect button, you can:

  1. select a delimiter: Acho Studio detects the column delimiter automatically. We support comma, semicolon, tab, and pipe. Please let us know if you need extra file type supported.

  2. add a header row: If your file does not have column names, you can check this box to enter your custom column names.

  3. Columns (name and data type): Change your column name, refine your column data types, and remove unwanted columns.

Safe mode upload

Safe mode is a feature built to ensure success of your CSV file upload. There is a number of reasons that could cause your upload to fail:

  • Use of invalid character like (-) hythen, ()parentheses (.)period, colon(;), Asterisks (*) and other characters

  • Line breaks in the column fields

  • Separator characters in the text of the CSV files

  • Long numbers that have leading zeroes

  • CSV file not using UTS

  • Non-printable ASCII control characters like CR or LF at the end of the line

  • Blank lines at the end of the corrupted CSV files

  • Duplicate column (data field) names

  • Text field with unescaped delimiter

  • Quoted string with an unescaped double quote

  • CRLF/Dos line endings

  • Non-standard escape characters

  • Unrecognized Unicode/Illegal Codepoint

When Safe mode is checked, Acho Studio's system will handle all these error cases and make sure your data can be parsed by a relational database management system (RDBMS). Within safe mode, Acho needs to change all your column data types to string, thus your CSV upload become more likely to be successful.

Troubleshooting
  1. Columns exceed 10,000

    When you have a file that has more than 10,000 columns, you may need to transpose or partition your file. Simple talk to the customer support and grant us temporary permission to access your file, and we should help you upload the data to Acho.

  2. The upload progress freezes at 60%

    This might be due to a variety of reasons. 1. Check your internet to make sure there's no breakage during the upload period. 2. Some values in the latter portion of file may be corrupt. Try re-upload the file with "safe upload".

  3. The file cannot be parsed

    If your file cannot even prompt the preview process, it may be mis-formatted. Contact us and we can help you examine its formatting and make sure it's fit for online processing.

When your CSV file looks good, simple click the Upload button to start the process.

For more info, please visit Connect to .CSV