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
Comments
-
0 Like
-
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-comffice:spreadsheet"
xmlns="urn:schemas-microsoft-com
ffice
ffice"
xmlns:x="urn:schemas-microsoft-comffice:excel"
xmlns:ss="urn:schemas-microsoft-comffice:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40">
<DocumentProperties xmlns="urn:schemas-microsoft-comffice
ffice">
<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-comffice
ffice">
<AllowPNG/>
</OfficeDocumentSettings>
<ExcelWorkbook xmlns="urn:schemas-microsoft-comffice: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" ssize="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" ssefaultColumnWidth="65" ss
efaultRowHeight="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
0 Like -
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
0 Like -
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
0 Like -
Just wanted to contribute to this thread. I feel exactly the same as the TO.
I wanted to switch from lastpass to f-secure key, but couldn't do so due to the fact, that f-secure wouldn't accept .csv files.
Anyhow, I would really appreciate, if this application would support .csv files in the future, for it seems to be a great program.
0 Like -
Well, one could do that, but this file would be encrypted and what we need is the raw data...
0 Like -
Yep, there are many different formats out there and our hands are full at the moment.
However I managed to squeeze some time for a quick script to help those who are eager to use fskey, it is unofficial, unsupported and all the applicable disclaimers
If you're interested in giving it a try (again, it is lightly tested!) here are the steps:
Export from lastpass in csv format
Copy the exported data from the web page into a file, say lastpass.csv (NOTE be sure to save it as UNICODE, the option can be found when you do File / Save As... down close to the save button where it says encoding if you're using notepad)
Download the script attached and put it in the same folder where the csv file was saved (let's say c:\temp)
from the command line, run:
lastpass2key.vbs lastpass.csv fskeydata.xml
it shoud show you a window that says "Done" once it finished (just a second or 2)
from fskey, import the fskeydata.xml file
WARNING:
Importing your data multiple times will create your data multiple times! it does not check if an entry already exists with that name.
If you give it a try, please let us know if it worked ok for you,
-Matias
1 1Like -
Uops, this is bound to happen with quick and dirty scripts
Would it be possible for you to try out with the same file, but be sure that there's no extra characters at the end of the file?
To do so simply open the csv file, go to the last visible character and press the delete key repeatedly, do not add any extra enter / return / space after the last character / letter, as this is my best guess as to what your problem is.
br
-Matias
0 Like -
@matias wrote:Yep, there are many different formats out there and our hands are full at the moment.
However I managed to squeeze some time for a quick script to help those who are eager to use fskey, it is unofficial, unsupported and all the applicable disclaimers
If you're interested in giving it a try (again, it is lightly tested!) here are the steps:
Export from lastpass in csv format
Copy the exported data from the web page into a file, say lastpass.csv (NOTE be sure to save it as UNICODE, the option can be found when you do File / Save As... down close to the save button where it says encoding if you're using notepad)
Download the script attached and put it in the same folder where the csv file was saved (let's say c:\temp)
from the command line, run:
lastpass2key.vbs lastpass.csv fskeydata.xml
it shoud show you a window that says "Done" once it finished (just a second or 2)
from fskey, import the fskeydata.xml file
WARNING:
Importing your data multiple times will create your data multiple times! it does not check if an entry already exists with that name.
If you give it a try, please let us know if it worked ok for you,
-Matias
How do I run the commands?
0 Like -
Hello Adrianleong98
Sorry for the late reply to your post.
To run a command you need to enter CMD. This can be opened by pressing windows button+R and the go to the folder where you have the files named in the instruction and then writing the command.
Instructions how to go to a folder in cmd can be found here.
Br
Johan
0 Like -
When I tried to run the commands, I get an error message saying: "Unrecognised file format". Could you tell me what I am doing wrong?
0 Like -
I'm trying to import my passwords from Lastpass, but I have this same problem.
I also get an error "Unrecognized filetype" when I run the script.
These are my steps:
1. Export passwords in csv from Lastpass as lpass.csv
2. Open the file in Notepad, save as > pass.csv > Unicode format
3. Open command prompt and run the command
4. Error...
Please help me, because I've had enough of Lastpass
0 Like