Tag: Mashup

Here is a solution to add columns to a list of an M3 panel in Smart Office without doing any M3 Java modifications and without writing any scripts. The advantage is zero programming. In addition, this technique is interesting when it’s not possible to create custom Sorting Orders (QTTP) nor custom Views (PAVR) for an M3 program (for example Stock Location – MMS010). This technique uses a new feature of M3 called Custom Lists. To create custom lists you will need the Industry Enrichment Package IEP F09201M306 in MNS096.

In this example I will add three columns Geo code X, Y, and Z to the list of Stock Location – MMS010/B1. The values come from the fields GEOX, GEOY, and GEOZ of MMS010/F. This solution is an alternative to the solution of my previous post where I illustrated how to programmatically add columns to a list by writing a script.

Desired result

The desired result is the list Stock Location – MMS010/B1 with three new columns Geo code X, Y, and Z.

Custom List

To create this custom list I follow these steps:

1. First, I create a new Information Browser Category in CMM310, GEOCODES in this example:
   
2. Then, I create a new View in CMM315 where I include the desired new columns, MSGEOX, MSGEOY, and MSGEOZ in this example:
   
3. Then, I simulate the list to select the columns to display and to select the order of the columns:
   
4. Finally, I add the Custom List to a Mashup where List type = Custom:
   

Final result

The final result is a Mashup with Stock Location – MMS010 and three new columns Geo code X, Y, and X.

Conclusion

With the new IEP feature and with Mashups we can now create Custom Lists in M3 by configuration only, i.e. without any programming.

For more information

To learn this technique and more, refer to the Mashup Designer Advanced training (code SMMA2) from the Lawson Learning courses.

Related articles

• How to add a column to a list (continued), latest post on how to add columns to a list with a script
• How to add a column to a list, older post on how to add columns to a list with a script

Here is a solution to write a Mashup in multiple languages in Lawson Smart Office, for example in English and Spanish. This task is a part of Localization (L10) and Internationalization (i18n).

Background

Smart Office is available in multiple languages, and the language can be switched by selecting Show (in the top right corner) > Settings > Lawson Smart Office > General:

We can write a Mashup so as to dynamically adapt to the current language.

1) Localization files

First, we create XML files with the constants in each target language. In this example I create the files en-us.xml and es.xml for English and Spanish, and I choose to place those files in a sub-folder named Localization in my Mashup folder:

We add the constants to the XML with a text editor such as Notepad. In this example, I have one constant Welcome which I set in English to Hello World! and in Spanish to Hola mundo!

My file en-us.xml contains:

<?xml version="1.0" encoding="utf-8" ?>
<assembly name="">
 <area name="">
 <entry name="Welcome">Hello World!</entry>
 </area>
</assembly>

My file es.xml contains:

<?xml version="1.0" encoding="utf-8" ?>
<assembly name="">
 <area name="">
 <entry name="Welcome">Hola mundo!</entry>
 </area>
</assembly>

We add as many <entry> elements as we have constants.

2) Project

Then, we declare those XML files in the Project in Mashup Designer.

For that, select File > Add Resource, and browse to the XML files, en-us.xml and es.xml in my example:

That will add the XML files to the Project Explorer:

3) XAML

Finally, we invoke our constants from the XAML code with the binding {mashup:Constant constant}. In this example I invoke the constant Welcome in a Label:

The XAML code will look like:

<Label Content="{mashup:Constant Welcome}" />

Result

Here is a screenshot of the Mashup in English:

Here is a screenshot of the Mashup in Spanish:

For more examples regarding translation, read the article Translate M3 with Google Translate API to automatically translate M3 and user-generated content in 52 languages.

Thanks to Juan V, and karinpb for their help!

Here is a solution for a Mashup to use an M3 program that doesn’t yet support bookmarks, for example MMS081. If the program doesn’t support bookmarks the options are limited. Normally only M3 programs that are bookmark enabled are supported in a Mashup.

