how to update custom metadata field from another look up table at UCM?

select did ,XCIVILRECORDNUMBER, lookup.CIVILNUMBER,XEMPNAME,name
from DEV_OCS.DOCMETA , EMPLOYEEANDCIVILNUMBERS2 lookup
where lookup.CIVILNUMBER=DOCMETA.XCIVILRECORDNUMBER
and XEMPNAME is null
create table DOCMETA_bckup
as select * from DOCMETA

commit
update DOCMETA dm
set XEMPNAME=(select name from EMPLOYEEANDCIVILNUMBERS2 where CIVILNUMBER=dm.XCIVILRECORDNUMBER)
where XEMPNAME is null

commit

slider with idoc script

<div id=”da-slider” class=”da-slider”>
<!–$loop SearchResults–>

<div class=”da-slide”>
<h2><a class=”<!–$ssClassName–>-result” <!–$ssColorExtra–> <!–$ssMouseExtra–>
href=”<!–$SearchResults.ssUrl–>”><!–$eval(ssRowLink)–></a></h2>
<p> <!–$xComments–> </p>
<a href=”<!–$SearchResults.ssUrl–>” class=”da-link”>إقرأ المزيد</a>
<div class=”da-img”><img src=”<!–$SearchResults.URL–>” width=”592″ height=”230″ alt=”image01″ /></div>
</div>
<!–$endloop–>
<nav class=”da-arrows”>
<span class=”da-arrows-prev”></span>
<span class=”da-arrows-next”></span>
</nav>
</div>

create ODC folder View with folder framework at dev_ocs schema

create view ODC_FOLDER_VIEW as
select “FFOLDERGUID”,”FPARENTGUID”,”FFOLDERNAME”,”FINHIBITPROPAGATION”,”FPROMPTFORMETADATA”,”FISCONTRIBUTION”,”FTARGETGUID”,”FAPPLICATION”,”FOWNER”,”FCREATOR”,”FLASTMODIFIER”,”FCREATEDATE”,”FLASTMODIFIEDDATE”,”FSECURITYGROUP”,”FDOCACCOUNT”,”FCLBRAUSERLIST”,”FCLBRAALIASLIST”,”FCLBRAROLELIST” from
FOLDERFOLDERS where FPARENTGUID=’451979EEE81E7B427F69F8998787BE3F’

 

check with

select * from ODC_FOLDER_VIEW

 

What is the digital asset management?

What is the digital asset management?

06

Oracle WebCenter Content’s digital asset management capability allows organizations to store, find, view, and use digital assets and rich media quickly and easily. Content, collateral, and individual asset items can be made available instantly in the appropriate formats for use on Web sites, in print materials, or in other programs.  Assets can be protected and controlled through rich and configurable access control.  Oracle’s digital asset management solution automates routine tasks, such as the process of creating multiple renditions, allowing you to effectively manage and appropriately use your rich media assets.

Digital asset management features 

 

  •  Workflow, version control, security, archiving, subscriptions, content conversion, collaboration, record disposition, and Web publication assets leveraging core capabilities of Oracle WebCenter Content
  •  Content check-in and accessibility from anywhere with Web-based and Windows Explorer interfaces
  •  Compression of content to decrease bandwidth demands
  •   Automatic categorization of assets for easy searching
  •   Quick identifying of files via automatically created thumbnail renditions
  •  Asset selection and download in one operation
  •   Secure content distribution – easily and quickly

Oracle Digital Asset Management automates routine tasks and provides robust functionality to effectively manage your rich media files.

  • Easily view and reuse digital assets: This is done via storyboard tree allowsimmediate viewing of specific video scenes.
  • Create thumbnails automatically to easily search and retrieve files: Increaseefficiency by allowing end users to find information quickly via searching for both text and utilizing visual recognition.
  • Save storage space and decrease bandwidth usage by compressing files: Savetime by significantly compressing large files and utilizing bandwidth more efficiently
  • Convert legacy images to Web-friendly formats: View older files without needing older desktop applications.
  • Reduce manual steps in creating multiple renditions: Automatically createmultiple formats of a corporate image or video and create additional formats on the fly.
  • Control access to corporate brand assets: Easily control security permissions surrounding access to brand assets. Manage only one copy of corporate assets.
  • Make corporate audio and video sessions available via the Web: Enable quick and easy browser-based access to presentations, recording presentations, e-learning files, documents, etc.

 Digital Asset Management bundle 

  • Image Management Application
  • Video Management Application
  • PDF Converter
  • TIFF Converter
  • XML Converter

