karinpb sent me the solution to get the current M3 profile (TST, DEV, EDU, etc.) in a Mashup in Lawson Smart Office. In my case, I use the value to launch a URL with the profile as a parameter. Here is the solution:
- Add the namespace:
xmlns:Services=“clr-namespace:Mango.Services;assembly=Mango.Core” - Add a control that shows the value:
<TextBlock DataContext=“{x:Static Services:ApplicationServices.SystemProfile}” Text=“{Binding Name}” />
- Here is a screenshot of the result:
Special thanks to Karin for the solution!
M3 ideas 
Hi,
Very good information on this page.
Good to know this group
Question : where can i find all the properties in the UserContext and SystemProfile ?
I’m looking for the API port, the web service server url and ….
LikeLike
Bonjour Hervé. You can find those properties in Smart Office > Navigator > Administration Tools > Profile Editor. You read those properties from a Mashup with for example for the LWS server: {mashup:ProfileValue Path=M3/WebService/url} . Karin posted an example. I will post another one soon.
LikeLike
Hervé, voici l’exemple: https://thibaudatwork.wordpress.com/2012/03/19/how-to-get-the-url-to-lawson-web-services-in-a-mashup/
LikeLike
Hi,
Thanks a lot for the valuable information. I would like to get the settings from External Profile configured in the profile editor. How can I use Jscript to get the path, parameters, etc.?
Best Regards,
Warren
LikeLike
Hi Warren, you do something like this: Mango.Services.ApplicationServices.SystemProfile.GetProperty(‘M3’, ‘WebService’, ‘url’)
LikeLike
It is highly appreciated. It helps me find the right syntax to the settings of External Application Group’s property. It is something like
Mango.Services.ApplicationServices.SystemProfile.GetProperty(‘External′, ‘FASTLSO’, ‘parameters’)
I can now put our SQL server connection information here to make JScripts more generic.
Thanks again.
Best Regards,
Warren
LikeLike
You’re welcome Warren. Also, you can shorten the statement by adding import Mango.Services at the top of your script, by using a variable var profile = ApplicationServices.SystemProfile, and by simply calling profile.GetProperty(…). As for doing direct SQL from scripts, if that’s what you’re doing, there have been discussions on this blog and/or on http://smartofficeblog.com/ about how a bad idea it is for many reasons, one of them being the need to install/setup an ODBC driver on each user’s computer = maintenance nightmare. The preferred method is creating a Lawson Web Service of type SQL, and making the asynchronous SOAP request from the script. And there’s already a setting for LWS URL in the System Profile (the one I wrote in my previous comment) so you wouldn’t need to add your own settings to the profile. Hope it helps. /Thibaud
LikeLike
Dear Thibaud,
Thanks a lot for your kindness. Yes, I need to find a way to make my JScipts more generic to call SQL according to the environment. Due to your help I have found it. 10.0.5.2 allows to create new application groups, add new types and new properties. I created an application group called “FAST” (my company name) and a type called “FASTSQL” with the properties of Server, Database, User and Password. Then my scripts can get the values of those properties by calling the SystemProfile object. It is working perfectly. What I need is to replicate the application group to each environment, of course, with different property values. It is better not to use the existing External group, because it is used for launching external applications and the application name can be seen user the Other menu of the Navigator.
The web service way is used by me only as the data source for data list panel in Mashup, which has no way to call SQL directly. It is a pain, as I have to generate the web service for each call, although the web service designer is easy to use.
Anyway, now we have a good solution for that purpose. It is a pity that I cannot attach a screen shot here for you to have a look.
I have another issue, which I will find a correct post to put it on.
Thanks again and Best Regards,
Warren
LikeLike