Skip to content

Each year I have to upload Projects / Tasks / Budgets into Dynamics SL. Every year it seems I get caught up in some formatting problems using the transaction import functionality of the Dynamics SL product. Do you think they’ll ever get a more sophisticated tool? The time required to analyze and format the .csv files is just brutal. Especially, again, this time of year; when we should all be taking a little more time off to relax with the family.

Anyway, just remember while you’re trimming the tree, I’m here using the finer points of the RTRIM T-SQL to remove trailing blanks, and then exporting queries to NotePad and opening the .txt files from Excel and running the text formatting wizard, and ensuring all the naughty numeric fields with leading zeroes are formatted as text…

Ah the joys…

Related Posts

Drop us a note

Please drop us a note via the form below with your comments or questions on this blog post; or if there is anything we can help you with.