Network setup - moving forward
-
@Dashrender said in Network setup - moving forward:
@coliver said in Network setup - moving forward:
@Obsolesce said in Network setup - moving forward:
@coliver said in Network setup - moving forward:
@Dashrender said in Network setup - moving forward:
Many people around here use NC - I could attempt to replace windows file shares with NC - but as I already mentioned, it's mostly used through a single huge shared volume - I have no idea how NC handles something like that. I can't imagine syncing 20+ GB to every computer... plus there would likely be no file locks, so people would be stepping on each other for edits, etc.
They are working on a NC "drive" that only caches currently worked on documents. I'm hoping they release it in the near future.
Maybe like Google Drive File Sync. That could be an option depending on what all is in S:
Yeah, pretty much. Honestly 20GB isn't that much. Sharepoint and Onedrive could easily cover that.
Yeah - they can - but damn, downloading and uploading the files over the interwebs - they take forever. We're on a 100/20 pipe here, even small files still have a noticeable download delay compared to using a local FS.
That's why moving away from local edits is something I'm really keen on. If we could move to cloud edits only, or at least primarily, that could go a long way.
Zoho Docs?
-
@scottalanmiller said in Network setup - moving forward:
@Pete-S said in Network setup - moving forward:
@Dashrender said in Network setup - moving forward:
Example, one thing we have tons of is Excel sheets people fill out daily - If we had a web form to fill out instead, we could likely get rid of Excel. of course on the back end (for management who wants reports) we'd need the ability to create reports from that data. that could be done with Excel, or the report could be created in the web package. But these are things I've never done before, have no clue how to do, or really where to start. I'm guessing with some sort of PHP script and a DB on the back end is the starting point.
Easiest way (and cheapest) to make that happen is to find a developer who can do it for you.
A web interface allows the user to feed the back-end SQL database. With the data structured you have many options to use that data in meaningful ways - through a webserver or in many other ways.
PS. In my experience most companies need more than just generic forms and more than just generic reports. Usually it's about automating or support a process in the business.
Agreed. A developer is rarely expensive compared to the cost of bad workflows. The stuff that is being done is likely not hard, just unique. A decent developer might be able to make something that really improves the business, improves efficiency, and lowers the deployment costs. There is likely a bit of money to be spent, it's not going to be saved from not buying Excel, but in theory it will make your people work faster and better.
A "simple" PHP based system, with a standard RDBMS will allow you to be fast, flexible, and platform agnostic (and if you want, LANless for this component.)
Yeah, I love all those things you said - except - won't save over the cost of office.. that's what makes it hard sell. If I have to spend $5K to do this, positive my boss would say no... now - maybe the board would say something different.
-
@scottalanmiller said in Network setup - moving forward:
@Obsolesce said in Network setup - moving forward:
@Dashrender said in Network setup - moving forward:
Example, one thing we have tons of is Excel sheets people fill out daily - If we had a web form to fill out instead, we could likely get rid of Excel. of course on the back end (for management who wants reports) we'd need the ability to create reports from that data. that could be done with Excel, or the report could be created in the web package. But these are things I've never done before, have no clue how to do, or really where to start. I'm guessing with some sort of PHP script and a DB on the back end is the starting point.
The quickest and easiest way if you don't know where to start could be a PoC using WP and a forms plug in. There's some great ones. I don't know the amount of data or any details, but that could work in place of Excel. Same with generating reports of the data entered. Maybe Drupal as well.
If you can take away the dependencies first, that can open up the door for a lot of better ways than current setup.
For a PoC, that's likely fast. If you have access to a developer that knows what they are doing, that kind of PoC can be less than a week project.
Honestly, for a lot of firms, everything that they need is sometimes nothing more than a week long project!
Oh I agree, this likely would be a week long project, but a week is still $4K+ assuming $100/hr - but maybe I'm really high on my expectation of cost - what would a dev expect to get paid hourly for something like this, assuming "a week" type project?
-
@scottalanmiller said in Network setup - moving forward:
@Dashrender said in Network setup - moving forward:
@coliver said in Network setup - moving forward:
@Obsolesce said in Network setup - moving forward:
@coliver said in Network setup - moving forward:
@Dashrender said in Network setup - moving forward:
Many people around here use NC - I could attempt to replace windows file shares with NC - but as I already mentioned, it's mostly used through a single huge shared volume - I have no idea how NC handles something like that. I can't imagine syncing 20+ GB to every computer... plus there would likely be no file locks, so people would be stepping on each other for edits, etc.
They are working on a NC "drive" that only caches currently worked on documents. I'm hoping they release it in the near future.
Maybe like Google Drive File Sync. That could be an option depending on what all is in S:
Yeah, pretty much. Honestly 20GB isn't that much. Sharepoint and Onedrive could easily cover that.
Yeah - they can - but damn, downloading and uploading the files over the interwebs - they take forever. We're on a 100/20 pipe here, even small files still have a noticeable download delay compared to using a local FS.
That's why moving away from local edits is something I'm really keen on. If we could move to cloud edits only, or at least primarily, that could go a long way.
Zoho Docs?
Or O365.
our chances of leaving the Exchange Eco-system is near zero.
-
@scottalanmiller said in Network setup - moving forward:
There is likely a bit of money to be spent, it's not going to be saved from not buying Excel, but in theory it will make your people work faster and better.
Dumping the office suite entirely for LibreOffice (especially when considering the subscription cost of O365) would save a lot of money in the long haul.
But there is very likely a conversion that would have to be done on each custom Excel file if they have any special formulas etc.
-
@Dashrender said in Network setup - moving forward:
Yeah, I love all those things you said - except - won't save over the cost of office.. that's what makes it hard sell.
My point was... it'll easily save over the cost of it (in most cases.)
-
@Dashrender said in Network setup - moving forward:
If I have to spend $5K to do this, positive my boss would say no... now - maybe the board would say something different.
Don't say what it costs, point out how much it makes/saves. TCO, not Cost of Acquisition.
-
@Dashrender said in Network setup - moving forward:
@scottalanmiller said in Network setup - moving forward:
@Obsolesce said in Network setup - moving forward:
@Dashrender said in Network setup - moving forward:
Example, one thing we have tons of is Excel sheets people fill out daily - If we had a web form to fill out instead, we could likely get rid of Excel. of course on the back end (for management who wants reports) we'd need the ability to create reports from that data. that could be done with Excel, or the report could be created in the web package. But these are things I've never done before, have no clue how to do, or really where to start. I'm guessing with some sort of PHP script and a DB on the back end is the starting point.
The quickest and easiest way if you don't know where to start could be a PoC using WP and a forms plug in. There's some great ones. I don't know the amount of data or any details, but that could work in place of Excel. Same with generating reports of the data entered. Maybe Drupal as well.
If you can take away the dependencies first, that can open up the door for a lot of better ways than current setup.
For a PoC, that's likely fast. If you have access to a developer that knows what they are doing, that kind of PoC can be less than a week project.
Honestly, for a lot of firms, everything that they need is sometimes nothing more than a week long project!
Oh I agree, this likely would be a week long project, but a week is still $4K+ assuming $100/hr - but maybe I'm really high on my expectation of cost - what would a dev expect to get paid hourly for something like this, assuming "a week" type project?
You'd pay by the week. If you find a good dev, give flex time for the project, have your ducks in a row, you could get away with $3K probably for a week.
-
@Dashrender said in Network setup - moving forward:
@scottalanmiller said in Network setup - moving forward:
@Dashrender said in Network setup - moving forward:
@coliver said in Network setup - moving forward:
@Obsolesce said in Network setup - moving forward:
@coliver said in Network setup - moving forward:
@Dashrender said in Network setup - moving forward:
Many people around here use NC - I could attempt to replace windows file shares with NC - but as I already mentioned, it's mostly used through a single huge shared volume - I have no idea how NC handles something like that. I can't imagine syncing 20+ GB to every computer... plus there would likely be no file locks, so people would be stepping on each other for edits, etc.
They are working on a NC "drive" that only caches currently worked on documents. I'm hoping they release it in the near future.
Maybe like Google Drive File Sync. That could be an option depending on what all is in S:
Yeah, pretty much. Honestly 20GB isn't that much. Sharepoint and Onedrive could easily cover that.
Yeah - they can - but damn, downloading and uploading the files over the interwebs - they take forever. We're on a 100/20 pipe here, even small files still have a noticeable download delay compared to using a local FS.
That's why moving away from local edits is something I'm really keen on. If we could move to cloud edits only, or at least primarily, that could go a long way.
Zoho Docs?
Or O365.
our chances of leaving the Exchange Eco-system is near zero.
One moment cost matters, the next it's irrelevant
-
@scottalanmiller said in Network setup - moving forward:
@Dashrender said in Network setup - moving forward:
@scottalanmiller said in Network setup - moving forward:
@Dashrender said in Network setup - moving forward:
@coliver said in Network setup - moving forward:
@Obsolesce said in Network setup - moving forward:
@coliver said in Network setup - moving forward:
@Dashrender said in Network setup - moving forward:
Many people around here use NC - I could attempt to replace windows file shares with NC - but as I already mentioned, it's mostly used through a single huge shared volume - I have no idea how NC handles something like that. I can't imagine syncing 20+ GB to every computer... plus there would likely be no file locks, so people would be stepping on each other for edits, etc.
They are working on a NC "drive" that only caches currently worked on documents. I'm hoping they release it in the near future.
Maybe like Google Drive File Sync. That could be an option depending on what all is in S:
Yeah, pretty much. Honestly 20GB isn't that much. Sharepoint and Onedrive could easily cover that.
Yeah - they can - but damn, downloading and uploading the files over the interwebs - they take forever. We're on a 100/20 pipe here, even small files still have a noticeable download delay compared to using a local FS.
That's why moving away from local edits is something I'm really keen on. If we could move to cloud edits only, or at least primarily, that could go a long way.
Zoho Docs?
Or O365.
our chances of leaving the Exchange Eco-system is near zero.
One moment cost matters, the next it's irrelevant
lol - yeah - it boils down to unwillingness to change - they don't want to learn a new client.
-
@Dashrender said in Network setup - moving forward:
@scottalanmiller said in Network setup - moving forward:
@Dashrender said in Network setup - moving forward:
@scottalanmiller said in Network setup - moving forward:
@Dashrender said in Network setup - moving forward:
@coliver said in Network setup - moving forward:
@Obsolesce said in Network setup - moving forward:
@coliver said in Network setup - moving forward:
@Dashrender said in Network setup - moving forward:
Many people around here use NC - I could attempt to replace windows file shares with NC - but as I already mentioned, it's mostly used through a single huge shared volume - I have no idea how NC handles something like that. I can't imagine syncing 20+ GB to every computer... plus there would likely be no file locks, so people would be stepping on each other for edits, etc.
They are working on a NC "drive" that only caches currently worked on documents. I'm hoping they release it in the near future.
Maybe like Google Drive File Sync. That could be an option depending on what all is in S:
Yeah, pretty much. Honestly 20GB isn't that much. Sharepoint and Onedrive could easily cover that.
Yeah - they can - but damn, downloading and uploading the files over the interwebs - they take forever. We're on a 100/20 pipe here, even small files still have a noticeable download delay compared to using a local FS.
That's why moving away from local edits is something I'm really keen on. If we could move to cloud edits only, or at least primarily, that could go a long way.
Zoho Docs?
Or O365.
our chances of leaving the Exchange Eco-system is near zero.
One moment cost matters, the next it's irrelevant
lol - yeah - it boils down to unwillingness to change - they don't want to learn a new client.
You can use Outlook with Zoho.
-
@coliver said in Network setup - moving forward:
@Dashrender said in Network setup - moving forward:
@scottalanmiller said in Network setup - moving forward:
@Dashrender said in Network setup - moving forward:
@scottalanmiller said in Network setup - moving forward:
@Dashrender said in Network setup - moving forward:
@coliver said in Network setup - moving forward:
@Obsolesce said in Network setup - moving forward:
@coliver said in Network setup - moving forward:
@Dashrender said in Network setup - moving forward:
Many people around here use NC - I could attempt to replace windows file shares with NC - but as I already mentioned, it's mostly used through a single huge shared volume - I have no idea how NC handles something like that. I can't imagine syncing 20+ GB to every computer... plus there would likely be no file locks, so people would be stepping on each other for edits, etc.
They are working on a NC "drive" that only caches currently worked on documents. I'm hoping they release it in the near future.
Maybe like Google Drive File Sync. That could be an option depending on what all is in S:
Yeah, pretty much. Honestly 20GB isn't that much. Sharepoint and Onedrive could easily cover that.
Yeah - they can - but damn, downloading and uploading the files over the interwebs - they take forever. We're on a 100/20 pipe here, even small files still have a noticeable download delay compared to using a local FS.
That's why moving away from local edits is something I'm really keen on. If we could move to cloud edits only, or at least primarily, that could go a long way.
Zoho Docs?
Or O365.
our chances of leaving the Exchange Eco-system is near zero.
One moment cost matters, the next it's irrelevant
lol - yeah - it boils down to unwillingness to change - they don't want to learn a new client.
You can use Outlook with Zoho.
But Zoho online would be nothing like Excel.. Granted Excel online is likely different from Excel local as well.
There are options.
-
@Dashrender said in Network setup - moving forward:
Granted Excel online is likely different from Excel local as well
Not as much as you think.
-
@coliver said in Network setup - moving forward:
@Dashrender said in Network setup - moving forward:
Granted Excel online is likely different from Excel local as well
Not as much as you think.
One way that the online version is substantially more different is you can't open password protected excel files in the web version.
So if you had a lot of those (stupid I know) you'd be up the creek without a paddle.
-
@DustinB3403 said in Network setup - moving forward:
One way that the online version is substantially more different is you can't open password protected excel files in the web version.
NC has that problem, too.
-
@DustinB3403 said in Network setup - moving forward:
@coliver said in Network setup - moving forward:
@Dashrender said in Network setup - moving forward:
Granted Excel online is likely different from Excel local as well
Not as much as you think.
One way that the online version is substantially more different is you can't open password protected excel files in the web version.
So if you had a lot of those (stupid I know) you'd be up the creek without a paddle.
not a Lot that I know of.. but definitely a few.
-
Off top I can think of a few options to help remove the dependence of Excel. This is a short list.
Microsoft Power Apps
Google App maker
Quickbase
Zoho Creator
