Qgis csv button - Giswater/giswater_dbmodel GitHub Wiki

Giswater QGIS plugin allows importing data from csv files into the data base. Button, by default, is programmed with:

• Import visit lot
• Import db prices
• Import elements
• Import addfields
• Import om visit

User may add and configure a new function, which can also appear on the button form. The new function should be defined first on the sys_function table, define a new import process on sys_fprocess and then configured on config_csv. While creating a new function it's important to know how does the button work. After selecting a file on the plugin form, data is inserted into table temp_csv and organized by function gw_fct_setcsv. User's function shoud be defined in a way to use data inserted into temp_csv table with the new fid. After reorganizing the data, the function defined on config_csv table, assigned to the process selected by user, is called and that function executes reading from temp_csv and inserting into table of interest.