AutoCAD Electrical General

Reply
Contributor
adrien.levasseur
Posts: 20
Registered: ‎01-31-2012
Message 1 of 12 (990 Views)

Cable list - FROM/TO listing

990 Views, 11 Replies
02-16-2012 06:50 AM

Hi all,

 

I would like to get a list of all cables ordered by localisation FROM then by localisation TO (then by TAG).

By using Cable summary report, i am not able to have the localisation TO

By using Cable From/To report, i have each conductors of the multicore cables. But i never have 1 cable going to several localisation in one end.

 

Could you help me solve how to add localisation TO in the Cable summary ?

If impossible, is there .mdb file that contain all the wires informations ?

 

Thanks in advance 

*Expert Elite*
Posts: 2,796
Registered: ‎10-18-2003
Message 2 of 12 (983 Views)

Re: Cable list - FROM/TO listing

02-16-2012 08:56 AM in reply to: adrien.levasseur

Maybe I am misunderstanding your problem, but the Cable From/To report will display all Location Codes that  you select when you generate the report (see attached screen capture).  Be sure you have the LOC1 and LOC2 fields in your report.  You can rename the fields once you move them into the report.  Perhaps rename LOC1 to LOC FROM and rename LOC2 to LOC TO.

 

Hint: You can also add the cable information to a Wire From/To report by clicking Change Report Format after you generate the Wire From/To list.

Doug McAlexander
Independent Consultant/Instructor/Mentor specializing in AutoCAD Electrical, ecscad, and promis-e implementation

Web site: www.ECADConsultant.com
Phone: (770) 841-8009

Please Accept as Solution if I helped you. Kudos are also much appreciated.
Contributor
adrien.levasseur
Posts: 20
Registered: ‎01-31-2012
Message 3 of 12 (962 Views)

Re: Cable list - FROM/TO listing

02-17-2012 04:00 AM in reply to: dougmcalexander

First of all, thanks for your consideration

 

Yes, you misunderstood me... And maybe my explanation not good enough.

 

I would like to have a report FROM/TO about cables, and not for each wires of the cable.

 

If you are the guys who pose the cable, you don't care the localisation of each wires, but you care the localisation of the entire cable. So the report you show me is over detailed compare the function i need.

 

Moreover (in my case) i never have wires from a single cable that goes in several localisation in one end.

This should look like :

CABLE N°

FROM

TO

MFG

CAT

 

Until now, i use my own .mdb or .xls files. But ACE could be more convenient by doing this task by itself.

 

 

 

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

Re: Cable list - FROM/TO listing

02-17-2012 07:17 AM in reply to: adrien.levasseur

Hello Adrian,

Seems like you want to run a report called "Cable from/to" report. This report gives you the option to define from which locations you want to list cables for. This report is wery easy to use and straight forward (see attached image).

 

Regards, Gary

Contributor
adrien.levasseur
Posts: 20
Registered: ‎01-31-2012
Message 5 of 12 (946 Views)

Re: Cable list - FROM/TO listing

02-17-2012 07:55 AM in reply to: CAD-ICE

The way i found is to erase all lines without MFG value toget what i need

Let's the picture talks for me....

 

I feel upset, cause the cable summary didn't give me the LOC1 and LOC2, this would be exactly what i need

 

Thanks for help, but still want more information on it :smileywink:

 

 

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

Re: Cable list - FROM/TO listing

02-17-2012 08:17 AM in reply to: adrien.levasseur

Hello again!

I´m not sure if I follow you but by looking at the picture it seem like the report you are trying to make is a summary of cables routed from one location to another with information on cable manufacturer and cable type right?

Please refer to the attached image which shows a cable from/to report from one of my projects. Isn´t this what you are after?

 

Regards, Gary

Contributor
adrien.levasseur
Posts: 20
Registered: ‎01-31-2012
Message 7 of 12 (934 Views)

Re: Cable list - FROM/TO listing

02-17-2012 08:24 AM in reply to: CAD-ICE

Hi again,

 

Your report looks exactly like the way i want...

What is report generator ? Could you show me how to use it and get same report as you ?

 

 

 

Distinguished Contributor
CAD-ICE
Posts: 291
Registered: ‎02-21-2009
Message 8 of 12 (924 Views)

Re: Cable list - FROM/TO listing

02-17-2012 08:45 AM in reply to: adrien.levasseur

Hello Adrian,

you simply click on the "Reports" Tab and then click on "Reports" on the Schematic tab. This opens a new window called "Schematic Reports". Now choose the report named "Cable From/To" and choose the Category Scematic and hit the "OK" button. This opens the "Select Drawings to Process" dialog window and you select the drawings you would like to process og select "Do Al"l if you like and hit the "OK" button. This should open the next window which is the "Location Code Selection for From/To Reporting" dialog window. Now chooce locations from and to and hit th "OK" button. This finally opens the "Report Generator" dialog box where you can design the report layout for instance by clicking on the "Change Report Format" button which opens a dialog window allowing you to select fields to report. In your case you would like something as shown on the attached image.

I hope this get´s you on the right track...

 

Regards, Gary

 

 

Contributor
adrien.levasseur
Posts: 20
Registered: ‎01-31-2012
Message 9 of 12 (860 Views)

Re: Cable list - FROM/TO listing

03-06-2012 07:30 AM in reply to: CAD-ICE

Hello Gary and all,

 

What you told me gives me a list of each single conductor for all cables in my drawings.
I think it works for you because you are using fan in/out for the cable. So the symbol of cable appears only one time for all conductors. But in my case, i used mulitple mount symbol (see the appendix.dwg).

 

So i should learn to use fan in/out and my report will looks better

Distinguished Contributor
CAD-ICE
Posts: 291
Registered: ‎02-21-2009
Message 10 of 12 (846 Views)

Re: Cable list - FROM/TO listing

03-06-2012 08:45 AM in reply to: adrien.levasseur

Hello Adrien,

I think you are misunderstanding something. The fan-in/fan-out tool is used to combine /collect a number of conductors into a single "Fan-IN" source object , whereafter you can distribute the collected conductors on various drawings through multiple "Fan-OUT" destinations.

The cable from/to reports as you mention a list for each conductor in all cables showing the connection of each conductor in two different locations. If you however wish to create a cable list showing only the cable tag and maybe some technical details for the cable type and descriptions, you should generate instead a bill of material report instead and filter out everything except cables as a suggestion ??

THL.

Gary 

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