in

InaPlex Forums

Forums and downloads for InaPlex customers and partners.

virtual fields and history table

Last post 03-18-2009 20:53 by admin. 5 replies.
Page 1 of 1 (6 items)
Sort Posts: Previous Next
  • 03-17-2009 21:53

    • cookts
    • Top 50 Contributor
    • Joined on 03-17-2009
    • Posts 3

    virtual fields and history table

     How do the vf fields work for importing into the history table in slx? I am importing GM emails and not sure what happens when you map to the vf_GoldmineEmail field.

     

    -tom

  • 03-17-2009 23:27 In reply to

    Re: virtual fields and history table

    hi Tom

    A lot happens. There are actually four different virtual fields for handling different scenarios. In each case, you map a text field that has a MIME encoded email to the virtual field. Inaport will parse the MIME text and extract various fields from the message header (date, subject, to, from, cc, bcc) and the message body (message text, attachments) then seek to set up one or more history records and attachment records. Ata a minimum, a history record will be created for the parent account or contact matched by the profile.

    • vf_MimeEmail - map a mime encoded email to this field
      Inaport will scan the email addresses found in the to/from/cc/bcc fields, and try to identify matching contacts. A history record will be created for each contact found, with the body of the email and the attachements.
    • vf_GoldMineMimeEmail  -  for handling MIME emails from a GoldMine database
      As for vf_MimeEmail, but customised to handle the non-standard elements of a GoldMine email. In particular, HTML email text is converted to plain text, and attachments are handled correctly. In a GoldMine email, the attachments are not stored in the body of the email; instead, a link is provided to a file on disk.
    • vf_MimeEmailSingle - only create one history record
      As for vf_GoldMineMimeEmail, but only create a single history record linked to the parent account or contact matched by the profile, instead of creating a history record for each of the to/from/cc/bcc email contacts.
    • vf_MimeEmailSingleNoError
      As for vf_MimeEmailSingle, but if there is an error when parsing the email, write a history record with the error message instead of logging an error and throwing the email away.

    Hope that helps. Any further questions, please ask.

    Regards

    Admin

    Filed under: ,
  • 03-17-2009 23:48 In reply to

    • cookts
    • Top 50 Contributor
    • Joined on 03-17-2009
    • Posts 3

    Re: virtual fields and history table

    I just need to map the mime to the vf field and that is it. I don't need to map any other fields in the history table? At a minimum, it should create a history record based on the acct/contact match from the profile.
  • 03-18-2009 0:05 In reply to

    Re: virtual fields and history table

    That is correct - it will populate a whole bunch of other fields for you, and link to the parent account/contact.

    Regards

    Admin

  • 03-18-2009 0:49 In reply to

    • cookts
    • Top 50 Contributor
    • Joined on 03-17-2009
    • Posts 3

    Re: virtual fields and history table

     I cannot get it to work. I map the rfc822 field to vf_GoldMineMimeEmail and I get an attachment if the email contained an attachment but the history record is not created. I know it is making an acct/contact match because the attachment is created.

  • 03-18-2009 20:53 In reply to

    Re: virtual fields and history table

    Hi

    I suggest you create a debug log by:

    1. Tools - Start Debug Logging - specify a log file
    2. Do a run with only one or two records

    Then send the log file to support@inaplex.com

    Regards

    Admin

Page 1 of 1 (6 items)
InaPlex Limited 2011