Hey All!So we're trying to slice and dice some segments from lists within Tessitura with criteria not in Tessitura, and then re-import the smaller, sliced and diced lists back in to pit them against one-another in testing email versus print mail stuff last season.We've been doing some work just exporting CSV files, splitting them up quickly ourselves, and then re-importing the nipped and tucked CSVs without issue ... Until now. We're getting some that work without issue, then others that return the following error:
The following error occured during import:Invalid input. This is usually caused by non-numeric characters customer numbers.We've ran through the customer ID column finding no non-numeric entries, confirmed we're indicating the correct one, even removed column headers (which are text coming straight out of List Manager) ... all to no avail.Anybody run into this ever before? Any tips, tricks, or otherwise?Thank you!Brian Jones
I've had to deal with this kind of problem before -- usually the first thing I check is the text encoding and line endings. If all of your files are from the same source and only some of them are having an issue, then that shouldn't be the problem, but it can never hurt to be absolutely sure. I always have a hex editor on hand just in case I need to inspect the actual bytes that are getting sent in one direction or another. (Not sure the best choice on windows; on mac I like 0xED).
Anyway, in your case the first thing I would try would be opening up the file in a text editor like Sublime Text (or something else capable of regex), and then doing a regular expression search for [^0-9\r\n], based on this StackOverflow answer. That should immediately highlight any characters in your file that are not a number 0-9, CR, or LF.
[^0-9\r\n]
I’m with Nick, with Notepad++ where he has Sublime, but if you’re already in Excel, you can put the formula below in a column and point it to your id number column (as written, ID is in A1 and formula would go in A2), then fill down. Numeric characters give a sum, non-numeric anywhere in the ID field string gives #value error. You could tweak it to true/false indicator, but this is the bare basics.
=SUMPRODUCT(SEARCH(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1),"0123456789"))
May not catch leading or trailing spaces depending on your version of Excel. I think every version that trims has the TRIM button in the ribbon, but you could always use =TRIM (A1) somewhere and then point the above formula to the results.
From: Tessitura Marketing Forum [mailto:forums-marketing@tessituranetwork.com] On Behalf Of Nick Reilingh Sent: Wednesday, July 26, 2017 3:19 PM To: John Trimble <J.Trimble@dbdt.com> Subject: Re: [Tessitura Marketing Forum] "Invalid input" on Import Attempt ... But the list just came from Tess?
From: Brian Jones <bounce-brianjones7980@tessituranetwork.com> Sent: 7/26/2017 3:23:05 PM
Hey All! So we're trying to slice and dice some segments from lists within Tessitura with criteria not in Tessitura, and then re-import the smaller, sliced and diced lists back in to pit them against one-another in testing email versus print mail stuff last season. We've been doing some work just exporting CSV files, splitting them up quickly ourselves, and then re-importing the nipped and tucked CSVs without issue ... Until now. We're getting some that work without issue, then others that return the following error:
The following error occured during import: Invalid input. This is usually caused by non-numeric characters customer numbers. We've ran through the customer ID column finding no non-numeric entries, confirmed we're indicating the correct one, even removed column headers (which are text coming straight out of List Manager) ... all to no avail. Anybody run into this ever before? Any tips, tricks, or otherwise? Thank you! Brian Jones
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Marketing Forum. You may reply to this message to post to the Marketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
This email has been scanned for spam and viruses by Proofpoint Essentials. Click here to report this email as spam.
I have had this happen if my import list is not a .txt or if my data row is not marked correctly in the import screen.
Make sure you are seleting your first data row correctly. Should be row 2 if you have field titles. Also your customer no column must be the column from your input where the customer ID is.