F-Secure KEY and LastPass

Scholar

F-Secure KEY and LastPass

I'm egar to try F-Secure KEY.  I've been using LastPass for years and hav accumulated a lot of passwords I'd like to import.

 

The problem is, LastPass exports only in CSV format and KEY imports XML.  I've tried using Excel to convert but still KEY refuses the import.  Can anyone help me here?

 

Walt

22 REPLIES 22
F-Secure Product Expert

Re: F-Secure KEY and LastPass

Hello Walt,

 

Currently it is not supported to import passwords in CSV/LastPass format.

However, I will forward this as a feature request for future releases. Thank you for the feedback!

Best Regards,
Jouni

Has somebody helped you? Say thanks by giving kudos. Has your issue been solved? Mark the post using "Accept As Solution" button to let others know.
Novice

Re: F-Secure KEY and LastPass

Put my strong vote in favor of CSV import as well.  No way I could convert from what I use without importing.

Advocate

Re: F-Secure KEY and LastPass

A question to F-Secure:

 

I don't see either Key or Freedome under products on the F-Secure site. Not at the bottom of all pages either, under the headline Products where all other products are listed. Is there a reason for this?

Superuser

Re: F-Secure KEY and LastPass

I've never heard of it, but would be interested to have a look at it.
Superuser

Re: F-Secure KEY and LastPass

Scholar

Re: F-Secure KEY and LastPass

OK, here's an idea...

 

I only know the very basics if XML, but I'm thinking that maybe removing some or all of the initial stuff that Excel put on this file might make F-Secure KEY happy.  Can anyone enlighten me as to what KEY would want?

 

----------------  BEGINNING OF XML FILE EXPORTED BY EXCEL -----------------

<?xml version="1.0"?>
<Workbook xmlns="urn:schemas-microsoft-comSmiley Surprisedffice:spreadsheet"
 xmlnsSmiley Surprised="urn:schemas-microsoft-comSmiley SurprisedfficeSmiley Surprisedffice"
 xmlns:x="urn:schemas-microsoft-comSmiley Surprisedffice:excel"
 xmlns:ss="urn:schemas-microsoft-comSmiley Surprisedffice:spreadsheet"
 xmlns:html="http://www.w3.org/TR/REC-html40">
 <DocumentProperties xmlns="urn:schemas-microsoft-comSmiley SurprisedfficeSmiley Surprisedffice">
  <Author>Walt Scrivens</Author>
  <LastAuthor>Walt Scrivens</LastAuthor>
  <Created>2013-11-26T13:54:57Z</Created>
  <Version>14.0</Version>
 </DocumentProperties>
 <OfficeDocumentSettings xmlns="urn:schemas-microsoft-comSmiley SurprisedfficeSmiley Surprisedffice">
  <AllowPNG/>
 </OfficeDocumentSettings>
 <ExcelWorkbook xmlns="urn:schemas-microsoft-comSmiley Surprisedffice:excel">
  <WindowHeight>12120</WindowHeight>
  <WindowWidth>25360</WindowWidth>
  <WindowTopX>240</WindowTopX>
  <WindowTopY>240</WindowTopY>
  <ProtectStructure>False</ProtectStructure>
  <ProtectWindows>False</ProtectWindows>
 </ExcelWorkbook>
 <Styles>
  <Style ss:ID="Default" ss:Name="Normal">
   <Alignment ss:Vertical="Bottom"/>
   <Borders/>
   <Font ss:FontName="Calibri" x:Family="Swiss" ssSmiley Frustratedize="12" ss:Color="#000000"/>
   <Interior/>
   <NumberFormat/>
   <Protection/>
  </Style>
 </Styles>
 <Worksheet ss:Name="lp.csv">
  <Table ss:ExpandedColumnCount="7" ss:ExpandedRowCount="282" x:FullColumns="1"
   x:FullRows="1" ssSmiley Very HappyefaultColumnWidth="65" ssSmiley Very HappyefaultRowHeight="15">
   <Row>
    <Cell><Data ss:Type="String">url</Data></Cell>
    <Cell><Data ss:Type="String">username</Data></Cell>
    <Cell><Data ss:Type="String">password</Data></Cell>
    <Cell><Data ss:Type="String">extra</Data></Cell>
    <Cell><Data ss:Type="String">name</Data></Cell>
    <Cell><Data ss:Type="String">grouping</Data></Cell>
    <Cell><Data ss:Type="String">fav</Data></Cell>
   </Row>
----------------------------------------------

 

After this comes the actual password data.

 

Walt

Superuser

Re: F-Secure KEY and LastPass

Love the unintentional smiley invasion!  Smiley LOL

Highlighted
Former F-Secure Employee

Re: F-Secure KEY and LastPass

an xml format you could try to translate is the one passwordsafe uses, without the gibberish it looks like this:

 

<?xml version="1.0" encoding="UTF-8"?>
<passwordsafe>
  <entry>
    <title>dummy</title>
    <url>http://aca.com</url>
    <username>a user</username>
    <password>a password</password>
    <notes>a note</notes>
  </entry>
</passwordsafe>

 

the fields in lastpass are, as you saw:

    <Cell><Data ss:Type="String">url</Data></Cell>
    <Cell><Data ss:Type="String">username</Data></Cell>
    <Cell><Data ss:Type="String">password</Data></Cell>
    <Cell><Data ss:Type="String">extra</Data></Cell>
    <Cell><Data ss:Type="String">name</Data></Cell>
    <Cell><Data ss:Type="String">grouping</Data></Cell>
    <Cell><Data ss:Type="String">fav</Data></Cell>

 

so the mapping would be

csv name => xml title

csv url => xml url

csv username => xml username

csv password =>xml password

csv extra => xml notes

 

be mindful that in general csv files are plain ascii text, im not sure if lastpass saves it as utf-8 csv or not, you may have issues with some characters depending on the alphabet you normally use, be specially carefull when those characters are in your passwords as they may not translate properly (any ascii char < 128 should be safe to convert)

As long as you used only numbers, letters (in the english alphabet) and the most common symbols your conversion should work.

 

Hope it helps

 

-Mat

Former F-Secure Employee

Re: F-Secure KEY and LastPass

Hello,

Some problems with csv files are the passwords. Since a password can contain allsorts of characters, It might be hard to figure out where a password starts and ends. 

 

For instance, Imagine a csv format of name, password, url to service where the values are delimited by a semicolon. So it adhers to the format:

name;password;url

Then what if your password happens to be hGt235;64)(;ht a line in the csv file might look like:

Bob;hGt235;64)(;ht;http://community.f-secure.com, It is going to be rather annoying to parse it.

 

++lauri