“Pakistani bunch of professional’s explored easy data import software for Microsoft Dynamics AX 2009
Yes, now importing data in Microsoft Dynamics AX 2009 is not a gigantic deal. DataLoader, software in use for Data Entry in Oracle is also applicable to enter data in Microsoft dynamics AX 2009. It works just like macro; people who are familiar with the use of Macros in Microsoft Dynamics GP will find it fairly easy to use.”
Kind Regards,
Hammad Rauf
DataLoad V4 - Classic & Professional
"If you have hundreds of records, then DataLoad Classic is a good way of loading the records that you need; if you have thousands of records then DataLoad Professional is the tool to use. Good thing is that this tool is made by oracle and Flexibiulity of AX being windows platform is such that this tool works on it as well.
And it’s FREE Implementing or supporting any application requires significant effort to configure and load master and transaction data, for example from legacy systems, an expensive and time-consuming activity.
DataLoad reduces the time and costs associated with data migration. Its easy-to-use interface means that it can be used by non-technical employees, giving end-users an active role in the implementation and support of any system. With 8,000 downloads a month and customers in over 30 countries, DataLoad is the world's most popular data entry tool for end users, consultants and developers.
Why Use DataLoad?
· Non-technical users can easily configure and load data into any system
· Recommended by Oracle, DataLoad contains specific additional features to load large volumes of data in Oracle E-Business Suite
· DataLoad is sponsored by leading UK systems integrator Edenbrook, which has committed to support and improve the tool
· DataLoad is available in Classic and Professional editions, catering to all types of application implementation from the simple to the vastly complex
· DataLoad Classic is available to download free of charge and is not a time limited trial version
· DataLoad has a proven track record with over 10 years of production use and is still actively developed to meet today's needs
DataLoad Functionality
A summary of DataLoad functionality is provided below,
DataLoad provides a spreadsheet style interface and the data contained within that spreadsheet can be loaded into any system using a Macro load, or into Oracle Applications using Forms Playback. Either way, data or setup is loaded through the application's forms and that provides many advantages. Users have a choice between the free DataLoad Classic or more feature rich DataLoad Professional,
Macro Loads
All versions of DataLoad provide the Macro load functionality and this is the load technology of choice in DataLoad Classic, the freeware version.
The easiest way to load data into a form is using a keyboard and mouse and this is what DataLoad does with Macro loads. You configure the data, keystrokes and mouse clicks in DataLoad that you want loaded into your form(s). When you run the load DataLoad presses the keys and clicks the mouse as you specified. Any keys on your keyboard can be used by DataLoad, in any combination, and the left and right mouse buttons can also be used. And because DataLoad calls the same low-level Windows code that is called when you actually press a key or use your mouse, the application you are loading data into cannot tell the difference between data entered by you at the keyboard or DataLoad.
To build a DataLoad load write down what keys and mouse clicks you use to enter one record in your application. Now enter that into a DataLoad row and copy the instructions down into as many rows as the number of records you are going to load. Finally, paste your data into cells in DataLoad that correspond to the fields in your form. Your load is now built!
To load data as quickly as possible DataLoad uses Windows copy & paste to copy data into form fields. Where the actual keystrokes should be sent instead the data just needs to be preceded with a backslash, '\'. To send mouse clicks use the *ML or *MR commands to send left or right mouse click respectively. Please read the User Guide for more information about keystrokes, DataLoad commands and mouse clicks.
Controlling the Load
DataLoad can send data, key strokes and mouse clicks far faster than applications can handle them. To slow down DataLoad there is a comprehensive set of Delay options, using both the Delays form and the *SL (Sleep) command which cause DataLoad to wait at key points.
For the fastest, most reliable copy & paste loads use the Load Control functionality in DataLoad Professional. Load Control enables DataLoad to monitor a log file written by the application you are loading data into. Having configured DataLoad to use the log file your load will not run faster than the application is processing the data. No delays are required and DataLoad will run as fast as possible without overloading the target application. Another great benefit of Load Control is that if an error occurs in the application DataLoad will stop sending data. Therefore loads can be run unsupervised.
To download visit http://www.dataload.net
PUBLISHED: October 29, 2008
The (Surprising) Power of Table Import in Dynamics GP: Mariano Gomez, the Dynamics GP Blogster, provides a very applicable and detailed overview of how to fully leverage the Table Import function in Dynamics GP for more efficient streamlined integration. He walks users through an example that imports several customer records, with step-by-step instructions, screenshots, and a host of useful resources. While cautioning users to be aware of its parameters, Gomez writes:
"[Table Import] is considered by many at the bottom of the food chain when it comes to integration tools, the fact is, it still holds its weight in today's XML-plagued world... Table Import can be an effective way for the end-user with some tech savvyness to get some data quickly into GP. Don't let the overwhelming amount of tools out there shy you away from using it, especially when these tools are not able to address parts of the application you are interested in integrating data into."
Windows Azure and Dynamics CRM: A Future of Stronger Collaboration: Menno te Koppele, a CRM Freak, envisions a more complete business experience with Dynamics CRM and the Azure platform: "In the future, developers will have access to SharePoint & CRM functionality for collaboration and building stronger customer relationships. With the flexibility to use familiar developer tools like Visual Studio, developers will be able to rapidly build applications that utilize SharePoint and CRM capabilities as developer services for their own applications."
"The Azure Services Platform is an internet-scale cloud computing and services platform hosted in Microsoft data centers. The Azure Services Platform provides a range of functionality to build applications that span from consumer web to enterprise scenarios and includes a cloud operating system and a set of developer services. Windows Azure is not an operating system but rather a complete cloud-based hosting management service built on Windows 2008."
Helpful Tips-n-Tricks to Fix "Errors" in Dynamics AX 2009: Solutions Monkey offers a 3rd installment of its Dynamics AX 2009 Enterprise Portal / Role Centers - Deployment Tips-n-Tricks. Each tip tackles a real problem scenario encountered when using AX 2009, and explains potential solutions. Here's tip #17:
"Microsoft Dynamics AX 2009 RTM Enterprise Portal Site creation fails or the default page comes with unexpected error in the UI and with "A Progress Template must be specified on UpdateProgress control with ID 'AXProgressControl'" error in the event log. How to fix this?
.NET 3.5SP1 has a breaking change from .NET 3.5. So if you have installed .NET 3.5 SP1 instead of just .NET 3.5, EP will give "A Progress Template must be specified on UpdateProgress control with ID 'AXProgressControl'" error. There is a hotfix available for Ax 2009 RTM. This is also fixed in the upcoming Ax 2009 SP1. So either uninstall .NET3.5SP1 and install .NET3.5 or get the hotfix from Ax support or get Ax 2009 SP1. Either one of these three approaches will fix this issue."
On November 10th, 2008 dsforeman said:
Excellent article.
Dave Foreman
http://www.interactivelimited.com
Posts
All Comments
