Help! My List Couldnt Be Processed...What Do I Do?
The first thing to remember is this: Dont panic! A universal solution exists to have your list processed quickly and
completelyevery time. Here, we will guide you through the steps to make sure this happens. But first, we will
outline the most common reasons lists are unable to be processed.
Common Causes of Processing Failure
- Bad Delimiter. Using a custom-delimited or CSV (comma-separated value) format when submitting your list to us can cause problems. In a CSV file, each field is separated by a comma. Problems arise when the file is not properly delimited as a CSV, or when a program does not save a CSV correctly. The same thing goes for all custom-delimited files. In order to make sure your address list is processed correctly, the delimiter needs to be used correctly. This is the case no matter which delimiter is used.
- Line Breaks in the Values. Adding line breaks in your field values causes problems for much the same reason that bad delimiters cause problems; the format is the issue. When extra lines are found in the field, parsing a file becomes complex and error-prone. Because our systems cannot detect where a field starts and stops, the list will not be accepted.
- Mixed Character Encoding. The mixing of ANSI, Unicode, and other character encodings confuses computer programs. For example, when a program reads a character set as ANSI, and then encounters Unicode within the same character set, it doesnt know which code to choose in continuing the processing. While different programs interpret, write, and save files differently, Microsoft Excel can handle most mix encoding, so your best bet is to open your file in Excel and save it there.
Using $ in Microsoft Excel.
A $ is a special character in Excel, used for coding purposes. When a $ is included in the worksheet name, our
systems do not know what to do with it; its like having the @ twice in an email address (for example,
ilove@email@example.com vs. firstname.lastname@example.org). Doing this goes against the rules of
email and, more importantly, it
work. So the answer to this problem is simple. If you have a $ in your Excel worksheet name,
take it out!
By far, the single most efficient way to get your list processed every time is to use a tab-delimited file . Saving your list as a tab-delimited file before submitting it to us will almost always guarantee its successful process. Why is this? Tab characters are very rarely found in fields, and they are much less error-prone when parsing and interpreting your file.
Three Steps to Saving a List as a Tab-Delimited File in Excel
1. Open your file in Excel. FileOpen(filename).