AnsweredAssumed Answered

Scripting and iCDBPartsLister.exe

Question asked by andrew_french on Nov 14, 2013
Latest reply on Dec 2, 2013 by andrew_french

My engineers have about 20 different (slight exageration) BOM outputs they want to see from DxDesigner.  Using the corporate WDIR I can control only one default ipl file so my solution is to create custom scripts available in my own drop down menu in DxDesigner that are preconfigured for specific outputs using icdbPartsLister.exe and the appropriate flags.

 

The issue I am having is when I try to specify the output file's name when the ipl file is configured to output an excel file.  I cannot get this to work for the life of me but I am having no problems when the output is a plain text file.  Has anyone else experienced this?  Is this a known bug or am I doing something silly?

 

Thanks for your time.

 

Option Explicit

dim WshShell, vdapp, vdpd, prjPath, prjFilePath, SDDHOME, WDIRPath, boardName, command

 

set vdapp = GetObject(,"ViewDraw.Application")

 

set vdpd = vdapp.GetProjectData

 

prjPath = vdpd.GetProjectPath

 

prjFilePath = vdpd.GetProjectFilePath

 

WDIRPath = \\Some\network\location\wdir

 

boardName = VdApp.ActiveView.GetTopLevelDesignName

 

set WshShell = CreateObject("WScript.Shell")

 

SDDHOME = WshShell.ExpandEnvironmentStrings("%SDD_HOME%")

 

command = SDDHOME & "\wv\win32\bin\icdbPartsLister.exe -prj=" & chr(34) & prjFilePath & chr(34) & " -board=" & boardName & " -cfg=" & chr(34) & WDIRPath & "\PartsLister\someiplfile.ipl -out=" & chr(34) & prjPath & "\configuredBOM.xlsx" & chr(34)

 

WshShell.Run command, , TRUE

Outcomes