gw_fct_import_omvisit - Giswater/giswater_dbmodel GitHub Wiki

---

Description

Function to import visits from csv file into database

Input example

SELECT gw_fct_import_omvisit($${
"client":{"device":4, "infoType":1, "lang":"ES"}, 
"form":{}, "feature":{}, 
"data":{"filterFields":{}, "pageInfo":{}, "importParam":"", "fid":"238"}}$$);

Output example

{
  "status": "Accepted",
  "message": {
    "level": 0,
    "text": "Process executed"
  },
  "version": "3.4.021",
  "body": {
    "form": {},
    "data": {
      "info": {
        "geometryType": "",
        "values": [
          {
            "id": 3038,
            "message": "LOG IMPORTACIO DE FITXER DE VISITES DE LA CONTRATA DE SANEJAMENT"
          },
          {
            "id": 3039,
            "message": "--------------------------------------------------------------------------------------"
          },
          {
            "id": 3040,
            "message": "Reading values from temp_csv table -> Done"
          },
          {
            "id": 3041,
            "message": "Inserting values on om_visit table -> Done"
          },
          {
            "id": 3042,
            "message": "Inserting values on  table -> Done"
          },
          {
            "id": 3043,
            "message": "Inserting values on om_visit_event table -> Done"
          },
          {
            "id": 3044,
            "message": "Deleting values from temp_csv -> Done"
          },
          {
            "id": 3045,
            "message": "Process finished"
          }
        ]
      }
    }
  }
}