Sage 100

Does anyone have any of the sample Workflow scripts from VinyardSoft (specific to Sage)? I am trying to have #KnowledgeSync go back and uncheck a box if criteria from a query are met, but I don't have any examples to work with. Finding all sorts of stuff on their website for other programs (SQL, Faxing, etc), but nothing for Sage. Anyone have something they care to share? @Sage100AdvancedScripting

You have to fill out the the request form. That takes you to the actual download page. Didn't know which you wanted so here are all that I could find which relate to Sage 100. I also pull down those related to some third party add on's, CRM integrations, and those related to self diagnosing / monitoring events. This last group is nice to ""watch the watcher"".

BTW, here is the web link: http://www.vineyardsoft.com/thankyou.php?mod=downloader

One last thing, Vineyardsoft sent a password to go along with the download. It is ""Island"". Here is the full content of the email. Thank you for downloading KnowledgeSync. The password to install the software is: island To download KnowledgeSync, use this link: http://03c0901.netsolvps.com/installs/KS_Setup.zip KnowledgeSync Manual: http://03c0901.netsolvps.com/lit/ks_manual.zip Computer based training: http://www.vineyardsoft.com/training-vids.php To search our KnowledgeBase, please click here: http://vineyardsoft.com/support_knowledgebase.php If you have any questions, please use our support webform by clicking here: http://vineyardsoft.com/support_email.php

Thanks @ShawnSlavin , I think I have most of those installed and I don't see much workflow specific to Sage100. Although the watchdog does give some insight... it looks like most are just queries and emails or reports. I have emailed KS Directly to see if I am overlooking anything in the eventpaks. If they give me anything additional I will be sure to post it here (or if I can figure this out). This thread will prove very useful as a one-stop-shop in the future!

I don't recall any eventpaks that perform any imports for Sage 100 (just queries/exports). We've used KSync to trigger scripts that perform the imports; for example, we have KSync run a script that checks for files present in a folder, and when it does, it passes the filename to another script which does the actual import and cleans up the folder.

ahhh that makes sense @SteveIwanowski. So rather than updating the files themselves you use KS to kick start a VI Job? Is that one you would be willing to share? I have a batch file I use to start a VI job using windows scheduler, I assume it is very similar?

Correct. If it's time-based (for example, runs daily at 9pm), I use Windows Task Scheduler ('feels' more reliable to me, but that's probably just superstition). If you need the job to react to something else happening, that's when I use KSync. I don't have any V/Is triggered by KSync (I prefer BOI to import), but you would configure a batch file under an Application Event, Actions tab, Run Program tab to run the V/I job.

Brilliant! Thanks Steve!

Michelle, you could follow @SteveIwanowski steps and use KSync to monitor the contents of a directory on a server or a folder in an Exchange Server. If KSync finds a qualifying object, the event fires to address.

Here's the VBS script that will check a folder (not its subfolders) for files, and then pass the filename (as an argument) to another script/batch/etc.

I will have this be part of a Job Stream (these are my new favorite if you haven't played with them yet). Here is the workflow: Create file using he Action tab to generate the csv file (Let's call it 'SO1.25.16') Email said file to the warehouse dist center for processing Re-import file using KS Action and VI I think that last step will have to be two actions since the file it spits out will always have a unique name, right? So One action to copy and rename it to a different file location, and another action to kick off the VI Job? To my knowledge there is no way to pass a path through a Batch file/VI, right? The below is the only script I have ever used to import VI from a command line: ..\MAS90\Home\Pvxwin32.exe .. \Launcher\Sota.Ini ..\SOA\Startup.M4P -ARG DIRECT UION myuser mypassword ABC VIWI00 AUTO

Wanted to update this. KS has a difficult time using Mapped Drives when executing a batch file. So we ended up using the following and it executes properly: net use s: \\<servernameremoved>\acct s: CD \v45\MAS90\Home Pvxwin32.exe ..\Launcher\Sota.Ini ..\SOA\Startup.M4P -ARG DIRECT UIOFF user password SPC VIWI2F AUTO