Attributes-to-Sap for Excel

[nkara]

Hello everyone,

In our excel documents that we upload to the ECTR system, can we match some data from defined fixed cells in Excel as characteristics and pull them to ECTR, that is, SAP. Just like we pull CATIA parameters to ECTR by mapping, I need to pull some standard data in Excel instantly.

Thank you for your support

Nazif Kara

[GerhardHimmelsb]

Hello Nazif,

did you have a look at the user guide?

https://help.sap.com/doc/32350f9b9d0a450380c163003c034667/1.2/en-US/User_Guide_EN.pdf 

Does this help?

Regards,

Gerhard Himmelsbach

- Product Manager SAP ECTR - 

[nkara]

 Hello Gerhard,

I am using ECTR version 1.1.7.4.

This resource unfortunately does not meet my needs.

For example, I need a resource like the one below. There are Customizing.pdfs for Catia or Solidworks.

But I could not find such a resource for Excel.

Regards

Nazif Kara

4.3 Mapping Settings in the SAP Engineering Control Center Interface to

CATIA V5

Similar to the settings for mapping data from SAP Engineering Control Center to the

integration SAP Engineering Control Center to CATIA V5, the settings for mapping from CATIA

V5 into SAP can be found in the file attributes-to-sap.xml. In the example below you can see

how the data mapping needs to be defined. Any feature within the xml syntax, apart from

special keywords for the CATIA integration which are described here, can be found in the

operations guide of ECTR.

In the example below you can see, how CATIA values are mapped to SAP, e.g.

Classification:

<section name="CAT_PR" description="Product mapping from CATIA to ←-

,→ SAP">

<DIR field="Description">

<APPL_ATTRIBUTE name="S-Description "/>

</DIR>

<DIR_CLS class="Z_CENIT" classtype="017" characteristic="←-

,→ KUNDENNAME">

<APPL_ATTRIBUTE name="P-Kundenname"/>

</DIR_CLS>

<DIR_CLS class="Z_CENIT" classtype="017" characteristic="←-

,→ WindowsUser">

<APPL_ATTRIBUTE name="E-Username"/>

</DIR_CLS>

<DIR_CLS class="Z_CENIT" classtype="017" characteristic="←-

,→ PartDefault">

<APPL_ATTRIBUTE name="U-Standard"/>

</DIR_CLS>

</section>

[GerhardHimmelsb]

Hello Nazif, the EXCEL attribute exchange (file properties to SAP metadata fields) works different than the exchange for CAD tools. Can you describe in more detail what you would like to achieve? I haven't understood this yet. Regards, Gerhard

[nkara]

Hello Gerhard,

Exactly what I am trying to do is as in the picture.

Best regards

Nazif Kara