While using Riipen's import functionality, you will be dealing with comma separated value (CSV) files which have very specific requirements in terms of how they are formatted, what encodings are present, and other technical specifications. Make sure to consult the appropriate help article for the specific type of import you are trying to conduct in order to download the associated import template file which serves as a starting place for your import file.
General
File format
General file requirements for Riipen importing are as follows:
All headers must be present and unchanged from the provided template file.
Unless otherwise stated, all fields are case sensitive
File must be exported in a true .CSV format
File may not be another file type with a .CSV extension added to it
File must be exported in Unicode (UTF-8)
Encoding
Riipen only accept UTF-8 encodings for import files. If you don't use UTF-8 format in your import files, it can cause poorly translated import records or even complete import failures.
To ensure you are using UTF-8 you can follow one of these steps below:
Microsoft Excel
Select "File->Save as" from the menu.
In the "Save as type" dropdown, select "CSV UTF-8 (Comma delimited) (.csv)"
Select "Web Options" in the "Tools..." dropdown at the bottom of the dialog box.
Select the "Encoding" tab.
In the "Save this document as:" dropdown, select "US-ASCII"
Attributes
All attributes in imports will specific an attribute type you must adhere to. What follows is a table of all attribute types and their formatting requirements:
Type | Format |
Array[Type] |
|
Boolean |
|
Date |
|
Float |
|
String |
|