Page 1 of 11612345678910...2025303540...Last »

Friday Funny: Finally…. The correct way to eat Vegemite

David Meego - Click for blog homepageIn recent years when I have come to conferences in the US, I have been bringing a stash of goodies with me.

Usually, this includes Arnott’s Tim Tams and Allen’s Chicos*, which are liked by almost everyone who tries them. And then there is the Aussie Icon, Vegemite.

The reaction I get from most people is one of abject terror, completely horrified when I suggest they try some vegemite. They will tell me how they have seen other Americans try it and that it is horrible, disgusting and compared to vomit.

US TV Hosts try Vegemite for the first time live on-air to celebrate Australia Day (direct link)

 

The problem is that those people who have tried it (including celebrities and TV show hosts) usually have tried it wrong. Usually very wrong. To quote one of my favourite TV comedies:

Wrong, wrong, brimming over with wrongability – Rimmer, Red Dwarf.

The problem is that Vegemite is very (read VERY) concentrated. Imagine an extremely salty beef and vegetable stock boiled down to a thick paste. Would you eat a spoonful neat? You just can’t spread it thick like peanut butter or Nutella and expect it to taste anything but disgusting.

It was first made as a by-product from another Australian favourite, beer. It is a dark brown food paste made from leftover brewers’ yeast extract with various vegetable and spice additives developed by Cyril P. Callister in Melbourne, Victoria, in 1922.

Here is another reaction from a recent episode of Jimmy Fallon’s Tonight show:

Jimmy Fallon and Steve Higgins try Vegemite (direct link)

 

So, finally it takes a famous Australian actor (and X-Man) Hugh Jackman to show Jimmy how to really eat Vegemite:

Hugh Jackman Shows Jimmy How to Really Eat Vegemite (direct link)

 

Hint: The butter (not margarine) should melt into the hot toast and the vegemite should be spread extremely thinly. If you can’t see the surface of the bread, you have it spread too thick and need to scrape some off.

That little 150g (5oz) jar should last a good 5 to 10 years. You can ignore the use by date. It never goes off and does not need refrigeration.

Go find some Vegemite and enjoy.

David

* While Allen’s is a Nestle brand, it seems they are too embarrassed to include Chicos in the product list.

This article was originally posted on http://www.winthropdc.com/blog.

Filed under: Fun, Public Service Announcement Tagged: Friday Funny, Fun

View article:
Friday Funny: Finally…. The correct way to eat Vegemite

May 22, 2015 · WinthropDC · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 17

Using the Support Debugging Tool to create user accessible SQL Scripts – Part 2

David Meego - Click for blog homepageThis is the second article in the series, if you haven’t already, please see the previous article: Using the Support Debugging Tool to create user accessible SQL Scripts – Part 1.

Today’s article adds a simple user interface for the previously created SQL scripts using Dexterity sanScript.

Last article we created a couple of SQL queries and saved them in SQL Execute. We will now re-use those scripts in our code, adding an additional where clause based on input from the user.

This highlights a couple of very cool features of the Support Debugging Tool: The ability to execute previously saved SQL scripts from Dexterity and the ability to execute a previously saved Dexterity script (against any dictionary). Along with the helper functions that allow you to read and write to fields in any window on any form in any dictionary, it makes the Support Debugging Tool a very powerful cross dictionary, cross environment development tool.

Part 2: Create the User Interface

