InaPlex Forums

 I am using Inaport to extract contact and sales information from Actinic ECommerce software which is based on Access.  The contact information is used to update CRM records in Goldmine and order information is to be added to Detail records within Goldmine PE.

When reading the Order information from the Access database, I need to import the record only if a flag in a table record is clear.  When the record has been read, the flag needs setting so that only the latest order information is read.

Is it possible to achieve this with Inaport (ie read and write to table records in the SOURCE)?

 Thanks

John

Hi John

Yes, this is possible. In Tab 5, have a look at the sub-tabs for each target table. There is a tab called "Pre and Post TableOp Expressions". (NOTE: Only available with a Professional License).

You can add one or more expressions to the grid for evaluation after the table operation (e.g. create or update) has happened. This can include a dbupdate() or dbinsert() that can update a source record or insert a new record into the source database.

Inaport also provides other functions to assist in this:

pk() - return the primary key of the record just created/updated

issinglematch()  -  return true if the record just touched was matched

Have a look in the expression editor in the section 'Pre and Post Table Op Expressions' and also in the help.

Any other questions, please ask.

Regards

Admin