Export Elements Tools V1.06

This Class is made to Export all or most recent changes to element in Dynamics AX.

The Class runs through UtilElements and selects records based on Current User, modifiedDateTime and createdDateTime and then exports the changed elements to a folder.

The file name of the exported elements are based on Element type, Element name, version and export version. (Version is taken from UtilElements, and export version is an internal variable that is incremented with each export.)

When running the class you are prompted for Directory (Where to put the exported file) and Processing Date (Used to query against modifiedDateTime and createdDateTime)

The Class saves some data in SysLastValue

----------- SETUP -----------
In classDeclaration there is a macro #AXVER that has to be set to the right version of AX, to make the class work.

---------- DOWNLOAD ----------
You can download the latest version of the Class here, works on AX4, AX2009 and AX2012
Download Link

---------- CHANGELOG ----------
1.00    2015-01-01 : First version.
1.01    2016-02-17 : Added method to export Projects
1.02    2016-02-17 : Implemented export of projects.
                             Always run in DAT Company.
1.03    2016-02-18 : Default value for export path. (Needs more thought)
                              Some minor changes in Search for new elements.
                              Reorder methods.
1.04    2016-02-18 : Added doc method for documentation. (This)
1.05    2016-02-22 : Rewrite how changed elements are found.
                              In method findNewOrChangedElements, UtilElement is searched for new
                              or changed elements, and they are then created as lines in table tmpUtil.
                              This was done to move the search to a method.
1.06    2016-02-22 : Changed the code so it can run on most versions of AX (4,5 and 6)

---------- IDEAS / ERRORS ----------
Prompt for witch user to export for, with blank = all, and default = current user.

Default value for export path, needs rethinking.

Save values from SysLastValue into a file, so they can be reused.

Look into making a form that shows what records to export.

When export is done, move files to another location, (Network drive or perhaps ftp server)
Possible also with an option to compress files before sending them.

Kommentarer

Send en kommentar

Populære opslag fra denne blog

Dynamics AX use of the startupcmd parameter

If you start ax32.exe with -startupcmd you can use this to automate some tasks. Like for instance this command will perform a full compile of all elements in AX. ax32.exe -startupcmd=CompileAll Here is a full list of all the startupcmd parameters in AX2009 and AX2012. The code that controls this can be found in Class SysStartupCmd method construct. You can also add your own commands by adding them to this method. Command AX2009 Command AX2012 Usage setbuildno setbuildno Updates the version information text in the About Microsoft Dynamics AX dialog  updatebuildno updatebuildno Synchronize the Build Number Between the Application and Database  synchronize synchronize Synchronizes the data dictionary  compileall compileall Compiles the application  compilepartial Compiles the application and updates Crossreference 
Læs mere

Axapta Manager (AxDynManagerV1.03)

Billede
I previously made a program to list, start and stop Dynamics AX Services. But i always through that is missed a few features, so now I am starting on this new version. ( Download link )  This is version 1.03 see change list at the end of the post. In this version the big thing i added was that you can now start/stop and restart more that one service in one go. The program is tested for AX 2009 and AX 2012. When you start the program this is what you will see: On the left you will see the list of services that you have, and on the right the list of possible AX configurations. Config menu. Under the menu item, Tools/Config, you can change the programs settings. Here you can add/remove computers to look for services on. To remove a computer from the list, double click on the item. To add a computer, input its name in the text box, and press the "Add" button, or enter. The refresh field controls how often the service list will be refres
Læs mere

Axapta Manager (AxDynManagerV1.02)

Billede
I previously made a program to list, start and stop Dynamics AX Services. But i always thought that is missed a few features, so now I am starting on this new version. ( Download link )  This is version 1.02 see change list at the end of the post. This version will still handle list, start and stop of services, but also restart of services, and i t will also support multiple servers. And as something new i have added the possibility to start your Dynamics AX from the program, supporting multiple configurations. The program is tested for AX 2009 and AX 2012. When you start the program this is what you will see: On the left you will see the list of services that you have, and on the right the list of possible AX configurations. Config menu. Under the menu item, Tools/Config, you can change the programs settings. Here you can add/remove computers to look for services on. To remove a computer from the list, double click on the item. To add a co
Læs mere