When importing accounts with a csv file, passwords don't get imported

[anogues]

They appear blank.

Also in the db the column is empty

[nuxsmin]

Did you set the master password option?. If so, it's only needed when importing XML files (doc needed), so if you set it, it was used so the process tried to decrypt every password with it.

[anogues]

it may well be yes. I thin i tried to import the csv file with the master password (no import password set).

I will retry tomorrow without setting the master password and i let you know!

Thanks

[nuxsmin]

Ok, the documentation is already being written so it would be available when the stable version were released.

[anogues]

Uhm something not working.

I am importing the following csv:

p11;server;unix;url;user;password;notes

no passwords set, neither master nor import

Importación finalizada
Revise el registro de eventos para más detalles

but then i go to check the account:

It appears empty, i think it is because not setting the master password it hasn't cyphered the account when inserting it to the db

mysql> select account_pass from accounts where account_name = 'p11';
+--------------+
| account_pass |
+--------------+
| password |
+--------------+
1 row in set (0.00 sec)

But what i want is to import the csv file, and then store the encrypted passwords in the database, like when you create manually an account.

So i tried adding the master password in the import stage with the following

p12;server;unix;url;user;password;notes

but then:

Importación finalizada
Revise el registro de eventos para más detalles

Same behaviour in the UI and the field is empty in the db:
mysql> select account_pass from accounts where account_name = 'p12';
+--------------+
| account_pass |
+--------------+
| |
+--------------+
1 row in set (0.00 sec)

So how can i supply clear passwords in a csv file and get them encrypted on the db when these are bulk loaded?

[nuxsmin]

I'm blind....I didn't notice that the password was encrypted if it was previously decrypted...

[nuxsmin]

I'm solving an issue with the CSV delimiter...I'll let you know when solved

[nuxsmin]

Hi, it has been solved in the latest commit (devel branch). I've added the field enclosure character ("), so fields would be more safely parsed. Does it break your CSV?

[anogues]

No, we can add the quotes, no problem.

I'll try!

[anogues]

Con las quotes no funciona, vuelve a salir el password en blanco!

[nuxsmin]

Es raro...

Tiene algún carácter especial?

[anogues]

No, estoy probando esto

[anogues]

"p12";"server";"unix";"url";"user";"password";"notes"

[nuxsmin]

Igual...

[anogues]

Pruebo de nuevo a ver si la he liado..

[nuxsmin]

Actualizaste al último commit? https://github.com/nuxsmin/sysPass/commits/devel

[anogues]

Si, le he dado a bajar el ultimo zip de devel

[nuxsmin]

Es más, lo último que he añadido es la ayuda sobre los campos

[anogues]

Ya está ya está, le habia puesto el master password...

Culpa mía

[nuxsmin]

Ammm...perfecto!!

[anogues]

Todo cargado ya, y funcionando, gracias!