Re: [Qgis-user] Looking for QGIS Python code for a three-level menu?

2024-05-12 Thread Jürgen E . Fischer via QGIS-User
Hi Mike,

On Sun, 12. May 2024 at 17:35:14 +, Elstermann, Mike via QGIS-User wrote:
> I'm looking for a piece of QGIS Python code for a three-level menu, something 
> like this:
> 
> Plugins
>|
>|
> MyMenu > -+-- Submenu 1 >  SubSubMenu 1.1
>|  |   +--- SubSubMenu 1.2
>|  |   +--- SubSubMenu 1.3
> Other...  |
>   +-- Submenu 2 >  SubSubMenu 2.1
>   |   +--- SubSubMenu 2.2
>   |   +--- SubSubMenu 2.3
>   |   +--- SubSubMenu 2.4
>   |
>   +-- Submenu 3 >  SubSubMenu 3.1
>   +--- SubSubMenu 3.2

m0 = iface.pluginMenu().addMenu("MyMenu")
m1 = m0.addMenu("SubMenu 1")
m1.addMenu("SubSubMenu 1.1")
m1.addMenu("SubSubMenu 1.2")
m1.addMenu("SubSubMenu 1.3")
m1 = m0.addMenu("SubMenu 2")
m1.addMenu("SubSubMenu 2.1")
m1.addMenu("SubSubMenu 2.2")
m1.addMenu("SubSubMenu 2.3")
m1 = m0.addMenu("SubMenu 3")
m1.addMenu("SubSubMenu 3.1")
m1.addMenu("SubSubMenu 3.2")

Jürgen

-- 
Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Nordenhttps://www.norbit.de
QGIS release manager (PSC)  Germany IRC: jef on Libera|OFTC


signature.asc
Description: PGP signature
___
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] INSTALL QGIS DESKTOP IN LUNUX UBUNTU THAT PERMIT CONNECT TO ORACLE DATABASES AND LOAD VECTOR LAYERS

2024-05-08 Thread Jürgen E . Fischer via QGIS-User
Hi,

On Wed, 08. May 2024 at 21:31:25 +, Fredy Varon via QGIS-User wrote:
> INSTALL QGIS DESKTOP IN LUNUX UBUNTU THAT PERMIT CONNECT  TO ORACLE DATABASES 
> AND LOAD VECTOR LAYERS

https://github.com/qgis/QGIS/blob/master/INSTALL.md#3101-building-packages-with-oracle-support


Jürgen

-- 
Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Nordenhttps://www.norbit.de
QGIS release manager (PSC)  Germany IRC: jef on Libera|OFTC


signature.asc
Description: PGP signature
___
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] A load of updates in OSGeo4W

2024-04-14 Thread Jürgen E . Fischer via QGIS-User
Hi there,

I just uploaded an update to OSGeo4W.   It is basically a rebuild of everything
with a newer compiler (Visual C++ 2022) and updates of almost all versions.
The update should work cleanly and cause no visual changes.

The main change is the move from Python 3.9.18 to 3.12.3.  But there's also an
update to Qt 5.15.13, OpenSSL 3.   Qt6 was also added enabling an experimental
build of QGIS master with Qt6. Based on that there is also an experimental
version of QField.

GDAL and PROJ also were updated to the latest version.

The legacy GRASS 7 was removed because it doesn't support Python 3.12.  GRASS 8
was already available and QGIS switch to it long before this update.

Please test and report.


Jürgen


More details in the commit message:

