Read data from csv txt

4 votes
Version: 
0.1
Date Updated: 
02/06/2015
Author Name: 
Pixamoon

Just simple script / code to read data from csv files exported from Excel and then create objects - (here: spheres)

How CSV should look:
Every planet in single line. Every value separated with "|" character.

for eg: (name|radius|x|y|z|sphere segments)

Sun|20|0|0|0|12
Earth|2|100|100|0|12

And so on.

If you need apply specific colors then add extra 3 numbers controlling rgb (egz |0|10|200)

Before run change file location in code or copy "SolarSystem.txt" file to C:\

Cheers,

AttachmentSize
read_data_from_csv-01.ms360 bytes
solarsystem.txt39 bytes

Comments

Comment viewing options

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

oki

oki, try this one

csv file structure:
name|x|y|rotation

x,y are in system unit scale (inches or centimeters)
rotation is just in degrees

You need to open it and change path to csvfile or just place csv/txt file on C drive with the same name as sample

Then select ground and run script.

Hope it helps :)

AttachmentSize
read_data_from_csv_and_instance_03.ms 1016 bytes
pylons.txt 35 bytes
pixamoon's picture

`

ok, cool, I'll change this one to instance pylons

robmyers67's picture

csv load

The reading from base landscape on the z would be great and as far as naming that is fine too.

Sweet

pixamoon's picture

csv

yes, they can be in groups
There is of course the way to connect wires between insulators with the script too. But this is other topic :)

Ok, I'll upload soon script to instance objects with positions from csv file.

So x,y,z plus Z axis rotation is enough, right ? Or you want to read z (height) from landscape ?
And how about new object naming - just base name + unique number ?

robmyers67's picture

Load csv

That sounds awesome. can it handle the pylon as a group just thinking about the insulators which are attached. Once the pylons are in place we then align the insulators to the following pylon then use splines to represent the cables. but just getting them into position is a great step forward

pixamoon's picture

csv

ah, oki,
I think the easiest way will be to have them in the project already. And just use script co copy/instance them with position and rotation from csv file.
File will have base names each pylon to be copied, then position and rotation.
file eg:
Pylon_A|100|10|0|90
Pylon_A|200|10|0|90
Pylon_B|100|100|0|90
etc
Pytlon_A|x|y|z|rotation

It is possible to place it also on surface (z position - if you have some landscaping already)
What you think?

robmyers67's picture

import .csv

Its basically pylons of various shapes and sizes which need to be loaded along a co-ordinate system. There are various pylon type which need to be loaded. Not precious as to how they are loaded whether from an external MAX file or whether we all the pylon types in the same model. The pylons have the frame as a mesh and the insulators are linked to the main mesh. We can group them if needs be. We basically need to drop the required pylon in a location with the correct rotation.
Hope this makes sense.

Cheers

Rob

AttachmentSize
pylons.jpg 42.43 KB
pixamoon's picture

`

oki oki,
yes sure, but what kind of meshes? Can you post some screenshot ?
Do you want to impost them form other file and place them to location from csv file ?
Or do you want to import meshes from csv too ?

robmyers67's picture

load data from ,csv

Hi I noticed this post and was wondering would it be possible to load meshes using this script and Have them placed in the scene. This will save time manually placing my objects. Cheers Rob

Comment viewing options

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