in

InaPlex Forums

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

Browse by Tags

  • Re: Importing to a table with no primary key

    Hi Mark this request has never come up before - very unusual to have no primary key. Was the table created using the SLX Administraotr? The answer is no, Inaport is hard wired to expect a primary key for the table. It can be any field; does not have to be a SQL Server primary key, if that is what you...
    Posted to Inaport (Forum) by admin on 10-26-2009

  • Importing to a table with no primary key

    We use Inaport (v7) with SalesLogix 7.2. I'd like to import to a system table that has no primary key. However, Inaport won't let me, as it continually asks me to complete the primary key field in the Relationships tab. Is there any way that I can setup an import to a table with no primary key...
    Posted to Inaport (Forum) by Anonymous on 10-26-2009

  • 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...
    Posted to Inaport (Forum) by admin on 03-17-2009

  • Re: Select Source Records from multiple tables

    Hi Doug There is nothing particularly wrong with that SQL, though I would normally write it as: SELECT a.*, c.* FROM account a INNER JOIN contact c ON a.accountid = c.accountid I just tested your SQL against SalesLogix in Inaport and it was fine. When you say you get a crash, what is happening? Perhaps...
    Posted to Inaport (Forum) by admin on 03-13-2009

  • Re: Transport

    Hi, It's Cegidim (sorry for the typo). This is a 3rd. party data provider who's data i am planning to upload into a CRM db. via INAPORT. I will need to build a Shell script to ensure that this transport is supported, which is fine. When are you planning to provide ftp support in INAPORT? Regards...
    Posted to Inaport (Forum) by EALTENBURG on 02-03-2009

  • Transport

    How do e.g Gegidim files end up at SalesLogix. i.e. Inaport does not have transport ( like ftp ) support. Regards, Eric
    Posted to Inaport (Forum) by EALTENBURG on 02-02-2009

  • Re: Excluding Records to a table

    Hi Edwin Interesting idea. Unfortunately, the code handling this table is completely general - it has no specific SLX knowledge. You could try using dbexecsql() or slxgetowner() in the expression column to get the userid and then map it. Regards David
    Posted to Inaport (Forum) by admin on 04-15-2008

  • Excluding Records to a table

    I saw the latest option that you can write excluded records to a table. Great. I want to write the excluded records to an activity record in SalesLogix. So that the admin user gets a reminder to do something about the record. However when writing to the actviity table, I do not have the virtual field...
    Posted to Inaport (Forum) by edwin on 04-15-2008

  • Re: Update Contact record in SLX 7.2 with Inaport 6.0.50720

    Hi You are not doing anything wrong, but Inaport insists on having the Account as a parent of Contact even for an update because of some quite complex business logic that needs to be implemented. Two possible approaches. First uses dbexecsql() 1. add a new field in tab 3 called accountid, and initialise...
    Posted to Inaport (Forum) by admin on 04-07-2008
Page 1 of 1 (9 items)
InaPlex Limited 2008