Video: How to transfer a Construction Project from Primavera to Tilos? – 20min Tutorial

This video tutorial shows how to transfer an existing project schedule created in Primavera P6 to a Time Location Diagram in TILOS. The TILOS Exchange Software is used. 20min to invest for a better understanding of the concept and the how to do.

Direct Link to the video: http://youtu.be/AWLbNw2KuMA

 

(1030)

What’s New in TILOS Version 8

This week we have been released the beta version of TILOS 8. Version 8 will provide the foundation for a new a new product line for linear scheduling. The most significant changes are under the surface of the application – in its software architecture, which has been completely rewritten.

We are very proud of the results:
TILOS has bigger capacity in data and it performs actions like opening projects, changing views or rescheduling up to 50 times faster than the previous version. The most plus in speed we got by generating grouped Gantt chart outputs. They now open directly after clicking due to optimized data management and overworked screen display. TILOS 8 is not only speeded up with software optimization, but also with optimized hardware usage by using multiple processor and multi thread technology.

The final release is planned for the end of January 2013. If you would like to test the new version before, please send us a email to betatest@tilos.org. We will supply a download link and an activation code to test the full functionality of TILOS 8.

TILOS Explorer changes

The explorer displays now 3 main folders to simplify the navigation:

1. Views:

In this folder you may group or sort all the different new (and old) views: Time distance views, Gantt charts views, list views generated from tasks, links, resources, micro progresses and others.

2. Project Data:

Here the entire project specific data is displayed, like distance axis informations and cell contents.

3. Library:

This folder contains base data not specifically linked to a project, such as task templates, resource and cost library.

 

 

Enhanced Grids usage

The data grids (Tables/Lists) have been completely reprogrammed. Now the grids have a more common look-and-feel and new fuctions:

  • By clicking the column header the rows get sorted by the values in this column, even in the gantt chart panel
  • With the cursor keys it is possible to navigate in the rows and columns
  • Tab key will jump to the next field in the row
  • Pulldown values can be selected by typing keys
  • The content of each data grid can be exported to the clipboard
  • In general the whole table grid can be used without mouse, only by keyboard

Cross project drag & drop in grids

Drag & Drop in Grids allows to create new lines just by copying existing lines in the same grid. You can do that also with the Shortcuts Ctrl-C and Ctrl-V.

As one of biggest enhancements in this context: It is possible to drag items (of the same grid) between parallel running TILOS Sessions. For example you may copy line styles, symbols or task templates between different TILOS files to synchronize the data in different projects. By this way: missing lower level objects gets also be copied to the destination, if needed.

Finally complete Sub-projects can be copied from one TILOS session to another: This special case replaces all data of the Sub-Project. As a result both (source and destination) content is similar. This option can be used to merge project data from different files into one file to make cross project analyzes.

Multiple sub project in same planning cell

One major benefit in project displaying of TILOS 8 is, that you have the possibility to display more than one Sub-project in the same Time-Distance-planning cell.
In combination with the new drag & drop functions for copying project data, this is very powerful new functionality: Plannings from different files or different states can be overlayed and compared.

Project controls, Baselining and Reporting

  • In previous versions, each sub project and baseline could be created with an own report date. Now the new baselines are working on file level and there is only one report date.
  • New created tasks, added after the baseline creation, now can be merged into existing baselines.
  • The dash board can be displayed in a cell of a view. The dashboard is showing the performance figures like progress actual and planned, schedule and cost performance index. The task base for the dashboard report can be set up by assigning a filter (e.g. take all welding tasks from different Sub-projects: Cross-Project Report for just one work type)
  • The task baseline values can be included in histograms to compare planned against actual values. The S-Curves then display planned quantities against actual achieved quantities, planned time against actual time, etc.

Mass Haulage Diagram

As a complete new functionality the Mass Haulage Diagrams has been added to TILOS Version 8.

This special new diagram displays all cut and fill areas and highlights the soil classes by different colors . The arrows are displaying the haulages between the cut and fill areas. These haulage lines can be created just by drawing on screen.

TILOS now provides an overwiew about the flow of material and also the transported quantities. Extractions, dump sites, stock piles are displayed in the border area of the Mass Haulage diagram.
The mass balance curve displays the balance between cut and fill calculated from the left side. Ideally this curve should be zero at the end.

