QRealTime
QRealTime copied to clipboard
I don't get the data neither in the table of attributes nor the geometry
I don't get the data neither in the table of attributes nor the geometry I connect to the server and download the form and its load the structure of the form in the attribute table but no data. I prepare the form in ODK Build. I tried it in the stable version and it works as long as it doesn't have grouped fields. However, in the experimental version it gives me a python error.
Goto View-->Panels-->Log Message 2020-05-15T08:01:54 INFO C:/Users/Mara/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\QRealTime\i18n\QRealTime_es.qm 2020-05-15T08:01:54 INFO None 2020-05-15T08:01:54 INFO None 2020-05-15T08:03:42 INFO key capturedbuild_Conociendo-odk-rev_1589495584None 2020-05-15T08:03:42 INFO [, , , , , , , , , , , , ]None 2020-05-15T08:03:42 INFO {'nodeset': '/data/meta/instanceID', 'type': 'string', 'readonly': 'true()', 'calculate': "concat('uuid:', uuid())"}None 2020-05-15T08:03:42 INFO attrib type isstring 2020-05-15T08:03:42 INFO first attributeinstanceIDNone 2020-05-15T08:03:42 INFO creating new field:instanceIDNone 2020-05-15T08:03:42 INFO Reached HiddenNone 2020-05-15T08:03:42 INFO setting hidden widgetNone 2020-05-15T08:03:42 INFO {'nodeset': '/data/apellido', 'type': 'string', 'required': 'true()', '{http://openrosa.org/javarosa}requiredMsg': "jr:itext('/data/apellido:requiredMsg')", '{http://openrosa.org/javarosa}constraintMsg': "jr:itext('/data/apellido:constraintMsg')"}None 2020-05-15T08:03:42 INFO attrib type isstring 2020-05-15T08:03:42 INFO first attributeapellidoNone 2020-05-15T08:03:42 INFO creating new field:apellidoNone 2020-05-15T08:03:42 INFO 'type'None 2020-05-15T08:03:42 INFO {'nodeset': '/data/nombre', 'type': 'string', 'required': 'true()', '{http://openrosa.org/javarosa}requiredMsg': "jr:itext('/data/nombre:requiredMsg')", '{http://openrosa.org/javarosa}constraintMsg': "jr:itext('/data/nombre:constraintMsg')"}None 2020-05-15T08:03:42 INFO attrib type isstring 2020-05-15T08:03:42 INFO first attributenombreNone 2020-05-15T08:03:42 INFO creating new field:nombreNone 2020-05-15T08:03:42 INFO 'type'None 2020-05-15T08:03:42 INFO {'nodeset': '/data/edad', 'type': 'int', 'required': 'true()', '{http://openrosa.org/javarosa}requiredMsg': "jr:itext('/data/edad:requiredMsg')", '{http://openrosa.org/javarosa}constraintMsg': "jr:itext('/data/edad:constraintMsg')"}None 2020-05-15T08:03:42 INFO attrib type isint 2020-05-15T08:03:42 INFO first attributeedadNone 2020-05-15T08:03:42 INFO creating new field:edadNone 2020-05-15T08:03:42 INFO 'type'None 2020-05-15T08:03:42 INFO {'nodeset': '/data/dia', 'type': 'date', '{http://openrosa.org/javarosa}constraintMsg': "jr:itext('/data/dia:constraintMsg')"}None 2020-05-15T08:03:42 INFO attrib type isdate 2020-05-15T08:03:42 INFO first attributediaNone 2020-05-15T08:03:42 INFO creating new field:diaNone 2020-05-15T08:03:42 INFO 'type'None 2020-05-15T08:03:42 INFO {'nodeset': '/data/GEOMETRY', 'type': 'geopoint', 'required': 'true()', '{http://openrosa.org/javarosa}requiredMsg': "jr:itext('/data/GEOMETRY:requiredMsg')", '{http://openrosa.org/javarosa}constraintMsg': "jr:itext('/data/GEOMETRY:constraintMsg')"}None 2020-05-15T08:03:42 INFO attrib type isgeopoint 2020-05-15T08:03:42 INFO first attributeGEOMETRYNone 2020-05-15T08:03:42 INFO {'nodeset': '/data/mate', 'type': 'select1', 'required': 'true()', '{http://openrosa.org/javarosa}requiredMsg': "jr:itext('/data/mate:requiredMsg')", '{http://openrosa.org/javarosa}constraintMsg': "jr:itext('/data/mate:constraintMsg')"}None 2020-05-15T08:03:42 INFO attrib type isselect1 2020-05-15T08:03:42 INFO first attributemateNone 2020-05-15T08:03:42 INFO creating new field:mateNone 2020-05-15T08:03:42 INFO 'type'None 2020-05-15T08:03:42 INFO {'nodeset': '/data/tipo_mate', 'type': 'select', 'relevant': "(selected(/data/mate, 'si'))", '{http://openrosa.org/javarosa}constraintMsg': "jr:itext('/data/tipo_mate:constraintMsg')"}None 2020-05-15T08:03:42 INFO attrib type isselect 2020-05-15T08:03:42 INFO first attributetipo_mateNone 2020-05-15T08:03:42 INFO creating new field:tipo_mateNone 2020-05-15T08:03:42 INFO 'type'None 2020-05-15T08:03:42 INFO {'nodeset': '/data/imagen', 'type': 'binary', '{http://openrosa.org/javarosa}constraintMsg': "jr:itext('/data/imagen:constraintMsg')"}None 2020-05-15T08:03:42 INFO attrib type isbinary 2020-05-15T08:03:42 INFO first attributeimagenNone 2020-05-15T08:03:42 INFO creating new field:imagenNone 2020-05-15T08:03:42 INFO 'type'None 2020-05-15T08:03:42 INFO now setting exernal resource widgtNone 2020-05-15T08:03:42 INFO {'nodeset': '/data/usuario', 'type': 'string', '{http://openrosa.org/javarosa}preload': 'property', '{http://openrosa.org/javarosa}preloadParams': 'username'}None 2020-05-15T08:03:42 INFO attrib type isstring 2020-05-15T08:03:42 INFO first attributeusuarioNone 2020-05-15T08:03:42 INFO creating new field:usuarioNone 2020-05-15T08:03:42 INFO Reached HiddenNone 2020-05-15T08:03:42 INFO setting hidden widgetNone 2020-05-15T08:03:42 INFO {'nodeset': '/data/fecha', 'type': 'date', '{http://openrosa.org/javarosa}preload': 'date', '{http://openrosa.org/javarosa}preloadParams': 'today'}None 2020-05-15T08:03:42 INFO attrib type isdate 2020-05-15T08:03:42 INFO first attributefechaNone 2020-05-15T08:03:42 INFO creating new field:fechaNone 2020-05-15T08:03:42 INFO Reached HiddenNone 2020-05-15T08:03:42 INFO setting hidden widgetNone 2020-05-15T08:03:42 INFO {'nodeset': '/data/start_time', 'type': 'dateTime', '{http://openrosa.org/javarosa}preload': 'timestamp', '{http://openrosa.org/javarosa}preloadParams': 'start'}None 2020-05-15T08:03:42 INFO attrib type isdateTime 2020-05-15T08:03:42 INFO first attributestart_timeNone 2020-05-15T08:03:42 INFO creating new field:start_timeNone 2020-05-15T08:03:42 INFO Reached HiddenNone 2020-05-15T08:03:42 INFO setting hidden widgetNone 2020-05-15T08:03:42 INFO {'nodeset': '/data/end_time', 'type': 'dateTime', '{http://openrosa.org/javarosa}preload': 'timestamp', '{http://openrosa.org/javarosa}preloadParams': 'end'}None 2020-05-15T08:03:42 INFO attrib type isdateTime 2020-05-15T08:03:42 INFO first attributeend_timeNone 2020-05-15T08:03:42 INFO creating new field:end_timeNone 2020-05-15T08:03:42 INFO Reached HiddenNone 2020-05-15T08:03:42 INFO setting hidden widgetNone 2020-05-15T08:03:42 INFO 'type'None 2020-05-15T08:03:42 INFO number of submissions are3 2020-05-15T08:03:42 INFO server lastID isuuid:b6c0c7d0-26a7-47ad-8f59-20d2c35cc93a 2020-05-15T08:03:42 INFO first DownloadNone 2020-05-15T08:03:42 INFO downloadingNone 2020-05-15T08:03:42 INFO http://rpgeo.ddns.net:8080/ODKAggregate/view/downloadSubmissionNone 2020-05-15T08:03:42 INFO errorNone 2020-05-15T08:03:42 INFO value isNone 2020-05-15T08:03:42 INFO value isRojas 2020-05-15T08:03:42 INFO value isMara 2020-05-15T08:03:42 INFO value is30 2020-05-15T08:03:42 INFO value is2020-05-14 2020-05-15T08:03:42 INFO value is-31.0119760200 -64.0780700900 534.1428222656 3.2160000801 2020-05-15T08:03:42 INFO value issi 2020-05-15T08:03:42 INFO value isamargo hierbas 2020-05-15T08:03:42 INFO value is1589495688199.jpg 2020-05-15T08:03:42 INFO Download url ishttp://rpgeo.ddns.net:8080/ODKAggregate/view/binaryData?blobKey=build_Conociendo-odk-rev_1589495584%5B%40version%3Dnull+and+%40uiVersion%3Dnull%5D%2Fdata%5B%40key%3Duuid%3Acea3b7e3-cc1f-4ab1-a3fa-53e41c3f49a2%5D%2Fimagen%5B%40ordinal%3D1%5D&as_attachment=true 2020-05-15T08:03:42 INFO value istaller 2020-05-15T08:03:42 INFO value is2020-05-14 2020-05-15T08:03:42 INFO value is2020-05-14T19:33:54.135-03:00 2020-05-15T08:03:42 INFO value is2020-05-14T19:34:52.112-03:00 2020-05-15T08:03:42 INFO value isuuid:cea3b7e3-cc1f-4ab1-a3fa-53e41c3f49a2 2020-05-15T08:03:42 INFO http://rpgeo.ddns.net:8080/ODKAggregate/view/downloadSubmissionNone 2020-05-15T08:03:42 INFO errorNone 2020-05-15T08:03:42 INFO http://rpgeo.ddns.net:8080/ODKAggregate/view/downloadSubmissionNone 2020-05-15T08:03:43 INFO errorNone 2020-05-15T08:03:43 INFO before Update LayerNone 2020-05-15T08:03:43 INFO table have some dataNone 2020-05-15T08:03:43 INFO ODKUUIDNone 2020-05-15T08:03:43 INFO []None 2020-05-15T08:03:43 INFO geofield isGEOMETRY 2020-05-15T08:03:43 INFO {'meta': None, 'apellido': 'Rojas', 'nombre': 'Mara', 'edad': '30', 'dia': '2020-05-14', 'GEOMETRY': '-31.0119760200 -64.0780700900 534.1428222656 3.2160000801', 'mate': 'si', 'tipo_mate': 'amargo hierbas', 'imagen': 'http://rpgeo.ddns.net:8080/ODKAggregate/view/binaryData?blobKey=build_Conociendo-odk-rev_1589495584%5B%40version%3Dnull+and+%40uiVersion%3Dnull%5D%2Fdata%5B%40key%3Duuid%3Acea3b7e3-cc1f-4ab1-a3fa-53e41c3f49a2%5D%2Fimagen%5B%40ordinal%3D1%5D', 'usuario': 'taller', 'fecha': '2020-05-14', 'start_time': '2020-05-14T19:33:54.135-03:00', 'end_time': '2020-05-14T19:34:52.112-03:00', 'ODKUUID': 'uuid:cea3b7e3-cc1f-4ab1-a3fa-53e41c3f49a2'}None 2020-05-15T08:03:43 INFO odk id isuuid:cea3b7e3-cc1f-4ab1-a3fa-53e41c3f49a2 2020-05-15T08:03:43 INFO {'meta': None, 'apellido': 'Rojas', 'nombre': 'Mara', 'edad': '30', 'dia': '2020-05-14', 'GEOMETRY': '-31.0119760200 -64.0780700900 534.1428222656 3.2160000801', 'mate': 'si', 'tipo_mate': 'amargo hierbas', 'imagen': 'http://rpgeo.ddns.net:8080/ODKAggregate/view/binaryData?blobKey=build_Conociendo-odk-rev_1589495584%5B%40version%3Dnull+and+%40uiVersion%3Dnull%5D%2Fdata%5B%40key%3Duuid%3Acea3b7e3-cc1f-4ab1-a3fa-53e41c3f49a2%5D%2Fimagen%5B%40ordinal%3D1%5D', 'usuario': 'taller', 'fecha': '2020-05-14', 'start_time': '2020-05-14T19:33:54.135-03:00', 'end_time': '2020-05-14T19:34:52.112-03:00', 'ODKUUID': 'uuid:cea3b7e3-cc1f-4ab1-a3fa-53e41c3f49a2'}None 2020-05-15T08:03:43 INFO POINT(-64.07807009 -31.01197602)None 2020-05-15T08:03:43 INFO geom is 2020-05-15T08:03:43 INFO {'meta': None, 'apellido': 'Rojas', 'nombre': 'Mara', 'edad': '20', 'dia': '2020-05-16', 'GEOMETRY': '-31.0119784600 -64.0780564300 534.1218261719 3.2160000801', 'mate': 'si', 'tipo_mate': 'amargo hierbas', 'imagen': None, 'usuario': 'taller', 'fecha': '2020-05-14', 'start_time': '2020-05-14T19:43:18.592-03:00', 'end_time': '2020-05-14T19:51:06.286-03:00', 'ODKUUID': 'uuid:e88cd799-2c7d-43e5-9493-579cfb6cea5e'}None 2020-05-15T08:03:43 INFO odk id isuuid:e88cd799-2c7d-43e5-9493-579cfb6cea5e 2020-05-15T08:03:43 INFO {'meta': None, 'apellido': 'Rojas', 'nombre': 'Mara', 'edad': '20', 'dia': '2020-05-16', 'GEOMETRY': '-31.0119784600 -64.0780564300 534.1218261719 3.2160000801', 'mate': 'si', 'tipo_mate': 'amargo hierbas', 'imagen': None, 'usuario': 'taller', 'fecha': '2020-05-14', 'start_time': '2020-05-14T19:43:18.592-03:00', 'end_time': '2020-05-14T19:51:06.286-03:00', 'ODKUUID': 'uuid:e88cd799-2c7d-43e5-9493-579cfb6cea5e'}None 2020-05-15T08:03:43 INFO POINT(-64.07805643 -31.01197846)None 2020-05-15T08:03:43 INFO geom is 2020-05-15T08:03:43 INFO {'meta': None, 'apellido': 'G', 'nombre': 'H', 'edad': '5', 'dia': '2020-05-22', 'GEOMETRY': '-31.0119552900 -64.0780424100 533.5878906250 8.5760002136', 'mate': 'si', 'tipo_mate': 'azucar', 'imagen': None, 'usuario': 'taller', 'fecha': '2020-05-14', 'start_time': '2020-05-14T19:51:16.024-03:00', 'end_time': '2020-05-14T19:51:57.531-03:00', 'ODKUUID': 'uuid:b6c0c7d0-26a7-47ad-8f59-20d2c35cc93a'}None 2020-05-15T08:03:43 INFO odk id isuuid:b6c0c7d0-26a7-47ad-8f59-20d2c35cc93a 2020-05-15T08:03:43 INFO {'meta': None, 'apellido': 'G', 'nombre': 'H', 'edad': '5', 'dia': '2020-05-22', 'GEOMETRY': '-31.0119552900 -64.0780424100 533.5878906250 8.5760002136', 'mate': 'si', 'tipo_mate': 'azucar', 'imagen': None, 'usuario': 'taller', 'fecha': '2020-05-14', 'start_time': '2020-05-14T19:51:16.024-03:00', 'end_time': '2020-05-14T19:51:57.531-03:00', 'ODKUUID': 'uuid:b6c0c7d0-26a7-47ad-8f59-20d2c35cc93a'}None 2020-05-15T08:03:43 INFO POINT(-64.07804241 -31.01195529)None 2020-05-15T08:03:43 INFO geom is
Python error tab 2020-05-15T08:03:43 WARNING Traceback (most recent call last): File "C:/Users/Mara/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\QRealTime\QRealTime.py", line 278, in importData service.importData(layer,selectedForm,True) File "C:/Users/Mara/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\QRealTime\QRealTime_dialog.py", line 271, in importData self.collectData(layer,self.formKey,importData,self.topElement,self.version,self.geoField) File "C:/Users/Mara/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\QRealTime\QRealTime_dialog.py", line 427, in collectData self.updateLayer(layer,remoteTable,geoField) File "C:/Users/Mara/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\QRealTime\QRealTime_dialog.py", line 504, in updateLayer self.iface.messageBar().pushWarning(self.tag, self.tr("Can't find '%s' field") % fieldError) TypeError: not all arguments converted during string formatting
To Reproduce Steps to reproduce the behavior:
- Go to 'Import' doing right click on a empy point layer
- Click on 'Accept' to import the form that it is in the Server.
- See error
Expected behavior Data in both attribute table and canvas (geometry).
Screenshots
please complete the following information):
- OS: [Windows 10 Pro]
- QGIS Version [3.6, 3.8]
- Plugin Version [3.11 The experimental one]
Additional context
- If I import the collected data as .csv in QGIS a can see it correctly.
- In the stable version its works.