Author Topic: Ok Programmers... Need some help! (Read 626 times)

Skuzzy · « **Reply #15 on:** April 01, 2005, 12:18:32 PM »

From a programming perspective, what you are asking for would be pretty trivial to accomplish.

However, acquiriing all the images you want would take mucho effort (read dinero, mullah, time, mo money!), if they are not already available from another source (such as the manufacturer).

koda76 · « **Reply #16 on:** April 01, 2005, 03:30:48 PM »

Theres an off the shelf product called NIM.(network inventory management) You can make containors and sub containors with part numbers and barcoded labels....nice stuff if you want to know where somethings at.

indy007 · « **Reply #17 on:** April 01, 2005, 04:41:56 PM »

Quote

Originally posted by Skuzzy
MySQL is hard to beat for database work in business and scales pretty well too. The price performance ratio is definately off the charts.

I'm liking it. It's easy & I had no previous DBA experience, just c++, VB, good ol' Pascal (that's what HS taught at the time), and a little assembly.

A web based front end though is no bad thing though. Crossplatform, easy to configure, hit it from anywhere.

price/performance ratio? It should cost $0

who needs to pay for tech support when you have google?

artik · « **Reply #18 on:** April 04, 2005, 11:34:16 AM »

Quote

Originally posted by Skuzzy

....
And no way would I ever use Windows for a server platform.

Are you running AH servers at Linux/UNIX machines?

Skuzzy · « **Reply #19 on:** April 04, 2005, 11:46:20 AM »

Solaris and FreeBSD artik

A WEB based front end is wrought with security issues. It's a bit clumsy for some things, other than look-ups as well.

artik · « **Reply #20 on:** April 04, 2005, 01:29:47 PM »

See,.. thanks... Actually it is quite expected. You need to run server with 700 connections load and not to reboot it for long time...

I wish there were Linux version of AH2...

I know your answer for this... You can't support two versions... But then I could finally drop MS Stuff.

indy007 · « **Reply #21 on:** April 04, 2005, 01:40:28 PM »

Quote

Originally posted by artik
See,.. thanks... Actually it is quite expected. You need to run server with 700 connections load and not to reboot it for long time...

I wish there were Linux version of AH2...

I know your answer for this... You can't support two versions... But then I could finally drop MS Stuff.

Worked for PDQ.Net straight out of highschool ('98). Average WinNT 4 server uptime: 29 days. Average unix (linux, freebsd, slackware) mixed: 180 days. The king: ns1.pdq.net - 391 days uptime.. only went down when we moved the entire NOC... couldn't get the UPS out w/o unplugging it, or woulda been longer

Pongo · « **Reply #22 on:** April 04, 2005, 01:57:15 PM »

"For those thinking web... NO! absolutely not. These computers will be isolated from the web to keep any unwanted problems out, and people seeking data out. There is no reason that this would be shared outside our company anyway"

Wish I got to retire a year earlier for every time a client made a statement like that they they later really really regreted.

Have you asked your suppliers if they have such a program? Do you have an accounting program? do you want purchase and billing integrated with your new inventory program?

"Sound like a major ordeal or what?"

It depends on your real requirments, which would of course be much more then you have stated. Or the worst case that you stated.

For example, if you meant that you would like the parts brake down diagram of a major assembly to be presented to you as a graphic and that you would like to be able to click on the graphic of a sub part and have all the data for that sub part show up. Thats a major deal.
Be sure that whoever you pay to do this has done something like it with references. Be sure you start with a study of what is available on the market like the nice people above have stated.

little issues like.
1 000 000 items. How many of those are like 400 of one item? How many different items? How many do you want the system to be able to handle worst case?
how many concurent users?
How smart do you want this system to be? the book you descibe cant reserve an item for 2 weeks subject to payment, do you want this system to be able to do that?
Do you want it to be able to send do an invoice for 3 merlins to Pongo and note that 3 merlins have to be ordered and know the sources for merlins? Maybe see that that one source has merlins in stock or on 3 months back order? Do you want it to know what washers by exaclty hold the urin tube on an avenger to the side of the cockpit and what sources and prices are typical for those washers? Anyway. Make sure who ever you get to do this askes lots and lots of questions of you and demonstrates that they have done this kind of work befor. No matter how limited you see your need right now decisions you make at the start will impact your ability to enhance the system later.
If someone offers to do the work for you and you will recoupe the cost by him selling it to other customers after its developed and share the profits just hang up.

Might be anoying but you want to hire someone that asks questions that indicate they have walked that road befor. If someone is telling you just what you want to hear it will be an expensive failure.

Skuzzy · « **Reply #23 on:** April 04, 2005, 02:28:29 PM »

Well done Pongo, however, a WEB interface is not always the best interface. There are pros and cons for any choices made. You just have to decide which ones you can live with and which ones you cannot live with.
I find the decision on which type of interface pretty much makes itself after that.

Nwbie · « **Reply #24 on:** April 04, 2005, 08:41:29 PM »

If you already have the inventory records in an excel database
Use Access- it is a no-brainer to import the files and the simple examples they have in the program will probably be all you need

NwBie