Author Topic: Add notes/annotation to multiple document list result of one load  (Read 3410 times)

ODSA

  • Jr. Member
  • **
  • Posts: 13
    • View Profile
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

Joe Wolken

  • Full Member
  • ***
  • Posts: 110
  • CMOD iSeries Consultant
    • View Profile
    • OAS Corp.
Re: Add notes/annotation to multiple document list result of one load
« Reply #1 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?
Installation, Upgrade, Migration, Administration, Integration, Customization, Training, and more!

Call: 512-402-1123
email: wolkenj@oascorp.com 
Click: http://www.OASCorp.com

ODSA

  • Jr. Member
  • **
  • Posts: 13
    • View Profile
Re: Add notes/annotation to multiple document list result of one load
« Reply #2 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

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2145
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: Add notes/annotation to multiple document list result of one load
« Reply #3 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.
« Last Edit: December 14, 2017, 10:52:40 AM by Justin Derrick »
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR

ODSA

  • Jr. Member
  • **
  • Posts: 13
    • View Profile
Re: Add notes/annotation to multiple document list result of one load
« Reply #4 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

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2145
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: Add notes/annotation to multiple document list result of one load
« Reply #5 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.
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR

ewirtz

  • Full Member
  • ***
  • Posts: 134
    • View Profile
Re: Add notes/annotation to multiple document list result of one load
« Reply #6 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

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2145
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: Add notes/annotation to multiple document list result of one load
« Reply #7 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.
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR