Porforis
12 years ago
I can't think of the correct term (Close to configuration management but not quite), but our company's looking for a system with which to efficiently document various known-working product configurations - basically, what parts have been actually tested with what other parts and what is an "official" product build. Up until now it's been done in an excel spreadsheet which doesn't lend itself well to maintainability, and it's extremely hard to implement complex tables and the like in our internal wiki.

In a perfect world I'd like a system where you could enter a part number or product name into a search box and be linked to all known product configurations using said part. Which I think is technically possible using our antiquated inventory and payroll system, but it's extremely far from user-friendly. This would be possible in a wiki if you made a page for every part, however if you ever change a builds, you'd need to manually edit any affected products' pages to reflect the changed builds.

I thought I'd poke and see if anybody's used such a system before or could at least let me know the technical term I'm looking for to assist me in my search - at the moment our company is in catch-up mode after years of terrible documentation, and while we've been saturating our wiki with information, the more we go on the more time it's going to take to maintain the wiki as products change and new products are built.
PackFanWithTwins
12 years ago
Sounds like you are looking for some flavor of Product Management program. There is probably one out there, but they vary.

If you track them with Excel, some small Database might do the trick if somebody had programming ability.
The world needs ditch diggers too Danny!!!
Porforis
12 years ago

Sounds like you are looking for some flavor of Product Management program. There is probably one out there, but they vary.

If you track them with Excel, some small Database might do the trick if somebody had programming ability.

Originally Posted by: PackFanWithTwins 



A lot of the information we're looking to organize is already in a database, unfortunately the program to run queries is barely more user-friendly than having to run manual SQL queries - We've already developed a web-based frontend for this system for time-logging purposes but I don't think IT is going to want to devote the time needed to create a similar frontend for this purpose.
PackFanWithTwins
12 years ago

A lot of the information we're looking to organize is already in a database, unfortunately the program to run queries is barely more user-friendly than having to run manual SQL queries - We've already developed a web-based frontend for this system for time-logging purposes but I don't think IT is going to want to devote the time needed to create a similar frontend for this purpose.

Originally Posted by: Porforis 



My best guess, again without knowing exactly what you are dealing with and what really looking for. Is that what you want is going to be something that is going to be custom.
The world needs ditch diggers too Danny!!!
4PackGirl
12 years ago
[wtf] 🤔 i'm sure you're speaking some form of the English language but...i'm just not sure!!! 😕 🤷
Pack93z
12 years ago
Platforms? I assume SQL 2005 or 8.

What types of products are we talking about... single level bills? Tiered?

Is this just a management tool or is there a need to tie it into a order processing platform?

Do you want the interface to be web driven, client based?

Or business here is a tier bill of materials for residential and commercial windows.. we use a configuration driven Q&A with the options tied to multiple choice questions.. stock verse custom. Each question will drive the bill for the related choice.

From the engineering standpoint, all parts are maintained in tables, pulled with scripting logic. But a simple query can pull back all parts and where they are used in the configurations based on product type and option.

All parts are kept in a single item master table with all purchase, stocking and costing information.

"The oranges are dry; the apples are mealy; and the papayas... I don't know what's going on with the papayas!"
Porforis
12 years ago

Platforms? I assume SQL 2005 or 8.

What types of products are we talking about... single level bills? Tiered?

Is this just a management tool or is there a need to tie it into a order processing platform?

Do you want the interface to be web driven, client based?

Or business here is a tier bill of materials for residential and commercial windows.. we use a configuration driven Q&A with the options tied to multiple choice questions.. stock verse custom. Each question will drive the bill for the related choice.

From the engineering standpoint, all parts are maintained in tables, pulled with scripting logic. But a simple query can pull back all parts and where they are used in the configurations based on product type and option.

All parts are kept in a single item master table with all purchase, stocking and costing information.

Originally Posted by: Pack93z 



