Duplicate entries


Duplicate entries

Author
Message
Paul Moore
Paul Moore
Forum Sage
Forum Sage (309K reputation)Forum Sage (309K reputation)Forum Sage (309K reputation)Forum Sage (309K reputation)Forum Sage (309K reputation)Forum Sage (309K reputation)Forum Sage (309K reputation)Forum Sage (309K reputation)Forum Sage (309K reputation)

Group: Forum Members
Posts: 738, Visits: 4.1K
Found something weird yesterday:
I'm current goign through the whole database re-reading every track and adding notes as I go along,
I've come across 4 duplicate carts so far, by dupclicate I mean excatly duplicate.
Cart 5064 and Cart 5064 both the same song, nope its not a miss print or a typo, I have 2 x 4 carts excatly the same !

Im going to copy the audio delete the cart, update,restart Autotrak and myraid and then reneter the audio, see if that cures it.
Not noticed this before but then havent been looking for it.

Anyone else spotted any duplicates ?
will keep you updated...

Regards,
Paul Moore

HitMix Radio
0792 858 1075


neilogden
neilogden
Forum Sage
Forum Sage (72K reputation)Forum Sage (72K reputation)Forum Sage (72K reputation)Forum Sage (72K reputation)Forum Sage (72K reputation)Forum Sage (72K reputation)Forum Sage (72K reputation)Forum Sage (72K reputation)Forum Sage (72K reputation)

Group: Forum Members
Posts: 184, Visits: 384
Its is possible (and perfectly acceptable) to have the same cart in more than one category.  If you have the same cart number appearing twice, that may be  what's happened.

Neil
Paul Moore
Paul Moore
Forum Sage
Forum Sage (309K reputation)Forum Sage (309K reputation)Forum Sage (309K reputation)Forum Sage (309K reputation)Forum Sage (309K reputation)Forum Sage (309K reputation)Forum Sage (309K reputation)Forum Sage (309K reputation)Forum Sage (309K reputation)

Group: Forum Members
Posts: 738, Visits: 4.1K
Thanks, will check later

Regards,
Paul Moore

HitMix Radio
0792 858 1075


Paul Moore
Paul Moore
Forum Sage
Forum Sage (309K reputation)Forum Sage (309K reputation)Forum Sage (309K reputation)Forum Sage (309K reputation)Forum Sage (309K reputation)Forum Sage (309K reputation)Forum Sage (309K reputation)Forum Sage (309K reputation)Forum Sage (309K reputation)

Group: Forum Members
Posts: 738, Visits: 4.1K
Checked tonight, the carts in question all have the same cart number and are all in the same category, fixed it now.
copy song to free cart, delet cart and info via autotrak, send playlist info across, add song again, duplicate now gone.

don't know how its happend but I have about 20 the same.
but not for long;-)

Regards,
Paul Moore

HitMix Radio
0792 858 1075


bernard
bernard
Forum Sage
Forum Sage (15K reputation)Forum Sage (15K reputation)Forum Sage (15K reputation)Forum Sage (15K reputation)Forum Sage (15K reputation)Forum Sage (15K reputation)Forum Sage (15K reputation)Forum Sage (15K reputation)Forum Sage (15K reputation)

Group: Forum Members
Posts: 43, Visits: 152
That's because it's also perfectly possible to enter the same cart in the same category more than once ... that song then gets played twice as much!
Paul Moore
Paul Moore
Forum Sage
Forum Sage (309K reputation)Forum Sage (309K reputation)Forum Sage (309K reputation)Forum Sage (309K reputation)Forum Sage (309K reputation)Forum Sage (309K reputation)Forum Sage (309K reputation)Forum Sage (309K reputation)Forum Sage (309K reputation)

Group: Forum Members
Posts: 738, Visits: 4.1K
True you can enter the same cart into duplicate categories as long as you give it a different song number, I think accidentaly the odd click into the song number section happened, could have been in the early days when we all used to hit space bar to start the song when editing it, as you do with adobe audition, but this wiped the song info.
Fixed in next release as we now have the tab focus on waveform feature !
Thanks for everyones help !

Regards,
Paul Moore

HitMix Radio
0792 858 1075


bernard
bernard
Forum Sage
Forum Sage (15K reputation)Forum Sage (15K reputation)Forum Sage (15K reputation)Forum Sage (15K reputation)Forum Sage (15K reputation)Forum Sage (15K reputation)Forum Sage (15K reputation)Forum Sage (15K reputation)Forum Sage (15K reputation)

Group: Forum Members
Posts: 43, Visits: 152
Actually, would it be useful to have a find duplicates function (rather than try doing it in Access) ?  Find duplicates in any category or find duplicates in a specified category

This might help when there are several people adding tunes to the audio wall and thus to Autotrack when sometimes they (I) don't check if they already exist on the system somewhere else

Just an idea, but as years go by and audio walls and databases get fuller, it's a bit needle and haystack but would help in some ways I think
David Boulton
David Boulton
Brand Manager - Broadcast Radio
Brand Manager - Broadcast Radio (232K reputation)Brand Manager - Broadcast Radio (232K reputation)Brand Manager - Broadcast Radio (232K reputation)Brand Manager - Broadcast Radio (232K reputation)Brand Manager - Broadcast Radio (232K reputation)Brand Manager - Broadcast Radio (232K reputation)Brand Manager - Broadcast Radio (232K reputation)Brand Manager - Broadcast Radio (232K reputation)Brand Manager - Broadcast Radio (232K reputation)

Group: Broadcast Radio
Posts: 562, Visits: 74K
bernard (22/02/2011)
Actually, would it be useful to have a find duplicates function (rather than try doing it in Access) ?  Find duplicates in any category or find duplicates in a specified category

This might help when there are several people adding tunes to the audio wall and thus to Autotrack when sometimes they (I) don't check if they already exist on the system somewhere else

Just an idea, but as years go by and audio walls and databases get fuller, it's a bit needle and haystack but would help in some ways I think


But you already can BigGrin

Songs tab, search all songs, sort by title - this of course won't take into account miss-spelling of the title or artist. You can then mass change some of the duplicates into a "held" category, or mass delete them.

If you access the database directly through Microsoft Access, and delete some data, there is a potential that you could remove dritical data, and we might not be able to open the database in Autotrack (and then all your work is gone).

Also you can check out the Autotrack Information Browser (Songs Menu> Artist Names), here you can tidy up spellings and see which song cards are associated with which artists - you can also remove unused titles and names.

Regards

David Boulton
Brand Manager
Broadcast Radio Ltd
Roger Woods
Roger Woods
Forum Sage
Forum Sage (50K reputation)Forum Sage (50K reputation)Forum Sage (50K reputation)Forum Sage (50K reputation)Forum Sage (50K reputation)Forum Sage (50K reputation)Forum Sage (50K reputation)Forum Sage (50K reputation)Forum Sage (50K reputation)

Group: Forum Members
Posts: 136, Visits: 623
All,

Found the feature David wrote about above the other day, when I finally had some time to play with Autotracks!

That's how I discovered all the duplicates we had on our system.

I have also used Myriad Manager to create a music report of the Audiowall and export that to a CSV file which I could then open in MS Excel, this gave me a total over view of the  Audiowall and again using MS Excel's sort feature was able to list by artist, title, etc.  

Roger.

Roger Woods
Producer/Presenter/Engineer
GO


Reading This Topic


Login
Existing Account
Email Address:


Password:


Select a Forum....





























Broadcast Radio Forums


Search