Converting MSP RTF fields in SQL

[Gareth Thackeray]

Hi,

The RTF notes associated with MSP objects are stored in a SQL Server
database in a field called (eg.) TASK_RTF_NOTES (data type image). We would
like to convert this within a standard SQL statement into plain text.

I suspect this is not possible without some sort of bolt-on, or at the very
least using T-SQL in some way.

Any ideas?

Thanks,

Gareth

 

[JackD]

The file called projdb.htm on your project cd or on a machine with Project
installed covers this and gives an example. It is essential reading if you
are going to work with the database.

-Jack

 

[Gareth Thackeray]

Thanks for that Jack. I'm familiar with that file. It describes a mechanism
to convert from RTF, but not at the SQL Server level.

Gareth

 

[JackD]

Ah, you want to do it completely within SQL Server? That would make it more
difficult.
I think I'd try putting together something that reads the data and writes it
into a text field that you can add to the database.
Then put that app on a schedule.

-Jack

 

[Gareth Thackeray]

If we go with this, I think that'll have to be the way it goes.

Thanks a lot.