POWERLOAD

This PowerShell extension for powerLoad, is designed to streamline and automate various tasks related to data loading into Vault using the Autodesk DTU (aka. BCP). The load scenarios can be a data loading

• ... from file system,
• ... from a competitive or legacy system,
• ... or from Vault to Vault (merge, clean-up or move).

In all 3 cases, you must

1. prepare your data so that it matches your target Vault,
2. validate if your data fits with your target Vault,
3. and create a valid DTU package which can be loaded into your Vault.

powerLoad helps you do just that. Your data is imported into a temporary powerLoad database where you can perform all necessary data manipulations at high speed, e.g. adding, removing or renaming properties, cleaning values, moving/renaming files and folders, checking and resolving file references and much more. Then powerLoad checks if your data matches the target vault to prevent the load from failing and finally creates a BCP package. powerLoad supports Delta-Loads for files, so you can create BCP packages that build on each other to overcome short windows of time in large data load projects.

Supported Vault versions

Vault Professional 2024, 2023, 2022

Known limitations and issues

Status at 22.01.2024

• Import-BCP ignores secodary associated files
• Import-BCP does not import Folder-File Links
• Import-BCP does not import Folder-Folder Links
• Import-BCP does not import Folder-Item Links
• Import-BCP does not yet support delta
• Export-BCP does not yet support delta
• Item BOMs are current not supported
• File BOM blobs not support. However, in case of a Vault to Vault migration, the IDs remain the same, so the existing BOM blobs can be reused.
• Database field AlternativeReferenceFullPath not yet supported

Prerequisites

Operating System: Windows 10 and 11

Installed Programs: Autodesk Vault, coolOrange powerLoad/bcpToolkit V24 (download), Microsoft PowerShell, AutoCAD Mechanical if AutoCAD DWGs and/or Inventor if Inventor files to be analyzed for missing references

Database: MS SQL Server 2017 or newer

Installation

1. Download bcpToolkit and run installer. You might unblock the exe before running the installer.
2. Download the Zip-File for your Vault version from the Release area. You might unblock the ZIP before extraction it.
3. Extract the Zip-File into a local folder of your choice, e.g. "C:\coolOrange\powerLoad".
4. If necessary, unblock all .dll Files or Run the script as Administrator (select all files, right click > properties, unblock).
5. Create a new PowerShell script or use a sample from the Samples folder.

Functions overview

The powerLoad extension provides the following CmdLets:

• Connect-powerLoadDatabase: Creates or opens the powerLoad database
• Import-BCP: Imports the BCP packages into the powerLoad database.
• Import-FilesToDatabase: Imports the files into the powerLoad database
• Get-VaultData: Imports data from Vault using a saved search
• Invoke-PowerLoadSql: Executes SQL statements to manipulate the data
• Add-PowerLoadUDP: Adds a user defined property to the powerLoad database.
• Remove-PowerLoadUDP: Removes a user defined property from the powerLoad database.
• Rename-PowerLoadUDP: Renames a user defined property in the powerLoad database.
• Resolve-AutoCadReferences: Checks the AutoCAD references and lists the references that could not be resolved.
• Resolve-InventorReferences: Checks the Inventor references using the Inventor project file and lists the references that could not be resolved.
• Test-PowerLoadDataBase: Tests the powerLoad database for errors.
• Test-PowerLoadVaultBehaviors: Tests your powerLoad data against your target Vault behaviors (configuration)
• Export-BCP: Creates a DTU/BCP package

Quick start

Create a PowerShell Script, copy this code, and adapt and extend as needed.

$exportPath = "c:\temp\test_export" #path to where the DTU (BCP) packages shall be created
$powerLoadPath = 'C:\temp\powerLoad\v1.0.28' #path to the powerLoad DLL
Get-ChildItem -Path $powerLoadPath -Filter *.dll -Recurse | Unblock-File
Import-Module "$powerLoadPath\powerload.dll" 
Connect-powerLoadDatabase -Server "MARCOMIRAND7E20\POWERLOAD" -DatabaseName "test" -User "sa" -Password 'Pa$$w0rd' #connect to database 

$files = Get-ChildItem -Path "C:\Autodesk\autodesk_inventor_2019_samples_sfx\Models\Assemblies\Scissors" -File -Recurse
$rootDirectories = @{"$importPath"='$/Designs/Scissors'}
$result = Import-FilesToDatabase -Files $files.FullName -rootDirectories $rootDirectories -ErrorCSVPath "$exportPath\importErrors.csv"

$projectFile = "C:\Autodesk\autodesk_inventor_2019_samples_sfx\samples.ipj"
$refCheck = Resolve-InventorReferences -InventorProjectFile $projectFile -ErrorCSVPath "$exportPath\RefErrors.csv"

$dbCheck = Test-PowerLoadDataBase -ErrorCSVPath "$exportPath\dbErrors.csv"

$vaultCheck = Test-PowerLoadVaultBehaviors -Server "localhost" -Vault "Vault" -User "Administrator" -Password "" -ErrorCSVPath "$exportPath\vaultErrors.csv"

Export-BCP -ExportDirectory $exportPath

Please Note:

This software is not fully tested or officially supported. It should be used at your own risk. While coolOrange invests significant effort in delivering a stable, high-performing, and comprehensive solution, we acknowledge that the software may have issues.

Using this software:

We strongly recommend collaborating with coolOrange when utilizing this software to ensure that we can work together to address any problems that may arise. While coolOrange is committed to enhancing and rectifying the software, there is no guarantee regarding the timing or certainty of these improvements.