The next step is to use Runtime Execute to create a simple user interface using system dialogs and the SQL scripts saved previously.

  1. Open the Support Debugging Tool main window (Microsoft Dynamics GP >> Tools >> Support Debugging Tool or Ctrl-D).
  2. Open the Runtime Execute window (Options >> Runtime Execute).
  3. Enter the Script ID, Script Name and script for the code to execute.
    local string l_string;
    local text MBS_Text_Field;
    local integer MBS_Status;
    
    if not getstring("Customer ID begins with:", false, l_string) then
    	abort script;
    end if;
    
    call with name "MBS_Script_Load_SQL" in dictionary 5261,
    	"DEMO1", MBS_Text_Field;
    
    if not empty(l_string) then
    	MBS_Text_Field = MBS_Text_Field + "and CUSTNMBR like " + SQL_FormatStrings(l_string+"%");
    end if;
    
    clear MBS_Text_Field;
    MBS_Text_Field = MBS_Text_Field + "select * from table" + char (13);
    call with name "MBS_SQL_Check_Exists" in dictionary 5261,
    	MBS_Text_Field, true Return Data, false Show Names, MBS_Status;
    case MBS_Status
    	in [OKAY]
    		warning MBS_Text_Field;
    	in [MISSING]
    		warning MBS_Text_Field;
    		abort script;
    	else
    		warning MBS_Text_Field;
    		abort script;
    end case;
    
    if ask("Do you want to clear Hold flags?", "Yes", "No", "") <> ASKBUTTON1 then
    	abort script;
    end if;
    
    call with name "MBS_Script_Load_SQL" in dictionary 5261,
    	"DEMO2", MBS_Text_Field;
    
    if not empty(l_string) then
    	MBS_Text_Field = MBS_Text_Field + "and CUSTNMBR like " + SQL_FormatStrings(l_string+"%");
    end if;
    
    clear MBS_Text_Field;
    MBS_Text_Field = MBS_Text_Field + "select * from table" + char (13);
    call with name "MBS_SQL_Check_Exists" in dictionary 5261,
    	MBS_Text_Field, true Return Data, false Show Names, MBS_Status;
    case MBS_Status
    	in [OKAY]
    		warning MBS_Text_Field;
    	in [MISSING]
    		warning MBS_Text_Field;
    	else
    		warning MBS_Text_Field;
    		abort script;
    end case;
    
    warning "Completed.";
    

    RuntimeScript

  4. You can use the Helper Button at the bottom of the window to insert Helper Functions at the current cursor location for loading and executing the SQL script. Variables needed will be automatically added to the top of the script.
    Helper1
    Helper2
  5. Use the Execute Button to test your script and ensure it works as desired.
  6. Click Save.

The script uses the getstring() function to obtain an input from the user. It then loads the display SQL script previously stored and adds an additional expression to the where clause based on the user input. The script then executes the SQL query and displays the returned data.

If data has been displayed then the ask() function is used to display a dialog asking if the user wishes to clear the Hold flags. If the response is Yes, the previously stored update SQL script is loaded, has its where clause adjusted and is executed. Finally, the warning command is used to tell the user the update has been completed.

Notes

  • You can change the dictionary context that the Dexterity sanScript code is executed against. Use Microsoft Dynamics GP unless you specifically need to access resources in another dictionary.
  • You can use Dexterity system dialogs such as getstring(), ask(), getfile(), savefile() error, and warning to provide a user interface.
  • You can also use Helper Functions to read values from any window in any dictionary.
  • Using Helper Functions to load and execute either SQL or Dexterity scripts allows for code re-use.
  • SQL scripts loaded via the Helper Functions can be modified prior to execution via a Helper Function. Note: Remember to delete or comment out the lines added which create a simple query when using the Execute SQL Select Statement Helper Function
  • There are also Helper Functions to Set, Get and Delete Parameters which can be used to pass information between the main script and called Dexterity scripts.
  • Runtime Execute).

Stay tuned for the final part of the puzzle.

David

This article was originally posted on http://www.winthropdc.com/blog.

Filed under: Development, Dexterity, Dynamics, GP, Microsoft, Products, SQL Server, Support Debugging Tool Tagged: Application, Dexterity, SDT, SQL, Support Debugging Tool

More:
Using the Support Debugging Tool to create user accessible SQL Scripts – Part 2

May 13, 2015 · WinthropDC · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 30

Using the Support Debugging Tool to create user accessible SQL Scripts – Part 1

David Meego - Click for blog homepageIt has been a while since I have posted a technical article on the blog. This is because I am spending almost all my time working on bringing some existing and new products to market.

I am still working on the rebranded and improved release of the Support Debugging Tool. There will be a number of improvements in its features and navigation, more on that soon.

For now, I wanted to post a really clever method of using the Support Debugging Tool to provide additional functionality to end users.

At the reIMAGINE 2014 conference in Fargo last November, Mariano Gomez and I demoed a method of creating a user accessible SQL script. The series covered in the next few posts will take you through the steps to create your own scripts on your system.

The Scenario

I will use the same scenario as we demonstrated at the conference. This will help explain the techniques involved so you can create your own examples.

For our example, we will use queries to check for customers that are marked as on Hold and update customers on Hold to remove the Hold flag.

