/Topic/SppTaskImportNamedSheetfromExcelintoanExistingProjectTable
Import Named Sheet From Excel Into An Existing Simple Table - This Specification Macro Task will import a named Sheet from Excel into an existing Simple Table.…
/Topic/Integration
Integration - Integrate DriveWorks with your other company systems. - Databases - DriveWorks can read and write data from any database with an ODBC driver as well…
/Topic/SppTaskImportNamedSheetFromExcelIntoConstantsAndControls
Import Named Sheet From Excel Into Constants And Controls - This Specification Flow Task reads in multiline, two column data from a named sheet in an Excel file,…
/Topic/SppTaskExportATableArrayToNamedRangeInExcel
Export a Table Array To Named Range in Excel - This Specification Flow Task exports a table array to a named range in an Excel file. The named range will be used…
/Topic/SppTaskImportMultiColumnNamedSheetFromExcelIntoConstantsAndControls
Import Multi Column Named Sheet from Excel into Constants and Controls - This Specification Flow Task reads in multiline, multi column data from a named sheet in…
/Topic/SppTaskImportNamedRangeValuesFromExcelIntoConstantsAndControls
Import Named Range Values From Excel Into Constants And Controls - This Specification Task reads in all data found in named ranges in an Excel file and passes th…
/Topic/DocumentRulesExcelWorkbook
Document Rules: Excel Workbook - DriveWorks can create new documents by using an Excel worksheet as a template. Rules are applied to named ranges in the workbook…
/Topic/Excel_Workbook_Document
Excel Workbook - This Document type is used to export data directly in to a Sheet in a Microsoft Excel Workbook from the DriveWorks project. - To work effectively…
/Topic/SppTaskExportCalculateImportToAndFromNamedRangesInExcel
Export/Calculate/Import To and From Named Ranges in Excel - This Specification Flow Task will look in all named ranges in an Excel file, and for each one, checks…
/Topic/HowToSetupaDSNOtherDatabase
Introduction - On a 32bit machine the ODBC can be found at Start > Programs > Control Panel > Administrative Tools > Data Sorce (ODBC). - On a 64bit machine the O…
/Topic/SppTaskExportCalculateImportToAndFromNamedSheetsInExcel
Export/Calculate/Import To And From Named Sheets In Excel - This Specification Macro Task will look for the text in the first column of a specified input Sheet.…
/Topic/SppTaskExportTableArrayToExcelCellReference
Export Table Array To Excel Cell Reference - This Specification Flow Task exports a table array into a Microsoft Excel Workbook via a Cell Reference. - Microsoft…
/Topic/SppTaskExportAllControlNamesToNamedSheetInExcel
Export All Control Names To Named Sheet in Excel - This Specification Flow Task recurses all the Forms in a Project and all of the Controls within each form. - Mi…
/Topic/HowToTroubleshootDocuments
How To: Troubleshoot Documents - This article gives solutions for common issues associated with Document Generation. - There was a problem sending the command to…
/Topic/HowToSetupaDSN-SQLServer
How To: Set up a DSN-SQL Server - On a 32bit machine the ODBC can be found at Start > Programs > Control Panel > Administrative Tools > Data Source (…
/Topic/SppTaskExportControlValuesToNamedSheetInExcel
Export Control Values To Named Sheet in Excel - This Specification Flow Task will recurse all forms in a Project and all Controls on each Form. For Controls that…
/Topic/DocumentRules
Document Rules - After capturing the documents to be created, use the Documents screen to build or edit the rules that control the document. - To Add, Edit or Del…
/Topic/BOMExcel
Enhanced functionality is available in the SOLIDWORKS Power Pack. Please consider using the Generation Task Export Drawing Table, to save a BOM as a…
/Topic/InfoExcelProjectsAndDriveWorksProjects
Info: Excel Projects and DriveWorks Projects - Please Note - Excel Projects are no longer supported in DriveWorks 12 and beyond. - This topic is now obsolete.…
/Topic/ReleaseDocuments
Release Document(s) - The Release Documents task will release any or all of the required Document outputs as defined in the Stage 4: Output Rules > Documen…
/Topic/9DriveWorksToolsWhatsNew
Project Conversion Tool - A project conversion tool which helps to convert DriveWorks Excel based projects into faster, more powerful native DriveWorks projects,…
/Topic/ProjectEditorTables
Define Tables - When creating an automation project, it is likely that you've got existing data in databases or spreadsheets that you want to reuse, you can crea…
/Topic/WhatsNewDriveWorks11PDFCreation
Create PDF's from Word and Excel Documents - Portable Document Format (PDF) files can be created, by default, for documents based on Microsoft® Word and Excel fi…
/Topic/InfoImpactsOfRegionalSettings
Info: Impacts of Regional Settings - This topic explains how DriveWorks works with Regional Settings. - Please note regional settings that use a comm…
/Topic/SpecificationPowerPack
DriveWorks Labs PowerPacks can be updated more often than the main release. Please consult the Online Help File for the most up to date information and funct…
/Topic/HowToMoveDriveWorksData
How To: Move DriveWorks Data - This document provides information on moving DriveWorks Data associated to a group. - Moving an actual DriveWorks group is covered…
/Topic/InfoUsingExternalDataInDriveWorks
Info: Using External Data In DriveWorks - Every business is under pressure to work more efficiently and effectively and there are numerous software solutions ava…
/Topic/GroupTables
Group Tables - Group Tables provide access to tabular data relevant to all projects within a group. - The data held in a Group Table can be accessed through all t…
/Topic/ConfiguringIntegrationThemeForIIS
How To: Configure IIS For The Integration Theme - DriveWorks Live can run directly as an application or as a service through Internet Information Services (IIS)…
/Topic/DocumentRulesWordDocument
Document Rules: Word Document - This document describes the kinds of rules that apply to documents. - Word Document Rules - Document Name Rule - Rule Meaning "DELET…
/Topic/DriveWorksLabs
DriveWorks Labs - DriveWorks Labs is an area where you can download some of the most common plugins for DriveWorks Pro. - These plugins have been created by Drive…
/Topic/InfoTechTipsIndex
DriveWorks Tech Tips Index - Tech Tips are accessed from MyDriveWorks and are available to DriveWorks Pro customers with an active subscription and support contr…
/Topic/UsingDriveWorksAdministrator
Using DriveWorks Administrator - DriveWorks Administrator is used to set up and run your Design Automation, CPQ and Online 3D Sales Configurator projects. - Using…
/Topic/HowToMoveFrom32bitTo64bit
How To: Move From a 32bit machine to a 64bit machine - This article discusses the procedure when transferring a DriveWorks installation from a 32bit machine to a…
/Topic/Word_Document
Word Document - This Document type is used to export data directly in to a Microsoft Word Document from the DriveWorks Project. - DriveWorks can attach to and ext…
/Topic/SppTaskReplaceImagesInExcelDocument
Replace Images in Excel Document - This Specification Task inserts an image into an Excel document to replace an existing shape that has a specific title. - Micro…
/Topic/ConfiguringDriveWorksLiveForIIS
How To: Configure IIS For The Web and Application Theme - DriveWorks 22 SP0 - DriveWorks 21 delivered a major update to DriveWorks' Forms Technology. - This has be…
/Topic/ProjectEditorDocuments
Documents - Files - DriveWorks has the ability to create Documents such as Microsoft Word, Microsoft Excel, or HTML Documents. - The Documents - Files Task provid…
/Topic/HowToImplementationGuide
How To: Implementation Guide - DriveWorks has been developed with Ease of Use in mind. The intention and practise at most companies is that Engineers can impleme…
/Topic/DWHLookup
DWHLookup - Returns a value from a table corresponding to a match found in the specified row. - Syntax - DWHLookup([Value], [Table Name], [Lookup Row], [Result Row…
/Topic/HLookup
HLookup - Returns a value from a table corresponding to a match found in the first row. - Searches the first row in the selected table for a match (either exact o…
/Topic/VLookup
VLookup - Returns a value from a table corresponding to a match found in the first column. - Searches the first column in the selected table for a match (either e…
/Topic/DWVLookup
DWVLookup - Returns a value from a table corresponding to a match found in the specified column. - Syntax - DWVLookup( [Value], [Table Name], [Lookup Column], [Res…
/Topic/DriveAppsDashboard
Using The Dashboard DriveApp - The Dashboard DriveApp gives access to useful DriveWorks resources and KPI's taken directly from the Group. - Running - When the Das…
/Topic/InfoDWFileExtensions
Info: DriveWorks File Extensions - This document describes the different file extensions that are either created by DriveWorks or used by DriveWorks. - Grou…
/Topic/SpecFlowConditionEditor
Condition Editor - The Condition Editor can be used to control whether specific tasks in a task sequence are executed, or whether a specification flow operation…
/Topic/GTExportPartSize
Export Part Size - SOLIDWORKS PowerPack - The Export Part Size Generation Task will export a text document which contains the size parameters of the bounding box…
/Topic/SppTaskDeleteExcelSheets
Delete Excel Sheets - This specification task deletes a specified list of Excel Worksheets from a provided Microsoft Excel Workbook. - Microsoft Office - - Ensure…
/Topic/HowToCreateAMacroToRunOnADocument
How To: Create A Macro To Run On A Document - When creating Word or Excel documents DriveWorks will automatically execute a macro called CreateReports, if it ex…
/Topic/DriveWorksFeatureComparison
DriveWorks Product ComparisonLearn about the differences between DriveWorksXpress, DriveWorks Solo and DriveWorks Pro and decide which software solution is righ…
/Topic/IppGeneratePieChart
Generate Pie Chart - This Specification Macro Task will generate an image of a Pie chart. The appearance and data of chart can be configured using th…
/Topic/TableColumnLookup
TableColumnLookup - Returns a value from a result column corresponding to a match found in the given lookup column. - Syntax - TableColumnLookup( [Lookup], [Lookup…
/Topic/MigrationFromEarlierVersionsOfDriveWorksPro
Migration - This topic will explain the DriveWorks migration process, using the DriveWorks Migration Tool, and the steps you need to take to ensure a successful…
/Topic/ControlClipboardButton
Clipboard Button - Allows the contents of a targeted control to be copied to the clients clipboard on any device. - The Clipboard button displays a button that al…
/Topic/DriveAppsCPQ
Using The CPQ DriveApp - The DriveWorks CPQ DriveApp allows you to manage the entire sales process of your configurable products. - Administer lists of Accounts,…
/Topic/SppTaskCopyExcelSheets
Copy Excel Sheets - This Specification Flow Task retrieves a specified sheet and creates named copies. The copies can be placed at the start or end of the curren…
/Topic/IppGenerateAreaChart
Generate Area Chart - This Specification Macro Task will generate an image of an Area chart. The appearance and data of chart can be configured using the propert…
/Topic/IppGenerateColumnChart
Generate Column Chart - This Specification Macro Task will generate an image of a Column chart. The appearance and data of chart can be configured using the prop…
/Topic/IppGenerateLineChart
Generate Line Chart - This Specification Macro Task will generate an image of a Line chart. The appearance and data of chart can be configured using the properti…
/Topic/Administrator
DriveWorks Administrator - Setup and manage your automation and configurator project with DriveWorks Administrator and the SOLIDWORKS Add-in. - Getting started - I…
/Topic/HowToDriveSheetMetalParts
Introduction - DriveWorks allows sheet metal functionality to be controlled based on your rules. Some sheet metal features are fully constrained by SOLIDWORKS an…
/Topic/HowToControlProperties
How To: Reference Control Properties - There are two types of control property. These can be categorized into how the property is referenced (when used in a rule…
/Topic/DMSpecificationInformationSP4
Specification Information - The Specification Information task is used if the specification files have been moved and require re-mapping or if specification info…
/Topic/Toolbox
Toolbox - The DriveWorks Toolbox provides a set of predefined actions that can be run by DriveWorks, as Tasks, in the following ways: - - From a macro butt…
/Topic/SppTaskAddExcelSheets
Add Excel Sheets - This Specification Flow Task adds sheets to a Microsoft Excel workbook from a given table of sheet names. - Microsoft Office - - Ensure Microso…
/Topic/Glossary
Glossary - - 3 - - A - - B - - C - - D - - E - - F - - G - - H - - I - - J - - K - - L - - M - - N - - O - - P - - Q - - R - - S - - T - - U - - V - - W - - X…
/Topic/HowToCreateandInstallaFormTemplate
How to: Create and Install a Form Template - This topic shows how to create a Form Template and install it to be used for other Projects and users. - Form Templat…
/Topic/FileFilter
File Filter, Upload File Extension Filter - File Filter - The filter to use when picking a file to upload. - Upload File Extension Filter - The filter to use when…
/Topic/InfoDWLimits
Info: DriveWorks Limits - This document defines the various limits that apply in various parts of DriveWorks. - SQL Limitations - Some areas of validation in Drive…
/Topic/UserPrerequisites
Hardware - CPU Intel or AMD with SSE2 support. See Note below. - RAM 16GB or more recommended. See Note below. - Hard Disk SSD dr…
/Topic/AutopilotPrerequisites
Hardware - CPU Intel or AMD with SSE2 support. See Note below. - RAM 16GB or more recommended. See Note below. - Hard Disk SSD dr…
/Topic/AdminPrerequisites
Hardware - CPU Intel or AMD with SSE2 support. See Note below. - RAM 16GB or more recommended. See Note below. - Hard Disk SSD dr…
/Topic/ChildSpecificationListEditor
Projects - Projects are applied in the Child Specification List editor. - The Child Specification Lists reads information from the Projects that can be specified…
/Topic/HowToCopyaDriveWorks6Implementation
Introduction - This document provides an overview of the process of copying a DriveWorks 6 Implementation, so that the copy can be migrated to DriveWorks 7. - It…
/Topic/FormControlPropertiesChildSpecificationListEditor
Projects - Projects are applied in the Child Specification List editor. - The Child Specification Lists reads information from the Projects that can be specified…
/Topic/PublicVideoIndex
Title Hyperlink Applicable Products Create New Designs Through the SOLIDWORKS Task Pane http://www.youtube.com/watch?v=7wtCi6BdhCs DriveWorks Pro Set up Item Li…
/Topic/ControlDataGrid
Data Grid - This control has been superseded with the Data Table control. - Data Grid Control End of Life - DriveWorks v10 introduced the Data Table control as a s…
/Topic/SysproGetAllAccountDetail
SysproGetAllAccountDetail - Returns an array of every item held in the Customer table of the SYSPRO database. - This function can return large amounts of data tha…
/Topic/SysproGetAllItemDetail
SysproGetAllItemDetail - Returns an array of every item held in the Inventory table of the SYSPRO database. - This function can return large amounts of data that…
/Topic/9DriveWorksAdminWhatsNew
DriveWorks Administrator Enhancements - - DriveWorks Administrator start-performance has been greatly improved. - - DriveWorks Administrator will automatically…
/Topic/SysproTaskGenericAddData
SYSPRO - Generic Add Data - Adds data to the SYSPRO Implementation by running a setupadd post to SYSPRO - Properties - Property - Description XMLParam…
/Topic/SysproTaskGenericUpdateData
SYSPRO - Generic Update Data - Updates data in the SYSPRO implementation by running a Setupdate post to SYSPRO. - Properties - Property - Description…
/Topic/XPathGet
XPathGet - Finds the value at a given path in an XML or JSON string. - Syntax - XPathGet([Input Data],[Path]) - Where: - Input Data is the input data on which to sea…
/Topic/GTDriveGeneralTable
Drive General Table - The Drive General Table Generation Task will drive tabular data into the specified table. - Properties - Property Name Description Table Data…
/Topic/SppTaskReplaceImagesInWordDocument
Replace Images in Word Document - This Specification Task inserts an image into a Word document to replace an existing shape that has a specific title. - Microsof…
/Topic/CommonFunctions
Functions - The following is an index of all functions available from the Rules Builder. - This does not include any functions installed with any plugin. - All fun…
/Topic/WhatsNewDriveWorks12AdminRollUpTable
Rollup Data Table - Rollup Data Tables are a way to gather data from multiple levels of child specifications and roll them up into a table in a parent specificat…
/Topic/InfoSolidWorksPDM
SOLIDWORKS Product Data Management - Please see Prerequisites for the supported SOLIDWORKS PDM versions. - - Knowledge Base Article Ref: KB15122201…
/Topic/SysproTaskTransactionPost
SYSPRO - Transaction Post - Runs a transaction post to SYSPRO. - Properties - Property - Description XML Params The xml containing the beha…
/Topic/19SP1Information
DriveWorks V19 SP1 Information - SQLite - We have replaced the use of SQL Compact with SQLite as its underlying database for Individual Groups and exported report…
/Topic/DriveWorksCPQDataAdmin
Managing Data for the CPQ DriveApp - The CPQ DriveApp allows you to add and manage data needed for creating custom quotations and orders. - The DriveApp gives you…
/Topic/GTExportCustomProperties
Export Custom Properties - SOLIDWORKS PowerPack - The Export Custom Properties Generation Task will export a text document with any custom properties used in the…
/Topic/ODBC_Data_Export_Document
ODBC Data Export - DriveWorks has the ability to export data to an external database (using a Microsoft Windows ODBC connection) as part of running a DriveWorks…
/Topic/GetData
GetData - The GetData wizard retrieves database data from an ODBC data source. - Using the GetData wizard, DriveWorks allows you to connect to existing data withi…
/Topic/HowToSetupaDSNAccess
How To: Set up a DSN-Access - On a 32bit machine the ODBC can be found at Start > Programs > Control Panel > Administrative Tools > Data Source (ODBC…
/Topic/SysproTaskTransactionBuild
Transaction Build - Runs a transaction build to SYSPRO. - Properties - Property - Description XML Data The xml containing the business obje…
/Topic/SysproGetTableDataAsXML
SysproGetTableDataAsXML - This function returns a data object as XML. It has 2 methods of operation: - Syntax - Method 1: - SysproGetTableDataAsXML([XML Data]) - Whe…
/Topic/Multiline
Multiline - The Multiline property allows data to be entered into a text box on separate lines. - Property Type: Fixed - Default Value: False - Hierarchical Referen…
/Topic/RollUpDataTable
Rollup Data Table - Rollup Data Tables are a way to gather data from multiple levels of child specifications and roll them up into a table in a parent specificat…
/Topic/HowToDiagnoseProjectIssuesUsingDriveWorksSpecificationReport
How To: Diagnose Project Issues Using DriveWorks Specification Report - DriveWorks produces Specification reports each time a specification is transitioned. - All…