Open Forum

    There’s still time to join 500+ peers & experts in Tampa this Sept. for unparalleled SL education & networking!  Register Now!

1.  TI, Automation,Integration

Posted 15 days ago
My question is not new, but I'm l struggling to find a right solution. What we need it's to run TI automatically, according to SystemManager.pdf it could be done by running it from a command line, however if there are any validation errors - log file would be generated in a "silent" mode, nobody will got a notification.

I'm wondering if somebody has a working solution in place and what was the approach, how difficult it was? How stable it is? What are the issues with it?

Thanks!

------------------------------
Andrey Nikolaev
DBA
RJC Engineers
Vancouver
------------------------------


2.  RE: TI, Automation,Integration

Posted 15 days ago
​We have VB Tools screens using Object Model  that automatically import or update and process.  Some screens we us the TI process.  Mostly we use the full Object Model functionality and read from a data source (SQL Table/view, text file or Excel file).  Populate the screens save and finish.  When you build an object model application you can code it to so it will launch DSL.  Select the company you login to and user to use.  This would then allow it to be called from a command line.

We use DSL's Application servers to run most of our automated Object Model apps so it runs on a schedule and is in queue if the machine goes down or is slow.  You can catch all kinds of errors and save them to an event log.  Error messages do not pop on the screen so you have to capture and write to an event log to get it.  I quite often use a queue table to track as I process to capture the file start time and end time.  If I have a start time and no end then I review the log starting at the start time to find the error I did not handle.

Hope this helps.

------------------------------
Dwight Neate
DBA Senior Programmer
Betco Corporation
Toledo OH
------------------------------



3.  RE: TI, Automation,Integration

Posted 15 days ago

Catalina Technologies have web apps for many of the SL screens that will automatically process data files and load them into SL.

Their programs also have error checking and options to repair, requeue etc.

You install and set them up once, and then they do all the processing, providing error checking and a method to resolve issues in the data.

 

June Henderson, CPA

209 West California Street, Suite 4

Gainesville, Texas 76240

jhenderson@365solutionsgroup.com

469.744.3520

LogoColorTextRight SMALL

 






4.  RE: TI, Automation,Integration

Posted 15 days ago
June is correct.  we have many integration tools that will get you out of the limitations of TI with a more modern API approach.  Our API's are both SOAP and REST which allow you to easily map data from other systems to SL.

You can see more information here:  http://www.catalinatechnology.com/?CTAPI

------------------------------
Brian Wharton
Founder/President
Catalina Technology
Redondo Beach CA
------------------------------



5.  RE: TI, Automation,Integration

Posted 15 days ago
We have a client using a product called TI Server. It runs nicely unattended. When a file appears in a user defined folder this utility knows what SL screen to load the data into. Results sent via email. It is not expensive and works well. We have it installed at an insurance company that uses SL to pay claims behind their custom front end. I have it set so the process can run 3 imports for one data file. It first has to create the vendor, then possibly create Ebanking info and then loads the vouchers to be paid. Some by check and some electronically. The beauty of this is someone else has determined how to do this and you don't need to know vbtools or any of the development things. If you are interested I can give you more info.

Peter.

Sent from my iPhone




6.  RE: TI, Automation,Integration

Posted 15 days ago
I have also used TI server, but it took the ISV a long time to get a SL2011 version released and I am not sure there is a 2015 version. Last time I attempted to contact them I could not get a reply. 

Sent from my Windows Phone





7.  RE: TI, Automation,Integration

Posted 6 days ago
Edited by Andrey Nikolaev 6 days ago
Thanks to everyone whom answered my question!

------------------------------
Andrey Nikolaev
DBA
RJC Engineers
Vancouver
------------------------------



8.  RE: TI, Automation,Integration

Posted 4 days ago
I had a very bad experience with TI Server. I wanted to test it on the current version of SL (SL2015). The publisher was very slow to respond to any request and questions. The software did not appear to support SL2015. The documentation was out of date (referenced SL7.0). There were numerous issues trying to get the software and install it. They were very slow responding to any issues when I was trying to install a test copy of the software.

------------------------------
Bill Degnan
Admiral Consulting Group
East Brunswick NJ
------------------------------



'