Register
Login
 
 Search 
Site Map
 
HomeAppsS3 AppsS3 FinancialsS3 HR/PayrollS3 Supply ChainS3 ProcurementM3 AppsEnterprise Asset Management Manufacturing OperationsFinancialsBPM/EPM/LBIDesign StudioEnterprise Reporting (Crystal)Microsoft Add-InsProcessFlow / BCISmart NotificationTechDatabase ERDsData DictionaryApplication SecurityDevelopmentLawson 4GL Quick ReferenceDesign StudioDatabaseDB2OracleSQL ServerEnvironmentiSeriesUnixAIXWindowsLogan/IOSLSF 9M3 System Foundation PortalERDsDocumentationTips & TricksForumsJobsLawsonGuruLawsonGuru LetterLawsonGuru BlogWorthwhile ReadingLawson in the NewsUser RegistrationStoreStore AdminMy PurchasesStore FAQsSearchEngage Publish Search IndexerSearch ResultsSearch TipsArticle ViewerJohnContentUser ManagerBackupsVenexusVenexus Web ControlsAboutAdminSite SettingsTabsSecurity RolesUser AccountsVendorsSite LogBulk EmailFile ManagerRecycle BinLog ViewerSkinsLanguagesSite WizardAuthenticationSolutions
Top 10 Posters
 
Share:email email|delicious.com delicious.com|digg digg|technorati technorati|reddit reddit|stumbleupon stumbleupon|google bookmarks google bookmarks|yahoo bookmarks yahoo bookmarks|slashdot slashdot|live live|ma.gnolia ma.gnolia
Tips on Using the LawsonGuru ForumsMaximize

LawsonGuru ForumsMinimize
Subject: Accessing Lawson DME from an external app
Prev Next
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion. 

AuthorMessages
rcUser is Offline
New Member
Posts:3

4/30/2008 9:56 AM 

I have been successful in sending a URL (pasted below) to the Lawson DME and having it return an XML or CSV file to a web browser. I can embed the username and password in the URL to bypass the SSO login screen, however, when I try the same URL using my downloaded http_get.c program it returns the SSO login screen. Anyone have any suggestions? is there some http options/settings I need to change? Does the web browser do something magical that I cannot in my C program?

http://ServerName/sso/SSOServlet?_action=LOGIN&_ssoUser=lawson&_ssoPass=lawson&_ssoOrigUrl=http%3A%2F%2FServerName%2Fcgi-lawson%2Fdme.exe%3FPROD%3DLOGAN%26FILE%3DWFACTIVITY%26INDEX%3DWACSET1%26FIELD%3DWORKUNIT%3BPROCESS-ID%3BACTIVITY-ID%3BACTIVITY-NAME%3BACTIVITY-TYPE%3BACT-STATUS%3BSTART-DATE%3BSTART-TIME%3BEND-DATE%3BEND-TIME%3BWF-SEQ-NBR%26OUT%3DXML%26DELIM%3D%7E&_serviceName=SSOP

JasonUser is Offline
Frequent Member
Posts:10

5/16/2008 8:13 AM 
Did you ever solve this? I am in the same boat. See my post on AGS and SSO. Let me know if you come up with anything. It's definitely something with the cookies.
rcUser is Offline
New Member
Posts:3

5/16/2008 8:46 AM 

There is a little sample Java program in an IOS Developer guide found on the Lawson support site that provides the API to login to SSO and call the DME. This only works on version 9...I believe just passing the URL with login info embedded will work on version 8, I have yet to try as I am awaiting the install...

JasonUser is Offline
Frequent Member
Posts:10

5/16/2008 9:45 AM 

Where can I expose this API? I think I need the LHC.jar file.

darwincollinsUser is Offline
New Member
Posts:3

5/30/2008 9:26 AM 
I responded to this thread earlier but don't see the post. In our case, we found that we need to now make two calls to the gateway (instead of 1). First one to get authenticated, get cookie, and then the 2nd to make the call to do actual work.
rcUser is Offline
New Member
Posts:3

