I'm doing several constituent imports today from txt files and in Review mode I'm seeing something I haven't seen before. It looks like there are some potential duplicates (which is normal), but for this particular file, there is no data telling me the potential account number and the new account number as I normally see. Has anyone else had this before and if so, what does it mean and how can I get the account information for the duplications?
Thanks in advance for any insight!!!
Here’s one common issue that I see.
If fields in the import format file have been rearranged, make sure that the last field (and no other field) in the RECORD section defines the EOL terminator (\r\n):
<FIELD ID="eaddress" xsi:type="CharTerm" TERMINATOR="\r\n" MAX_LENGTH="80" COLLATION="SQL_Latin1_General_CP1_CI_AS"/>
<!-- The last line of the record node should have a TERMINATOR="\r\n" to indicate the end of the import row. -->
=>Ryan Creps
@Tessitura Network
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of David Geoffrey Hall Sent: Wednesday, December 18, 2013 11:37 PM To: Ryan Creps Subject: Re: [Tessitura Technical Forum] Constituent Import
Hi Aaron, that error is what happens when the columns in the XML file do not match the columns in the import file, and vice versa. Have you forgotten to remove the comment tags at the beginning and END of the line in your XML file?
If you can post a copy of your XML file and the headers from your text file I'll happily have a look.
Cheers,
dgh
From: Aaron Waapu <bounce-aaronwaapu3789@tessituranetwork.com> Sent: 12/18/2013 10:21:39 PM
Hi Debbie, how did you overcome the access rights issue? I am experiencing the same error message and its driving me bonkers!
I am also getting an Error 7330? Ring a bell?
Thanks!!
---
Error getting data from \\svrfile01\Tessitura\ImportLists\8967.txt - Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)". The import file data may be out of sync with the specified format file.
Error 50000, Severity 0, State 0, Procedure , Line 0, Import failed. AP_CONSTITUENT_IMPORT halted.
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!