• Replies 6 replies
  • Subscribers 338 subscribers
  • Views 62 views
  • Users 0 members are here
Related

Missing attributes

Suzanne Bridger
$organization

I recently had to bulk add an attribute to around 6,500 constituents, which we then double checked in List Manager and everything was fine.  Since then we have found accounts where the attribute is now not present - I have reviewed my original lists and they did have it when we ran the checks. 

Without an audit log we having trouble explaining this phenonmenon and are more than a little bit stumped as to where these have gone and why. 

Has anyone else seen this happen and would know of possible causes/triggers?

Many thanks!

  • $organization

    Suzanne,

    Have you checked tx_keyword_cust_type to make sure that there is a row for this attribute and all account types that it was added to?

    For example if you added this attribute to Individual accounts and Corporate Contact accounts you would need  two rows in tx_keyword_cust_type with values:

    Keyword No - the new attribute you added, Cust Type - Individual

    Keyword No - the new attribute you added, Cust Type - Corporate Contact

  • $organization

    I thought of something else.  If any of the accounts were merged between the time you created the list  and when you imported, that could account for some discrepancies.

  • $organization in reply to Dale Aucoin

    This is the odd thing, I know that the cursor successfully added the attribute because the account in question was pulled up by the list that I ran immediately after, in which the criteria was 'give me everyone with attribute X' .  

    Also, the last account I looked at had never been through a merge.

  • Former Member
    Former Member $organization in reply to Suzanne Bridger
    Two other options.
    A bit obvious, maybe, but can they be removed manually? Has someone been accidentally deleting them?
    And do you have any automated attribute setting/removing scripts that might be exceeding their authority when they run and deleting this attribute by mistake?
    Ken McSwain
    +61 (0)418 659 360
    Sent from BlackBerry

    -----
    Original Message -----
    From: Tessitura Technical Forum
    To: Ken McSwain
    Sent: Wed Apr 08 19:47:13 2009
    Subject: Re: [Tessitura Technical Forum] Missing attributes

    This is the odd thing, I know that the cursor successfully added the attribute because the account in question was pulled up by the list that I ran immediately after, in which the criteria was 'give me everyone with attribute X' .

    Also, the last account I looked at had never been through a merge.

    From: Dale Aucoin
    Sent: 4/7/2009 11:43:09 AM


    I thought of something else. If any of the accounts were merged between the time you created the list and when you imported, that could account for some discrepancies.




    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.
    Please consider the environment before printing this email.
    =====This message is intended for the addressee(s) named and may contain confidential information.
    If you are not the intended recipient, please delete it and notify the sender.
    Views expressed in this email are those of the individual sender and are not necessarily the views of the Sydney Opera House Trust=====
  • $organization in reply to Former Member

    Hi Suzanne,

    Don't know if this is the same thing but I had a problem where I thought attributes had disappeared and it turned out the edit mask in T_Keyword was blank rather than set to 'none'.

    Once I'd changed it they reappeared! Although I still have no idea why this happened...

    Sarah

  • $organization in reply to Sarah Gilbert

    Hi Sarah,

    I know exactly that thing you're talking about, it catches me out regularly!  When I set up new attributes and check that they work ok they quite often go blank on me. 

    Some types of keywords don't need an edit mask so if you're copying from what you can see in the system table it's easy to miss it by mistake.

    Thanks, Suzanne.