Consistency

[Fred Slota]

If we're going to sanction the database madness of repeating Cover Artist in both its dedicated CoverArtist field and the Notes field, can we at least settle on a consistent nomenclature?

 

I suggest "Cover by Joe Smith" or "Retailer Incentive Cover by Joe Smith", as opposed to "Joe Smith Cover" or "Joe Smith Retailer Incentive Cover".  This would allow searching for cover artist in the notes field.

 

As a related suggestion, notes about photo covers should use the form "Cover of model Jane Doe" as opposed to "Cover by model Jane Doe", clarifying the difference and allowing for consistent searches.

[Mark J. Castaneda]

we prefer the 'Retailer Incentive Cover by Joe Smith' format.

Problem is some of our users fight against this and send in data in their own style, we do our best to catch it before it gets integrated in the master database but it can be tough sometimes with hundreds of submissions coming in daily.

[Steven L. Dasinger]

In general, Cover Artist is moved to Item Description from the Notes column.

That is not to say that some Cover Artists have been left in Notes. It they are, it is due to them being part of a string that doesn't have the keywords CB is looking for to move the information.

[Fred Slota]

Sorry my mistake in naming the wrong field.  But, that was not the point of the post, which was to standardize the freeform text entry so that searches could be more reliably performed.