I can't install PwB for some reason so will have to rely on your exports.
Can you create a test database with a few entries and post the complete export?
cheers, Paul
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi Paul, mate I have backed up/deleted and recreated/joined a couple different websites to create the new json. If this does not work are you able to supply me with an email address so I can send you my original (less really sensitive passwords of course)
Here is the initial draft to convert PwB JSON to CSV.
I'm doing this to allow you to view the data and make any amendments.
I have not converted tags because there weren't any in the test data but everything else seems OK.
You will need to use the CSV to XML converter to turn the CSV into an XML file for import.
Use
Extract 2 files from the attached zip.
Run (double click) on the PB2CSV command file to launch the converter.
It may trigger Windows smart screen - click “More Info” and then “Run anyway”.
Select the JSON file to import and the CSV file to export.
Open the CSV file in your spreadsheet, delete the first row and check the data.
Once you are happy, run the CSV to XML converter to produce the KeePass XML file for import.
Hi Paul, sorry mate I have downloaded the attached and it is the actual Password Boss install file, there are "2 files" only the executable, no PB2CSV command file
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
One of the 2 files in Password_Boss.zip file above is called "pb2csv.CMD". If you don't have "view extensions" enabled in Explorer you will only see "pb2csv" with a Type of "Windows Command Script". This is the file you need to run.
BTW, I have not sorted folder hierarchy (does that exist in PwB?) because the test data did not contain sub folders.
cheers, Paul
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Shit sorry mate, Im a twit. I have done what you have asked and I actually converted my proper passwordboss file to the XML file to import in to KeyPass, the format is perfect
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Dominik, I can't work out the import function in KeePass for my conversion scripts. (I've created the database no problems.)
Do I need to pipe the data to ImportUtil.Import?
cheers, Paul
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
The ImportUtil.Import methods are indeed used for importing data. You can pass one or more IOConnectionInfo objects that identify the file(s) to be imported.
Best regards,
Dominik
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Had this issue with other calls, like KeePassLib.PwGroup, but getting the argument number right sorted it.
Tried with different case, same deal.
PS C:\tmp> [KeePass.DataExchange.ImportUtil]::Import($PwDatabase, $FileFormat, $IOConnectionInfoImport, $MM, $CompositeKey)
Cannot find an overload for "import" and the argument count: "5"
cheers, Paul
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Yes, that makes sense.
I pass objects, except for $MM (=4) which is probably wrong.
$FileFormat is a KeePass.DataExchange.FileFormatPool object set to "KeePass XML (2.x)"
cheers, Paul
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Can you supply a sample Password Boss JSON export for us to work with?
cheers, Paul
Hi Paul attached is an altered Json file. I have also included the PasswordBoss program (zipped) so you can create a proper json file is needed
There are no URLs in that export - half of one in the name field.
Can you post a test entry with a URL?
cheers, Paul
I can't install PwB for some reason so will have to rely on your exports.
Can you create a test database with a few entries and post the complete export?
cheers, Paul
Hi Paul, mate I have backed up/deleted and recreated/joined a couple different websites to create the new json. If this does not work are you able to supply me with an email address so I can send you my original (less really sensitive passwords of course)
Password Boss JSON to CSV converter
Here is the initial draft to convert PwB JSON to CSV.I'm doing this to allow you to view the data and make any amendments.
I have not converted tags because there weren't any in the test data but everything else seems OK.
You will need to use the CSV to XML converter to turn the CSV into an XML file for import.
Use
Extract 2 files from the attached zip.
Run (double click) on the PB2CSV command file to launch the converter.
It may trigger Windows smart screen - click “More Info” and then “Run anyway”.
Select the JSON file to import and the CSV file to export.
Open the CSV file in your spreadsheet, delete the first row and check the data.
Once you are happy, run the CSV to XML converter to produce the KeePass XML file for import.
cheers, Paul
Last edit: Paul 2024-03-06
Hi Paul, sorry mate I have downloaded the attached and it is the actual Password Boss install file, there are "2 files" only the executable, no PB2CSV command file
One of the 2 files in Password_Boss.zip file above is called "pb2csv.CMD". If you don't have "view extensions" enabled in Explorer you will only see "pb2csv" with a Type of "Windows Command Script". This is the file you need to run.
BTW, I have not sorted folder hierarchy (does that exist in PwB?) because the test data did not contain sub folders.
cheers, Paul
Hi Paul sorry mate but I only have one file
Download the zip file above.
Extract the 2 files it contains to a new folder.
Double click on PB2CSV.
cheers, Paul
Paul there is only one file in that zip which is the passwordboss.exe file
This zip file you want is PasswordBoss2CSV-v1.2.zip in this post.
cheers, Paul
Shit sorry mate, Im a twit. I have done what you have asked and I actually converted my proper passwordboss file to the XML file to import in to KeyPass, the format is perfect
Glad it worked.
If you need anything else...
cheers, Paul
I've added it to the plugins page:
https://keepass.info/plugins.html#converttocsv
Thanks and best regards,
Dominik
Dominik, I can't work out the import function in KeePass for my conversion scripts. (I've created the database no problems.)
Do I need to pipe the data to ImportUtil.Import?
cheers, Paul
The
ImportUtil.Importmethods are indeed used for importing data. You can pass one or moreIOConnectionInfoobjects that identify the file(s) to be imported.Best regards,
Dominik
I have to admit to being stumped calling the import. PowerShell can't decide which Import to use.
cheers, Paul
Weird. There definitely is an
Importmethod with 5 arguments.The error message mentions "
import"; maybe a case-sensitivity issue ("import" vs. "Import")?Best regards,
Dominik
Had this issue with other calls, like KeePassLib.PwGroup, but getting the argument number right sorted it.
Tried with different case, same deal.
PS C:\tmp> [KeePass.DataExchange.ImportUtil]::Import($PwDatabase, $FileFormat, $IOConnectionInfoImport, $MM, $CompositeKey)
Cannot find an overload for "import" and the argument count: "5"
cheers, Paul
PowerShell's error message might be incorrect. Maybe one of the arguments that you are passing is of the wrong type.
What are you passing as
$FileFormat?Best regards,
Dominik
Yes, that makes sense.
I pass objects, except for $MM (=4) which is probably wrong.
$FileFormat is a KeePass.DataExchange.FileFormatPool object set to "KeePass XML (2.x)"
cheers, Paul
Dominik, can you please confirm the value / use of "PwMergeMethod mm"?
If I use "PwMergeMethod.CreateNewUuids" I don't seem to get a value returned.
cheers, Paul
PwMergeMethodis an enum, with Int32 as underlying type. The elementCreateNewUuidshas value 4.Best regards,
Dominik