This Documentum scripting tool was created in Microsoft Visual Studio Community 2017 C#/WPF Ribbon. Multiple scripts can be contained in one file then run as one command against the idql32/64. It then refreshes the grid with the results file that is created by the idql tool. It was created to help with scripting Documentum databases. This application must be run on the Documentum Content Server in order to work properly.

Table of Contents

• Dependencies
• Glossary of Terms
• Functionality

Dependencies

Software	Dependency
Microsoft Visual Studio Community	Solution
Microsoft Ribbon for WPF	Project
Microsoft SQL Server CE 3.5	Database
SQL Server Compact Toolbox	Database
Sandcastle	API documentation
Log4Net	Error Logging
Documentum	Script
www.IconArchive.com	Icons
Snagit	Read Me
Badges (Library, Custom, Star/Fork)	Read Me

Glossary of Terms

Term	Meaning
DocScript	Documentum Script Administrator
DQL	Documentum Query Language is used to query Documentum which is a content management system used to create, manage, deliver, and archive all types of content from text documents and spreadsheets to digital images, HTML, and XML components. DQL uses syntax that is a superset of ANSI-standard SQL (Structured Query Language) DQL statements operate on objects and sometimes on tables/rows but SQL statements operate only on tables/rows. Part of DQL statements are translated automatically into SQL before being executed by the eContent Server
API	Application Programming Interface is a collection of methods prescribed by an application program by which another application can send requests to it. For example, Server API methods are executed by the Documentum Desktop to access the Content Server
idql	A scripting application for DQL located in the working directory on the content server
iapi	A scripting application for API located in the working directory on the content server
WPF	Windows Presentation Foundation (or WPF) is a graphical subsystem by Microsoft for rendering user interfaces in Windows-based applications. WPF, previously known as "Avalon", was initially released as part of .NET Framework 3.0 in 2006. WPF uses DirectX. WPF attempts to provide a consistent programming model for building applications and separates the user interface from business logic. It resembles similar XML-oriented object models, such as those implemented in XUL and SVG. WPF employs XAML, an XML-based language, to define and link various interface elements.[1] WPF applications can be deployed as standalone desktop programs or hosted as an embedded object in a website. WPF aims to unify a number of common user interface elements, such as 2D/3D rendering, fixed and adaptive documents, typography, vector graphics, runtime animation, and pre-rendered media. These elements can then be linked and manipulated based on various events, user interactions, and data bindings.

Functionality

Listed below is the detailed functionality of this application and its components.

Main Form

Run

• This button will first copy the script from the script file directory to the working directory. Then it will execute the script file.

User Name

• This account must be an administrator in Documentum.

Password

• The password for the administrator in Documentum

Script Type

• This is the type of script you can run. i.e. idql32.exe for a 32 bit machine and idql64 for a 64 bit machine.

Docbase

• A specific docbase must be selected

Script File

• This file contains one or more than one script files. It has to be copied to the working directory to run.
• The script file can not have any spaces in the file name

Results File

• This is the file that is created after the script file is run. Unless the path to this file is indicated the default path is the working directory.

Working Directory

• This is the location of the script type e.g. idql64.exe, iapi64.exe

Quick Access ToolBar

The following are all functions of the quick access toolbar.

Refresh

• This refreshes the results column from the results file in the datagrid

Save

• This saves the grid to a csv file

Application Menu

The following are all functions of the application menu.

About

• The about form

How To…

• Opens the as built documentation.

API Doc…

• Opens the API documentation.

Settings

• All the dropdown lists and default values are stored here and can be edited.

Copy

• Copies the command line script

Exit

• Closes the application.