[jp] CSV export

  • Previous message: [jp] How would I print address lables?
  • Next message: [jp] CSV export
  • Vassilii Khachaturov vassilii at tarunz.org
    Thu Jan 11 18:00:18 EST 2007

     

    > Ralph Alvy wrote:
    > > I'm interested in exporting all my Contacts from JPilot to CSV format. I
    > > notice that this is possible as one of the File menu choices. However, the
    > > export appears to simply order data according to raw field order. What I'm
    
    Look at the very 1st line of the CSV output, it gives you a clue as to
    what fields you actually have in there.
    
    On one hand, you have Phone1 ... Phone5 columns in the CSV, which are the
    raw contents of the corresponding contact fields. OTOH, there are the
    corresponding phoneLabel[1-5] fields, which, in turn, are NUMERICAL
    indices into the array of possibilities of what the corresponding phone
    might be. See the documentation for the excellent perl module
    Palm::Address which lists the names in the correct order.
    
    What are you going to do with the CSV? If you are going to parse it
    yourself, why not use Palm::Address and directly access the PDB (this way
    you get access to additional data, such as the custom field names!) If you
    are going to import it into something else, like kontact, try exporting
    into another format (jpilot supports also export into vcard and ldif).
    
    HTH,
    Vassilii
    
    
    

     

     

    More information about the jpilot mailing list