Displaying Item Hierarchies

You will often want to organise information in a hierarchy. In a hierarchy, each item of information will have a unique Identity, a hierarchical number and (usually) a name. Displaying item hierarchies nicely will help everyone to clearly understand the information and its structure.

For example, here is a (very!) simple collection of System Breakdown Structure (SBS) hierarchies:

displaying hierarchies
A Collection of SBS Hierarchies

This display clearly shows the hierarchical structure of the items, their hierarchical numbers, and their names.

Displaying Item Hierarchies

Hierarchies display items with a label. This label contains the item’s Identity, Name, Version and Draft ID attributes.

3SL recommends that hierarchical items are auto-numbered. Therefore, their Identity will not be the nice hierarchical number that users will want to see. That hierarchical number is normally stored in the Key attribute.

Therefore, we want the labels for items in a hierarchy to contain the Key and Name attributes.

Create a View for Trees

So, your first step is to define a view to show items in trees, such as:

define view tree labels
Define Items’ Tree View

This contains only the Key and Name attributes, and a small text separator containing  a colon. This separator is cosmetic. If you prefer not to have it, then don’t!

Save the view with a simple name such as the item type followed by Tree. In this case, the view name is:

SBS – Tree

Save it as a Project scope view. If you save the view with Project scope, everyone in the project can use it.

Tell Cradle to Use this View in Trees

The final step is to tell Cradle to use the new view when displaying hierarchies of this type of information:

displaying item hierarchies set default view
Specify a View to Show Items in Trees
  • Select Project Setup in the Project tab
  • Set Options to Item Definitions
  • Select the Item Types tab and select your type of information
  • Choose your new view from the Tree View drop-down list
  • Save and close the schema

After you have made this change, all hierarchies of this type of item will be shown using your new hierarchical view.

X-Ray Day 2017

 X-Ray Day 8th November 2017

X-Rays  are a form of electromagnetic radiation or “ray” for short.

When first discovered, these mysterious rays were nothing like anything that had been described before, hence the ‘X’ name has stuck.

X-rays have a wavelength less than 10 nanometres, that is, they are shorter than those of UV, and longer than those of gamma rays.  It was a German scientist Wilhelm Röntgen often credited with their discovery.

Looking Inside Cradle

Thankfully there is no need to use X-Rays to look inside your Cradle project.

Information once stored can be recalled by Queries and presented in Views or Forms. Output can be directed to HTML or RTF tables, shown graphically as a Hierarchy diagram, explored by clicking links. Formal publishing to Microsoft® Word documents can be achieved through Document Publisher.

In short there is no mystery to your data once inside Cradle unlike our bones, welded joints or airport suitcases you can easily see your data.

Celebrate on X-Ray Day 2017

Celebrate the genius of a very useful tool in the x-ray machine. Whilst we don’t advise you have an x-ray for fun, you could download another useful tool here!

Load Cross Reference Links

Cross references, or links, are used to connect items in the database. Each cross reference connects two items. A cross reference represents the fact that the two items are related in some way. Sometimes, it is helpful to load cross reference links en masse from an external file.

Types of File to Load

Cradle can load data from files in three main formats:

  • Cradle
  • CSV / TSV, comma separated value or tab separated value
  • XML, there are many possible dialects of XML

Microsoft Excel® can easily produce CSV files. Also, it is easy to work with collections of simple data in Excel. Therefore, we recommend that you use Excel to load cross reference links into Cradle using CSV files.

Example

In this blog entry, we will assume that you want to load cross reference links between user-defined items, such as system requirements and verifications, or test cases to test results. So, if you want to do anything else, please look in the reference section below for links to the Cradle help.

In our example, we will create links of type FRED from PROCR items to SR items.

Create Cross Reference Links

You will need the following columns in your Excel spreadsheet:

  • Type, use the value: NOTE_NOTE
  • Link Type, the link type of the cross references that you want to create. In our example, this is the link type: FRED.
  • From Info Subtype, use the value: NULL_INFOSUB
  • For From Model Namespace, use the value: MH_IGNOREMODEL
  • From Number, this contains the Identity of the item at the from end of the cross reference. In our example, this is the Identity of the PROCR item.
  • From Type, this contains the type of item at the from end of the cross reference. In our example, this is: PROCR.
  • To Info Subtype, use the value: NULL_INFOSUB
  • For To Model Namespace, use the value: MH_IGNOREMODEL
  • To Number, this contains the Identity of the item at the to end of the cross reference. In our example, this is the Identity of the SR item.
  • To Type, this contains the type of item at the to end of the cross reference. In our example, this is: SR.