But we can workaround the limitation by using the Program attribute instead of a Bookmark element.

<m3:ListPanel Name="MMS081B" Program="MMS081">
    <m3:ListPanel.Events>
       <mashup:Events>
          <mashup:Event SourceEventName="Startup" />
       </mashup:Events>
    </m3:ListPanel.Events>
</m3:ListPanel>

Note that starting programs using the Program property is a bit risky since we cannot guarantee the Sorting order nor the initial values on the panel as we can with Bookmarks.

In this case there is no standard way to set header fields when the program is started. But after the program has been started it can be set to blank using the M3 Mashup Apply event. We can use the Apply event to set values in the header and position fields, and when the values are set the ListPanel will automatically press the ENTER key to update the list.

As an example of the Apply event, we can set the Facility (FACI) to a certain value using the Apply event.

<Button Name="testButton" Content="Set Facility">
    <Button.CommandParameter>
       <mashup:Events>
          <mashup:Event TargetName="MMS081B" SourceEventName="Click" TargetEventName="Apply">
             <mashup:Parameter TargetKey="W1FACI" Value="A01" />
          </mashup:Event>
       </mashup:Events>
    </Button.CommandParameter>
</Button>

As another example of the Apply event, we can transfer a parameter from another ListPanel, for example the Item Number ITNO of MMS001/B:

<m3:ListPanel Name="MMS001B" Header="Items">
    <m3:ListPanel.Events>
       <mashup:Events>
          <mashup:Event SourceEventName="Startup">
             <mashup:Parameter TargetKey="MMCONO" />
             <mashup:Parameter TargetKey="MMITNO" />
          </mashup:Event>
          <mashup:Event SourceEventName="CurrentItemChanged" TargetName="MMS081B" TargetEventName="Apply">
             <mashup:Parameter SourceKey="ITNO" />
             <mashup:Parameter SourceKey="FACI" Value="A01" />
             <mashup:Parameter TargetKey="WHLO" Value="001" />
          </mashup:Event>
       </mashup:Events>
    </m3:ListPanel.Events>
    <m3:ListPanel.Bookmark>
       <m3:Bookmark Program="MMS001" Table="MITMAS" KeyNames="MMCONO,MMITNO" />
    </m3:ListPanel.Bookmark>
</m3:ListPanel>

Thanks to Peter K for all the help!

Here is the solution to get the current Company (CONO), Division (DIVI), and Facility (FACI) in a Mashup in Lawson Smart Office. Last week I wrote a post on How to get the current username in a Mashup. This week I post about CONO, DIVI, FACI:

1. Add this namespace to the Mashup:
   xmlns:mforms=”clr-namespace:MForms;assembly=MForms”
2. Get the values with this extension method:
   {mashup:UserContextValue Path=M3/Company}
   {mashup:UserContextValue Path=M3/Division}
   {mashup:UserContextValue Path=M3/Facility}
3. Alternatively, you can use the field names:
   {mashup:UserContextValue Path=M3/CONO}
   {mashup:UserContextValue Path=M3/DIVI}
   {mashup:UserContextValue Path=M3/FACI}
4. Use the value for example in a TextBlock:
   <TextBlock Text=”{mashup:UserContextValue Path=M3/Company}” />
   <TextBlock Text=”{mashup:UserContextValue Path=M3/Division}” />
   <TextBlock Text=”{mashup:UserContextValue Path=M3/Facility}” />

Here are the values you can get:
CONO | Company, CompanyName
DIVI | Division, DivisionName
FACI | Facility, FacilityName
WHLO | Warehouse, WarehouseName
LANC | Language
DTFM | DateFormat
DCFM | DecimalFormat
TIZO | TimeZone
CUNO | Customer
DEPT | Department
Menu
MenuVersion

Here is a screenshot of the result:

Special thanks to karinpb and Juan V of Spain for their help!