iTunes cannot locate any songs in library
I'm using Mac OS High Sierra, v10.13.5 and iTunes for Mac, v12.7.5.9. This has been a problem for me for almost 2 weeks so I may miss a couple of steps to getting where I currently am. Here goes...
My initial problem was that I would add songs to iTunes and they would disappear if I close and reopen iTunes. I learned (by digging around my folders) that every time I re-added the songs iTunes would create another copy of the songs but they would still disappear. I decided to call Apple for support and that's when my problems got worse.
First technician had me move the .itl file to the desktop and reopen iTunes. It wouldn't open. She did a few other things I can't remember. Eventually she had me put the .itl file back and it STILL wouldn't open. She escalated the ticket to a senior advisor who I've been working with for going on 2 weeks! After much back and forth moving things around, making multiple copies of 14,000 songs he got me to the point where I could see all the songs but had lost playlists, dates added, ratings, play counts, etc. Frustration extremely high at this point. I showed him where my original files were located and we pointed to those and I can see the music, playlists, ratings, etc but...
- when I go to play a song iTunes cannot locate the song (exclamation points)
- I have a separate copy that will play because I have an Apple music subscription.
Now I have 28,000 songs and half are duplicates, half have exclamation points and I think I'm looking at a ton or work unless I can get an easier resolution in the community. My end goal is to get rid of the exclamation points, maintain the song information and ideally maintain the playlists. Sorry for being so wordy but I thought detail would be best. Thanks for any assistance you can provide.
MacBook Pro, Mac OS X (10.6.8)