Getting "Invalid File Name" error when trying to import a mailing list

  • 6
  • Problem
  • Updated 5 years ago
  • Solved
Archived and Closed

This conversation is no longer open for comments or replies and is no longer visible to community members. The community moderator provided the following reason for archiving: Resolved

My co-workers and I are all currently unable to import mailing list files in any format--XLS, XLSX, or CSV. No matter what the file is named, we see the following error when trying to import: "Invalid File Name. Your file name contains a special character that is preventing your file from importing. Rename your file before attempting to upload again."

We have an important mailing that needs to go out either this afternoon or first thing on Monday. Help!
Photo of Chevron Business Point

Chevron Business Point

  • 11 Posts
  • 0 Reply Likes
  • frustrated

Posted 6 years ago

  • 6
Photo of Texas PTA

Texas PTA

  • 10 Posts
  • 0 Reply Likes
I haven't been able to upload anything in the last two days from my computer. Tried all the file types. I just get an "Import Failed"
Photo of Rachel Rogers

Rachel Rogers, Communications Strategist

  • 89 Posts
  • 2 Reply Likes
Thanks for alerting us about those import problems. I have jumped into both accounts (Chevron Business Point and Texas PTA) and was able to complete a test import into both accounts.

If you are still unable to import anything into your account, why don't you try uploading the spreadsheet you are trying to use into your document library and let me know that it is there. I will gladly take a look at the list you're trying to import and see what might be causing that hang-up.

I'll be looking for your reply!
Photo of Chevron Business Point

Chevron Business Point

  • 11 Posts
  • 0 Reply Likes
Hi Rachel,

We are still receiving the same error when trying to import a mailing list. ("Invalid File Name. Your file name contains a special character that is preventing your file from importing. Rename your file before attempting to upload again." )

As per your suggestion, I will import the following Excel mailing list, containing 5566 email addresses, to Documents:

Retail_EM_All_Brand_March_2014.xlsx

Thanks for your assistance. This is a very frustrating issue, and we have a Fraud Alert mailing that absolutely MUST go out today.

regards,
Karin
The Chevron Business Point Team
Photo of Texas PTA

Texas PTA

  • 10 Posts
  • 0 Reply Likes
I have uploaded our spreadsheet into documents: CS TXSTAR. Let me know if you are able to upload. Thanks. 
Photo of Rachel Rogers

Rachel Rogers, Communications Strategist

  • 89 Posts
  • 2 Reply Likes
Hi there! Your import seems to be working perfectly for me as well. I hesitate to complete it, because I'm not 100% certain what all of the fields in the spreadsheet are supposed to map to. Why don't you try importing the spreadsheet once again to see if it's working for you now. If not, please let me know and I can email you directly to try and get more information on how to complete your import accurately.

Thanks!
Photo of Texas PTA

Texas PTA

  • 10 Posts
  • 0 Reply Likes
I still got an import error. I was able to upload a different list last week, but this one is giving me trouble. 
Photo of Tyler Scott

Tyler Scott, Employee

  • 805 Posts
  • 39 Reply Likes
Good morning! Stepping in here for Rachel and I just posted a few different options for Chevron below. Can you please attempt these as well to see if this does the trick?

Thanks!
Photo of Tyler Scott

Tyler Scott, Employee

  • 805 Posts
  • 39 Reply Likes
Good morning Catherine! Can you please upload your Excel file to your document library in Emma? I’ll grab the file from there, so I can continue to do some additional digging.

Thanks!
Photo of Texas PTA

Texas PTA

  • 10 Posts
  • 0 Reply Likes
Sure! It's called CS TXSTAR
(Edited)
Photo of Tyler Scott

Tyler Scott, Employee

  • 805 Posts
  • 39 Reply Likes
Hey Catherine! That import is good to go and I’ve imported them into a group called EMMA TESTING. I did a little trick with the spreadsheet to remove any hidden formatting and then it took with no trouble. Here are those steps in case you need them for future reference. Please let me know if I can assist further.
  • Open the file in Excel, and copy all of the information
  • Open a new worksheet
  • Click the edit button and select “Paste Special”
  • Select “values” but nothing else and paste
  • Save that file as an .xls or .xlsx file
(Edited)
Photo of Chevron Business Point

Chevron Business Point

  • 11 Posts
  • 0 Reply Likes
Good morning, Rachel, any update on this issue? Per your suggestion, I uploaded our mailing list to Documents yesterday. Were you able to import it as a new mailing list?

Thanks!
The Chevron Business Point Team
Photo of Rachel Rogers

Rachel Rogers, Communications Strategist

  • 89 Posts
  • 2 Reply Likes
