-
Notifications
You must be signed in to change notification settings - Fork 11
gw_fct_import_elements
Edgar Fuste edited this page Nov 2, 2021
·
1 revision
Function to import elements from csv file into database
SELECT gw_fct_import_elements($${
"client":{"device":4, "infoType":1, "lang":"ES"}, "form":{}, "feature":{},
"data":{"filterFields":{}, "pageInfo":{}, "importParam":"node", "fid":"235"}}$$)::text
{
"status": "Accepted",
"message": {
"level": 0,
"text": "Process executed"
},
"version": "3.4.019",
"body": {
"form": {},
"data": {
"info": {
"geometryType": "",
"values": [
{
"id": 3393,
"message": "IMPORT ELEMENTS FILE"
},
{
"id": 3394,
"message": "------------------------------"
},
{
"id": 3395,
"message": "Reading values from temp_csv table -> Done"
},
{
"id": 3396,
"message": "Inserting values on element table -> Done"
},
{
"id": 3397,
"message": "Inserting values on element_x_node table -> Done"
},
{
"id": 3398,
"message": "Deleting values from temp_csv -> Done"
},
{
"id": 3399,
"message": "Process finished"
}
]
}
}
}
}