Skip to content

That Time of Year Again

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…

No comment yet, add your voice below!

Add a Comment

Your email address will not be published. Required fields are marked *