Hello,
New Passbolt user here, I’m trying to import a csv in Keepass format but I’m seeing this exact thing happening:
On passbolt 4.3.0
Can anyone confirm?
BR
Alexander
I am seeing the same issue when importing cvs files exported from lastpass.
for the grouping column i have tried using a single \ and a \
e.g
lastpass export default
username,password,totp,extra,name,grouping,fav
user1,password1,user1 Account,Folder1\Folder2\Folder3\Folder4,0
When it gets imported it creates a folder in passbolt called Folder1\Folder2\Folder3\Folder4 instead of creating the folder structure and puts the correct passords in it.
When modifing the csv with \
username,password,totp,extra,name,grouping,fav
user1,password1,user1 Account,Folder1\Folder2\Folder3\Folder4,0
it gets imported it creates a folder in passbolt Folder1\Folder2\Folder3\Folder4 instead of a folder structure
running 4.8
Hello @pb1212
Please, can you try to separate the folder with / instead of \ ?
Also, I have tried to reproduce the issues, as you can see the header are not correctly matching e.g. you have “user 1 Account” for TOTP. You can have more information about what is supported or not on our dedicated documentation.
After updating the exampled based on what you’ve shared I am able to retrieve the right folder structure.
username,password,totp,extra,name,grouping,fav
user1,password1,,,Resource Name,Folder1/Folder2/Folder3/Folder4,,
Hope it helps.
HI
Thanks - changing from \ to / has worked, the folder structure has imported great.
I really appreciate the quick response.
1 Like
Hello @antony ,
I’m glad that things worked out for pb1212, but for us the issue still remains.
We use the Keepass CSV format like the original linked bug report.
This test CSV:
“Group”,“Title”,“Username”,“Password”,“Url”,“Notes”
“Testfolder”,“Test account”,“Testuser”,“testpassword”,“https://test.com”,“Testing if folder is created”
renders this message for us:
1 password has been imported successfully.
1 folder has been imported successfully.
You can find these newly imported passwords in the folder
import-20240614081142
.
And indeed, the folder created is has the generic timestamped name. Could you please test on your side?
Best regards
Alexander
Hello @AlexanderL,
Sorry for the delay there.
I have been able to reproduce the issues but also resolve it, thanks to the example you’ve shared.
It looks like the issues here is that Url is not in uppercase where it should be URL according to our dedicated documentation.
Based on what you’ve shared, I have created this import.csv file.
"Group","Title","Username","Password","URL","Notes"
"Testfolder","Test account","Testuser","testpassword","https://test.com","Testing if folder is created"
"Testfolder","Test account","Testuser","testpassword","https://test.com","Testing if folder is created"
"Testfolder/Inception","Test account","Testuser","testpassword","https://test.com","Testing if folder is created"
"Testfolder/Inception2","Test account","Testuser","testpassword","https://test.com","Testing if folder is created"
"Testfolder 2","Test account","Testuser","testpassword","https://test.com","Testing if folder is created"
"Testfolder 2","Test account","Testuser","testpassword","https://test.com","Testing if folder is created"
"Testfolder 2/Inception","Test account","Testuser","testpassword","https://test.com","Testing if folder is created"
When changing Url to URL I have been able to import all of the folders.
I hope it helps 
Antony!
You are 100% correct, thank you 
I might have tested with
if (valid.toLower() == input.toLower())
or similar but maybe there are reasons.
I don’t think that I can update the title to reflect that the issue is solved so please feel free to do so!
All the best
1 Like