Querying task notes in Excel

[Walter]

I am using VBA in Excel to read data from the project server 2003 database.
The taskname field is truncated at 255 characters no matter what I try. Any
suggestions?

Walter

 

[John]

I am using VBA in Excel to read data from the project server 2003 database.
The taskname field is truncated at 255 characters no matter what I try. Any
suggestions?

Walter

Wlater,
That's probably because the Task Name field is limited to 255 characters
as is every other text field in Project, except for the Notes field. I
suggest you shorten the name or break it into multiple tasks.

John
Project MVP

 

[Walter]

John - thanks for your reply. I made a mistake in my post. I am actually
pulling the Tasknotes field. In Project, there are more than 255 characters
of text. I suspect something is truncating the data to 255 either in the
ODBC connector or something else. When I look at the data in the debugger
it is truncated prior to placing it in a variable. So, it's already
truncated in the recordset or the debugger truncates it when displaying it.
Not sure which.

Walter

 

[John]

John - thanks for your reply. I made a mistake in my post. I am actually
pulling the Tasknotes field. In Project, there are more than 255 characters
of text. I suspect something is truncating the data to 255 either in the
ODBC connector or something else. When I look at the data in the debugger
it is truncated prior to placing it in a variable. So, it's already
truncated in the recordset or the debugger truncates it when displaying it.
Not sure which.

Walter

Walter,
I haven't tried reading the Notes field using an ODBC connection, so I'm
not sure what to tell you. I can tell you that indeed the full Notes
field text string is stored in Project's database and can be extracted
using VBA - years ago I wrote a macro to do just that. However Excel
does have a couple of limitations of its own when dealing with long text
strings. First, Excel will not wrap text beyond 1024 characters (give or
take a few characters depending on how many line feeds are present).
Excel also has a row height limitation of 409 points.

With regard to viewing long strings in the debugger. Yes it will
truncate the string at 255 characters or the first line feed, whichever
occurs first. But the debugger isn't the problem - it just displays
information.

John
Project MVP

 

[Walter]

I don't think it's related to a line feed although that is good to know.
The truncation always occurs at 255 characters.

It's driving me crazy! I have these reports 99% automated but I have to cut
and paste these notes on 10% of the projects! Uggghh!

Walter