A load of updates (fixes #788, #810, #816, #819, #820, #823, closes 
jef-n/OSGeo4W#21, refs qgis/QGIS#54491, qgis/QGIS#56499)

Highlights:
  Switched to Visual Studio 2022
  Qt6 6.6.3, PyQt6 6.6.1
  Qt5 5.15.13, PyQt5 5.15.10
  Python 3.12.3
  OpenSSL 3.0.13
  PROJ 9.4.0
  GDAL 3.8.5
  qgis-qt6-dev based on Qt6 next to qgis-dev based on Qt5
  experimental QField based on Qt6 / qgis-qt6-dev

Details:
  Removed:
libjpeg (already replaced with libjpeg-turbo earlier)
python3-clcache (replaced by ccache)
python3-pyuv (dependency of python3-clcache)

  Updated:
apache 2.4.52 -> 2.4.58
arrow-cpp 7.0.0 -> 15.0.2
boost 1.74.0 -> 1.84.0
brotli 1.0.9 -> 1.1.0
curl 8.4.0 -> 8.6.0
draco 1.5.6 -> 1.5.7
exiv2 0.27.3 -> 0.28.2
expat 2.2.10 -> 2.6.2
ffmpeg 5.1 -> 6.1.1
freetype 2.10.2 -> 2.13.2
gdal 3.8.4 -> 3.8.5
gpsbabel 1.8.0 -> 1.9.0
grass 7.8.8 -> 8.3.2
grass8 8.3.2 -> 99 (transitional; depends on grass)
gsl 2.6 -> 2.7.1+
hdf4 4.2.16 -> 4.3.0
hdf5 1.14.0 -> 1.14.3
kealib 1.4.14 -> 1.5.3
lerc 3.0 -> 4.0.0
libharu 2.3.0 -> 2.4.4
libiconv 1.16 -> 1.17
libjpeg-turbo 2.0.7-esr -> 3.0.2
libjxl 0.8.1 -> 0.10.2
libmysql 8.0.21 -> 8.2.0
libosmium-devel 2.18.0 -> 2.20.0
libpng 1.6.37 -> 1.6.43
libtiff 4.5.1 -> 4.6.0
libxml2 2.9.10 -> 2.12.5
libxslt 1.1.34 -> 1.1.39
libzip 1.7.3 -> 1.10.1
lua 5.4.4 -> 5.4.6
lz4 1.9.3 -> 1.9.4
minizip-ng-devel 3.0.2 -> 4.0.4
node 16.14.0 -> 20.11.1
oci 19.11 -> 21.13
ogdi 4.1.0 -> 4.1.1
opencl 2.0.10 -> 2023.12.14
openfyba-devel 20150103 -> 20240408
openjpeg 2.4.0 -> 2.5.2
openssl 1.1.1w -> 3.0.13
osm2pgsql 1.8.1 -> 1.11.0
osmium 1.15.0 -> 1.16.0
pdal 2.6.0 -> 2.6.3
poppler 23.07.0 -> 24.04.0
proj 9.3.1 -> 9.4.0
proj-data 1.16 -> 1.17
python3 3.9.18 -> 3.12.3
protobuf-devel 3.13.0 -> 25.3
qca 2.3.1 -> 2.3.8
qscintilla 2.13.4 -> 2.14.1
qt5 5.15.3 -> 5.15.13
qtkeychain 0.13.2 -> 0.14.2
qwc2 20220311-671a6e7 -> 20240408-3d95409
qwt 6.1.6 -> 6.2.0
saga 7.8.2 -> 9.3.1
saga9 9.2.0 -> 99 (transitional; depends on saga)
snappy-devel 1.1.9 -> 1.1.10
spdlog-devel 1.10.0 -> 1.13.0
sqlite3 3.41.1 -> 3.45.1
swig 4.0.2 -> 4.2.1
thrift 0.16.0 -> 0.20.0
transifex-cli 1.6.5 -> 1.6.10
utf8proc 2.7.0 -> 2.9.0
wxwidgets 3.2.1 -> 3.2.4
xerces-c 3.2.3 -> 3.2.5
xz 5.2.5 -> 5.4.5
yarnpkg 1.22.17 -> 1.22.21
zlib 1.2.12 -> 1.3.1
zstd 1.4.5 -> 1.5.5

  Updated Python extensions:
python3-access 1.1.1 -> 1.1.9
python3-affine 2.3.0 -> 2.4.0
python3-alabaster 0.7.12 -> 0.7.16
python3-argon2-cffi 20.1.0 -> 23.1.0
python3-atomicwrites 1.4.0 -> 1.4.1
python3-attrdict 2.0.1 -> python3-attrdict3 2.0.2
python3-attrs 20.2.0 -> 23.2.0
python3-autopep8 2.0.1 -> 2.1.0
python3-babel 2.8.0 -> 2.14.0
python3-backports.entry-points-selectable 1.1.0 -> 1.3.0
python3-beautifulsoup4 4.9.3 -> 4.12.3
python3-bleach 3.2.1 -> 6.1.0
python3-certifi 2020.6.20 -> 2024.2.2
python3-cffi 1.14.3 -> 1.16.0
python3-cftime 1.2.1 -> 1.6.3
python3-chardet 3.0.4 -> 5.2.0
python3-click 7.1.2 -> 8.1.7
python3-cligj 0.7.0 -> 0.7.2
python3-colorama 0.4.4 -> 0.4.6
python3-coverage 5.3 -> 7.4.4
python3-cycler 0.10.0 -> 0.12.1
python3-decorator 4.4.2 -> 5.1.1
python3-defusedxml 0.6.0 -> 0.7.1
python3-distlib 0.3.2 -> 0.3.8
python3-docutils 0.16 -> 0.20.1
python3-entrypoints 0.3 -> 0.4
python3-esda 2.3.1 -> 2.5.1
python3-exifread 2.3.2 -> 3.0.0
python3-filelock 3.0.12 -> 3.13.3
python3-fiona 1.9.5 -> 1.9.6
python3-fonttools 4.28.5 -> 4.51.0
python3-future 0.18.2 -> 1.0.0
python3-gdal 3.8.4 -> 3.8.5
python3-geoalchemy2 0.12.5 -> 0.14.7
python3-geographiclib 1.50 -> 2.0
python3-geopandas 0.14.1 -> 0.14.3
python3-giddy 2.3.3 -> 2.3.5
python3-greenlet 1.1.1 -> 3.0.3
python3-h5py 3.8.0 -> 3.10.0
python3-httplib2 0.18.1 -> 0.22.0
python3-idna 2.10 -> 3.6
python3-imagesize 1.2.0 -> 1.4.1
python3-importlib-metadata 2.0.0 -> 7.1.0
python3-inequality 1.0.0 -> 1.0.1
 

Re: [Qgis-user] Announce - migrate our mailing lists to Discourse

2024-04-03 Thread Jürgen E . Fischer via QGIS-User
Hi Greg,

On Wed, 03. Apr 2024 at 18:23:47 -0400, Greg Troxel via QGIS-User wrote:
> People like me tend not to be happy about things turning into forums and are
> likely to participate less.  As an example, openstreetmap moved from
> mailinglists to forums and I have not, so I interract far far less and spend
> more time on other things.  I am probably somewhat unusual (started doing
> email in the 70s), and here probably only strk thinks I"m normal :-)

Just for the record: I also don't like the move, I also feel the same pain and
I also think you're normal.

To make it worse the advertised discourse mailing list option apparently
doesn't work well - at least for "normal" people (see
https://trac.osgeo.org/osgeo/ticket/3073).


Jürgen

-- 
Jürgen E. Fischer
Dipl.-Inf. (FH)   norBIT GmbH   Tel. +49-4931-918175-31
Software Engineer Rheinstraße 13Fax. +49-4931-918175-50
Geschäftsführer   D-26506 Norden  https://www.norbit.de


signature.asc
Description: PGP signature
___
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] Can´t open my QGIS 3.28 projects

2024-02-29 Thread Jürgen E . Fischer via QGIS-User
Hi Jorge,

On Thu, 29. Feb 2024 at 13:31:07 +, Jorge Matos wrote:
>  Now, it was a surprise to learn that the QGIS projects are somehow linked to
>  drive D. The software and projects are all on drive C, inside the desktop
>  PC.

The environment variable TEMP in your windows user profile is probably pointing
at D:\TMP and most software which is creating temporary files there.  So that
should not affect only QGIS.


Jürgen

-- 
Jürgen E. Fischer
Dipl.-Inf. (FH)   norBIT GmbH   Tel. +49-4931-918175-31
Software Engineer Rheinstraße 13Fax. +49-4931-918175-50
Geschäftsführer   D-26506 Norden  https://www.norbit.de


signature.asc
Description: PGP signature
___
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] Can´t open my QGIS 3.28 projects

2024-02-29 Thread Jürgen E . Fischer via QGIS-User
hi Jorge,

On Thu, 29. Feb 2024 at 11:53:43 +, Jorge Matos via QGIS-User wrote:
> "An error occurred during execution of following code:
> 
> fault_handler_file=open('D:/TMP/qgis-python-crash-info-8744', 'wt')

Did you remove D:/TMP or even D: by any chance?

> After this message, the general window for choosing saved projects appears. 
> When I click on one of them the following message appears;
> Unable to unzip file 'C:/Users/jorge/Documents/QGIS/Degebe/Degebe.qgz'

Maybe also because your %TEMP% points nowhere sensible (anymore)?


Jürgen

-- 
Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Nordenhttps://www.norbit.de
QGIS release manager (PSC)  Germany IRC: jef on Libera|OFTC


