InaPlex Forums

We are using Inaport 6.0 with Goldmine 7.0302.  When attempting to import items from a spreadsheet into a tab in Goldmine we get about 50 rows with "row error:  No matches on table _contact2".  _contact1 is being used as the parent table with _contact2 as the child.  _contact1 is matching records on key5 and key1.  The majority of items are bein imported and we cannot seem to find what is causing the error.  Any suggestions?  Thanks.

Hi

Have you checked that the Contact2 records actually exist? Try running the following query:

select accountno from contact1 where accountno not in (select accountno from contact2)

This will find records in C1 that do not have a C2 record. See if they are the records where you are getting a match fail.

If this is not the issue, let me know if the accountno's of the records that are failing have a trailing space.

Regards

Admin

Hi

The records do exist and yes, it appears that the accountno's of the records that are failing contain a trailing space. 

Thanks

Amy

Hi Amy

OK - in the setup for the _contact2 table, go to the relationships tab. Change expression for the foreign key to

trim(#ACCOUNTNO)

Then try again.

Regards

Admin

Hi - I thought for sure that would work, but am still getting the errors.  Any other suggestions?  I appreciate your help.

Thanks...Amy

Hi Amy

Try adding a trim() to the primary key for _contact2

Regards

Admin

Once the trim() was added to the primary key for _contact2 and _contact1 it worked.  Thanks for your help.

Amy

Thanks for letting me know

Regards

Admin

The suggestion also helped me with an issue where I was bringing in an existing field and the text showed an added \00 on the end, preventing me from annotating the text.

When I added the trim() function, it took it away the trouble-characters and allowed me to add text.

Very cool.

Thanks

DaveN

Hi Dave

You might want to also have a look at this knowledge base post, which discusses in some detail removing troublesome characters such as NULLs

http://www.inaplex.com/cs/forums/t/71.aspx

Regards

Admin