Can I create an item in Cradle remotely?

Web Access can be used from around the Globe.

Provided you have set access to the web server, if you can connect a browser you can certainly create an item in Cradle remotely.

This video shows how simple it is.

  1. click the New Item icon
  2. fill in the details
  3. add additional information in the item opened in a form
  4. see the item in the database query.

Many tasks can be performed through Cradle’s Web Access.

Storing Project Databases in NAS

We are sometimes asked about storing project databases in NAS (network attached storage), is it possible, is it a good idea, and how to do it.

NAS

Network attached storage is a type of storage device that attaches directly to a network. It is typically a RAID array of disks with one or more interfaces and some management software. It provides network storage without a need to manage a server with attached storage.

A NAS storage device
A Typical NAS Device

Storing Project Databases in NAS

Each Cradle project database is a directory of files and subdirectories. It can be stored anywhere. So, yes, you can store a Cradle database on a NAS device.

Since the NAS device is not a server in the normal sense, it will not be running any part of Cradle and, in particular, will therefore not be running the Cradle Database Server (CDS).

Therefore storing Cradle database(s) on a NAS device means that you are storing them remote form the CDS.

Storing Project Databases in Server Storage

For the same reason, you can store a Cradle project database on a server that is separate from the computer that runs the CDS.

Therefore storing Cradle database(s) on a separate server means that you are storing them remote form the CDS.

Advantages and Disadvantages

If you don’t have a server in your network, then a NAS device is a cost-effective means to add centralised storage.

NAS devices are often used to collate data for backup. Storing Cradle databases on a NAS device eliminates the need to copy the databases onto the NAS device for backup.

Not storing Cradle databases on the machine that runs the CDS adds considerable latency between the CDS and the disk(s) that store the databases. Increasing latency worsens the performance of the CDS.

How to Store Cradle Databases on NAS

  1. Specify the location of the database’s directory using a UNC pathname, of the form: \\hostname\path
  2. Ensure that the access rights of the database’s NAS directory are accessible RW by the Windows ‘System’ user of the computer that runs the CDS or, for Linux, either root or whatever user your CDS runs as on its local machine

Recommendations

In general, we do not recommend storing project databases in NAS or indeed in any network-based resource.

If possible, only store your Cradle databases on the machine that runs the CDS and backup your databases regularly!

Publish Subject Items in Document Publisher

Using the ‘Publish Subject Items’ option

The Publish Subject Items option in the Hierarchy Table can allow a user to stop items being published. This is based on a link(s) existing or not. Users need to understand it affects not only the type it is on but can affect the Subject type as well.

Publish Subject items Options
Hierarchy Details – Publish Subject items Options

Publish Subject Items – Always

When the option is set to ‘Always’, this means that the target items will be published in the document. It does not matter if there are linked items below or not.

Publish Subject Items – ‘Only if link exists’

When the option is set to ‘Only if link exists‘ then the item type will only get published if the item linked to the source has the correct link type and is not excluded because of a filter.

With ‘Only if link exists‘ set on the ISSUE item type and a filter:

– Requirement (Source Item)

– ISSUE (Target Item with filtering)
– RISK (Target Item)

With the hierarchy set as above, if a Requirement only had 1 ISSUE linked to it and this link was removed due to filtering. This means the source item will not be published as there are no linked items to be output. If the Requirement has 2 ISSUEs linked to it and only one is removed through filtering then the source item, the single linked ISSUE and any linked RISK items will be published .

With ‘Only if link exists‘ set on the ISSUE item type and no a filter:

– Requirement

– ISSUE
– RISK

With the hierarchy set as above, the Requirement will be published as well as both ISSUEs and any linked RISK items.

Publish Subject Items – ‘Only if link does not exist’

When the option is set to ‘Only if link does not exist‘ is set on a target item then the source item is only output if the target item is not linked.

With ‘Only if link does not exist‘ set on the RISK item type:

– Requirement

– RISK

Any Requirements that are not linked to a RISK or have the wrong link type will be published. Those Requirements that are linked will not be published.

Publish Subject Items – ‘Only if all links exist’

When the option is set to ‘Only if all links exist‘ then the source item will be output if all linked items have the correct link type and are not removed through filtering.

With ‘Only if all links exist ‘ set on the ISSUE item type and a filter:

– Requirement

– ISSUE (with filtering)
– RISK

If the Requirement has a single ISSUE linked to it and the filtering removes this link then neither the Requirement nor the ISSUE will be published.

When a Requirement has two ISSUEs linked to it and the filtering removes one link then neither the Requirement nor the ISSUEs will be published.

With the filtering removed from the ISSUE item type then the Requirement, ISSUEs and RISK items will be published.

