CSV data source
The CSV data source allows you to upload a comma-separated value (CSV) file of information. For each row listed in the file, a shadow asset is created, which can be in such assets as an asset listing.
Once you have created your CSV data source, you can configure the asset on its associated screens. Many of these screens are similar to a standard page. They are described in the Asset screens documentation.
Read the DB data source documentation for more information on the record filter and dynamic inputs screens. This documentation will only describe the Details screen, which is different for a CSV data source.
The Details screen for a CSV data source allows you to upload the CSV file and create shadow assets in your system. For more information about the Status, Future status, and Thumbnail sections of the Details screen, refer to the Asset screens documentation.
This section allows you to change the details for the CSV data source. The fields available are as follows:
By default, the name entered when the CSV data source was created will appear in this field. You can change the name by clicking into this field and entering the new name of the CSV data source.
- Use first row as attribute names?
Select whether to use the first row of the CSV file as field names for the shadow assets. If you select no in this field, the CSV file will be imported into one shadow asset instead of one shadow asset per row.
- Use first column as row identifier?
Select whether to use the first column of the CSV file as the identifier for the rows below.
Upload new CSV file
This section allows you to upload the CSV file you want to use to create shadow assets.
In the CSV upload field, select the file you want to upload and select Save. The shadow assets will be created under the CSV data source in the asset tree. Read the Shadow assets documentation for more information.
Selecting the Compare format for uploaded CSV to existing contacts field will allow Matrix to check the content of the CSV file being uploaded to ensure that it is consistent with the format of the current CSV file. If the system finds that the format is different, the upload process will be aborted, and the previous CSV data will be restored.
Shadow asset name
Once you have uploaded a CSV file in the CSV upload field, the shadow asset name section will appear on the Details screen.
This section allows you to specify the name of the shadow assets as well as providing a list of keyword replacements that can be used for the shadow assets.
The fields available are as follows:
- Enter the shadow assets' name
This field allows you to specify the name of the shadow assets. It can be either a standard string or a combination of strings and keyword replacements.
- Available keywords for the data source record set asset
This section provides a list of available keyword replacements for the shadow assets. You can use any combination of these keyword replacements and string as the name of the shadow assets.
Steps to creating a CSV data source
To create a CSV data source:
Create a CSV file with the data that you want to import into your system. The first row of the CSV file will be used as the name of the fields for the shadow assets. An example CSV file is shown below.
FirstName, LastName, StreetName, Suburb, State, Postcode John,Doe,120 jefferson st.,Riverside,NSW,2000 Jack,McGinnis,220 hobo Av.,Phila,QLD,4569 Pam,Smith,120 Jefferson St.,Riverside,VIC,3256
Create a CSV data source in your system.
Select the CSV file in the CSV upload field of the Details screen.
The shadow assets will be created under the CSV data source in the asset tree.