Saturday, September 20, 2014

Example SAP Smartform with QRcodes using the Barcode Writer in Pure Postscript

Example QRcodes in SAP Smartforms with the Barcode Writer in Pure Postscript

First follow the SAP my original QRcode SAP blog post

Then download the example SAP Smartform here, to your computer.

Run the smartforms transactoin

Upload the form as shown

The form name is z_qrcode_bwipp

Locate the downloaded smartform and open

Go into the smartform in change mode

Activate the Form

Only test the form, it is standalone and should work as required in test mode.

Hit the test mode and select the printer created in the first blog post

A PDF should be created as follows from the example smartform.
Check the smartform out to see how it works. Then watch the Youtube video here for more ideas on using the Barcode Writer in Pure Postscript with SAP.
Any questions, let me know in the comments section.

Friday, June 6, 2014

Bits and Pieces from my SAP HANA Cloud Portal Movie Producer entry

My SAP HANA Cloud Portal Movie

It's an SCN World

Link to my SCN blog


I can't open up my SAP HANA Cloud Portal site as it relies too much on my developer edition SQL Anywhere instance in the AWS EC2 cloud. As its only a developer edition then I can't really open it up to offer a "service" :)

Lumira Cloud Analysis 

I do cover a SAP Lumira Cloud analysis of 3 months of @SCNblogs twitter tweets with BITLY links in my blog. Shame that SCN Jive platform does not allow such standard SAP features such as embedding Lumira Cloud stories (unbelievable really that the SCN Jive platform blocks SAP software ). However I am not a fan of the Lumira cloud in that I find it does not always embed correctly anyway. Also no control over the display so if your screen is not big enough Lumira drops chart labels and the actual charts do not have any legends (unless you click on them)! Which to me sometimes makes the charts unreadable. Anyway a link to the @SCNblogs Jan-Mar 2014 analysis is here.

SDN Points 2004-2010 

The Google Earth SDN points 2004-2010 in an iFrame below, you need a windows or mac for the plugin to work.

Geoserver running in the SAPHCP

The top SDN points user per country just before Jive came along. Click on the country and the user with the most SDN points business card will be displayed. The old SDN business cards are still "out there".


Friday, May 9, 2014

#SAP #Lumira: U.S. Census Quickfacts on a Custom U.S. Counties Choropleth Map (custom #d3js and #topojson)

This is a cross post from my SCN document on the same subject. I intend to add some more "experimental" :) features on this page as I go along and more "stable" ones on the SCN site.

After following this blog post the data from the US Census quickfacts site can be shown on a custom US Counties Choropleth map in SAP Lumira. An example map is here. It is based on the free personal edition of SAP Lumira which can be downloaded for free from this page.



The custom US Counties map Lumira extension is based on the following

1) Document from Manfred Schwarz  Lumira Geoextension with datamaps.js and topojson.js , however no datamaps.js is used in this custom map. The great work by Manfred in regards to setting up require.js to use D3.v3 and topojson was used in this extension.

2) The custom US counties map is based on the same code found in a blog by Robert Russell (me:))  Custom Choropleth Maps with VizPacker

The custom topojson map of the US counties is based on an original county map found here  No restrictions have been placed on the original US counties map

TOPOJSON was used to convert the map and simplify it.

Version Information

VersionDownload LocationLumira Version
Version 1
9th May 2014
Custom US Counties Map - Download the extension here.1.15

Install Vizpacker extension

Download the extension from the link provided “Version Information” section above.

1) Quit SAP Lumira to install the extension.

2) Extract the downloaded file into the Lumira extensions folder (administrator authorisation is required)

C:\Program Files\SAP Lumira\Desktop\extensions

After extracting the file you should have the following folder

C:\Program Files\SAP Lumira\Desktop\extensions\bundles\viz\ext\rjruscountiesv1\

  With the following files required for the US counties choropleth map
  1. d3.v3.js
  2. domReady.js
  3. rjruscountiesv1-bundle.js
  4. topojson.v1.min.js

Download US Census QuickFacts Data

Download the following files from the quickfacts census site

  1. DataSet.txt
  2. DataDict.txt
  3. FIPS_CountyName.txt
Download all files to a local drive.

There is a requirement to convert the data into excel files. This is required to ensure that leading zeros are not dropped from the FIPS county codes.
On the quickfacts download page there is a description of how to format the data. Some screenshots are below to highlight the necessary steps for the FIPS data and variations found in loading the data.

1) Convert the DataSet.txt to an Excel format


Essential to format the FIPS column as Text as this is to prevent the leading 0 being dropped from some of the county FIP codes.

Save as a new Excel file

2) Convert the DataDict.txt file to an Excel format

Following options taken when splitting the DataDict file which is different to how it is described on the download page.