signature.asc
Description: PGP signature
___
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] Risk of security vulnerability using older version of QGis

2024-02-27 Thread Jürgen E . Fischer via QGIS-User
Hi Max,

On Tue, 27. Feb 2024 at 18:04:30 +0100, Max via QGIS-User wrote:
> I couldn’t find anything useful about my concerns but obviously this has also
> happened to other QGis users
> (https://www.reddit.com/r/QGIS/comments/s1be86/why_did_qgis_ask_to_record_my_screen/)

But that also gives an sensible explanation - or didn't that also happen to you
when using the color picker?

Otherwise that warning would make sense: QGIS needs to "look" outside it's own
window if you want to pick a color from elsewhere and macOS warns you about
that "recording", because it cannot tell whether the application did that
deliberately or upon your request.

That "screen recording" is related to color picking and mac in some tickets.  
Eg.

https://github.com/qgis/QGIS/issues/48030
https://github.com/qgis/QGIS/issues/51592

So I guess that's ok.  But I've never seen it as I don't use a Mac.


Jürgen

-- 
Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Nordenhttps://www.norbit.de
QGIS release manager (PSC)  Germany IRC: jef on Libera|OFTC


signature.asc
Description: PGP signature
___
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] Donation

2023-11-27 Thread Jürgen E . Fischer via QGIS-User
Hi Ilkka,

On Mon, 27. Nov 2023 at 19:24:43 +0200, Ilkka Haapalinna via QGIS-User wrote:
> I am a bit (a lot) frustrated.
> Tried to download. It was impossible without donating.
> I did donation. I have a reciept of that.
> But could not download?

It doesn't require a donation, but it might take patience.  What did you
actually try to download?   Did you retry?


Jürgen

-- 
Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Nordenhttps://www.norbit.de
QGIS release manager (PSC)  Germany IRC: jef on Libera|OFTC


signature.asc
Description: PGP signature
___
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] [EXT] Problem downloading QGIS 3.34 to macOS 12.7.1 [Marketing Mail]

2023-11-14 Thread Jürgen E . Fischer via QGIS-User
Hi Mike,

On Tue, 07. Nov 2023 at 07:15:36 +, Elstermann, Mike via QGIS-User wrote:
> THX Anita & Andrea!

You're welcome. ;)



Jürgen

-- 
Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Nordenhttps://www.norbit.de
QGIS release manager (PSC)  Germany IRC: jef on Libera|OFTC


signature.asc
Description: PGP signature
___
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] Dataset

2023-10-19 Thread Jürgen E . Fischer via QGIS-User
Hi Sofia,

On Thu, 19. Oct 2023 at 08:45:52 +, Sofia Tridima via QGIS-User wrote:
> I am a new user in QGIS 1.7.4

Um, 1.7.4 is from 2012.  Better use 3.23.3 or 3.28.11.


Jürgen

-- 
Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Nordenhttps://www.norbit.de
QGIS release manager (PSC)  Germany IRC: jef on Libera|OFTC


signature.asc
Description: PGP signature
___
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] Get the translation of a core string in Python

2023-10-05 Thread Jürgen E . Fischer via QGIS-User
Moin Michel,

On Tue, 03. Oct 2023 at 11:04:26 +, Michel Stuyts via QGIS-User wrote:
> In for example the file "qgis_nl.ts" I found the translated value for 
> "Loading Plugins":

You also need to know the context of the translation, ie.:

  
  QObject
  …
> 
> 
> Loading Plugins
> Plug-ins laden
> 
> 
> But I want to use that translation in a Python plugin.  Does anybody know 
> what the way is to get the translation of a core string using Python?

>>> QCoreApplication.translate("QObject", "Loading Plugins")
'Plug-ins laden'


Jürgen

-- 
Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Nordenhttps://www.norbit.de
QGIS release manager (PSC)  Germany IRC: jef on Libera|OFTC


signature.asc
Description: PGP signature
___
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] STEPS TO BUILD FROM SOURCE QGIS DESKTOP INCLUDING ORACLE LIBRARIES

2023-09-29 Thread Jürgen E . Fischer via QGIS-User
Hi Richard,

On Fri, 29. Sep 2023 at 14:39:01 +0200, Richard Duivenvoorde via QGIS-User 
wrote:
> Ubercool! These lines even work on my current Debian Bookworm \o/

Although I'd change the dch line to bookworm-oracle in that case.
 
> One question: the result is:
> qgis-build-deps_3.32.3~sid~oracle1_all.deb
 
> but where does it install after
> sudo dpkg -i qgis-build-deps_3.32.3~sid~oracle1_all.deb
> or
> sudo gdebi qgis-build-deps_3.32.3~sid~oracle1_all.deb
> 
> I could not find it in /usr/bin. I can only find it in the
> qgis-3.32.3~sid~oracle1/debian/build/output/bin/qgis
> or
> qgis-3.32.3~sid~oracle1/debian/qgis/usr/bin/qgis
> 
> should it not be installed on the user's disk?

Sure, because that is the actual result (or the main part of it).

qgis-build-deps is just an empty package from mk-build-deps that depends on all
packages which qgis needs to build.   So it installing what apt-get build-dep
would, just for the dependencies of the current source (listed in
debian/control) and not the package in the repository.

> PS: I think this deserves a place in the (linux specific) docs ( while it is
> working :-) )...

ack. ;)


Jürgen

-- 
Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Nordenhttps://www.norbit.de
QGIS release manager (PSC)  Germany IRC: jef on Libera|OFTC


signature.asc
Description: PGP signature
___
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] STEPS TO BUILD FROM SOURCE QGIS DESKTOP INCLUDING ORACLE LIBRARIES

2023-09-29 Thread Jürgen E . Fischer via QGIS-User
Hi Fredy,

On Thu, 28. Sep 2023 at 14:32:26 +, Fredy Varon via QGIS-User wrote:
> Anyone has the steps to build and compile qgis desktop on Linux Ubuntu to
> permits Access to Oracle databases

sudo apt install devscripts alien
curl -JLO 
https://download.oracle.com/otn_software/linux/instantclient/2111000/oracle-instantclient-devel-21.11.0.0.0-1.el8.x86_64.rpm
curl -JLO 
https://download.oracle.com/otn_software/linux/instantclient/2111000/oracle-instantclient-basiclite-21.11.0.0.0-1.el8.x86_64.rpm
fakeroot alien oracle-instantclient-devel-21.11.0.0.0-1.el8.x86_64.rpm 
oracle-instantclient-basiclite-21.11.0.0.0-1.el8.x86_64.rpm
sudo dpkg -i oracle-instantclient-devel_21.11.0.0.0-2_amd64.deb 
oracle-instantclient-basiclite_21.11.0.0.0-2_amd64.deb

