Displaying only one "type" of a format

Dex Vinyl
Dex Vinyl
Offline
0
Hi Team,

Firstly let me say thanks for a great piece of software :)

My catalogue is 90% Vinyl and 10% Shellac and will never contain any other formats, I use the Type section to distinguish between different types of records both by size and content.

I would like to be able to effectively split my library into 12" and 7" for display purposes - can you please advise how i can do this?

Thanks in advance :)

Accepted Answer

Monday, January 12 2015, 06:54 PM - #Permalink
0
well, the only way would be to do it directly in the database... do you know MySQL?
The reply is currently minimized Show
Responses (6)
  • Accepted Answer

    Saturday, June 25 2022, 05:54 AM - #Permalink
    0
    Get custom vinyl records in Australia, from the labels to the grooves. Make your own vinyl records on-demand with your desired music, colors, patterns, and finishes.

    https://vinylpressing.com.au/wp-content/uploads/2022/06/custom-vinyl-records.jpg
    The reply is currently minimized Show
  • Accepted Answer

    Monday, January 12 2015, 07:27 PM - #Permalink
    0
    well, then you can try go to your phpMyAdmin and make a bulk MySQL query.. but be very careful because any change you make there, you can't undo..! so be very sure to know what you're doing...
    The reply is currently minimized Show
  • Accepted Answer

    Dex Vinyl
    Dex Vinyl
    Offline
    Monday, January 12 2015, 07:02 PM - #Permalink
    0
    I can get by in MySQL, I'm not the best but I'm sure I can manage it
    The reply is currently minimized Show
  • Accepted Answer

    Dex Vinyl
    Dex Vinyl
    Offline
    Monday, January 12 2015, 02:10 PM - #Permalink
    0
    Is there an easy way of making bulk changes?
    The reply is currently minimized Show
  • Accepted Answer

    Dex Vinyl
    Dex Vinyl
    Offline
    Monday, January 12 2015, 02:05 PM - #Permalink
    0
    we want to keep format to being the base format so vinyl and shellac and specify size in type.

    If we can't sort on type, we will have to re-do the rest of the library - doable but a pain in the arse, as we have over 500 items in now which are a mix of sizes
    The reply is currently minimized Show
  • Accepted Answer

    Monday, January 12 2015, 12:32 PM - #Permalink
    0
    well, you can simply use the "format" field for this.. can't you?
    The reply is currently minimized Show
Your Reply