I have an idea, looking to find a solution!

Member

Message

karrella

Joined: Aug 19, 2005

# Posts: 41

Posted: 07/25/2007 10:06 pm

I have an idea for my job to speed up productivity, its for a program but I think it might be able to be implemented as a wiki-type system with a search engine. If so I'm sure it would be no problem at all for a web expert type. (p.s. sorry if this is completely too off topic) I figured I'd ask my favorite experts here first. Where would be a good place to pitch my idea? I know there are a lot of "bid for the job" type code places but I don't know which would be decent.

If you are curious of my exact idea here it is.

Again this is for my job, I'm a comic store geek. Every week new issues come in the store and I have to sort the books people have ordered (subscribed to) into their reserve bag. Sometimes I miss an issue, and receive the wrath of a scorned geek! It's not pretty... anyways there is a ship list on the net that the distributor releases weekly with the exact contents of what we get. If I can somehow paste this list into the program and have it tell me exactly what books to pull each week for each member there is no possible way I can miss anything. At the moment all I'm doing is checking an index card of up to 50 book titles, comparing the contents on the table in front of me, and grabbing the books. If the program or code could search the ship list with the particular members subscribe list and output me what they should receive that week it would speed things up greatly! I could just click onto the next member, on and on and I'd be done in no time at all!

So to recap my ramble;

-It should be able to take in a text list of books "the weekly ship list".
-Save a list of members with an editable list of books they subscribe to.
-Compare (search) the ship list with the members reserve list and tell me what books are in (on both lists)
-Optionally save other data about the member, phone number etc.

I really think this could be done with something like the wiki software where I can have a start page with the list of the members, click on one see his list. "click next member" and continue through the bunch. If it could tell me how many members had a particular book on their list thats an awesome bonus! That would help with ordering.

Anyways I should hit the sack before I rant about this all night! LOL I'm pretty stoked about this idea if you cant tell!

(Copy Shortcut)

Curt

Joined: Eons Ago

# Posts: 3671

Posted: 07/26/2007 08:05 am

I'm not a database guru, but it would seem this task would be suited for a database program like MS Access. How you would implement a database to read in magazine titles I do not know.

(Copy Shortcut)

g1smd

Moderator

Joined: Jul 28, 2002

# Posts: 10057

Website

Posted: 07/26/2007 12:33 pm

Yes. A custom database solution would do that and more for you.

However, that isn't my area of expertise.

(Copy Shortcut)

mj1256

Joined: Jun 05, 2006

# Posts: 710

Posted: 07/26/2007 03:02 pm

access will do this

(Copy Shortcut)

karrella

Joined: Aug 19, 2005

# Posts: 41

Posted: 07/26/2007 10:50 pm

I checked out Microsoft Office Access 2007
Thank goodness it has a demo! Thats kinda pricey unless the student/home version will work for me.

Anyone tried it? Is it fairly user friendly, cause it's not just me but also my boss that needs to be able to understand it.

Thanks again guys =)

(Copy Shortcut)

g1smd

Moderator

Joined: Jul 28, 2002

# Posts: 10057

Website

Posted: 07/27/2007 12:54 pm

Download a copy of Open Office for free and you get most of the functionality of the Microsoft product but you get it all for free.

(Copy Shortcut)

flyingrose

Moderator

Joined: Oct 30, 2003

# Posts: 3361

Website

Posted: 07/27/2007 02:29 pm

That is great advice g1smd! I didn't know about Open Office but I am going to check it out.

(Copy Shortcut)

mj1256

Joined: Jun 05, 2006

# Posts: 710

Posted: 07/27/2007 06:15 pm

You may also just go to a freelancer website and hire someone to build the database for you. It may not be as expensive as you may think. Of course you need to look at all the factors such as, what is the value of your time, value of time saved, value of angry customers, value to accuracy, savings in the time it will take you to learn how to make the database, value of your time to keep revising it until you get it right, etc and you will see that it is affordable.

(Copy Shortcut)

You are not permitted to post messages in this forum or topic, because of one or more of the following reasons:

You have not yet logged in, or registered properly as a member
You are a member, but no longer have posting rights.
This is a private forum, for which you do not have permissions.

If you are a recent member, it's possible that you simply have not yet confirmed your account. Please check your email for a message entitled 'JimWorld Forums: Confirm Your Account' and follow the instructions contained within.

If you cannot find this message, click here to Re-Send it.

If you are still experiencing problem, please read the Login Assistance Article for some advice on what may be causing your login not to work properly.

Switch to Advanced Editor and ... Create a New Topic or Reply to this Thread

SEF