• 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
  • $organization

    We have also been working with the standard import utility.

     

    Just $0.02.  You have likely already looked at this.

     

    We have seen problems like this when you do not have a space in the last column of data exported.

     

    This can be impacted by the way we exported from MS Excel.  (Presuming you are using Excel to cleanup your data.) Highlight copy and paste may not work well depending where you past the results.  Notepad ++ seems to be better than some options.

     

    If I remember correctly we like the option “Save as” and choose “Text (Tab delimited) (*.txt)” as the save as type.

     

    --Tom

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Wendell Baskin
    Sent: Monday, January 13, 2014 5:34 PM
    To: Thomas Brown
    Subject: [Tessitura Technical Forum] Constituent Import

     

    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
  • $organization

    We have also been working with the standard import utility.

     

    Just $0.02.  You have likely already looked at this.

     

    We have seen problems like this when you do not have a space in the last column of data exported.

     

    This can be impacted by the way we exported from MS Excel.  (Presuming you are using Excel to cleanup your data.) Highlight copy and paste may not work well depending where you past the results.  Notepad ++ seems to be better than some options.

     

    If I remember correctly we like the option “Save as” and choose “Text (Tab delimited) (*.txt)” as the save as type.

     

    --Tom

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Wendell Baskin
    Sent: Monday, January 13, 2014 5:34 PM
    To: Thomas Brown
    Subject: [Tessitura Technical Forum] Constituent Import

     

    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