Bojensen Blogs

Tag: Dataimport

Dynamics AX 2012 Data Import using Excel Add-in: Dynamics AX 2012 Excel Add-in – Customer transactions import

  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…

Dynamics AX 2012 Data Import using Excel Add-in: Dynamics AX 2012 Excel Add-in – Storage Dimensions

  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…

Dynamics AX: Read All Files inside a directory

 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) {…

How to import multiple file from a folder? – Microsoft Dynamics AX

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…