Re: [Qgis-user] Can't access Oracle sequences
Hi Sylvain, On Mon, 16. Mar 2015 at 18:01:35 +0100, PIERRE Sylvain wrote: With Postgis/QGIS configuration I can manage sequences on primary key when editing new object (editing forms show a nextval(‘xx’::regclass) formula in pk field) With my Oracle/QGIS conf I can’t manage sequences, and editing failed when I want to save. Where is the problem? Is it an Oracle provider issue ? Not really. In PostgreSQL the sequence value is retrieved by a default expression. In Oracle sequences used to be retrieved and assigned to the new record using a before insert trigger. But in Oracle 12c you can also use default values to retrieve and assign the next sequence value. I suppose that works in QGIS too, but I don't currently have setup a 12c to verify. So unless you have 12c with a default value, you have to have a trigger to deal with assigning the key value. 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 Norden http://www.norbit.de QGIS release manager (PSC) GermanyIRC: jef on FreeNode signature.asc Description: Digital signature ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] QGIS on WinXP
Has anyone been able to install any of the last several versions of QGIS on WinXP? If so, how? ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] QGIS on WinXP
Hi, I installed 2.6.1 on XP two weeks ago using the OSGEO4W install without problem.nbsp; Make sure you are using the 32 bit version as Window XP is 32 bit. (Unless you have a rare 64bit version). If you are having problems with the installation, please add info. Nicolas Cadieux M.Sc. Les Entreprises Arch#233;otec inc.#160; 8548, rue Saint-Denis Montr#233;al H2P 2H2 T#233;l#233;phone:#160;514.381.5112 #160;Fax: 514.381.4995 www.archeotec.ca Le 2015-03-16 18:09, quot;geoff carver [via OSGeo.org]quot; lt;ml-node+s1560n5193731...@n6.nabble.comgt; a écrit : Has anyone been able to install any of the last several versions of QGIS on WinXP? If so, how? ___ Qgis-user mailing list [hidden email] http://lists.osgeo.org/mailman/listinfo/qgis-user If you reply to this email, your message will be added to the discussion below: http://osgeo-org.1560.x6.nabble.com/QGIS-on-WinXP-tp5193731.html To start a new topic under Quantum GIS - User, email ml-node#43;s1560n4125267h38#64;n6.nabble.com To unsubscribe from Quantum GIS - User, click here . NAML -- View this message in context: http://osgeo-org.1560.x6.nabble.com/QGIS-on-WinXP-tp5193731p5193744.html Sent from the Quantum GIS - User mailing list archive at Nabble.com.___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] QGIS tracking/fieldwork application
Try googling Roam QGIS. Roam is a new skin aka user interface (and more) for QGIS, enabling it to function better on a windows tablet. Regards Bo Victor Thomsen AestasGIS Denmark Den 16-03-2015 kl. 08:54 skrev Leo Kris Palao: Hi QGIS Users, Good day! I watched the live tracking video of QGIS in https://www.youtube.com/watch?v=0WevRW4tbzst=253 (Live Tracking and sampling with Quantum GIS, a tablet PC and a Bluetooth datalogger) I am interested to the same. I am particularly interested on how I can customize my forms such that when I digitize a point, I can use drop down menu options, combo box, etc. If you could point me in the right direction (blogs, websites), will be very helpful. Thanks, -Leo ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Line symbols with edge along the line and without edge at the ends?
Line symbols with edge along the line and without edge at the ends? Left NOT OK, Right OK [cid:image002.jpg@01D05FD6.9885A5C0] THX, mikeE. oledata.mso Description: oledata.mso ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Line symbols with edge along the line and without edge at the ends?
Hi, This is possible. Make sure that you enable symbol levels (button Advanced - Symbol levels at the lower right of the symbology dialogue) and set the line endings to flat (not square or round). Andreas On 16.03.2015 10:47, Elstermann, Mike wrote: Line symbols with edge along the line and without edge at the ends? Left NOT OK, Right OK THX, mikeE. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Oracle connection Timeout
We have a QGIS installation running with a Oracle 12 Database. If we open the Qgis Oracle Connection window and set up a connection without saving our username and password, then click on the connect button, and then add any table to qgis, our DBA gets the error below: We are experiencing the same problem whether we are connecting from our QGIS 2.2 installation on Linux or our QGIS 2.6 installation on Windows. We experience the same problem with 2 different databases, and with 2 different oracle servers. We have tried increasing the connection timeout on the oracle side to 200 seconds, with no effect. From qgis, we see no hang or connection problems. We are quickly asked for our credentials and the layer loads successfully. The error usually comes after the load is complete. These errors also come with the opening of projects with Oracle tables in them. The end result is that we have to do a daily reboot of our TNS Listener. Our DBA finds this unacceptable, particularly since the number of users is expected to rise sharply. I am not seeing any reports of other users with this problem. Any ideas? Thanks, Heather The error: Fatal NI connect error 12170. VERSION INFORMATION: TNS for Linux: Version 11.2.0.4.0 - Production Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production Time: 16-MAR-2015 13:36:21 Tracing not turned on. Tns error struct: ns main err code: 12535 TNS-12535: TNS:operation timed out ns secondary err code: 12606 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.100.78.43)(PORT=49830)) WARNING: inbound connection timed out (ORA-3136) ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Oracle connection Timeout
Hi Heather, On Mon, 16. Mar 2015 at 14:12:23 +0100, Hillers Heather wrote: We have a QGIS installation running with a Oracle 12 Database. If we open the Qgis Oracle Connection window and set up a connection without saving our username and password, then click on the connect button, and then add any table to qgis, our DBA gets the error below: We are experiencing the same problem whether we are connecting from our QGIS 2.2 installation on Linux or our QGIS 2.6 installation on Windows. We experience the same problem with 2 different databases, and with 2 different oracle servers. We have tried increasing the connection timeout on the oracle side to 200 seconds, with no effect. From qgis, we see no hang or connection problems. We are quickly asked for our credentials and the layer loads successfully. The error usually comes after the load is complete. These errors also come with the opening of projects with Oracle tables in them. The end result is that we have to do a daily reboot of our TNS Listener. Our DBA finds this unacceptable, particularly since the number of users is expected to rise sharply. I am not seeing any reports of other users with this problem. Any ideas? Never seen this either. Googling suggests that it might be a firewall between client server that kills idle connections. 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 Norden http://www.norbit.de QGIS release manager (PSC) GermanyIRC: jef on FreeNode signature.asc Description: Digital signature ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Add New Records to Relation or Non-Spatial Table Using Line Entry (vs Form Entry)
Great work to all who have been a part of improving the user's ability to customize input forms! My question is about the way that new records are added to either a relation (created to handle a one to many relationship between two tables) or to a non-spatial table. In either case, the attributes for the new record are input using the form (either the default one or one that's been customized by the user). In my case, I would actually benefit by creating new records from the table view. Since the various widgets are available from the table view, I don't see a disadvantage for using this approach. As is, I can modify existing records from the table view, but each time I create a new one, I must use the form to populate the attributes. I have searched for a way to change this in the QGIS settings and project properties, but I am unable to find and available setting. Can this behavior be changed? Thanks! -- Jeffrey Durrence McLean Engineering Company jeffrey.durre...@mcleanengineering.com ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Can't access Oracle sequences
Hello, With Postgis/QGIS configuration I can manage sequences on primary key when editing new object (editing forms show a nextval(‘xx’::regclass) formula in pk field) With my Oracle/QGIS conf I can’t manage sequences, and editing failed when I want to save. Where is the problem? Is it an Oracle provider issue ? Is it a GRANT privilege problem on sequences? Thanks Sylvain ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Building an input form with choice-dependent dropdown lists
Hi, I have created an input form using the Drag and Drop designer, The form has multiple dropdown widgets that are either value map or value relation widgets. To minimize input errors, I need to make a form whose dropdrowns are completed in a certain order and whose dropdown values are based on the preceding choices. From what I have read, it appears that this is where I would need to venture into customization with QT designer and/or python init scripts. Having read through several examples of form customization and Python scripts, I have spent more time on clever ways of achieving similar functionality with data tricks (e.g., attaching multiple times to the same table or views derived from the same table and employing filtering on each), but I have created what appears to be an overly complicated solution. If QT designer + python scripting holds the most promise, I'd appreciate advice on a good entry point for learning these techniques. I have a located a few texts on QGIS development, but I don't know if they are the best for what I'm trying to do. Also, if there are other mailing lists or groups that might help me, I'd welcome that input as well. Thanks! -- Jeffrey Durrence McLean Engineering Company jeffrey.durre...@mcleanengineering.com ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] QGIS tracking/fieldwork application
Thanks Bo, I will have a look on the Roam QGIS. Can you also suggest some blogs or websites using Android tablet? Thanks, -Leo On Tue, Mar 17, 2015 at 3:01 AM, qgis-user-requ...@lists.osgeo.org wrote: Send Qgis-user mailing list submissions to qgis-user@lists.osgeo.org To subscribe or unsubscribe via the World Wide Web, visit http://lists.osgeo.org/mailman/listinfo/qgis-user or, via email, send a message with subject or body 'help' to qgis-user-requ...@lists.osgeo.org You can reach the person managing the list at qgis-user-ow...@lists.osgeo.org When replying, please edit your Subject line so it is more specific than Re: Contents of Qgis-user digest... Today's Topics: 1. Re: Line symbols with edge along the line and without edge at the ends? (Andreas Neumann) 2. Re: QGIS tracking/fieldwork application (Bo Victor Thomsen) 3. Oracle connection Timeout (Hillers Heather) 4. Re: Oracle connection Timeout (J?rgen E. Fischer) 5. Can't access Oracle sequences (PIERRE Sylvain) 6. Add New Records to Relation or Non-Spatial Table Using Line Entry (vs Form Entry) (Jeffrey Durrence) 7. Building an input form with choice-dependent dropdown lists (Jeffrey Durrence) -- Message: 1 Date: Mon, 16 Mar 2015 11:18:11 +0100 From: Andreas Neumann a.neum...@carto.net To: qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] Line symbols with edge along the line and without edge at the ends? Message-ID: 5506ade3.4050...@carto.net Content-Type: text/plain; charset=windows-1252; Format=flowed Hi, This is possible. Make sure that you enable symbol levels (button Advanced - Symbol levels at the lower right of the symbology dialogue) and set the line endings to flat (not square or round). Andreas On 16.03.2015 10:47, Elstermann, Mike wrote: Line symbols with edge along the line and without edge at the ends? Left NOT OK, Right OK THX, mikeE. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user -- next part -- An HTML attachment was scrubbed... URL: http://lists.osgeo.org/pipermail/qgis-user/attachments/20150316/5991d658/attachment-0001.html -- next part -- A non-text attachment was scrubbed... Name: not available Type: image/jpeg Size: 5997 bytes Desc: not available URL: http://lists.osgeo.org/pipermail/qgis-user/attachments/20150316/5991d658/attachment-0001.jpe -- Message: 2 Date: Mon, 16 Mar 2015 11:25:57 +0100 From: Bo Victor Thomsen bo.victor.thom...@gmail.com To: qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] QGIS tracking/fieldwork application Message-ID: 5506afb5.9030...@gmail.com Content-Type: text/plain; charset=windows-1252; Format=flowed Try googling Roam QGIS. Roam is a new skin aka user interface (and more) for QGIS, enabling it to function better on a windows tablet. Regards Bo Victor Thomsen AestasGIS Denmark Den 16-03-2015 kl. 08:54 skrev Leo Kris Palao: Hi QGIS Users, Good day! I watched the live tracking video of QGIS in https://www.youtube.com/watch?v=0WevRW4tbzst=253 (Live Tracking and sampling with Quantum GIS, a tablet PC and a Bluetooth datalogger) I am interested to the same. I am particularly interested on how I can customize my forms such that when I digitize a point, I can use drop down menu options, combo box, etc. If you could point me in the right direction (blogs, websites), will be very helpful. Thanks, -Leo ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user -- next part -- An HTML attachment was scrubbed... URL: http://lists.osgeo.org/pipermail/qgis-user/attachments/20150316/c4e1093b/attachment-0001.html -- Message: 3 Date: Mon, 16 Mar 2015 14:12:23 +0100 From: Hillers Heather heather.hill...@erftverband.de To: 'qgis-user@lists.osgeo.org' qgis-user@lists.osgeo.org Subject: [Qgis-user] Oracle connection Timeout Message-ID: 92b765d2b126e24ea4ac2f4f29b85aef02610fd...@exsrv2.erftverband.de Content-Type: text/plain; charset=us-ascii We have a QGIS installation running with a Oracle 12 Database. If we open the Qgis Oracle Connection window and set up a connection without saving our username and password, then click on the connect button, and then add any table to qgis, our DBA gets the error below: We are experiencing the same problem whether we are connecting from our QGIS 2.2 installation on Linux or our QGIS 2.6 installation on Windows. We experience the same problem with 2 different databases, and with 2 different oracle servers. We have
[Qgis-user] QGIS tracking/fieldwork application
Hi QGIS Users, Good day! I watched the live tracking video of QGIS in https://www.youtube.com/watch?v=0WevRW4tbzst=253 (Live Tracking and sampling with Quantum GIS, a tablet PC and a Bluetooth datalogger) I am interested to the same. I am particularly interested on how I can customize my forms such that when I digitize a point, I can use drop down menu options, combo box, etc. If you could point me in the right direction (blogs, websites), will be very helpful. Thanks, -Leo ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user