Is there a possible way to copy/import the drawlist from the drawlist management form to excel and export it back to E3D from excel.
Is there a possible way to copy/import the drawlist from the drawlist management form to excel and export it back to E3D from excel.
Hello,
As far as I know, it is not possible to import / export the contents of the Drawlist management form to Excel.
Your drawlist data are stored under an IDLI element in the Draw Explorer.
Type GOTO IDLNAME in the Command Window while your View is CE to see the IDLI associated with your view.
You can output the ADDE elements and REME elements under the IDLI element as a DB list text file
You can import this DB list text file back to AVEVA Draw on an empty IDLI.
It is possible to develop a custom PML macro form to allow the user to export and import Excel files instead of working with DB list text files.
You can generate a report for exporting drawlist members.
For importing, you can apply some pdms commands and excel formulas within the excel which can be copied and run as macro in Draw module
Thanks for your responses... Appreciated your guidence...
Could you please elaborate what commands and how it is to be done with PDMS command and excel formula
in excel, finalise the drawlist in a column including both ADD & REM elements. Then use concatenate formula by appending ADD or REM to prepare the macro.