Hi there! My apologies for the delay. I downloaded your spreadsheet and was able to import it into your audience without any issue. I created a group for you that had the same name as the spreadsheet (Retail EM All Brand March 2014).

I'm not sure what was hanging you up there, but I'm happy to report that the import was a success!
Photo of Chevron Business Point

Chevron Business Point

  • 11 Posts
  • 0 Reply Likes
Rachel, thanks for importing that list for us! Much appreciated. I am now able to proceed with two important mailings.

Unfortunately, mailing list imports still aren't working.

I just tried again importing again with the same file, renamed to "test.xlsx" and received the same Invalid File Name error.

I'm stumped. This functionality was working perfectly for us last week...could a mandatory, corporate-wide Java update be to blame? Chevron does use older browser and Java versions....right now, we are using EMMA with Internet Explorer 10.0.9200CO
Photo of Tyler Scott

Tyler Scott, Employee

  • 805 Posts
  • 39 Reply Likes
Good morning! Stepping in here for Rachel as she is actually out until next week. I don’t believe the Java update should have an effect, but I wanted to see if you had Chrome or Firefox on your computer which you could attempt to use to see if you still run into the same error on the import in those browsers as well. 

If that doesn't fix things up on your end, we've got a few other troubleshooting ideas. I'd like to take a peek at the full file path of the spreadsheet you're selecting. Once you've selected the spreadsheet file from your computer that you'd like to import, but before you click continue, please copy everything in the box to the left of the "browse" button and paste that text here or if you’d like you can email it directly to me tscott at myemma .com On a side note, I did hear of another customer report where the spreadsheet they were attempting to import was saved in a shared folder, and that was causing some trouble. Do you know if you're using a shared folder to access the spreadsheet document you're attempting to import? 

Finally, when saving a file in Excel, there is an option to uncheck "append extension." If you save your file without a file extension, it will cause an error. The error we've seen in that case is not the same error as you're experiencing, but since it's not something we can duplicate on this end, we just want to be sure we double-check every possibility. Do you know if you've unchecked "append extension" when you're saving the Excel file on your end? 

Please let me know if you still run into issues though and we’ll keep digging!
Photo of Chevron Business Point

Chevron Business Point

  • 11 Posts
  • 0 Reply Likes
Good morning, Tyler,

Thanks for your suggestions. I pulled a new mailing list from our customer database this morning, and ran into the same "Invalid File Name" error.

We normally work from folders located on network drives, but following your suggestion, I downloaded this mailing list to my local hard drive: C:\Users\kwec\Downloads\Retail BizUnit All Brands March 2014.xlsx

The import operation failed once more with an Invalid File Name error when I tried uploading the new list to EMMA.

To confirm, we *are* creating the files in Excel with "append extensions" enabled.

Regarding your suggestion to switch to another browser, I'm afraid that's not possible at this time. Chevron has a tightly-regulated computing environment, and we are not permitted to install any software other than the official approved versions, which tend to be very old versions. In our case, we're still running on Internet Explorer 8 in our production environment.

I have a second PC with a test environment and Internet Explorer 10.0.9200CO installed, which we're currently using for creating and editing email blasts in Emma. I've tried the mailing list import on both my machines and with both versions of Internet Explorer, without success.

The Import facility was working just fine until last Friday, so I'm mystified why we're suddenly seeing these "Invalid File Name" errors.

Appreciate your help,
Karin
The Chevron Business Point team
Photo of Tyler Scott

Tyler Scott, Employee

  • 805 Posts
  • 39 Reply Likes
Good morning Karin! Thank you for the information and I’m continuing to dig on this and may need to rope in one of my colleagues to take a look as well. Can you please upload the most recent excel file to your document library in your Emma account. Please give me a shout once you’ve completed this and I’ll grab the file from there to do some more research.

Thanks!
Photo of Chevron Business Point

Chevron Business Point

  • 11 Posts
  • 0 Reply Likes
Good morning, Tyler,

As requested, I have now uploaded our most recent mailing list to our Documents library. The file is named EM_Only_March_2014.xls and it contains 805 email addresses. I tried importing it as a new group this morning, and once again received the Invalid File Name error.

