File Import

Data Suite supports importing data from the following file types:

New File Uploads

Users can upload new files from these sources:

• Supported File Types: CSV, Excel, Google Sheet

• Upload Sources:

  • From computer

  • From Google Drive

  • From OneDrive

• Size Limit: Maximum 30MB per upload

Existing Files

You can also use files previously uploaded to the system, provided they are still within the allowed storage period.

Create Dataset from a New File

Upload Files from Your Computer

1

Log in to FPT Data Suite

Log in to the FPT Data Suite system.

2

Navigate to Dataset creation

Navigate to Workspace > Data Warehouse > Create Dataset > From new file > Browse.

3

Upload the file via drag and drop or browse

In the Upload File popup, you can upload files in one of the following ways:

• Method 1: Drag and drop a file from your computer into the popup.

• Method 2: Click Browse Files > select file > click Open.

• Method 3: Click My Device > select file > click Open.

4

Double-check the uploaded file

Double-check the uploaded file before proceeding.

Upload Files from Google Drive

Follow the same steps as above, but in the Upload File popup, select Google Drive.

1

Log in to FPT Data Suite

Log in to the FPT Data Suite system.

2

Navigate to Dataset creation

Navigate to Workspace > Data Warehouse > Create Dataset > From new file > Browse.

3

Select Google Drive

In the Upload File popup, select Google Drive.

4

Log in to Google account

Log in to the Google account that contains the file you want to upload.

5

Grant access to FPT Data Suite App

Grant access to the FPT Data Suite App (Trust DS App).

6

Select file and upload

Select the file > Upload.

7

Double-check the uploaded file

Double-check the uploaded file before proceeding.

Upload Files from OneDrive

Follow the same steps as above, but in the Upload File popup, select OneDrive.

1

Log in to FPT Data Suite

Log in to the FPT Data Suite system.

2

Navigate to Dataset creation

Navigate to Workspace > Data Warehouse > Create Dataset > From new file > Browse.

3

Select OneDrive

In the Upload File popup, select OneDrive.

4

Log in to OneDrive account

Log in to the OneDrive account that contains the file you want to upload.

5

Select file and upload

Select the file > Upload.

6

Double-check the uploaded file

Double-check the uploaded file before proceeding.

Create Dataset from a CSV File

1

Log in to FPT Data Suite

Log in to the FPT Data Suite system.

2

Navigate to Dataset creation

Navigate to Workspace > Data Warehouse > Create Dataset > From new file > Browse.

3

Select file source

Select one of the three file sources (From computer, Google Drive, or OneDrive).

4

Select and upload file

Select your CSV file and upload it.

5

Complete the dataset creation

Complete the dataset creation process.

Create Dataset from an Excel File or Google Sheets

1

Log in to FPT Data Suite

Log in to the FPT Data Suite system.

2

Navigate to Dataset creation

Navigate to Workspace > Data Warehouse > Create Dataset > From new file > Browse.

3

Select and upload file

Select an Excel file or a Google Sheets file and upload it.

4

Configure additional settings

Additional settings:

• Select a sheet.

• Select the data range (cell range) to import into the Data Warehouse.

Note: By default, the first row of the file (CSV, Excel, or Google Sheets) is used as the header. Dataset field names are based on these headers.

Create Dataset from an Existing File

1

Log in to FPT Data Suite

Log in to the FPT Data Suite system.

2

Navigate to Dataset creation from available file

Navigate to Workspace > Data Warehouse > Create Dataset > From Available File.

3

Select file

Select a file from the list of previously uploaded files.

4

Complete dataset creation

Follow the instructions to complete dataset creation.

Synchronize Data from File to DWH Table

When you need to modify data (update, add, or delete) in a Dataset that was originally created on the DWH from a file source, you'll need to update and synchronize this data to the DWH.

Note: When updating a file, do not modify its structure—only update its content.

• You can:

  • Update the file locally (on your computer), or

  • Update it directly on Google Drive or OneDrive (if it was originally uploaded from there).

• Do not change the file structure (e.g., column names or number of columns). Any structural modifications—such as adding, removing, or renaming columns—will cause synchronization errors.

For Files from Computer

1

Update the file content locally

Update the file content on your computer.

2

Log in to FPT Data Suite

Log in to the FPT Data Suite system.

3

Navigate to Dataset's Data Origin

Navigate to: Workspace > Data Warehouse > [Dataset] > Data Origin.

4

Upload the updated file

Upload the updated file from your computer, Google Drive, or OneDrive.

5

Complete the Dataset file information update

Complete the process of updating the Dataset file information.

6

Synchronize data from source

Go to the Data tab > select Update data from source.

For Files from Google Drive or OneDrive

1

Update the file directly on Drive/OneDrive

Update the file content directly on Google Drive or OneDrive.

2

Log in to FPT Data Suite

Log in to the FPT Data Suite system.

3

Synchronize data from source

Navigate to: Workspace > Data Warehouse > [Dataset] and click Update Data from Source.