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.
-
@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.
-
@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:
@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.
Seems like Excel would just do this. It totally depends on how they would provide the data. But there are industry standards around this stuff.
-
@scottalanmiller said in Consulting for a Small Construction Company:
that the data is only for partners, that I'm not worried about. That makes sense. It's just how they provide it.
I follow your logic now. One of the worst systems I have dealt with is from Linde. They are finally moving to a web based extranet though. I hated updating their software and dealing with the machine licenses. it was a major time sink.
-
I think I mispoke - or mislead. The 3rd party stuff that's used from within the first party's software is hand entered into an import csv and imported into the first party's software.
There are other entities that are dealt with directly through their own web portals.
