topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • Saturday December 14, 2024, 10:07 pm
  • Proudly celebrating 15+ years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: Inventory Software  (Read 26245 times)

techidave

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 1,045
    • View Profile
    • Donate to Member
Inventory Software
« on: January 22, 2008, 12:58 PM »
Our school is looking for a good piece of software to help with inventory.  It must be able to record details about anything from a desk to a computer, printer, or even a bus!  If it could also record service info that would be good also.  I am thinking it needs to be able to work with bar codes and print out labels.  Printing reports would also be good.  it wouldn't have to be free but should be reasonable.

What have you guys used in the pass??  No, databases and me do not get along very well.

Dave

tanatos

  • Participant
  • Joined in 2006
  • *
  • Posts: 4
    • View Profile
    • Donate to Member
Re: Inventory Software
« Reply #1 on: January 22, 2008, 01:01 PM »
well i could be able to do this ... but no fancy mysql database storage but a simple file info storage.for a modic sum.msg me with details ;)

mouser

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 40,914
    • View Profile
    • Mouser's Software Zone on DonationCoder.com
    • Read more about this member.
    • Donate to Member
Re: Inventory Software
« Reply #2 on: January 22, 2008, 06:19 PM »
tanatos, we don't object to people on the forum arranging to work on paid programming projects outside of forum discussions, but this forum is almost exclusively about people coding stuff for free (though accepting donations after the fact if people want to support their work).

So while your intentions may be good, we discourage people from answering posts like this by offering to be hired for pay to do it.  If and when someone decides they want to hire a programmer for a job, that's a different matter and I encourage you to reply to such people directly.  Until then it would probably be better not to offer to work for hire when people post a request.  Might seem strange compared to other programming sites, but that's just the way we do it here.

Back to the subject, I know their are existing inventory programs, both local and web-based, i just don't know the names of them.  but surely some people here have some experience with them and it would be nice to hear from people who use such programs..

techidave

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 1,045
    • View Profile
    • Donate to Member
Re: Inventory Software
« Reply #3 on: January 22, 2008, 06:22 PM »
I am looking for those existing programs, just having problems finding one thats pretty much already setup for someone in IT to just start using.  We need if for insurance purposes as much as I need it to help me track what I have in what room or building.

Dave

mouser

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 40,914
    • View Profile
    • Mouser's Software Zone on DonationCoder.com
    • Read more about this member.
    • Donate to Member
Re: Inventory Software
« Reply #4 on: January 22, 2008, 06:24 PM »
I'm also interested in hearing what people use.  Hopefully we'll see some good pointers here, and please keep us updated in the thread with your findings if you try stuff and tell us what you come up with.

techidave

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 1,045
    • View Profile
    • Donate to Member
Re: Inventory Software
« Reply #5 on: January 22, 2008, 06:33 PM »
I will do that.  I just started looking a few hours ago but haven't found much taylored to my needs.  I suppose I could sit down with Access 2003 or 2007 or Filemaker Pro 8.5 and take a stab at it but building a database like this is kind of beyond my giftings.

dspelley

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 90
  • But it's a dry heat.
    • View Profile
    • Read more about this member.
    • Donate to Member
Re: Inventory Software
« Reply #6 on: January 22, 2008, 07:06 PM »
State Farm Insurance has a free download on their site for an inventory program called Possessions Matters

I think it's a fairly old program, and probably focused on home inventories, but since it's free you might want to take a look. It says it can print insurance claims, theft reports, etc.

I haven't tried it.
We are at the very beginning of time for the human race. It is not unreasonable that we grapple with problems. But there are tens of thousands of years in the future. Our responsibility is to do what we can, learn what we can, improve the solutions, and pass them on.
--- Richard Feynman (1918-1988)

dspelley

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 90
  • But it's a dry heat.
    • View Profile
    • Read more about this member.
    • Donate to Member
Re: Inventory Software
« Reply #7 on: January 22, 2008, 07:15 PM »
There's also a free asset management program called Pyxis on http://www.freshney.org/. Says it's intended for home and small business and looks like it's fairly customizable.

Again, I haven't used it.
We are at the very beginning of time for the human race. It is not unreasonable that we grapple with problems. But there are tens of thousands of years in the future. Our responsibility is to do what we can, learn what we can, improve the solutions, and pass them on.
--- Richard Feynman (1918-1988)

PPLandry

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 702
    • View Profile
    • InfoQube Information manager
    • Read more about this member.
    • Donate to Member
Re: Inventory Software
« Reply #8 on: January 22, 2008, 10:32 PM »
Our school is looking for a good piece of software to help with inventory.  It must be able to record details about anything from a desk to a computer, printer, or even a bus!  If it could also record service info that would be good also.  I am thinking it needs to be able to work with bar codes and print out labels.  Printing reports would also be good.  it wouldn't have to be free but should be reasonable.

What have you guys used in the pass??  No, databases and me do not get along very well.
I'm the developer of SQLNotes (www.sqlnotes.net) which has been discussed here at DC. It is half way between an information organizer and a database. It is based on a multi-user database and can easily be configured to perform inventories. It is very flexible, so extra stuff like service info can be recorded. It can also print summarizing reports and charts. The one missing feature is bar code printing, but this could be added if desired. Finally, data can be read by (and exported to) MS Office applications (Word, Excel, Access) and other ODBC-enabled applications.
Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz

techidave

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 1,045
    • View Profile
    • Donate to Member
