Username:
Password:
Please type the Two words with a space between them to prove you are a real human being.
There have been several changes related to import/export, described in the following sections.
The c_io command line utility provided in both UNIX and Windows-based Cradle systems has a new -sanitise command line option that causes c_io to generate a sanitised export file.
A sanitised export file is identical to a normal Cradle format import/export file except that:
Sanitisation of subject matter data means to replace all non-whitespace (space and tab) characters by the character x. This sanitisation applies to the following attributes:
The Number and category code attributes are not sanitised.
When a sanitised export file is generated for all item types in a source database and the sanitised file is imported into another database, that destination (sanitised) database will have an identical schema and set of items and cross references to the source database, except that the content of the data in the destination database will be sanitised. This means queries, views, forms and so on will work in the same way in both databases (except only for queries based on the contents of frames).
Sanitised exports have several uses, one is to send exports of customers’ Cradle databases, or parts thereof, to 3SL whilst protecting the national, commercial or military sensitivity of the data.
Where the differences between a sanitised and an ordinary export are that all subject matter related data in the original export has been replaced by x characters in the sanitised export.
A new -type query option has been added to the c_io command that allows the contents of an export file to be controlled by a query specified in new -query and -qloc options to specify the query’s name, and its location (personal, user, team, user type, project or system scope).
Query based exports can be performed with a c_io command of the form:
c_io -login user,pass,pcode -type query -query name -qloc location -export file
For example, a system Req - All query can be used with the command:
c_io -login user,pass,pcode -type query -query “Req - All” -qloc system -export file
User feedback has been improved in c_io in the form of two new options -verbose and -log.
The -log creates a log file containing the same summary of the items exported and imported and details of any errors and items not overwritten as can be produced from the Log... buttons in the Export Information and Import Information dialogues in Toolset and WorkBench.
If -sanitise and -log are being used, then all information in the log file is also sanitised.
The -verbose option causes a popup to be produced once the c_io command has completed its import or export, and can be convenient for exports and imports that take a long time to run.
Two new privileges have been introduced to allow projects to optionally limit the ability to perform import and export operations to/from Cradle databases:
These privileges are enabled for all existing users in all existing projects.
These privileges apply to all export and import operations:
Extra information is now included in all Cradle format import/export files produced by Toolset, WorkBench and the c_io command line utility. This new information appears as comments at the top and bottom of the import/export file:
Back to the newsletter archive.