The cut (blue) and fill (gold) tasks can be generated automatically from the context menu of a haulage line. The task quantity is set by the haulage quantity while duration is calculated from the work rate.
The time histograms displaying planned cut quantities per week, the summary curve displays the stock pile of the crushing zone.
The planning of big mass movements are more easy and transparent with the new functionality. It is included in the controlling concept along with TILOS.

Data Exchange

All exchange modules have been adapted to the new data structure. To shorten the number of clicks, the addon modules can now directly communicate with TILOS online. No need to create and read xml files any more, as long as both applications run on the same machine.
The XML-Exchange-Profiles can be included in the TILOS file itself.

Data exchange is now much easier and more comprehensive.

Google Earth Addon

One of the most interesting aspects of TILOS 8 is the new Google Earth add-on component. Just a couple of clicks are required to visualize your project on the globe.
We have already published that:

http://blog.tilos.org/development/tilos-version-8-contains-google-earth-integration/

 

(2613)

TILOS Version 8 contains Google Earth Integration

Linear project GmbH releases the ‘beta’ version of its linear scheduling software TILOS 8. It is a major step in the development of the software providing the foundation for a wider usage of TILOS in the future: It can handle much bigger projects and works faster. It allows merging of data from different planning phases or partners using the simple drag & drop function to consolidate sub-projects into one central file. The improved planning features of TILOS enable its usage as an analysis and visualization tool for those who still plan with Primavera or Microsoft Project Gantt Charts.

One of the most interesting aspects of TILOS 8 is the new Google Earth add-on component. Just some clicks are required to visualize your project on the globe.

The steps are:

  1. Import the paths and placemarks from Google Earth or a spreadsheet
  2. Load the schedule from TILOS
  3. Set the filters and the display criteria of what you would like to view.

The image above is showing the situation on Feb 09, 2013. The autoplay function simulates the ongoing construction process in user defined steps. The Screen is updatedevery ten seconds to show the new status on the next step. Linear tasks are displayed as lines in different colors while those being executed in one place (buildings) are displayed as symbols. The animated map provides a rough roadmap of the execution of the project for all parties.

To get more information, watch the video on how to make a Google earth visualisation:
This video ist hosted by youtube. please change to the best resolution availlable in the bottom settings bar.

If you would like to test the new TILOS Version 8 with Google Earth Integration, you may sign-up and register for our global test program. Be one of the first to try the new functions with TILOS8. Send an email to BetaTest@TILOS.org.

We intend to release the international version of TILOS 8 (English) at the end of January 2013.

(2963)

Data Exchange from CPM (Gantt-Chart) to Linear Schedule (TILOS)

TILOS is being used on many huge projects in combination with CPM based project management systems, in most cases Microsoft Project and Oracle Primavera. The initial demand from new users having planned without linear scheduling concepts in the past is: To convert the project into a linear schedule, display a time-distance-diagram (also named time location diagram).

As the projects data are rich, calendars, tasks, relationships, costs data and actuals, we recommend to use the xml based data exchange. It can exchange in both directions and opens the gate for parallel planning in different systems.

Supposing you are familiar with the program workflow how to data exchange, we concentrate here on specific options to optimize the exchange and the results:

For each of the discussed special cases, there is a sample template profile available along with the standard setup of TILOS. You can open the profiles with the profile editor.

How to set up the basic profile settings?

All profiles require:

This sample: Application 1 and Application 2 defines the programs that shout exchange data. The Checks on Calendars, tasks and Links define that these objects are transported from MS Project to TILOS.

How to get distance data into CPM schedule?

It is important to have attributes in the CPM System, that contain the placement of the tasks according to distance axis. As there is no dedicated data field for that, it need to be done based on user defined fields in the application.
In order to avoid conflicts with formats, we recommend to use a text field. This allows also to use special format like 400+00 or imperial formats like 4m 50y.
In the profile -> task Object the following settings are required and already set by default. If you use other fields, please change the Fieldname on the CPM Side (in this case: Text13 Text14 from MS Project)

During import TILOS interprets the string based on the current default display sets for the distance unit. If this is not the same as set in the CPM system, you need to change the unit before import to TILOS or set the import unit in the import parameters to a different one. Press the Button Edit right of Application 1 (TILOS) field and set up the Distance unit to apply.

