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.
Step 2¶
- Once in staging, I can go to my “datasources” interface: by clicking in the bar below the screen.
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.
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
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.
Step 2¶
- Once in staging, I can go to my “datasources” interface: by clicking in the bar below the screen.
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.
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
Also, you have specifics settings, by clicking on “More optional parameters”: Sheetname option: you can choose the name of the 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.