We are introducing some great enhancements to our dataimport feature, with some advanced capabilities. Not only can you import new data, you can also update existing data.
Access the data import setting
In this example I'm going to walk you through the import of companies and contacts data.
- From the administration dashboard click here to access the selected business modules settings
- Click here to access the Import Data function
Edit the import configuration
Before starting a data import, we need to configure the mapping between our data file and our business module columns.
- Click here to edit the mapping configuration
Add a mapping
We can now start creating the mapping, that will result in a successfull data import.
- Click here to add a mapping
Mapping CSV Fields with SharePoint fields
From this interface you add mappings between fields in the csv file and fields in the business module you are importing your data to.
- Here you enter the name of the cloumn containing the relevant field data in the csv file
- Here you select the relevent field from the business module, that you want to map to the csv data
CSV data source field names and values
Please make sure the csv file meets the following requirements before attempting an import. We also recommend to import a single line of data, to verify the import, before initialising a complete data import.
- The first row in the data source must contain the field names, separated with a semicolon (;)
- Each row of field values must be separated with a semicolon (;) and each field value must be surrounded by quotation marks
Example: "WorkPoint A/S";"Adgangsvejen 3";"6700";"Esbjerg";"+4576110110";"firstname.lastname@example.org"
- If a field value doesn't contain any data, the field value must not contain any quotation marks. Notice in the example below that the email address field value doesn't contain any data. The quotation marks normally surronding the email field value are removed.
Example: "WorkPoint A/S";"Adgangsvejen 3";"6700";"Esbjerg";"+4576110110";;
- If a field value should contain quotation marks as data, add a quotation mark before the quotation mark.
Example: "WorkPoint A/S";"Adgangsvejen 3";"6700";"Esbjerg";"+4576110110";""Qoute Marks Example""
Supported SharePoint Field Types
The table below shows what SharePoint Field Types are supported and how the field values must be formated in the csv import file.
CSV Data Source example
Company;Address;City;Zip;Phone;Email "Arcu Iaculis Enim PC";"P.O. Box 184, 3773 In Rd.";"Bremerhaven";"0257NR";"01 19 64 44 54";"sagittis.Nullam.email@example.com" "Phasellus Dapibus Inc.";"Ap 257-7776 Phasellus St. Calle";"Blancos";"55119";"09 67 65 89 15";"firstname.lastname@example.org" "Ante Blandit Foundation";"P.O. Box 258, 1017 In St.";"Bonn";"04284";"06 64 51 30 09";"Curae.Phasellus@acrisus.edu" "Felis Eget Institute";"P.O. Box 215, 3457 Quam, Street";"Mahbubnagar";"3602JQ";"08 24 73 31 12";"imperdiet.ullamcorper.Duis@anuncIn.ca" "Nulla Ante Iaculis Inc.";"620-3729 Dis Rd.";"Brussel";"8710";"03 06 12 18 43";"email@example.com"
CSV data source mapping example
- Here I have mapped the fields from my csv file, with fields in my business module
- This check mark indicates that this column in the csv file, holds the value that uniquely identifies the element. A primary key must always be choosen. The primary key is used when updating existing data.
- Click her to save the mapping configuration for the business module
Start importing data
After a succesfull configuration of the data mapping, we can start the data import. We strongly recommend only to import a subset of the data from the csv file, and verify that the data is vaild and that the imported elements look as expected, before commiting to a comlete import. There is no undo button, and if misconfigured data is imported, it must be removed manually.
- Click here to select the csv file from your computers filesystem
- Choose if you want to have a site created for the imported elements
- Click here to start the import
Monitoring the import
- After clicking start data import the following status window is displayed
Verify the data import
When the import has completed, you can click here to see details about the import and eventually correct errors in the data souce file.
The data import result
When we access our business module, the data from the csv file we have imported can be viewed. Because we use a primary key when importing data, we can make changes to the data we allready have imported, by running the import command again.
In this example I want to update the address of the company "Arcu laculis Enim PC" from my previous import.
CSV file example:
Company;Address;City;Zip;Phone;Email "Arcu Iaculis Enim PC";"Rundweg 4";"Bremen";"0257NR";"01 19 64 44 54";"sagittis.Nullam.firstname.lastname@example.org"
- I browse the filesystem for the csv file and start the import/update operation
- This time the status window indicates that this is an update task and not an import of new data, since there allready is a company in the business module, with a primary key that matches an element in our source csv file.
- When the update is completed our item is updated with the data from the csv file