Arijit Basu: Excel Import | Custom

[Blog bot]

Источник: http://daxguy.blogspot.com/2007/04/e...rt-custom.html
==============

I had created a small utility in AX for one of the implementations which gave the user the facility to upload data from custom excel templates. In some cases where internet connectivity is an issue, this template was distributed to the locations where the users entered their daily expenses and emailed the template on a periodic basis to HO. In HO, these excel sheets were uploaded to DAX. The beauty is that before importing the data, it was possible to see the data, see errors and their causes and then import / post a journal in this case. It was really handy.

The Excel template [The data is simulated :)]



The AX Excel import tool (Showing the data before import and highliting the records which have error including an error description :)



You can always improve on this. Imagination is da limit :)
May not be the best way but it works nicely for my situation :)




Источник: http://daxguy.blogspot.com/2007/04/e...rt-custom.html