×
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

Does "Import" not work when editing standards data?

Does "Import" not work when editing standards data?

Does "Import" not work when editing standards data?

(OP)
I'm working "direct" for a company now and am transitioning them to SolidWorks from AutoCAD, and I'm working in SolidWorks 2005.  Perhaps 2006 or the Beta of 2007 has the following problem fixed, but I can't test that.  I would certainly think that it would be worth fixing if it's broken.  The Truarc retaining rings in the Toolbox are a bit of a problem to ME specifically because my new employer (like many companies) don't buy from Truarc.  They buy from Rotor Clip which has basically identical parts -- at least geometrically -- with analogous part numbers.  What I wanted to do was to "Create New Standard" (using the Truarc library as the "Designed From" source) for Rotor Clip retaining rings.  Then of course I wanted to edit the standards data for that new standard library.  There are "Export" and "Import" functions available from the "All Configurations" tab for each of the various kinds of External and Internal rings.  That's a really nice thing, ostensibly enabling one to export to a spreadsheet, modify the data wholesale there and then reimport into the standards data.  The only problem is that the "Import" function doesn't work!!  It appears to work -- or at least be doing something -- when you identify the spreadsheet that has been modified, but after finishing (without error messages) it doesn't actually change anything.  The data is just the same, and I can confirm that also by trying to insert parts from that Toolbox library.  For those who want to use this great functionality, that's really frustrating.  I have checked to make sure that the problem exists on more than one installation, and have also checked to make sure that I'm not trying to modify a file with a Read Only (or Hidden or System) attribute bit set.  No such luck.  Does NE1 know of a "fix" or am I SOL?

Mark Stapleton
Watermark Design, LLC
Charlotte, NC
www.h2omarkdesign.com

RE: Does "Import" not work when editing standards data?

Hello Sporkman! Long time no here from? Glad to see you on this group!

I assume you followed the instructions per the help?

You can add part numbers, part descriptions, and comments for each configuration. You can edit the cells in the dialog box or click Export to export the data to Microsoft Excel and edit the data in Excel. When you are done in Excel and have saved the spreadsheet, click Import to import the data into the database for Hole Wizard holes and Toolbox documents

Regards,

Scott Baugh, CSWP
www.scottjbaugh.com
FAQ731-376

RE: Does "Import" not work when editing standards data?

(OP)
Yes, I followed all instructions as well as I understand them, and I did note that I got error messages if I did anything wrong in editing the spreadsheet before trying to import it.  Especially it seems the header information in the spreadsheet must be left alone.  But when the Import seemed to be successful, without error messages, the data in the standards data remained just the same.

Wondering whether anyone can experiment with 2006 or the Beta of 2007 and see if the Import function seems to work.  Or if someone can confirm that it DOESN'T work in 2005 that would be useful also.

Mark Stapleton
Watermark Design, LLC
Charlotte, NC
www.h2omarkdesign.com

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