Hi There
We need to import a massive new Individual accounts in Tessitura. It's my first time using the Import Constituent from the Utility and can't even to make it work in Test Environment. I have made my XML and Text file columns identical and as I learned from other post my text is save as Tab Delimited and my xml last column should have TERMINATOR="\r\n".
<FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="80" TERMINATOR="\r\n" xsi:type="CharTerm" ID="eaddress"/>
Below is the err that I'm getting from tessitura front end:
50000 error during set up - \\kriostess\Impftp\Format Files\ is not a valid directory or is unable to access the filepath.
50000 Error 50000, Severity 0, State 0, Procedure, Line 0, Import failed. AP-CONSTITUENT_IMPORT halted.
Anyone did encounter these error in Importing Constituent? Any response will be greatly appreciate?
Thanks
Eric Lazaro
RWB - DBA
Hi Eric,
You are obviously a RAMP client as you are accessing the KRIOSTESS server.
I've created several import processes, based on the Constituent import, but importing into various tables and manipulating the data prior to the insert statement.
The line I use to pick up the file uses this format: \\kriostess\pub\Ovic\Test\Import\
So, I think you just need to specify the folder where the file resides slightly differently.
I use a series of sub-folders to keep my different imports separate, and it seems to work well.
Hope that helps.
Debbie
Thanks for the response Debbie.
I did even literally looked on SQL of which folder the my file resides and basically mirror the File path according to each subfolders from Server and still not getting success :)
here is now the error:
50000 Error during file import setup - \\kriostess\pub\WINN\Test\Import File is not a valid directory or the process is unable to access the filepath.
50000 Error 50000, Severity 0, State 0, Procedure , Line 0, Import failed. AP_CONSTITUENT_IMPORT halted.
I will still try playing around the file path....thanks for the tips