• Blog posts

    Bio

    by Miles Nicholson

    Inventor_import_Harness_MN_01.gif

    AutoCAD® Electrical has a real-time bi-directional link between Autodesk Inventor and wire/cable connection data is updated on the fly, ensuring consistency of information between your mechanical and electrical engineers. For more information on this:

    AutoCAD Electrical Interoperability with Autodesk Inventor

    However, if you are not using AutoCAD® Electrical to create the from-to information used to route wires/cables, then how can you define the connections easily rather than define the connections individually and tediously in Inventor?

    Define the connections in Microsoft® Excel!

    Harness assemblies often contain many discrete wires and multi-conductor cables that must be placed in the harness assembly and attached to the appropriate pins. Instead of bringing in each wire or cable individually, or indeed defining them individually within Inventor, you can import a wire list data set that automatically establishes connectivity in the harness assembly. The import files can be in .csv or .xml format. When using an .xml import file, you can also generate virtual parts and bring in additional data such as properties e.g. part data.

    Once the wires and cables are imported, the system indicates the status of the import, displays the Imported Harness Data dialog box and writes a log file containing the details of the import.

    The Import Harness Data tool requires a configuration file (*.CFG) and a data file (*.CSV).

    The required format for the CFG must be as follows:

    All values in the data file must correspond to the data types specified in the configuration file. Units on values, if specified, must be appropriate for the corresponding data type.

    Inventor_import_Harness_MN_02.png

    Further information on Create a wire list (.csv) file

    A configuration file is a text file and can be easily created in Notepad. An example of a CFG file would be where the “//” prefix signifies a text comment:

    Inventor_import_Harness_MN_03.png

                                                                                                                                                                         
    cablesandwires
    //Import Wire & Cable Data into Inventor
    //Ideally you should utilise AutoCAD Electrical which has a bi-directional link to Inventor
    c:\temp\CableAndWiresImportErrors.txt
    //Any line prefixed with "//" is a comment line
    //The next 2 lines are the "English" names with the following line the mapping ID's required by Inventor
    //Wire No,From Component,From Pin,To Component,To Pin,Wire Type,Cable No,Cable Core
    Wire ID,RefDes1,Pin1,RefDes2,Pin2,Library Name,Cable ID,Conductor ID
    text,text,text,text,text,text,text,text
    none,none,none,none,none,none,none,none

                                                                                                                                                                         
    An example of a CSV file would match the formatting of the CFG:

                                                                                                                                                                         

    100,J1,2,P5,1,18AWG-RED,,
    101,J1,4,P5,8,18AWG-YEL,,
    119,PL1,1,PL2,1,,W1,RD
    120,PL1,2,PL2,2,,W1,BK

                                                                                                                                                                         

    If you are editing the data in Microsoft® Excel, save the file as a CSV (UTF-8) format. Characters such as “²” are maintained. The wire types defined in the data file must exist within the Inventor Cable & Harness Library Inventor_import_Harness_MN_04.png