swampthing
Mark VII Class
- Joined
- Jun 28, 2012
Just got back from holiday and found this going on. I thought I was crazy. Mark, this is Amazing!
G45 GBase Thinktank
- Thread starter bosshoss
- Start date
- Joined
- Apr 20, 2011
- Location
- The shores of southern CT
i would also suggest adding these to the wax details
Instead of catalog number, change wording to read as label catalog number
Add: Matrix number/Pressing Code directly underneath label catalog number
Add Pressing account number/Code under that
For instance, the MY label out of Arkansas uses both on the label. for years, some people source the master number as the label # which is incorrect. The Dutch Masters "The Expectation" Label number for example should show as label catalog number 2926
master number/pressing code would be U4KM8053
pressing account code would be 618E
Just to be thorough!
Not every release will have / include this information on the 45, but in this example all three fields are essential.
This way, a database sort can be done to find all 45s with the 618E account code.
Instead of catalog number, change wording to read as label catalog number
Add: Matrix number/Pressing Code directly underneath label catalog number
Add Pressing account number/Code under that
For instance, the MY label out of Arkansas uses both on the label. for years, some people source the master number as the label # which is incorrect. The Dutch Masters "The Expectation" Label number for example should show as label catalog number 2926
master number/pressing code would be U4KM8053
pressing account code would be 618E
Just to be thorough!
Not every release will have / include this information on the 45, but in this example all three fields are essential.
This way, a database sort can be done to find all 45s with the 618E account code.
- Joined
- Apr 12, 2011
- Location
- Sydney, Australia
It would be great to allow members to add their own ratings via some kind of interface. But it would require some complex programming, and it's already quite a major project. There would have to be a default rating applied at the time the 45 entry was created, otherwise it would have no rating until someone voted. Who knows, maybe nobody would vote for weeks or months. It would have to be something like the Apple app store ratings, where it says something like "Average rating 5 stars, 3 votes counted". The other option is to use TBM ratings, rounded off to a 5 star rating system, which I think Mike is ok with. But that would only apply to USA entries, of course.
JGTiger
Mark VII Class
- Joined
- Apr 24, 2011
- Location
- The Mountains
Great idea, Bosshoss- reading this thread. I would contribute matrix #s etc...
Hicksville Hogwash
Tennalaga Class
- Joined
- Apr 11, 2012
- Location
- Gauley Bridge, West Virginia.
The whole idea sounds like complex programming to me, so why not make it really complex? Averaging star ratings can't be too hard! Can it?
I think if you can get minimum involvement from the many rather than maximum from the few. It will become more.. Fun. :oops:
Involvement from the Comp Collectors and Bottom Feeders (like me) is going to fill out some fields way quicker than waiting on the Big Time collectors to enter every matrix, town, style, pressing plant......
. At least they know the songs and bands and a few of these details. OK there will be many holes that will need filling but better that than a few very well detailed sterile artifacts standing in a virtual museum of white walls and empty plinths.
- Joined
- Apr 12, 2011
- Location
- Sydney, Australia
True. I'm sure Aaron could handle it.
- Joined
- Apr 20, 2011
- Location
- The shores of southern CT
I think the whole point of the database is creating an accurate catalog which can be downloaded by the user for their own purposes (inventory, personal "ratings" etc. The "Style" category will be nightmare to wade thru because everyone will have their own bias. Therefore, certain fields should only be keyed by administrators to avoid duplicity, error, etc. and others left blank for users to put their own input in via download.
I can easily convert ratings to a five star rating because I have the entire TBM rating data file broken down vote by vote in decimal format. I've already began working on the G45 list tabulation based upon the formula Mark gave to me which weighs the 3 factors (rarity, legend, song rating).
I don't want to be a stick in the mud, but some of these concepts sort of undercut all of the work I did for the book. I would like to keep at least some of the concepts unique for the time being, at least. I will gladly contribute my hard data.
I can easily convert ratings to a five star rating because I have the entire TBM rating data file broken down vote by vote in decimal format. I've already began working on the G45 list tabulation based upon the formula Mark gave to me which weighs the 3 factors (rarity, legend, song rating).
I don't want to be a stick in the mud, but some of these concepts sort of undercut all of the work I did for the book. I would like to keep at least some of the concepts unique for the time being, at least. I will gladly contribute my hard data.
- Joined
- Apr 12, 2011
- Location
- Sydney, Australia
The database concept will definitely be optimized to work with TBM, not against it. In order to achieve that, I'll be working closely with Mike at every stage.
- Joined
- Apr 12, 2011
- Location
- Sydney, Australia
Here's how the data entry screen is shaping up. About one third of the data fields are in place so far. There will also be buttons to click to allow uploading scans and possibly soundfiles. It's my first attempt at web programming, so don't laugh, I've learnt how to do this from scratch in less than a week! You can fill in the fields to see how it feels, but no data will be saved.
http://www.g45central.com/G45dataentry.html
http://www.g45central.com/G45dataentry.html
- Joined
- Apr 12, 2011
- Location
- Sydney, Australia
It would need a lot more than just having the "LP" tag added, unfortunately. Each LP would need unlimited tracks, unlimited artists for compilation LPs, unlimited star ratings per LP, unlimited links to youtube, unlimited this, unlimited that. The only way to handle LPs would be to completely re-design the whole system as primarily a "songs" database, linked to various tables containing format information. If a "song" existed only on a compilation LP, then some of the existing data fields would not apply, or would be unknown. The scope and workload would be widened considerably, and focus on 45s would be lost. I'm even considering eliminating EPs, because they are really a mini-LP.
- Joined
- Apr 12, 2011
- Location
- Sydney, Australia
Since you mentioned it Paul, I'm actually considering redesigning the underlying data structure as "songs". For each "45" format entry there would be 2 songs for example Record # S123456A and # S123456B, with "S" denoting a "Single". They would be separate data entries, but always displayed as a linked pair by the database user interface programs, including the data entry console. This would allow for the eventual easy expansion to other formats including EPs, and LPs, even if it is currently restricted to 45s. LPs tracks could be stored as #L12345A1, L12345A2, L12345A3 L12345B1..etc, with the A1 representing "sida A, track 1" (of LP #12345). We could spend the first couple of decades on 45s, and press on with the rest after that...
soundog III
Tennalaga Class
- Joined
- Apr 24, 2011
- Location
- New York
How many documented, and, presumably more specific to this course of discourse, undocumented garage LP's are there? A paltry handful of killers at beast. As in a dozen or so US, and a couple times that ex-US.
Ghettoize the LP's in their own enclave with the facts spelled out in detail.
Lets get real here , there are perhaps several dozen universally acknowledged contenders at most. With an allowance for a bit more expansive overview regarding worldwide beat age waxings. All the additional scholarly addendum that might serve to clutter up the site would / should / could be readily available online. A one stop overview ought to be sufficient to cover the handful of worthy contenders...
Outliers, recent Discoveries & the tragically ( un-remarked upon) candidates for inclusion would (hopefully) be proposed from precincts flung far & wide.
Keep this a 45 centric site is my sentiment.
Laurent Bigot
Ikon Class
- Joined
- Apr 21, 2011
- Location
- Paris, France
Basically you're not interested in LPs so this thing should be 45 only... Like adding Lps would take something away from anyone? The only good reason I can see in not including LPs is technical, if it's too complicated.
Hicksville Hogwash
Tennalaga Class
- Joined
- Apr 11, 2012
- Location
- Gauley Bridge, West Virginia.
Looking good to me Boss
, a few silly things like; countries are going to have to be really expanded a lot just quickly no Germany, Greece, Argentina or Peru. ...and you'll piss off Wales for no inclusion, I'd go for UK (England, Wales, Scotland and Northern Ireland!) but that'll piss off the Scots
. maybe an OTHER option with a type in box?
But over all looks pretty user friendly to me.
The EP, LP thing maybe put in a Number of tracks option then a track listing field? But I'm with soundog it's G45 Not G331/3. Keep it simple, stupid.
, a few silly things like; countries are going to have to be really expanded a lot just quickly no Germany, Greece, Argentina or Peru. ...and you'll piss off Wales for no inclusion, I'd go for UK (England, Wales, Scotland and Northern Ireland!) but that'll piss off the Scots. maybe an OTHER option with a type in box?But over all looks pretty user friendly to me.
The EP, LP thing maybe put in a Number of tracks option then a track listing field? But I'm with soundog it's G45 Not G331/3. Keep it simple, stupid.
Monster Mike
Ikon Class
- Joined
- Feb 1, 2013
Looks great!
soundog III
Tennalaga Class
- Joined
- Apr 24, 2011
- Location
- New York
Uh, no.
Simply list LP's in a distinct section. How much is there to be discovered regarding "garage" LP's anyway? The worldwide total is mighty close to finite. For example, if iit must be done list all the lame-o Justice titles once & be done with it. Half baked frat, so what?? Once Barbarians, Remains, Watchband, Sonics, Tempo's, Elevators, etc... are listed that'll be that. People can comment all they want. It shouldn't be too very complicated to have a section dedicated to them.
Regarding non-US beat LP's things are considerably more varied, though still not particularly abundant. Funny thing is I can't recall a single thread / topic ever posted on this forum or it's predecessor addressing this topic. For example how many killer garage LP's are there from Sweden. Zero, perhaps? Denmark? One for sure. Italy? The Piper Club sampler is the only one that immediately comes to mind.. France? Zero. Spain? Ditto. Regarding Germany a few Star club samplers have strong tracks. But an entire beat / garage LP by a single band? That kills? Not sure I can think of one.
Aside from the US/UK only Netherlands & Australia spring to mind as countries that released more than a handful of genuine KILLER LP's. As in 3 or more *** out of five. And if Psych, Instrumental / Frat & major label releases are excluded the total of candidates becomes vanishingly small.
I like LP's just fine. The fact is that there are very few bona-fide killer LP's in this genre.
Here's a question. Can anyone reading this add any live LP's to the ones pictured below? (And yes, I realize "Beat Bomb" is not live)
Frantic
G45 Legend
- Joined
- Apr 20, 2011
What he said
- Joined
- Apr 12, 2011
- Location
- Sydney, Australia
I've take note of all the comments above, and will find useful hints in all of them. Thanks!
I had to re-design the Console. It was just too hard to program multiple buttons on the same line. so I reduced all elements to one item per line. It also reads better i think. As H. Hogwash noted, the options menus are not complete, so help on this aspect is appreciated.
http://www.g45central.com/G45dataentry2.html
The style options are not worked out properly yet. Please let me know what descriptive words you think are needed. But remember that the final list will have to pass the scrutiny of Professor Moptopmike.
I had to re-design the Console. It was just too hard to program multiple buttons on the same line. so I reduced all elements to one item per line. It also reads better i think. As H. Hogwash noted, the options menus are not complete, so help on this aspect is appreciated.
http://www.g45central.com/G45dataentry2.html
The style options are not worked out properly yet. Please let me know what descriptive words you think are needed. But remember that the final list will have to pass the scrutiny of Professor Moptopmike.
Similar threads
