PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 12/10/2008 5:08 PM by  MARCO3535
Add-Ins Query - Unattended
 10 Replies
Sort:
You are not authorized to post a reply.
Author Messages
William Saltmarsh
Private
Private
Basic Member
(11 points)
Basic Member
Posts:5


Send Message:

--
9/2/2008 12:24 PM

    Is there a functionality/mechanism that will allow an Add-Ins query to run completely unattended, that is, with no operator intervention for entering login credentials and deleting duplicate output files?

    John Henley
    Private
    Private
    Senior Member
    (9899 points)
    Senior Member
    Posts:3317


    Send Message:

    --
    9/2/2008 12:50 PM
    No, there is not a way to implement unattended "lights-out" automation using Excel AddIns. In fact, you can't even use VBA to control the Addins (beyond invoking them). Depending on your requirements, you can use some scripting or programming environment to do something similar via DME/Data queries...
    Thanks for using the LawsonGuru.com forums!
    John
    William Saltmarsh
    Private
    Private
    Basic Member
    (11 points)
    Basic Member
    Posts:5


    Send Message:

    --
    9/2/2008 1:19 PM

    Thanks for your reply, John. I suspected that was the answer I was going to receive. Why would Lawson want to make things easier when we can do it the old fashioned way?

    John Henley
    Private
    Private
    Senior Member
    (9899 points)
    Senior Member
    Posts:3317


    Send Message:

    --
    9/2/2008 1:54 PM
    It's pretty sad, I think. I remember talking to the developer of the Addins a few years ago and when I asked him why they didn't VBA-enable them, his response was "that's a great idea--we didn't even think about that!"!!
    Thanks for using the LawsonGuru.com forums!
    John
    William Saltmarsh
    Private
    Private
    Basic Member
    (11 points)
    Basic Member
    Posts:5


    Send Message:

    --
    9/2/2008 2:11 PM

    I hear you, John. Pretty sad indeed. But wait, here's another great idea. I could submit an Enhancement Request. No, maybe not. I might have to wait another year or so to get a final answer. I did that once and as a result am discouraged from ever doing it again. I had the full support of everyone (fellow users) I ever talked to about it except from the people whose opinion counted the most, Lawson. 

    k-rock
    Private
    Private
    Veteran Member
    (416 points)
    Veteran Member
    Posts:142


    Send Message:

    --
    9/2/2008 6:59 PM
    If you have the talent to write lights-out scripting, why are you still using add-ins? There are a lot of tools much more well suited to that task in the market place.
    William Saltmarsh
    Private
    Private
    Basic Member
    (11 points)
    Basic Member
    Posts:5


    Send Message:

    --
    9/3/2008 11:19 AM

    Hey, k-rock, thanks for jumping on board. It was not my intention nor did I ever mean to convey the implication that I had enough talent to write as you say, lights-out scripting, because if that were the case I would be doing something sufficiently different than what I am doing now. Be that as it may. The point I was trying to make was that Lawson may not always seem to have what I perceive to be the user community's best interest in mind despite statements to the contrary. Sometimes Lawson appears to do what's best for Lawson and there's nothing wrong with that in a pure business context. Why reach out to the user community and ask for suggestions to improve the product or service but then turn around and make it a significant challenge to opt in toward that regard?

    Shane Jones
    Private
    Private
    Veteran Member
    (1246 points)
    Veteran Member
    Posts:460


    Send Message:

    --
    9/11/2008 8:13 PM

    Would you be able to use Process Flow Integrator for this?   I am hoping to try this once I upgrade later this year....

     

     

    Shane Jones
    Tools: HR, Payroll, Benefits, PFI, Smart Office, BSI, Portal and Self-Service
    Systems: Lawson, Open Hire, Kronos, Crystal Reporting, SumTotal Learning
    ** Teach others to fish...
    John Henley
    Private
    Private
    Senior Member
    (9899 points)
    Senior Member
    Posts:3317


    Send Message:

    --
    9/11/2008 9:13 PM
    Re: Add-Ins Query - Unattended (8ebe8e13-dc4f-4353-9dda-b0e31f35e518) <!-- Converted from text/plain format -->

    Yes, absolutely.
    John Henley

    Thanks for using the LawsonGuru.com forums!
    John
    jeremy.zerr
    Private
    Private
    Advanced Member
    (55 points)
    Advanced Member
    Posts:23


    Send Message:

    --
    11/10/2008 8:50 PM
    I got around the problem of not being able to automate an Add-ins query by taking the DME web query that the Query Wizard generates, and automating it in a few ways.

    I've embedded it into Excel VB, in perl, in javascript (like Lawson portal), and in php.

    You just need to set your query up once in the Query wizard, then copy the DME web query URL, and use that in all those other programming environments.  Basically, because it really is just a web call, almost every single programming language supports calling it and processing the output.

    I wrote up how to do it in perl in a post on my website:
    Lawson reporting using DME from perl

    Its probably more useful to do it from Excel VBA since that seems like its more handy for people to run.  Of course, I can't really 100% automate an Excel solution, it requires people to open the spreadsheet up and click a button, but after that, the whole DME query and processing can be automated.  Usually is good enough in most cases.  But if you are looking for 100% automation, then a real programming language like perl is likely your answer.

    And don't think that because you have Windows, that you can't run perl.  My desktop is Windows, and I run perl to automate a bunch of DME queries.

    Jeremy Zerr
    Lawson Reporting
    MARCO3535
    Private
    Private
    Advanced Member
    (59 points)
    Advanced Member
    Posts:25


    Send Message:

    --
    12/10/2008 5:08 PM
    Sorry to jump in so late, but I'm researching whether the excel addin-upload to run the same time everyday without human intervention. 

    I have been asked to run an upload that was run periodically to now run run into HR11 everyday.

    It doesn't sound like this is an attainable goal.  If it is, is there a recomended method.

    Thanks




    You are not authorized to post a reply.