curl -JLO https://download.qgis.org/downloads/qgis-3.32.3.tar.bz2
tar xjf qgis-3.32.3.tar.bz2
cd qgis-3.32.3
sed -i -e "s#18.5#21#" debian/rules
sed -i -e "s#12.1##" debian/control.in
dch -l ~sid~oracle --force-distribution --distribution sid-oracle "sid build 
with oracle"
debian/rules templates
sudo mk-build-deps -i
dpkg-buildpackage -us -uc -b


Jürgen

-- 
Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Nordenhttps://www.norbit.de
QGIS release manager (PSC)  Germany IRC: jef on Libera|OFTC


signature.asc
Description: PGP signature
___
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] Sicherheitslücke [ CVE-2023-36664 ] Ghostscript in Qgis?

2023-07-19 Thread Jürgen E . Fischer via QGIS-User
Hi Andreas,

On Wed, 19. Jul 2023 at 13:57:21 +0200, Andreas Neumann via QGIS-User wrote:
> How did you install QGIS? Through the OSGeo4W installer or with the
> standalone installer or .msi installer?

Both contain ghostscript as dependency of GRASS.   OSGeo4W was updated to
10.01.2.


Jürgen

-- 
Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Nordenhttps://www.norbit.de
QGIS release manager (PSC)  Germany IRC: jef on Libera|OFTC


signature.asc
Description: PGP signature
___
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] Problems with installation QGIS Server 3.28.5 on Ubuntu 22.04.

2023-04-22 Thread Jürgen E . Fischer via QGIS-User
Moin Günter,

On Fri, 21. Apr 2023 at 18:38:06 +0200, G. Wagner, Wagner-IT via QGIS-User 
wrote:
> I have problems installing QGIS Server 3.28.5 on Ubuntu 22.04. (Hetzner Cloud 
> Server [1]):
> I proceed accordingly [2]. But with "sudo apt install qgis-server 
> --no-install-recommends --no-install-suggests " I receive:
 
> gw@CAX11-2204:~$ sudo apt install qgis-server --no-install-recommends 
> --no-install-suggests
> Reading package lists... Done
> Building dependency tree... Done
> Reading state information... Done
> Some packages could not be installed. This may mean that you have
> requested an impossible situation or if you are using the unstable
> distribution that some required packages have not yet been created
> or been moved out of Incoming.
> The following information may help to resolve the situation:
> 
> The following packages have unmet dependencies:
>  python3-qgis : Depends: python3-qgis-common (= 3.22.4+dfsg-3build1) but it 
> is not going to be installed
>  qgis-providers : Depends: qgis-providers-common (= 3.22.4+dfsg-3build1) but 
> 1:3.28.5+36jammy is to be install
> E: Unable to correct problems, you have held broken packages.

qgis-server and python3-qgis share dependencies.  You need to upgrade
python3-qgis too or remove it.  Or remove all qgis packages before switch from
stock ubuntu packages to qgis.org packages.


Jürgen

-- 
Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Nordenhttps://www.norbit.de
QGIS release manager (PSC)  Germany IRC: jef on Libera|OFTC


signature.asc
Description: PGP signature
___
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] QGIS LTR GDAL version

2023-03-29 Thread Jürgen E . Fischer via QGIS-User
Moin Klaus

On Wed, 29. Mar 2023 at 11:10:01 +0200, Klaus Mithöfer via QGIS-User wrote:
> i use QGIS 3.28.4 on Linux and Windows. On Linux QGIS comes with GDAL 3.4.1,
> on windows with 3.6.2. Why is that and is it possible to upgrade on Linux? I
> use the standard installation for QGIS.

There is no standard for QGIS installations ;)

We don't ship GDAL with QGIS on Debian/Ubuntu, but build with the available 
version of the distribution.   

You are apparently on jammy - ubuntugis has GDAL 3.6.2 for jammy.
Ubuntu lunar has 3.6.2 natively.


Jürgen

-- 
Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Nordenhttps://www.norbit.de
QGIS release manager (PSC)  Germany IRC: jef on Libera|OFTC


signature.asc
Description: PGP signature
___
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] QGIS (OGR) updating ESRI file geodatabases

2023-02-27 Thread Jürgen E . Fischer via QGIS-User
Hi Chris,

On Mon, 27. Feb 2023 at 12:33:31 -0800, chris hermansen via QGIS-User wrote:
> So I fired up QGIS 3.28 running on Ubuntu 22.10 and opened an ArcGIS 9.3
> created file geodatabase and, sure enough, could not edit it.
> 
> I then checked the About QGIS page which indicates the GDAL/OGR version is
> 3.5.1 and I see reading further on the GDAL page linked above that the
> "Create" functionality is new in 3.6.
> 
> Therefore, I'm wondering when we might see this surfaced in QGIS.  Can
> anyone on this list give me an idea as to when this wonderful event might
> occur?

QGIS uses what your distribution offers.

Ubuntu lunar has GDAL 3.6.2 - kinetic only 3.5.1.  (see 
https://packages.ubuntu.com/search?keywords=gdal=names=all=all)
ubuntugis has GDAL 3.6.2 for jammy - but not for non-lts kinetic (see 
https://launchpad.net/~ubuntugis/+archive/ubuntu/ubuntugis-unstable/+packages?field.name_filter=gdal_filter=published_filter=)


Jürgen

-- 
Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Nordenhttps://www.norbit.de
QGIS release manager (PSC)  Germany IRC: jef on Libera|OFTC


signature.asc
Description: PGP signature
___
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] QGIS - Questions

2023-02-15 Thread Jürgen E . Fischer via QGIS-User
Hi Jonathan,

On Wed, 15. Feb 2023 at 19:48:20 +, Jonathan Rabenasolo via QGIS-User wrote:
> I'm working on some projects with a large group of people, and I'm wondering
> if It's possible to assign some admins to a QGIS file. To be more precise, I
> want to allow editing ONLY for admins, and other people can ONLY view the
> project.

Doesn't assigning corresponding file permissions do the job?


Jürgen

PS: please don't cross post user question to -developer and -psc.

-- 
Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Nordenhttps://www.norbit.de
QGIS release manager (PSC)  Germany IRC: jef on Libera|OFTC


signature.asc
Description: PGP signature
___
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] Doubt with qgis_projects table

2023-02-12 Thread Jürgen E . Fischer via QGIS-User
Hi Jorge,

