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]

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]

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.

Thats how far we got...

Buy what about the “encryption2” usercodes?

[mansart]

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]

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

thx for that