Creating cone primative and exact location using data from Excel

Hi,

I am looking for a way to automate the process by which we create 3D Studio Max camera alignment points. Bascially we do verified photomontages using 3D Studio Max cameras which are aligned over high-resolution photography. To verify the locations we employ a surveyor to visit the actual site they survey the area and send us back and excel spreadsheet of data.

For one camera location they might be 25+ points which need to be created. Sometimes we produce 40+ verified views for a project, each will need all of the these points to be created in 3D space.

The data currently arrives in this format (as excel)

VERIFIED VIEW: A

EASTINGS NORTHINGS HEIGHT
Camera Position 529125.999 180995.364 23.540
1 529128.130 180990.600 24.720
2 529132.326 180983.142 26.239
3 529147.104 180961.269 32.615
4 529135.357 180986.790 28.772
5 529138.875 180980.983 28.794
6 529145.835 180969.416 28.802
7 529151.950 180958.044 27.108
8 529172.205 180923.357 28.264
9 529132.962 180984.779 32.065
10 529151.934 180934.350 27.640
11 529156.774 180908.705 27.863
12 529135.739 180961.745 23.948
13 529125.685 180980.813 23.666
14 529122.439 180983.706 23.732
15 529125.043 180953.418 40.348
16 529138.544 180930.955 40.319
17 529152.181 180909.210 42.778
18 529177.756 180863.832 43.515
19 529203.204 180821.890 43.915
20 529129.358 180946.209 28.487
21 529139.007 180930.152 28.392
22 529125.145 180951.908 46.404
23 529140.391 180927.034 47.944
24 529122.603 180983.733 29.802
25 529129.747 180989.365 23.590

I am looking for a script to automatically build a max file with all of these points represented by inverted cones (pivot to be set at the exact co-ordinate. Ideally I would like the 'camera location' data to be represented by a very simple blob human mesh.

Does anyone have information on how do this? Or actually know of anybody who could right such a script for me (paid of course)?

Many thanks

Toby Ritchie

Comments

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
Marco Brunetta's picture

Shouldn't be too hard. Could

Shouldn't be too hard. Could you attach the excel file so I can use it to test the app? Also, what kind of units are those? millimeters?

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.