These fields can be in any order.

load cross reference links
Define Cross References in Excel

Load Cross Reference Links

You can load the CSV file containing your links by:

  1. Select Import from the Project tab in WorkBench
  2. Set: File Type to be: CSV
  3. Then, set: Info Type to be: Cross References
  4. Also, set: Overwrite to be: Off, as this is safer than the other options(!)
  5. And set From file to be where your CSV file is stored
  6. Click Import
load cross reference links
Load Cross Reference Links

You will be asked to define the mapping between fields in the CSV file and the attributes of cross references. Because the column headings in Excel match the names of the attributes, everything is mapped automatically:

load cross reference links
Load Cross Reference Links – Field Mapping

Click OK to load cross reference links from the CSV file.

Link Rules

The link rules defined in your schema are used to control if cross references will be imported from your CSV file. You can set an option to ignore your link rules, if you want to.

Dangling Links

Importing cross references this way may create dangling cross references. A cross reference is dangling if the item at its from end, or its to end, does not exist. Cradle allows you to import these cross references because it would be too restrictive to prevent you doing this.

You can detect and remove dangling cross references using the Cross Reference Integrity check in the Project tab in WorkBench.

Reference in Cradle Help

You can review the details of Cradle’s CSV file format in the Cradle help. Every Cradle system contains the Cradle help. You can access this help from the Help tab in every Cradle UI, and (on Windows) from the Cradle Help item in the Start menu.

We also provide the Cradle help on-line in our website:

https://www.threesl.com/cradle/help/

You can access the detailed help for Cradle’s CSV file format here:

https://www.threesl.com/cradle/help/7.3/Import%20Export/Other/csv_fileformat.htm

Functional and Non-Functional Requirements

A Requirement that works and one that doesn’t?

Grammatically the difference between the types of requirement could be seen like that, but not so in RM (Requirements Management) parlance. Functional and Non-Functional Requirements are a what and how of engineering.

HID showing how functional and non-functional requirements link to form the overall set
Interlinked Functional and Non-Functional Requirements

Functional Requirement

These define what the features are. “The User Interface board shall send an enable signal when the user presses the On key”
or “The finance reporting mechanism shall produce a summary report automatically at the end of each month”. These requirements tell the designer/implementer what the systems need to do. They can be read and agreed by the customer and will align with their expectations of the system.

Functional requirements are not limited to actions. They can include regulatory or safety requirements, “The system shall be protected and able to be certified to IP44”, or internal rules “The output format shall be commensurate with detail explained in the operating procedures for the production line”. They can reference other external requirements or standards. “The electrical interface shall be compatible with USB 2.0 standards using type A connectors, verified by a third party.”

Non-Functional Requirement

These define how the system will operate. They will place constraints and capacities on the system that can be measured.  “The User Interface  enable signal shall be a TTL level present within 0.25 seconds of the user making contact with the physical interface” or “The finance reporting mechanism shall be capable of summarising 100K entries into the 10 specified categories”.

These limits and descriptions provide bounds within which the Functional Requirements can me met. “The system shall allow users to cross the road safely” is a wide Functional Requirement. “The user shall not need to interact directly with the facility”, “The design shall comprise of a fixed physical system requiring no power”. Looks like we’re building a bridge or subway rather than a pelican crossing then!

Lines are Drawn

There is always going to be a grey line between the two areas. Some will depend where the responsibilities end and so on one project what is deemed a functional requirement. “The interface must be USB 2.0”, is a main operating characteristic that our system can not change and is needed to interface to an external system. On another project the functional requirement may be “The main system should interface with up to three external input and output devices” and the design team may decide “All inter product interfaces shall use USB 2.0 standard communications”

