> For the complete documentation index, see [llms.txt](https://help.pesipiuma.app/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.pesipiuma.app/en/using-pesipiuma/using-the-importers/lectra-modaris.md).

# Lectra - Modaris

Use the importer for Lectra - Modaris

## 1. Prepare the data using Lectra Modaris

### Extract the piece sections

* Open the model in Modaris and select the first piece to start from. In the following example the BACK piece.

<figure><img src="https://1466117825-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkPY8JSef9JxWbQFz10MA%2Fuploads%2Fgit-blob-cb6f6d5a08d372f6c1a204027dd90ca03cb2b929%2F1-lectra-modaris-home.png?alt=media" alt=""><figcaption><p>Workspace | <strong>Modaris V6</strong></p></figcaption></figure>

* Extract the first section **starting from the bottom and moving upwards**. This order is essential for correct data export.

{% hint style="info" %}
Only by following this exact extraction order can Pesipiuma correctly import the data.
{% endhint %}

<figure><img src="https://1466117825-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkPY8JSef9JxWbQFz10MA%2Fuploads%2Fgit-blob-d0651b5f7f85bfed40bc0748f313bb76dc5e854c%2F2-lectra-modaris-estrazione.png?alt=media" alt=""><figcaption><p>Extraction starting from the lowest section of the BACK piece | <strong>Modaris V6</strong></p></figcaption></figure>

* Once all sections have been extracted they will appear in the lower right part of the workspace ordered from left to right.

<figure><img src="https://1466117825-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkPY8JSef9JxWbQFz10MA%2Fuploads%2Fgit-blob-229fd2117a4ef1f1ceb7424c45099beb577f7a92%2F3-lectra-modaris-measures.png?alt=media" alt=""><figcaption><p>Extracted sections positioned at the bottom right of the workspace | <strong>Modaris V6</strong></p></figcaption></figure>

### Retrieve the section areas

* Open the **Measures sheet** and choose **Area** from the tool palette on the right.
* Set the grid to **Horizontal** and in the *Configure* menu choose **Net Area**.

<div align="center"><img src="https://1466117825-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkPY8JSef9JxWbQFz10MA%2Fuploads%2Fgit-blob-14fddc402f8c32cd4dab7acd49e9f939f1ae2468%2F5-lectra-modaris-config.png?alt=media" alt="Measures sheet - Configure | Modaris V6"></div>

* Click the extracted sections one at a time **starting from the leftmost one** so that they are added to the **Measures sheet** in the same order.

{% hint style="info" %}
On the Modaris workspace the extracted sections are positioned at the bottom right. For a correct export proceed from the first on the left moving rightward. This keeps the order required for importing in Pesipiuma.
{% endhint %}

<figure><img src="https://1466117825-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkPY8JSef9JxWbQFz10MA%2Fuploads%2Fgit-blob-229fd2117a4ef1f1ceb7424c45099beb577f7a92%2F3-lectra-modaris-measures.png?alt=media" alt=""><figcaption><p>Select the sections of the BACK piece starting from the first extracted one | <strong>Modaris V6</strong></p></figcaption></figure>

* After adding all sections to the Measures sheet you will get a table with the areas listed from the first section at the top. **This order allows correct import in Pesipiuma**. If the model is graded the sheet will also contain the measurements for all sizes.

![Areas of the BACK sections shown in the Measures sheet | Modaris V6](https://1466117825-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkPY8JSef9JxWbQFz10MA%2Fuploads%2Fgit-blob-d1ac447b9214f2437b798bf04ad6837df1470f7d%2F6-lectra-modaris-export.png?alt=media)

### Export the data

* Choose **Print/Export file** from the menu and select **Export Data File** (Modaris **V6** and **V7**) or **Text file** (Modaris **V8**) depending on the version in use.
* Select the destination on your computer and type the file name following these rules based on the *Modaris version*:
  1. **For Modaris V6 or V7:** the name must explicitly include the **.xls** extension
  2. **For later versions:** the name must explicitly include the **.csv** extension

{% hint style="success" %}
At this stage you can also manage the *quantity* of the pieces by adding the pound sign (**`#`**) to the .xls or .csv file name. For example, importing a file named **front#2.xls** will assign a quantity of **2** to the **front** piece.
{% endhint %}

{% hint style="info" %}
An Excel compatibility error may appear. Simply ignore it and continue saving the **.xls** or **.csv** file.
{% endhint %}

* Repeat these operations for all pieces to be padded, always **respecting the bottom-to-top extraction order**. When finished you will have as many **.xls** (or **.csv**) files as there are pieces.

### Examples

#### Example: Excel file exported from Modaris V6 in .xls format

In this example exported from Modaris V6 the first row contains the size names. Use the **Lectra v6** importer when importing this file into Pesipiuma.

![Example of Excel file resulting from exporting the BACK piece | Modaris V6](https://1466117825-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkPY8JSef9JxWbQFz10MA%2Fuploads%2Fgit-blob-3cbb6ca0eeccee74b4aede22318b2ad2cdfeb8ea%2F7-lectra-modaris-xls.png?alt=media)

#### Example: Excel view of the file exported from Modaris V8 in .csv format

In this example exported from Modaris V8 the size names start on row 6. Use the **Lectra v8** importer when importing this file into Pesipiuma.

<figure><img src="https://1466117825-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkPY8JSef9JxWbQFz10MA%2Fuploads%2Fgit-blob-d8cb3d7bd14371cb8841742578f4952b7f4b6d82%2F8-lectra-modaris-v8.png?alt=media" alt=""><figcaption><p>Example of file resulting from exporting the BACK piece | <strong>Modaris V8</strong></p></figcaption></figure>

## 2. Import the data generated by Lectra Modaris into Pesipiuma

{% hint style="info" %}
The active importers in the workspace are the ones included in the subscribed plan. If you need to add **Lectra v6** or **Lectra v8**, contact support; for Business or Enterprise plans, contact your system administrator.
{% endhint %}

1. Open the project [Editor](/en/using-pesipiuma/introduction/report-editor.md).
2. Click **Import Excel** for an empty project, or **Replace Excel** for an existing Excel project.
3. In the **Excel files** area, select **Lectra v6** or **Lectra v8** from the importer menu.
4. Drop the exported files into the upload area or click to select them.
5. Optionally add a report image in the **Image** area.
6. Click **Preview**.
7. In the **Excel Preview**, check the header preview and select the base size.
8. Click **Confirm** in the preview.
9. Click **Import**.

The Lectra importer expects one file per piece. Supported formats are **.xls**, **.xlsx**, and **.csv**.

{% hint style="success" %}
The quantity can be included in the file name by adding **`#`** followed by the quantity. For example, importing **front#2.xls** creates the **front** piece with quantity **2**.
{% endhint %}

After import, Pesipiuma creates the sizes, pieces, and sections in the editor. The default coefficient is `100`, the default quantity is read from the file name, and rounding defaults to the tenth of a gram.

At this point you can [edit](/en/using-pesipiuma/preliminary-operations/manage-pieces.md#edit-a-piece) quantities, coefficients, section notes, and rounding if needed.

For Excel reports, add or replace the [report image](/en/using-pesipiuma/create-a-report/upload-an-image.md) and [position the labels](/en/using-pesipiuma/create-a-report/place-report-labels.md) before opening the report.

{% hint style="warning" %}
An Excel project cannot be switched to DXF import. Create a new project if you need to use DXF/RUL files instead.
{% endhint %}

{% content-ref url="/pages/dwRnLNLrTOzI7ambwR0Y" %}
[Place the Labels](/en/using-pesipiuma/create-a-report/place-report-labels.md)
{% endcontent-ref %}

{% content-ref url="/pages/lMXLgMIS6m3k9lH91cbo" %}
[Report Image](/en/using-pesipiuma/create-a-report/upload-an-image.md)
{% endcontent-ref %}

{% content-ref url="/pages/93DzN6ftRmV81jSUN8xN" %}
[Create a Report](/en/using-pesipiuma/create-a-report.md)
{% endcontent-ref %}