We've got an integration to add new items to the inventory tables but it isn't integrating all the fields which it should be; in particular the 6 custom fields on the options card and the item notes. All the integrations report as being successful.
The source is an SQL table.
What do you mean custom fields?
The 6 custom/user defined fields, columns [USCATVLS_1] - [USCATVLS_6] in IV00101
Worked for me. I had to first make sure those types existed. For example I had to go into the options window in GP and a Test1 for the first Category and I was prompted to add this category value.
In the mapping if you click on the Options folder and then on the right side next to the Fields tab click the Options tab, does it say Use Field Rules or Use Default?
It was set to 'use default'. Now that it is set to 'use field rules', it works. Thx!
However, the notes still aren't working...
Mine worked as well. What are you mapping the note to in your source? Is it a lot of characters?
It comes from a custom system which we use to manage the addition of new items. The average length of the history field is 300-600 characters, well within the max of 32,000.
What is the format of the data coming from your custom system? From the looks of your integration layout, this should work.
Its an nvarchar(2000).
I just tried integrating it with "test" in the history source field (to the notes destination field), and it didn't work. Prompted by what you said I thought it could be some of the line breaks, but apparently not or it would have worked with "test".
Instead of mapping it set it to use constant just as a test.
I just mapped mine and it worked as well. Not sure what is going on with yours. If you preview the source in IM do you see the notes?
I am with Jonathan on this one - if you Right Click on the source and preview your data do you actually see any of the notes? If you do not, I am thinking I would recommend a script to cast and convert the SQL field to an alternative data type, even if it's smaller, and truncates information initially, as a test.
In the source preview, the notes do appear as a field with the correct data.
Tried setting it as a constant of "test note" and it didn't work.
Something isn't right with the setup then because I tested this on 2010 and 2013 and it works just fine. I would have to refer you to open a support case for this so we could get your IMD file and source files in house to look at this further.