Importing data, made easy

thumbnail

on June 10, 2020 • Back to Blog index

Data migration is always a large investment when running a PLM project. Whether it is for a complete implementation project or to run a proof of concept, the import process can take longer than expected.

Excel is still a great flexible UI

Even when you are building large and complex migration projects with great ETL solutions (which we believe can still really help with migration) you always have some data in excel files. It allows to tune the data, run some data cleansing with a good amount of freedom. The UI is just easy for the human brain, therefore we decided we needed to give a simple path from an Excel spreadsheet to Ganister PLM Database.

Let the datamodel build your template

The First step consists in building the spreadsheet template. It will generate an excel spreadsheet based on the objects you want to import.

  1. the system reads your datamodel
  2. it asks you which nodetypes (part,document,…) you want to import
  3. it asks you which relationship you would like to import
  4. it creates and open the spreadsheet.

Automated import from spreadsheet

Once you are done with filling data in your spreadsheet, re-run the following command

npm run dataLoader

And this time you will select the import data command which will just ask you to back up your data and then will process the import. Under the hood it splits the Excel workbook into smaller individual CSVs, it processes all the nodes and then the relationships.

Have a look !