importing csv into palm zire
October 28, 2006 9:08 AM Subscribe
How can I view and search csv files exported from excel on my mac, using free tools?
Response by poster: aaarrrggh, I was unclear. Yes, on my palm.
I was actually able to import 415 records as memos, but that only supports two fields really, title and body, so it's a clunky solution at best.
posted by mecran01 at 9:33 AM on October 28, 2006
I was actually able to import 415 records as memos, but that only supports two fields really, title and body, so it's a clunky solution at best.
posted by mecran01 at 9:33 AM on October 28, 2006
Any text viewer for Palm will handle CSV files, and I'm sure most of them have search capabilities.
posted by mphuie at 11:46 AM on October 28, 2006
posted by mphuie at 11:46 AM on October 28, 2006
Text viewer, or Handago Excel.
posted by orthogonality at 2:46 PM on October 28, 2006
posted by orthogonality at 2:46 PM on October 28, 2006
Response by poster: Thanks all--
Handango costs money, and a text viewer doesn't provide some of the flexibility of a database like listdb, which has windows tools for csv import, so I suppose I'll have to borrow a windows machine to do it properly.
posted by mecran01 at 6:17 AM on October 29, 2006
Handango costs money, and a text viewer doesn't provide some of the flexibility of a database like listdb, which has windows tools for csv import, so I suppose I'll have to borrow a windows machine to do it properly.
posted by mecran01 at 6:17 AM on October 29, 2006
Response by poster: ok, got it. It looks like pilot-db and jpilot-db (desktop client) will do what I want, and are both free. Yeah!
posted by mecran01 at 1:57 PM on November 2, 2006
posted by mecran01 at 1:57 PM on November 2, 2006
Response by poster: update: jpilot-db doesn't work with any version of pilot-db after 1.0.3, and the oldest version online is 1.0.4, which causes fatal system errors. I also tried using a perl script to import csv into listdb but it wants the csv data in a format that I can't successfully reverse engineer.
posted by mecran01 at 12:13 PM on November 3, 2006
posted by mecran01 at 12:13 PM on November 3, 2006
Response by poster: I did it!
Using the free database program ListDB, and the perl scripts here:
http://home.pacbell.net/dunhamd/
I created a CSV file using this format:
2playaz,Field1,Field2,Unsorted,2buy,own
Unsorted,Battle,6.7,3.5
Unsorted,Puerto Rico,8.46,3.35
Unsorted,Tigris & Euphrates,8.22,3.6
Unsorted,Caylus,8.2,3.76
Unsorted,Power Grid,8.15,3.41
Unsorted,El Grande,8.06,3.22
And imported it using the aforementioned perl script. About 50 percent of the time the perl script would generate a file with a size of 0, but I kept running it until the output showed up.
Now to fill my palm with tasty fields and records!
posted by mecran01 at 2:49 PM on November 3, 2006
Using the free database program ListDB, and the perl scripts here:
http://home.pacbell.net/dunhamd/
I created a CSV file using this format:
2playaz,Field1,Field2,Unsorted,2buy,own
Unsorted,Battle,6.7,3.5
Unsorted,Puerto Rico,8.46,3.35
Unsorted,Tigris & Euphrates,8.22,3.6
Unsorted,Caylus,8.2,3.76
Unsorted,Power Grid,8.15,3.41
Unsorted,El Grande,8.06,3.22
And imported it using the aforementioned perl script. About 50 percent of the time the perl script would generate a file with a size of 0, but I kept running it until the output showed up.
Now to fill my palm with tasty fields and records!
posted by mecran01 at 2:49 PM on November 3, 2006
This thread is closed to new comments.
posted by bricoleur at 9:22 AM on October 28, 2006