Error 3315

[Skybird74]

Originally Posted by madjim

Sky,
I have always kept all of my KMA files in one folder so I have never merged a database. There are other folks who have done this that know more about it than me.
Jim

So, you have always imported using the same computer? I did most of my importing using my desktop and laptop just for the Show.

I'm not afraid of the program, I just don't want to waste my time installing a bunch of programs I have no other use for, just to locate 8 files listed in Access format. I don't believe that program will help me sort through the 1800 duplicate IDs either.

[madjim- with the Lord]

Originally Posted by Skybird74

So, you have always imported using the same computer?

Not true Sky. I'll import on either machine. I check every song on the disc against my database before I import to be sure that I don't enter a "double". I keep track of the DiscID's (not the BookID -Thanks again Dale) and transfer the KMA files I entered into one machine to the other using a jump drive. I rebuild the database and I have the same songs on both machines with no doubles. I also put a copy of the new KMA files in the KMA folder on my back-up drives as well. This keeps both of my machines (all three counting test machine #2) and my back-up external drives up to date.

If I'm in a hurry a double will get through every now and then. I just make a note when I find one and remove it from all machines and back-up drives the next time the show machine is on the bench.

It's a little work but I never have to "Merge".


Jim

[bryant]

Originally Posted by madjim

Not true Sky. I'll import on either machine. I check every song on the disc against my database before I import to be sure that I don't enter a "double". I keep track of the DiscID's (not the BookID -Thanks again Dale) and transfer the KMA files I entered into one machine to the other using a jump drive. I rebuild the database and I have the same songs on both machines with no doubles. I also put a copy of the new KMA files in the KMA folder on my back-up drives as well. This keeps both of my machines (all three counting test machine #2) and my back-up external drives up to date.

If I'm in a hurry a double will get through every now and then. I just make a note when I find one and remove it from all machines and back-up drives the next time the show machine is on the bench.

It's a little work but I never have to "Merge".


Jim

I do exactly as Jim does, it works well and I don't ever use Merge.

[Skybird74]

Originally Posted by madjim

Not true Sky. I'll import on either machine. I check every song on the disc against my database before I import to be sure that I don't enter a "double". I keep track of the DiscID's (not the BookID -Thanks again Dale) and transfer the KMA files I entered into one machine to the other using a jump drive. I rebuild the database ........ It's a little work but I never have to "Merge".
Jim

Good idea. I have always Merged just because that's what the Manual said to do.

[Skybird74]

Laddie, thanks for finding this program.
Jim, nice way to make it easy for everyone!

This program is MORE THAN I COULD HAVE HOPED FOR!!!!!!!

Everything is there all in one place, like magic!!!!!!!
It can be exported in .csv format, which can be read by Microsoft Works Database, which is already included with most computers, or Excel if you have it. From there it can even be printed.

Of course, you know I'd have a question - if you put the files in order by DiskID, a column is added entitled "Record ID", in addition to "Book ID". Is this possibly the order in which they were entered? If so, maybe now I can find those annoying Error 3315 files

[ddouglass]

All of the columns are there, but off screen, so you have to move the screen view to get to see them. Sort by RecordID so they will be in exactly the order Hoster rebuilds the database. Look for the first erroring record number. You shouldn't find it because it errored, but you should find the number before and after it. Then the two rows look back for the DiskID and track numbers above and below that track. That will tell you which track needs to be re-imported.

[Skybird74]

NOPE! All 8 record numbers that appeared with the Error 3315 are all there and the songs play fine.

In fact, the database says there are 8 MORE songs than the songbook shows.
The song book says it created 10,751 entries.
The database says there are 10,759.

And.... it's not the song (record number) before or after the number it errored on, either.

[ddouglass]

If that is the case are any of the fields blank? If not then I guess yours are not legitimate errors and those will have to wait until MTU can come up with a fix for this. I know that Admin said they were going to look at this specific problem this week. Only way I know for you to fix it would be to re-import those songs if you don't want to wait for a fix.
I didn' mean that the before or after files were the error but if it wasn't there then they would give you the information needed to re-import them.