On Sun, 12. Feb 2023 at 17:18:20 +, Jorge Lopez via QGIS-User wrote:
> What I presume is that I need the way that column was generated, Martin
> Dobias created this in the core qgis and maybe he can provide some light on
> this.

The content column contains the qgz file.  To decode and update it you could do
something like this:

from PyQt5.QtCore import QByteArray
from PyQt5.QtSql import QSqlDatabase, QSqlQuery, QSql
from io import BytesIO
from zipfile import ZipFile, ZIP_DEFLATED

db = QSqlDatabase.addDatabase("QPSQL")
db.setConnectOptions("service=…")
db.open()

q = QSqlQuery(db)
q.exec_("SELECT content,metadata,name FROM qgis_projects WHERE 
name='project-name'")
q.next()

inzip = BytesIO(q.value(0))
outzip = BytesIO()

metadata = q.value(1)
name = q.value(2)

iz = ZipFile(inzip)
oz = ZipFile(outzip, mode='w', compression=ZIP_DEFLATED)

for m in iz.namelist():
data = iz.read(m)
if m.endswith(".qgs"):
data = data.decode('UTF-8')

# modify projects XML in data

oz.writestr(m, data.encode("UTF-8"))
else:
oz.writestr(m, data)

oz.close()

q.prepare("UPDATE qgis_projects SET content=:content,metadata=:metadata WHERE 
name=:name")
v = QByteArray(outzip.getvalue())
q.bindValue(":content", v, QSql.In | QSql.Binary)
q.bindValue(":metadata", metadata)
q.bindValue(":name", name)
q.exec_()


Jürgen

-- 
Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Nordenhttps://www.norbit.de
QGIS release manager (PSC)  Germany IRC: jef on Libera|OFTC


signature.asc
Description: PGP signature
___
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] QGIS V3.22.14 LEGEND Default PATCHES

2023-02-10 Thread Jürgen E . Fischer via QGIS-User
Hi,

qgis-user-owner is only for administrative purposes.  Please subscribe to the
mailing list and post to qgis-user@lists.osgeo.org.


Jürgen

-- 
Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Nordenhttps://www.norbit.de
QGIS release manager (PSC)  Germany IRC: jef on Libera|OFTC


signature.asc
Description: PGP signature
norBIT Gesellschaft fuer Unternehmensberatung und Informationssysteme mbH
Rheinstrasse 13, 26506 Norden
GF: Juergen Fischer, Nils Kutscher HR: Amtsgericht Aurich HRB 100827
Datenschutzerklaerung: https://www.norbit.de/83/
___
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] QGIS for Windows with GSS/Kerberos/Active Directory

2023-02-04 Thread Jürgen E . Fischer via QGIS-User
Hi Tomas,

On Fri, 03. Feb 2023 at 16:41:28 +0100, Tomas Pospisek via QGIS-User wrote:
> So it seems QGIS as shipped by qgis.org does not ship with GSS support? Is
> that correct?

Yes.

> Does anybody use QGIS on Windows with GSS?

Apparently not.


> Any pointers/suggestions/help?
 
Please try libpq 15.1-1 from OSGeo4W (choose "Advanced Install" and enable
Exp.)


Jürgen

-- 
Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Nordenhttps://www.norbit.de
QGIS release manager (PSC)  Germany IRC: jef on Libera|OFTC


signature.asc
Description: PGP signature
___
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] Mac problem

2023-01-27 Thread Jürgen E . Fischer via QGIS-User
Hi John,

On Thu, 26. Jan 2023 at 15:12:39 +, John Layt via QGIS-User wrote:
> Apple has some extra security checks when running apps for the very first
> time. If the app is signed with a developer certificate purchased from
> Apple, then you can just double-click to run the app and it gets approved.
> If the app is not signed, as in the case of QGIS, then you need to manually
> approve the app by first right-clicking on the app and selecting Open from
> the context menu. The Option key is not required. Note that on Macs, the
> right-click is not enabled by default, so you might need to enable that
> first in the System Preferences.
> 
> I seem to recall the association was trying to obtain a
> developers certificate? Has there been any progress on that?

AFAIK we have such a certificate and the installer is signed, but after that
Apple decided that the app also has to be notarized - which we don't do yet.


Jürgen

-- 
Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Nordenhttps://www.norbit.de
QGIS release manager (PSC)  Germany IRC: jef on Libera|OFTC


signature.asc
Description: PGP signature
___
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] QGIS Error qgis_app.dll

2022-12-13 Thread Jürgen E . Fischer via QGIS-User
Hi Marvin.

On Tue, 13. Dec 2022 at 11:34:29 +, Kinberger, Marvin via QGIS-User wrote:
> I've got a solution. it was because of the tiledb.dll. I had version 2.8.2-1
> installed on our system. after an update to 2.8.2-3 the error was fixed.
> Thanks for the support especially to Jürgen.

ah, old issue - https://github.com/qgis/QGIS/issues/49148


Jürgen

-- 
Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Nordenhttps://www.norbit.de
QGIS release manager (PSC)  Germany IRC: jef on Libera|OFTC


signature.asc
Description: PGP signature
___
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] QGIS Error qgis_app.dll

2022-12-07 Thread Jürgen E . Fischer via QGIS-User
Hi Marvin,

On Wed, 07. Dec 2022 at 16:08:51 +, Kinberger, Marvin via QGIS-User wrote:
> I have now placed an opencl.dll in the bin directory of the qgis
> installation. Unfortunately without success. the error keeps coming.

> Based on the evaluation with depends.exe, I can also see that the opencl.dll
> from the system32 directory is being used. this shows the log.  I also do not
> recognize any dll in the log that is somehow conspicuous or missing.  does
> anyone have a hint?

Doesn't look like there's a DLL missing - but maybe there's an incompatible
one.  The opencl.dll present in system32 is still used.  You could try to
rename it and recheck and updated it with the version in OSGeo4W (as the
installer probably would; see also https://github.com/qgis/QGIS/issues/44806).


Jürgen
 
-- 
Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Nordenhttps://www.norbit.de
QGIS release manager (PSC)  Germany IRC: jef on Libera|OFTC


signature.asc
Description: PGP signature
___
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] QGIS Error qgis_app.dll

2022-12-07 Thread Jürgen E . Fischer via Qgis-user
Hi Marvin,

On Wed, 07. Dec 2022 at 09:22:21 +, Kinberger, Marvin via Qgis-user wrote:
> Hi, I have a problem with a central QGIS installation. I installed QGIS on a
> network drive using the OSGeo4W installer. Some clients can work with it
> without problems. On others, however, an error occurs when starting QGIS.

