Creating a connection to a file
To create a connection to a file:
Warning
If you use a new DataLens object model with workbooks and collections:
- Go to the DataLens home page
. In the left-hand panel, select Collections and workbooks. - Open the workbook, click Create in the top-right corner, and select the appropriate object.
Follow the guide from step 3.
-
Go to the connections page
. -
Click Create connection.
-
Select Files as the connection type.
-
Click Upload files and select the file. The information about the added file and the uploaded data will be displayed in the central area of the screen.
Note
- Currently, you can upload CSV, TXT, and Excel (
xlsx
only) files. - The number of files per connection cannot exceed 10. Each Excel sheet is counted as a separate file.
- The size of each file may not exceed 100 MB.
- The maximum number of columns per file is 300.
- After you upload the file, the preview shows only the first 30 rows.
- Currently, you can upload CSV, TXT, and Excel (
-
Select the file upload parameters:
CSV or TXTExcel-
The information about the added file and the uploaded data will be displayed at the center of the screen. At the top of the screen, select:
- Encoding: Specify the file data encoding. You can use
utf-8
,utf-16
,windows-1251
, andutf-8-sig
. - Delimiter: Specify the delimiter that is used in the file. The available values are
Comma
,Semicolon
, andTabulation character
. - Column header: Select the title option. If you select Yes, DataLens will use the first row of data as a heading.
- Encoding: Specify the file data encoding. You can use
-
(Optional) Select the type of data for each column. To do this, click the icon to the left of the column.
- If the file being uploaded contains multiple sheets, specify the ones you want to upload in the Add sheets window. You cannot select empty sheets. Enable the Sheets option to select all available sheets. Each sheet is uploaded to a separate table.
- The information about the added file and the uploaded data will be displayed at the center of the screen. At the top of the screen, select the Column header option. If you select Yes, DataLens will use the first row of data as heading.
-
-
Repeat steps 4 and 5 to add files.
-
Click Create connection.
-
Enter a connection name and click Create. The connection will appear in the list.
You can add, rename, and delete files in the connection.