Import / Export in the Builders
The XML export and import in SmartList Builder has existed since at least GP8 but there were lots of pieces that didn’t export (and so were missing in the imported version). In a discussion with MS support they confirm that there are various documented issues in older GP versions. In addition, Outlook didn’t like to email the XML files. So, I just got into the habit of building SmartLists on the client’s server.
Since it has been over 5 years, I figured it was time to look at the Import & Export features again. (Especially since Outlook will now email XML files without issue.)
Testing on GP 10 SP 4+ (10.00.1411), I created a SmartList with all of the various features including items that didn’t work in earlier versions (field formatting, negative values, Go To’s etc.). I exported, deleted the original and imported the XML file.
I was pleasantly surprised. I found that everything came thru EXCEPT Advanced Go To’s – which are easy to re-add after importing. (Let me know if you are aware of any other issues!) I will certainly be using the Import/Export in the future.
One note – make sure you are NOT importing into a GP install that has the same List ID (for that type) it will try to overwrite the existing List without warning. (And I have found that this overwriting has unpredictable results). My trick is to save only one List in each file and name the file the List ID.
Here is how to export:
Microsoft Dynamics GP >> Tools >> SmartList Builder >> Export
Microsoft Dynamics GP >> Tools >> SmartList Builder >> Import
Be patient, it will take a little time to import your List (generally about 1 minute each or more). You will not be able to use GP until it is done importing. (If you try – GP will show as “Not Responding” and the import screen will stop updating. Don’t panic – it is still importing – just wait.)
PS – Thanks for all the congratulations… my son is doing great.
Leave a Reply Cancel reply
This is a personal site. The opinions here are my own and not necessarily those of Software Solutions Group, Inc.
Use all advice, code, suggestions, recommendations and other information provided on this site at your own risk. No warranty of any kind is provided for the use of this information. Site owner is not responsible for any use or misuse of this information.
This site is not affiliated with Microsoft. Microsoft, Dynamics GP, the Microsoft Dynamics Logo, Great Plains, Excel, SQL Server and FRx are registered trademarks of Microsoft Corporation.