Pile Cut-off Level using Dynamo

If you are following my post, previously I looked at exporting the pile coordinates either from Survey Point or Project Base Point and explained in details where the results coming from with the help of diagrams. If you missed that section, you better go back to that article first before continue reading this one.

Here is the link for that article: Exporting Pile Coordinate from Survey Point instead of Project Base Point

Today, I want to give an update to my Dynamo script; to include in my final output the “Pile cut-off level” values for each individual piles on my project.

Here is the project that I’ll be looking at:


And I want to have the same result using the revised Dynamo script to one shown below.

Here is what the script looks like before from Exporting Pile Coordinate from Survey Point instead of Project Base Point:

And here is it now after the upgrade:

And the result when I “Run” the script and the comparison to Excitech Tools:

The first update I did was to extract the z-coordinates (Point.z node) and add 75mm (check this value with your structural engineer) for the “Embedment Length”, then round-up the result before converting the units from millimeters to meters. One thing that you need to make sure is that your pile is attached to the bottom of your pile cap. The 75mm embedment length calculation begins at the top most level of the pile.

Another update I did was to convert the result from “String.Remove” node to number using “String.ToNumber” node in order for me to convert the unit as well from millimeters to meters. As you may already know, the information provided by “String.Remove” node are considered as string and this is the reason why I need to convert it to number first in order for the “Divide” node to work.

And finally, add a new item, item4, from List.Create node to include the pile cut-off level.

Now I am ready to assign this values to my Northing, Easting and Pile Cut-off Level project parameters using my separate Dynamo script.

You can use this workflow if you don’t have Excitech Tools installed on your machine as part of your Revit Add-ins.

If you want to give it a try, here is the script.

Have a great day!


Allan Cantos EngTech MICE

BSc. Civil Engineering / Principal Structural Technician

My BILT Europe 2018 visit has now come to an end

Thank you BILT Europe for the opportunity to be part of speakers family. My third time presenting my topic this year about Revit-Dynamo-Power BI Workflow but this time, in a class/laboratory setting (with some update and added automation).

Thank you @Cameron Brennan for sorting out all the necessary files and software needed for my session.

The Fun Fair gathering last night was really enjoyable; and I had sleepless night.

@Silvia Taurer @Rui Gavina

#datamining #revit #builteurope #bilt #rtc #bim #enjoyment #dynamo

Few photos taken when I got the opportunity to go out around the area of Grajska tirna vzpenjača – Castle Funicular:


Allan Cantos EngTech MICE

BSc Civil Engineering / Principal Structural Technician

Structural Data Mining Using Revit-Dynamo-Power BI Workflow BILT Europe 2018 Class – SOLD OUT!

Hello BILT Europe 2018 delegates (also applies to those who are visiting my website), I hope you are now ready for a 3-days of fun, networking and learning at BILT Europe 2018 which will begin tomorrow and to be held at GR – Ljubljana Exhibition and Convention Centre. Too many topics to choose from and I bet, you’ll experience having a hard time to choose which one to take if in the same time slot, you have 2 or 3 topics that you find interesting.

If you happened to be one of those who would like to attend my class on Friday, 12th of October, but unable to do so, because you missed to register early, please don’t despair. You’ll still have the chance to get a copy of the class manual in more detailed than what’s provided on the conference by visiting HERE.

This website will keep on running for as long as there is someone like you who would be willing to spend small amount to support me in funding my website. Your support is very much appreciated. Thank you in advance.

Enjoy your BILT Europe visit.


Allan Cantos EngTech MICE

BSc. Civil Engineer / Principal Structural Technician


What is e57 file format and how to bring it into Revit?

An engineer came to me and asked me to investigate the file he received which was under e57 file format. Honestly, at first, I don’t know what software this kind of file format came from and how I will open it to do my investigation. Thanks to the internet, I went to Google and did a little bit of research about e57 file type.

According to http://www.libe57.org/, the e57 file format is a compact, vendor-neutral format for storing point clouds, images, and metadata produced by 3D imaging systems, such as laser scanners. So, from here, I can conclude that the e57 file is something to do with point clouds. The file happens to be a survey information of existing structures.

Now, the next question is, how I can bring this e57 file format to Revit? Will it land at the same coordinate system I have on my Revit model? What positioning I will use? For now, I don’t know the answer as this will be my first time to encounter e57 file format.

