AutoCAD Electrical General

Reply
Distinguished Contributor
Tee.Dee
Posts: 141
Registered: ‎11-03-2011
Message 1 of 6 (198 Views)

Import from Spredsheet problem

198 Views, 5 Replies
02-12-2013 01:50 PM

Hey guys,

 

The scenario is this:

 

I have a bunch of drawings with cable markers on them, the cables are named 1, 2, 3 etc. I export the drawings to spreadsheet and then change the cable names eg. from 1 to CA001.  I then import the spreadsheet and the tag names update successsfully.

 

Heres the problem, if I then insert another cable marker named '1' (which doesnt exist anymore because it has been renamed to CA001) it comes up with the duplicate tag warning, I insert it anyway and I can surf from it to the cable markers now named CA001.  The cable markers are still holding the original tag name they were given before being changed in Excel eventhough they display the correct tag they were changed to in Excel.

 

If I export the drawings to spreadsheet again all of the tag names I had updated in Excel change back to what they were originaly eg. from CA001 back to 1.

 

I have tried deleting the project.mdb file but that doesnt work.  Anyone have any suggestions of how I can stop this behavior?  Where is the Tag name data stored?

 

Thanks!

Distinguished Contributor
CAD-ICE
Posts: 291
Registered: ‎02-21-2009
Message 2 of 6 (186 Views)

Re: Import from Spredsheet problem

02-12-2013 04:51 PM in reply to: Tee.Dee

Hi there!

seems like you have some problems with the project database. Did you try a full rebuild?

If that didn´t help I would recommend that you delete the scratch database and reopen the project again with a fresh regenerated database.

Hope this helps :smileyhappy:

Regards, Gary

Distinguished Contributor
Tee.Dee
Posts: 141
Registered: ‎11-03-2011
Message 3 of 6 (183 Views)

Re: Import from Spredsheet problem

02-12-2013 04:55 PM in reply to: CAD-ICE

Thanks Gary,

 

How do I do a full rebuild?  I have tried deleting the database and reopening the project but that had no effect.

 

Tim.

Distinguished Contributor
CAD-ICE
Posts: 291
Registered: ‎02-21-2009
Message 4 of 6 (167 Views)

Re: Import from Spredsheet problem

02-13-2013 04:23 AM in reply to: Tee.Dee

Hi Tim,

If you have already tried deleting the scratch database "Projectname.mdb" I don´t think that the rebuild will help you any further. Anyway attached is a screenshot showing where to find the full rebuild tool.

Good luck and regards, Gary

Mentor
algerj
Posts: 219
Registered: ‎02-25-2010
Message 5 of 6 (161 Views)

Re: Import from Spredsheet problem

02-13-2013 08:55 AM in reply to: Tee.Dee

I know a work around that works to fix this issue and the wonderful "No data to display" issue for reports.

 

1. Remove all drawing from the project with the issue.

(remove every single one, DO NOT DELETE THE DRAWINGS OR THE PROJECT)

it clears out the project database, somehow it fixes issues that a normal rebuild doesn't.

 

2. Re-add the drawings to the project using the "Add Drawings" Command

 

3. save the project

 

4. re-run the Export and it should be working properly.

 

Before you do any of the above, just let me know if started seeing the issue after a Crash.

If it started happening after a crash I would just run an audit on the page experincing the issue. 

 

i hope this helps,

 

James Alger

SolidCAD 

Distinguished Contributor
Tee.Dee
Posts: 141
Registered: ‎11-03-2011
Message 6 of 6 (155 Views)

Re: Import from Spredsheet problem

02-13-2013 02:23 PM in reply to: algerj

Thanks Gary, I hadnt seen that there before, good to know.

 

Thanks James, not sure if it started after a crash or not but its very possible,  for the moment I have manualy changed the tag names for all the cable markers having the problem but these will all need to be changed again in a future revision so I will give your method a go then if the problem is still there.  I will let you know how I go.  Thanks again.

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
Manufacturing Community
The Manufacturing Community provides additional access to tips, tutorials, blogs and networking with peers.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

New AutoCAD Electrical Category!

The AutoCAD Electrical forum has moved into it's very own category page, and can no longer be found within the Additional Product Forums.

Ask the Community