Re: [Qgis-user] CSV layer, Time column null expressie to test for NULL/empty?
Pff, ok found a solution:
"bezoek.begintijd" IS NULL
works
So if I want to test for empty strings, or NULL (like strings), AND real NULLS,
I use now:
( "bezoek.begintijd" IS NULL OR "bezoek.begintijd" in ('', ' ', 'NULL') )
Regards,
Richard Duivenvoorde
On 1/18/23 18:31, Richard Duivenvoorde via QGIS-User wrote:
We have csv data, which is loaded as layer via the Delimited Text Layer
provider.
The data contains both a date and a time column, which we have to format as
isodatetime using an QGIS Expression.
BUT sometimes time column is empty/no value (in which case we have to format it
as isoTIME only).
So we have to check IF the time column is empty, then only format the Date,
else use Date AND Time.
My problem is that I fail to create an expression for the test IF the column
(see screenshot) is empty.
I thought to use (our column is called "bezoek.begintijd"):
"bezoek.begintijd" in ('', ' ', NULL)
BUT this does NOT return True or False, but NULL !!
But:
("bezoek.begintijd" in ('', ' ', NULL)) = NULL
does ALSO NOT resolve to True... (also NULL)
When the record has no data (the csv holds no data for that record), it shows
if it has data:
Anybody an idea what test I can use to test if the time column (which is typed
as Time) is empty/null/none?
Thanks for any pointers.
Regards,
Richard Duivenvoorde
___
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
___
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] CSV layer, Time column null expressie to test for NULL/empty?
We have csv data, which is loaded as layer via the Delimited Text Layer
provider.
The data contains both a date and a time column, which we have to format as
isodatetime using an QGIS Expression.
BUT sometimes time column is empty/no value (in which case we have to format it
as isoTIME only).
So we have to check IF the time column is empty, then only format the Date,
else use Date AND Time.
My problem is that I fail to create an expression for the test IF the column
(see screenshot) is empty.
I thought to use (our column is called "bezoek.begintijd"):
"bezoek.begintijd" in ('', ' ', NULL)
BUT this does NOT return True or False, but NULL !!
But:
("bezoek.begintijd" in ('', ' ', NULL)) = NULL
does ALSO NOT resolve to True... (also NULL)
When the record has no data (the csv holds no data for that record), it shows
if it has data:
Anybody an idea what test I can use to test if the time column (which is typed
as Time) is empty/null/none?
Thanks for any pointers.
Regards,
Richard Duivenvoorde___
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Export to ESRI File Geodatabase
*Randal Hale* /Tue Jan 17 12:56:50 PST 2023/ I installed QGIS using the Stand Alone installer (after removing QGIS Network Install) and didn't have ESRI File Geodatabase as a choice on export Features. This is confirmed by another user using the standalone installer. Hi Randal, AFAIK neither the OSGeo4W stand-alone installer nor the network installer currently install the GDAL plugin library needed to write a File Geodatabase layer using the ESRI proprietary driver via the "Export As" menu. If you want to use such ESRI proprietary driver, you need to install the package named gdal-filegdb using the OSGeo4W Setup installation interface. Regards. Andrea Giudiceandrea___ QGIS-User mailing list QGIS-User@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Export to ESRI File Geodatabase
*Nyall Dawson* /Tue Jan 17 15:53:36 PST 2023/ It should still be possible to export to GDB in 3.28 without that fix. >/From the browser panel, you can create a new empty Geodatabase by /right-clicking on a folder, and then drag and drop layers directly into that GDB to import them! Anyway, importing a layer in an ESRI File Geodatabase using the drag and drop functionality of the QGIS Browser may lead to an incorrect imported layer in some circumstances as reported at https://github.com/qgis/QGIS/issues/51435. Regards. Andrea Giudiceandrea___ QGIS-User mailing list QGIS-User@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
