Old bug back? Folders not created on import from csv

[AlexanderL]

Hello,
New Passbolt user here, I’m trying to import a csv in Keepass format but I’m seeing this exact thing happening:

BUG: Specifying groups in a CSV file doesn't create the folders on import

We have been testing the new folder feature and have been attempting an import, but not having much luck, with our Lastpass format getting all folders interpreted as tags. We use Thycotic Secret Server, but a trial of Lastpass for teams meant we had a workflow for export to Lastpass format in place, which Passbolt took without issue, EXCEPT for importing folders. our Lastpass CSV export is this: name,username,password,url,extra,grouping, What column heading is the Passbolt importer expecting…

On passbolt 4.3.0

Can anyone confirm?

BR
Alexander

[pb1212]

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

[antony]

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.

[pb1212]

HI

Thanks - changing from \ to / has worked, the folder structure has imported great.

I really appreciate the quick response.

[AlexanderL]

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

[antony]

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