Importing Part Data

Table of contents

• Mapping Data
• Adding a stage
• Import Options
• Attributes Explanation

The Import Manager supports you when importing part data. It allows you to use your own column titles as attributes for ipolog 4, but these must first be assigned. To do this, go to Common Data and select the desired planning state of your part data.

Then select “Import part data”:

A window opens. Select the desired import file here. How the file is formatted is explained here.

Please note: The file must be in “.xlsx” format and has to be located on your PC locally.

Next, select the spreadsheet that contains your data and which row in your file is the header row. The header row contains the column titles/attributes.

In the following window, you can then assign the columns in ipolog 4 to the corresponding columns in your file. The left-hand side contains the attributes (or column titles) in ipolog 4, the right-hand side the attributes of your table:

You can use the buttons at the bottom left of the window to adjust whether already assigned attributes or everything except mandatory fields should be shown/hidden. You can also decide whether the level parameters of predecessor Log-IDs should be passed on to successor Log-IDs if there is exactly one predecessor.

Mapping Data

"Mapping" your data means, that you can link the existing data in your import file to the data in ipolog 4 in order to use it in the program:

On the left-hand side, we see the attributes of ipolog 4 and different symbols in front of them.

In the first column we see “Name” and in front of it the “red exclamation mark” symbol. This stands for a mandatory field that has not yet been assigned.

Below this we see the attribute “Supplier” and a “gray check mark” symbol in front of it. This stands for an optional field that has already been automatically assigned (because it has the exact same name in our table or has been assigned before).

In third place is the attribute “Supplier article number” and a “gray exclamation mark” symbol. This means that this optional field and has not yet been assigned.

Finally, we see the attribute “Supply rate (%)” and a “green checkmark” symbol, because this mandatory field has already been successfully assigned to a column in our import file.

To fill the data fields, left-click on “Select field” or an existing attribute on the right-hand side to edit it and select a suitable attribute from your imported table:

Adding a stage

In addition to the existing attribute groups, more can be added by selecting “+ Add stage”. The stages can be used to reflect the stage processes in your planning space:

Please note: By assigning the attributes "Layout level", "Station" and "Area" to columns in your import file, it is possible to horizontally filter your part data to use it in different parts of your project. Not assigning your part data to these attributes results in the parts being stored in the "reservoir area" in your project.

Import Options

After you have linked the data from your import file with ipolog, you can determine how the imported data should be handled in the next step:

Please note: Select the same formatting at "Specify number format for unformatted cells" as it is in the excel file you try to import. If your numbers are separated from their decimals with a dot, select "Dot as decimal separator" here.

You can also select the synchronization manager for the option “Import and overwrite existing planning state data with the new data from file”. This allows you to select for each attribute individually whether you want to overwrite existing data or only import the data if the attribute is still missing:

Attributes Explanation