About BiI

BiI ERP-PDM is now under development

  • Further development of SAP-PDM while retaining existing functionality
  • Straightforward integration into other ERP systems
  • A powerful serial number generator based on BiI SWSNG

BiI SAP-PDM is a powerful and lightweight solution for

  • the automatic bidirectional synchronisation of data between PDM and SAP
  • the guaranteed data consistency of the data in BiI's responsibility
  • the management of BOMs from CADs not supported by the PDM
  • the management of neutral formats (DWG, DXF, PDF...) outside the vault
  • the automatic providing of data, e.g. neutral formats, inside SAP
  • the even more simple integration of the PDM into existing systems

BiI SOLIDWORKS PRODUCT CONFIGURATOR for EXCEL
is a powerful and lightweight solution for the automatic

  • creation of products and their variants in CAD
  • creation of 3D models and drawings
  • creation of neutral formats in 3D/2D
  • creation and managing BOMs
  • managing of configured products

BiI SWPAW is a powerful and lightweight solution for

  • the development of add-ins in any programming language supported by Windows
  • the rapid development of add-in prototypes
  • the control of the authorisations for add-in execution
  • the integration of existing programmes and solutions into PDM

BiI SWSNG is a lightweight solution for

  • the automated number assignment for new parts in a multi-user environment
  • the use of any number ranges in any folder strucures
  • using the automatic number assignment directly from the CAD system
  • eliminating the limitations of PDM number generators

Why BiI

Open Source Code
  • Complete transparency by owning the source code

BiI ERP-PDM

Data Migration
  • Import of ERP data into CAD/PDM
  • Import of CAD/PDM data into ERP
Data Consistency
  • Data synchronisation only possible if predefined specifications are adhered to
  • Strict separation of master data maintenance between departments
  • Logging of all transactions in the BiI Database
Economical
  • No costs due to double data maintenance
  • No additional PDM licence required
  • Simple integration into the existing work environment
  • Short implementation and training time
  • Straightforward integration into any ERP system
Increasing Efficiency
  • No manual, lengthy and error-prone data synchronisation
  • Data check and synchronisation between PDM and ERP at the touch of a button
  • Optimised SolidWorks Convert Task for faster neutral format creation
  • Meaningful status and error information during synchronisation
  • A powerful serial number generator based on BiI SWSNG

BiI SAP-PDM

Equivalent to BiI ERP-PDM plus
  • Only one additional SAP licence required
  • The workflow is optimised for SAP Business One and Beas
  • Automatic collection of e.g. neutral formats for orders inside SAP

Workflows are usually automated when the time required for manual data maintenance is no longer in a cost/benefit ratio. At this time, there is usually so much data available, that migration is unavoidable. Due to several successful migrations, tools are available that can be customised to individual needs with relatively little effort.

BiI SOLIDWORKS PRODUCT CONFIGURATOR for EXCEL

Configuration Logic
  • For the easy modelling of logical processes and complex calculations, Excel was chosen as interface between Configurator and SolidWorks
Customisation
  • For the easy customisation of the Configurator, VBA was chosen for creation of 3d models and 2D drawings in SolidWorks
Way of Working
  • 3D models and 2D drawings can be created with templates or from scratch. Of course a mix of both is also possible
Integration Environment
  • The kernel of the Configurator is a SQL-Server 2016, which can also be used in the free version

BiI SWPAW

Programming and Scripting Languages
  • Any language supported by Windows can be used
  • Scripts and programmes can be written in different languages
Authorisations
  • Execution of commands can be controlled by user groups and computers
Error Handling
  • Robust error handling routines integrated in the wrapper
  • Routines have to be written only for the part that extend the add-in
Existing Soloutions
  • Existing programmes can be easily integrated into the PDM if they can be controlled via command line

BiI SWSNG

Multi-User Capability
  • Number assignment is based on an SQL Database
SolidWorks CAD
  • Easy integration into CAD
  • The source code for a CAD add-in is integrated
SolidWorks PDM
  • Easy integration into PDM

About Me

Often, software systems that are not compatible with each other, are used. There is great potential for optimisation in order to reduce the resulting costs permanently. For this reason, in the last few years I have specialised in the administration and customising of ERP, CAD and PDM systems, the development of interfaces for data exchange and tools to efficiency increase.

