csv import

[boutn]

Any of you tried importing users via csv-file on the newer machines? (MX6070V)

We have a new client, who has like a bazillion users, with usercodes, and they have an xls list of these...

Not really in the mood of inserting these manually

[mansart]

Re: csv import

Set up a "test" user on Sharp, then export it.

Once open you will see the format the sharp requires.

From here copy and paste customers data into the Sharp export.

Once done import that file into the Sharp.

[boutn]

Re: csv import

Set up a "test" user on Sharp, then export it.

Once open you will see the format the sharp requires.

From here copy and paste customers data into the Sharp export.

Once done import that file into the Sharp.

[mansart]

Re: csv import

Here is how I got it to work......

Turn on account control......create one test user with a 5 digit PIN

Log on to web interface as admin........export the csv file.

id = increment up by 1
name = user name
search-string = initial
login-id = user number Ex. 12345
login-id/@encodingMethod = LEAVE BLANK
password = user number again
password/@encoding = LEAVE BLANK

Capture.JPG
Now save and import. The encryption will be done at time of import, so the next time you export you won't see "user number" 12345, it will be encrypted

[boutn]

Re: csv import

Here is how I got it to work......

Turn on account control......create one test user with a 5 digit PIN

Log on to web interface as admin........export the csv file.

id = increment up by 1
name = user name
search-string = initial
login-id = user number Ex. 12345
login-id/@encodingMethod = LEAVE BLANK
password = user number again
password/@encoding = LEAVE BLANK

[ATTACH=CONFIG]42028[/ATTACH]
Now save and import. The encryption will be done at time of import, so the next time you export you won't see "user number" 12345, it will be encrypted

thx for that