Web based family history software

file Question renumbering gedcom

  • mariannevanharten
  • mariannevanharten's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
4 years 3 months ago #1 by mariannevanharten
renumbering gedcom was created by mariannevanharten
I am looking for a way to renumber my single gedcom file. The renumber option in the control panel doesn't work for me, because I've one tree.
My gedcom file has many groups of ID's and single ID's. I want to have ascending numbers from 1 to as many people, families, sources, etc.

Which program can do such for me?

Best regards,

Marianne

Please Log in or Create an account to join the conversation.

  • norwegian_sardines
  • norwegian_sardines's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
More
4 years 3 months ago #2 by norwegian_sardines
Replied by norwegian_sardines on topic renumbering gedcom
I can’t tell you how to do this, but why do you need to renumber the XREF numbers?

Ken

Please Log in or Create an account to join the conversation.

  • mariannevanharten
  • mariannevanharten's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
4 years 3 months ago #3 by mariannevanharten
Replied by mariannevanharten on topic renumbering gedcom
I have installed the module for original names (I for individuals, S for sources, etc.). I want to reorder these collections for a better administration.

Please Log in or Create an account to join the conversation.

  • bertkoor
  • bertkoor's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Greetings from Utrecht, Holland
More
4 years 3 months ago #4 by bertkoor
Replied by bertkoor on topic renumbering gedcom
I think you'll like the Renumber function of webtrees 1.7.
Install it on your own PC under XAMPP. Import the GEDCOM, renumber & export.
I have not tried it myself, so I cannot guarantee it will start renumbering at one.

But the XREFs are meaningless indeed, and renumbering is a bit pointless.
If from the beginning you not knew any better than each record got a random XREF of 10 letters, then you would not have the urge to fill all gaps again and stick to I123 & F78.

stamboom.BertKoor.nl runs on webtrees v2.2.1

Please Log in or Create an account to join the conversation.

More
4 years 3 months ago #5 by fisharebest
Replied by fisharebest on topic renumbering gedcom
1 - create a new/temporary tree
2 - export your main tree, and import it into the temporary tree.

Now, every record in your main tree has a record with the same XREF in the temporary tree

3 - Control panel -> Family trees -> You main tree -> Renumber
4 - Delete the temporary tree

Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

More
4 years 3 months ago #6 by Peter_S
Replied by Peter_S on topic renumbering gedcom

fisharebest wrote: 1 - create a new/temporary tree
2 - export your main tree, and import it into the temporary tree.

Now, every record in your main tree has a record with the same XREF in the temporary tree

3 - Control panel -> Family trees -> You main tree -> Renumber
4 - Delete the temporary tree

Hi Greg,

only for my understanding: Why are steps 2 and 4 necessary? Only for backup if something is going wrong?

Best regards
Peter

Peter

webtrees 2.2.1, vesta modules, chart modules of magicsunday, extended family and imprint of hartenthaler
PHP 8.3.12, MariaDB 10.11.8
Webhosting: genonline.de

Please Log in or Create an account to join the conversation.

More
4 years 3 months ago #7 by fisharebest
Replied by fisharebest on topic renumbering gedcom
The renumber function will only renumber an XREF if it also exists in another tree.

It was created so that you can easily merge two trees.

Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

  • mariannevanharten
  • mariannevanharten's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
4 years 3 months ago #8 by mariannevanharten
Replied by mariannevanharten on topic renumbering gedcom
I think these steps are clear.
But when running these steps, after 3. I get an error:
Service Unavailable
The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.

I think I can set one or more PHP option in my hosting's control panel. But which option(s)?

Please Log in or Create an account to join the conversation.

More
4 years 3 months ago #9 by fisharebest
Replied by fisharebest on topic renumbering gedcom
This is most likely cauesd by a timeout.

You have asked webtrees to do a time-consuming task.

webtrees can detect PHP time limits, and do something sensible.
In this case, it will save the changes it made - and tell you to run the process again, to complete the rest of the task.

But webtrees cannot detect the apache time limit.

So, you need to make sure the PHP time limit is less than the apache time limit.

Apache limits are typically 30 or 60 seconds.
So set the PHP max execution time to 25 or 55 seconds.

Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

More
4 years 3 months ago #10 by Peter_S
Replied by Peter_S on topic renumbering gedcom
Hi Greg,

fisharebest wrote: webtrees can detect PHP time limits, and do something sensible.
In this case, it will save the changes it made - and tell you to run the process again, to complete the rest of the task.


Does this intelligent behavior of webtrees also work for other time-consuming functions like Relationships?

fisharebest wrote: So, you need to make sure the PHP time limit is less than the apache time limit.

Apache limits are typically 30 or 60 seconds.
So set the PHP max execution time to 25 or 55 seconds.


I think this important hint should be documented in the installation description and/or displayed as a hint during the installation process.

Best regards
Peter

Peter

webtrees 2.2.1, vesta modules, chart modules of magicsunday, extended family and imprint of hartenthaler
PHP 8.3.12, MariaDB 10.11.8
Webhosting: genonline.de

Please Log in or Create an account to join the conversation.

More
4 years 3 months ago #11 by fisharebest
Replied by fisharebest on topic renumbering gedcom
> Does this intelligent behavior of webtrees also work for other time-consuming functions like Relationships?

No, it only applies to tasks that can be broken down into lots of smaller independent tasks.

e.g. data-fixes

Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

