in

InaPlex Forums

Forums and downloads for InaPlex customers and partners.
All Tags » Matching (RSS)

Browse by Tags

  • Re: Inaport delete error

    Hi Dan When I wrote it, GISME had a trigger on CONTSUPP (to detect changes to email and web addresses) , and it would not surprise me if wMobile does as well. If you batch file is running at the same time as the Inaport delete job, I could imagine this causing an issue. With over a million records in...
    Posted to Inaport (Forum) by admin on 10-26-2009

  • Re: No match found on _contact2

    Hi As Contact2 is 1-1 from Contact 1, you do not need to supply match criteria. Matching on any child table is a two step process: 1. Use the primary key and foreign key information in the Relationships tab to identify child records that belong to the matched parent record 2. Then use any match criteria...
    Posted to Inaport (Forum) by admin on 08-14-2009

  • Re: When using Inaport to create alarms, how best to update CAL createdby field

    No problem Sorry I was not clear about the matching. What I meant was that because CAL is 1:1 with _Calendar, you only need the primary key/foreign key criteria - you do not need to supply match criteria in addition. This is because matching is a two step process: 1. Use the foreign key to identify records...
    Posted to Inaport (Forum) by admin on 04-07-2009

  • Re: How to resolve Multiple Matches on _details table

    Hi Kim SQL Matching is only available in the Professional Edition. Standard matching will let you match on the parent _contact1 table, then match and create or update on the details table. Then reason we were talking about using SQL Matching earlier is that they needed to match on the child table (Details...
    Posted to Inaport (Forum) by admin on 04-03-2009

  • Re: Contsupp.City field Date

    Hi I've read your post about the sql query to update the contsupp table and thought I'd try it but when I select the sql query match type, it reverts to "no match". I suspect that this factility is available only in the professional edition and not the standard version that I think...
    Posted to Inaport (Forum) by ksharpe on 04-03-2009

  • Re: GoldMine: Primary and Additional Contact creation in one profile

    Hi Presumably you specifed the operation on _contact1 to be "Update existing or create new". The trick then is to set up some match criteria that allows you to identify the primary contact uniquely. For example (source and target expression in the Match tab for _contact1): normcomp(#sourceCompanyName...
    Posted to Inaport (Forum) by admin on 04-03-2009

  • Re: Multiple match criteria with Fuzzy Matches

    Hi As noted, because both company and contact are in the same table (in fact, same record) for GoldMine, it is difficult to set up different match criteria. I assume that you will have records in contact1 for ABC/Joe and ABC/Jenny. What I have suggested will work for this. If the only problems with company...
    Posted to Inaport (Forum) by admin on 03-24-2009

  • Matching against Numbers

    When using Standard or Fuzzy matching, Inaport will convert all target matching fields to strings BEFORE matching the incoming field against it. This is because Inaport needs to be able to match across many different database types, including products such as ACT! or SageCRM.com which do not support...
    Posted to Knowledge Base (Forum) by admin on 03-19-2008
Page 1 of 1 (8 items)
InaPlex Limited 2008