Please read the Guidelines that have been chosen to keep this forum soaring high!

Renumbering Heavenletters

Posted October 26th, 2015 by Uwe-1

Dear Will and Santhan.

Gloria wishes, that a few HLs shall be renumbered, since the number at the moment does not represent the order, the HLs have been written.

I suppose, the number of the HL is a database key. I want to know, how I have to do the changes.

First question: Is it possible, to change the number of a HL after it is assigned? (In other words, is it a primary key?)

Second question: Is the number a unique key? In this case, I would have to assign a number as a placeholder (e.g. 9999) and then use the number freed to assign it to the correct HL. Otherwise, I could simply assign the correct number and, during the work of the fix, there would be two HLs with an identical number.

Third question: I do not know, how the translations are connected to the originals. What work has to be done on the translations?

Thank you for your help!

Uwe

‹ Signature of Heavenletters Chinese my profile ›

Dear Uwe, I'm am not at all

On October 27th, 2015 Gloria Wen... says:

Dear Uwe, I'm am not at all technical.

This is what I remember:

If this Heavenletter written May 17 had been in its right spot, what number would it have?Then it would be necessary for you to change the numbers and ensuing dates of when they will be published. I believe this has to be done manually

Translators who have already translated some of these Heavenletters in advance will have to change the numbers and dates accordingly. on their translations

The sooner you can make these changes, the sooner translators can fix their translations without incurring more Heavenletters to change.

I'm so sorry for this trouble my mistake has made.

Uwe, Theophil also went through this once,. He might be able to help.

Do you have Will's email address. If you don't, ask me privately. I don't know that he knows of a faster way. If anyway does, he does.

God bless you, Uwe.

I found the way and fixed

On October 27th, 2015 Uwe-1 says:

Dear Will and Santhan,

I found out, that HL-numbers do not have to be unique. So I could easily assign the correct numbers.
And, as Gloria said, the translartors have to fix numbers and dates as well.
My questions above are obsolete.

Thank you.

Blessings
Uwe