I am trying to import about 500 bulkmail users into our system. I have followed the instructions for import, so I understand how it is suppose to work. My problem here seems to be with excel not correctly identifying the email addresses. For example:
When I make a new excel document, and add the name in column 1, and email address in column 2, then save this file as a CVS, then import into Matrix it works great! Excel notices that I have typed in an email address, and it changes it to a blue color, and makes it a clickable email address. My problem comes when I need to copy and paste an entire list (500 addresses) into the excel columns. It seems that excel does not recognize the email addresses the same as when I manually type them in. I don't get them highlighted in blue, and they are not a clickable email address. Now this seems like it would not matter, but when I save this file (which looks exactly the same as the first file, just no blue linked email addresses) as CVS and import into Matrix it does not like the file, and only reads the first entry, gives me an error and makes that first one a bulkmail user.
Has anyone else had this problem? Is there any way that I can make it so that these import correctly, when I have to copy and paste the addresses and names into Excel?
I don't have a copy of Excel with me to test this on, but I'd imagine the way you input the email addresses into Excel isn't important, the important part is the exporting to a CSV (comma-separated values) file.
If only the first email address is importing, I'd suspect there is a problem with the character Excel is using to define a line break. This character varies between operating systems; Matrix is probably expecting a Unix style break.
When you export/save the CSV file, there should be some options around line-breaks, or the format in which to save the file. If there is a Unix format, pick that, otherwise try one of the other options.