Importing CSV-Files

<< Click to Display Table of Contents >>

Raynet One Data Hub > 14.0 > Administration and User Guide > Tasks > Naming Conventions > Naming Conventions for Tables Created by Importing Files into a Container 

Importing CSV-Files

When importing a single CSV file, the name of the table will be identical to the dataset name. The dataset name can have a maximum of 60 characters and is not allowed to contain the following special characters: . -, ", ', [, and ].

•Example: dbo.TaskDataSetname

 

If more than one CSV file is imported, multiple tables with a prefix and a suffix will be created. The prefix is always the dataset name of the task followed by a - (minus) and the suffix. The suffix is always the the filename of the CSV file.

•Example: dbo.TaskDataSetname-Filename

 

papercliper

Note:

It is possible for a user to change the prefix by changing the dataset name.

It is not possible for a user to change the suffix since this is determined by the file name.