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.

     

     

     

     

    S
    sacquarone21-Topaz I
    21-Topaz I
    February 28, 2022

    Hello @BenLoosli 

     

    I'm unable to reproduce your issue, and - I may have missed something in my keywords - but I failed to find any similar behavior reported to PTC TS in our internal Knowledge Base of acrtiles/Cases/SPRs. When proceeding as per both @MartinHanak , this always leads for me to the:

    • systematic successfull creation of all instance rows
    • potential absence of columns, if columns defined in first family table DO NOT EXIST in the object where Family Table is imported in Excel (and this is expected if so)

     

    If my undesratnding of your use case is correct, even the rows are not imported as expected, and this is strange. I'm wondering if you have excel_family_table_keep_file yes in your configuration files (default value being no, and this is how I tested the use case - per default then) ?

    • If set to yes, my suggestion is to try again after having modifed the value to no
    • If not set (or set to no), I don't see ... Maybe would you like to attach the 2 Family Table parts to this post (if possible, without potential risk of confidentiality loss) to allow us checking if it may be a data specific issue?

     

    As additional information:

    excel_family_table_keep_file

    Category: File Storage & Retrieval

    Description: Yes - in case of editing family table with excel, if saved excel file exist , will always update it.

    Values: yes, no*

     

    Regards,

     

    Serge

     

     

    Terms & ConditionsCookie settingsAccessibility statement