Skip to main content
B
23-Emerald III
BenLoosli23-Emerald III
23-Emerald III
February 24, 2022
Solved

Imported Family Table data

  • February 24, 2022
  • 1 reply
  • 5576 views

I have many family tables of hardware items designed in a system that is standalone and had to go through hoops to get the spreadsheet exported from excel moved to this system. I then have to rebuild my master CAD model of the parts and put the columns needed into a blank family table.

In Creo 4, I was able to cut and past the data from the exported .csv file into the family table, save it and then verify the instances with no issues.

Now on Creo 7, I do the import and the spreadsheet turns yellow background and when saved the family table is empty. Open the Excel editor and all of the data is there. It just won't update the Creo file data.

Any suggestions before I open a helpdesk call?

 

Best answer by BenLoosli

Update

CS article written: Article - CS364445 - Unable to add the Family Table instances using Edit with Excel in a specific part in Creo Parametric (ptc.com)

Bottom line is: No Plans to Fix in any release (10, 9, 8 or 7) 

Problem is part specific.

 

1 reply

M
MartinHanak24-Ruby III
24-Ruby III
February 24, 2022

Hi,

no problem on my PC ... Creo 7.0.5.0, Excel 2016

 

Test no.1

Columns in csv file separated by TAB character.

  • open family table part in Creo
  • open Family table dialog box and then Excel using button in Family table dialog box
  • open csv file in Notepad++ > select all rows > CTRL+C
  • in Excel > CTRL+V
  • close Excel
  • new instances are available in Family table dialog box

Test no.2

Columns in csv file separated by semicolon character.

  • open family table part in Creo
  • open Family table dialog box and then Excel using button in Family table dialog box
  • open csv file in second instance of Excel > select all rows > CTRL+C
  • in Excel > CTRL+V
  • close Excel
  • new instances are available in Family table dialog box

 

    B
    23-Emerald III
    BenLoosli23-Emerald IIIAuthor
    23-Emerald III
    February 24, 2022

    I used your test 2 option with Creo 7.0.7.0 and Excel 365 and also Creo 7.0.5.0.

    Neither would import the table data into Creo. They all turn the cell background yellow.

    I have edited existing family tables in 7.0.7.0 with Excel 365, so I know the combination should work.

    I have tried importing only a few rows and all 526 rows.

    I just created 2 rows manually and those rows were verified into the table, including the columns that are driven by relations in the part file. Added the rest of the rows with cut and paste and when I closed the spreadsheet, it wiped out the 2 added rows.

     

     

     

     

    B
    23-Emerald III
    BenLoosli23-Emerald IIIAuthor
    23-Emerald III
    March 4, 2022

    Had a connected session with PTC tech support on 3 March and they can see what I am talking about on my system. Still waiting to see if this issue is going to be referred to R&D for resolution.

    Terms & ConditionsCookie settingsAccessibility statement