In the ideal world everything should operate 100% of the time without failure and should be completely intuitive. Should occur without delay and should be fixable for ever. However, the world we live in is not ideal. System designers need to recognise that. Non-Functional Requirements can define these limits and manage expectations, from both a contractual and measurable quality point of view.

  • “To aid the user to perform the task consistently. The UI shall provide guidance in the form of fixed text and sequenced indicators.”,
  • The system shall have an availability no less than 99% of the time”, 
  • “Visual and audible feedback shall be provided within 0.2 seconds of any interaction”,
  • “Design components should have an availability before EoL of two years minimum”

For every system these user experience, reliability, performance criteria, and through lifecycle considerations should be made.

3SL Email Filters

We all use e-mail as a reliable method for our personal and business communications. However, as we all know, vast numbers of spam, junk and malicious e-mails are also sent every day. Everyone needs protection from the damage that clicking a link or attachment in just one e-mail can do. 3SL has recently changed our 3SL email filters to further reduce our exposure to such threat vectors. We expect that you and your organisation also update your filters regularly.

3SL email filters
Block Spam and Malicious E-Mails

This blog post is a summary of what the 3SL email filters will do.

We are publishing this so that you can reliably send your emails to us. We do not expect that the 3SL email filters will block any of your emails. But if one of your emails is blocked, this blog post may help to explain why.

Principles of 3SL Email Filters

We will obviously not disclose full details of the 3SL email filters. You would not expect us to do something that silly. There are some general principles which we will publish, which are:

  • The more malicious an email is, the less likely our mail server is to provide an informative response to the sender, or their mail server
  • The more malicious an email is, the more likely we are to provide false responses, or no response, to the sending mail server
  • We use all available blacklists to ignore all known malicious senders and mail relays. Either we access them online, or we keep local copies and then update them regularly.
  • 3SL always reports malicious financial emails to the organisation that they are supposed to come from
  • We report all malicious e-mails to blacklist sites wherever possible
  • We automatically block emails based on their from, to, subject, content, formatting and attachments
  • Any e-mails sent to undisclosed recipients or with multiple from tags will be rejected
  • We operate our own blacklists, for people we dislike
  • Emails from people we especially dislike are automatically sent to spam reporting sites
  • We operate our own whitelists, for people we like!
  • All e-mails and all of their attachments are scanned for viruses and other nasty tricks(!)

Email Attachments

The types of attachment to an email is an important part of the 3SL email filters. Therefore, the 3SL email filters are very sensitive to the types of files that are attached to e-mails.

We currently block everything that is remotely executable. This includes the obvious ones, such as:

  • exe files
  • scr files
  • msi files
  • .bat files
  • .cmd files
  • .lnk files
  • .com files

and many others.

We also block file types that are common vehicles for malicious code, including the obvious ones:

  • .jar files
  • .ace files

and others that we will keep to ourselves!

In total, we block over 20 file types.

Accepted Attached File Types

We want to receive your e-mails! Therefore, if you need to send any attachments with your e-mail, only send:

  • Microsoft Office files
  • Open Office files
  • PDF files
  • Plain or rich text files
  • Cradle import/export files
  • Simple images

We will detect macros in e-mail attachments. So, please don’t send us any file with a macro inside it!

If you send a file containing a macro, then either your e-mail will be rejected or, if you are in our whitelist – and this includes customers – then your e-mail may be logged as spam, or it may be rejected.

Alternatives to Email for File Exchange

If we need to exchange files with you that would be blocked by our email system, or by yours, there is an alternative!

Every login account in our website can have a file transfer area. You can use this area to download any type of file from us. You can use this area to upload any type of file to us. Therefore, this mechanism avoids any need for us, or you, to send files by e-mail that either of our mail systems would block.

We think that this mechanism is very useful. 3SL asks all of our customers to consider using this mechanism. We hope that you will agree.  Therefore:

  • If you have a login to our website, we can enable this facility for you.
  • If you do not have a login to our website, please register and create one!

Your organisation may also provide a secure file transfer mechanism. If so, tell us about it. We will be pleased to use it.

Help Us to Help You

Obviously, we never send anything malicious to anyone. Equally obviously, we do not ever knowingly send any emails that could be regarded as spam, malicious or suspicious. So we would be concerned if you do not receive any of our emails.

