It you have the data and the data have x,y,z coordinates then you just need to loop through them and position them in the scene. You can probably search he asset store for a SQL data access script.
Could you suggest any scripts from asset store for accessing SQL or CSV data. Once that data is accessible, it’s values depending on text should work to decide the shape and position.
I see some graphing tools and SQL/CSV tools, but I’m unable to figure out a graph creation of 3d point plotting script, that can read a csv and automatically show a point on screen.
Example:
Food habits of a family are being studied. Depending on which family members ate which fruits, we can deduce how much energy they have at their disposal. So family member is the object on screen.
X-axis Oranges = 1, Apples = 2
Y-axis Oranges alone = 0, Oranges + apples = 2
Z-axis Status spoilt = 0, Fresh = 1
More identification can be added to the point - Shape to show whether its man, woman, infant. Color = age
Also we need to draw lines and show all members that like the same fruit as connected. When the line is clicked, we get data about the common factors of both the points.
Now this is sort of how far i can think right now!
Hopefully you can interpret them into something useful:
so what next?
Have a class of Family member which contains a vector position, a shape (link to mesh) and a render color
Figure out how to load the SQL table into a like List
loop through this list and create new game objects for each : GameObject TempName = newGameObject(); and apply the data such as the position, gender and age
After this is done they should display in the unity scene at runtime
