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.

     

     

     

     

    R
    rklesch13-Aquamarine
    13-Aquamarine
    August 3, 2022

    Hello @BenLoosli,

    even if this topic seems to be closed: Today we had the same happening in creo 7.0.5. and 8.0.5 as well.

    Indeed, the problem was data dependent. It was a familiy table with reference dimensions only (for drawing purposes). Of course, they do not affect the model. So, it was not possible to change them afterwards at all. Neither in the family table UI or Excel.

    Freshly created data with driving dimensions works fine.

    Of course, it would be great, if the UI would give any signs or messages in such a case.

    In my example, d0 is a driving dimension, d4 is a reference dimension (that can´t be modified by user)

     

    Famtab.PNG

    Maybe, this could help You or others.

    Best regards!

    Terms & ConditionsCookie settingsAccessibility statement