https://issues.qgis.org/https://issues.qgis.org/favicon.ico2013-11-01T00:32:24ZQGIS Issue TrackingQGIS Application - Bug report #8976: Offline Editor not retaining key integer values (or if it retains it does not synchronize correctly)https://issues.qgis.org/issues/8976?journal_id=460642013-11-01T00:32:24ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Category</strong> set to <i>C++ Plugins</i></li><li><strong>Status</strong> changed from <i>Open</i> to <i>Feedback</i></li><li><strong>Target version</strong> set to <i>Future Release - High Priority</i></li></ul><p>I just tested here and regarding your report it seems to work as expected.</p>
<p>By the way, when off-line it is expected the user to manually fill the primary key field?</p> QGIS Application - Bug report #8976: Offline Editor not retaining key integer values (or if it retains it does not synchronize correctly)https://issues.qgis.org/issues/8976?journal_id=460792013-11-01T10:35:19ZZachary Lancasterzlancaster@spatialfocus.com
<ul><li><strong>File</strong> <a href="/attachments/download/6426/offline_2_0_1.png">offline_2_0_1.png</a> added</li><li><strong>File</strong> <a href="/attachments/download/6425/offline_1_8.png">offline_1_8.png</a> added</li></ul><p>It can not be expected that primary key values be filled by the user. The reintegration of the data relies heavily on the correct use of these primary key values. The retention of primary keys did work in 1.8 and allowed for data to be synced back to the online database.</p>
<p>If we look at the images attached we will see that all integer values (in this case keys) are not being retained by the offline database. This leads me to believe that all integer values are not being retained in the offline version of the database.</p> QGIS Application - Bug report #8976: Offline Editor not retaining key integer values (or if it retains it does not synchronize correctly)https://issues.qgis.org/issues/8976?journal_id=460802013-11-01T10:52:05ZGiovanni Manghigiovanni.manghi@gmail.com
<ul></ul><p>Hi, this is weird. I'm on Linux and for me the primary are retained correctly in the off-line DB.</p>
<p>Anyway I would consider the lack of an autofill function for the primary key when off-line a regression.</p>
<p>This tools was working ok on qgis 1.7.4, as far as I know it was not working (for other reasons) on 1.8, see</p>
<p><a class="issue tracker-1 status-5 priority-10 priority- closed" href="https://issues.qgis.org/issues/6146" title="Offline editing tool broken (Closed)">#6146</a></p>
<p>it was ok for you on 1.8?</p>
<p>What OS are you using?</p> QGIS Application - Bug report #8976: Offline Editor not retaining key integer values (or if it retains it does not synchronize correctly)https://issues.qgis.org/issues/8976?journal_id=461172013-11-03T14:04:46ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Subject</strong> changed from <i>Offline Editor not retaining key integer values</i> to <i>Offline Editor not retaining key integer values (or if it retains it does not synchronize correctly)</i></li><li><strong>Status</strong> changed from <i>Feedback</i> to <i>Open</i></li><li><strong>Priority</strong> changed from <i>Normal</i> to <i>Severe/Regression</i></li></ul><p>Anyway I tested 1.7.4 and it was working correctly. In the off line table the primary key field was supposed to be left untouched and then the plugin took care to fill it correctly when synchronizing back. This does not happens now in master.</p> QGIS Application - Bug report #8976: Offline Editor not retaining key integer values (or if it retains it does not synchronize correctly)https://issues.qgis.org/issues/8976?journal_id=482622014-02-07T06:53:03ZMartin Dobiaswonder.sk@gmail.com
<ul><li><strong>Status</strong> changed from <i>Open</i> to <i>Feedback</i></li></ul><p>When I convert a layer to offline project, the primary key is preserved and I can keep update attributes.</p>
<p>Maybe a short SQL dump of your table would help (create table + few inserts).</p> QGIS Application - Bug report #8976: Offline Editor not retaining key integer values (or if it retains it does not synchronize correctly)https://issues.qgis.org/issues/8976?journal_id=482992014-02-08T02:18:40ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Resolution</strong> set to <i>fixed/implemented</i></li><li><strong>Status</strong> changed from <i>Feedback</i> to <i>Closed</i></li></ul><p>Martin Dobias wrote:</p>
<blockquote>
<p>When I convert a layer to offline project, the primary key is preserved and I can keep update attributes.</p>
<p>Maybe a short SQL dump of your table would help (create table + few inserts).</p>
</blockquote>
<p>I just compiled the latest code and it works as expected. Please reopen if necessary.</p>