Hello EBDN Community,

I hope youll doing well

i had a bug please tell to resolve it , or the code snippets which then i can implement in my code any resources which can help me to solve this problem kindly send it to this
This email address is being protected from spambots. You need JavaScript enabled to view it.

or here in the EBDN

I have explained the requirement clearly, unambiguously, and technically.

Below is a clean, professional, step-by-step requirement description written exactly based on:

# 📌 Requirement: Catalog-based Material Selection During Device Generation

## Environment

* **Software**: AUCOTEC Engineering Base (Plant Engineering)
* **Context**: Device generation via custom Assistant / Plug-in (Excel-based generation)
* **Catalog Used**: Standard Catalog

---

## 1. Catalog Structure (MANDATORY)

The catalog is structured as follows:

```
Standard catalog
└─ Materials
└─ Microfinish
├─ XYZ-90
├─ XYZ-89
├─ XYZ-91
```

* `XYZ-90`, `XYZ-89`, `XYZ-91`, are Material catalog entries
* These are not device templates and not FG-based functions
* Each entry represents a material option

---

## 2. Generated Device Attribute

Each generated device already contains the attribute:

```
Purchase Order Data → Material
```

* Attribute name: Material
* Attribute type: Text
* Attribute exists on the device before generation

---

## 3. Required Program Behavior

During device generation (from Excel):

1. The program generates the device (but does NOT store it immediately).
2. The program checks whether the generated device contains the Material attribute.
3. If the attribute exists:

The program must **ask the user to select a material**.
4. The selection dialog must:

Show **ONLY** material entries from
`Standard catalog → Materials → Microfinish`
Example list:

```
XY
XYZ-89
3
```
* **No FG names**
* **No device types**
* **No control-valve / valve entries**
5. The user selects **one material** from the list.
6. The selected value is assigned to:

```
Generated Device → Purchase Order Data → Material
```
7. Only after material selection, the device is stored.

---

## 4. What Must NOT Happen

The following behaviors are **NOT acceptable**:

* ❌ Showing device types like
`Valve, Control-Valve (Process / Fluid)`
* ❌ Showing FG-based templates
* ❌ Showing catalog functions
* ❌ Allowing free-text manual material entry
* ❌ Assigning material after generation is complete
* ❌ Copying attributes instead of values

---

## 5. Timing Requirement (VERY IMPORTANT)

* Material selection must happen **during generation**, not after.
* Progress dialog may pause while the selection dialog is open.
* This is expected and acceptable behavior.



## 6. Expected Result (Final)

After generation:

```
Generated Device
└─ Purchase Order Data
└─ Material = XYZ-91 (or XYZ-89 / XYZ-90)


No manual correction required
Material value is catalog-controlled
Fully consistent with EB best practices

7. One-Line Summary (for EBDN)

> “During Excel-based device generation, the assistant must prompt the user to select a material from Standard Catalog → Materials → Microfinish(folder), and assign the selected catalog material value to the generated device’s Material attribute before storing the device.”*


Kindly help me to resolve these

if any one has code snippets or have codes , resources , already worked in this situation kindly send that to me

Thank you
Darshan B G
This email address is being protected from spambots. You need JavaScript enabled to view it.

Dear Community,

I was using the below code of Worksheet Management (aucOpExecInsertWorksheet) in 2025 EB Version , but showing some issues , can anyone kindly check it and let me know the solutions or any updated code related to this kindly let me know

The Code Page link : https://ebdn.aucotec.com/index.php?option=com_content&view=article&id=11600:x181207145704z889&catid=2748&Itemid=1607

Sheet Operations
ebdn Reference WoksheetManagement 22 March 2023
aucOpExecInsertWorksheet
Full Qualified Name
aucOpExecInsertWorksheet

Description

The operation creates a new worksheet on a Visio sheet for a given start object.


Argument


Datatype


In/Out


Optional


Description


aucArgExecSheetRef2Obj


OID


In


OID of the worksheet configuration


aucArgExecSheetRef2Sheet


OID


In


OID of the AO start object, on which the Worksheet will be opened


aucArgExecSheetPosX


integer

long

single

double


In


X


Worksheet position in X; units of measure: mm


aucArgExecSheetPosY


integer

long

single

double


In


X


Worksheet position in Y; units of measure: mm


aucArgExecSheetRelX


integer

long

single

double


In


X


Worksheet width, not yet implemented


aucArgExecSheetRelY


integer

long

single

double


In


X


Worksheet height, not yet implemented


aucArgExecSheetRetVal


OID (string)


In


X


Has to be the final argument! Returns the DO-OID of the created worksheet

Dear Community,

I was using the below code of Worksheet Management (aucOpExecInsertWorksheet) in 2025 EB Version , but showing some issues , can anyone kindly check it and let me know the solutions or any updated code related to this kindly let me know

The Code Page link : https://ebdn.aucotec.com/index.php?option=com_content&view=article&id=11600:x181207145704z889&catid=2748&Itemid=1607

Sheet Operations
ebdn Reference WoksheetManagement 22 March 2023
aucOpExecInsertWorksheet
Full Qualified Name
aucOpExecInsertWorksheet

Description

The operation creates a new worksheet on a Visio sheet for a given start object.


Argument


Datatype


In/Out


Optional


Description


aucArgExecSheetRef2Obj


OID


In


OID of the worksheet configuration


aucArgExecSheetRef2Sheet


OID


In


OID of the AO start object, on which the Worksheet will be opened


aucArgExecSheetPosX


integer

long

single

double


In


X


Worksheet position in X; units of measure: mm


aucArgExecSheetPosY


integer

long

single

double


In


X


Worksheet position in Y; units of measure: mm


aucArgExecSheetRelX


integer

long

single

double


In


X


Worksheet width, not yet implemented


aucArgExecSheetRelY


integer

long

single

double


In


X


Worksheet height, not yet implemented


aucArgExecSheetRetVal


OID (string)


In


X


Has to be the final argument! Returns the DO-OID of the created worksheet