Therefore, please tell us if you believe that we are sending emails that are being blocked by your mail system.

If this happens, then we will work with you and your IT to either:

  • Add 3SL to your organisation’s whitelist, and therefore none of our e-mails will ever be blocked
  • Or we will change the format of our emails so they are acceptable to your organisation

Three Hundredth Blog Entry!

Enjoying our Blog?

We’re hope you are all enjoying the 3SL blog and have found useful, interesting and fun articles.

This morning we noticed the counter creep over the three hundredth blog entry mark.

screenshot of the opening blog entry from Jan 2016
First Blog Entry

Looking back we’ve covered everything from announcements about  new Whitepapers to ‘How to‘s on simple Category Validation to more complex Document Publisher Table Generation . We’ve also looked at the stories of the day celebrating engineering excellence such as Ada Lovelace and Pi days to the more bizarre  Towel Day. Our FAQ section has answered customer enquiries about controlling their Hierarchy Diagram output to freeing up licences locked by a user who has gone home and left their machine locked.

Get in touch…

Onward, beyond the three hundredth blog entry we’ll be keeping you up to date with all things 3SL and Cradle (and the odd bonkers story too!)

Have you got a great tip for setting up a schema for a particular engineering or management practice? You could submit a guest article and let us, and other users,  know all about it.

If you mention Cradle in your own company blog, send us the link and we may mention it.

If you’d like see a ‘How To’ on a particular subject, we’ll endeavour to put one together.

Go on, drop us a line and let us know social-customer@threesl.com, call us +44 (0)1229 838867 DM us @threesl

Remote Workers and Cradle – how do they communicate?

Cradle, like many modern applications, uses networked communications between clients and servers. However, with modern working practices, often not all users are on the same site. Some, not even the same continent as the Cradle server. So we need to create a method to allow these remote workers access to the Cradle server.

Thin Clients

3SL created the CWS (Cradle Web Server).  This allows a capable thin client deployment to local and remote workers without the need to install Cradle WorkBench.  But some customers want their remote workers to have access to the full capabilities of WorkBench, Project Manager, Document Publisher, and Document Loader; so how can these remote workers deploy the Cradle clients with network access to the server?

Virtualised Applications and Desktops – (e.g. XenApp, RemoteApp)

Citrix XenApp® and Microsoft® RemoteApp allow your applications and desktops to be virtualised and then served to the user from central servers.  The Cradle client utilities are installed on the Application Servers.  Users are able to connect to the server which redirects the Application or Desktop display to the users device.  These technologies allow users with devices which are not currently supported by 3SL to use the full desktop Cradle applications.

Many Cradle customers use Citrix XenApp® and Microsoft® RemoteApp virtualised apps and desktops to serve Cradle WorkBench, and other Cradle utilities to their local and remote workers.  But what if you’re remote and your company doesn’t use these distribution technologies? What are your options for remotely connecting to a Cradle server?

There are a number of methods which we have assisted customers in deploying to allow their remote workers access to a central Cradle system.

VPN – Virtual Private Network

Virtual private networks provide a link from the remote hosts to the network where the CDS lives and we can talk directly to the CDS over this connection. VPN can provide host to network, and network to network communications. Authenticating and encrypting VPN links provide security over the internet.

This is the preferred method between sites, or dedicated remote workers, as most customers already have VPN technologies in place and this provides the least restrictions and requires little additional configuration of the Cradle server.

NAT – Network Address Translation

This is where we remap one IP address space to another IP address space.  What this gives us is the ability of a gateway or firewall to route Cradle communications to a CDS behind the firewall.  This can expose the Cradle server to unwanted external traffic if the firewall rules are not carefully locked down.

SSH Tunnels  – Secure Shell for Unix and Linux hosts

Part of this protocol is the ability to map local IP ports to remote IP hosts and ports beyond the remote SSH host. We can use this to direct Cradle communications to the CDS.

You may not wish to expose the Cradle server using NAT as it can open it up to potential hostile traffic, but you don’t want to go down the route of a full VPN solution.  SSH tunnels fulfils this need.

In future blogs, we’ll be going through some of these options in more detail for Cradle specific installations.