OnDemand User Group

Off Topic => General => Topic started by: ODSA on July 25, 2016, 03:26:08 PM

Title: Add notes/annotation to multiple document list result of one load
Post by: ODSA on July 25, 2016, 03:26:08 PM

Hi All,
I am on OnDemand Content Management version 9.0.0.3, I have a requirement to add Note/Annotation to ~800 documents that were loaded as part of one incorrect load. Is it possible to add notes for all 800 document in bulk instead of adding the notes manually one at a time which will be a time consuming process?.  Please advise.

Thanks,
ODSA

Title: Re: Add notes/annotation to multiple document list result of one load
Post by: Joe Wolken on July 25, 2016, 05:45:14 PM

If the goal to to mark these 800 documents as 'Bad', as an alternative to adding a note/annotation have you considered changing one or more of the index values to a value that will never be normally searched by the users. For example, a date that is far in the past?

Title: Re: Add notes/annotation to multiple document list result of one load
Post by: ODSA on July 26, 2016, 01:16:25 PM

Hi Joe,
Can that be done in Bulk? I mean can we modify the index value of all the impacted documents at one time?

Thanks,
ODSA

Title: Re: Add notes/annotation to multiple document list result of one load
Post by: Justin Derrick on July 27, 2016, 08:27:38 PM

Yup, you can use the Doc_Name field (which you can obtain from the load ID for the bad load) as your SQL criteria.  The wiki has some information about the format of the Doc_Name field:

https://cmod.wiki/index.php/DOC_NAME

-JD.

Title: Re: Add notes/annotation to multiple document list result of one load
Post by: ODSA on August 30, 2016, 09:30:34 PM

Hi Justin,

I guess the problem here is that not all the documents of a load is corrupted, there are few in a load that are good and there are multiple such semi corrupted load.

Regards,
Shivani

Title: Re: Add notes/annotation to multiple document list result of one load
Post by: Justin Derrick on August 31, 2016, 06:24:32 AM

It appears you have a data quality issue that's outside the scope of what CMOD can deal with...  Garbage in, Garbage out!  :)

You'll have to modify or delete these rows manually to fix this issue.

-JD.

Title: Re: Add notes/annotation to multiple document list result of one load
Post by: ewirtz on August 31, 2016, 10:50:15 PM

Hi ODSA,
the combination DOC_NAME and DOC_OFF is unique.
17FAAA                 0
17FAAA              4024
.
.

If you can generate a list of DOC_NAME, DOC_OFF from one ore iterative  SQLs than you can write a script to add the annotations.

Regards

Egon

Title: Re: Add notes/annotation to multiple document list result of one load
Post by: Justin Derrick on September 01, 2016, 05:50:08 AM

Ed's right -- but unless the metadata for the bad records has something in common, you've got to find these documents, and then get their Object & Offset, then put them into another SQL to do the update -- a painful process.

-JD.