More
4 years 3 months ago #12 by Peter_S
Replied by Peter_S on topic renumbering gedcom
The idea was to interrupt the process just before the PHP time expires, cache the previous result and start the next time slice with a "Continue" button. Would this be feasible from a technical point of view?

Peter

webtrees 2.2.1, vesta modules, chart modules of magicsunday, extended family and imprint of hartenthaler
PHP 8.3.12, MariaDB 10.11.8
Webhosting: genonline.de

Please Log in or Create an account to join the conversation.

  • mariannevanharten
  • mariannevanharten's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
4 years 3 months ago #13 by mariannevanharten
Replied by mariannevanharten on topic renumbering gedcom
I've set the max_execution_time to 55.
When I click the renumber button, the process stops after these time and the number of records is less than before. So I repeat this function a few times.
After a few times webtrees replies with an error:
Code:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '16-individual.php-I41386' for key 'PRIMARY' (SQL: update `wt_hit_counter` set `page_parameter` = I41386 where `gedcom_id` = 16 and `page_parameter` = I129930) …/vendor/illuminate/database/Connection.php:664 #0 …/vendor/illuminate/database/Connection.php(624): Illuminate\Database\Connection->runQueryCallback('update `wt_hit_...', Array, Object(Closure)) #1 …/vendor/illuminate/database/Connection.php(490): Illuminate\Database\Connection->run('update `wt_hit_...', Array, Object(Closure))
and some more lines.

What is the best way to help?

Regards,
Marianne

Please Log in or Create an account to join the conversation.

More
4 years 3 months ago #14 by fisharebest
Replied by fisharebest on topic renumbering gedcom
It is renumbering I129930 to I41386

I41386 isn't currently used, so is available for re-use.

But it I guess that it previously existed, so there is a "hit counter" entry for it.

This is puzzling, as the algorithm to choose a new XREF only increases. After it has generated I129930, the next number should be higher than that.

It shouldn't generate a lower number, such as I41386.

Delete the entry for I41386 from the table wt_hit_counter, and try again...

Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

More
5 months 3 weeks ago #15 by derieppe
Replied by derieppe on topic renumbering gedcom
Hi,

I know that almost 4 years have gone by but I've just discovered your message.

I have developed and made available free of charge to genealogists a utility that does exactly what you asked for: renumber individuals, families, sources... in the format of your choice from a GEDCOM file exported from your application.

You can download it for free here: geneasofts.com/en/download/gedcomrenumber-en/

Best regards.

Please Log in or Create an account to join the conversation.

More
5 months 3 weeks ago #16 by TheDutchJewel
Replied by TheDutchJewel on topic renumbering gedcom

You can download it for free here: geneasofts.com/en/download/gedcomrenumber-en/

 

That looks very promising, but I can't manage to download it.

First I could not create an account (because of a 403 Access Forbidden error). I reported that in another browser using the contact form.

Then I added the product to the shopping cart in that other browser, but when I want to download it I get the following message:

We're sorry, you are not allowed to proceed
Your request looks suspiciously similar to automated requests from spam posting software or it has been denied by a security policy configured by the website administrator.

If you believe you should be able to perform this request, please let us know.

RID: QMAA3OZEW4YI7V5NXF6LLCJF
Know more: Documentation


I can't then report this via the contact form, because sending it hangs indefinitely. All in all, a very frustrating process.
 

• webtrees 2.0.19 (last 2.0.x version that Vesta fixed for changed markdown implementation)
  + Laragon 8.1.0 with PHP 7.4.33 + Rural & Primer theme + Vesta & other modules
• latest webtrees 2.2.x (only for testing and presentation) + PHP 8.4.x

Please Log in or Create an account to join the conversation.

More
5 months 3 weeks ago #17 by derieppe
Replied by derieppe on topic renumbering gedcom
Good evening.
We have received your message and, as indicated by our support team, your IP address has been blocked by our protection system. You should be aware that the site is subject to dozens of attempted attacks every day...
Once the IP address has been blocked, there's nothing you can do (login ou password reset...) ! Using anoter browser froim the same IP adress does not does not bypass security...
We need to find out why you are experiencing this problem. We will contact you directly by email outside this forum.
Sincerely

Please Log in or Create an account to join the conversation.

More
5 months 3 weeks ago #18 by TheDutchJewel
Replied by TheDutchJewel on topic renumbering gedcom
After unblocking my IP, my name/password combination no longer worked. When I chose “forgot password,” I got a link that referred to a French language page where I could change the password, but the moment I set the page to English, I could only enter my email address to reset the password. Using the English language setting, it was not possible to change the password.

On the advice of GeneaSofts.Com, I disabled my password manager add-on to be able to reset the password.
After changing my password that way, I enabled the password manager add-on again, added the new password to the password manager add-on and logged in via password manager add-on after which I was finally able to download the file.

• webtrees 2.0.19 (last 2.0.x version that Vesta fixed for changed markdown implementation)
  + Laragon 8.1.0 with PHP 7.4.33 + Rural & Primer theme + Vesta & other modules
• latest webtrees 2.2.x (only for testing and presentation) + PHP 8.4.x

Please Log in or Create an account to join the conversation.

More
5 months 3 weeks ago - 5 months 3 weeks ago #19 by Franz Frese
Replied by Franz Frese on topic renumbering gedcom
These numbers are useless for visitors, why should I rename them?

I always wonder when I see sites, displaying these.
 
Last edit: 5 months 3 weeks ago by Franz Frese.

Please Log in or Create an account to join the conversation.

Powered by Kunena Forum