Export

Exports from Linetrack: PDF, MS Project, Primavera, Excel.

Not everyone who needs to see a plan works in Linetrack. The customer wants a PDF for the status meeting, their scheduler a file for MS Project or Primavera P6, controlling the utilisation in Excel. Linetrack produces these files from the views you plan in anyway. Whatever has to flow into another system on a regular basis is collected by the REST API.

Ready-made connectionPDF from Gantt and resourcesMS Project XML and Primavera XMLExcel with a native chart

In short

Linetrack exports project and portfolio Gantt charts as well as the resource and team views as PDF, project plans as MS Project XML (MSPDI) or Primavera XML (PMXML), and utilisation per resource group as an Excel file with a native chart. The exports are part of the product and start in the view concerned, project plans also from archived projects. For projects, tasks, planned hours and KPIs in other systems there are the REST API and the KPI API.

Formats

Which view goes out as which file

Every export starts where the current status is already on screen. You choose format and options, Linetrack creates the file. The conversion to MS Project and Primavera runs on our own servers, not at a service provider.

PDFProject

Project Gantt as PDF

For customer meetings and the project file. You set title and period, add your company logo and decide whether progress, critical path, resource diagram and today line appear on the sheet. For sending by email, a smaller file can be produced.

  • Title
  • Period
  • Company logo
  • Progress
  • Critical path
  • Resource diagram
  • Today line
  • Smaller file

Where in Linetrack: project Gantt → "Export as" → PDF

PDFPortfolio

Portfolio Gantt as PDF

All projects of a portfolio on one sheet, for management or the sales meeting. If you wish, Linetrack colours the bars by maturity, so the status of each project can be read from the colour.

  • Portfolio
  • Period
  • Colouring by maturity
  • Company logo
  • Today line
PDFResources

Utilisation and assignments as PDF

The resource view ("Auslastung") shows how fully employees and groups are booked, the team view ("Belegung") who is planned for what. Both go out as PDF, for example for the installation team's weekly meeting or the notice board in the workshop.

  • Resource view ("Auslastung")
  • Team view ("Belegung")
  • Period
  • Title
  • Company logo
XMLSchedule

MS Project and Primavera P6

From any project Gantt, including that of an archived project, Linetrack produces MS Project XML (MSPDI) or Primavera XML (PMXML). Structure, summary tasks, milestones, dates, durations in working days, relationships with lags and the project calendar are included, descriptions come along as notes.

  • MSPDI
  • PMXML
  • Archived projects
  • Project calendar
  • Notes

Where in Linetrack: project Gantt → "Export as"

ExcelKPIs

Utilisation per resource group as .xlsx

The widget in the KPI dashboard writes net capacity, planned hours per project, other, total and shortfall into a table, month by month. Next to it sits a native Excel chart that can be edited further in Excel, in German or English.

  • Net capacity
  • Hours per project
  • Other
  • Total
  • Shortfall
  • DE / EN

Where in Linetrack: KPI dashboard → "Auslastung je Ressourcengruppe"

API

Everything else through the API

Where a file is not enough, another system reads the data directly. Projects, tasks and planned hours per task and resource come through the REST API, KPIs such as completion, traffic light and schedule adherence through the KPI API. That is how they reach Power BI, the ERP or a report of your own.

  • Projects
  • Tasks
  • Planned hours
  • KPIs
  • X-API-KEY

What this makes possible

Who gets which file on their desk

Status meeting at the customer

The evening before the status meeting the project manager exports the project Gantt for the next three months as a PDF, with logo, critical path and today line. When the customer asks about the FAT date the next day, the critical path on the printout shows what it depends on.

Installation week on the board

Every Friday the installation manager prints the fitters' assignments for the coming two weeks. Who is on site at which customer hangs on the board in the hall, readable for colleagues without a Linetrack login too.

Portfolio at the management meeting

For the monthly meeting with management, the head of project management pulls the portfolio Gantt as a PDF, coloured by maturity. One sheet shows which orders overlap in the second quarter.

The customer wants an MS Project file

A customer in automotive supply keeps its suppliers' plans in MS Project. The project manager exports the plan as MS Project XML, and the customer opens it with calendar and dependencies and attaches it to the overall plan.

A slide for the advisory board

Controlling receives utilisation per resource group as .xlsx and builds the slide for the advisory board meeting from it. Because the chart is a real Excel chart, they adjust colours and labels themselves instead of asking for a new screenshot.

Planned hours for post-calculation

Cost estimating wants to know how many hours were planned per task and resource, to compare them with the actual times in the ERP. Instead of a list by email, the ERP collects the planned hours through the REST API, for every order and line item.

How it works

