Porforis
11 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
11 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
11 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
11 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
11 years ago
[wtf] 🤔 i'm sure you're speaking some form of the English language but...i'm just not sure!!! 😕 🤷
Pack93z
11 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
11 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.
Fan Shout
Martha Careful (2h) : Congratulations
Zero2Cool (9h) : Boom. Student Loan. $0.00. Only took about 20 years.
Zero2Cool (14-Apr) : Packers DT Kenny Clark: New defensive coordinator Jeff Hafley will 'allow us to be way more disruptive'
Zero2Cool (12-Apr) : Saints have agreed to terms on a contract with former Packers wide receiver Equanimeous St. Brown.
beast (12-Apr) : No, but of it's for legislation, then half of the country will find it evil, not good, whatever it says....
Mucky Tundra (12-Apr) : Draft is still 2 weeks away. UGH
dhazer (11-Apr) : Does anyone know of a good AI generator to create letters of Support for legislation?
Zero2Cool (11-Apr) : Gordon "Red" Batty retires as equipment manager
Zero2Cool (10-Apr) : Sounds like that's pretty certain now.
Zero2Cool (10-Apr) : Packers "at" Eagles in Brazil. Week One
dfosterf (10-Apr) : Va' Fazer As Malas Va' !
Zero2Cool (9-Apr) : Mark Murphy tipping us off?
Zero2Cool (9-Apr) : “We’re either the first- or second-most popular team in Brazil.”
Zero2Cool (9-Apr) : Christian Watson got married. Wife better be careful with those hamstrings!! 😂😂
dfosterf (9-Apr) : Those poor bastards
Zero2Cool (8-Apr) : Falcons have signed former Packers CB Kevin King, who has been out of football since 2021.
dfosterf (8-Apr) : Collectively, we need to spend more time in what we have, when analyzing ostendible needs and historical proclivities
dfosterf (8-Apr) : I say he is better than so many of these draft picks
dfosterf (8-Apr) : Question of the week for me: Has anyone besides me done any deep dive into the potential of Alex McGough, our 3rd string qb?
Zero2Cool (8-Apr) : Or in Tunsil's case, something gets released day of draft or day before lol
Zero2Cool (8-Apr) : Seems every year someone does something pre-draft.
dfosterf (8-Apr) : Falling down drunk. The draft board
dfosterf (8-Apr) : Allright! Potential character guy/f#×k up pickup in D'Vondre Sweat!
Zero2Cool (7-Apr) : Go Badgers!!!
Martha Careful (6-Apr) : Go Boilermakers!!!
Martha Careful (5-Apr) : Diggs has not stepped up in the playoffs and has a high cost
beast (5-Apr) : Probably not going to let Diggs walk away unless he's horrible... but according to reports he also might not be as good as he used to be.
beast (5-Apr) : The 25th pick in the draft has been an offensive player since 2017, 2 TE, 2 WR, 1 RB, 1 OC
Mucky Tundra (5-Apr) : Odd, why give up a 2025 2nd Rounder for him if you're just gonna let him walk?
Zero2Cool (4-Apr) : Texans to let Diggs be free agent in '25
buckeyepackfan (4-Apr) : 49r's aign RB Patrick Taylor.
Martha Careful (4-Apr) : Reversion to the mean would indicate we will keep it
Zero2Cool (4-Apr) : It's also been utilized in a trade in 14 of the past 20 years
Zero2Cool (4-Apr) : The 25th pick in the draft hasn't been made by it's original holder since 2016.
Mucky Tundra (4-Apr) : Gotta imagine that Green Bay vs Houston will be a primetime game this upcoming season
Zero2Cool (3-Apr) : No. Kill QB. No worries. 😁
Mucky Tundra (3-Apr) : Diggs, Collins, Dell and Schultz is gonna be tough to cover
Zero2Cool (3-Apr) : Stefon Diggs' trade will not be processed as a post-June 1 designation, so that is just over $31 million in dead cap this year.
Zero2Cool (3-Apr) : Bills trading WR Stefon Diggs to the Texans in exchange for a 2025 2nd-round pick. (via @rapsheet)
beast (3-Apr) : Using Patterson as RB and RB/WR tweener... so I think they also signed Patterson as a 3rd down RB, not just a kick returner as articles are
beast (3-Apr) : I think PFT missed the real Steelers/Patterson connection, Steelers new OC Arthur Smith has been Patterson's head coach the last 3 years
wpr (2-Apr) : It has Martha. I was stunned when I was in HS to learn Iowa was still playing half court BB in the 70's.
Martha Careful (2-Apr) : Caitlin Clark, Angel Reese...women's sports has come a long way. GREAT TO SEE!!
Martha Careful (31-Mar) : Happy Easter everyone. I hope you all have a great day.
dfosterf (28-Mar) : Maybe
Mucky Tundra (28-Mar) : Yes
Zero2Cool (28-Mar) : No.
Mucky Tundra (28-Mar) : End of a Degu-era
dhazer (28-Mar) : Steelers sign Patterson because of new kickoff rule interesting
Zero2Cool (28-Mar) : Former #Packers TE Josiah Deguara is signing a 1-year deal with the Jaguars, per source.
Please sign in to use Fan Shout
2023 Packers Schedule
Sunday, Sep 10 @ 3:25 PM
Bears
Sunday, Sep 17 @ 12:00 PM
Falcons
Sunday, Sep 24 @ 12:00 PM
SAINTS
Thursday, Sep 28 @ 7:15 PM
LIONS
Monday, Oct 9 @ 7:15 PM
Raiders
Sunday, Oct 22 @ 3:25 PM
Broncos
Sunday, Oct 29 @ 12:00 PM
VIKINGS
Sunday, Nov 5 @ 12:00 PM
RAMS
Sunday, Nov 12 @ 12:00 PM
Steelers
Sunday, Nov 19 @ 12:00 PM
CHARGERS
Thursday, Nov 23 @ 11:30 AM
Lions
Sunday, Dec 3 @ 7:20 PM
CHIEFS
Monday, Dec 11 @ 7:15 PM
Giants
Sunday, Dec 17 @ 12:00 PM
BUCCANEERS
Sunday, Dec 24 @ 12:00 PM
Panthers
Sunday, Dec 31 @ 7:20 PM
Vikings
Sunday, Jan 7 @ 3:25 PM
BEARS
Sunday, Jan 14 @ 3:30 PM
Cowboys
Saturday, Jan 20 @ 7:15 PM
49ers
Recent Topics
2h / Green Bay Packers Talk / Martha Careful

15h / Green Bay Packers Talk / Mucky Tundra

22h / Random Babble / Martha Careful

15-Apr / Green Bay Packers Talk / dfosterf

15-Apr / Green Bay Packers Talk / dfosterf

12-Apr / Random Babble / Nonstopdrivel

12-Apr / Green Bay Packers Talk / Martha Careful

11-Apr / Green Bay Packers Talk / Zero2Cool

10-Apr / Green Bay Packers Talk / dfosterf

8-Apr / Green Bay Packers Talk / Zero2Cool

5-Apr / Green Bay Packers Talk / Martha Careful

5-Apr / Green Bay Packers Talk / bboystyle

4-Apr / Green Bay Packers Talk / Zero2Cool

4-Apr / Green Bay Packers Talk / buckeyepackfan

4-Apr / Green Bay Packers Talk / Mucky Tundra

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