SharpSync
  • Welcome
  • Fundamentals
    • Getting Started
      • Registration
      • Landing Page
      • Support
      • Subscription
    • Data Sources
    • Property Mappings
    • Rule Templates
    • BOM Comparison
    • Data Safety
    • Troubleshooting
      • Duplicate component paths
      • OAuth 2.0
  • Data Sources
    • Autodesk Inventor
    • CSV
      • Getting Started
      • Importing a Bill of Materials (BOM)
    • MS Dynamics 365 Business Central
      • Getting Started
      • Item Fields Json & Internal Names
      • Resource Fields Json & Internal Names
      • List Names For nestedObject Mappings
    • NetSuite
      • OAuth Setup
        • Permissions
      • Suite API Setup
      • Create an uploads folder
      • Setting up a thumbnail folder
      • Authentication + Configuration
      • Common setup
        • Configure quantity mapping
        • Configure accounts mappings
        • Configure itemType mapping
        • Configure isPhantom mapping
        • Configure subsidiary mapping
        • Configure price mapping
        • Configure Where Used Link mapping
        • Configure thumbnail mapping
        • Common Mapping Rules
        • Common List names
      • Advanced Bill of Materials
      • Configure Server Side Script
        • Example Server Side Script
      • Configure SharpSync to use Server Side Script
      • Configure Routings
      • Integration tips
      • Troubleshooting
    • Odoo
      • Getting Started
        • Authentication + Configuration
        • Debugging tips
      • Common Setup
        • Map BOM Codes
        • Map BOM Types
        • Map Attribute Values
          • Reading Attributes - Overview
          • Display All Attribute Names
          • Display Single Attribute Values
          • Writing attributes
      • Product Management
      • Hosting Options
      • List Names
      • Permissions
    • Onshape
      • Getting Started
      • Setting up Derivatives
    • Propel PLM
      • Getting Started
    • SolidWorks
    • SolidWorks PDM
      • Downloading and installing the add-in
      • Configure the add-in
      • Setting up the Solidworks PDM Web 2
      • Troubleshooting
      • Submitting a BOM for update
  • Property Mappings
    • Property Mapping Settings
      • Rendering Types
    • Rule Templates
      • Import / Export
        • Append text
        • Calculate number
        • Export manipulation
        • Format as decimal number
        • Prepend text
        • Remove property
        • Replace all instances
        • Replace first instance
        • Round to nearest X
        • Select from JSON
        • Set cell value
        • Set empty cells
        • Text manipulation
      • Display
        • Number between
        • Text contains
        • Text ends with
        • Text evaluation
        • Text is a number
        • Text is exactly
        • Text is in list
        • Text is not a number
        • Text is not empty
        • Text is not in list
        • Text length between
        • Text length is exactly
        • Text maximum length
        • Text minimum length
        • Text not contains
        • Text not ends with
        • Text not starts with
        • Text starts with
  • Advanced
    • Derivatives
    • Advanced Scripting
  • User management
    • User Management
    • Application Permissions
Powered by GitBook
On this page
  • Transferring a Drawing URL
  • Transferring a Drawing PDF
  1. Data Sources
  2. Onshape

Setting up Derivatives

Derivatives are files that are derived from other files or documents.

See also Derivatives.

In Onshape, derivatives are primarily files used for exporting, such as PDF, DXF, ZIP, IGES, etc.

Onshape is different to a typical offline CAD file or PDM system in that it does not store 'Files'. It stores Documents. Each document may contain one ore more elements (documents within documents). Each element may be one of the following:

  • A single part body document

  • A multi-part body document

  • An assembly

  • A drawing

  • A derivative (PDF, DXF, IGES)

  • An import (e.g. STEP, IGES, ZIP, etc)

Derivatives supported by SharpSync are all types that can be derived from native Onshape Types. This means that:

  • If you can export it from Onshape using an "Export" option then ...

  • You can use it in SharpSync.

To setup derivatives in SharpSync, navigate to the Derivatives section. The procedure is explained in that section. What is not explained there, are how to setup derivatives of Drawings, which themselves are derivatives of CAD models. This will be explained below

You must be an organization admin to be able to do this

In this section, we'll talk you through:

  • Transferring a Drawing URL

  • Transferring a Drawing PDF

