gw_fct_import_addfields - Giswater/giswater_dbmodel GitHub Wiki

---

Description

Function to import custom fields from csv file into database

Input example

SELECT gw_fct_import_addfields($${
"client":{"device":4, "infoType":1, "lang":"ES"},
"feature":{},"data":{}}$$)

Output example

{
  "status": "Accepted",
  "message": {
    "level": 0,
    "text": "Process executed"
  },
  "version": "3.4.019",
  "body": {
    "form": {},
    "data": {
      "info": {
        "geometryType": "",
        "values": [
          {
            "id": 3378,
            "message": "IMPORT ADD FIELDS FILE"
          },
          {
            "id": 3379,
            "message": "------------------------------"
          },
          {
            "id": 3380,
            "message": "Reading values from temp_csv table -> Done"
          },
          {
            "id": 3381,
            "message": "Inserting values on man_addfields_value table -> Done"
          },
          {
            "id": 3382,
            "message": "Deleting values from temp_csv -> Done"
          },
          {
            "id": 3383,
            "message": "Process finished"
          }
        ]
      }
    }
  }
}