GENBOX-L Archives

Archiver > GENBOX > 2004-03 > 1080259045


From: "wim prange" <>
Subject: RE: [GENBOX] Renumber Individuals and Sources?
Date: Fri, 26 Mar 2004 00:57:25 +0100
In-Reply-To: <CHEMKKAJHOKJPIEOPLKDGELHFBAA.clcasper@sprynet.com>


CheriC - I saw an option under importing a GB-database to retain original
ID-nrs under Invidual Identifiers. Maybe with that option checked, it also
retains original source-nrs, I don't know. If I were you I would carefully
check your ByGones Research Extracts though...

When using ID-nrs for Individuals, I would use the User ID-field under
Identifiers, not the automatically generated ID-nr.

Gr. Wim

> -----Oorspronkelijk bericht-----
> Van: Cheri Casper [mailto:]
> Verzonden: vrijdag 26 maart 2004 0:34
> Aan:
> Onderwerp: RE: [GENBOX] Renumber Individuals and Sources?
>
>
> Wim - I don't remember the specifics but you can darn well bet I'll be
> careful about doing so. I don't want things renumbered. My family folders
> are identified by the ID numbers of the individuals. My ByGones Reseach
> Extracts are cross-referenced to the the GB source number. If I got stuff
> renumbered it would be a disaster! But I can tell you that at some juncture
> I developed that large gap in my source numbers which has remained to this
> day. My most recent source (created last night) is 684, but I only have
> 500-something sources.
>
> If this is the way it is supposed to work, then this is very problematic for
> folks who use the numbers for cross-reference purposes. I still believe
> that renumbering should be a deliberate option selected by the user; not
> something that happens upon export/import. I would never find anything!
>
> CheriC
>
> -----Original Message-----
> From: wim prange [mailto:]
> Sent: Thursday, March 25, 2004 2:00 PM
> To:
> Subject: RE: [GENBOX] Renumber Individuals and Sources?
>
>
> Hi CheriC,
>
> just tested it on a test file again: last person in testfile had Ind# 867,
> deleted an individual (Ind# 860) and after export the last person in file
> now
> has Ind# 866. Have done the same with sources: deleted a couple of sources
> and
> the highest source-ID# is the same as the amount of sourcerecords.
>
> Tested it a second time with the option "linked only" checked for sources
> and
> the results was the same: the sources were renumbered.
>
> How did you export the file? I exported to a new genbox-database. Maybe
> importing a genbox-database into a new file works differently?
>
> Gr.
>
>
>
>
> > -----Oorspronkelijk bericht-----
> > Van: Cheri Casper [mailto:]
> > Verzonden: donderdag 25 maart 2004 21:04
> > Aan:
> > Onderwerp: RE: [GENBOX] Renumber Individuals and Sources?
> >
> >
> > Wim - I beg to differ. I have exported to a new file a couple of times
> and
> > my sources still go from 171 to 328. Since I use the source number as a
> > cross reference as well as the individual ID number, I certainly hope the
> > gaps wouldn't be closed *unless the user specifically performed a
> > renumbering action." That would make an abysmal mess of my paper system.
> >
> > CheriC
> >
> > -----Original Message-----
> > From: wim prange [mailto:]
> > Sent: Thursday, March 25, 2004 9:51 AM
> > To:
> > Subject: RE: [GENBOX] Renumber Individuals and Sources?
> >
> >
> > Hi Karen,
> >
> > You can't renumber in Genbox and renumbering in Access is *not* a good
> idea:
> > Genbox uses these numbers as pointers between the tables, you would create
> > false links or links to non-existing records.
> >
> > To get rid of the gaps can be done with exporting the file to a new
> > Genbox-database.
> >
> > Gr. Wim
> >
> > > -----Oorspronkelijk bericht-----
> > > Van: Karen Carrigan [mailto:]
> > > Verzonden: donderdag 25 maart 2004 18:34
> > > Aan:
> > > Onderwerp: [GENBOX] Renumber Individuals and Sources?
> > >
> > >
> > > Hey Genbox List,
> > > Has anyone tried to renumber either individuals or sources? Will
> opening
> > > Genbox in MSAccess allow you to either change numbers or resequence?
> Not
> > a
> > > big deal...I just made a mess trying to combine 2 datasets, and have
> some
> > > huge gaps in numbering after cleanup.
> > > Karen
> > >
> > >
> > > ==== GENBOX Mailing List ====
> > > To join this list, send an email to
> > > with the word "subscribe" as the subject line. Then email your
> > > messages to and they will appear on this list.
> > >
> > > ==============================
> > > Gain access to over two billion names including the new Immigration
> > > Collection with an Ancestry.com free trial. Click to learn more.
> > > http://www.ancestry.com/rd/redir.asp?targetid=4930&sourceid=1237
> > >
> >
> >
> > ==== GENBOX Mailing List ====
> > To join this list, send an email to with the
> > word "subscribe" as the subject line. Then email your messages to
> > and they will appear on this list.
> >
> > ==============================
> > Gain access to over two billion names including the new Immigration
> > Collection with an Ancestry.com free trial. Click to learn more.
> > http://www.ancestry.com/rd/redir.asp?targetid=4930&sourceid=1237
> >
> >
> >
> > ==== GENBOX Mailing List ====
> > To join this list, send an email to
> > with the word "subscribe" as the subject line. Then email your
> > messages to and they will appear on this list.
> >
> > ==============================
> > Gain access to over two billion names including the new Immigration
> > Collection with an Ancestry.com free trial. Click to learn more.
> > http://www.ancestry.com/rd/redir.asp?targetid=4930&sourceid=1237
> >
>
>
> ==== GENBOX Mailing List ====
> To join this list, send an email to with the
> word "subscribe" as the subject line. Then email your messages to
> and they will appear on this list.
>
> ==============================
> Gain access to over two billion names including the new Immigration
> Collection with an Ancestry.com free trial. Click to learn more.
> http://www.ancestry.com/rd/redir.asp?targetid=4930&sourceid=1237
>
>
>
> ==== GENBOX Mailing List ====
> To join this list, send an email to
> with the word "subscribe" as the subject line. Then email your
> messages to and they will appear on this list.
>
> ==============================
> Gain access to over two billion names including the new Immigration
> Collection with an Ancestry.com free trial. Click to learn more.
> http://www.ancestry.com/rd/redir.asp?targetid=4930&sourceid=1237
>

This thread: