csv import with empty field
csv import with empty field
Hello
When importing a csv all thr fields have to be filled else if there s an empty one the remaining fields will be offset by -1 If the first line is empty you can t even map it to a field a template has to exist to be able to import the csv
(from redmine: issue id 4658, created on 2016-03-31, closed on 2016-04-20)
- Changesets:
- Revision 86633ee2 by Côme Chilliet on 2016-04-05T04:17:27.000Z:
Fixes #4658 Fixed error message when CSV import fails- Revision d50c7904 by Côme Chilliet on 2016-04-05T04:17:54.000Z:
Fixes #4658 Fixed error message when CSV import fails- Custom Fields:
- Bug in version: 1.0.10
Activity
pascal tempier wrote:
When importing a csv all the fields have to be filled else if there s an empty one the remaining fields will be offset by -1
Indeed, this should now be fixed (but you can’t map this column to a mandatory field if there are empty cells in it).
If the first line is empty you can t even map it to a field
I guess you mean if there are empty values in the first line, in this case you should be able to map it by using the column number thanks to the fix.
a template has to exist to be able to import the csv
Yes, that’s how import works.
(from redmine: written on 2016-04-01)
Ok that looks fixed, in as in, i can now select an empty column.
It s not fixed as in, i can t import my test csv to confirm. It says the login is empty Could we get at which line of the import is failling?
csv here under, using the user template in http://demo-fixes.fusiondirectory.org/fusiondirectory/ :
"mon prénom","bbb",,"test service 2","test user2" "mon prén","bbbaaa",,, dubois,jean-jaques,9876,"test serv3","test user3" "aaa","pas de nom",987,zzzz,xxxx monom,"monprénom pas de tel",,whoowoo,badabada olla,llalala,1121212121212,blabla,dorémifasol
(from redmine: written on 2016-04-04)
-
pascal tempier wrote:
Ok that looks fixed, in as in, i can now select an empty column.
It s not fixed as in, i can t import my test csv to confirm. It says the login is empty Could we get at which line of the import is failling?
Pushed a fix, now errors are grouped within a single error dialog which says at which line the error appeared.
csv here under, using the user template in http://demo-fixes.fusiondirectory.org/fusiondirectory/ : Sorry, demo-fixes is reseted daily I can’t see the template used. What did you use in login field and are you sure non of your csv lines produced an empty login?
"mon prénom","bbb",,"test service 2","test user2" "mon prén","bbbaaa",,, dubois,jean-jaques,9876,"test serv3","test user3" "aaa","pas de nom",987,zzzz,xxxx monom,"monprénom pas de tel",,whoowoo,badabada olla,llalala,1121212121212,blabla,dorémifasol
(from redmine: written on 2016-04-05)
-
pascal tempier wrote:
login : @%a|l|p|s[1,1]|givenName%%a|l|p|sn%@ pass : @%r[12]|%@ country : france displayname : @%givenName% %au|sn%@
nom, prénom, description, téléphone : @%askme%@
Unix tab home folder : @/home/%a|l|p|s[1,1]|givenName%%a|l|p|sn%@
You misread the documentation, if you want to apply several modifiers, you don’t separate them with «|». There is a single | which separates the attribute name from the modifiers. So you need to set:
login : @%alps[1,1]|givenName%%alp|sn%@ Unix tab home folder : @/home/%alps[1,1]|givenName%%alp|sn%@
Also, I’m pretty sure you want @s[0,1]@ to have the first letter and not the second one. Actually @s[1]@ also takes the first letter. I’m adding an example with 0 to the documentation to make this clearer.
(from redmine: written on 2016-04-06)
added Fixed label
