-
Notifications
You must be signed in to change notification settings - Fork 33
gw_fct_import_dbprices
Daniel Marín edited this page Jul 8, 2026
·
1 revision
Function to import prices from csv file into database
SELECT gw_fct_import_dbprices($${
"client":{"device":4, "infoType":1, "lang":"ES"},
"feature":{},"data":{}}$$){
"status": "Accepted",
"message": {
"level": 3,
"text": "Process done successfully"
},
"version": "3.5.003",
"body": {
"form": {},
"data": {
"info": {
"geometryType": "",
"values": [
{
"id": 710,
"message": "IMPORT DB PRICES FILE"
},
{
"id": 711,
"message": "------------------------------"
},
{
"id": 712,
"message": "Reading values from temp_csv table -> Done"
},
{
"id": 713,
"message": "Inserting values on plan_price table -> Done"
},
{
"id": 714,
"message": "Deleting values from temp_csv -> Done"
},
{
"id": 715,
"message": "Process finished"
}
]
}
}
}
}

