CSV vs. XLS
Posted: Thu May 01, 2014 10:12 am
Hi,
I am using the Noventri Suite 2.12.21.2541r_2.12 with the Eco 200 and it is displaying images and videos and importing powerpoint, etc.
This morning I am attempting to grab some information from our inhouse calendar via Python and saving the data to the Noventri server as a CSV.
I have:
TIME, TIME, TIME
ROOM, ROOM, ROOM
DESC., DESC., DESC.
If I check database and Data Text and then select the .csv and then in the text area do this:
[1:1]\t[2:1]\t[3:1]\n\n[1:2]\t[2:2]\t[3:2]\n\n[1:3]\t[2:3]\t[3:3]
Everything displays. (Although, I can't figure out how to align the columns or how it would refresh after updating each day.)
When I try and use the ODBC driver so that it will re-read the DB - things don't work so well. I can select the Microsoft Text driver and the proper table, but when I try and select the table, nothing displays.
What have I missed?
Regards,
Lou
I am using the Noventri Suite 2.12.21.2541r_2.12 with the Eco 200 and it is displaying images and videos and importing powerpoint, etc.
This morning I am attempting to grab some information from our inhouse calendar via Python and saving the data to the Noventri server as a CSV.
I have:
TIME, TIME, TIME
ROOM, ROOM, ROOM
DESC., DESC., DESC.
If I check database and Data Text and then select the .csv and then in the text area do this:
[1:1]\t[2:1]\t[3:1]\n\n[1:2]\t[2:2]\t[3:2]\n\n[1:3]\t[2:3]\t[3:3]
Everything displays. (Although, I can't figure out how to align the columns or how it would refresh after updating each day.)
When I try and use the ODBC driver so that it will re-read the DB - things don't work so well. I can select the Microsoft Text driver and the proper table, but when I try and select the table, nothing displays.
What have I missed?
Regards,
Lou