MTU.Community


Go Back   MTU.Community > Hoster Software > Hoster Help

Hoster Help Post Hoster questions, tips and suggestions here.

Reply
 
Thread Tools Display Modes
  #1  
Old October 1st, 2010, 10:50 AM
rcatala rcatala is offline
Registered User
 
Join Date: Mar 2003
Posts: 4
Re: Long BookIDs

Thanks Dale. But when I print out a songbook, some of the ids are very long. Example: 6231111-23, another 89672-02, 7181111-41 and so on. That is the problem I am referring to. I recently added songs that were mp3/zip files and it appears most of them were assigned the long number. I don't mind re-importing, but I suspect this will happen again. Is there a way to go directly into the database and renumber, perhaps with MS Access?
Reply With Quote
  #2  
Old October 1st, 2010, 11:30 AM
Roy Dennis's Avatar
Roy Dennis Roy Dennis is offline
Super Moderator
 
Join Date: Mar 2004
Location: Kent, England
Posts: 6,391
Re: Long BookIDs

Before you consolidated these files, did you see what Book IDs were assigned to these files then ?

It looks like it has added 1111 on to the end of the book id. If you delete these KMH files it would be best to do it from the edit multiples tab then re import them but check when importing that the # shown in the next box of the Book Id Root is of a manageable size first, (no more than 4 digits). Just import a few first and check it in the edit screen or songbook before completing the rest.

After deleting all these Kmh headers, check which is the last number showing from the drop down window in the main screens book id, then your next book ID when importing should be one up from this of course ignoring the last 2 digits.

Roy.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On


All times are GMT -4. The time now is 06:14 PM.


Powered by vBulletin® Version 3.7.1
Copyright ©2009 - 2025, Jelsoft Enterprises Ltd.
The contents of this forum are copyrighted by Micro Technology Unlimited, 2000-2008. Use of any material from these Forums is prohibited without written agreement from MTU.