Re: Can I export all the data (incl refs between objects) and reimport it into a new zodb instance

On Tue, Oct 4, 2016 at 2:37 PM, Jo Gilder <[email protected]> wrote:
> Hi thanks.
>
> The two sites are separate databases they just have very similar schema.

But there aren't references between sites, right?

> The reason for the none data.fs backup would be to allow it to be referred to without python. An easy visual check that all is well with the data by non coding researchers.

This feels like a very different requirement than backup.

"non-coding researcher" sounds like an oxymoron. :)

You'd probably be better off writing a custom exporter based on your
application and researcher's needs, or better yet a web application
for browsing the data. You could probably do something quick and
fuggly.

>
> Long term we may need to change horses and use a different cms than substanced as it is no longer supported. Maybe plone (so could stay as data.fs) or kotti (needs sqlite). Any other cms for zodb that are current and supported?

IDK.

>
> From what I had seen I had assumed the uuids were added sequentially, I just couldn't find out if there was an option to override that for known data.

I'd like to add an option to generate them randomly.

> But then as you say, not really the way to go.
>
> I've added in new fields with defaults as we've been developing so happy with that. The page you linked to was helpful with updating when it gets slightly more complicated.
>
> The partial update to the zodb will be a big job very similar to the initial import (for one of the sites at least), I just hope I have enough info about the links between the old data and the new data.fs so that I can make all the changes I need!

Next time you import data, include the original primary keys, so as to
make these sorts of updates easier.  In fact, assuming you figure out
how to link the data this time, I'd bring the original primary keys
along for the ride.

Jim

-- 
Jim Fulton
http://jimfulton.info

-- 
You received this message because you are subscribed to the Google Groups "zodb" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [email protected].
For more options, visit https://groups.google.com/d/optout.