Tools - Batch Export

This topic describes a feature that is provided only within Manifold Database Administrator Edition and is not available in other Manifold System editions. If you have purchased and installed Database Administrator Edition the features described in this topic will be available to you. If you have installed some other Manifold System edition you will not be able to use these features.

The Tools - Batch Export command works with Oracle databases only. It allows users of Database Administrator Edition to export many drawings, images and surfaces at once into an Oracle database. The Oracle server must support SDO_GEOMETRY for upload of drawings, and it must support GeoRasters for upload of images and surfaces.

The Batch Export dialog combines the functions of File - Export dialogs for drawings, images and surfaces into a single dialog, using similar controls. The Batch Export dialog is resizeable.

$images\dlg_batch_export.gif$

Controls

Server	The name of the Oracle server. oracledb is the default if the full enterprise Oracle product was installed using the directions in the Installing Oracle topic. In the case of Oracle Express installations the server name is xe by default. See the directions for connection in the Installing Oracle topic.
User Name	An authorized user name to login onto the Oracle server. system is the default system administrator name if the server was installed using the directions in the Installing Oracle topic. Experienced Oracle IT managers will provide users with their own login names.
Password	Password to use to login to the Oracle server.
Connect	Press this button to connect to the Oracle server and to enable dialog controls. Some other controls, such as the OK button, will not be enabled until a connection has been established.
$images\btn_box_select_all.gif$	Select All - Check all components.
$images\btn_box_select_none.gif$	Select None - Uncheck all components. No components will be exported. Tech tip: Use this to uncheck all components before checking those desired.
$images\btn_box_select_invert.gif$	Select Inverse - Uncheck all previously checked components and check all previously unchecked components. This is a fast way to check only a few components out of many: uncheck those desired and then push Select Inverse.
(component pane)	A list of components in the project available for export. Checking the box of a component will export it. Some controls in the dialog will not be enabled unless a component of that type has been checked. Most column values are editable. To edit a specific column value, double-click it. Columns in the pane include: Component - The name of the component in the Manifold project. Export As - Name to use for this component in the database. Friendly names may be specified in this column. Precision - Location precision parameter to be used for drawings. Expressed in whatever native drawing units are used by that drawing. Projection - Coordinate system to be used within Oracle for this component. Manifold will use the same projection used by the drawing if it is supported by the server (nearly always possible) or whichever is the most similar projection available on the server. Double-click to launch the Projection dialog that allows choosing an Oracle projection. Using a projection on the server different than that used by the drawing will require re-projecting the drawing, which can take a significant amount of time for large drawings.
Drawings
Identity column	Allows customizing the name of the identity column. OID by default.
Geometry column	Allows customizing the name of the geometry column. Geometry by default.
Version column	Allows customizing the name of the version column. Version by default.
Do not reproject data	Off by default. Check to prevent re-projection of data on export, as might be required to match the projection in use by Manifold to an available Oracle projection.
Create spatial index	Checked by default. Creates an Oracle spatial index for the table containing the drawing, which makes certain Oracle spatial operations faster.
Create sequence and triggers	Checked by default. Creates a sequence object to generate values for the ID column, a trigger to fill values in the ID column for newly inserted records, and another trigger to update values in the Version column for changed records.
Images and surfaces
Do not reproject data	Off by default. Check to prevent re-projection of data on export, as might be required to match the projection in use by Manifold to an available Oracle projection.
Create pyramids	Create intermediate level images to enable much faster zooming and panning. Always leave this checked unless you are a maximum Oracle GeoRaster expert and have some specialized reason not to create pyramids.
Split data into tiles	Off by default. If checked, will split image data into tiles of the specified size instead of sending image data in one chunk. For use by Oracle experts who wish to tune image storage in the DBMS.
Preserve image library tile structure	On by default and used when exporting an image library image to Oracle. When on, the export process will create a separate database tile for each file in the image library, scaling pixels as necessary. When off, the export will send the image library as an ordinary image component and will cut pixels into new tiles if need be.

The default name of the identity column used when exporting a drawing to an Oracle database is OID to avoid naming collisions with the ID column that stores Manifold object IDs in Manifold drawings.

When we press the OK button to tell the Batch Export dialog to go to work exporting components that have been checked in the components pane, as each component is exported the box for it will be automatically unchecked. This facilitates canceling the Batch Export process, which can be lengthy in the case of many components or large components and then restarting the Batch Export process at a more convenient time with only the remaining components checked.