In preperation for migrating from Newforma Project Center version 5 to version 6 I needed to fix a problem. My users map a network drive to a Windows share. The drive mapping P:\ = \\Davis1\Projects is simple enough but introduces an interesting issue. The users can create files that exceed the path length limitations of Windows. Newforma’s index service uses the UNC mapping and fails to find some of the files.
I decided a tool to truncate the files would be in order and here it is, The NPC Path Length Repair Tool.
Click the Open Project Summaries button and locate your Newforma ProjectSummaryModel.xml file. I like to make a copy rather than open the master file – at a minimum make a backup of the file first.
The tool will read the project models and the project folders from the XML file. These should match but the tool will tell you if it doesn’t.
It takes a long time to run through the ProjectSummaryModel.xml file so once it has opened it and created the work list you can re-open the Previous Run.
This version only fixes the email file names. It does report on other problems that it encounters so the first time through I recommend using the Pause On Errors option so you can see what it complains about.
The tool will show you the UNC Paths that it finds for both the project folders and for project email.
When you select the option to Shorten Email Filename it does by removing part of the subject that is saved in the path. It keeps the tags that Newforma places on the email that might associate it with an RFI.
The problem is with emails that are RFI’s – for example an email named:
\\davis1\projects\2009\09702.00.000 - kaiser wheat ridge - infill shell space\correspondence - notes\newforma\email\2009-05\2009-05-15-1847-02-FK5E Paul.Brown@d Project- Kaiser Wheatridge - Infill Shell Space - RFI Assignment - Plumbing Walls - RFI-003-9GU.msg:
The tool as I envisioned would just truncate the filename – So the file above would become:
\\davis1\projects\2009\09702.00.000 - kaiser wheat ridge - infill shell space\correspondence - notes\newforma\email\2009-05\2009-05-15-1847-02-FK5E Paul.Brown@d Project- Kaiser Wheatridge - Infill Shell Space - RFI Assignment - Plumbing Walls - RFI-00.msg:
The Tag that Newforma placed on the file “ – RFI-003-9GU” would get cut off.
So, instead the tool looks up the RFI’s from the NPM files and appends the RFI tag back onto the truncated message effectivley reducing the subject information.
In a future release I may have it walk the NPM files and have it check and fix RFI’s and submittals that have related email. For now It is enough to fix Newforma’s broken path with the email.