Transferring a Drawing URL

There is only a single option for Onshape drawings, and that is the transfer of the URL. You cannot transfer the drawing itself. To transfer a drawing, you must convert it to a PDF first or let SharpSync do the conversion for you. To convert a drawing to a PDF, the drawing must exist first.

Navigate to the 'Derivatives' section.

Add a new derivative by Selecting 'Drawing'

Configure the settings as shown below

Derivative Setting
Description
Value

Template

The derivative header name as the user will see it. Modify to suit your needs.

DRAWING

Extension

The default extension you wish to use when moving the file from Onshape to your ERP. Modify to suit your needs.

drawing

Search pattern

The search pattern to use when searching for documents in Onshape. Only exact matching results are returned. Modify to suit your needs.

DRW-{rowData.componentName} The above is a suggestion only, but note that if you use different naming conventions or more than 1 naming convention, then multiples of DRAWING derivatives must be added. Using the example above, if the document name is A1 then the search will be for DRW-A1

Naming Pattern

The naming pattern to use when generating new documents. Modify to suit your needs.

{rowData.componentName}-{rowData.cells.revision} The above suggestion

Generate for Drawings

checked

Property Mapping

The property mapping to use when setting the value. You must have a property mapping value set if you want to transfer a url

This value will be customer specific. Select a Property Mapping. Mine was called drawingUrl

Transfer URL

Whether to transfer the URL by default. If unchecked, the user must manually check this option every time.

checked

Enabled

Whether the template may be accessed by users when displaying BOM data

checked

Now that we have the derivative template setup, we are ready to transfer the drawing URL to a property in our destination ERP. To do this:

  • Load a bill of material in SharpSync

  • Look for drawing rows (Default color is a blue-ish color and it will have the same name as the part or assembly

  • Click the button to the right (looks like a Folder +)

  • Add a new derivate (Pick the drawing template we just setup)

  • The values are filled based on the settings and the row's cells.

  • Click the Submit button.

  • When the BOM has finished processing, the URL of the drawing will be written to the ERP.

Transferring a Drawing PDF

A PDF is a derivative of a drawing. The structure at the moment is

Assembly > Drawing > PDF

The assembly must exist for the drawing to exist. The drawing must exist for the PDF to exist.

The next step is to create the PDF derivative template and then use it in the BOM view.

  • Navigate to the Derivatives section

  • Add a new Derivative Template > Pick PDF

Configure the settings as shown below:

Derivative Setting
Description
Value

Template

The derivative header name as the user will see it. Modify to suit your needs.

PDF

Extension

The default extension you wish to use when moving the file from Onshape to your ERP. Modify to suit your needs.

pdf

Search pattern

The search pattern to use when searching for documents in Onshape. Only exact matching results are returned. Modify to suit your needs.

At the time of writing, pre-generated PDFs are not supported, so leave this field empty.

Naming Pattern

The naming pattern to use when generating new documents. Modify to suit your needs.

{rowData.componentName}-{rowData.cells.revision} The above suggestion

Generate for Drawings

Checked

Property Mapping

The property mapping to use when setting the value. You must have a property mapping value set if you want to transfer a url

This value will be customer specific. Select a Property Mapping. Mine was called drawingUrl

Transfer File

Whether to transfer the File by default. If unchecked, the user must manually check this option every time.

checked

Enabled

Whether the template may be accessed by users when displaying BOM data

checked

Now that we have the derivative template setup, we are ready to transfer the drawing PDF to our destination ERP. To do this:

  • Load a bill of material in SharpSync

  • Look for drawing rows (Default color is a blue-ish color and it will have the same name as the part or assembly

  • Click the button to the right (looks like a Folder +)

  • Add a new derivate (Pick the drawing template we just setup)

  • The values are filled based on the settings and the row's cells.

  • Click the Submit button.

  • When the BOM has finished processing, the PDF of the drawing will be saved to the ERP.

PreviousGetting StartedNextPropel PLM

Last updated 3 days ago

A derivative button appears when valid derivative templates exist
The Store URL checkbox is automatically selected based on our template settings
A derivative button appears when valid derivative templates exist
The Store File checkbox is automatically selected because of our template settings