[Qgis-user] Null value issue in attribute form

[Brent Wood via QGIS-User]

Hi,

I have a database table which has an attribute form built for data entry, in 
QGIS 3.34.

There is a text field "station_code"
It is set to not null & enforce not null in the form.

If the default value is null (empty) the form includes the default text 'NULL'.
Any text entered in the form is then appended to the string 'NULL', which is 
NOT what I want to happen. This behaviour requires the user to delete the 4 
chars 'NULL' every time they enter some data, before typing in the value, which 
is something of an inconvenience, and leads to data errors.

If I set the default value in the form to '' (empty string), then the field is 
populated with this by default, and data entry works as I want, however, as 
this value is not null, the record can be saved without a value being entered, 
so the not null requirement is essentially useless.

Is there a way to set the form up to have a "not null" constraint applied in 
the form, without having QGIS pre-populate the field in the form with the 
string 'NULL'?
It works for integer types, the form has an italicised 'NULL' but this does NOT 
form part of the value in the field, unlike the string field.


Thanks

Brent Wood

Principal Technician, Fisheries
NIWA
DDI:  +64 (4) 3860529
[https://www.niwa.co.nz/static/niwa-2018-horizontal-180.png] 

Brent Wood
Principal Technician - GIS and Spatial Data Management
Programme Leader - Environmental Information Delivery
+64-4-386-0529

National Institute of Water & Atmospheric Research Ltd (NIWA)
301 Evans Bay Parade Hataitai Wellington New Zealand
Connect with NIWA: niwa.co.nz 
Facebook 
LinkedIn 
Twitter 
Instagram 
YouTube
To ensure compliance with legal requirements and to maintain cyber security 
standards, NIWA's IT systems are subject to ongoing monitoring, activity 
logging and auditing. This monitoring and auditing service may be provided by 
third parties. Such third parties can access information transmitted to, 
processed by and stored on NIWA's IT systems.
Note: This email is intended solely for the use of the addressee and may 
contain information that is confidential or subject to legal professional 
privilege. If you receive this email in error please immediately notify the 
sender and delete the email.
___
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] Opening the Data Source Manager crashes QGIS

[Rob Dingen via QGIS-User]

Yes, the moment I click the data source manager icon it crashes without 
failure..
Thanks very much for your advice. I will follow the steps and see where I land.
Thanks
Rob

> On 9 Nov 2023, at 12:00 PM, Richard Duivenvoorde  wrote:
> 
> Hi Rob,
> 
> IF it is indeed a google earth plugin, which is causing the crash, 
> reinstalling will not help because plugins are installed in your 
> (QGIS)-profile, not in your installation.
> 
> Is it constantly crashing?
> 
> So either remove the plugin (via the plugin manager), or go into your profile 
> (Settings/User Profiles) and remove the plugin by hand.
> A last option is to create a fresh profile, which will give you a profile 
> without any plugin.
> See 
> https://docs.qgis.org/3.28/en/docs/user_manual/introduction/qgis_configuration.html#working-with-user-profiles
> 
> Hope This Helps :-)
> 
> Richard Duivenvoorde
> 
> On 11/9/23 11:47, Rob Dingen via QGIS-User wrote:
>> Dear Forum,
>> Forgive my ignorance and infancy level using QGIS
>> Installed on IOS:
>> QGIS version3.32.3-Lima
>> Qt version5.15.2
>> Python version3.9.5
>> When I try to open the Data Source Manager the application crashes. I 
>> probably did something wrong with a google earth plugin.
>> Removing and installing a new copy does not help
>> Could anyone advise how to install a clean version without importing the 
>> files which cause the crash?
>> Please keep in mind I am a novel user .. not a developer
>> Grateful!
>> Best
>> Rob
>> ___
>> 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

Re: [Qgis-user] Opening the Data Source Manager crashes QGIS

[Richard Duivenvoorde via QGIS-User]

Hi Rob,

IF it is indeed a google earth plugin, which is causing the crash, reinstalling 
will not help because plugins are installed in your (QGIS)-profile, not in your 
installation.

Is it constantly crashing?

So either remove the plugin (via the plugin manager), or go into your profile 
(Settings/User Profiles) and remove the plugin by hand.
A last option is to create a fresh profile, which will give you a profile 
without any plugin.
See 
https://docs.qgis.org/3.28/en/docs/user_manual/introduction/qgis_configuration.html#working-with-user-profiles

Hope This Helps :-)

Richard Duivenvoorde

On 11/9/23 11:47, Rob Dingen via QGIS-User wrote:

Dear Forum,
Forgive my ignorance and infancy level using QGIS
Installed on IOS:

QGIS version3.32.3-Lima
Qt version5.15.2
Python version3.9.5
When I try to open the Data Source Manager the application crashes. I probably 
did something wrong with a google earth plugin.

Removing and installing a new copy does not help
Could anyone advise how to install a clean version without importing the files 
which cause the crash?
Please keep in mind I am a novel user .. not a developer

Grateful!
Best
Rob

___
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] Opening the Data Source Manager crashes QGIS

[Rob Dingen via QGIS-User]

Dear Forum, 
Forgive my ignorance and infancy level using QGIS
Installed on IOS:

QGIS version3.32.3-Lima
Qt version  5.15.2
Python version  3.9.5
When I try to open the Data Source Manager the application crashes. I probably 
did something wrong with a google earth plugin.

Removing and installing a new copy does not help 
Could anyone advise how to install a clean version without importing the files 
which cause the crash?
Please keep in mind I am a novel user .. not a developer 

Grateful!
Best
Rob
___
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