3. Create your first extraction

Tab Name (1) : From the dropdown you can choose to import you data on an existing sheet, or create a new one by just typing its name, and they press “enter” key to validate the entry

Server (2) : Chose here the server instance to use. If your credentials expired or if it’s the first time you connect, you have to log in by using your credentials in order to continue. Be aware, you need “Administration / Settings” grant level in order to use “Advanced SQL request”.

If you want to automate your extractions, you need to check “Remember my credentials” in order to automatically reconnect when they will expire

Odoo table (3) : You have to choose here the table from where to extract data.

Select a module, and than you can pick the table from which you want your data. You can also use the search tool and filter upon description or technical name. To validate your choice click over the check button.

Configuring the extraction :

Select the list of columns you need to work with. This will open a popup and will let you chose the fields and their order.

Once columns validated, you can pick optional configuration. You need to be aware that by default Odoo delivers only 80 first rows, so you will need to change this limit in order to retrieve the full dataset (some limitations may apply).

What are your Feelings