Link the “Point Cloud” under “Insert” tab and “Link” menu ribbon options. I found out that you can link the e57 file format. See image below for file type options supported.

Now, I’ll try to import the e57 file format using “Auto – Origin to Origin” positioning and see what will happen.

I’ve got that warning message and from that, it leaves me no choice than to click “Yes” for it to work. So, I clicked “Yes” and this window popped-up:

Continue the process by clicking “Start Indexing” button then you can grab a coffee as this will take a while depending on the size of your e57 file. In my case, the file size is around 30GB, so enormous!

While the file indexing is progressing, you can do other stuff to keep you busy.

Now the process is completed. Unfortunately, I lost tract of the time it took to process the almost 30GB e57 file. However, I reckoned, it took 2.5 hours using my Lenovo ThinkPad P70 laptop. Additional specifications are shown below.

As advised previously, we can link the new file once completed, which is now in the format of .rcp. An .rcp format file is a project file that groups together multiple .rcs scan files. The result of indexing a raw format file is an .rcp file and one or more .rcs files.

For now, I’ll use “Auto – Origin to Origin” as positioning.

Click “Open” and it gave me a warning.

I hit “No” and try again but, this time using “Auto – Center to Center” positioning, then click “Open”.

I have the same warning as the one above. This time instead of clicking “No”, I hit the “Yes” button and the result…..the point cloud is rotated.

I tried again but, this time using the last positioning option, which is “Auto – By Shared Coordinates”, then click “Open”.

Again, same warning message, hit “Yes” and voila! it landed on the area around the building to be constructed.

Any comments, corrections or suggestions for improvement are very much welcome.

Have a great day.


Allan Cantos EngTech MICE

BSc Civil Engineering / Principal Structural Technician

allscan12.com – Under Maintenance

Hello everyone, apologies if my website were down in the past 2 days. The website was under maintenance.

It also came to my attention that my blog readers, who would like to subscribe or leave some comments, were having some issues of not seeing what they were typing. It could be something to do with the website theme I used, and for that reason, I decided to change the way the website will appear on your screen.

I’ll be back soon with the new look. Thank you for your patience.

Have a nice day.


Allan Cantos EngTech MICE

BSc. Civil Engineering / Principal Structural Technician

How to remove recent files on your Revit start-up page

Hello everyone. I trust you are well and allow me to say thank you for visiting my website blog section in advance..

Today I’m gonna look at resetting my Revit startup page to default settings; by removing all recent files list.

I am sure most of you are aware of this, so I wrote this topic as my personal note on how to do this and for me to avoid searching at Google should I forget how to do this.

This method must be done specially if you will be running a presentation outside the company and you don’t want to show the projects you are working on.

Here is what you’ll see when you have recent files shown (I intentionally overwritten the images and file names):

Now, here are the steps that we need to do:

