Visualize Database/Excell in ICE

[sant0s]

Hi,

for a job I try to find a solution, to visualize a lot of datasets thats in a database.
Means, I have a name, a location, size, etc.

As an example, User_A is delivering 500 parcels different size and different cities in 1 year.
The timeline is 100% = 365 days. On the days, User_A is delivering the parcels, an object pops up by the size of the parcel on that location.

Point is, that I can do it manually if there are some data - but this would be thousands of datasets

Anybody had something like that before? Is that possible with ICE?
Thx alot!

Markus

[Hirazi Blue]

You'd have to script it. You can export your data as csv and utilize the csv module Python has on offer to read your data into Softimage. This thread on the mailing list broaches the subject and also points to an example by Stephan Blair as to writing (not reading) point positions to a csv file...

Again with the belated edit :
as is mentioned in the mailing list thread above there are also several wrappers to read Excel files more or less directly. Look here.
But this would involve setting up/installing these wrappers first, which might be a pain...

[sant0s]

hey hb,
thx!

will check that, but the first look told me, its heavy stuff...!

that here never got it to the end, right? ^^
https://www.si-community.com/forum/v ... =13&t=2983

and a way, where I fill in attributes with:
DATE_____NAME_____LOCATION______TRUE/FALSE
and read that in ICE? actually like the link above but without reading a file.

Than I would have to write a lot of attributes, but learning python now takes more time.

[sattish]

how about converting the data into icecache format externally ?
maybe this thread will help ..
https://groups.google.com/forum/#!msg/x ... bQ9i08WPMJ

i tried compiling the pdb2ice tool by ben rogall in the past but its missing some custom header files

[csaez]

how about converting the data into icecache format externally ?
maybe this thread will help ..
https://groups.google.com/forum/#!msg/x ... bQ9i08WPMJ

i tried compiling the pdb2ice tool by ben rogall in the past but its missing some custom header files

A python alternative to easily create icecache files
http://www.cesarsaez.me/2013/11/scan-files.html

[sant0s]

hey,
thx for your answers guys!
HB helped me out and I have a little script that does the job.
thx "an dieser stelle" ;)