Hello
Under SW I have an assembly containing x parts referenced under epdm
Each room has a data card with a variable ERP number field.
I have an exel file with the ERP N° field filled in for all these documents.
How do I pass the ERP number parameter in each room?
I don't have admin rights!
Hello
You can do it in macro. Do you have any knowledge?
In SW or VBA macro?
In the 2 cases little knowledge but I can try if not too complicated
Hello
MyPDM tools is only possible in admin with us.
I was looking for something + simple.
If the ERP field is recoverable in a BOM, you can insert a name with a column for this field. (insert / table / nomenclature then you add your ERP code field if it is not in your default nomenclatures)
If your parts are checked out, you can change the property by double-clicking on the BOM box inserted in your 3d assembly (or MEP) and SW updates the property in the part.
If you have a way to sort your SW nomenclature and your excel file on the same column (plan number for example) you are in the same order so it can go quite quickly at the copy/paste level.
I just tried under SW 2014: you can copy / paste multi box if you have the same number of cells selected in SW and excel. So if you manage to make an exact sorting the manipulation is done in 2 clicks :-)
Without admin rights you will be able to do a lot else otherwise I think.
Hello
Attached is a corresponding snippet of code for excel. Works on files only if you have edit rights to the state the selected file is in.
Hello
Thank you for your answers.
The simplest is the froussel one, which does not require external software (admin rights) or macros to test. On the other hand, I didn't think that the SW --> epdm link was so simple.
Anyone with a cut and paste modifies Plan No., Designation, Counter...
Hello
The SW --> Epdm link is indeed quite simple but to say that anyone can modify the values of the variables ...
The security side is managed on the Epdm side and, depending on the settings and the rights given to users and/or groups, it is easy to ensure that no more variables can be modified without respecting a certain process, so the values modified in SW may not be taken into account when the file is archived in Epdm.
Kind regards.