Hide Table of Contents

Import Data

SOLIDWORKS Electrical has a feature allowing you to import from Excel files or text files for integration into an electrical project.

 

Menu: Import/Export > Import Data

 

When the command is launched, a dialog asks you to select the type of files (text or Excel files) and the file to be imported.

Step 1. Select data source

File or data source

Click this icon and select the Excel file containing the data you want to import.

Click this icon and select the text file containing the data you want to import.

 

Save in the import configuration: You can save the settings in the configuration file to reuse it for another import.

Import configuration

You can select an import configuration (all settings used during a previous import). A configuration file is saved in the last step of the data import.

 

On the right of the wizard, a preview area displays the data. If you import data stored in an XLS file, you can have tabs corresponding to the different XLS sheets. You can use the wizard several times to imports all sheets contained in the XLS file.

Step 2. Definition of a data range

The second part of the wizard manages data definition.

Current step

Data range: Select the range of data (an Excel file can contain multiple sheets).

Description: Enter a description or click the [...] button to enter a description in all languages supported by SOLIDWORKS Electrical.

Data type: Checks boxes corresponding to the data type you want to import.

Steps list

The Steps list displays the list of different steps for the data import. To import several ranges, go to the last step of the wizard and click the Add a data range button in Step 5 (Data comparison - differential report) to create a new data range.

Step 3. Title rows

To not import the column headings, select the number of rows including the title and the number of lines to be displayed.

Title rows

Number of title rows: Enter the number of lines corresponding to the header of the column.

Title row to display: Select the row number containing the name of the data type.

Step 4. Field definition

This step of the wizard allows you to organize the file data and the data managed by SOLIDWORKS Electrical.

Description: Select the data type and, using drag and drop, drag it to the right column to create a correspondence.

Associate data

Select the option and associate it to the column number or the column title.

 

Assign a class to components using mark: When an element has a mark with a root, SOLIDWORKS Electrical can automatically set the class associated with this root.

Remove association: Select the column where you want to delete the association and click the button.

Step 5. Data comparison - differential report

The last step of the wizard allows you to test the import (Compare button) before carrying out the import. A report file opens, displaying the list of operations carried out.

 

Add a data range: Used with an XLS file containing two or more sheets. You can have as many ranges as you want, for example, one to import cable references and a second to import components. If you add a new range, you must return to the first step to configure it.

Processing data

Compare: Before importing data, you can use the Compare button to test the import. A report opens to display the result.

Import: After the test, you can click the Import button to update the electrical project database with the imported data.

Save settings to an import configuration: You can save the import settings in a configuration file. This file can be used for another import.

 

Click the Finish button to exit the wizard.



Provide feedback on this topic

SOLIDWORKS welcomes your feedback concerning the presentation, accuracy, and thoroughness of the documentation. Use the form below to send your comments and suggestions about this topic directly to our documentation team. The documentation team cannot answer technical support questions. Click here for information about technical support.

* Required

 
*Email:  
Subject:   Feedback on Help Topics
Page:   Import Data
*Comment:  
*   I acknowledge I have read and I hereby accept the privacy policy under which my Personal Data will be used by Dassault Systèmes

Print Topic

Select the scope of content to print:




x

We have detected you are using a browser version older than Internet Explorer 7. For optimized display, we suggest upgrading your browser to Internet Explorer 7 or newer.

 Never show this message again
x

Web Help Content Version: SOLIDWORKS Electrical 2023 SP0

To disable Web help from within SOLIDWORKS and use local help instead, click Help > Use SOLIDWORKS Web Help.

To report problems encountered with the Web help interface and search, contact your local support representative. To provide feedback on individual help topics, use the “Feedback on this topic” link on the individual topic page.