Publish Subject Items – ‘Only if all link do not exist’

When the option is set to ‘Only if all links do not exist‘ then the source item will be output as long as non of the linked items have the correct link type or at are removed through filtering.

With ‘Only if all links do not exist ‘ set on the ISSUE item type and a filter:

– Requirement

– RISK

If a Requirement has a RISK linked in the right way then the source item will not be output. If a Requirement has either no linked RISK items or the link type is wrong then the source item will be output.

For help on Document Publisher click here

For blog posts on Document Publisher click here

How do I change an item’s owner?

Did you know you can change the owner of an item?

Changing an item’s owner is really easy.  Simply select the item you want to reassign to  different owner and from the context menu (right click) select -> More -> Set Owner…   The following dialog will then open:

.
Set New Owner

There are obviously some restrictions, you can’t set the owner to PROJECT and bypass configuration management, you need the right privileges within your team. This is explained in the Cradle help

You can also Set Owner Including Related Items, by navigating to the same place as Set Owner and the option below that one is for Related Items.

If you would like further information regarding Owner of an Item click here.

Captions for Images in Document Publisher?

Question: I have images that need to go into a document and want to have captions with them when published, how do I do this?

Create a Frame in WorkBench

To have captions for images without using RTF frames, add a new frame, name it the same as your image frame with the TITLE appended to it e.g. PICTURETITLE or PICTURE_TITLE. Leave this frame as a plain text frame.

Adding a text frame to use as the caption for an image
Adding a text frame to use as the caption for an image

Run or open and item with the image you wish to set a caption for. Then enter the caption for the image in this new text frame.

PICTURETITLE frame for the captions
PICTURETITLE frame for the captions

Set the Options for Captions in Document Publisher

Open your template in Document Publisher and open the Option UI. Select the ‘Figures and Tables’ tab and enter the name of this frame in the box for ‘Title frame’.

Figures and Tables tab in Options
Figures and Tables tab in Options

If using a default Paragraph Group tag without Field tags then a user can add the PICTURE frame name to the ‘Frames to publish after TEXT and NOTES in the default layout’ under the ‘Item Frames’ tab.

Item Frames Tab in Options
Item Frames Tab in Options

This will then output the default layout including the frames from the ‘Frames to publish after TEXT and NOTES in the default layout’ option. The text in the PICTURETITLE frame is used for the caption for each image. The captions then for each image will then be entered into the List of Figures during publishing.

List of Figures for both default and field tag output
List of Figures for both default and field tag output
An image using the title frame for the caption
An image using the title frame for the caption via the default layout

Using Field Tags

If the user wishes to use Field tags the option will work with these too. Add the field tag for the image in this case the PICTURE frame. As the template is published, the caption for the image is set from the PICTURETITLE frame. Again this will be picked up in the List of Figures when published.

Using Field tags in a Paragraph Group tag to output images with captions
Using Field tags in a Paragraph Group tag to output images with captions

Using the PICTURE frame Field tags will also work within a Table or an Inserted Table. It will output the caption with the image and add it to the List of Figures when published.

Using Captions for images within a Table
Using Captions for images within a Table
List of Figures Including the tags in a Table
List of Figures Including the tags in a Table

For more information on Document Publisher click here

Article updated 05/12/2018 – Changed to be an FAQ

How do I see multiple queries at the same time?

Run and Display Multiple Queries Simultaneously

In Cradle it is very simple to see multiple queries!

First of all run your selected Query and this will open in a pane as usual such as shown below:

Query feature
Pane 1 – Query Feature

Now in the Top Right of the Pane you will see a little Arrow pointing right, if you select this you will be able to “Split Top/Bottom” or Split Left/Right” Creating a new pane. In that pane right click and you will have the option to “New Query…” This can be done multiple times. Showing multiple queries in views, multiple items in forms or multiple diagrams As you can see by my example below I have 3 Queries open all with different views and styles.

WorkBench showing multiple queries
Multiple Queries

For further information on Multiple Queries click here

How do I fix api-ms-win-crt-runtime-l1-1-0.dll error?

Fixing “api-ms-win-crt-runtime-l1-1-0.dll” Error

Warning note
Error/Warning

If, during an install, you receive the error ‘api-ms-win-crt-runtime-l1-1-0.dll is missing’ this is due to Microsoft® Windows  updates not being applied. To fix this you need to:

  1.  Install Windows updates by:
    1. Go to Start > Control Panel > Windows Updates
    2. Check for updates
    3. Install all available updates
    4. After the updates are installed, restart your computer
    5. After the restart repeat the steps above again until no more updates are available
  2. Once ALL Windows updates have been installed, download the Visual V++ Re-distributable
    1. For Windows 64-bit: Visual C++ Re-distributable for Visual Studio 2015 (64-bit)
    2. For Windows 32-bit: Visual C++ Re-distributable for Visual Studio 2015 (32-bit)
  3. Run the vcredist_x64.exe (64-bit) or vcredist_x86.exe (32-bit) and select Uninstall
  4. Run the setup.exe again and select Install

