Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Missing Checkbox Fields in Extract

We've noticed that some fields don't get replicated. For example, in the Contact table, the HasOptedOutOfEmail field (a Checkbox datatype) isn't in the resulting SQL Server table. Is this due to a SalesForce api limitation?
1 person has
this question
+1
Reply
  • Normally, when a field doesn't appear there are 2 possible reasons:

    1. The field level security of the field makes it not visible to the salesforce user. Verify what sf user is used by the link server. Then, login in salesforce as that user and navigate to an instance of the object in question. Is the field on the screen ? Check the field level security of the object for the profile of the sf user and make sure that 'Visible' is checked.

    2. The DBAmp metadata cache is behind. Normally, DBAmp will cache metadata until there is 1 to 3 minutes of inactivity. You can force a reload of the metadata by running the query below. If the field still does not appear, the pursue reason 1 above.

    Select * from SALESFORCE...sys_sfobjects

    If you are still having trouble after checking the items above, send a note to support at forceamp.com so we can take a look.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned

  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned