×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Migrate spreadsheet data

Migrate spreadsheet data

Migrate spreadsheet data

(OP)
We have an old file that did not have its spreadsheet data migrated from Xess to Excel. We no longer have Xess on any of our systems. Is there a way for us to migrate to spreadsheet data to excel or are we stuck and have to redo it?

Thanks.

Steve
NX 6.0.5.3

RE: Migrate spreadsheet data

Once the file is open, go to...

Preferences -> Spreadsheet...

...and set the 'Default Spreadsheet' to 'Excel' and toggle On the 'Force Migrate Spreadsheet Data' option. Close the dialog by hitting OK and then go to...

Tools -> Spreadsheet...

...and the data from your old XESS sheet should now be displayed in a new Excel page. Now when you close the Excel page be sure to hit the OK button when you're asked if you wish to save the changes to the Spreadsheet.

John R. Baker, P.E.
Product 'Evangelist'
Product Engineering Software
Siemens PLM Software Inc.
Industry Sector
Cypress, CA
Siemens PLM:
UG/NX Museum:

To an Engineer, the glass is twice as big as it needs to be.

RE: Migrate spreadsheet data

(OP)
John,

I don't have the option to "force migrate spreadsheet data." I only have the choice of xess and excel. I also should have correctly stated that this is for part family data.

Steve
NX 6.0.5.3

RE: Migrate spreadsheet data

Sorry, I was looking at a newer version of NX. In NX 6.0, while you should still change this Preference to Excel just so that the system knows what it's to do the next time you attempt to open a Spreadsheet in this file, to actually migrate the Spreadsheet data from the XESS format into an Excel scheme, go to...

File -> Utilities -> Migrate Spreadsheet Data...

...where you will be given a dialog where you can migrate all of the various Spreadsheets used in NX from XESS to Excel.

John R. Baker, P.E.
Product 'Evangelist'
Product Engineering Software
Siemens PLM Software Inc.
Industry Sector
Cypress, CA
Siemens PLM:
UG/NX Museum:

To an Engineer, the glass is twice as big as it needs to be.

RE: Migrate spreadsheet data

(OP)
Is there a workaround if you don't have xess anymore? That is where our problem arises.

Steve
NX 6.0.5.3

RE: Migrate spreadsheet data

Are you saying that you can't use the 'Utilities' tool? I don't have any old files with XESS data to test this with (and it would have been a real test since I don't have XESS on my system either) so I can't really say if it should have worked or not.

That being said, I suspect that the option that is now available in the Preferences -> Spreadsheet dialog (BTW, this was added in NX 8.0) is what will address this situation since the name of the option implies that this will 'force' the migration no matter what (note that I could find no documentation on this new 'feature' and since I'm not in the office today I may not be able to follow-up on this until Monday).

John R. Baker, P.E.
Product 'Evangelist'
Product Engineering Software
Siemens PLM Software Inc.
Industry Sector
Cypress, CA
Siemens PLM:
UG/NX Museum:

To an Engineer, the glass is twice as big as it needs to be.

RE: Migrate spreadsheet data

Worst case scenario - send the file to GTAC. I'm 95% sure they have to tools to migrate your data and send the file back. Make sure to tell them the version of NX and Excel that you use.

www.nxjournaling.com

RE: Migrate spreadsheet data

(OP)
My solution is to open the file in NX 8; force the update to excel, then save the family table as an excel workbook so my user can then delete the xess part family and recreate it from the excel file.

Steve
NX 6.0.5.3

RE: Migrate spreadsheet data

So my suspicions were correct, that the changes we made in NX 8.0 did provide support for FORCING the migration even if you did NOT have a version of XESS running. It would appear that short of getting new copy of XESS, that you've found a way of accomplishing what was needed.

John R. Baker, P.E.
Product 'Evangelist'
Product Engineering Software
Siemens PLM Software Inc.
Industry Sector
Cypress, CA
Siemens PLM:
UG/NX Museum:

To an Engineer, the glass is twice as big as it needs to be.

RE: Migrate spreadsheet data

(OP)
You are correct, John, and your little tip about forcing the update was exactly what I needed.

Thanks.

Steve
NX 6.0.5.3

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources