Search PalmPower's 487 Palm-related article archive 
Home
EasyPrint
News details Click here for the RSS feed's XML code. This is not a browser URL.
Articles-only Click here for the RSS feed's XML code. This is not a browser URL.
Importing JFile databases (continued)

  • Field names can be no longer than 20 characters.

  • You can only have 20 fields per database.

  • You are limited 500 characters per field of data.

To make our DEMO.TXT file a CSV, I had to enlist the help of my favorite spreadsheet. I opened DEMO.TXT in Microsoft Excel 97, which recognizes the data as text and automatically launches the Text Import Wizard. The data in each column is of a fixed width using spaces in between, so Excel can easily determine that the data in each column represents a cell of data. Once I was able to import the data into a Excel worksheet, I put in a field name for each column of data in the first row, making sure that I didn't exceed 20 characters of data per field name. I saved the file as DEMO.CSV, ran JCONVERT, installed the compiled .pdb file on my PalmPilot, and Sha-zam! My database of 1998 Major League Baseball pitcher statistics was ready for use.

Of course, you might not be so lucky to find text on the Web in perfect columns, so you might need to massage the data in a text editor or move it around in your favorite spreadsheet program first. But now at least you understand how simple the process is, right?

Ah, the light at the end of the tunnel is always so refreshing.

Product availability and resources
JFile is available at http://www.land-j.com.

Baseball stats are available from the CBS Sportsline web site at http://ww1.sportsline.com/u/archive/baseball/mlb/1998/May-28/ystatalpit.htm.

Jason Perlow is a computer consultant and freelance writer living in the NYC metro area. He can be reached via email at the incredibly cool address of jason@argonautsystems.com.


« Previous  ·  1  ·  2
Other articles you might like
Home > Solutions (189 articles)
   Miniature data warehousing is now possible
   A cheap way to schedule repeating tasks
   The Franklin Electronic ROLODEX, an inexpensive and very functional PDA substitute
Home > Phones and PDAs > Palm and Treo > Software (211 articles)
   TealOS: great Palm software you are prohibited from buying
   CallRec gives your Treo better call recording
   Edit Office files on the go with Documents To Go
Get Weekly Email Updates
Subscribe to our regular weekly email newsletter. It's packed with tips, reviews, deep analysis, and the latest news.
 
Other PalmPower Articles
Palm gets up to date with new Tungsten family of handhelds
Create handwritten email with riteMail
Presenter-to-Go puts PowerPoint presentations on your Palm OS handheld
Looking for the cutting edge
Gain remote access to databases and PLCs
PalmSource Open House showcases what's new in the Palm community
Analysis: handheld market share
More from the ZATZ journals
Computing Unplugged: The iPad defenders have spoken
David Gewirtz Online: CNN commentary and analysis
DominoPower: Application development, William Shatner, and the origin of the universe
OutlookPower: More about disappearing text
-- Advertisement --

BLOGGING AND PODCASTING WITH ONE EASY-TO-USE TOOL
Now you can publish your thoughts, opinions, and comments in your own blog or podcast.<p />

  • Supports multiple authors and multiple blogs or podcasts.
  • Generate and publish RSS feeds for iTunes and other directories.
  • Post photos, images or animations.
  • Get feedback and have conversations with visitors to your site. <p />

Personalize your blog or podcast with your own unique domain name -- or integrate it with your existing site by setting it up as a subdomain.

Tap here and get blogging or podcasting within minutes.

-- Advertisement --

Sent Items Organizer
When you need to file your sent email into their proper folders based on keywords or who it's to. It's also perfect for shared mailboxes.

It also adds a "Send And File" toolbar button while you're composing (similar to the way Lotus Notes used to work) for quick and easy filing.

Find out more!

ZATZ Home  ·  News  ·  Back Issues  ·  Credits/Trademarks ·  Link To Us
Copyright © 1998-2010, ZATZ Publishing. All rights reserved worldwide.
Editor's Login