Network setup - moving forward
-
@Obsolesce said in Network setup - moving forward:
What's the energy behind the need for change?
It's not so much about change - rather it's about doing an evaluation of the current setup and what might be a better way to go forward.
Yes, all of my infrastructure is old, and needs to be replaced.
Our use of the S: drive could likely be severely reduced if we had forms, documentation, etc in an web site instead.
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.
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.
I could look at WebDAV mappings - which would mean wanting some kind of LDAP centralized authentication source to simply that for users.
I'd also what some mechanism that will auto map printers/shares, etc when users log into new computers. -
@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.
-
@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.
-
@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.
-
@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:
-
@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.
-
@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.)
-
@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.
That's a game changer for them.
-
@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!
-
@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.
OneDrive had this ages ago - though from the description, OneDrive had both clients in one - it kept marked for offline use files synced and always offline - AND - it would show the entire filesystem that was on the server.
I don't see why these functions are split over two applications?FYI - OneDrive did dump this functionality for a while because the manner in which it was originally implemented required an amount of local storage when the server side file count was large to sometimes be larger than the available space on space limited devices (like the original win10 tabs that were sold with 16 GB of storage). But MS brought the functionality back a year or two ago.
-
@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!
Ya a Dev is likely the best option, I agree.
-
@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.
-
@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.
