Skip to main content
Question

How to CONVERT EXCEL data to ???? (preferably IFC 2x3)

  • October 25, 2023
  • 6 replies
  • 138 views

vimva679
Supporter
Forum|alt.badge.img+9

image to

 

image 

What is most important is i would like to add permanent different symbol for each 'GType' whenever i load it into Trimble Connect + AR Viewer

6 replies

redgeographics
Celebrity
Forum|alt.badge.img+62

You can specify on the Excel Reader (in the properties when you're creating the reader) that certain columns should be treated as x, y and z coordinates. You'll also need to specify the coordinate system.


vimva679
Supporter
Forum|alt.badge.img+9
  • Author
  • Supporter
  • October 25, 2023

How to add symbols to each elements eg. PLAT look like Square , PENE look like Circle , DOOR look like rectangle etc. ?


david_r
Celebrity
  • October 25, 2023

vimva679
Supporter
Forum|alt.badge.img+9
  • Author
  • Supporter
  • October 25, 2023

@david_r​ and @Hans van der Maarel​ and @daveatsafe​ Not getting it quite right, i have used the article and recreated the workbench but it does not export IFC at the end only attributes are exported. For reference i have attached WORK and Data template (i have distorted XYZ and would not match or create any object, but if u wish to try you could INPUT XYZ values) . I am also missing step to give shapes to Gtype objects like square, rectangle, triangle, think line etc. for each Gtype. thank you with your previous input as well.


vimva679
Supporter
Forum|alt.badge.img+9
  • Author
  • Supporter
  • October 30, 2023

imageWhen running till AttributeCreator, i could see all the points, when writing to IFC it looses all and nothing is get write out :( . Any idea . Highly obliged with help .

image 

 


vimva679
Supporter
Forum|alt.badge.img+9
  • Author
  • Supporter
  • October 30, 2023

attached is the most updated Workbench