Re: [Gramps-devel] Bulk database update

[Doug B. <dou...@gm...>]

On Thu, Sep 22, 2011 at 1:13 PM, Matt Keenan <mat...@gm...> wrote:
> Hi,
>
> I want to do a bulk update of some 4000+ notes to remove the
> "Formated" check from each one. As one can imagine manually opening
> each note, unchecking the check box and closing each note, would be
> somewhat of a lengthy task. So here's what I did, and I want to verify
> that this is safe.... before committing to using my new database.
>
> - Make a gpkg backup of my family database to say "matt.gpkg".
>
> - On an ubuntu box :
>   $ cp ~/backups/matt.gpkg /tmp/matt.tar.gz
>   $ cd /tmp
>   $ gzip -d matt.tar.gz
>   $ tar -xvf matt.tar
>   $ cp data.gramps data.gramps.gz
>   $ gzip -d data.gramps.gz
>
> - Now I edit data.gramps as it's just a plain ascii xml file, and
> using vim I simply remove the format="1" from all the note
>  elements.
>  e.g.  s/ format="1"//
>
> - I can now rezip and retar up my backup
>
>  $ gzip data.gramps
>  $ mv data.gramps.gz data.gramps
>  $ tar -cvf matt-2.tar data.gramps Media
>  $ gzip matt-2.tar
>  $ cp matt-2.tar.gz ~/backups/matt-2.gpkg
>
>  Media above is my media files which also untarred from the original backup.
>
> - I can now within gramps, create a new family database and import
> this new matt-2.gpkg file.
>  after import all appears to be fine, I just want to verify what I've
> done is safe and acceptable, and I can now make edits to my newly
> import family tree safely and trust this as my master going forward ?

Sounds good to me!

-Doug

> cheers
>
> Matt
>
> As I don't know the specifics of the database tables/fields etc.
>
> --
> HH Golf Society
>       www.hh-gs.com
>
> IFLAF
>       www.iflaf.com
>
> ------------------------------------------------------------------------------
> All the data continuously generated in your IT infrastructure contains a
> definitive record of customers, application performance, security
> threats, fraudulent activity and more. Splunk takes this data and makes
> sense of it. Business sense. IT sense. Common sense.
> http://p.sf.net/sfu/splunk-d2dcopy1
> _______________________________________________
> Gramps-devel mailing list
> Gra...@li...
> https://lists.sourceforge.net/lists/listinfo/gramps-devel
>