How it Works

When digital assets such as images and videos are ingested into the Oracle system, a number of additional renditions of varying file formats, resolutions, sizes, etc. are automatically generated allowing users to download and use images without reformatting or requiring the use of native applications such as Photoshop for resizing and perhaps impacting your brand.
The original (native) file is available as well as other additional renditions that were autogenerated into jpg and png formats with varying properties such as size, resolution, color, etc. The number and properties of each rendition are completely configurable. Users can add the graphics they need to utilize and download.
When videos are ingested, renditions along with storyboards are auto-generated

Supported Streaming Servers 

For streaming digital video, Digital Asset Manager currently supports the following streaming servers:

  •  Windows Streaming Media—versions for supported Windows operating systems
  •  QuickTime Streaming Media—Darwin and QuickTime Streaming Server  version 10.4
  •  RealMedia —Helix DNA Server version 11

the following screenshots show some steps from configuring the DAM Solution

1-8-2013 5-20-07 PM 1-8-2013 5-22-17 PM 1-8-2013 5-22-38 PM 1-12-2013 1-51-14 PM   1-12-2013 2-25-23 PM 1-12-2013 2-27-08 PM 1-12-2013 2-27-48 PM

the difficulty of construction of DAM Solution resides on tools used and how these tools configured to work together

the tools list as following

  • Webcenter Content on linux server “the archive”
  • flb factory on windows server “the video conversion Engine”
  • SQL Server on windows server

you will need to mount folder on windows server to be accessible on Linux server and this is will need from you have a solid background on Linux to accomplish  this task

How to Update Metadata of documents through DB at UCM(webcenter Content) ?

let’s imagine the following scenario

you have different employee profile for different Document types of each employee such sanctions,vacations, services,certificate ,.. etc

and every UCM profile has 2 metadata “civil number of employee” , and ” employee name” and title which have specific signature as follow

“type of Documnet of ********** ” where the position of * is the civil number example “Vacations of 1235495689” vacations “document title” and the number represent the civil number

and the entry user forget to enter the civil number of employee and those documents are more than 700 document

sure you will not request from user to back to all those document and updates their metadata it’s time consuming and headache

we need to make workaround to get from title the civil number and update the missed civil number

to overcome via DB this problem we should have background about the UCM DB diagram specially the tables of Documents

the metadata of document spread through more than table as following

DOCUMENTS    contain basic data of document “metadata of slandered chick-in”

DOCUMENTHISTORY  contain history of document and life cycle from new to released

DOCMETA    contain metadata of document the customized one

REVISIONS  contain different versions of document

all those tables contain the DID column primary key at DOCUMENTS   table and represented as foreign key at remaining tables

we need to modify metadata so it will be available on  DOCMETA   table but at our case we will get the new value from another metadata -basic one- the DDOCTitle  metadata which represent the  document title

so we need to set the civil number to equal sub string from the document title “get the last 10 characters from title column”

select dm.DID,dm.XCIVILRECORDNUMBER,R.DDOCTYPE,R.DDOCTITLE, substr(R.DDOCTITLE,-10,10)  as newcivil
from DEV_OCS.DOCMETA dm,REVISIONS r
where  r.did=dm.did
and XCIVILRECORDNUMBER is  not NULL

the previous SQL statement get all document with civil number null “have not civil number” and get also the civil number as substring from title field which belong to another table revision

we can get them by different method which will be ready for update statement as following

select  dm.XCIVILRECORDNUMBER ,(select  substr(R.DDOCTITLE,-10,10) from REVISIONS r  where r.did=dm.did) as newcivil
from DEV_OCS.DOCMETA dm
where dm. XCIVILRECORDNUMBER is NULL

now let’s run our update statement as following
update DEV_OCS.DOCMETA dm
set dm.XCIVILRECORDNUMBER =(select  substr(R.DDOCTITLE,-10,10) from REVISIONS r  where r.did=dm.did and r.ddoctype !=’Document’)
where dm. XCIVILRECORDNUMBER is NULL

the result will appear as following screenshot

18-08-2013 06-33-55 م

 

 

how to modifiy kernel parameters at redhat

at installation of webcenter content some checks failed like parameters of  kernel

Checking for hardnofiles=4096; hardnofiles=1024.    Failed <<<<
Checking for softnofiles=4096; softnofiles=1024.    Failed <<<<

solution

cd /etc/security

vi limits.conf

add the following lines before the end of file and save and restart the system

 

change kernal paramters