Hyperlink Address Magic

[mcuba]

I have a CM tool where I can pull a comma separated file down and I made an
import map to merge this data with our current view. Effectively, I need to
track trouble reports, assign them to team members, and provide a hyperlink
to the trouble report text.

I get from my CSV file an identifier such as REV_TR_001 and I have available
a file that would be named REV_TR_001.txt which is a text file description of
that trouble report. I import the REV_TR_001 as the 'Name' identifier via
the import map.

I would like to know if anyone has ideas as to how I could construct the
hyperlink address from the Name field automatically so that the team, which
views the project file via an HTML file, could simply click on the hyperlink
to get at the trouble report.

Would I need to create a Macro to run to walk through each row and build the
hyperlink address? Is there an easier way?

Thanks in advance for your help!

Mattt

 

[JulieS]

Hi Matt,

Instead of importing the hyperlink address into the [Name] field in project
you could import the data into the [Hyperlink Address Field] in Project. The
hyperlink address field exports beautifully with a slight modification to the
HTML export map to add the field.

Hope this helps. Let us know how you get along.

Julie