|
ronpoz -> "Pseudo" CellarTracker IPhone/IPod Touch App! (8/16/2008 9:57:12 AM)
|
Hey guys,
I love to access my cellar tracker data when at the wine shop. The only problem, is that the data connection on my Windows Mobile phone is slow and there is no Wi-Fi for my IPod Touch to connect to.
So, I have been downloading my various lists via Excel, printing them and then taking them along. I don't like paper and wanted to get my database on my IPod Touch somehow.
I happened to be scrolling through the Apple Apps store and came across this cool little $1.99 application called "CSV Touch". CSV, hmmmm. I know I can export data to CSV, maybe this app can pull it in and cache it? YES IT CAN. [:D]
So, I purchased the app, went to http://www.cellartracker.com/ow.asp?ExcelDownload to find out how to export to CSV, then realized I can create them on the fly with the following: http://www.cellartracker.com/xlquery.asp?table=List&User=<your_login>&Password=<your_password>!!! Be sure to add on &Format=csv for the proper CSV Export.
So I pointed this app to these custom URLs and BAM, it cached my entire wishlist, tasting notes and other lists. You can select the columns to display so it doesnt get too clogged, when you click on an item, you can see all the data.
Obviously, if you have an IPhone (with v. 2.0 firmware), it will work even better as you can update on the fly without need for a wi-fi hotspot.
Anyway, if you have 2 bucks to burn, download it from the Apple App Store (Search for CSV Touch) and give it a go.
I hope this helps some of you out there who cannot get access to cellartracker while shopping, it will certainly help me!!!
More info about CSV Touch can be found here: http://www.ozymandias.se/Ozymandias/Home.html
Since it is a CSV database, you can use it for anything!
Warm regards,
Ron
|
|
|
|
