Import From File – Example 3

This example is a bit harder, but nothing that CanDB can't handle! Some notes regarding the above:

1. There are two header rows, not one, and CanDB must look at both rows to map from column name to CanDB properties.

2. The Can column is actually a beer can's name plus a bit of text to describe the can. To map this into CanDB we want to split the Can column into CanDB properties of "Name" and "Short Text", delimiting the cell value based on the "-" (dash character, but only if the "-" is proceeded by a blank character). We must have "-" in the Possible Chars since we don't want names such as "Adler-brau" to be split into two values.

3. The spreadsheet has explicit columns of Location and State, but in CanDB this is a single property named "Location". We want to have CanDB consolidate these two column values into one string for CanDB storage. This is accomplished by an "=" character proceeding a list of column names.

4. Some cells have "n /a" as "Not applicable". CanDB treats cells with this value as if the value was empty.

To import this example the following Import From File configuration would be used: