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
dfosterf (8h) : Maybe
Mucky Tundra (9h) : Yes
Zero2Cool (10h) : No.
Mucky Tundra (12h) : End of a Degu-era
dhazer (12h) : Steelers sign Patterson because of new kickoff rule interesting
Zero2Cool (15h) : Former #Packers TE Josiah Deguara is signing a 1-year deal with the Jaguars, per source.
Zero2Cool (16h) : They do not do it for "content sake".
dfosterf (28-Mar) : For the record, I enjoy Beast and Mucky drafts
Zero2Cool (27-Mar) : Haha
Mucky Tundra (27-Mar) : No time for talking! Back to work beast!
beast (27-Mar) : You saw only 4,201 of my mocks? 🥺 I think that means you missed more than half of them 😢
dfosterf (27-Mar) : Does anyone know what Lambeau field improvements got put on hold? My guess would be for the 2025 draft
Zero2Cool (27-Mar) : It's like listen, you made 4,201 mocks, no shit.
Zero2Cool (27-Mar) : Cuz during the draft "I had them mocked there!" as if it's amazing.
Zero2Cool (27-Mar) : They're fun to do once in awhile. It's people who think they are "content" that annoy me.
dfosterf (27-Mar) : Against tbd
dfosterf (27-Mar) : Answer to your question is yes, it's a Thursday, will be the Chiefs aga
dfosterf (27-Mar) : Luckily for all concerned, I don't post them. I did one, but that was like 25 mocks ago
Zero2Cool (27-Mar) : NFL 2024 gonna start Sept 5th isn't it???
Zero2Cool (27-Mar) : Ugh... kids these days!
dfosterf (27-Mar) : I'm gonna go do some more mock draft hell instead 🤪
Zero2Cool (27-Mar) : Did we do one of those prediction threads yet for 2024 season?
dfosterf (27-Mar) : In my city, they are playing the nimby game, in order to keep some railroad tracks vs. 2 professional sports teams and a concert venue.
dfosterf (27-Mar) : And/Or a city council, of which I haven't seen a good one in a very long time
dfosterf (27-Mar) : That sounds like a Mayor, not a city.
buckeyepackfan (26-Mar) : Packers halt scheduled 80mil upgrade of stadium until lease agreement talks are restarted
Zero2Cool (26-Mar) : City of Green Bay puts Packers' Lambeau Field lease talks on hold
buckeyepackfan (26-Mar) : Packers 1 of 3 teams to vote no on new kickoff rule.
Zero2Cool (26-Mar) : Packers sign another Kicker
dfosterf (26-Mar) : Lengthy explanation at PFF if you click the link
dfosterf (26-Mar) : Kickoff rules officially changed.ngthy explan
Zero2Cool (26-Mar) : lol
Cheesey (26-Mar) : 2009? No thanks! One open heart surgery is enough!
dfosterf (26-Mar) : Good for you!
Zero2Cool (26-Mar) : Yes. That's the one.
dfosterf (26-Mar) : Is that "Lady Dugan" per chance?
dfosterf (26-Mar) : Crystal?
dfosterf (26-Mar) : Please refresh my memory
Zero2Cool (26-Mar) : Alan posts. Crystal back in my life. It's 2009 all over again! Lol
Mucky Tundra (26-Mar) : BAH GAWD! THAT'S CHEESEYS MUSIC!
Zero2Cool (25-Mar) : Gutekunst said early stages of Jordan Love contract being discussed.
Zero2Cool (25-Mar) : Shouldn't be penalized cuz official screwed up
Zero2Cool (25-Mar) : Yeah, challenge until you are incorrect twice.
Zero2Cool (25-Mar) : Fining them is the goal, per the people who made the rule anyway.
dfosterf (25-Mar) : Still waiting on the kickoff rule changes. Did hear yesterday that the touchback proposal will now be the 30 yard line, not the 35
dfosterf (25-Mar) : Probably speed of game issues with your proposal
dfosterf (25-Mar) : Hopefully the refs don't get in the habit of throwing flags on this
beast (25-Mar) : I think when it comes to Challenges should get two strikes, so unlimited challenges as long as they keep winning them, but 2 wrong then done
dfosterf (25-Mar) : Still subject to the fines etc
dfosterf (25-Mar) : Yes, I should have been more specific. Also, they are now saying it would be a 15 yard penalty. That makes more sense .
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
3h / Around The NFL / beast

8h / Green Bay Packers Talk / buckeyepackfan

28-Mar / Green Bay Packers Talk / dfosterf

28-Mar / Green Bay Packers Talk / bboystyle

27-Mar / Green Bay Packers Talk / Mucky Tundra

27-Mar / Random Babble / Zero2Cool

27-Mar / Green Bay Packers Talk / beast

26-Mar / Green Bay Packers Talk / beast

26-Mar / Green Bay Packers Talk / beast

26-Mar / Green Bay Packers Talk / bboystyle

25-Mar / Green Bay Packers Talk / Zero2Cool

25-Mar / Green Bay Packers Talk / Zero2Cool

24-Mar / Green Bay Packers Talk / beast

24-Mar / Green Bay Packers Talk / beast

22-Mar / Green Bay Packers Talk / beast

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