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

No references between the sites.

Yes, a very different proposition to backup - but something I can see on 
the horizon.

Funnily enough one of the properties one site wants to add is the original 
primary key. Formerly thought of as not required, now that was a mistake. 
The other site had data which came without any unique identifiers so I had 
to create them (don't ask).

I am surrounded by relational database projects and lacking knowledge or 
local support for zodb (the plone supporter who recommended it has moved 
on) so every hill is always higher than I think.  

This group is excellent for help but I find it difficult searching on 
google as there is so little about.

Thanks again.

On Tuesday, 4 October 2016 19:56:47 UTC+1, Jim Fulton wrote:
>
> On Tue, Oct 4, 2016 at 2:37 PM, Jo Gilder <[email protected] 
> <javascript:>> 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.