Editing of Songs Database with Access and Saving to KMA Files

[aznetbear]

Hoster should just add the fields to the current Edit Songs option under Tools Menu. Additional fields would be, Song Title, Artist, Manufacturer, allowing changes to be made single or multiple.

Just a suggestion

[ddouglass]

Originally Posted by aznetbear

Hoster should just add the fields to the current Edit Songs option under Tools Menu. Additional fields would be, Song Title, Artist, Manufacturer, allowing changes to be made single or multiple.

Just a suggestion

Song Title and Artist are already there but only for single edit. Not for multiple.
Again anything that MTU does in this direction will be down the road and not in the near future as they are working on other items right now.

I have used this (Access) to change DiscID on 3 sets that were entered incorrectly when we imported them. And that is one thing I don't believe MTU would want in the Edit Songs dialog for everyone to be able to do.

[admin]

Originally Posted by aznetbear

Hoster should just add the fields to the current Edit Songs option under Tools Menu. Additional fields would be, Song Title, Artist, Manufacturer, allowing changes to be made single or multiple.

Just a suggestion

I'm not picking out anyone here. However, I AM PASSIONATE about this subject.

First... Aznetbear, Brand (Mfgr), Song Title, Artist, Genre, Language, Duet, Mux and "Hide in Songbook" fields ARE already in the Edit Songs dialog for you to change.

Edit DiscID: Our ONLY recommendation is to re-import the DiscIDs you messed up on. This method insures everyone - no matter how non-technical or technical they are - WILL safely correct their mistakes. The reason we DON'T add DiscID, is you MUST change all records (songs) with the same DiscID. If not, the songs originally from that DiscID are "fractured" across two numbers. However, some people WILL NOT change all the records for a DiscID. Yes we could add lots of error checks... if we had any free time and this was a problem for MANY users, but we don't and it's not. It HAS BEEN thoroughly thought out.

Edit BookID: The reason we don't allow changing BookIDs is it is very complex to do. Our current method is SAFE and INSURES everyone has a clean Songs Database. We have succeeded in "hiding the database" so non-technical users can enjoy this sophisticated technology, without getting frustrated. It has been extremely difficult, but our existing way is proven SAFE for everyone. "If it ain't broke, don't fix it" definitely applies here!

Even Ddouglass's proposal here is, IMHO, risky at best. Keep in mind... Dale is one of our most technically competent and deeply respected Hoster users. The "safety net" is those who bought ACCESS are probably more technical and able to conceptualize what they are doing. However, even experts can do damage because this is a VERY COMPLEX issue. We have spent thousands of hours over the years to create and maintain BookIDs.

If we start getting Support Tickets to fix Songs Database, I'll delete this Thread. We'll answer those Tickets with "Reinstall all your KMA files from you Backup Drive and rebuild your Songs Database." No backup? Well, after you re-import everything be sure to back them up this time.

[ddouglass]

I thoroughly agree with Admin. This is not for those who are non-technically inclined.
You need to have a thorough understanding of how database files work and in particular how this one works within Hoster. You also need to have a good working knowledge of Access. Don't go out and buy Access and think you can instantly be able to use this.
If you don't know exactly what you are doing then as Admin said Re-importing is the best way to go to correct items that cannot be done in the Edit Songs Utility.

[Beavis]

probably better off deleting this thread, those who know how to do it dont need this thread for help