> "Could not load qgis_app.dll"
> I have already checked all the information in the qgis-ltr-bin.env.

https://github.com/qgis/QGIS/issues/26891#issuecomment-495889169

opencl.dll might be an issue - if the machine you installed on/from has a newer
opencl.dll in system32 it's removed from OSGeo4W, but might be missing on some
clients.


Jürgen

-- 
Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Nordenhttps://www.norbit.de
QGIS release manager (PSC)  Germany IRC: jef on Libera|OFTC


signature.asc
Description: PGP signature
___
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] Missing python plugin support on Win7

2022-11-26 Thread Jürgen E . Fischer via Qgis-user
Hi Antonio,

On Sat, 26. Nov 2022 at 06:29:43 +0100, Antonio Valanzano via Qgis-user wrote:
> Does it depend on the version of my os  or on the fact that I am using an
> italian version of Win7?
> Could it be this  row:   set v=%v:*[Version =%   ?

Correct.  The output is not the expected "Version" but "Versione".


Jürgen

-- 
Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Nordenhttps://www.norbit.de
QGIS release manager (PSC)  Germany IRC: jef on Libera|OFTC


signature.asc
Description: PGP signature
___
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] Missing python plugin support on Win7

2022-11-25 Thread Jürgen E . Fischer via Qgis-user
On Fri, 25. Nov 2022 at 23:29:11 +0100, Antonio Valanzano via Qgis-user wrote:
> I have reinstalled the sw version 3.22.13-Białowieża using the Express
> Install
> and I noticed that in the bin folder the patch for Win 7 was named
> api-ms-win-core-path-l1-1-0.dll.w7
> and that misspelled name caused the problem of the missing python plugin
> support.

Please check why etc/postinstall/api-ms-win-core-path-l1-1-0.bat, which should
do that rename on Windows 7, fails for you.

What output do you get from ver in cmd?


Jürgen

-- 
Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Nordenhttps://www.norbit.de
QGIS release manager (PSC)  Germany IRC: jef on Libera|OFTC


signature.asc
Description: PGP signature
___
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] Missing python plugin support on Win7

2022-11-25 Thread Jürgen E . Fischer via Qgis-user
Hi Antonio,

On Fri, 25. Nov 2022 at 08:07:04 +0100, Antonio Valanzano via Qgis-user wrote:
> So in Win7 is not possible to use any plugin apart from these 3

Your Win7.  On others it apparently works fine (general python support
including the plugin manager at least).  Anything in your logs?


Jürgen

-- 
Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Nordenhttps://www.norbit.de
QGIS release manager (PSC)  Germany IRC: jef on Libera|OFTC


signature.asc
Description: PGP signature
___
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] QGIS-Server How to avoid unique data check in postgis for each session

2022-11-16 Thread Jürgen E . Fischer via Qgis-user
Hi Amedeo,

On Wed, 16. Nov 2022 at 14:18:57 +0100, Amedeo Fadini via Qgis-user wrote:
> SELECT count(distinct ("id","field1"))=count(("id","field1")) FROM
> "public"."mytable"

Check  "use estimated table metadata" in the connection before adding the
layer.


Jürgen


-- 
Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Nordenhttps://www.norbit.de
QGIS release manager (PSC)  Germany IRC: jef on Libera|OFTC


signature.asc
Description: PGP signature
___
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] QGIS on Windows 7

2022-11-09 Thread Jürgen E . Fischer via Qgis-user
Hi Jonathan,

On Wed, 09. Nov 2022 at 09:39:29 +0100, Jonathan Moules via Qgis-user wrote:
> > QGIS requires Windows 8 64 bit or higher because QGIS uses Python 3.9 or
> > later, which is not available for Windows 7
 
> What's the last version that will work on Windows 7? Ideally an LTS.
 
> Also, given there are still many millions of Windows 7 users out there, it
> may be worth linking to it explicitly as well.

Try installing from OSGeo4W, but include the api-ms-win-core-path-HACK package.
That should make python work on Windows 7 again (but still only 64bit).


Jürgen

-- 
Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Nordenhttps://www.norbit.de
QGIS release manager (PSC)  Germany IRC: jef on Libera|OFTC


signature.asc
Description: PGP signature
___
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] query for Virtual Layer in relation to another layer

2022-11-04 Thread Jürgen E . Fischer via Qgis-user
Moin Uwe,

On Fri, 04. Nov 2022 at 13:59:35 +0100, Uwe Fischer wrote:
> great - it works as expected!! Thank you!
> How can I find out about the engine that is used and the SQL syntax for
> virtual layers? I'd like to learn about it to be able to build more queries
> like this one.

Well, || is the standard syntax, but there are probably also databases that
will take + to concatenate strings too.  It's SQLite:

https://docs.qgis.org/3.28/en/docs/user_manual/managing_data_source/create_layers.html#supported-query-language

14.2.5.2. Supported query language

The underlying engine uses SQLite and SpatiaLite to operate.


Jürgen
 
-- 
Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Nordenhttps://www.norbit.de
QGIS release manager (PSC)  Germany IRC: jef on Libera|OFTC


signature.asc
Description: PGP signature
___
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] query for Virtual Layer in relation to another layer

2022-11-04 Thread Jürgen E . Fischer via Qgis-user
On Fri, 04. Nov 2022 at 12:32:29 +0100, Uwe Fischer via Qgis-user wrote:
> On Montag, 24. Oktober 2022 15:32, Reetz, Michael (NLPV) wrote:
> > you could try this:
> > select * from my_lines l join my_polys p on l.my_line_attribute like '%' + 
> > p.my_poly_attribute + '%'

> sorry for the delay, I had some days out of office.
> The query you sent is working (that is: no error message), but the resulting 
> virtual layer is empty. Are there other ideas?

Not sure which engine virtual layers actually use, but I'd try || instead of + 

As in

sqlite> select '%' || 'foo' || '%';
%foo%

instead of

sqlite> select '%' + 'foo' + '%';
0


Jürgen

-- 
Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Nordenhttps://www.norbit.de
QGIS release manager (PSC)  Germany IRC: jef on Libera|OFTC


signature.asc
Description: PGP signature
___
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] ogr2ogr doesn't connect to MS SQL Server

2022-10-20 Thread Jürgen E . Fischer via Qgis-user
Hi,

On Thu, 20. Oct 2022 at 16:29:02 +0200, Jürgen E. Fischer wrote:
> QGIS has a native MSSQL provider and doesn't need GDAL/OGR with MSSQL support.
> But you can install gdal-mss (from OSGeo4W setup; also included in the
> standalone) to add that.