Save as a new Excel file

3) Convert the FIPS_CountyName.txt  file to an Excel format

Again it is important to load the FIPS data as follows


Essential to use Text as column name as shown.


Split the United States Column (Column B)

Select only Column B select Data and split into Columns as shown below



ADD column header names


Save as new Excel file

Format Data

Insert two rows at the top of the new Excel file DataSet.xslx

Follow the section to add descriptive headings to the DataSet file on the download page.

“Copy headings from DataDict to the top of the DataSet worksheet”

The final DataSet.xslx file should look like this.


Save the DataSet.xslx file and the rest of the work is in Lumira.

Lumira will be used to add the county names as follows.

Load the FIPS_CountyName.xslx file and DataSet.xslx and take the option to merge the data.

The result should be a 100% match on the FIPS columns in both files.


Add a filter to exclude the “blank” States in the State CODE column, so only US counties will be available in Lumira visualisations.


Select the Custom chart “US Counties – SCN demo”  as shown below.


Select Measure required and the FIPS dimension as per the example shown below.

Tuesday, March 25, 2014

SAP Lumira Extension: Custom Map of Japan

With this blog post I will build on my SAP Lumira extension of a choropleth map of Japan.

The extension can be downloaded here., and the following blog will cover it's use.

The background to the original extension is covered in my SCN blog

Custom Choropleth Maps with VizPacker

This blog and my extension was featured as a "Cool Example" in the SAP webinar here

SAP Lumira SDK - An Introduction and Cool Examples

My intentions for adding extra features/functionality to this extension is a way to try and build the best map *I* can. Emphasis on the "I" as I can't build the best map ever :) . Also it is a good example for me to learn more about D3 and making the map as user friendly as possible inside SAP Lumira.

A free copy of SAP Lumira can be downloaded from the main Lumira site
I only use the free personal edition and all my examples are built on this free version.

I will be adding blog entries on a regular basis with added features or new ways of implementing the technical code for the map or for different countries.

I will be releasing with an update based on dates and the first of these being the 26th March 2014.

Japan Choropleth Map Update 1 - 26/03/2014

Custom Choropleth Map of Japan.

The main updates to the map for this post is to create a pure choropleth map of Japan and strip out the football references in the SCN blog. Also the method to lookup the prefectures is extended, the first example only used the names found inside the Natural Earth Shapefile to recognise the prefectures. With the first update I have added Kanji, Romaji, ISO-codes, FIPS codes and prefecture numbers as ways to build the choropleth map. These can be selected or changed without reloading the map. I have added Javascript code to auto detect these values to match the prefecture name to the map. These lookup values are also available for download for reference.

Download the code and the lookup table from here

The zip file contains two files,

Close SAP Lumira if it is already running.

Extract the downloaded VizPacker file "" extension to the "extension" directory as shown in the screenshot

After the extension is extracted there should be the japanv1-bundle.js file in the directory structure as shown below.

Example using the Wikipedia data for the population of Japan by prefecture

Taking the first line of the actual data from the Wikipedia page. As you can see the prefecture name is in Japanese and romaji. My SAP Lumira map extension will be able to use these "Prefectures" and "Japanese" columns as attributes to create the choropleth map. The text file in the download contains all the possible attributes that can be used.

(Oct 1, 2010 to
Sep 30, 2011)
of Japanese
(Oct 1, 2010)
1Tōkyō-to東京都13,195,9746,523,5516,672,42336,58612,869,20513,159,3882,188.676,029.22Shinjuku-ku, Tōkyō-to

Example  using the "Prefectures" column for the prefectures and the measure "Estimated Male Population" to create a map in SAP Lumira.

Using the "Prefecture" attribute from the wikipedia table  (red arrow in the screenshot above) this attribute is in romaji and I have moved the mouse over Tōkyō-to and this is shown in the screen shot too.

Next example using the "Japanese" column for the prefectures and keeping the same measure "Estimated Male Population" to create a map in SAP Lumira.

Exactly the same Lumira chart extension but simply swapping to the "Japanese" attribute from the wikipedia data  (red arrow in the screenshot above) this attribute is in Kanji and I have moved the mouse over 東京都 and this is shown in the screen shot too.

Licensed under the creative commons

Creative Commons License

This work is licensed under a Creative Commons Attribution-ShareAlike 3.0 Unported License.

Sunday, February 16, 2014

A map of old ABAP developers

An example SVG map from my SCN blog.

SCN does not support the interactive nature of SVG.

The map was created with SQL Anywhere and the details can be found in the following blog.

Choropleth maps of @SCNblogs links and crime data using SQL Anywhere
The blog details how this map of bitly clicks was created for the top @SCNblog tweet for January 2014.
"A map of old ABAP developers"   

Google +