5/30/2008 11:56 AM 
Does anyone have trouble with the data coming back from these URLs? I request quarterly deduction data for two employees in my URL using the | as the OR conditional (employee=1000|employee=1002) and I get all the employees? aggravating...I also have a problem with the amount of data coming back, it only returns so much then I get a RELOAD URL like
RELOAD=/servlet/Router/Data/Erp?FILE=QUARTDED&OTMMAX=600&INDEX=QTDSET1&NEXT=TRUE&%28EMPLOYEE=1000%7C1002%29&FIELD=COMPANY%3BPROCESS-LEVEL%3BEMPLOYEE%3BPAYROLL-YEAR%3BQUARTER%3BDED-CODE%3BDED-AMT%3BTAX-WAGES%3BWAGE-AMOUNT%3BEXCESS&PROD=HR&OTMDELIM=%7E&SELECT=COMPANY%3D4321&OUT=CSV&SORTASC=COMPANY;QUARTER&BEGIN=4321=1200=2006=1=US=TEFW=spaces=spaces=spaces=RETIR=MN=Y&
I try submitting this URL so I can concat this to the original but there is duplicate data? Anyone know whats going on here?


John HenleyUser is Offline
Super Member!
Posts:1148

5/30/2008 3:01 PM 
What are you using as the &OUT parameter? For XML 25 records are returned. For CSV I think it's 10,000 records. Both I think can be overridden by adding &MAX=999999 or by changing $LAWDIR/system/iosconfig.xml ...

Thanks for using the LawsonGuru.com forums!

John
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
Forums > Lawson System Foundation > S3 Customization/Development > Accessing Lawson DME from an external app



ActiveForums 3.7
Forum Postings...Minimize
S3 HR/Payroll/Benefits
PR39 and Benefit Deductions
8/28/2008 4:43 AM
I had a user enter about 300 o...
S3 HR/Payroll/Benefits
RE: PA100 and Effective Dates
8/28/2008 4:17 AM
If you run your PA100 and ente...
S3 Customization/Development
Lawson HCM in different language
8/28/2008 1:09 AM
Hi, I'm a complete newcomer t...
S3 Systems Administration
RE: Updating LSF Core Technology 9.0.0.3 - 9.0.0.5
8/27/2008 7:04 PM
The batch mode is much better,...
S3 HR/Payroll/Benefits
RE: PA100 and Effective Dates
8/27/2008 3:27 PM
Thanks, Stephanie.  What ...
S3 HR/Payroll/Benefits
RE: PA100 and Effective Dates
8/27/2008 2:38 PM
We would handle that situation...
S3 HR/Payroll/Benefits
RE: PA100 and Effective Dates
8/27/2008 2:19 PM
How do you handle a situation ...
S3 HR/Payroll/Benefits
RE: PA100 and Effective Dates
8/27/2008 2:04 PM
The PA100 will process pending...
S3 Systems Administration
Online screens hanging
8/27/2008 1:59 PM
All online screens are hanging...
S3 HR/Payroll/Benefits
PA100 and Effective Dates
8/27/2008 1:54 PM
I need feedback from my fellow...
S3 Security
RE: MSS Direct Reports Security Rule
8/26/2008 4:43 PM
Thanks, John. This works out g...
S3 Systems Administration
RE: Updating LSF Core Technology 9.0.0.3 - 9.0.0.5
8/26/2008 1:43 PM
Hi Dana, We never actually ma...
S3 Systems Administration
RE: Updating LSF Core Technology 9.0.0.3 - 9.0.0.5
8/26/2008 1:07 PM
Thanks Ben, I appreciate it. ...
LWSN Business Practices
RE: Lawson CUE 2010
8/26/2008 12:51 PM
I heard back from Lawson and C...
S3 Supply Chain
RE: ABC classification
8/26/2008 12:12 PM
In update mode, IC151 will ass...
Home  |  Forums  |  Jobs  |  Store  |  About