How the file comes about

  1. 1

    Open the view

    Depending on what needs to go out, you open the project or portfolio Gantt, the resource or team view, or the KPI dashboard.

  2. 2

    Choose format and options

    In the project Gantt you choose PDF, Microsoft Project or Primavera P6 under "Export as". For a PDF you set period, title, logo and the elements on the sheet.

  3. 3

    Pass it on

    The file goes to the customer, into the project file or to controlling. If the same evaluation is needed every month, a connection through the API serves you better than sending files.

Practical examples

How do plant builders, building services contractors and conveyor manufacturers use Linetrack exports in practice?

From Linetrack you export what the recipient can read or process further: PDF for dates and meetings, MS Project XML or Primavera XML for the schedulers of customers and general contractors, Excel for capacity planning and controlling. Three typical scenarios from plant engineering, building services and conveyor technology show what that looks like.

Plant engineering with customer-mandated scheduling

Monthly schedule in Primavera format for the operator

Starting point
A plant builder is erecting a process plant for an operator. The supply contract requires the contractor to deliver its schedule every month in a form the operator's schedulers can hang into the site master plan in Primavera P6. Until now the project manager rebuilt the plan for this in a separate file each month.
How Linetrack is used
The project manager keeps planning in the project Gantt in Linetrack and, on the reporting date, chooses “Export as” and Primavera P6. The file arrives as Primavera XML (PMXML) with structure, summary tasks, milestones, relationships including lags and the project calendar. The tasks carry readable activity IDs and a “Linetrack ID” field, so the operator's scheduler can match each task to the project manager's plan. Tasks that do not have a date yet are marked [UNGEPLANT] in the file.
Result
The plan is no longer maintained in a second tool alongside. The operator gets the file in the agreed format, and the project manager has a single planning source.
MS Project and Primavera in Linetrack →
Building services (TGA) on large construction sites

One plan, two recipients: general contractor and site management

Starting point
A building services contractor installs electrical, ventilation and building automation systems on a large construction site. The general contractor keeps the master schedule in MS Project and wants to find the trades' dates there, together with their dependencies. For the site management's progress meeting the project manager also needs a sheet on which commissioning and acceptance can be followed.
How Linetrack is used
The project manager exports the project Gantt as MS Project XML (MSPDI). Structure, summary tasks and milestones come along, plus durations in working days, the relationships with their lags and the project calendar with holidays and exceptions. Task descriptions arrive as notes. The general contractor's scheduler opens the file directly in MS Project. For the progress meeting the project manager pulls the same Gantt as a PDF with progress and critical path and emails the smaller file version.
Result
The general contractor works with the contractor's dates without anyone retyping them, and the lags ahead of acceptance are the same there as in Linetrack. The progress meeting runs on one sheet showing the current status.
Linetrack for building and energy services →
Conveyor technology for airports and logistics centres

Shutdown window, acceptance and utilisation of the commissioning engineers

Starting point
A conveyor manufacturer is extending a sorting system in a logistics centre, and the conversion may only take place within a fixed operating shutdown. The customer's operations management wants to know whether the dates for installation, commissioning and site acceptance test (SAT) will hold. At the same time several plants are running at the manufacturer, and the same commissioning engineers appear in the plans of several projects.
How Linetrack is used
For operations management, the project manager sets the period around the shutdown in the PDF export of the plant's Gantt and sends the smaller file version with the critical path. The head of commissioning exports utilisation per resource group from the KPI dashboard as .xlsx. The table shows net capacity, planned hours per project and shortfall month by month, and it can be filtered in Excel and compared with the order book.
Result
Before the shutdown the customer can see what its dates depend on. Internally the shortfall column shows in which month the commissioning engineers fall short across several plants, before a project slips.
Linetrack for mechanical and plant engineering →

Examples without a reference label describe typical workflows in the respective industry and therefore name no company.

FAQ

Frequently asked questions

Any questions?

Book a call with our team.

Can archived projects be exported too?

Yes. Export as MS Project XML and Primavera XML is also available for archived projects, for example for the plant documentation after acceptance.

Is there an export as .mpp or .xer?

Linetrack exports the XML formats: MS Project XML (MSPDI) and Primavera XML (PMXML). MS Project opens MS Project XML directly, Primavera P6 reads PMXML through its import. For importing, Linetrack also reads .mpp and .xer.

Where is the file for MS Project and Primavera produced?

On Linetrack's own infrastructure. The project plan is not handed to an external export service for the conversion.

Can controlling work with the utilisation figures in Excel?

Yes. The "Auslastung je Ressourcengruppe" widget delivers an .xlsx file with a data table and a native Excel chart. Table and chart can be edited, filtered and copied into your own reports in Excel.

The platforms and brands mentioned belong to their respective owners. Mentioning them describes the technical connection and does not imply a partnership or certification.