Hello, I am trying to run the Constituent Import utility from the client. I have the text file and the format file prepared and it runs perfectly on our Test system. However when I try to run the same files from the same location on our production system, I get the following errors:
....... may not be a valid directory or the process is unable to access the filepath.
.......file1.txt is not a valid file or the process is unable to access the file.
Error reading format file........ You do not have permission to use the bulk load statement.
As I said, the same files work in our test system so I do not believe it is the files. In trying to problem solve, I added the bulkadmin Server Role to my user on production (although my user in Test does not have this role.)
I've been looking at what differences in permission there might be between production and test and have not found anything.
Does anyone have any hints about what might possibly be wrong?
Many thanks,
Tanya
Hi Tanya,
When we set this up, I had to grant the account we use for the SQL Server database service access to the folder via NTFS permissions. We used Modify permissions. You would also want to confirm that the share permissions for the MIS_APPS share either allows Everyone or includes that same account.
It didn’t work properly until we did that from what I remember…
Thanks,
David
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Tanya Hoffmann Sent: Friday, December 4, 2015 6:44 AM To: David Frederick <DFrederick@scfta.org> Subject: RE: [Tessitura Technical Forum] Constituent Import Utility problem
Hi,
The files are on a shared folder that both Tessitura and the users can access. I’ve changed some of the exact names to protect the innocent but here are the file paths. If it were a permissions issue on the folder – what should I be looking for?
\\jfkc\MIS_APPS\TESSITURA\Tessitura\ImportGroupon\file1.txt
\\jfkc\MIS_APPS\TESSITURA\Tessitura\ImportGroupon\format\GrouponFormat.xml
Many thanks!