Import/Export MySQL and 3D Viewer

[artoritorian]

Hello! I’m newby in Sketchup Development.

I need to solve two problems:

1. Editing Custom Component Attributes through the fields on the site via MySQL.
2. 3D WEB Viewer with features:

• Standart Sketchup Viewer features
• Layers control
• SelectionTool
• Custom Component Attributes Editor
• Search Components by custom attributes (lighting)
• EntityInfo
• TapeMeasureTool
• DimensionTool
• Clip plane
• Markup tool

If it’s unpossible to make Viewer in Web version it may be standalone Windows app.

I uploaded scheme how it should work.

Tell me please which direction I need to look for.
Maybe somebody knows guru programmers on Skatchup Ruby from Russia who could help me.

Thank you!

UPD for example (20MB) - http://www.arcgis.com/apps/CEWebViewer/viewer.html?3dWebScene=86f88285788a4c53bd3d5dde6b315dfe

[Aerilius]

What is the goal of this plugin? (It rather sounds like a clone SketchUp. Do you have an idea what effort that requires?)
How is it related to MySQL?
How is it related to the CityEngine link?

Before planning an extension or even a software, you need to know the goal and what technical prerequisites you need to realize it.

• You are aware that .skp is a proprietary undocumented file format. You cannot trivially open it in a self-made viewer.
  • There exists a binary SDK for reading .skp files into an external software (no SketchUp needed). This SDK is only available for MacOS and Windows.
  • You can also make a SketchUp extension to export the .skp model (from running SketchUp) into your own file format, which your web viewer can read.
• You can make an extension that reads in SketchUp all component attributes and sends them to a server e.g. as JSON.
• There exist already several universal attribute editors. Basically you could take one and restrict it to show only your own attributes.
• There exists also an extension to export model and attributes to CityGML which CityEngine can import.

[artoritorian]

Thank you for your answer.

What is the goal of this plugin? (It rather sounds like a clone SketchUp. Do you have an idea what effort that requires?)

Main goal is connect Sketchup file with MySQL and web 3D viewer

How is it related to MySQL?

I need to storage Component Atributes in MySQL to show and edit them in the web on site. And then I can see it in the Sketchup file. If it’s possible of course.

How is it related to the CityEngine link?

Nope, I link CityEngine viewer as an example of Web Viewer with layers control. Just this.

• You are aware that .skp is a proprietary undocumented file format. You cannot trivially open it in a self-made viewer.
• There exists a binary SDK for reading .skp files into an external software (no SketchUp needed). This SDK is only available for MacOS and Windows.
• You can also make a SketchUp extension to export the .skp model (from running SketchUp) into your own file format, which your web viewer can read.
• You can make an extension that reads in SketchUp all component attributes and sends them to a server e.g. as JSON.
• There exist already several universal attribute editors. Basically you could take one and restrict it to show only your own attributes.

Thank you. This information helps me.