cancel
Showing results for 
Search instead for 
Did you mean: 

Missing Metadata - TRIM 6.2.5

SOLVED
Go to solution
Highlighted
Joanna Thompson
Regular Collector

Missing Metadata - TRIM 6.2.5

Hi there, you would think that this would be an easy thing for me to figure out but I can't. We have been having serious security issues with our recently updated version of TRIM. One of the manifestations of these issues is that occasionally when a document is created and added into a folder, it doesn't have the security applied (we take our security defaults from the container). This has been reported to HP but we don't have a fix yet. However, lately we've come across a similar problem, where not only is the security from the folder missing, but the metadata regarding the owner locations, home location, assignee and creator are all missing as well. I can fix the owner, home and assignee, but I can't figure out how to add the creator information after the fact. I have looked at the Provenance field in the Additional Fields, but amending that doesn't seem to have any affect on the Creator field, which makes sense to me. Is there an easy way to add the Creator metadata after a document/folder has been created??!

 

Thanks,

Joanna Thompson,

Records Management Specialist, Information Access Operations

Shared Services BC, Ministry of Labour, Citizens' Services and Open Government

Province of British Columbia

Joanna Thompson
Senior Records Management Application Analyst
Government Records Service, Corporate Information and Records Management Operations
Ministry of Finance, Government of British Columbia
3 REPLIES
Chris Mcklaren
Frequent Visitor
Solution

Re: Missing Metadata - TRIM 6.2.5

Hi Joanna,

 

The only way to fix the "Creator" record data is to import the data using the TRIM SDK or via a SQL script.  This means you will need help from a programmer or DBA.  However since you are having other metadata issues I would recommend that any attempt to fix this data be delayed until after you have resolved the other TRIM errors.

 

I have modified record creator information using Visual Basic for Applications (VBA) with MS Excel.

Step 1 is to export selected data (including uri) of the affected records into a spread sheet.

Step 2 is to update the Creator Field in the Excel spreadsheet

Step 3 is to update the record data (Creator Field) back into TRIM

 

HP released a new build (1343) of HP TRIM 6R2 SP5 last week.

 

Attached is the TRIMSPER.pdf for the latest TRIM release (1343).  Check it out to see if your errors have been identified and fixed.

 

Cheers,

Chris

Cheers,
Chris Mcklaren
TRIMGuru
Honored Contributor

Re: Missing Metadata - TRIM 6.2.5

Just throwing this out there - I assume that both the client(s) as well as the workgroup server were updated ?

 

Joanna Thompson
Regular Collector

Re: Missing Metadata - TRIM 6.2.5

Thank you for the advice and the document. I have looked at the document and for our build (1329) none of the issues we have encountered are listed. However, I found a similar issue in the patch for a later build. Not sure what that means. I will see what I can do about the creator metadata issue - our Enterprise Wide Application Services will no doubt be able to help me there.

Joanna Thompson
Senior Records Management Application Analyst
Government Records Service, Corporate Information and Records Management Operations
Ministry of Finance, Government of British Columbia
//Add this to "OnDomLoad" event