Error on importing csv file

[verob54]

I installed version 1.2.0.19 of "syspass".
When I want to import a csv file with my passwords I have the error:
- In Firefox: mime type not supported -Please check the file format
- Under Chrome: Wrong field number (1), please check the CSV format in line 1
My file is in the correct format, I also tested with a file that works (with 3 lines) find in a forum (same error)
Thank you in advance for your help if you have any ideas!
cordially

[haken735]

Hi,

I have the same issue.
I also tried to format the CSV file like it explained in wiki: account_name;customer;category;url;user;password;notes

bye

[taro-ball]

same here
syspass on Debian8
clients: Firefox & Chrome on MacOS

[Normo]

Hey,
I've encountered the same issue in the latest 2.0-beta release.

sysPass environment info:

• sysPass 2.0.0.17011901-beta
• Server side: Debian 8, Apache 2.4, PHP 5.6, MySQL 5.5
• Clients: Chrome 55, Firefox 50.1, Opera 42

Used CSV data:

VOIP Account from CSV;Cliente 1;VOIP;http://syspass.org;root;password;Account for VOIP
Google Account from CSV;Google;HTTP;http://syspass.org;root;password;Account for Google
Customer 1 Account from CSV;Customer 1;SSH;http://syspass.org;root;password;Account for Customer 1

Log entry:

sysPass[27846]: CEF:0|sysPass|logger|2.0.0.17011901|Import Accounts|El número de campos es incorrecto (1)#012Help : Compruebe el formato del archivo CSV en línea 1|0|ip_addr="..." user_name="..."

[nuxsmin]

Could you test it with the latest 2.0 release?

[Normo]

Hello @nuxsmin ,

I've updated to the latest 2.0-beta 2.0.0.17012501.
The CSV import seems to work now. I was able to import the CSV data which I posted in my previous comment. Accounts, Customers and Categories were created correctly. 👍

❗ But: The passwords were not imported correctly. Unfortunately the password field is empty. Maybe it is related to ##373 ?

[nuxsmin]

It could be, you should let blank the master password field because it would be used when you are importing an XML file that were encrypted within a different master password.

[Normo]

I left the master password field blank and imported CSV data again. Passwords were imported correctly. Thank you very much 👍

(Maybe two separate forms, one for XML and one for CSV, would be better? Or at least make it more obvious that import/master password are only needed for XML import. I know there is a '?' hint, but it should be more clear at the first view.)

[verob54]

Hi
I have not tested with the latest 2.0 release but thank you for all these answers
I keep you informed of my future tests!

[Normo]

@nuxsmin: Thanks for adjusting the import options layout.

[nuxsmin]

You're welcome @Normo

It was a bit confusing...

[nuxsmin]

Hi @verob54 and @haken735, could you try it out at the demo site?. Does it work with sysPass v2?

[verob54]

hello
We installed version 2.1 (2.1.0.17022601) and now it works for import csv files!!
Thank you very much for all
With this new version, there are just the translations of menus that are not all in French! Half Spanish and French ;-))

[nuxsmin]

That is great @verob54 !!

About the translation issues, I'll take a look because the default language for the untranslated strings is English, so it should display English anyway...

BTW, if you have some time I'd like to invite you to complete the French translation :) on https://poeditor.com/join/project/fmlsBuugyv

Thanks for the feedback!!

[verob54]

Here are some screenshots of the French / Spanish translation errors
I do the max to help you with the translation!

[verob54]

and there is no more the visual theme: Classic, there is only the theme "material blue"

[nuxsmin]

As of 2.0 version, the only visual theme is "material-blue", because I haven't enough time to maintain both themes. The theme color could be changed "easily" by downloading from https://getmdl.io/customize/index.html and adjusting some icons colors.

I think, that I could give more options by changing the theme color (maybe in a near future), but develop an entire theme is a very time consuming task :(