Odd issue importing users from CSV
Question asked by Chris Eastin - 8/29/2020 at 11:27 AM
Answered
I'm trying to import a couple hundred users from a CSV file.  I've got the account name, password, Display name and Return Address.  I set up the CSV with the following headers "Account, Password, Display Name, Reply-To Address", followed by columns of data matching each.  The issue I'm running in to is, when I import the CSV, I drop the file into the import box, match the appropriate fields up with the column headers I created and submit.  It processes.  I get all the users.  The login, password and reply address show as normal, but the Display Name field is empty (on the full list of users, it shows the Account login name as the display nae, but the detail view of the user shows the field blank).  For example, if the CSV fields look like "Bob, Password123, Bob Robertson, Bob@somedomain.com", everything is fine except the Bob Robertson never gets imported.  I've tried both adding quotation marks around the name as well as making separate First Name, Last Name fields.  No help.  Any idea what I could be doing wrong?

5 Replies

Reply to Thread
0
Robert Emmett Replied
Employee Post
@Chris, can you tell me what version of SmarterMail you are using?  I tested this against the latest public build (7544) and it works. I have included a screenshot showing the fields filled out.

Robert Emmett
Software Developer
SmarterTools Inc.
(877) 357-6278
www.smartertools.com
0
Chris Eastin Replied
                       SmarterMail Enterprise
                       Build 7523 (Aug 6, 2020)
                   

0
Chris Eastin Replied
Marked As Answer
Well, I found the fix.  I removed the reply-to address column and now the display names show up.
0
Robert Emmett Replied
Employee Post
@Chris, I am still unable to replicate the behavior. How were you setting the mappings?  I have set the "reply-to address" to be ignored and also set it as "Other Email".  In both cases, I was able to import the user and have the display name show correctly.

Robert Emmett
Software Developer
SmarterTools Inc.
(877) 357-6278
www.smartertools.com
0
Chris Eastin Replied
My original CSV was set up as follows...

username,password,displayas,reply_address
bob,Password123,Bob Robertson,Bob@somedomain.com

I'd map "bob" to the username, "Password123" to the password, "Bob Robertson" to the Display As, and ignore the reply address.  This would import the username/password but leave the Display As blank.

I then re-did the CSV to just have the username,password,displayas columns...
username,password,displayas
bob,Password123,Bob Robertson

And would map to the matching fields in the drop box.  This seems to work as now the Display Name shows in the account details (but still doesn't show in the full list of users).  This should be fine for what I'm doing.  If the end users want to put in a different reply address, they can do some themselves (will send out a message to all new users to check out their profiles and fill in any missing data).  




Reply to Thread