Trying to update two fields in tiitm001, namely ctyp and csel.

Created an exchange scheme (see attached Word doc with screen shots)
for just the three fields item, ctyp, and csel.

When I run the import script, all records fail to process.

I can't figure out where I'm going wrong.

Is this allowable, or do I have to create a scheme for all fields ?

If it is allowable, can anyone tell me what I am doing wrong?

Thanks,

Dave M.

Dave,

Error 606 means that a reference does not exist.

I'm pretty sure it's saying that there is no reference to 10 in the Selection Code table.

10~3~606~1000003~500~10

Mike

Mike,

Thanks for the reply.

I'm pretty sure you're correct, but I haven't been able to remedy the error.
The selection code " 10" does exist in the selection code table.
The domain tccsel is a 3 character string which is right justified.
I tried putting a leading space in front of "10" in the ascii file and I am still getting the same 10~3~606~1000003~500~ 10 result.

Any further ideas ?

Regards,

Dave

Some further information:

The bshell log contains the following error.

2012-05-01[15:21:52]:E:dmcnally: Errno 0 bdb_errno 606 (Reference does not exist)
2012-05-01[15:21:52]:E:dmcnally: Log_mesg: Reference does not exist: tiitm001.ccur->tcmcs002.ccur [' ' ]

It looks like I need to include the currency field.
I'll give it a try and update the post.

Dave

Make sure the batch line is has "Add Record" set to no.

It sounds like it's trying to insert a full record.

Vince

Vince,

That's exactly what it was. Once I set "Add Record ?" to No, the data loaded.
See attached jpeg with screen shot.

Thanks for the help!

Dave M.