Consulting for a Small Construction Company
-
@Dashrender said in Consulting for a Small Construction Company:
@scottalanmiller said in Consulting for a Small Construction Company:
@Dashrender said in Consulting for a Small Construction Company:
I've worked with a few small'ish industry businesses (alcohol distributors and HVAC distributors) They both used a product produced by a vendor inside those industries as their 20% uniqueness - both packages are just horrible from a design/support perspective, both required local admin and damn near impossible to make run as a non admin.
These software packages are so unique though, that I don't know if a third party software solution would really work for them, without going to extreme lengths to import the data from each vendor, then create the interdependence between components as the current solution provides.
It's frustrating to look at what some of these places have to deal with.
Just because the package is unique does not mean that it is useful, though. I've never heard anyone claim "competitive advantage" or "improved efficiency" or "improved profits" only ever "uniqueness" which is what people would say when they need a reason but don't have one for why they chose it. Uniqueness alone isn't an advantage.
In these cases, it's not about uniqueness, it's about functionality. Hand coding their own solution, assuming they could get the raw data to put into their own solution would cost many times what it costs to just buy the product from the vendor. Beyond that, I'm not sure what you are driving at.
What I'm saying is that lots of companies make this claim that their businesses are "so unique" in their industry that they can't use standard tools (MS Office, QuickBooks, Sharepoint, what have you) but instead need "apps made for their industry." In some cases, it is certainly true, medical offices for example. But for many businesses, it's simply a marketing tactic. Lots of these companies claim uniqueness even though it turns out their special software does nothing special.
-
Example... I've seen undertakers use custom software that costs an arm and a leg, is written like crap, doesn't work reliably and has all kinds of insane dependencies. Did it do something special to warrant using it? No. Excel would have been better.
-
@scottalanmiller said in Consulting for a Small Construction Company:
Example... I've seen undertakers use custom software that costs an arm and a leg, is written like crap, doesn't work reliably and has all kinds of insane dependencies. Did it do something special to warrant using it? No. Excel would have been better.
Sure, in there case Excel might have worked, even though they would have to manually import all of their inventory into then create the flows (logic) that allows what part to go with what casket, etc).
-
@Dashrender said in Consulting for a Small Construction Company:
@scottalanmiller said in Consulting for a Small Construction Company:
Example... I've seen undertakers use custom software that costs an arm and a leg, is written like crap, doesn't work reliably and has all kinds of insane dependencies. Did it do something special to warrant using it? No. Excel would have been better.
Sure, in there case Excel might have worked, even though they would have to manually import all of their inventory into then create the flows (logic) that allows what part to go with what casket, etc).
Right. But for the average business... this works. I'm not saying Excel specifically. But there are tons of standard tools developers for normal businesses. And they work for the majority of them. And the smaller you get, the more they make sense. And those industries that "need" special case software, there is almost always good software available. There are exceptions, but everyone thinks that their industry is the special case.
-
@scottalanmiller said in Consulting for a Small Construction Company:
@Dashrender said in Consulting for a Small Construction Company:
@scottalanmiller said in Consulting for a Small Construction Company:
Example... I've seen undertakers use custom software that costs an arm and a leg, is written like crap, doesn't work reliably and has all kinds of insane dependencies. Did it do something special to warrant using it? No. Excel would have been better.
Sure, in there case Excel might have worked, even though they would have to manually import all of their inventory into then create the flows (logic) that allows what part to go with what casket, etc).
Right. But for the average business... this works. I'm not saying Excel specifically. But there are tons of standard tools developers for normal businesses. And they work for the majority of them. And the smaller you get, the more they make sense. And those industries that "need" special case software, there is almost always good software available. There are exceptions, but everyone thinks that their industry is the special case.
I really wish that was the case for the HVAC group I'm working with now - sadly it's not.
-
What kind of special case software do they need?
-
Building HVAC systems. You pick the chassis, then you are shown only a list of items allowed for that chassis. Sure you can do this with Excel or some other Access like DB, sure don't want to use Access. But then you'd still have to have the software installed somewhere so you can get the raw data (you're lucky if you don't have to pull it out by hand) and import it into your system and then make sure the logic is correct.
-
@Dashrender said in Consulting for a Small Construction Company:
Building HVAC systems. You pick the chassis, then you are shown only a list of items allowed for that chassis. Sure you can do this with Excel or some other Access like DB, sure don't want to use Access. But then you'd still have to have the software installed somewhere so you can get the raw data (you're lucky if you don't have to pull it out by hand) and import it into your system and then make sure the logic is correct.
This kind of thing should be all web based and pulling from a vendor provided API or even XML export or something.
-
@Dashrender said in Consulting for a Small Construction Company:
Building HVAC systems. You pick the chassis, then you are shown only a list of items allowed for that chassis. Sure you can do this with Excel or some other Access like DB, sure don't want to use Access. But then you'd still have to have the software installed somewhere so you can get the raw data (you're lucky if you don't have to pull it out by hand) and import it into your system and then make sure the logic is correct.
Most ERP systems can do configuration and validation automatically without having a user look into it. Most web fronts, even FOSS ones, can do this too with minimal configuration.
-
@Dashrender said in Consulting for a Small Construction Company:
Building HVAC systems. You pick the chassis, then you are shown only a list of items allowed for that chassis. Sure you can do this with Excel or some other Access like DB, sure don't want to use Access. But then you'd still have to have the software installed somewhere so you can get the raw data (you're lucky if you don't have to pull it out by hand) and import it into your system and then make sure the logic is correct.
What's complex about that that you would need much of anything at all? This sounds like, unless I'm missing something big, exactly what common tools are built for. What's unique or special to HVAC here?
-
This is why I recommended a VPS. They can whatever proprietary software they want to run and run it in the cloud.
-
@scottalanmiller said in Consulting for a Small Construction Company:
@Dashrender said in Consulting for a Small Construction Company:
Building HVAC systems. You pick the chassis, then you are shown only a list of items allowed for that chassis. Sure you can do this with Excel or some other Access like DB, sure don't want to use Access. But then you'd still have to have the software installed somewhere so you can get the raw data (you're lucky if you don't have to pull it out by hand) and import it into your system and then make sure the logic is correct.
What's complex about that that you would need much of anything at all? This sounds like, unless I'm missing something big, exactly what common tools are built for. What's unique or special to HVAC here?
I guess it's simply getting access to the actual data. If the vendor will send over a csv, then it wouldn't be that hard...
-
@Dashrender said in Consulting for a Small Construction Company:
I guess it's simply getting access to the actual data. If the vendor will send over a csv, then it wouldn't be that hard...
Is this a matter of vendors denying access to data and only providing the info via their own configuration utility? So they need one from each vendor?
-
@scottalanmiller said in Consulting for a Small Construction Company:
@Dashrender said in Consulting for a Small Construction Company:
I guess it's simply getting access to the actual data. If the vendor will send over a csv, then it wouldn't be that hard...
Is this a matter of vendors denying access to data and only providing the info via their own configuration utility? So they need one from each vendor?
correct.
-
@Dashrender said in Consulting for a Small Construction Company:
@scottalanmiller said in Consulting for a Small Construction Company:
@Dashrender said in Consulting for a Small Construction Company:
I guess it's simply getting access to the actual data. If the vendor will send over a csv, then it wouldn't be that hard...
Is this a matter of vendors denying access to data and only providing the info via their own configuration utility? So they need one from each vendor?
correct.
Huge problem really. which brings this conversation around to the PBS everything open source thread.
-
@Dashrender said in Consulting for a Small Construction Company:
@scottalanmiller said in Consulting for a Small Construction Company:
@Dashrender said in Consulting for a Small Construction Company:
I guess it's simply getting access to the actual data. If the vendor will send over a csv, then it wouldn't be that hard...
Is this a matter of vendors denying access to data and only providing the info via their own configuration utility? So they need one from each vendor?
correct.
Maybe this is more work than it's worth. But can't they get that out of the current system they have and add it to an ERP system? Or does it change that much that it wouldn't be reliable?
-
@Dashrender said in Consulting for a Small Construction Company:
@scottalanmiller said in Consulting for a Small Construction Company:
@Dashrender said in Consulting for a Small Construction Company:
I guess it's simply getting access to the actual data. If the vendor will send over a csv, then it wouldn't be that hard...
Is this a matter of vendors denying access to data and only providing the info via their own configuration utility? So they need one from each vendor?
correct.
That should all go into the calculation as to why that vendor is overly expensive.
The vendor actually is denying access to their parts data? This seems really unlikely. You've spoken to the vendor and they actually won't provide the data?
-
@scottalanmiller said in Consulting for a Small Construction Company:
@Dashrender said in Consulting for a Small Construction Company:
@scottalanmiller said in Consulting for a Small Construction Company:
@Dashrender said in Consulting for a Small Construction Company:
I guess it's simply getting access to the actual data. If the vendor will send over a csv, then it wouldn't be that hard...
Is this a matter of vendors denying access to data and only providing the info via their own configuration utility? So they need one from each vendor?
correct.
That should all go into the calculation as to why that vendor is overly expensive.
The vendor actually is denying access to their parts data? This seems really unlikely. You've spoken to the vendor and they actually won't provide the data?
This is not uncommon at all. It is very common that manufacturers will strike deals with dealers and only provide information via that chain.
-
@scottalanmiller said in Consulting for a Small Construction Company:
@Dashrender said in Consulting for a Small Construction Company:
@scottalanmiller said in Consulting for a Small Construction Company:
@Dashrender said in Consulting for a Small Construction Company:
I guess it's simply getting access to the actual data. If the vendor will send over a csv, then it wouldn't be that hard...
Is this a matter of vendors denying access to data and only providing the info via their own configuration utility? So they need one from each vendor?
correct.
That should all go into the calculation as to why that vendor is overly expensive.
The vendor actually is denying access to their parts data? This seems really unlikely. You've spoken to the vendor and they actually won't provide the data?
No I haven't, I suppose it's worth a conversation - but I'm here to tell you they'll likely not move away from it if making a replacement ERP with with vendor provided data unless the transition was say less than $2K. The current software is there and works. for it's intended purpose.. works well. Even though it requires local admin rights - which is the only thing that really makes me want to get rid of it.
I also really dislike the fact that it's only single workstation aware. So someone making a quote on one system, is completely unaware of someone else making one someplace else.
-
@JaredBusch said in Consulting for a Small Construction Company:
@scottalanmiller said in Consulting for a Small Construction Company:
@Dashrender said in Consulting for a Small Construction Company:
@scottalanmiller said in Consulting for a Small Construction Company:
@Dashrender said in Consulting for a Small Construction Company:
I guess it's simply getting access to the actual data. If the vendor will send over a csv, then it wouldn't be that hard...
Is this a matter of vendors denying access to data and only providing the info via their own configuration utility? So they need one from each vendor?
correct.
That should all go into the calculation as to why that vendor is overly expensive.
The vendor actually is denying access to their parts data? This seems really unlikely. You've spoken to the vendor and they actually won't provide the data?
This is not uncommon at all. It is very common that manufacturers will strike deals with dealers and only provide information via that chain.
I'm not surprised by that part. I'm surprised that they would go through all of the risk and expense of building an in house application that they have to maintain (or they lose sales) and provide and support to their channel partners making their partners less effective and riskier and making them less cost effective to do business with when they could just give them the data or built the application into their web portal or whatever. It would benefit them AND their partners, not like they are benefiting here themselves, right?
that the data is only for partners, that I'm not worried about. That makes sense. It's just how they provide it.