# Solidworks Electrical Schematic
###### tags: `firmware_hardware` `electrical_system` `NTURT`
## reference
[official website tutorials](https://help.solidworks.com/2022/english/swelec/2DTutorials.htm?id=da5e8eab3a644749b1239b4e2d1360a5#Pg0)
[sample project](https://swelectrical-help.solidworks.com/dl/swe/CHM/2017/EN/HelpOnLine/ProjectsSamples.htm)
## problems and solutions
* SQL server problem
* error message: The executable file "C:\Users\kuoja\Documents\SOLIDWORKS Downloads\SOLIDWORKS 2022 SP03.1\PreReqs\SQLServer\en_sql_server_2019_express_x64_e2d9f596.exe" /ConfigurationFile="C:\ProgramData\SOLIDWORKS Electrical\SWSQLSetup.ini" /IACCEPTSQLSERVERLICENSETERMS /Q /SAPWD=SQLpwd4ew /AGTSVCPASSWORD=SQLpwd4ew did not install successfully.
* solution: Install Microsoft SQL Server Management Studio, and login to the SQL server Solidwork is using(might be [yourcomputer name]/SQLEXPRESS, for me it's JACK-THINKPAD-X\SQLEXPRESS) by windows authentication (you can login with SQL server authentication if you know the password. right click on the server in the Obect Exlplorer (showed in the following screen shot). Navigate to Security, and select SQL Server and Windows Authencation mode.  
## tutorial
* [super old but look quite thorough tutorial](https://youtu.be/FXvg67NpOk0)
* [nice tutorial for knowing what it is capable of (by GoEngineer)](https://youtu.be/iMazR1TPVqo)
* [(2D only) true detailed basics and reletively rookie freindly tutorial](https://youtu.be/Y2y5J20WW6U), include create a manufacure part in mh library based on the spec sheet, and wire style, PLC, origin-destination arrow, macro, wire numbering. Always saying: garabage in garbage out.
* [SolidWorks Electrical Assemblies (by solidworks)](https://youtu.be/n84KxbfI_3M), how to place 2d components in 3D assembly
* [SOLIDWORKS Electrical 3D: Getting Started - Webinar (by GoEngineer)](https://youtu.be/1ATXDszRdpo)
* [solidworks tutorials - electric (by GoEngineer)](https://youtube.com/playlist?list=PLObi3o8pH9TFK_Iso64Pl4J1gnjjzyb0q)
* [how to turn customized profile to routing component and cable wire library wizard](https://www.youtube.com/watch?v=JESQEXxDnYQ&ab_channel=GoEngineer)
* [seems like pretty thorough example of 2D -> 3D](https://youtu.be/9hD5jxJ2iAk)(I didn't finish it)
* [SOLIDWORKS Electrical Schematics - Product introduction](https://youtu.be/XSydDiDJ2Oc)
* [Getting Started With SOLIDWORKS Electrical - User Interface](https://youtu.be/Npp5B_KRveY) (not really useful)
## small tutorial
* [terminal strip](https://youtu.be/CMnO_bgB-O4)
* [SOLIDWORKS Electrical - Dynamic Connector Configuration Creation](https://youtu.be/5NvFqJ8PO4g)
* [Tech Tip: Inserting Dynamic Connectors with SolidWorks Electrical](https://youtu.be/tnVM_A-LJFk)
## other
* [wire harness VS cable](https://whma.org/five-differences-between-a-wire-harness-and-a-cable-assembly/)
* cable is fully enclosed and protective, wire harness is just simple way of combination of several wires in the sense of organising
* [Difference between wire, cable and harness](https://r1132100503382-eu1-3dswym.3dexperience.3ds.com/?_gl=1*yqzdcm*_ga*MjAwMjQ1NzA5MS4xNjkwMjk3MTY4*_ga_XQJPQWHZHH*MTY5MDYyNjI1NS4yLjAuMTY5MDYyNjI1NS42MC4wLjA.&serverId=SwymHttpdTomcatServer_1_8081#community:yUw32GbYTEqKdgY7-jbZPg/iquestion:sl-FvKHgTgyIlcm_0LVfWw)
```
here is the breakdown of what SWE means by each of these:
Wires - individual signals running on a single conductor that will maintain their own identity. (may be part of a harness by multiselecting, right click, add to harness). Wires are added and managed in Project> Configurations>Wire Styles (project specific). Can be routed using "route wires" command in SWE 3D. Components in 3D that have Cpoints set up through the wizard will reference your schematic to run the single conductors from point to point based on your schematic definitions.
Cable - a sleeved grouping of wires, logically packaged together with each conductor having a gauge, wire number, and color. Cables have a part (reference) and manufacturer in the library, and are added and the cables used in a particular project are managed in Project>Cables. Schematic wires can be logically "associated" to cores (conductors) of cables in your design. It is key that if each Cable is properly assigned it will display "origin" and "destination" assigned. Routed in 3D using "route cables". You can route the cable including each conductor origin/destination based on your schematics, or if the specific pins are not specific the cable will still route based on the location assignments (think line diagram block style)
Harness - a logical grouping of WIRES, CABLES, and Connectors that would be gathered and assembled as a single harness entity. You can define your harnesses in SWE schematic, pick which schematic entities are part of the harness, and that logical association can then be routed in 3D all together using "route harnesses".
Any of these can be "flattened" as SWE 3D creates a feature that behaves like "harness" even if the "harness" only consists of individual wires running point to point or otherwise.
```
* 晟祥 tells us to finde cables and connectors from here
* [connectors](http://www.nian-yeong.com.tw/)
* [cables](https://www.nizing.com.tw/zh)
* [M12 water proof head 致德](https://tw.jtep.net/store/index?sn=1314)
* 致榮 CJ-M12-12P
* [solidworks electrical content portal (paid library)](https://electricalcontentportal.3ds.com/Page/home.aspx?type=swe&ticket=ST-14856940-ae35wLAuU1Wtzev1P3dn-cas)
* [super old tutorial](https://youtu.be/DxhuDK3qT8E)
* [pdf from goengineer](https://bayanbox.ir/view/1379275181502528307/SOLIDWORKS-Electrical-Getting-Started.pdf)
* ask chat GPT
```
The description "UL2464#24*1P+AEB OL=48mm" refers to a specific type of cable. Here's a breakdown of what each part of the description means:
"UL2464": This is a UL (Underwriters Laboratories) rating for the cable, indicating that it meets certain safety and performance standards set by UL.
"#24": This indicates the size of the conductor (the metal wire inside the cable) and is measured in American Wire Gauge (AWG). In this case, it's #24, which means the conductor has a diameter of about 0.0201 inches (0.511 mm).
"*1P": This indicates that the cable has one conductor (one wire) and is not a multi-conductor cable.
"+AEB": This indicates the type of insulation used on the conductor. In this case, it's AEB (Acrylonitrile-ethylene-butadiene), which is a type of thermoplastic elastomer (TPE) that provides good electrical and mechanical properties.
"OL=48mm": This refers to the overall length (OL) of the cable and indicates that it is 48 millimeters long.
Overall, this description is specifying a single-conductor cable that is 24 AWG in size, has AEB insulation, and is 48mm long.
```