Import Fields Explained

Help
2004-11-04
2012-09-17
  • Angelo McComis

    Angelo McComis - 2004-11-04

    Import uses Tab Separated Values.

    The field order is:

    Group
    Username
    Password
    Notes

    Note that Groups can be subgrouped for the purposs of tree view. The unfortunate part is that it uses "." to delineate groups.

    E.g. "Top Level" is a top level group.
    "Top Level.Subgroup" is Subgroup under the Top Level top group.

     
    • jsalb3

      jsalb3 - 2004-11-10

      Ahhhh so that's why it keeps breaking up my url's into several entries!

      For my imports, it broke out all url's into multiple record entries. Unfortunately, the url is my Group name.

      Hmm, change all . to , then import and change all , to .??? ouch.

      Thanks for the tips.

       
    • jsalb3

      jsalb3 - 2004-11-10

      When I import, there is a new field called Title which puts data from my txt file into it. Is it
      Group
      Title
      Username
      Password
      Notes?

      At times it loads "Imported" into the Group.
      Curiouser and curiouser.

       
    • jsalb3

      jsalb3 - 2004-11-17

      I have tried that. I'm doing something wrong. Password Safe will not import the Notes column and stops importing after about 10 entries.

      My file is .txt DOS tab delimited; all . have been replaced by , this is what it looks like:
      Insurance Co joeblow xxxyyy123 1/8/2004
      then a tab following the date (Note) and the next record.

      I have over 200 logon id's and passwords and I really don't have the time to enter each one but I don't want them in an excel spreadsheet anymore either!

      Help, Jim

       
    • jsalb3

      jsalb3 - 2004-11-17

      I'm sorry, I can't figure out how to attach to that url. I see downloads but no attachments / uploads. Here is the text of my file, I hope the tabs make it through.
      In all cases, the date is the Note field.

      acm,org qizp8 Cpient: 0472647 P8OFEIIIONZP O84e8: 5554154 x9pti 5/5/2004 Insurance Qizp8 Zrfitzte 1/8/2004 amazon living,com qizp8@itzte,4e,9i qizp85@hotxzip,cox Zxzzon5 1/8/2004 zny4zy,cox qizp8 zny4zy5 1/8/2004 appple,com qizp85@ x9pt 5/26/2004 asynchrony www, asynchrony,com qizp8 4ep500 1/8/2004 basstab.com qix8zii8o8 zctive8zii5 1/8/2004 8pog itic4e qizp85@h x9pti bookxz8k Exp8eii http://www,bookxz8kcent8zp,com/ Qi5 bz84or 1/8/2004 8ookionpine,cox Qzizp8 4epp 1/8/2004 88ightxzip Q9z8zntine https://q9z8zntine,itzte,4e,9i/88ightxzip/pogin,4o?xetho4=pogin9ie8 qix,izp8 v584on4@ 5/16/2004 89iineii czie i9xxz8y http://nzpopi,itzte,4e,9i/tic/ qizp8 qixz4x Kz844 11/16/2004 Chief Officer Qizp85 Chief5 1/8/2004 CIN (CIO) Qizp8 4epp 1/8/2004 Citi Qizp8x 4xxx5xxx 1/8/2004 Cpziixztei,cox/9ie8 qizp8@itzte,4e,9i x9ptiiync 1/8/2004 COXPZQ PIN9X 8oot @Pin9X8oot1 1/8/2004 Coxp9te8 Wo8p4 qzizp8 C0xp9te8Qix 1/8/2004 Cont8zcti 4ztz 8zie qizp8 pziiwo84 1/8/2004 Co98ie,com qizp8@itzte,4e,9i C098ieQ1x Itzte TP-00212E-INXC Cpzii I4:45845 1/8/2004 CRM Community http://www,community,com/ Qizp85 4epp500 1/7/2005 4CI 828 Cox49sity Qizp8 4epp500 1/7/2005 ACI Technology Conferences 40528020 QXIXX00 1/7/2005 4epzwz8e Po8tzp Qizp8 X9pet8zin 1/7/2005 4ep4ot,net exzip http://www,4ep4ot,net/xy4ep4ot,eqi qizp8 Iweeney 4EPP 500 Optippex Z4xiniit8zto8 Tony@Coppini 1/7/2005 4epp P8efe88e4 Zcco9nt qizp8@itzte,4e,9i 4epp500 1/7/2005 4EPP P8exie8 I9ppo8t qizp8@itzte,4e,9i 4epp500 1/7/2005 4epp ihopping Cz8t Qizp85@hotxzip,com 4epp5 1/7/2005 4eiktop czppop 1/7/2005 4ip8e8t qizp8@itzte,4e,9i qizp8@itzte,4e,9i 1/7/2005 4iic9iiion@freezope,org http://piiti,zxzze,np/xzipxzn/optioni/4iic9iiion/qix,izp8%40itzte,4e,9i ip8oho e8zy q8zy557 eyeizve85 PzyPzp125 1/7/2005 exi,inte8wiie,com qizp85 eyeizve85 1/7/2005 Epion cp98xex8e8 Qizp85@hotxzip,com epionP8O5000 1/7/2005 EPION Qizp8@itzte,4e,9i 4epp500 1/7/2005 Epion P8inte8 qixzepion Hz8xzn 1/7/2005 FC 4TIqzi <ente8> 1/7/2005 Fe4e8zp It94ent Zi4 (Qzcie)http://www,pin,e4,gov/PINWe8Zpp/pinin4ex,qip Pziiph8zie qzxeiizp8 PIN 1261 5/18/2004 Fi4ep http://www,xyizvingiztwo8k,com/xyizvingiztwo8k,htx 577 4P 1/7/2005 f8ee8izxzg,com qix,izp8@itzte,4e,9i qizp85@hotxzip,cox f8ee5 5/11/2004 freezope wikki wikki http://4ti4ni,freezope,org/xznzge http://www,freezope,org/regiite8r/confi8x?i4=5428&key=74PqZx8 9ie8nzxe 4ti4ni i4: 5428 zw26cc key: 74PqZx8 2/19/2004

       
    • jsalb3

      jsalb3 - 2004-11-19

      OK, I'm getting close; here is an example of my import file:
      www,abc,com<tab>logn id<tab>password<tab><tab><new para>
      www,def,com<tab>logon id<tab>password<tab><tab><new para>

      This will work perfectly for the first 20 entries and then it will not import any more.

      I have tried Importing multiple times and more than 20 at a time with the same result. The first 20 entries remain; nothing new is added or replaced.

      This looks to be a great product, I am determined to get this right.

       
      • Rony Shapiro

        Rony Shapiro - 2004-11-19

        Hi,

        I'm working on supporting multiline Notes fields in 2.07.

        A pre-release version which is more forgiving (and informative) may be found here:
        https://sourceforge.net/tracker/index.php?func=detail&aid=1030060&group_id=41019&atid=429579

         
        • jsalb3

          jsalb3 - 2004-11-22

          Yeow - Pre 2.07 jumped from importing 20 records to importing over 150! I found some errors in my import file that I'm working on; great work, thank you.

          Once I get my source figured out and I get a good import, I'd like to contribute to the effort and write up some import documentation for Password Safe - in a .txt file; how would I upload it to the site?

           
        • jsalb3

          jsalb3 - 2004-11-22

          Got it!
          I narrowed down my 'real' passwords to 176, and Password Safe imported all 176 perfectly!

          I had some notes and mis-aligned entries which I removed from my import file and Password Safe handled it perfectly. Did I say that already?

          I'm writing up a brief "How To" for anyone who is interested.

          Let me know.

           
          • Rony Shapiro

            Rony Shapiro - 2004-11-22

            Hi,

            Glad you've found the new version helpful.

            If you mail me your notes directly, I'll try to have them incorporated in the new help file that will go with 2.07.

            Thanks.

            Rony

             

Log in to post a comment.