The end result we want is a user accessible menu entry which can be used to display any customers on Hold which meet a user entered “Begins with” value and then have the option to clear the Hold flag.

Note: The series assumes that the Support Debugging Tool is installed using the Recommended Configuration (shared setup file location) and that you have Advanced Mode features enabled and available to you.

Part 1: Create the SQL Queries

The first step is to use SQL Execute to create and save the SQL queries needed to display and update the data.

  1. Open the Support Debugging Tool main window (Microsoft Dynamics GP >> Tools >> Support Debugging Tool or Ctrl-D).
  2. Open the SQL Execute window (Options >> SQL Execute).
  3. Enter the Script ID, Script Name and script for your display query:
    select Customer Number from RM_Customer_MSTR where Hold <> 0

    SQLScript1

  4. Click Save.
  5. Enter the Script ID, Script Name and script for your update query:
    update RM_Customer_MSTR set Hold = 0 where Hold <> 0

    SQLScript2

  6. Click Save.

Notes

  • You can use Dexterity Technical Names in your queries if they are surrounded by braces  and SQL Execute will convert them to physical table and column names before execution for you.
  • If you want more than 20 rows returned for the display query, you can change or remove the limit.
  • If you want the query execute against the System database or a specific company database, you can change the Execute Query context drop down list.
  • If you wish to be able dynamically change the query ensure that you can make your changes by adding code at the beginning or end of the script. This can be achieved by setting a variable at the beginning of the script or by adding where clause to the end.
  • You can use more descriptive Script ID and Script Names for your scripts.

More to come on the next post.

David

This article was originally posted on http://www.winthropdc.com/blog.

Filed under: Dexterity, Dynamics, GP, Microsoft, Products, SQL Server, Support Debugging Tool Tagged: Application, Dexterity, SDT, SQL, Support Debugging Tool

Read More:
Using the Support Debugging Tool to create user accessible SQL Scripts – Part 1

May 11, 2015 · WinthropDC · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 28

#StarWarsDay: Star Wars Day 2015

David Meego - Click for blog homepageWhat did Luke Skywalker say to his friends on midnight of May the third?

“May the Fourth be with you!”

Yes, corny jokes aside, it is 04-May-2015 and the geeks and nerds of the world are uniting for Star Wars Day 2015.

This has become a day to celebrate all things Star Wars related and help hype the new movies coming and sell more Star Wars toys and paraphernalia. I am sure that makes George Lucas (and now Disney) quite happy.

StarWarsDay

Now to help you celebrate the day I wanted to combine a number of really geeky things together to amuse you.

Have you heard for Simon Jansen from New Zealand? Maybe not, but you might have come across his project. Started in July 1997 still ongoing (last updated in January 2015), he has be recreating the original Star Wars (Episode IV: A New Hope) movie using text characters. Using ASCII characters his animation, ASCIIMATION now covers about 80% of the movie. You might ask Why? According to his FAQ, “Well, it seemed like a good idea at the time.“.

Sten Spans, a Dutch Unix engineer, took Simon’s work and made it available from his Telnet server. Some people believed that this was an “Easter Egg” hidden in the command line of Windows, but it isn’t. It can be accessed from any device or operating system that has a Telnet client installed.

Note: You might need to go to Control Panel >> Programs and Features >> Turn Windows Features on and off and select the Telnet Client, then click OK to install Telnet on Windows.

Finally, there is Minecraft. Now owned by Microsoft, Minecraft is a another world wide phenomenon loved by geeks, nerds and children around the world. So, I present the following video for your pleasure:

Starwars ASCII (via Minecraft) (direct link)

 

Just in case you don’t like the silent treatment, here is a version which has had dialogue and music added:

Star Wars Asciimation With Sound (direct link)

 

For more information about Star Wars Day (and fun), check out the following sites:

Enjoy today, but be careful tomorrow as you could get caught up in the “Revenge of the Fifth”.

David

PS: Did you see the surprise in the first video at 13:59?

This article was originally posted on http://www.winthropdc.com/blog.

Filed under: Fun, News Tagged: Fun, News

Link:
#StarWarsDay: Star Wars Day 2015

May 4, 2015 · WinthropDC · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 61

Social Media and Winthrop Development Consultants

David Meego - Click for blog homepageHello to my readers.

