Re: Test changing the backend / export - import

The "exporting" roundup is running 2.1.0

The "importing" roundup is on 2.0.0
https://www.turnkeylinux.org/updates/new-turnkey-roundup-version-161

List of dump directory:
30.10.2021  20:37    <DIR>          .
30.10.2021  20:37    <DIR>          ..
30.10.2021  20:37    <DIR>          file-files
30.10.2021  20:37           108 646 file-journals.csv
30.10.2021  20:37            80 060 file.csv
30.10.2021  20:43         9 759 695 issue-journals.csv
30.10.2021  20:37         2 528 600 issue.csv
30.10.2021  19:11         1 103 518 keyword-journals.csv
30.10.2021  19:11             7 019 keyword.csv
30.10.2021  19:12    <DIR>          msg-files
30.10.2021  20:37        18 713 238 msg-journals.csv
30.10.2021  19:12        18 671 381 msg.csv
30.10.2021  19:11         1 023 193 priority-journals.csv
30.10.2021  19:11               797 priority.csv
30.10.2021  19:11            15 623 query-journals.csv
30.10.2021  19:11            11 095 query.csv
30.10.2021  19:11         5 041 274 status-journals.csv
30.10.2021  19:11               906 status.csv
30.10.2021  19:11         2 179 270 user-journals.csv
30.10.2021  19:11             8 275 user.csv
              16 Datei(en),     59 264 878 Bytes


The error
>     newid = eval_import(proplist[propnames.index("id")])
> IndexError: list index out of range

is based on which file ?

br
Norbert

-----Ursprüngliche Nachricht-----
Von: Ralf Schlatterbeck [mailto:[email protected]] 
Gesendet: Mittwoch, 03. November 2021 12:20
An: SCHLEMMER Norbert <[email protected]>
Cc: [email protected]
Betreff: Re: [Roundup-users] Test changing the backend / export - import

*EXTERNAL source*


On Wed, Nov 03, 2021 at 10:04:53AM +0000, SCHLEMMER Norbert wrote:

> Please find below the listing :
[...]
>     newid = eval_import(proplist[propnames.index("id")])
> IndexError: list index out of range

this looks like something in the data you're importing is very wrong.
What version of roundup are you *exporting* from? What version are you using for *importing*?

Note that exporting/importing with different roundup versions is not supported. It may work occasionally but is not the recommended way to migrate a database to another backend.

In my code (HEAD) the code-line above is not in the line indicated by your traceback. And my code checks if the 'id' property is in the export-dump and only computes propnames.index if 'id' is indeed in the
propnames:

rdbms_common.py line 3153:
        if not "id" in propnames:
            newid = self.db.newid(self.classname)
        else:
            newid = eval_import(proplist[propnames.index("id")])

So in newer code you should never see the traceback you're getting.
(but the id should always be in the exported properties!)

Ralf
--
Dr. Ralf Schlatterbeck                  Tel:   +43/2243/26465-16
Open Source Consulting                  www:   www.runtux.com
Reichergasse 131, A-3411 Weidling       email: [email protected]