BTW that's probably new in OSGeo4W since the switch to GDAL 3.5.  Earlier
MSSQL support was also built in and the plugin would just add support for bulk
copy.


Jürgen
 
-- 
Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Nordenhttps://www.norbit.de
QGIS release manager (PSC)  Germany IRC: jef on Libera|OFTC


signature.asc
Description: PGP signature
___
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] ogr2ogr doesn't connect to MS SQL Server

2022-10-20 Thread Jürgen E . Fischer via Qgis-user
Hi Michael,

On Wed, 19. Oct 2022 at 10:49:35 +, Reetz, Michael (NLPV) via Qgis-user 
wrote:
> we are using MS SQL Server 2019 as basis for Geoserver and GIS software.
> There are a lot of tables that have attributes of the types geometry and/or
> geography. I can load these tables into QGIS (3.22.8) projects without any
> problems.

QGIS has a native MSSQL provider and doesn't need GDAL/OGR with MSSQL support.
But you can install gdal-mss (from OSGeo4W setup; also included in the
standalone) to add that.

> Now I'm asked to add an geography attribute to one table that has already an
> geometry attribute and populate it with coordinates by transforming the
> geometry values

I would have thought that would be a two liner in SQL.  But I wasn't awar that
MSSQL doesn't have st_transform - if that's still the case.  But you can also
do the second step in QGIS.

Suppose you have a table foo with a geometry column, via browser add a
geography column using execute SQL:

ALTER TABLE foo ADD geog geography

Add the layer with the original geometry column and execute in field calculator 
to the
geog field:

geom_to_wkt(transform($geometry, 'EPSG:25832', 'EPSG:4326'))


Jürgen

-- 
Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Nordenhttps://www.norbit.de
QGIS release manager (PSC)  Germany IRC: jef on Libera|OFTC


signature.asc
Description: PGP signature
___
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] problem

2022-10-06 Thread Jürgen E . Fischer via Qgis-user
Hi Nilo,

On Thu, 06. Oct 2022 at 13:53:50 -0300, Nilo Cesar Coelho via Qgis-user wrote:
> How to solve this problem?
> 
> []

Did you verify that your download is correct?  There's checksum next to it.

cmd> curl -L https://download.qgis.org/downloads/QGIS-OSGeo4W-3.26.3-1.sha256sum
cabacaf3fc159c0324a3c0414e12b9600644d2b373149a80c88fab3bd88f983c 
*QGIS-OSGeo4W-3.26.3-1.msi
cmd> certutil -hashfile QGIS-OSGeo4W-3.26.3-1.msi SHA256
SHA256-Hash von QGIS-OSGeo4W-3.26.3-1.msi:
cabacaf3fc159c0324a3c0414e12b9600644d2b373149a80c88fab3bd88f983c
CertUtil: -hashfile-Befehl wurde erfolgreich ausgeführt.


Jürgen

-- 
Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Nordenhttps://www.norbit.de
QGIS release manager (PSC)  Germany IRC: jef on Libera|OFTC


signature.asc
Description: PGP signature
___
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] Latest development version of QGIS as a .msi standalone installer ?

2022-08-17 Thread Jürgen E . Fischer via Qgis-user
Hi Bo,

On Wed, 17. Aug 2022 at 10:48:00 +0200, Bo Victor Thomsen via Qgis-user wrote:
> So is there a http- or ftp- location where I can download the QGIS
> development version as a msi package ?

No, the nightlies are not packaged as msi.  But you could use
scripts/createmsi.pl[1] to make one.  See msis.sh[1] for an example use (but
you'd need to skip the signing parts as the signing certificate is not public).


Jürgen

[0] https://github.com/jef-n/OSGeo4W/blob/master/scripts/createmsi.pl
[1] https://github.com/jef-n/OSGeo4W/blob/master/scripts/msis.sh


-- 
Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Nordenhttps://www.norbit.de
QGIS release manager (PSC)  Germany IRC: jef on Libera|OFTC


signature.asc
Description: PGP signature
norBIT Gesellschaft fuer Unternehmensberatung und Informationssysteme mbH
Rheinstrasse 13, 26506 Norden
GF: Juergen Fischer, Nils Kutscher HR: Amtsgericht Aurich HRB 100827
Datenschutzerklaerung: https://www.norbit.de/83/
___
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] OSGeo4W Shell with Unix-Style Terminal?

2022-07-07 Thread Jürgen E . Fischer via Qgis-user
Hi Mike,

On Thu, 07. Jul 2022 at 17:31:26 -0400, Mike Treglia wrote:
> So I've added the below to my profile (from the link you've previously
> shared), and I can run 'fetchenv /c/OSGeo4W/bin/o4w_env.bat' from my bash
> terminal - and it starts the process, but it either is getting hung up, or
> is just taking longer than I anticipated - is it something that does take
> some time and I just need to let it run, so be patient? Or am I maybe
> missing or need to adjust something else?

Not sure - I use cygwin's bash and with that it works.  Other shells might
behave differently.

msys for instance has problems with plain /c in the cmd call and needs //c (see
https://github.com/OSGeo/grass/blob/main/mswindows/osgeo4w/package.sh#L33)

Try set -x to get some more insight what it does and where it hangs.  It might
take a few seconds, but no minute.


Jürgen

-- 
Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Nordenhttps://www.norbit.de
QGIS release manager (PSC)  Germany IRC: jef on Libera|OFTC


signature.asc
Description: PGP signature
___
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] OSGeo4W Shell with Unix-Style Terminal?

2022-07-07 Thread Jürgen E . Fischer via Qgis-user
Hi Mike,

On Thu, 07. Jul 2022 at 12:20:52 -0400, Mike Treglia wrote:
> I think I might be missing some of the knowledge I need to implement this
> for now, which is alright. For example, I'm not sure where I should start
> adjusting things in that portion of the build_helpers script, and
> where/when I should run that, or if I'm should modify that portion of
> build_helpers (ln 107-143) and insert that into /c/OSGeo4W/bin/o4w_env.bat,
> such that the OSGeo4W.bat file will call on the desired environment.

Sorry, I was implying that you're shell savy and pointers were enough.
Copy fetchenv to your .profile and run it from there (or once you want to run
osgeo4w stuff).

…
fetchenv() {
…   
}

fetchenv /c/OSGeo4W/bin/o4w_env.bat
…

It runs cmd to get a clean copy of the environment and once more with
o4w_env.bat to get the updated version and then works out the differences,
makes them shell digestable and sources them to the running shell.