Re: Inventory Software
« Reply #9 on: January 23, 2008, 05:56 AM »
I looked briefly at the programs that dspelley mentioned but its not quite what I want.  I will take a look at the SQLNotes but not sure how hard it will be to customize.

mouser

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 40,914
    • View Profile
    • Mouser's Software Zone on DonationCoder.com
    • Read more about this member.
    • Donate to Member
Re: Inventory Software
« Reply #10 on: January 23, 2008, 06:09 AM »
Keep searching, i think it would be helpful to more than a few people to hear what you find.

techidave

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 1,045
    • View Profile
    • Donate to Member
Re: Inventory Software
« Reply #11 on: January 23, 2008, 09:24 AM »
I stumbled across this one last night  Inventory Solutions which is a $30 shareware program.  Its tailored to home/office/church but has a number of the features I am looking for.  I haven't looked at the reporting part yet but am thinking its lacking.



http://www.fileflash.com/program/32229/


ps.  I did try attaching a screenshot I made using Screenshot Captor but it wouldn't post.  The attachment was only 126kb.

techidave

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 1,045
    • View Profile
    • Donate to Member
Re: Inventory Software
« Reply #12 on: January 23, 2008, 10:33 AM »
After trying it out a little more I decided that it wasn't quite what i was wanting.  Its not customizable and lacked some important (for me) fields that i thought it should have.  Here is a better link to the home page.  http://www.inventorysolutionsonline.net/

techidave

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 1,045
    • View Profile
    • Donate to Member
Re: Inventory Software
« Reply #13 on: January 23, 2008, 05:45 PM »
I guess I will give the SQLNotes a whirl and see if it is "user friendly".

keep the suggestions coming.

PPLandry

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 702
    • View Profile
    • InfoQube Information manager
    • Read more about this member.
    • Donate to Member
Re: Inventory Software
« Reply #14 on: January 23, 2008, 05:51 PM »
I guess I will give the SQLNotes a whirl and see if it is "user friendly".
I'll update the SQLNotes default template to include an inventory setup for you. Today or tomorrow.
Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz

techidave

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 1,045
    • View Profile
    • Donate to Member
Re: Inventory Software
« Reply #15 on: January 23, 2008, 06:13 PM »
Wow, thanks alot!  I cannot wait until I get back in the office on Friday.

PPLandry

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 702
    • View Profile
    • InfoQube Information manager
    • Read more about this member.
    • Donate to Member
Re: Inventory Software
« Reply #16 on: January 23, 2008, 06:33 PM »
Wow, thanks alot!  I cannot wait until I get back in the office on Friday.
If you want, list the information that you want to record and any other pertinent information. That will help me in creating the template.
Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz

techidave

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 1,045
    • View Profile
    • Donate to Member
Re: Inventory Software
« Reply #17 on: January 23, 2008, 09:12 PM »
will this be customizable?  that is can I change say the type of field from a text box to a drop down or change the label on the field?  or maybe tell it what i want the reponses to be?

or will all this have to be hardcoated?

PPLandry

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 702
    • View Profile
    • InfoQube Information manager
    • Read more about this member.
    • Donate to Member
Re: Inventory Software
« Reply #18 on: January 23, 2008, 09:33 PM »
Nothing is hard-coded in SQLNotes, so yes, you'll be able to change everything!

I just wanted to get an idea of your inventory requirements:
- Item name
- Item identifier (from bar code ?)
- Qty
- Approx. value or cost (gross, net)
- Location (i.e. room)
- Category
- Comments

It takes about 10 minutes to set it up
Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz

techidave

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 1,045
    • View Profile
    • Donate to Member
Re: Inventory Software
« Reply #19 on: January 23, 2008, 09:36 PM »
oh i just sent you a message with a spreadhseet attached but forgot to have a comment field.

PPLandry

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 702
    • View Profile
    • InfoQube Information manager
    • Read more about this member.
    • Donate to Member
Re: Inventory Software
« Reply #20 on: January 23, 2008, 09:59 PM »
The file was not included in the message, so you can send me the file directly.
Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
« Last Edit: January 25, 2008, 10:55 AM by PPLandry »

mouser

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 40,914
    • View Profile
    • Mouser's Software Zone on DonationCoder.com
    • Read more about this member.
    • Donate to Member
Re: Inventory Software
« Reply #21 on: January 24, 2008, 01:00 AM »
You guys might want to handle all the arrangements and back and forth details through personal messages so it doesn't get the thread off course. (but post the final results here please to keep us informed).

johnfdeluca

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 81
    • View Profile
    • Donate to Member
Re: Inventory Software
« Reply #22 on: January 24, 2008, 10:03 AM »
You might also want to consider Quicken Home Inventory.  Not sure if it will meet your business needs but worth a look-see.  I own it but as yet have not used it....however if you have specific questions or want me to send screencast, just let me know.
http://quicken.intui...home-inventory.jhtml
[attachthumb=#1][/attachthumb]
[attachthumb=#2][/attachthumb]

imtrobin

  • Charter Member
  • Joined in 2005
  • ***
  • default avatar
  • Posts: 125
    • View Profile
    • Donate to Member
Re: Inventory Software
« Reply #23 on: February 06, 2008, 10:54 PM »
Saw this recommended one
http://www.nolapro.com/index.php

jeremejazz

  • Supporting Member
  • Joined in 2009
  • **
  • Posts: 59
  • hey!
    • View Profile
    • Personal Website
    • Donate to Member
Re: Inventory Software
« Reply #24 on: February 05, 2010, 11:05 PM »
what programming language are you using?  ;D