gw_fct_import_elements - Giswater/giswater_dbmodel GitHub Wiki

---

Description

Function to import elements from csv file into database

Input example

SELECT gw_fct_import_elements($${
"client":{"device":4, "infoType":1, "lang":"ES"}, "form":{}, "feature":{},
"data":{"filterFields":{}, "pageInfo":{}, "importParam":"node", "fid":"235"}}$$)::text

Output example

{
  "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"
          }
        ]
      }
    }
  }
}