Hello
In soldworks electrical, I have a project with several bundles each representing an electrical cabinet.
I'd like to make a list of cables per bundle (so for each cabinet) but the basic cable list function takes out all the cables from the project.
Has anyone ever done this?
I don't know Electrical but by making a sub-assembly per cabinet?
This is done what is already in place. in the project there are several bundles (for the other functions the software understands these subsets well) for example for the BOMs, I have no problem.
I manage to get the list of equipment out of bundles, but for the cables everything is grouped together.
and so stupidly not knowing electrical
so don't blame me if I say nonsense ;-)
What if you created a project for each wardrobe
and after a project containing all these cabinets
@+
See this tutorial
http://www.leguide3d.com/profiles/blogs/solidworks-electrical-associer-un-cable-dans-un-sh-ma-l-ctrique
Hello
I just looked into your concern. Indeed, you can't separate the cables by bundle (or I don't have the trick either).
On the other hand, I can offer you a solution to sort these cables. Instead of making bundles, try to make localizations for your cabinets. It is much easier to sort the material or cable references by the.
In BOM configurations, you can even add sort columns and make breaks. This will separate the items for you as you wish.
I hope this will help you, even if I'm coming a little late...
Hi all
After 7 years of research, I managed to sort by bundle. I thank Visiativ support and Solidworks Electrical by the way. It took me a while despite a good SQL query because the elements have to be well " tidy ". I'm under
Consequently:
SELECT DISTINCT
vew_cable_ex.cab_tag AS cab_tag
, vew_cable_ex.cab_id AS cab_id
, vew_cable_ex.cab_tra_0_l1 AS cab_tra_0_l1
, vew_cable_ex.vcablocfrom_loc_id AS vcablocfrom_loc_id
, vew_cable_ex.vcablocfrom_loc_text AS vcablocfrom_loc_text
, vew_cable_ex.vcablocfrom_tra_0_l1 AS vcablocfrom_tra_0_l1
, vew_cable_ex.vcablocfrom_loc_tagpath AS vcablocfrom_loc_tagpath
, vew_cable_ex.vcablocto_loc_id AS vcablocto_loc_id
, vew_cable_ex.vcablocto_loc_text AS vcablocto_loc_text
, vew_cable_ex.vcablocto_tra_0_l1 AS vcablocto_tra_0_l1
, vew_cable_ex.vcablocto_loc_tagpath AS vcablocto_loc_tagpath
, vew_cable_ex.cab_length AS cab_length
, vew_cable_ex.cab_reference AS cab_reference
, vew_cable_ex.cab_manufacturer AS cab_manufacturer
, vew_cable_ex.cab_tagroot AS cab_tagroot
, vew_cable_ex.cab_tagorderno AS cab_tagorderno
, vew_cable_ex.cab_hasneutral AS cab_hasneutral
, vew_cable_ex.cab_hasground AS cab_hasground
, vew_cable_ex.cab_gauge AS cab_gauge
, vew_cable_ex.cab_section AS cab_section
, vew_cable_ex.cab_wirecount AS cab_wirecount
, vew_cable_ex.cab_ductpath AS cab_ductpath
, vew_cable_ex.cab_diameter AS cab_diameter
, vew_cable_ex.cab_family AS cab_family
, vew_cable_ex.cab_articlename AS cab_articlename
, vew_cable_ex.cab_swfromcomp AS cab_swfromcomp
, vew_cable_ex.cab_swtocomp AS cab_swtocomp
, vew_cable_ex.cab_tra_1_l1 AS cab_tra_1_l1
, vew_cable_ex.cab_tra_2_l1 AS cab_tra_2_l1
, vew_cable_ex.cab_tra_0_l2 AS cab_tra_0_l2
, vew_cable_ex.cab_tra_1_l2 AS cab_tra_1_l2
, vew_cable_ex.cab_tra_2_l2 AS cab_tra_2_l2
, vew_cable_ex.cab_tra_0_l3 AS cab_tra_0_l3
, vew_cable_ex.cab_tra_1_l3 AS cab_tra_1_l3
, vew_cable_ex.cab_tra_2_l3 AS cab_tra_2_l3
, vew_cable_ex.cab_use_data0 AS cab_use_data0
, vew_cable_ex.cab_use_data1 AS cab_use_data1
, vew_cable_ex.cab_use_data2 AS cab_use_data2
, tew_bundle.bun_id AS bun_id
, tew_bundle.bun_defaultlocid AS bun_defaultlocid
FROM
vew_cable_ex
LEFT JOIN tew_bundle ON tew_bundle.bun_defaultlocid=vew_cable_ex.vcablocfrom_loc_id
WHERE bun_id =%CUR_BUNDLE_ID%
It didn't work the first time, you have to check the project several times. Delete and then regenerate folios. Do not hesitate to check the cables with a design rule.
There you go, hoping that it unlocks some of them.
Thank you for remembering to ask the question and for providing the answer.