PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 02/01/2012 10:22 AM by  mark.cook
App Link to Smart Office Forms
 11 Replies
Sort:
You are not authorized to post a reply.
Author Messages
KJBULLS
Consultant
Lawson Partner
Basic Member
(15 points)
Basic Member
Posts:7


Send Message:

--
01/24/2012 12:14 PM
    Does anyone know how to create an Application link to Smart Office forms? I know how to do this to go to portal and inquire a specific record for a specific form but I cant get it to work in Smart Office. Can anyone please post an example? Thanks for your help

    KJ
    mark.cook
    Private
    Private
    Veteran Member
    (1244 points)
    Veteran Member
    Posts:444


    Send Message:

    --
    01/24/2012 12:40 PM
    Have you tried something like this:

    sforms://ap10.1/?_PDL=LIVE&_VIEW=form&_HK=_DATAPARAM~~VEN-VENDOR-GROUP~1~~VEN-VENDOR~100~~
    KJBULLS
    Consultant
    Lawson Partner
    Basic Member
    (15 points)
    Basic Member
    Posts:7


    Send Message:

    --
    01/25/2012 11:37 AM
    Hi Mark,

    Thanks for your response. I have tried like you said:

    http://xyz:19005/LSO/Laws...~~ACM-CUSTOMER~86402

    It works outside of LBI. Within LBI when I click on the link, it takes me to AR10 form, fills in the company 2000 but it does not fill in the Customer parameter value. I have tried several other things, but it just does not want to pass the Customer parameter. It only passes the first parameter. Any other suggestions?

    Thanks for your help
    Matthew Nye
    Private
    Private
    Veteran Member
    (1532 points)
    Veteran Member
    Posts:514


    Send Message:

    --
    01/25/2012 12:21 PM
    that sounds like a data issue. you might have to do some data conversion tricks with the customer field in SN. Otherwise, check the status bar in IE, it should give you some hints. if not, inspect the XML definition of AR10 and make sure it matches what you are trying to pass in. Im not intimately familiar with AR10 but are you sure Company/Customer are the only two required fields? i always do a manual inquiry with the values to check this.
    If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/
    mark.cook
    Private
    Private
    Veteran Member
    (1244 points)
    Veteran Member
    Posts:444


    Send Message:

    --
    01/25/2012 12:34 PM
    I took your link, popped my server info both in LBI as a link and from Notepad and it worked. You have to be close.

    I also tried it with ~~ at the end to see if it impacted the syntax any but got the same results that it popped the company and customer both filled in.
    mark.cook
    Private
    Private
    Veteran Member
    (1244 points)
    Veteran Member
    Posts:444


    Send Message:

    --
    01/25/2012 12:39 PM
    I think Matthew has your next step, there could be a issue with how the data is pulling in. I used this in a browser window and a link to within Framework services, I populated the Company and Employee numbers with values and it worked.

    See if you can use the link in a browser with prepopulated data. If that works the syntax is correct and you just have to figure out how to pass the value in the link.

    KJBULLS
    Consultant
    Lawson Partner
    Basic Member
    (15 points)
    Basic Member
    Posts:7


    Send Message:

    --
    01/25/2012 2:43 PM
    Hi Mark & Matthew,

    Thanks for your response. I made sure that I have the customer in the right format. I tried TRIM as well as LPAD functions as their customer field length is 9. Also I made sure that Company and Customer are the only fields required to inquire the form. They are both coming from ACM table.

    When I run the link in the browser with hardcoded company and customer values, it works like a charm. When I add the link in the Smart Notes WITH hard coded values, it passes the Company number but leaves the customer number blank. Here is my link again. Not sure what I am missing:

    with Hard Coded Values: (It works great in the browser but not in SN. In SN even with hard coded values it only passes Company value and leaves customer blank)

    sforms://AR10.1/?PDL=PROD901%26_VIEW=form%26_HK=_DATAPARAM~~ACM-COMPANY~2000~~ACM-CUSTOMER~86402

    without Hard Coded Values: (Does not work- passes Company but does not pass Customer)

    sforms://AR10.1/?PDL=PROD901%26_VIEW=form%26_HK=_DATAPARAM~~ACM-COMPANY~[COMPANY]~~ACM-CUSTOMER~[CUSTOMER]

    Please advise. I am so close to the solution but struggling. Again thanks so much for your help.


    Ruma Malhotra
    Private
    Private
    Veteran Member
    (1092 points)
    Veteran Member
    Posts:412


    Send Message:

    --
    01/25/2012 3:16 PM
    You would also need to check whether there is an AR10 property that exists in the Lawson.xml file.

    Also in your syntax can you replace %26 with %20 and try again.

    Good luck.
    Ruma Malhotra
    Private
    Private
    Veteran Member
    (1092 points)
    Veteran Member
    Posts:412


    Send Message:

    --
    01/25/2012 3:22 PM
    My links work with the following format:

    fully qualified URL/efs/LAL?SID=LAL Service Name on LBI&SF=TKN&_TKN=AR10.1&_HK=[Company]%20[Customer]
    KJBULLS
    Consultant
    Lawson Partner
    Basic Member
    (15 points)
    Basic Member
    Posts:7


    Send Message:

    --
    01/26/2012 9:32 AM
    Are you linking SN to Smart Office or Portal? I am linking from Smart Notes to Smart Office S3 Forms .

    Thanks
    Ruma Malhotra
    Private
    Private
    Veteran Member
    (1092 points)
    Veteran Member
    Posts:412


    Send Message:

    --
    01/26/2012 9:49 AM
    My apologies. I am talking about portal to smart notifications.
    mark.cook
    Private
    Private
    Veteran Member
    (1244 points)
    Veteran Member
    Posts:444


    Send Message:

    --
    02/01/2012 10:22 AM
    KJ let me know if you got this to work. I tried it from a SN as well and got the same issue you did. It will be a week or so before I get back to it as the SN I use does not effect anyone in LSO as we are rolling this out in phases for now.
    You are not authorized to post a reply.