How can I create a logging system in Drupal with the ability to download a .csv file
Hi, I work for a premiere licensed apparel company and I'm using a combination of Drupal and Gallery2 as a sales tool for our salespeople to see our t-shirts designs. I love Drupal alot and want to use it as a main hub to connect all departments in our company. I'm currently trying to find a way to create a system where we can:
-Log designs using a webform
-License (Disney, Marvel, etc.) Design name, design #, artist initials, product code, shirt colors, demographic, etc. (created as cck fields)
-Search by design name and #
-Filter by License (Disney, Marvel, etc.) Design name, design #, artist initials, product code, shirt colors, demographic, etc.
-Automatically assign the next design #, ensuring that there aren't any duplicate #s or names.
I would like to connect this to gallery2 if possible, but the first priority is getting a working logging system.
This company is currently using Illustrator cs2 to log designs. Who does that?! There is no way to handle data and prep it for a database or any other information solution.
Let me know if there are any modules that would allow me to do this or if anyone has any ideas. Thanks!
_
I would probably rethink the gallery2 part-- there's nothing you describe that drupal couldn't do easily without gallery2. Integrating with gallery2 just complicates things.
I would do this by creating a custom content type named "design", adding cck fields for the meta data you wish to collect and search (license, design #, artist, code, colors, etc), and use views to create the listings. Then filtering and searching by any of those pieces of information becomes trivial with views. Actually, I would consider using ubercart for this (even if you're not planning to sell the shirts online, as a lot of this type of functionality is built in to ubercart). For a good example, see http://www.oogliebooglie.com.
_
Don't be a Help Vampire - read and abide the forum guidelines.
If you find my assistance useful, please pay it forward to your fellow drupalers.
The thing I like about
The thing I like about gallery 2 is the "Upload Archive" feature that allows me to .zip directories that contain hundreds of images and let gallery2 unpackage them and place into galleries. Since we have thousands of designs that need to be available to remote sales people (special access through permissions), I figured that Gallery2 was the best way to go.
The site www.oogliebooglie.com looks like something I want to do to my own personal ecommerce site. I'll definitely experiment with ubercart. For my own personal site, i was just thinking about using Magento Commerce for the store portion and using Drupal for the community/blog portion, but it would be great to integrate it all into Drupal. I just figured that Magento would have alot more options for running a retail store and allowing room for growth. Everything is ready to go out of the box with magento, but I really like how oogliebooglie.com is set up using Drupal. Is this your personal site????
Thanks for your suggestions
_
No it's not my site, just one of the ones I found browsing around ubercart.org (i'm working on my first ecommerce site now)-- definitely checkout their live sites link, there's lots of cool sites to see. For me I'd much rather keep everything drupal then deal with integrations-- but I've never used magento so I'm not sure what, if anything, you'd be giving up.
_
Don't be a Help Vampire - read and abide the forum guidelines.
If you find my assistance useful, please pay it forward to your fellow drupalers.
Looking for drop-down filtering of lists.
For the filtering, I would like to be able to show the list of all the designs in a table format, I would like to have dropdown menus above the table so you can filter out the results. I looked around and was only able to come up with this:
http://drupal.org/project/views_filterblock
It isn't available for Druapl 6.x and I'm not completely sure if this is what will work for me. Not sure if that filtering setup is hidden somewhere else in a module's "BONUS" pack or something.
Any suggestions?? Maybe I don't know how to use views enough to create that??
Oh yeah...I wanna be able to
Oh yeah...I wanna be able to run some checks to make sure that names don't get duplicated along with assigning the next available #
Views Bonus Pack
Views Bonus Pack generates .csv files from views, which would work given that you're using CCK.
Okay, so the Views Bonus Pack
Okay, so the Views Bonus Pack is the part that handles .csv downloads. At first I looked at using WebForm, but that just sends an email and probably won't be the best solution for this. I just saw that you were able to download the complete table. I'm going to go with the custom content type first with the CCK bonus pack and see how it goes. Thanks for the tip!