Guido Posted April 23, 2020 Share Posted April 23, 2020 Hello, I'm having trouble importing and exporting csv templates created with Passwordstate. It seems that it creates an incorrectly formatted csv with commas, when I open it with excel (office365), everything comes out unformatted. I attach the csv file. In addition, if I try to convert it via excel (from text to csv) to display it correctly, at the time of import I have this error: 23/04/2020 11:00:00 Passwords Row 5: Could not find a matching Password List in the database. Possibly you specified an incorrect PasswordListID, or possibly one for a Folder. 23/04/2020 11:00:00 Passwords Row 4: Could not find a matching Password List in the database. Possibly you specified an incorrect PasswordListID, or possibly one for a Folder. Thanks results.csv Link to comment Share on other sites More sharing options...
support Posted April 23, 2020 Share Posted April 23, 2020 Hello Guido, That csv template file you provided opens okay for us in Excel. CSV files are meant to be comma separated, and I'm wondering what sort of formatting issue you are seeing? With your import below, I believe you are doing this on the screen Administration -> Password Lists. This is intended to bulk insert into multiple different Password Lists at a time, and you have to specify the correct PasswordListID values here, which it does not look like you have done. If you want to instead import into just one single Password List, you can do this from the Password List itself, under the Passwords tab. Look in the List Administrator Actions dropdown list beneath the grid, and you can import from there - and please use the CSV template from there as well, as you do not need to specify the PasswordListID values in this manner. Regards Click Studios Link to comment Share on other sites More sharing options...
Guido Posted April 24, 2020 Author Share Posted April 24, 2020 When export the csv template the result is: With Excel Office 365 Link to comment Share on other sites More sharing options...
support Posted April 24, 2020 Share Posted April 24, 2020 Hi Guido, Thanks, but we do not see that in the standard version of Excel - each field is separated into different columns. So any other customers using Office 365 see this problem? Regards Click Studios Link to comment Share on other sites More sharing options...
Guido Posted April 24, 2020 Author Share Posted April 24, 2020 I have the same problem with Excel 2019 (no office365) in another pc. it seems that passwordstate does not correctly generate the formatted csv. Link to comment Share on other sites More sharing options...
support Posted April 24, 2020 Share Posted April 24, 2020 Hi Guido, We have customers using this feature all the time, and we've never had this reported before sorry - so we do believe it is generating a proper csv file - if you open in Notepad, you should be able to confirm this. Maybe you could create your own CSV file based off the columns names you see in the one we export? Do any other customers have issues like this in Excel? Regards Click Studios Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now