• Replies 11 replies
  • Subscribers 337 subscribers
  • Views 265 views
  • Users 0 members are here
Related

Constituent Import

Teresa Dean
$organization

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!!!

Parents
  • Former Member
    Former Member $organization

    Thanks for everyone’s comments.

    After contacting TASK, it appears the problem may be related to database permissions.

     

    Best regards

    Wendell Baskin

    Bass Hall – Fort Worth

     

    From: Wendell Baskin <bounce-wendellbaskin7249@tessituranetwork.com>
    Sent: 1/13/2014 4:20:51 PM

    Several months ago I imported many constituents from using legacy data.  Referencing the Help system I configured the .xml file and the input (.txt) file.  The import process worked as expected, with no errors.

    Now, I'm experiencing a problem importing constituent data.

    When I attempt to import constituent data in Review mode (in Test), this error appears:
    Error #515.  Cannot import NULL into column "message" in T_IMPORT_SESSION_LOG.

    This error didn't appear during earlier imports.  So, I ran the import process referencing those earlier files (the files were not changed).  The same error message now appears using these older files.

    Data is being loaded into TW_CONSTITUENT_IMPORT, but that data is not imported into Tessitura.
    And, for each import attempt, data is being written to T_IMPORT_SESSION_LOG (including data in the "message" column).  I'm puzzled.

    I found some references to T_IMPORT_SESSION_LOG on the network, and continue to look for possible solutions.
    Reviewing previous posts it appears constituent imports can be a challenge.  
    I would be grateful if someone could point me in a better direction.

    Thanks, everyone, and Best Regards
    Wendell Baskin (    wbaskin@basshall.com)
    Bass Hall - Fort Worth




    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!

Reply
  • Former Member
    Former Member $organization

    Thanks for everyone’s comments.

    After contacting TASK, it appears the problem may be related to database permissions.

     

    Best regards

    Wendell Baskin

    Bass Hall – Fort Worth

     

    From: Wendell Baskin <bounce-wendellbaskin7249@tessituranetwork.com>
    Sent: 1/13/2014 4:20:51 PM

    Several months ago I imported many constituents from using legacy data.  Referencing the Help system I configured the .xml file and the input (.txt) file.  The import process worked as expected, with no errors.

    Now, I'm experiencing a problem importing constituent data.

    When I attempt to import constituent data in Review mode (in Test), this error appears:
    Error #515.  Cannot import NULL into column "message" in T_IMPORT_SESSION_LOG.

    This error didn't appear during earlier imports.  So, I ran the import process referencing those earlier files (the files were not changed).  The same error message now appears using these older files.

    Data is being loaded into TW_CONSTITUENT_IMPORT, but that data is not imported into Tessitura.
    And, for each import attempt, data is being written to T_IMPORT_SESSION_LOG (including data in the "message" column).  I'm puzzled.

    I found some references to T_IMPORT_SESSION_LOG on the network, and continue to look for possible solutions.
    Reviewing previous posts it appears constituent imports can be a challenge.  
    I would be grateful if someone could point me in a better direction.

    Thanks, everyone, and Best Regards
    Wendell Baskin (    wbaskin@basshall.com)
    Bass Hall - Fort Worth




    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!

Children
No Data