This wouldn't (need to) be tied into an order processing/inventory system. This is strictly for purposes of documenting tested and approved part configurations, web-based would be nice but not 100% necessary since this would be for internal use only. What irritates me about this is that we've already got the data, it already populates to a SQL database, and developing a web-based frontend to run specific queries for specific uses isn't that hard - it's just not something anybody wants to dedicate any time to (yet, until they overhaul the whole system). Ideally it'd be a completely desperate application, but the more I think about it the more I think it wouldn't be the end of the world to halfass it in our wiki until they overhaul our entire inventory and billing application and develop a web-based front end for it, which supposedly will happen Juneish.
Similar Topics
Users browsing this topic
    Fan Shout
    dfosterf (1h) : Nobody coming up with a keep, but at x amount
    dfosterf (1h) : Trade, cut or keep
    dfosterf (2h) : that from Jaire
    dfosterf (2h) : My guess is the Packers floated the concept of a reworked contract via his agent and agent got a f'
    Zero2Cool (2h) : Yes, and that is why I think Rob worded it how he did. Rather than say "agent"
    dfosterf (2h) : Same laws apply. Agent must present such an offer to Jaire. Cannot accept or reject without presenting it
    Zero2Cool (2h) : I'm thinking that is why Rob worded it how he did.
    dfosterf (2h) : The Packers can certainly still make the offer to the agent
    dfosterf (2h) : Laws of agency and definition of fiduciary responsibility
    dfosterf (2h) : Jaire is open to a reduced contract without Jaire's permission
    dfosterf (2h) : The agent would arguably violate the law if he were to tell the Packers
    Zero2Cool (3h) : That someone ... likely the agent.
    Zero2Cool (3h) : So, Jaire has not been offered nor rejected a pay reduction, but someone says he'd decline.
    Zero2Cool (3h) : Demovksy says t was direct communication with someone familiar with Jaire’s line of thinking at that moment.
    Zero2Cool (3h) : Demovsky just replied to me a bit ago. Jaire hasn't said it.
    dfosterf (5h) : Of course, that depends on the definition of "we"
    dfosterf (5h) : We have been told that they haven't because he wouldn't accept it. I submit we don't know that
    dfosterf (5h) : What is the downside in making a calculated reduced offer to Jaire?
    Zero2Cool (21h) : Packers are receiving interest in Jaire Alexander but a trade is not imminent
    Zero2Cool (15-Apr) : Jalen Ramsey wants to be traded. He's never happy is he?
    Zero2Cool (15-Apr) : two 1sts in 2022 and two 2nd's in 2023 and 2024
    Zero2Cool (15-Apr) : Packers had fortunate last three drafts.
    dfosterf (15-Apr) : I may have to move
    dfosterf (15-Apr) : My wife just told the ancient Japanese sushi dude not enough rice under his fish
    Zero2Cool (14-Apr) : I think a dozen is what I need
    dfosterf (14-Apr) : Go fund me for this purpose just might work. A dozen nurses show up at 1265 to provide mental health assistance.
    dfosterf (14-Apr) : Maybe send a crew of Angels to the Packers draft room on draft day.
    Zero2Cool (14-Apr) : I am the Angel that gets visited.
    dfosterf (14-Apr) : Visiting Angels has a pretty good reputation
    Zero2Cool (14-Apr) : what
    Martha Careful (14-Apr) : WINNING IT, not someone else losing it. The best victory though was re-uniting with his wife
    Martha Careful (14-Apr) : The manner in which he won it was just amazing and wonderful. First blowing the lead then getting back, then blowing it. But ultimately
    Zero2Cool (12-Apr) : I'm guessing since the thumb was broken, he wasn't feeling it.
    dfosterf (10-Apr) : Looking for guidance. Not feeling the thumb.
    Mucky Tundra (10-Apr) : If they knew about it or not
    Mucky Tundra (10-Apr) : I don't recall that he did which is why I asked.
    Zero2Cool (10-Apr) : Guessing they probably knew. Did he have cast or something on?
    Mucky Tundra (10-Apr) : Did they know that at the time or was that something the realized afterwards?
    Zero2Cool (9-Apr) : Van Ness played most of season with broken thumb
    wpr (9-Apr) : yay
    Zero2Cool (9-Apr) : Mark Murphy says Steelers likely to protect Packers game. Meaning, no Ireland
    Zero2Cool (8-Apr) : Struggling to figure out what text editor options are needed and which are 'nice to have'
    Mucky Tundra (8-Apr) : *CHOMP CHOMP CHOMP*
    Zero2Cool (2-Apr) : WR who said he'd break Xavier Worthy 40 time...and ran slower than you
    Mucky Tundra (2-Apr) : Who?
    Zero2Cool (2-Apr) : Texas’ WR Isaiah Bond is scheduled to visit the Bills, Browns, Chiefs, Falcons, Packers and Titans starting next week.
    Zero2Cool (2-Apr) : Spotting ball isn't changing, only measuring distance is, Which wasn't the issue.
    Zero2Cool (2-Apr) : The spotting of the ball IS the issue. Not the chain gang.
    Mucky Tundra (2-Apr) : Will there be a tracker on the ball or something?
    Zero2Cool (1-Apr) : uh oh
    Please sign in to use Fan Shout
    2024 Packers Schedule
    Friday, Sep 6 @ 7:15 PM
    Eagles
    29 - 34
    Sunday, Sep 15 @ 12:00 PM
    COLTS
    16 - 10
    Sunday, Sep 22 @ 12:00 PM
    Titans
    30 - 14
    Sunday, Sep 29 @ 12:00 PM
    VIKINGS
    29 - 31
    Sunday, Oct 6 @ 3:25 PM
    Rams
    24 - 19
    Sunday, Oct 13 @ 12:00 PM
    CARDINALS
    34 - 13
    Sunday, Oct 20 @ 12:00 PM
    TEXANS
    24 - 22
    Sunday, Oct 27 @ 12:00 PM
    Jaguars
    30 - 27
    Sunday, Nov 3 @ 3:25 PM
    LIONS
    14 - 24
    Sunday, Nov 17 @ 12:00 PM
    Bears
    20 - 19
    Sunday, Nov 24 @ 3:25 PM
    49ERS
    38 - 10
    Thursday, Nov 28 @ 7:20 PM
    DOLPHINS
    30 - 17
    Thursday, Dec 5 @ 7:15 PM
    Lions
    31 - 34
    Sunday, Dec 15 @ 7:20 PM
    Seahawks
    30 - 13
    Monday, Dec 23 @ 7:15 PM
    SAINTS
    34 - 0
    Sunday, Dec 29 @ 3:25 PM
    Vikings
    25 - 27
    Sunday, Jan 5 @ 12:00 PM
    BEARS
    22 - 24
    Sunday, Jan 12 @ 3:30 PM
    Eagles
    10 - 22
    Recent Topics
    3h / Green Bay Packers Talk / Zero2Cool

    15-Apr / Green Bay Packers Talk / dfosterf

    13-Apr / Green Bay Packers Talk / Martha Careful

    12-Apr / Feedback, Suggestions and Issues / Zero2Cool

    11-Apr / Feedback, Suggestions and Issues / Rockmolder

    2-Apr / Green Bay Packers Talk / Zero2Cool

    2-Apr / Green Bay Packers Talk / bboystyle

    1-Apr / Green Bay Packers Talk / Mucky Tundra

    1-Apr / Green Bay Packers Talk / wpr

    31-Mar / Green Bay Packers Talk / Zero2Cool

    30-Mar / Green Bay Packers Talk / Zero2Cool

    29-Mar / Random Babble / wpr

    28-Mar / Random Babble / Martha Careful

    26-Mar / Random Babble / Mucky Tundra

    25-Mar / Random Babble / Martha Careful

    Headlines
    Copyright © 2006 - 2025 PackersHome.com™. All Rights Reserved.