How to :: how to drop a datasource in Toucan Toco?

Overview

Hey data friends 👋

You want to know how to drop a datasource in Toucan? You are on the dedicated page 🚀

In this section you are going to see how to drop:

The most dropped files in Toucan 😉

Drop a csv file

You got some csv files, and you want to use it in Toucan, here you go!

Step 1

  • Once on my app, I switch to “staging” mode. This is where a contributor can create, edit, update content for the app. The “staging” mode of Toucan also called “Studio”, changes made in the “staging” mode will be available to the end-users only if you publish them!

To switch in “staging” mode, you have to click in the down left corner of your app.

staging mode

Step 2

  • Once in staging, I can go to my “datasources” interface: by clicking in the bar below the screen.
staging mode 2

Step 3

  • In the “datasources” interface, I can “Add a data source””: by clicking on the dedicated square and selecting a csv file on my computer.
square drop

Step 4

  • Once I have chosen my file, the settings window opens: you can check and preview your datas. Also, you have others globals settings: Load: if you activate this setting, you allow to load the file in the database, and use it in Toucan

Match multiple files: you can use regex to load multiple files. If you more details about it, you can check this page

Cache the extracted file: you can activate or not to speed the extraction by not reading the file again if its modification date has not changed Validation: here, you can add some validation steps to be sure that your file is correct

settings window

Drop an excel file

Your company used excel files, and you want to use it in Toucan, here you go!

Step 1

  • Once on my app, I switch to “staging” mode. This is where a contributor can create, edit, update content for the app. The “staging” mode of Toucan also called “Studio”, changes made in the “staging” mode will be available to the end-users only if you publish them!

To switch in “staging” mode, you have to click in the down left corner of your app.

staging mode

Step 2

  • Once in staging, I can go to my “datasources” interface: by clicking in the bar below the screen.
staging mode 2

Step 3

  • In the “datasources” interface, I can “Add a data source””: by clicking on the dedicated square and selecting an excel file on my computer.
square drop

Step 4

  • Once I have chosen my file, the settings window opens: you can check and preview your datas. You have others globals settings: Load: if you activate this setting, you allow to load the file in the database, and use it in Toucan

Match multiple files: you can use regex to load multiple files. If you more details about it, you can check this page

Cache the extracted file: you can activate or not to speed the extraction by not reading the file again if its modification date has not changed Validation: here, you can add some validation steps to be sure that your file is correct

settings window

Also, you have specifics settings, by clicking on “More optional parameters”: Sheetname option: you can choose the name of the sheetname.

sheetname

💡 Also, you have others specifics settings, if you want to know more about it: follow this part to discover how to add your datasources like a pro.