10-07-2008 08:47 AM - edited 10-07-2008 08:48 AM
Yes, it can EASILY be done, you need your JAVA development to just QUEUE requests and process the files sequentially.
I would be delighted to continue this off-line if you like.
CRM Solutions, Inc.
631 265-6356 or Support@V8Software.com
10-07-2008 08:59 AM
Thanks for the offer Kevin. Unfortunately queuing requests is not acceptable for a (multi-user) web-based system so I guess we'll stick with OLE-DB.
10-07-2008 09:16 AM
Crumbs Dave - of course you are 100% correct - insofar as you are only intending to READ data from ACT, ACTOLEDB will be the best answer with PHP. No question about it.
FWIW - it may be a devil of a lot faster though, to squirt the data from ACT into MySQL on a regular timed basis (as ACTOLEDB is jolly slow and has a tendancy to time-out on occasion) and create a nice direct link using ODBC in your PHP instead.
Then you could (as needs and wants change in the future) permit comments or additional data to be added to your MySQL tables for subsequent updating into ACT and/or your other system(s).
10-07-2008 09:22 AM
FWIW - it may be a devil of a lot faster though, to squirt the data from ACT into MySQL on a regular timed basis
Mmm... good idea! Thanks Kevin
10-08-2008 09:50 AM
OK Folks - I have some feedback.
I am now given to understand that MiddleWare SDK for ACT by Sage does NOT require Premium -and it has been run successfully under ACT STANDARD. (2008 Version 10).
I now stand rather sheepishly looking at my computer monitor and really don't want to say "gee - I dunno"
Hmmm - you know what - if somebody has a standard version and could try that out - it sure would be neat to know.
I guess it should work.
Every single PC that can actually run ACT in our network and on ALL of the laptops - we have Premium installed.
And although we could uninstall premium and install the cheaper version - I always feel that the PC is no longer a "Virgin" and some enabling stuff may have been left behind.
Do you happen to have the standard (non Premium) version on any PC Yan?
If so - feedback would be greatly appreciated.
12-30-2013 09:10 AM
The LATEST version of Middleware now works with Act! 2010 and above.
It is fully documented and tested to Act! Version 2014.
It is still Royalty-Free, and can be downloaded from http://MiddlewareSDK.com
No registration is required.
01-31-2014 05:13 AM
I just put the .net v4 version middleware.dll into the Plugins dir of 2 computers and restarted Act! 16.
Then I created the %temp%\v8software\ directory and issued a simple command like CPAD into JobControl.txt
On neither of the 2 systems this command seems to be followed up. Nothing's seems to be happening. How so?
On 1 system I tried to delete middleware.dll while Act! was active, but access was denied.
02-25-2014 08:50 AM
You should not need to create the V8Software folder. If you do, then it is not one that Middleware is using :-)
When Act! Starts... it runs Middleware.dll
If you cannot delete that DLL - then clearly it is running.
Which means that it has created the V8Software folder somewhere.
By default, it will be in the CURRENT WINDOWS USERS temp folder.
If you cannot see it, then might I suggest that you do a Windows Search for V8Software.
BTW... you *MAY* have to turn off the User Control or Run Act! as Administrator to enable it.
Please feel free to email me at Support@V8Software.com Peter