Does "Import" not work when editing standards data?

[Sporkman]

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

http://www.h2omarkdesign.com

 

[SBaugh]

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

http://www.scottjbaugh.com

faq731-376

 

[Sporkman]

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

http://www.h2omarkdesign.com