Saturday, 27 October 2007
Now I have a Vista machine and I am used to most things not working and I did not expect NoteBurner to fair any better. Well here is the shocker. It installed and it works perfectly. Well done guys! What a great piece of software.
If you want to check this out for yourself, you can go to http://www.noteburner.com/glc/
Sunday, 14 October 2007
I did a quick search on Google and found little. Then I thought, what about Excel? Maybe I could use Excel to somehow show the file in the format I wanted. Well It was remarkably easy.
I created two worksheets. My first sheet simply contained one cell which contained the full text of the record in my file. Each row contained one record.
In my second sheet, I created a series of column headings and then used the MID function to take a single character from my first sheet based upon the column I was in. The formula looked like this:
I then copied this function to all of my cells. I also put in some row headings and some conditional formatting to change the colour of the background if the length of the field was 0 (i.e. no character.)
After generating my text file, I would open it in notepad, select all (Ctrl+A) and copy it, then paste into the Text File worksheet of excel and check the data in the columns against my specification.
It did the job quite nicely.
Friday, 12 October 2007
Why? My guess is they just couldn't finish it in time and so, rather than delay it again, they killed it. Now before I start ranting, I have to admit this decision has positive aspects. Releasing an unstable 5.1 product would have shown a lack of vision surpassed only by Wayne Barnes' recent performance in the All Blacks-France World Cup Quarter Final.
The Dynamics NAV 6.0 product (previously known as 5.1, previously known as 5.0) promises to be something special and it is important that it works.
Tuesday, 2 October 2007
Now I knew I had done this before and there was a really smart way of doing it but it took me a while to find it again. The trick is to use the coalesce function. You need to declare a variable to select into and then select from that so this is for use in a table-function or stored procedure.
Try this out in a NAV database when you have more than once company.
DECLARE @CompanyList VARCHAR(1000)
SELECT @CompanyList = COALESCE(@CompanyList + ', ', '') + Name
The URL is http://blogs.msdn.com/nav. Enjoy!