Based on my professional experience as an administrator, programmer, engineer, production planner and mechanic, I have the understanding of cross-departmental workflows and the resulting needs for process optimisation. With this knowledge and my programming skills, I am able to realise specific software tools for process optimisation in record time.

My software and programming skills
Virtualisation VMware, Microsoft Azure
Administration Windows-Server, SQL-Server, SolidWorks CAD, SolidWorks PDM, SAP Business One/beas
Programming languages C#, Transact-SQL, VisualBasic, Visual Basic for Applications, Visual Basic Script, AutoHotkey
API programming SolidWorks CAD, SolidWorks PDM, SAP Business One, Microsoft Office
VBA programming SolidWorks CAD, SolidWorks PDM, MS-Excel, MS-Project
CAD SolidWorks, Unigraphics NX, ThinkDesign, AutoCAD
CAM WorkNC, MasterCAM, HyperMill
CNC controls DIN, Heidenhain TNC

BiI ERP-PDM V0.7.0

Preconditions

Hard
  • & Software
  • Specification

    Overall System
    • ERP or PDM as leading system
    • Bidirectional synchronisation
    • Managing CAD neutral formats (DWG, DXF, PDF...) outside the vault
    • Meaningful status and error information during synchronisation
    • Plausibility check according to specific guidelines before each synchronisation
    • Differentiation of mandatory data and optional data for item creation and update in ERP
    • Number ranges with unique number pairs between ERP and PDM
    • Preventing uncontrolled item creation or update
    • SQL-Server as the interface for data exchange
    • Logging of all transactions in the BiI Database
    PDM
    • No additional licences
    • Managing BOMs from any CAD system, also from systems not supported by PDM
    • Reading out BOMs from a predefined configuration in SolidWorks CAD
    • Reading and writing of the variables from or to a predefined configuration
    • Transfer of master data and BOMs in last version to ERP
    ERP
    • Automatic item number assignment on new creation
    • Updating all mandatory data during each synchronisation
    • Detecting and preventing unauthorised changes to marked fields before every master data update
    • Logging all transfer to the ERP system for complete traceability

    BiI SAP-PDM V0.6.0

    Preconditions

    Hard
  • & Software
  • Specification

    • Please refer to BiI ERP-PDM V0.7.0

    BiI SWPAW V0.2.0

    Preconditions

    Hard
  • & Software
  • Specification

    • A wrapper for all PDM events except tasks and serial numbers
    • Expandable by any programming and scripting language available under Windows
    • Controlling the behaviour of the add-in via an INI file and RegEx
    • Sharing information between programmes and scripts via files in INI format
    • Providing a set of default information for each event
    • A debug mode for measuring execution times and debugging scripts

    BiI SWSNG V0.2.0

    Preconditions

    Hard
  • & Software
  • Specification

    • Automatic number assignment for new parts, also without PDM
    • Multi-user capability due to the central SQL database
    • Individually customisable

    Features

    BiI ERP-PDM V0.7.0

    • Managing BOMs in PDM from any CAD system, even if the CAD is not supported by the PDM
    • Managing CAD neutral formats (DWG, DXF, PDF...) outside the vault on a file server
    • Managing PDM configurations as items in ERP
    • Synchronisation can be restricted to defined PDM workflow status
    • Managing of PDM assemblies in ERP as a purchase part without a BOM if the BOM is not needed
    • Default PDM values ​​for data transfer to ERP
    • Number ranges in unique n:m relationships
    • Using of SolidWorks BOMs
    • Support of multilingual translation in ERP
    • Implementation of all tables, stored procedures, functions, settings etc. into the BiI database
    • Source code based on SAP-PDM V0.6.0

    BiI SAP-PDM V0.6.0

    Equivalent to BiI ERP-PDM plus
    • Configurator to easily create and customise BiI
    • Integrated web server

    BiI SWPAW V0.2.0

    BiI SWSNG V0.2.0

    BiI VBADC V0.1.0

    BiI SWPAW V0.2.0

    The source code of the SolidWorks PDM Add-In Wrapper is now available on GitHub.

    BiI SWSNG V0.2.0

    The source code of the SolidWorks Serial No. Generator is now available on GitHub .

    BiI VBADC V0.1.0

    The source code of the SolidWorks Serial No. Generator is now available on GitHub .