Показать сообщение отдельно
Старый 12.04.2007, 13:00   #1  
Blog bot is offline
Blog bot
Участник
 
25,477 / 846 (79) +++++++
Регистрация: 28.10.2006
Arijit Basu: Excel Import | Custom
Источник: 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
__________________
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору.