Re: export / import difficulties from version 1.3.3 to 1.4.20

In message <[email protected]>,
Chad Seys writes:
>  I am trying to migrate a tracker from version 1.3.3 to 1.4.20 .
>  I initially tried to follow the instruction for updating trackers
>  using the tweaks listed on the 'upgrading versions' and the
>  migrate command.  This did not work....

This is the correct way to do the upgrade.

> I don't have the failure text at the moment but can try again if 
> needed.  Looked like some database entries changed names.

Hmm, how strange. What database back end are you using?

>  I next tried to export / import the tracker.  This also did not work.

Export/import between roundup versions is not claimed to work. It is
meant to be used when changing database back ends (e.g. from berkeley
db to sqlite or sqlite to postgres) using the same version of roundup.

(It can also possibly be used to do a logical backup of the data for
later import to the same versiion of roundup.)

Any other use is unsupported.

> Below is the error output.
> I'd be willing to try either method (migrate or import).  Whatever works!
># roundup-admin import /tmp/web/
>Enter tracker home: /roundup/test
>
>setting status 9
>
>setting msg 854
>
>setting keyword 2
>
>setting user 776
>
>setting priority 8
>
>setting query 2
>
>setting file 92
>Traceback (most recent call last):
>  File "/usr/lib/python2.7/dist-packages/roundup/admin.py", line 1481, in 
>run_command
>    ret = function(args[1:])
>  File "/usr/lib/python2.7/dist-packages/roundup/admin.py", line 1257, in 
>do_import
>    nodeid = cl.import_list(file_props, r)
>  File "/usr/lib/python2.7/dist-packages/roundup/backends/rdbms_common.py", 
>line 2837, in import_list
>    prop = properties[propname]
>KeyError: 'topic'

This again looks like a schema issue. My guess is something is wacky
in your current schema definition (or it's representation in the
database) and the database is out of sync with the defined schema.

Are you sure that /roundup/test has the same schema.py and other files
that the original rounup instance had?

Can you check schema.py in your /roundup/test instance and see if
"topic" is defined as a property for your class named "file".

--
				-- rouilj
John Rouillard
===========================================================================
My employers don't acknowledge my existence much less my opinions.

------------------------------------------------------------------------------
HPCC Systems Open Source Big Data Platform from LexisNexis Risk Solutions
Find What Matters Most in Your Big Data with HPCC Systems
Open Source. Fast. Scalable. Simple. Ideal for Dirty Data.
Leverages Graph Analysis for Fast Processing & Easy Data Exploration
http://p.sf.net/sfu/hpccsystems