First, locate the Revit.ini file which you can find here: C:Users\(Your Local User Name>AppData>Roaming>Autodesk>Revit>Autodesk Revit (choose whichever version you are using)>Revit.ini.

Open the Revit.ini file by double clicking or right click the Revit.ini file to open the file in text editor or Notepad.

Then scroll down until you find the word: [Recent File List]

Underneath that text you will find a list of all the recent files that have recently been opened by Revit. Delete the text for those recent files. Make sure to leave the [Recent File List] line in the text file. See image below for sample.

Save the file and open up Revit. You’ll see the welcome page sets to default one, as if you’ve just newly installed the software.

WARNING: Make sure that the only text you delete in the Revit.ini file are those lines specifically mentioned above, otherwise, deleting other text from the Revit.ini file can cause mayhem on the Revit UI which potentially requires you to reinstall the software.

Have a blessed day.


Allan Cantos, EngTech MICE

BSc. Civil Engineering / Principal Structural Technician

BILT EUR 2018 Laboratory Session 2.2: Structural Data Mining Using Revit-Dynamo-Power BI Workflow

In less than a month will begin the BILT EUR 2018 which will be held at GR – Ljubljana Exhibition and Convention Centre, Ljubljana, Slovenia from October 11-13.

In my previous BILT appearances this year, BILT Asia 2018 and BILT ANZ 2018, my presentation focused on live demonstration; explaining how the workflow works from start to finish. Fortunately, I did not experience any technical issues and the live demonstration went very well.

This time, on my last appearance this year at BILT community as speaker, I made a change in the way I’ll deliver my topic. Why not come to my laboratory session? I want you all to experience, right there and then, how this workflow works. It’s pretty simple and it is open to any level. If you happen to be an expert and would like to comment or provide additional information in improving the workflow, I am more than happy and will appreciate it much if you could come to me after the laboratory session to have a little knowledge sharing session. We will all learn from each other. Please don’t come to me on the third day as I’ll not be around. I have to fly back to London on Saturday morning and so unfortunate to miss the after event big party, but that’s fine.

For more details on how to purchase a ticket, please visit BILT EUR 2018 website.

By the way, you can avail of 10%  discount off the 3 Day Delegate rate (excluding accommodation) by clicking https://www.eiseverywhere.com/ereg/newreg.php?eventid=294058&discountcode=ALLSCAN12

Code to use will be ALLSCAN12

So, here is my session:

And here’s the agenda for the session:

First, I’ll demonstrate the process of preparing the data you need using Revit schedules. I bet this part is the easiest one for all of you. Nothing is so much exciting about this.

Next, since Power BI works smoothly with Microsoft Excel, We’ll use Excel to store our data mined information from Revit.

After that, we’ll create a simple Dynamo graph to automate the process of sending the information from Revit to spreadsheet. Thus, eradicating potential human error caused by copy and pasting or manual typing.

And finally, we’ll bring the data to life using Power BI. You’ll all learn a basic understanding on how to build your Power BI project.

I hope to see you all in my session.

Once again, here are the details:

Date: Friday, October 12, 2018

Laboratory Session: 2.2

Presentation Topic: Structural Data Mining Using Revit-Dynamo-Power BI Workflow

Presentation Time: 11:00am – 12:15pm

Duration: 75 Minute laboratory session (including question time)

Categories/ Level: Structure, Data Management, Autodesk Revit | All Levels

I am very excited now to deliver the presentation with you and if in case you’ve found the presentation to be helpful, why not share my blog across social networks?

If you weren’t able to attend the BILT Conference, you can get a copy of the tutorial that I spent time writing by visiting the link below:

Revit-Dynamo-Power BI Workflow ebook

For the complete BILT EUR 2018 program, please visit: http://www.rtcevents.com/bilt/eur18/schedule/


Allan Cantos, EngTech MICE

BSc. Civil Engineering / Principal Structural Technician

Learn Python Programming (2018) on Udemy – Completed

Hello everyone. As a continuation to my previous post HERE, I would like to announce that I have completed my course.

Allow me to list down with you what I have learned in this free Python Programming course on Udemy just in case you are interested in knowing some of them; or all of them.

  1. What is the correct way to add a comment in Python?
  2. What is the correct way to set variable, say, ‘s’ equal to the string, say, “Hello World!”?
  3. What type of variable is a True or False?
  4. What type of variable is, say, 100.45?
  5. Arithmetic and Concatenation
  6. Data Structures
  7. Control Flow
  8. String and List Methods
  9. Typecasting and Escape Sequences
  10. Getting User Input
  11. Functions
  12. Importing Modules
  13. And finally, how to make a GitHub Repository

In order for me to remember all of this, I need to keep reviewing my notes from time to time or find a way to apply this in my current field of work.

For those who wants to learn Python Programming, I highly recommend this course for you. The course itself is just an hour long but since I made some notes and did some readings, it took me 4 hours to complete the course (2 hours for each separate dates).

Once again, here is the link for the course: Learn Python Programming Course

Have a great day.


Allan Cantos EngTech MICE

BSc Civil Engineering / Principal Structural Technician

Revit-Dynamo-Power BI Guide eBook on sale!

Click the image below to get your copy.

Any issues, errors or corrections, please give me a shout and I’ll sort it out quickly.

Happy reading and doing the exercises .

I trust you’ll find the tutorial helpful.

Best regards,

Allan Cantos EngTech MICE

BSc Civil Engineering / Principal Structural Technician



Learn Python Programming (2018) on Udemy

Hello everyone! How are you all doing? I trust you are well.

For some of you who are interested in learning the basics of Python programming, I came across this course in Udemy  and I would love to share this to you. Python is still the fastest growing major programming language and if you want to learn some basics, please click on the link provided below to get yourself started.

Learn Python Programming Course

Have a great weekend and enjoy learning.


Allan Cantos EngTech MICE

BSc Civil Engineering / Principal Structural Technician