Overview

There are multiple types of imports which can be used to upload data into Makersite. Makersite is extremely flexible and can understand a growing number of import formats with different rows and columns. This document provides an overview of some of the key minimum criteria and requirements which are most commonly used for imports but this list is not exhaustive.

For more information on import tools and how to prepare files, please refer to supporting documentation in FAQ: Import tools

BOM Importer

The BOM importer allows for quick upload of bill of materials (BOM) or product data in a range of different formats. For more information on how to prepare files for import and to download an import template, please refer to supporting documentation in FAQ: BOM files preparation

After dragging and dropping a bill of materials, the inputs are mapped with materials, product groups, processes, substances or resources to enrich the supply chain and create the digital twin.

There is a complex algorithm behind the BOM importer functionality but an attempt to simplify the most common use of the logic has been described below.

There are two ways to match datasets: “Alternative” or “Composition”

  1. Alternative is the most common type of matching which connects the same or similar datasets to provide representative results. A single BOM item is matched to a single alternative (1 for 1). The imported BOM structure is replaced with the matched dataset. For example: capacitor 1 = capacitor X5R or polypropylene = polypropylene injection moulding

  2. Composition matching can also be used to define the structure of a dataset. It includes multiple datasets which make up the dataset which is being defined (1 to multiple). The imported BOM structure remains intact with the matched dataset shown downstream. For example: Steel = Chromium + Nickel (99.5%) + Manganese + Silicon + Iron or Pen = Cap + Barrel + Ink… etc…

Matching to datasets on Makersite is prioritized by GUID, CAS and composition in this order to build the dataset.

File types: excel, csv

Minimum required fields

There are very few fields which are actually mandatory to create a model from BOM import within Makersite. These are shown in the table below.

Columns

Description

Input Format

Output/Result

Level

Structure of BOM or assembly (0, 1, 2 etc)

Number

Adds assembly structure and builds visuals

Name

Name of product, chemical, material, process, lifecycle stage, etc.

Mixed

Assigns name and used to match datasets

Amount

How much of the named dataset

Number

Adds quantity

Unit

In which units is the amount (units, kg, m2, litres, metric ton*km, etc)

Mixed

Assigns units to amount

Example 1

Level

Name

Amount

Unit

0

Motorbike

250

kg

1

Engine

50

kg

2

Cylinder block

30

kg

3

Cast iron

30

kg

2

Cylinder head

20

kg

3

Cast iron

20

kg

1

Frame

40

kg

2

Front forks

20

kg

3

Aluminium

10

kg

etc..

etc..

etc..

etc..

Additional required fields

The list is almost endless of additional fields that can be added to Makersite. If you would like a dataset to include a column for new data, simply add a column with the required heading and Makersite will include this field when the dataset is created. The table below includes just a few of the most common additional fields.

Columns

Description

Input Format

Output/Result

GUID

Globally unique identifier or a unique identifier for the dataset

Mixed

Assigns ID and used to match datasets

Part number

Part number for the dataset

Mixed

Assigns PN and used to match datasets

MPN

Manufacturer part number

Mixed

Assigns MPN and used to match datasets

Synonym

Abbreviation, alternative name or specification (polypropylene = PP)

Mixed

Adds synonym for matching alternatives

Category

Product category such as UNSPSC for electronic components

8-digit number

Assigns MPN and adds category characteristics

CAS

CAS registry number for chemical substances, up to 10 digits long

xxxxxxx-yy-z

Assigns CAS# and used to match datasets

Min / Max concentration

Specify minimum or maximum percentage of CAS# in composition

Number between 0 and 1

Assigns min / max values

Supplier

Specify the supplier for the dataset

Mixed

Adds supplier details

Example 1

Level

Name

GUID

Synonym

Amount

Unit

0

Motorbike

001

Raptor45

250

kg

1

Engine

101

50

kg

2

Cylinder block

102

30

kg

3

Steel

1.4301

30

kg

2

Cylinder head

103

20

kg

3

Steel

1.4301

20

kg

1

Frame

201

40

kg

2

Front forks

202

20

kg

3

Aluminium

6082-T6

10

kg

etc..

etc..

etc..

etc..

etc..

etc..

Example 2

Level

Name

CAS

Min concentration

Max concentration

0

Material spec

1

Steel 1.4301

2

Chromium

7440-47-3

0.18

0.19

2

Nickel (99.5%)

7440-02-0

0.8

0.9

2

Manganese

7439-96-5

0.2

0.2

2

Silicon

7440-21-3

0.0075

0.0075

2

Iron

7439-89-6

0.7125

0.6925

Other importers

The table below lists a summary of the other importers and format requirements.

Importer

Format

Documentation

File Types

BOM importer

As above

As above

excel, csv

Supplier importer

Coming soon

Coming soon

excel, csv

EcoSpold importer

Standard EcoSpold format

FAQ: EcoSpold Importer

xml, spold

Compliance list importer

See FAQ

FAQ: Restricted Substance List Import

excel, csv

CAD importer

Coming soon

Coming soon

Coming soon

IPC importer

Standard defined IPC2581 format

FAQ: IPC File Import

xml

If you have any further questions or would like to know more, please feel free to connect with the team for more information.

Did this answer your question?