When importing, you specify whether the CSV file contains column headings and with which character the individual data records are separated from one another (e.g., semicolons or tabs).[\/vc_column_text][\/vc_column_inner][\/vc_row_inner][image_with_animation image_url=”898″ alignment=”” animation=”Fade In” img_link_large=”yes” border_radius=”none” box_shadow=”none” max_width=”100%”][vc_column_text]Notes<\/u>
\nThe separator should not be contained in the table data, even within quotation marks. In such cases, the record will not be imported or will be imported incorrectly.<\/p>\n
If a CSV column is assigned to a part database field of the type Number<\/strong> or Floating point number<\/strong>, the corresponding CSV column must be filled correctly; otherwise, the import will abort.[\/vc_column_text][\/vc_column][\/vc_row][vc_row type=”in_container” full_screen_row_position=”middle” scene_position=”center” text_color=”dark” text_align=”left” overlay_strength=”0.3″ shape_divider_position=”bottom”][vc_column column_padding=”no-extra-padding” column_padding_position=”all” background_color_opacity=”1″ background_hover_color_opacity=”1″ column_link_target=”_self” column_shadow=”none” column_border_radius=”none” width=”1\/1″ tablet_width_inherit=”default” tablet_text_alignment=”default” phone_text_alignment=”default” column_border_width=”none” column_border_style=”solid”][vc_column_text]\n 2. You can determine the storage location of the part database via the Open<\/strong> symbol button. 3. Navigate with Windows Explorer to the storage location of the part database and copy it into a directory of your choice.[\/vc_column_text][\/vc_column][\/vc_row][vc_row type=”in_container” full_screen_row_position=”middle” scene_position=”center” text_color=”dark” text_align=”left” overlay_strength=”0.3″ shape_divider_position=”bottom”][vc_column column_padding=”no-extra-padding” column_padding_position=”all” background_color_opacity=”1″ background_hover_color_opacity=”1″ column_link_target=”_self” column_shadow=”none” column_border_radius=”none” width=”1\/1″ tablet_width_inherit=”default” tablet_text_alignment=”default” phone_text_alignment=”default” column_border_width=”none” column_border_style=”solid”][vc_column_text]\n 5. Enter the delimiter that separates the records in the CSV file. By default, this is a semicolon or a tab. 6. Click OK<\/strong>. The Field assignment<\/strong> dialog opens.[\/vc_column_text][\/vc_column_inner][\/vc_row_inner][divider line_type=”No Line” custom_height=”5″][image_with_animation image_url=”900″ alignment=”center” animation=”Fade In” img_link_large=”yes” border_radius=”none” box_shadow=”none” max_width=”100%”][\/vc_column][\/vc_row][vc_row type=”in_container” full_screen_row_position=”middle” scene_position=”center” text_color=”dark” text_align=”left” overlay_strength=”0.3″ shape_divider_position=”bottom”][vc_column column_padding=”no-extra-padding” column_padding_position=”all” background_color_opacity=”1″ background_hover_color_opacity=”1″ column_link_target=”_self” column_shadow=”none” column_border_radius=”none” width=”1\/1″ tablet_width_inherit=”default” tablet_text_alignment=”default” phone_text_alignment=”default” column_border_width=”none” column_border_style=”solid”][vc_row_inner column_margin=”default” text_align=”left”][vc_column_inner column_padding=”no-extra-padding” column_padding_position=”all” background_color_opacity=”1″ background_hover_color_opacity=”1″ column_shadow=”none” column_border_radius=”none” column_link_target=”_self” width=”1\/1″ tablet_width_inherit=”default” column_border_width=”none” column_border_style=”solid”][vc_column_text]7. Map the columns in the CSV file to the WSCAD part database fields:<\/p>\n Thomas Janowicz<\/strong> [vc_row type=”in_container” full_screen_row_position=”middle” scene_position=”center” text_color=”dark” text_align=”left” overlay_strength=”0.3″ shape_divider_position=”bottom”][vc_column column_padding=”no-extra-padding” column_padding_position=”all” background_color_opacity=”1″ background_hover_color_opacity=”1″ column_link_target=”_self” column_shadow=”none” column_border_radius=”none” width=”1\/1″ tablet_width_inherit=”default” tablet_text_alignment=”default” phone_text_alignment=”default” column_border_width=”none”…<\/p>\n","protected":false},"author":2,"featured_media":901,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[13],"tags":[189,74,70],"class_list":{"0":"post-869","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-wscad-suite","8":"tag-article-database","9":"tag-electrical-cad","10":"tag-part-database"},"yoast_head":"\nSave current WSCAD SUITE part database<\/h3>\n[\/vc_column_text][divider line_type=”No Line”][vc_column_text]First, make a backup of the current WSCAD SUITE part database. If the parts are then not imported as desired, you can always access the backup copy.[\/vc_column_text][divider line_type=”No Line”][vc_column_text]1. First, check which part database is being used. To do this, click on the main menu command Tools | Settings (options) | Master data | Part.<\/strong> Here you can see which type of part database is being used (Access, SQL Server or MySQL).
\nNote:<\/u> The set part database is project-dependent. It is thus possible that another project may use a different part database.<\/p>\n
\nNote:<\/u> By default, the part databases are stored under the Databases<\/em> folder in the WSCAD installation directory.<\/p>\nImport CSV file<\/h3>\n[\/vc_column_text][divider line_type=”No Line”][vc_column_text]\n1. Click on Tools | Master data | Part management.<\/strong> The Part management dialog opens.
\n[\/vc_column_text][divider line_type=”No Line”][vc_column_text]2. Click in the menu of the Part management on Tools | Database Import CSV<\/strong>. The Part database converter<\/strong> wizard opens.[\/vc_column_text][divider line_type=”No Line”][image_with_animation image_url=”897″ alignment=”center” animation=”Fade In” img_link_large=”yes” border_radius=”none” box_shadow=”none” max_width=”100%”][divider line_type=”No Line”][vc_row_inner column_margin=”default” text_align=”left”][vc_column_inner column_padding=”no-extra-padding” column_padding_position=”all” background_color_opacity=”1″ background_hover_color_opacity=”1″ column_shadow=”none” column_border_radius=”none” column_link_target=”_self” width=”1\/1″ tablet_width_inherit=”default” column_border_width=”none” column_border_style=”solid”][vc_column_text]3. Using the Browse symbol button next to the Database<\/strong> field, navigate to the CSV file and open it. The following dialog appears:[\/vc_column_text][divider line_type=”No Line”][image_with_animation image_url=”899″ alignment=”center” animation=”Fade In” img_link_large=”yes” border_radius=”none” box_shadow=”none” max_width=”100%”][\/vc_column_inner][\/vc_row_inner][vc_row_inner column_margin=”default” text_align=”left”][vc_column_inner column_padding=”no-extra-padding” column_padding_position=”all” background_color_opacity=”1″ background_hover_color_opacity=”1″ column_shadow=”none” column_border_radius=”none” column_link_target=”_self” width=”1\/1″ tablet_width_inherit=”default” column_border_width=”none” column_border_style=”solid”][vc_column_text]4. If your CSV file contains column headings, select the check box Use first row as column definition.<\/strong><\/p>\n
\nNote:<\/u> You will see this when you open the CSV file with a text editor.<\/p>\n\n
\n
\n
\n
\n
\n
\nYou can use the plus symbol button to add more columns from the CSV file and assign them to WSCAD fields. With the minus symbol button, you can delete the entries again.<\/li>\n<\/ol>\n[\/vc_column_text][divider line_type=”No Line”][image_with_animation image_url=”896″ alignment=”center” animation=”Fade In” img_link_large=”yes” border_radius=”none” box_shadow=”none” max_width=”100%”][\/vc_column_inner][\/vc_row_inner][\/vc_column][\/vc_row][vc_row type=”in_container” full_screen_row_position=”middle” scene_position=”center” text_color=”dark” text_align=”left” overlay_strength=”0.3″ shape_divider_position=”bottom”][vc_column column_padding=”no-extra-padding” column_padding_position=”all” background_color_opacity=”1″ background_hover_color_opacity=”1″ column_link_target=”_self” column_shadow=”none” column_border_radius=”none” width=”1\/1″ tablet_width_inherit=”default” tablet_text_alignment=”default” phone_text_alignment=”default” column_border_width=”none” column_border_style=”solid”][vc_column_text]\n\n
\n
\nIf this check box is selected, existing records will be overwritten with the new data. If the check box is cleared, existing records will not be overwritten. In that case, you can only create new records.<\/li>\n
\n(only selectable if the Update check box is activated) If this box is selected, only the empty fields of existing records will be overwritten. If the check box is cleared, all the data of existing records will be overwritten.<\/li>\n
\nIf this check box is selected, new data records will be created if the records do not already exist. If the check box is cleared, no new records will be created. Only existing records are updated.<\/li>\n<\/ul>\n[\/vc_column_text][divider line_type=”No Line”][vc_column_text]\n\n
\n
\nTechnical Writer,
\nDocumentation Management<\/p>\n[\/vc_column_text][\/vc_column_inner][vc_column_inner column_padding=”no-extra-padding” column_padding_position=”all” background_color_opacity=”1″ background_hover_color_opacity=”1″ column_shadow=”none” column_border_radius=”none” column_link_target=”_self” width=”3\/4″ tablet_width_inherit=”default” column_border_width=”none” column_border_style=”solid”][\/vc_column_inner][\/vc_row_inner][\/vc_column][\/vc_row]\n","protected":false},"excerpt":{"rendered":"