When importing data in DBase31 from CSV file,
following specific format is mandatory:
-separator is ";" (not configurable for now).
-the 2 first lines are used to describe the [Fields]:
1)the first line contains Field names. [Field] name must be unique.
2)the second line contains Field types.
Supported types are: text, textarea, date, image
."text" is free text (this is the default type).
."area" is free text, and will be displayed in a textarea.
."date" must match format YYYY-MM-DD (ex: 2011-04-19)
."image" contains the image file name.
The file must be jpg, or png.
The file must be present in a specific directory, next to the imported CSV file. This "images" directory must be suffixed with "_data".
ex: For a CSV file named "data01.csv"
The image field value may be: "image01.png"
With a file relative path: "data01_data/image01.png"
So the global file structure would be:
You can import data to a "new" [Library],
or you can merge data [Items] to an existing [Library]!
The first [Field] in the CSV file is used to identify [Items].
When "merge data" is turned on, if a matching [Item] is found
in the selected [Library]:
new [Fields] will be created in the [Library],
while existing [Fields] will be updated (including empty values).