Category Archives: ECM

Enterprise Content Management

Excel to UCM Batch loader Format Parser

Utility developed to convert Excel sheet contains metadata for files to be check-in at UCM to UCM batch loader format link to download http://www.mediafire.com/file/36z34rauj545keh/Excel_Parser.rar Advertisements

Posted in Oracle ECM, UCM, Uncategorized | Tagged , , , , , | Leave a comment

UCM Custom Export Utility

download attached Jar file link to download JAR https://www.mediafire.com/file/23fj8ls9xqxc03q/UCMExportUtility.jar Upload it to UCM server Follow instructions as screen shoots

Posted in ECM, Oracle ECM, UCM, Uncategorized | Tagged , , | Leave a comment

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

Posted in ECM | Leave a comment

Enabling the OracleTextSearch at UCM

add the following variables to the config.cfg SearchIndexerEngineName=OracleTextSearch IndexerDatabaseProviderName=SystemDatabase restart the ucm server and rebuild the full index check the following link for further info. http://docs.oracle.com/cd/E21043_01/doc.1111/e10792/c05_search001.htm  

Posted in ECM | Tagged | 1 Comment

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>

Posted in ECM, idoc script | Leave a comment

intradoc.common.ServiceException: !csUserInsufficientAccess

Users with read only privilege are not able to access or login to the Content Server.  The error generated in the log is:   To resolve the issue, add the following configuration entry to the <cs_dir>/config/config.cfg and restart the Content … Continue reading

Posted in Oracle ECM, UCM | Leave a comment

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  

Posted in ECM, ODC, ODDC | Tagged , , , | Leave a comment