Purpose: The purpose of this document is to illustrate how to work with Tracking Dimensions in Dynamics AX 2012 Excel Add-in. Challenge: Data model changes in Dynamics AX related to high normalization and introduction of surrogate keys made import of data more complex. Additionally there are number of differences between Excel and AX Rich Client…
Tag: Dataimport
Microsoft Dynamics Ax
Dynamics AX 2012 Excel Add-in – Vendor transactions import
by Bo Jensen •
Purpose: The purpose of this document is to illustrate how to use Microsoft Dynamics AX 2012 Excel Add-in for import of vendor transactions with required level of detail. Challenge: Data model changes in Microsoft Dynamics related to high normalization and introduction of surrogate keys made some imports more complex. In fact the data model forming…
Microsoft Dynamics Ax
Dynamics AX 2012 Data Import using Excel Add-in: Dynamics AX 2012 Excel Add-in – Customer transactions import
by Bo Jensen •
Purpose: The purpose of this document is to illustrate how to use Microsoft Dynamics AX 2012 Excel Add-in for import of customer transactions with required level of detail. Challenge: Data model changes in Microsoft Dynamics related to high normalization and introduction of surrogate keys made some imports more complex. In fact the data model…
Microsoft Dynamics Ax
Dynamics AX 2012 Data Import using Excel Add-in: Dynamics AX 2012 Excel Add-in – Storage Dimensions
by Bo Jensen •
Purpose: The purpose of this document is to illustrate how to work with Storage Dimensions in Dynamics AX 2012 Excel Add-in. Challenge: Data model changes in Dynamics AX related to high normalization and introduction of surrogate keys made import of data more complex. Additionally there are number of differences between Excel and AX Rich…
Microsoft Dynamics Ax
Import duplicate company data to use for testing [AX 2012]
by Bo Jensen •
I found this article on Microsoft Technet which describes how to setup the data-import correct when importing duplicate company data within the same application. Import duplicate company data to use for testing [AX 2012]
Microsoft Dynamics Ax
X++ CODE TO READ MS OFFICE WORD DOCUMENT
by Bo Jensen •
Use the below job if you want to read text from MS Word document in Dynamics Ax 2009.
Microsoft Dynamics Ax
X++ code to Read/Write Dynamics Ax data to excel
by Bo Jensen •
Here are some bits of X++ code to read and write AX data from Excel
Microsoft Dynamics Ax
Dynamics AX: Read All Files inside a directory
by Bo Jensen •
void FindAllCSV() { #Evat_NL #File Filename baseFolder; Filename csvFilename; Filename foundBaseFileName; Filename foundFileName; container mainFolder, subFolder, fileContainer; boolean filesFoundMainFolder = true; boolean filesFoundSubFolder = true; int apiResult; int setCurrentFolder (Filename _filename = ”) { ; return WinAPI::setCurrentDirectory(_filename); } ; baseFolder = “C:TEST”; apiResult = setCurrentFolder(SysTreeNode::duplicatePathDelimiters(baseFolder)); mainFolder = WinAPI::findFirstFile(“*.*”); foundBaseFileName = conpeek(mainFolder, 2); while (filesFoundMainFolder) {…
Microsoft Dynamics Ax
How to import multiple file from a folder? – Microsoft Dynamics AX
by Bo Jensen •
container createListOfFiles(FilePath _path = path, FileNameType _pattern = pattern) { System.Array files; int fileCount; int i; str nextFile; new InteropPermission(InteropKind::ClrInterop).assert(); info(strfmt(‘Search in: %1 %2’, _path, _pattern)); listOfFiles = connull(); actIx = 0; files = System.IO.Directory::GetFiles(_path, _pattern); if (files) { fileCount = files.get_Length(); info(strFmt(‘Number of…
DotNET, Webdevelopment
Importing CSV Data and saving it in database – CodeProject
by Bo Jensen •
Importing CSV Data and saving it in database – CodeProject
DotNET, Webdevelopment
A Simplified SQL-CSV Import/Export Functionality – CodeProject
by Bo Jensen •
A Simplified SQL-CSV Import/Export Functionality – CodeProject