Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Scheduling Integration Manager

Scheduling Integration Manager

Scheduling Integration Manager

I need to write a package that will allow me to cycle through multiple integrations (journal entry uploads) automatically.  Does anyone know of any resources that will give me some direction?

RE: Scheduling Integration Manager

Write a script.  Integration manager can be called from a command line with a integration name parameter .

RE: Scheduling Integration Manager

Be careful - while you can use the Task Scheduler to call a batch file containing a command line call to launch IM there are some caveats. This is not a highly robust and durable solution, so you can't set it and forget it.

Second, GP has to be running and logged in to the target company before you launch IM. You can write a login macro to do this but make sure to allow time to get tup to speed.

Good luck!

RE: Scheduling Integration Manager

The login macro usually works but the exiting GP does not work consistently and depends on the version you are using.

The cool thing is the SQL Optimized integrations.  GP is not required to be running so there is no need for a login or logout macro.  This is keeps you from tying up a user against your user count.  

Unfortunately, they have only written certain destinations and Journal Entry is not one of them.  Funny that they do GL Account which is typically a one time integration.

RE: Scheduling Integration Manager

The last response indicated that journal entry upload is not a destination for Integration Mananger.  That is not correct.  The destination is named "General Journal".  We use it all the time.  To get a complete list of the destinations, open Integration Manager and click on Help \ Contents and then on Destinations \ Available Destinations.  I can provide the spreadhseet we upload from (or you could use text files amongst other possibilities) and any set up help you might need for manually uploading the entries.  I have not, however, set up any automatic or scheduled job to do it.

RE: Scheduling Integration Manager

I'm sorry that was misleading.  What I meant was that General Journal was not a destination in SQL Optimized adapter.

Yes, I also do General Journal integrations.  I have a client who uses them so much from another system that I wrote the integrations using the Excel data source.  

Unfortunately, those require you to either run while GP is open or use a macro that logs in and logs out.  The log out macro doesn't work consistently on version 7.

Anyway, good luck! :)

RE: Scheduling Integration Manager


Thank you all very much for the responses.  This part of my project has been held up while I complete some other things.  However, I expect to get back to this in a couple of weeks.  I'm sure I'll have more questions then.

Again, thanks very much, I really appreciate people taking the time to read this and respond.

-Chris Jardin

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close