I have tried importing this file using both IE 8 (our standard browser environment in Chevron's regulated computing environment) and also IE 10 on our test system (which is also now the system I use to create Emma mailings). The import failed with the same error on both computers.

Regards,
Karin
The Chevron Business Point Team
Photo of Tyler Scott

Tyler Scott, Employee

  • 805 Posts
  • 39 Reply Likes
Hey Karin! Thank you for the info and I’m going to pass this along to one of our tech specialists to have her take a look too. I’ll be sure to keep you posted. Please let me know if you have any questions in the mean time.

Thanks again!
Photo of Chevron Business Point

Chevron Business Point

  • 11 Posts
  • 0 Reply Likes
Thank you, Tyler. Would you be able to upload that list to create a new email list (same name as file..."EM Only March 2014")? We need to send a mailing out very soon to that particular user group.

Thanks!
Karin
Photo of Tyler Scott

Tyler Scott, Employee

  • 805 Posts
  • 39 Reply Likes
Good morning Karin! I’ve imported that list to a group called EMMA TESTING and it is good to go. You can of course change the name of the group, but those folks are definitely in there now.

I’ll keep you posted on what we find on the import issue.

Thanks!
Photo of Chevron Business Point

Chevron Business Point

  • 11 Posts
  • 0 Reply Likes
Thanks so much for importing that mailing list for us, Tyler. I can now proceed with sending out that email to our customer base....

regards,
Karin
Photo of Tyler Scott

Tyler Scott, Employee

  • 805 Posts
  • 39 Reply Likes
Good morning Karin! We’re still continuing to dig on this import deal, but have not yet been successful in recreating on our end. I’ve added a couple of Excel documents to your document library. One is called emmatestone while the other is emmatesttwo. One is your original data with all formatting removed and the other is just a file with my colleagues email address in it. Can you please save these files to your desktop and give them a shot importing into your Emma account.

I also wanted to see if you are in compatibility mode on your computer. If so, could you please try turning this off and see if this makes a difference when importing. Thank you so much for your patience and willingness to help. I’m hoping these items will shed some additional light.

Thanks!
Photo of Chevron Business Point

Chevron Business Point

  • 11 Posts
  • 0 Reply Likes
Good morning, Tyler. Appreciate your continuing efforts to assist with this odd problem...I downloaded your test files this morning, and tried importing them as new Audience imports. Received the same error for both files: Invalid File Name.Your file name contains a special character that is preventing your file from importing. Rename your file before attempting to upload again.

>I also wanted to see if you are in compatibility mode on your computer.

If you are referring to my Office setting, I don't believe we are using compatibility mode. The mailing addresses are retrieved from our customer database as .csv files. I have tried importing new mailing lists as .csv, .xls, and .xlsx and all of them are producing the same error, no matter what they're named.
Photo of Life Cycle Institute

Life Cycle Institute

  • 7 Posts
  • 5 Reply Likes
Hello,

I am having this issue as well. We usually do four imports per month. I have tried three of my four files and all are giving me this error. There are no unusual characters in the folder or file names. We update these sames files each month with our refreshed information so the file names and file types are the same as always. Any insight into this issue? I am using IE8, which has not been a problem before.

Thanks!
Photo of Tyler Scott

Tyler Scott, Employee

  • 805 Posts
  • 39 Reply Likes
Good morning! Can you please attempt to upgrade your browser to at least IE9 as 8 is a version which we no longer support. Or do you perhaps have Firefox and/or Chrome which you could attempt to use to see if you still run into the same issues? If this does not do the trick, please see the recommendations above on the comment with Chevron Business Point and let me know if you still run into troubles.

Thanks!
Photo of Tyler Scott

Tyler Scott, Employee

  • 805 Posts
  • 39 Reply Likes
Hey there! I wanted to check in to see if you were still having issues with that import or if those suggestions above did the trick. Please just give me a shout if you’re still having some difficulties.

Thanks!
Photo of Tyler Scott

Tyler Scott, Employee

  • 805 Posts
  • 39 Reply Likes
I wanted to thank everyone for their assistance and taking the time to help us troubleshoot this import issue. I’ve shared all of this information with our tech specialists team as they continue to dig. There is actually a separate Community conversation which we’ll continue to update once we have more info on this bug if you’d like to follow along. I’ve noted each of your accounts as being effected by this as well.

Thanks again! 
Photo of Chevron Business Point

Chevron Business Point

  • 11 Posts
  • 0 Reply Likes
Thank you for the update, Tyler. I was able to locate a version of Firefox for our regulated computing environment, installed it in my test environment, and am happy to report that I was able to successfully import a new mailing list. So, yes, the import issue does indeed seem to be Internet Explorer-specific.

Regards,
Karin
the Chevron Business Point Team
Photo of Tyler Scott

Tyler Scott, Employee

  • 805 Posts
  • 39 Reply Likes
Good morning everyone! I wanted to share some pretty sweet news that this issue has been resolved, so those imports in Internet Explorer will indeed work now. Thank you for your patience and flexibility!
(Edited)