Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Transaction import aut...
Microsoft Dynamics SL (Archived)

Transaction import automation

(0) ShareShare
ReportReport
Posted on by Andrew73 1,471

Hi All,

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!

*This post is locked for comments

  • Erich Strelow F Profile Picture
    Erich Strelow F 16 on at
    RE: Transaction import automation

    I agree with Rob. Application Server (AS) has a specific interface for scheduling TI. You can query the AS queue to trace how your TI workload is doing.

    We built a setup around this so our HR staff could post payroll journal files to SL, since we use a no-SL payroll system.

    The approach is something like:

    1. Licensing of the AS module.
    2. Setup the AS user and working environment. We have a virtual Windows 7 machine somewhere that's running the AS.
    3. Setup a web page with a file drope zone so the user can drag & drop the file. For some reason, we named our AS as "Atomic Ant", and even got a clipart for it, so the web portal is presented as that. This page triggers the automation ASDevObj.ASRequest object that is badly documented in the AS manual.
    4. Setup a second web page with pending and ready TI requests, based on a query over SYS.AppSrvRequest.
    5. A third page shows the detail of a specific job. This one is beyond the scope, since does a lot of log file parsing so it can highlite the offending data.
    6. atomant.jpg

    As for stability, the main problem is to keep the AS instance running all the time. TI jobs has stronger requirements OS-wise, since it needs an open Window station. We use a third party monitoring system to aid on this.

  • Community Member Profile Picture
    Community Member on at
    RE: Transaction import automation

    I used to use Application Server to run these on a schedule and that worked without issue and it emailed the logs. From the command line you should be able to log the output to a file. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Check out the New Agent Creator Community

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

#1
Community Member Profile Picture

Community Member 136

#2
Mohamed Amine Mahmoudi Profile Picture

Mohamed Amine Mahmoudi 102 Super User 2025 Season 1

#3
REUser Profile Picture

REUser 8

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans