Dev LabelCompany2009 Transferring Existing Information To The New System

Label Company Proposal 2009 -
Home

Existing Information

The current data in the database is in a straightforward format of
'Label - Cat#'.

There can be one or several such pairings per release.

Transferring the Information

We could just do a direct transformation of the data, so label -> label
field, cat# -> cat# field, and label name goes into the cat# free
text field to tie them together.

However, we can do an improved transfer where we can knock out redundant
labels and / or catalog numbers. This will have the advantage of making
the display more concise, as well as showing the correct way to enter
multiple variations.

The script to do this would use the following logic:

Take all label strings, remove duplicates, and enter the remainder into the new 'entity' field, tagged as 'Label'.
Take all cat# strings, remove duplicates, and enter the remainder into the new 'number' field, tagged as 'Catalog Number'.
If we end up with only one label or cat#, then don't write anything into the cat# free text field.
Else, write the label/s that a catalog number refers to into the cat# free text field.

The possible combinations are listed below, together with the
transformation:

One label, one catalog number

Label = Discogs Records
Cat# = DR-001

Here we can just transfer the info directly across. No need for the free
text field.

One label, Two catalog numbers

Label = Discogs Records
Cat# = DR-001
Label2 = Discogs Records
Cat#2 = dr1

For this example, we can enter the label just the once, and list the two
catalog numbers. No need for the free text field.

Two labels, one catalog number

Label = Discogs Records
Cat# = DR-001
Label2 = NikDiscs
Cat#2 = DR-001

Here, we can list the two labels, and enter the cat# just once.

Two Labels, Two catalog numbers

Label = Discogs Records
Cat# = DR-001
Label2 = NikDiscs
Cat#2 = ND0239

Here, we want to transfer both labels and both catalog numbers across,
and list the labels in their respective cat# fields to tie them into
their labels.

Multiple labels and catalog numbers

Label = Discogs Records
Cat# = DR-001
Label2 = Discogs Records
Cat#2 = dr1
Label3 = NikDiscs
Cat#3 = ND0239
Label4 = Teo Music
Cat#4 = DR-001

Nice complicated example with multiple relationships.

Duplicate label names should be merged, so we get:

Label = Discogs Records
Label2 = NikDiscs
Label3 = Teo Music

Duplicate catalog numbers should also be merged, so:

Cat# = DR-001
Cat#2 = dr1
Cat#3 = ND0239

Finally, the cat# free text field is used to link the cat#s with the
labels:

Cat# = DR-001 (Discogs Records, Teo Music)
Cat#2 = dr1 (Discogs Records)
Cat#3 = ND0239 (NikDiscs)