Is this even do able?
We are on Office 365 and this is our entire LAN. Everyone works from home.
We have a QuickBooks file for our accounting that is stored in an SP lib. Each person syncs this library to a local folder of theirs. So they can open it locally and make changes to it and it syncs back to SP and everyone can see the latest version. However, we have to enforce checkouts, and in the case of QB, 3 effected files must be checked in and checked out,
So the user can't launch the QB files from SP because that will cause a download since it is a non MS doc and if they save the file after changes, it will save to the temp directory, not automatically to the correct local folder synced to SP.
So they have to first go to the SP lib, checkout all three files, then open the main QB file from their local synced folder. Then edit, save, and then go back into SP and check these files in. This is too messy and too much to ask the user to do every time.
I'm looking for a way to have them press a button or provide some mechanism, whether that be within SP or an app outside of SP, that checks out those three files from the lib, then launches the one main file from the local synced folder, Then when the file is saved back to the local synch folder, it checks the file in.
This sounds to me like it would require some sort of executable that can talk to both SharePoint and windows, as it would have to do both during this process. Can anything like this be done or are there certain rules in SP that woulds not allow something like this (an outside app launching SP and checking things in and out)? I can't see how one can create any app that runs within SP to launch a file from someone's local folder.
We cannot use QB online, which would actually be the easiest solution for us, so we are left trying to create unorthodox workarounds.