Also works with other software that provides batch files to update the
environment (like msvc, strawberry perl, venvs in python - just to name the few
the osgeo4w build scripts use it for).


Jürgen

-- 
Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Nordenhttps://www.norbit.de
QGIS release manager (PSC)  Germany IRC: jef on Libera|OFTC


signature.asc
Description: PGP signature
___
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] Issues with dependencies for Ubuntu 22.04

2022-07-07 Thread Jürgen E . Fischer via Qgis-user
Hi Vincente,

On Thu, 07. Jul 2022 at 14:29:18 +, vicentesmith via Qgis-user wrote:
> I'm trying to install QGIS in a fresh Ubuntu 22.04 system. Before building
> QGIS, I'm installing the dependencies from
> https://github.com/qgis/QGIS/blob/master/INSTALL.md#33-install-build-dependencies
> for jammy. At some point during the process, the system asked which services
> to restart so I left the default ones (packagekit, palkit, rsyslog, ssh,
> systemd-journal, systemd-manager, systemd-networkd, systemd-resolved).
> Everything seemed OK at the end but rebooting the system froze everything and
> I cannot even log in.

> NOTE: I also tried using apt to install QGIS directly. This time, there was
> no problem but it installed v3.22.4.  Thanks.

Not sure if I get your point.  Are you trying to build or run QGIS?

To run it you don't need the build dependencies.  Installing them
should however still not lead to a login failure.  But as you're not even
installing QGIS, that's not an QGIS issue.

If you don't use the qgis.org repository (or ubuntugis) you get the version of
QGIS jammy offers - and that is 3.22.4 (see
https://packages.ubuntu.com/search?keywords=qgis=names=jammy=all)


Jürgen

-- 
Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Nordenhttps://www.norbit.de
QGIS release manager (PSC)  Germany IRC: jef on Libera|OFTC


signature.asc
Description: PGP signature
___
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] OSGeo4W Shell with Unix-Style Terminal?

2022-07-07 Thread Jürgen E . Fischer via Qgis-user
Hi Mike,

On Thu, 07. Jul 2022 at 10:08:21 -0400, Mike Treglia via Qgis-user wrote:
> I was hoping to use the OSGeo4W shell from a unix-style terminal - like git
> bash or similar. For some things, in the past, I've added the directory
> with binaries from the OSGeo4W install to my Windows Environment System
> Variables for as a value in Path.

Adapt fetchenv
https://github.com/jef-n/OSGeo4W/blob/master/scripts/build-helpers#L107 to your
shell and fetchenv /c/OSGeo4W/bin/o4w_env.bat.  That way you should get all
veriables the batch files setup into your environment.


Jürgen

-- 
Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Nordenhttps://www.norbit.de
QGIS release manager (PSC)  Germany IRC: jef on Libera|OFTC


signature.asc
Description: PGP signature
___
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] Burned by QGIS again - Windows 10 QGIS 3.22.8

2022-07-07 Thread Jürgen E . Fischer via Qgis-user
Hi,

On Thu, 07. Jul 2022 at 06:13:49 +0200, Andrea Giudiceandrea via Qgis-user 
wrote:
> has reported in [1], [2] and [3], the issue only occurred on Windows systems
> with CPU not supporting the AVX2 instruction set extension.

which was even executed initializing of the tiledb support, which was happening
on load of GDAL and in turn qgis and crssync and hence broke the whole show on
those machines.  Otherwise hardly anyone would have noticed that tiledb was
added at all.

I guess there can always be such subtle things that slip through.


Jürgen

-- 
Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Nordenhttps://www.norbit.de
QGIS release manager (PSC)  Germany IRC: jef on Libera|OFTC


signature.asc
Description: PGP signature
___
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] Burned by QGIS again - Windows 10 QGIS 3.22.8

2022-07-06 Thread Jürgen E . Fischer via Qgis-user
Hi,

On Wed, 06. Jul 2022 at 13:10:58 +0200, Andrea Giudiceandrea via Qgis-user 
wrote:
> Just some minutes ago a new version of the Standalone Installers, containing
> the fix, for both QGIS 3.22.8 and QGIS 3.26.0, was released.
> 
> The new Standalone Installers are:
> - QGIS-OSGeo4W-3.22.8-4.msi
> https://download.qgis.org/downloads/QGIS-OSGeo4W-3.22.8-4.msi
> - QGIS-OSGeo4W-3.26.0-4.msi
> https://download.qgis.org/downloads/QGIS-OSGeo4W-3.26.0-4.msi

And in a few minutes more the download links on the website will be uptodate in
all languages.


Jürgen

-- 
Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Nordenhttps://www.norbit.de
QGIS release manager (PSC)  Germany IRC: jef on Libera|OFTC


signature.asc
Description: PGP signature
___
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] Burned by QGIS again - Windows 10 QGIS 3.22.8

2022-07-06 Thread Jürgen E . Fischer via Qgis-user
Hi,

On Wed, 06. Jul 2022 at 13:20:00 +0200, Jürgen E. Fischer wrote:
> And in a few minutes more the download links on the website will be uptodate 
> in
> all languages.

And the osuosl mirror will probably update soon too.


Jürgen

-- 
Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Nordenhttps://www.norbit.de
QGIS release manager (PSC)  Germany IRC: jef on Libera|OFTC


signature.asc
Description: PGP signature
___
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] Mac OS QGIS installer 3.16

2022-04-21 Thread Jürgen E . Fischer via Qgis-user
Hi Sebastian,

On Thu, 21. Apr 2022 at 05:43:52 -0400, Sebastian Gutwein via Qgis-user wrote:
> I have a student that is trying to install QGIS on her Mac OS. Neither the
> latest or the long term version are working for some reason. In the fall
> she had 3.16 installed and wanted to try to install it again in case there
> was an issue with the latest version. However we can't seem to find 3.16 in
> the official repository. I would assume because it was after the switch
> from the KyngChaos builds they would be in the QGIS repository here:
> https://download.qgis.org/downloads/macOS/ but I only see up to 3.8. Should
> I then point her to the KyngChaos version?

No, that's where kyngchaos used to put his builds. 

The automatic builds land under 

https://download.qgis.org/downloads/macos/ 

Old versions are in

https://download.qgis.org/downloads/macos/pr/

or 

https://download.qgis.org/downloads/macos/ltr/



Jürgen

-- 
Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Nordenhttps://www.norbit.de
QGIS release manager (PSC)  Germany IRC: jef on Libera|OFTC


signature.asc
Description: PGP signature
___
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