This is just a quick reminder of the various ways you can keep up to date with what is happening at Winthrop Development Consultants.

You have many options to connect with Winthrop through a variety of websites and social media platforms.

Please Favourite/Bookmark/Like/Follow/Connect/Subscribe to the following services with the links below:

Social-media-WDCWinthrop Development Consultants Company Website
http://www.winthropdc.com/

Social-media-RSS
Winthrop Development Consultants Blog
http://www.winthropdc.com/blog

Social-media-Facebook
Winthrop Development Consultants on Facebook
http://www.facebook.com/WinthropDC

Social-media-Twitter
Winthrop Development Consultants on Twitter
http://www.twitter.com/WinthropDC

Social-media-LinkedIn
David Musgrave on LinkedIn
http://www.linkedin.com/in/DMusgrave

Social-media-YouTube
Winthrop Development Consultants on YouTube
http://www.youtube.com/WinthropDC1

Social-media-MS
Winthrop Development Consultants Syndicated Blog on Dynamics Community
http://community.dynamics.com/gp/b/winthropdevelopmentconsultantsblog

 

Stay connected

David

This article was originally posted on http://www.winthropdc.com/blog.

Filed under: Public Service Announcement Tagged: General

Read More:
Social Media and Winthrop Development Consultants

April 23, 2015 · WinthropDC · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 40

Update: Positive Thoughts for Leslie Vail

David Meego - Click for blog homepageJust wanted to post a quick update from my friend Leslie Vail after my original post:

I heard from Leslie today that the surgery went well and she is now resting comfortably.

She wanted to thank everyone for their positive thoughts and lovely comments.

Please keep the positive vibes flowing as Leslie continues on the road to recovery.

We need her well and back at the conferences. No-one else can wear the capes like she does.

MarkCape
Mark Rockwell trying to emulate Leslie

JohnCape
John Lowther playing Leslie when he co-presented with her

LeslieJenniferSheila
Leslie, Jennifer (my wife) and Sheila from Convergence 2012

LeslieCape
Leslie and the famous golden GPUG cape at Convergence 2011

Get well soon.

David

This article was originally posted on http://www.winthropdc.com/blog.

Filed under: News Tagged: General, News

More:
Update: Positive Thoughts for Leslie Vail

April 21, 2015 · WinthropDC · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 36

Positive Thoughts for Leslie Vail

David Meego - Click for blog homepageThis is a shout out for my great friend Leslie Vail. Leslie is a Microsoft Most Valuable Professional (MVP) for Microsoft Dynamics GP and has been a stalwart of the Microsoft Dynamics GP community for many years. She also known as the Dynamics Confessor on her Dynamics Confessions Blogspot.

Between you and me, she does not like it when I mention that she worked with Great Plains Accounting before Great Plains Dynamics 1.0 was even released. So don’t mention it to anyone.

Well, Leslie needs our help.

You might remember that when we last saw Leslie at reIMAGINE 2014 last November, that she was walking with a cane (which she decorated in typical Leslie style).

The issue is that Leslie has done so much walking around (wearing one of her capes) when training and at conferences, that her hips are playing up. So they are working on rebuilding her by replacing first one and then the other hip.

Leslie
Leslie showing off her decorated cane at reIMAGINE 2014.

One hip has already been done, but Leslie was not yet ready for all the walking at Convergence 2015, and so could not make it. We really missed you in Atlanta Leslie.

Anyhow, a couple of days ago, she let me know that she has been diagnosed with Kidney Cancer. She is scheduled for surgery on this coming Monday morning (US time). This is her second brush with cancer and Leslie says she will beat this “bump in the road” like she did before.

Leslie also said this information was not newsworthy, but I disagreed. So I requested and received permission to post something as I wanted her to see how much she means to the Dynamics GP community.

Please keep Leslie in your thoughts and send lots of positive energy to her. Also add your comments and well wishes below.

Looking forward to see a healthy (and Bionic) Leslie soon at reIMAGINE 2015 (in Fargo) and/or GPUG Summit 2015 (in Reno).

Love you Leslie.

David

This article was originally posted on http://www.winthropdc.com/blog.

Filed under: News Tagged: General, News

See the original post:
Positive Thoughts for Leslie Vail

April 17, 2015 · WinthropDC · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 42