AnsweredAssumed Answered

PDM API SaveToCSV Config Issues

Question asked by Corey Meyer on Dec 17, 2020
Latest reply on Dec 21, 2020 by Corey Meyer

Like • Show 0 Likes0
Comment • 2

I'm trying to save a csv of a PDM BOM using the SaveToCSV() method in C#.

I select the config using this code:

bomView = (IEdmBomView3)aFile.GetComputedBOM(ppoRetLayout.mbsLayoutName, 0, Config, asBuiltId + (int)EdmBomFlag.EdmBf_ShowSelected);

Let's say in this case the Config name is "Config1".

I then save this bomView to csv.

bomView.SaveToCSV("c:\\temp\\SavedBOM.csv", false);

As far as I can tell, this creates a BOM from the default config, not the "config1" config.

The only difference is the "config1" has a pattern of several of the assemblies.

Clicking the "Save CSV" from within the vault in windows explorer creates a CSV with the expected values.

The SaveToCSV() method creates a file with only one of the assembly.

Is this a bug in PDM? I would hope the CSV generated from the file browser interface would make one from a program API call, but this appears to not be the case.

No one else has this question

Outcomes

2 Replies

Amen Allah Jlili Dec 19, 2020 5:15 PM
Mark Correct
Correct Answer
Corey,

So If I understand you correctly, the issue is related the configuration parameter in GetComputedBOM ?
Can you provide us with a minimal viable example (code + CAD files) so we can try to replicate this issue on our ends?

Best,
Amen
SOLIDWORKS PDM API Programming services
Like • Show 0 Likes0
Actions
- Corey Meyer @ Amen Allah Jlili on Dec 21, 2020 9:33 AM
  Mark Correct
  Correct Answer
  This is the complete code I am using
  using EPDM.Interop.epdm;
  using Microsoft.VisualBasic;
  using System;
  using System.Collections.Generic;
  using System.Diagnostics;
  using System.Linq;
  using System.Text;
  using System.Threading.Tasks;
  
  namespace PDMTesting
  {
      class Program
      {
          static private IEdmVault5 vault1 = null;
          static IEdmFile7 aFile;
          static IEdmBom bom;
          static IEdmBomMgr bomMgr;
          static IEdmBomView3 bomView;
          static void Main(string[] args)
          {
              GetBom();
              SaveBom();
          }
  
          private static void GetBom()
          {
              try
              {
                  IEdmVault7 vault2 = null;
                  if (vault1 == null)
                  {
                      vault1 = new EdmVault5();
                  }
                  vault2 = (IEdmVault9)vault1;
                  if (!vault1.IsLoggedIn)
                  {
                      LoadVault();
                  }
  
                  if (aFile != null)
                  {
                      // Get named BOMs and their versions for the selected file
                      EdmBomInfo[] derivedBOMs = null;
                      aFile.GetDerivedBOMs(out derivedBOMs);
  
                      // Get a BOM view with the specified layout
                      bomMgr = (IEdmBomMgr)vault2.CreateUtility(EdmUtility.EdmUtil_BomMgr);
                      EdmBomLayout[] ppoRetLayouts = null;
                      EdmBomLayout ppoRetLayout = default(EdmBomLayout);
                      bomMgr.GetBomLayouts(out ppoRetLayouts);
                      bomView = (IEdmBomView3)aFile.GetComputedBOM("BOM", 0, "For Ebom", (int)EdmBomFlag.EdmBf_AsBuilt + (int)EdmBomFlag.EdmBf_ShowSelected);
  
                  }
              }
              catch (System.Runtime.InteropServices.COMException ex)
              {
                  Console.WriteLine("HRESULT = 0x" + ex.ErrorCode.ToString("X") + " " + ex.Message);
              }
              catch (Exception ex)
              {
                  Console.WriteLine(ex.Message);
              }
          }
  
          static void LoadVault()
          {
              IEdmVault7 vault2 = null;
              if (vault1 == null)
              {
                  vault1 = new EdmVault5();
              }
              vault2 = (IEdmVault7)vault1;
  
              if (!vault1.IsLoggedIn)
              {
                  vault1.LoginAuto("TTX", Process.GetCurrentProcess().MainWindowHandle.ToInt32());
              }
              IEdmFolder5 ppoRetParentFolder;
  
              aFile = (IEdmFile7)vault1.GetFileFromPath(@"{FilePath}.SLDASM", out ppoRetParentFolder);
  
          }
  
          static void SaveBom()
          {
              try
              {
                  IEdmVault7 vault2 = null;
                  if (vault1 == null)
                  {
                      vault1 = new EdmVault5();
                  }
                  vault2 = (IEdmVault9)vault1;
                  if (!vault1.IsLoggedIn)
                  {
                      LoadVault();
                  }
  
                  if ((aFile != null) & (bomView != null))
                  {
                      bomView.SaveToCSV("c:\\temp\\SavedBOM_Wrong.csv", false);
  
                  }
              }
              catch (System.Runtime.InteropServices.COMException ex)
              {
                  Console.WriteLine("HRESULT = 0x" + ex.ErrorCode.ToString("X") + " " + ex.Message);
              }
              catch (Exception ex)
              {
                  Console.WriteLine(ex.Message);
              }
          }
      }
  }
  The config it is supposed to be pull is "For Ebom". The text below is the BOM result I gets first line, with "Default" selected (with some info redacted).
  File Name,SW Part Number,CustomProp Part Number,Material Number,Qty,Description,Revision,Length,Width,Area,Notes,Configuration,State,Found In
  {File}.SLDASM,{FileName},{FileName},,1,{{FileDesc},,,,,,Default,Work in Progress
  It does not seem tied to the actual file, as when we check out and check back in the file with no changes and it makes a new revision then it seems to pull the correct file again. So running this code after a revision is made will pull the correct config and BOM data.
  Like • Show 0 Likes0
  Actions

PDM API SaveToCSV Config Issues

Outcomes

Related Content

Recommended Content