Mark Polino's Blog, page 259
February 27, 2012
Calculated Fields in Extender and the Builders - Microsoft Dynamics GP Support Blog
Nicole Albertson from the Microsoft Dynamics GP Support and Services blog looks at Calculated Fields in Extender and the Builders
Kinect in the Commercial World (Random thoughts from Errol) - Inside Microsoft Dynamics GP
Over at Inside Microsoft Dynamics GP, Error has some thoughts on Kinect in the Commercial World
I agree that there may be some really cool applications coming for Kinect. We love playing with ours at home.
Weekly Dynamic: SmartConnect and XLSM files Part 1
I'm going to do a couple of Weekly Dynamics on SmartConnect based on some work I did recently.
Let's start with XLSM files. These are Excel files with macros included. It's not unusual to get a CSV or Excel based file from a outside source. This could be a vendor, a customer, a partner (like ADP or bank Purchasing Card files) whatever. Often these files require manipulation prior to integration and a common way to deal with that is with an Excel macro. A macro provides a consistent way to manipulate what should be a consistent file.
When the time comes to integrate these files using SmartConnect there is a problem. SmartConnect doesn't support XLSM file natively. If you pick that you want integrate and Excel file, you can' t pick an XLSM file as the source. Integration Manager actually has this same issue. So what's the answer? Well, there are few options. We'll tackle two this week and one next week.
Option one is simply to save the file in an XLS or XLSX format and integrate it. Saving that way however destroys the macros and creates some additional steps for the user.
Another option is to point your data source to an ODBC connection in SmartConnect. Select an Excel connector and point it to the XSLM file. Because the ODBC connector reads the data out of the file the extension isn't an issue. User can simply save their XLSM file and integrate normally using the SmartConnect interface.
Next week we'll look at another option.
[image error]
February 23, 2012
Book Codes - Management Reporter 2012 Feature Highlight - Dynamics Corporate Performance Management
From Dynamics Corporate Performance Management comes a look at Book Codes in Management Reporter 2012
PreGAME Events for Microsoft Dynamics Partners at Convergence 2012 – March 17 - Microsoft Dynamics Partner Community Blog
For partners, Kevin Machayya covers PreGAME Events for Microsoft Dynamics Partners at Convergence 2012 – March 17
I'll be there.
[image error]
Winner Winner Chicken Dinner!
Other winners this year include Steve Jobs and Seth Godin. I'm sure that Seth is going around saying "Other winners this year include Mark Polino!"
Try one for yourself. Pick up a story, sit back with a cup of coffee and relax with Dynamics GP instead of working with it.
