Tip: How to export/import from SysLastValue table

Recently, I was troubleshooting an issue related to user settings. i.e. There was a requirement to migrate the user settings from one environment to another.

As we all know, User related setups for queries, forms, reports etc are stored in SysLastValue table. This is a system table and can't be accessed directly through AOT.

Solution:

NOTE: PLEASE BACK UP YOUR SYSLASTVALUE TABLE BEFORE YOU ATTEMPT THE BELOW STEPS AND TRY TO VALIDATE THE STEPS FIRST IN A TEST/SANDBOX ENVIRONMENT

1. Created a definition Group for SysLastValue table

2. Filter only for SysLastValue table

3. Set up the filter criteria For export in our case we have to do for one user

4. Note that at this point when we do the export, the .dat and .def file which is generated won't be having any data in it. This is becoz by default the System tables are not included in the Standard Export/Import Wizard of AX.

We need to do a small code change inorder to achieve this, Go to AOT > Classes > SysDataExpImp

5. Modify the candoTable method inorder to comment out the code which does the system table check for SysLastValue as shown below

6. Now, once again do the export and there you go..

Initially, I tried to do the SQL way, but figured out that it doesn't work and moreover SQL is not the correct way as we can miss out on Recids.

New website on Dynamics AX

http://www.msdynamicswire.com/?page=dynamicsAX

Microsoft Dynamics AX acquires IP for 4 industry solutions

http://www.microsoft.com/presspass/press/2009/sep09/09-22ERPIndustryPR.mspx

http://blog.softwareinsider.org/2009/09/22/news-analysis-microsoft-dynamics-ax-acquires-ip-for-three-industry-solutions/

Microsoft Dynamics XRM Application Challenge

http://www.microsoft.com/india/xrm/

Microsoft Dynamics Salary Survey 2009

Nigel Frank International would like to invite you to complete what is to be our annual survey of Microsoft Dynamics salaries worldwide.




The survey will only take a couple of minutes to complete and your response and any personal details will be kept strictly confidential. The survey is available in the following languages for your convenience; English, German, French, Dutch, Danish, Spanish, Italian, Norwegian, and Finnish.



As a thank-you for your contribution we will send you a PDF report of the results once they have been compiled. This will give you an insight into the salaries, opinions and demographics of your Microsoft Dynamics counterparts worldwide.



Please find a link to the Microsoft Dynamics Salary Survey 2009 below:
 
http://www.surveymonkey.com/s.aspx?sm=vVj2OAQjLAzjNPH6f4LopQ_3d_3d
 
Your response will be greatly appreciated and will help to give everyone in the Microsoft Dynamics community a greater understanding of their profession