[1.x] Process Plan - Import from Excel / MS Project

• Import from MS Project

With the release of LCM-1.2.2, the Import from Excel function is available in the project data for project admins. The possibility of preparing data in Excel or importing it from other systems means that, for example, public holidays can be quickly created in LCM Digital over several years or trades can be transferred from management systems.

Please note the order of the data in the tables listed. For the import, all information is taken over from the second line onward. Hidden rows and columns are also included in the import. Set filters are also ignored. All contents in the first row are ignored.

You can use the Excel export file of any PP as template for the PP import.

Note: Different calendars cannot be respected, all companies get the project celandar assigned. Note: Project Summary Tasks (e.g. from MS Projects) cannot be imported and need to be removed from the Excel-file beforehand. Note: After the import you get an E-Mail that states whether the import was successful. If the import has failed, the E-Mail lists the reasons, so you can adjust your file. Note: The order of columns can be freely chosen, the columns only need the distinct header given in the following table.

Necessary	Column Header	Data Type	Content
	Fragnet Step ID	-	This column has to be present for the import, but the content is noch considered .
x	Area	Text	Cannot contain more than 150 characters.
x	Subarea	Text	Cannot contain more than 150 characters.
x	Zone Type	Text	Cannot contain more than 150 characters.
x	Takt Type	Text	Cannot contain more than 150 characters. Is only allowed to exist in a single zone type/takt type-combination.
x	Takt Zone	Text	Cannot contain more than 150 characters. Is only allowed to exist in a single zone type/takt type/area/subarea-combination.
x	Trade	Text	Cannot contain more than 150 characters.
	Trade Background Color	Text	Has to be formatted as RGB(RRR,GGG,BBB).
x	Company Code	Text	Cannot contain more than 4 characters.
	Phase Code	Text	Cannot contain more than 3 characters.
	Team	Text	Cannot contain more than 150 characters. Has to be unique per trade/company/phase.
	Manpower	Integer	Has to be between 0 and 1000 (incl.).
x	Fragnet Step	Text	Cannot contain more than 150 characters. Has to be unique per trade/company/phase. The characters \/?*[] cause errors when importing and need to be removed or substitutes for import.
x	Start Date	Date	Has to be formatted as date in Excel.
(x)	End Date	Date	Has to be formatted as date in Excel. Has to be greater than the start date. Has to be filled in if the duration is empty.
(x)	Duration	Integer	If the end date is empty, this column has to be filled in. Cannot be bigger than 180
	Status	Text	Can either be "Not Started", "In Progress" or "Done". If the field is left empty, the fragnet step will receive the status "Not Started".
(x)	Actual Start Date	Date	Cannot be empty if the status is in "In Progress" or "Done". Has to be formatted as date in Excel.
(x)	Actual Finish Date	Date	Cannot be empty if the status is "Done". Has to be formatted as date in Excel.
	Fragnet Step Description	Text	Cannot contain more than 250 characters.
	Material Code	Text	Cannot contain more than 150 characters.
	Forecast Quantity	Integer
	Material Unit	Test

---

Import from MS Project

Data from MS Project can be imported into LCM Digital via an Excel export. It is important to acknowledge that LCM Digital uses a stricter structural conceptthan MS Project, so hierarchies and summary task need to be modified to be able to be imported.

Here is an example of how columns and the hierarchy structure from MS Project can be modified in the Excel file for import:

If you need assistance for importing MS Project files into LCM Digital 1.x, please contact our support. 

---