Delivery Import
The section outlines how to use the import button found inside the delivery section.
Purpose
The Import function is designed to speed up the delivery creation process when scaffold or formwork structures are built in CAD software.
Some CAD systems can generate a material or component list as an export. Instead of manually adding each component into the delivery one by one, the Import function allows that exported list to be uploaded directly into the delivery.
This helps reduce manual data entry, improve accuracy, and save time when processing large deliveries.
Requirements
To successfully import a CAD component list into a delivery, the exported component data should match the inventory records stored in Cloudscaff.
The following fields can be used for matching:
Code
Category
Size
Name
Location
The more matching information available, the more accurate the import process will be.
At minimum, the import requires either:
A matching Code, or
A matching Name
If neither of these fields exist or match an inventory item in Cloudscaff, the component will not be recognized during the import process.
Process
Phase 1: Download your Cloudscaff inventory list
Inside the delivery, click the Import button in the top right corner.
This will open the Import Inventory List window and guide you through the import process.
Click Download List.
This will download your full Cloudscaff inventory list in Excel format. The export includes the following columns:
id
Internal Cloudscaff item ID
code
Component code
category
Component category
size
Component size
name
Component name
location
Current inventory location
totalQty
Total quantity in the system
availableQty
Available quantity
orderQty
Quantity currently on order
deliveredQty
Quantity already delivered
deliveryQty
Quantity to deliver
Phase 2: Choose the correct import template
Now that you have downloaded your Cloudscaff inventory list in Excel format, you need to use it together with one of the Cloudscaff import templates.
There are two import templates available:
Cloudscaff Import Inventory Template Using Code
Cloudscaff Import Inventory Template Using Name
Which template you use depends on the information available from your CAD drawing export.
Using Code
Your drawing export contains component codes
Using Name
Your drawing export contains component names
Cloudscaff Import Inventory Template Using Code
Cloudscaff Import Inventory Template Using Name
Understanding how the template works
The import template works by comparing your CAD drawing list against your Cloudscaff inventory list.
The template contains two tabs:
Cloudscaff Inventory List
Paste Your Cloudscaff Inventory export here
DrawingList
Paste Your drawing or CAD component list here
The process works like this:
You download your Cloudscaff inventory list
You paste that inventory list into the template
You paste your CAD drawing list into the DrawingList tab
The template automatically matches the items together
The delivery quantities are automatically populated
You export the "Cloudscaff Inventory List" as a CSV
You upload the CSV back into Cloudscaff
If the component names or codes match correctly, the import will prepare the delivery automatically for you.
Phase 3: Paste your Cloudscaff inventory list into the template
Open the downloaded Cloudscaff inventory list.
Copy all the rows from the downloaded file from the following columns.
id
code
category
size
name
location
deliveryQty
Then open the import template and paste the data into the tab called:
Cloudscaff Inventory List
This gives the template a full copy of your Cloudscaff inventory database so it can perform the matching process.
Phase 4: Paste your drawing list
Go to the tab called:
DrawingList
This is where you paste the material list generated from your CAD drawing.
Depending on which template you are using:
Paste the Code and Quantity, or
Paste the Name and Quantity
You only need:
The component Code or Name
The required Quantity
Example using codes:
STD-3M
120
LEDGER-2M
45
Example using names:
Standard 3m
120
Ledger 2m
45
How the automatic matching works
The template automatically compares:
The Code or Name from the DrawingList tab against
The Code or Name in the Cloudscaff Inventory List tab
If they match correctly:
The delivery quantities will automatically populate
The correct Cloudscaff inventory items will be prepared for import
If something does not match:
The quantity will not populate
The item may be skipped during import
This is why your component names or codes must match the Cloudscaff inventory records correctly.
Important Notes
Do not delete the id column
The id column is required by Cloudscaff during the import process.
If the id column is removed or changed, the import will fail.
Do not change column names
Keep all column names exactly as they are in the template.
Only update the deliveryQty values
The template is designed to automatically populate the correct delivery quantities.
Phase 5: Export the file as CSV
Once all quantities have populated correctly:
Open the Cloudscaff Inventory List tab
Click File
Click Save As
Select:
CSV (Comma delimited) (.csv)
Save the file.
Phase 6: Upload the CSV into Cloudscaff
Return to Cloudscaff.
In the Import window:
Click Upload CSV
Select the CSV file you exported
Confirm the upload
Cloudscaff will then automatically build the delivery using the imported quantities.
Last updated