How to convert sector based data into TILOS Station values?

Having no distance values in the CPM system, but sector names assigned to the schedule it is also possible to generate a location in TILOS:
In TILOS a sector table is required to match Sector name (from CPM) with coordinates.

In the CPM system you need a code assignment or text field with sector name as value (Sample: Text15). In the profile match this field with the sector name assigned in TILOS.

During import, TILOS will assign the task to the belonging sector, and displays this in tab coordinates. However, coordinates cannot be changed for that task until the sector assignment is released from the task.

How to get different colors and shapes in TILOS?

Each TILOS task refers to a task template defining color and line style. In General CPM a code library assignment or a text field contains the work type or other categories. This can be matched with TILOS templates and beginning from the first import there is a ready to display result in TILOS.

There are 2 possibilities:

How to map task template name with external data?

Use the task template name, if you have coded in the CPM system a single text field for the work type.

Using Primavera, you might link a code library. The sample matched the description of the code assignment with the TILOS field Task Template.

How to map task template ID with external data?

The TILOS template library is a structure and has UID created based on the structure level. This is the same logic Primavera uses.

In exchange profile, the template can also be transferred using the path of the code assignment to match with TILOS template.

How to transfer sub sets of data?

Considering, that the CPM schedule is huge with multi thousand tasks, it will overflow the time distance chart. We recommend to reduce the exchange data to a reasonable level, that should be displayed in TILOS.

MS-Project and ASTA Powerproject exchange the data based on VBA macros. Here only those tasks get exported, that are visible on screen in the current view applied. This means: Collapsed tasks get not exported. This enables to export only upper level activities and not the details. Similar things can be done with filter views.
Primavera exchanges the data in the Primavera API interface. Here you are able to set filters on those tasks that should be exchanged. We recommend to make a user defined field: ExportToTILOS, populate this in P6 with global change and use this field as export filter.
While MS Project allows on summary tasks, Primavera has more options: You may create task of type Level of effort and control they duration by incoming links from other tasks and export only those to TILOS. A further way is to define WBS summary tasks.

How to export code library assignments?

Additional structures can be transferred by using the TILOS categories.

This 3 types (categories, category entries, category assignments) checked also transfers the complete libraries to TILOS. See sample profile regarding setup.
In the API program filter for categories that should be exported. In that way you avoid to create big, needless data sets in TILOS.

How to export WBS code from Primavera to TILOS?

Version 8 has built in WBS code structure, so the transfer is fairly easy. In Version 7, the WBS structure is matched into a TILOS category. (Edit button right of Application 2 Primavera)

Export WBS as category: Checked option exports only WBS no code, if you want to transfer just the WBS as category library and no codes. Enter in WBS Category name the name of category library you want to assign in TILOS.
To exchange the category assignments itself, you need to exchange the category assignments also.

Primavera adds ProjectID ahead of WBS. There is option to add this during import and to remove during export.

How to exchange cost and resource data?

To exchange also cost and resource data, further options need to be applied.

There are further sample profiles with this options checked. The API program exports only those resourses, that are used on the projects.
The resource and cost assignments get simplified. Only total quantity and total cost get exchanged.

How to exchange progress information ?

To exchange progress further options need to be applied. Select in the profile editor the task attribute: Progress%.

Note, the progress can only bet transferred to tasks, that have progress model: Simple % (As CPM only reports simple %). In any other case this field gets calculated by TILOS and can’t be imported.

How to set the TASKID from CPM system in the TILOS tasks?

Each system has its own model to handle unique task ID’ s. Besides that, TILOS also has a field called GUID, that allows tasks to keep its TILOS ID and maintain the exchange ID in a further field. The GUID was invented to have a global unique ID for tasks that are exchanged between different applications, especially if multiple applications share the data exchange.

Settings for data exchange to use application ID as ID:

Application Parameter Setting
TILOS Taskidentifier TaskID
Primavera Use Global UID
as Task Identifier
No
ASTA Generate task ID by Unique TaskID
MS Project Always a GUID is created.

 

Settings for data exchange to use application GUID as ID

Application Parameter Setting
TILOS Taskidentifier GUID
Primavera Use Global UID
as Task Identifier
Yes
ASTA Generate task ID by Generate on
Export
MS Project Always a GUID is created.

Any other combination we do not recommend.

(7258)