How to Colour Code Categories and Frames?

Did you know you can Colour Code your Frames to match the Priority you have set in Categories?

To enable this colour code you will need to navigate to Project Setup, inside here go to Item Definitions – Categories. For my example I have used Req Priority, in my Category Values I have :

  • URGENT – Red
  • MEDIUM – Orange
  • LOWEST – Yellow
  • TBD – Blue

 

Project Schema category colour code setup dialog.
Single Value Category Setup

 

Ensure you have assigned this Category to a Frame in an Item Type. For my example I have put mine into Item Type – Requirements and the Frame is TEXT

As you can see in my example, whenever I change my Req Priority the text colour changes in “Detailed Description” Frame.

For further information regarding Frames click here

Article updated 05/12/2018 – Changed to be a FAQ

How do I rearrange items in a hierarchy?

Reorder Item and Their Hierarchies

Hierarchies are seldom created in a single operation. It is more usual for you to create a  hierarchy interactively,  gradually developing the hierarchy item-by-item.  It is also very likely that the hierarchy will need to be reorganised, to reorder items as it is being built, for example:

  • To add a new top-level item into the hierarchy and move existing items below it
  • Move individual items to a different position in the hierarchy
  • Move sub-trees in the hierarchy upwards, downwards, or to any other new position

We term this process of rearranging “reordering”. Cradle fully supports reordering using drag and drop.

To enable this feature:

  • Items must be of the same type (system notes or requirements)
  • Auto-numbering must be selected for the item
  • Items must allow hierarchical numbering using Key
  • CREATE_XREF and DELETE_XREF privileges needed
  • Set the preference  “Allow drag and drop in same tree”
  • A navigation that sorts by Key
Reorder items
Reorder items

Why we use hierarchies

Hierarchies are useful to show the users of a project a view of the Top level item and all its branches, and with Cradle it is easy to join many hierarchies into one, you can create a new top-level item and connect hierarchies to it.

For further information on reordering please head over to our online help.

Article Updated 04/02/2019 – Added why we use hierarchies

How do I manage my Linux Cradle server when I have no GUI?

Managing your Cradle server via Command Line

Quite often you may find that the server machine you install the CDS and CWS on may not have a graphic user interface, in this case you can manage your Cradle server via a command line

How to Install a Security Code

The c_config command allows you to update a Cradle Security Code

Format
c_config -i code
Example
c-config -i BWEr-DSWe...

How to Start/Stop/Restart the Cradle Database Servers

The c_start command allows you to start, stop, restart or test the Cradle Database Server (CDS) and/or Cradle Web Server (CWS).

Format
c_start {start | stop | restart | test} {cds | cws | all}
Example
c_start start cds
Variations
CommandResult
c_start startstart cds + cws
c_start start cdsstart cds only
c_start start cwsstart cws only
c_start start allstart cds + cws
c_start stopstop cds + cws
c_start stop cdsstop cds only
c_start stop cwsstop cws only
c_start stop allstop cds + cws
c_start restartrestart cds + cws
c_start restart cdsrestart cds only
c_start restart cwsrestart cws only
c_start restart allrestart cds + cws
c_start testgive process numb of cds + cws
c_start test cdsonly give process numb of cds
c_start test cwsonly give process numb of cws
c_start test allgive process numb of cds + cws

How to Manage Cradle Projects

The c_prj command is used to create, delete, lock and unlock Cradle projects.

Format
c_prj.exe [-create
              -code <projcode>
              -title <project title>
              -path <project location>
              [-pid <project PID>]
              [-schema <schema name>]]
          [-delete
              -code <projcode>
              -password <MANAGER password>
              [-method {all | pdb | reg_only}]]
          [-lock
              -auth <user>,<password>,<projcode>
              [-allow_user <user>]]
          [-unlock
              -auth <user>,<password>,<projcode>]
Examples
c_prj.exe -create -code TEST -title "Test Project" -path /home/apps/temp/projects/test -pid TEST01 -schema empty

Will create a project with a project code of TEST, a title of Test Project in the /home/apps/temp/projects location with a PID of TEST01 using the empty schema.

c_prj.exe -delete -code TEST -password MANAGER PASSWORD -method all

Will delete the TEST project along with the registry entry, database files and directories.