A Drum Shop Database Thread

[Jeremy Bender]

Can we get a drum shop list as a reference tool similar to how a phone book used to show? If someone has a shop to add to the list they could do this somehow.

Have this as a sticky in the general discussion forum.

They would be listed by country - USA / Canada / U.K. / Australia et al.

 

[MrInsanePolack]

Can we get a drum shop list as a reference tool similar to how a phone book used to show?

I think that's a cool idea. Now who here remembers how to use a phone book lol?

 

[organworthyplayer337]

my contribution:
Memphis Drum Shop
2112 Percussion
Rupp’s Drums
Drum Center of Portsmouth
Cymbalism Music
Philadelphia Drums and Percussion
Steve Weiss Music

 

[bermuda]

Good idea, listings should be concise with just the necessary info:

Store name / City, ST, Country / web site

Dedicated drum shops only, and full-line or chain stores with exceptional drum departments (such as the Hollywood, CA Guitar Center and adjacent Sam Ash stores.) I suppose online stores count as well.

A single post reflecting the submissions could be assembled/updated from member posts.

#Bernhard ?

 

[Liam]

Mabey a spreadsheet like this.

 

[Xstr8edgtnrdrmrX]

I could create a Google Drive spreadsheet, adn we could sticky the link somehow....

 

[bermuda]

Not sure a spreadsheet can be displayed in a thread, or if it's really necessary. A simple 'laundry list' of shops (in order by country I assume) should be sufficient. If the list becomes so long that the page needs to be searched, it's a simple browser function (usually ctrl+F for Windows.)

I've run it by Bernhard and the other mods, and volunteered to oversee it. Let's see what happens.

 

[bermuda]

I could create a Google Drive spreadsheet, adn we could sticky the link somehow....

Not familiar with all of the Google functions, but if it's easy to access and navigate, that could be cool. Is it possible to sort/order entries by a particular field (such as state, country, etc.) as a database does?

 

[Liam]

Google Spreadsheets are similar to excel but with less functionality, you would be able to sort the fields alphabetically or numerically.

If you are trying to post the sheet, you can use a link that anyone can see or, embed it on a website.

 

[someguy01]

Drum City Guitarland, Wheat Ridge, CO 303.421.4515 https://www.drumcityguitarland.com/
Rupp's Drums, Denver, CO 303.756.5777 https://www.ruppsdrums.com/
Denver Percussion Centennial, CO 866.737.2877 https://www.denverpercussion.com/
Bill's Music Catonsville, MD 410.747.1900 https://www.billsmusic.com/
Chuck Levin's Washington Music Center Silver Spring, MD 301.946.8808 https://chucklevins.com/
I have done business with everyone on this list and would recommend them to anyone.

 

[Ransan]

Good idea!

Bentleys Fresno, CA.

I’m curious as to how the spreadsheet looks when it’s presented. Is it going to be a static directory?
Would there be a master user with few sub users or will the spreadsheet be updated by anyone and everyone?

Primarily .xls are what I recommend as I am more comfortable with the layout, security, and support.
Google sheets is just as functional, just a bit different as it promotes communal data inputs. This measure is less secure as one can easily update the spreadsheet in a live environment. Good thing about G sheets are, there is an audit functionality that will color trail the last users edit activity.

Both xls and G sheets will allow you to lock cells or protect worksheets so no overwriting takes place, securing the worksheets integrity.

(My profession requires me to live in spreadsheets and use both with high proficiency)
————————

What about a ‘link within a link’ page kinda like drum archive. Where you select the logo link and it takes you to their site?

 

[Liam]

Mabey add a page to the drummerworld website with the list of stores, also a search feature for city/town would be useful.

 

[GruntersDad]

The wedsite for eash cite should have a map. Keep it simple. Store name, City, website, should handle it.

 

[bermuda]

I also prefer the simplicity of each listing, the web site will have their additional necessary info. Still not sure that a spreadsheet is an advantage though. I would expect maybe 150-200 listings tops, and those will be simple enough to view by country (and state state/province where applicable) on a 'laundry list' of stores. That also helps keep clicks/navigation to a minimum. Much simpler to have their site listed in the post, rather than clicking to open another page/site, just to see the same link there.

 

[Ransan]

Not familiar with all of the Google functions, but if it's easy to access and navigate, that could be cool. Is it possible to sort/order entries by a particular field (such as state, country, etc.) as a database does?

Yes Google sheets is almost just as computational as Excel. They both centralize data very well for tracking and what not.

G sheets have mostly the same types of calculations, filters and sorting sequencing commands as Excel. The sort/filters are highly adjustable with layering definitions.
Not as much logic formulas, but better for group collaboration.

I’d put it like this, when building financial models, I would not be doing so in G sheets.

For this project - both would suffice really well.
Just a matter of delivery to forum that would essentially make sense.

 

[larryace]

If this is going to be done...it seems that we would have to organize them by state, right?

Otherwise people would have to read every post

 

[Ransan]

If this is going to be done...it seems that we would have to organize them by state, right?

Otherwise people would have to read every post

Yep, to be effective and efficient, databases would work. Could sort however you want alpha, state, etc…

Which is why the thread posts simply won’t work.
There will be duplication after a while and no updates so the integrity would eventually lose to convolution.

Well that’s my input on the subject, good luck!

Let me know if I can help!

 

[MrInsanePolack]

If you open the thread, then use the search function for this thread only, it will display specific posts. For example, I searched "Denver" (because I knew it was in there somewhere) and this came up:


So if just using the search function, you can type in a city/state/country and DW will find it for you.

 

[larryace]

Brian that's too easy.

We simply must complicate it.

 

[Captain Bash]

Brian that's too easy.

We simply must complicate it.

I agree with Larry, let’s complicate this, first up I live in England, UK (the real one not the Noble and Cooley Xanadu) and over here there is no such thing as a geographic state, the queen won’t allow it.
The term you are reaching for is County. So the naming headers should run City/County/Country. British people will get confused if you ask them for information on their state. My current state is antagonistic.