Hoster prints songbook incorrectly

[wb6bna]

I remember when Hoster printed very nice songbooks, now it sucks. I will send them in an email if you fwd me ur email address, as I am unable to attach the docs to this post for some reason. If anyone can tell me what I am doing wrong please tell me. Thanks Alan

[Roy Dennis]

I can't think what's changed in the final layout over the years but if you want to send your result via my email the address is in the private message.

[Roy Dennis]

I've posted a link to your file so anyone who may have a suggestion can view it.

https://1drv.ms/b/s!AvLuciAi7-DesFWdP7hQuaZd0fbw

The trouble as I see it is when you imported the files you did not set the define field order correct.
It looks like you probably imported them as "Title Only (Insert Full File name) Order.
For the songbook to sort correctly the songs have to be imported with the data in the correct columns.

If you open Hosters Edit dialog and just select match for the Book ID then enter 1374 as the search string it should show all those files, then look at the Artist name field and Title fields and all the other fields, Are they in the correct columns or is most of the data in a single column ?

I also note that some of the file names show an "F" after the artist name is that something to do with the Drive letter ?

Also those files were not imported as first name last name order so you would not be able to sort the books in that order.

Apart from laboriously editing them all one at a time I think it would be easier to re import them correctly.
All those file that have disc and track numbers at the start of the file names you would probably be best to set the define field order to ignore that first field.

Or alternately use a Bulk file renamer tool such as:
http://www.bulkrenameutility.co.uk/V...ersion=2.7.1.3

Rename them without the leading # then re Import.

[wb6bna]

Nearly all of them have been in my database since between 2006 and 2010 and there have only been a couple since then

[Roy Dennis]

See if you can take a screen shot of the edit dialog after listing 1374 book Id.
Then I might be able to see the problem.

[wb6bna]

The screenshot is attached. I just noticed there is a 01 before all the songs Alan I think I may know the problem but don't know how to fix it. Several years ago I converted all my scdg's and imported them to Hoster and maybe this is the problem, but I don't know how to fix it.screenshot.bmp