[Instructor] OK, let's just jump right in
and create an integration manager routine.
We're going to create a routine to import
vendor cards into Dynamics GP.
Let's go into Dynamics GP under purchasing, cards, vendor.
You'll notice that there are only two required
fields on the vendor card: the vendor ID,
and the vendor name.
I'm also going to import the vendor class,
that will default a lot of the fields on the vendor.
For example, if I created a vendor B,
and chose the class trade vendors,
it starts to fill out some of the fields,
see, net 30 payment terms,
other types of fields are filled out
including all these account numbers.
So, by just importing
a name and a class
it will fill out quite a bit of fields for you.
OK, let's get started.
We go into integration manager, click new integrations,
the integration name will be "vendor import",
or any name you'd like to give it,
there is a maximum number of errors allowed,
if you set these to zero, then the integration
will not continue,
if there's any errors it will stop
and nothing will be imported.
First thing we need to do is add a source.
Where are we getting our data from?
This is a text source,
I created a text file, it's a tab delimited text file,
it has column headings, vendor ID, vendor name,
and vendor class.
So that's the file that I'm using as my source,
back to integration manager, I say define new text,
I browse to that file you were just looking at,
I indicate that it's tab delimited,
I indicate that the first row contains column names.
If I click on the column tab, I can see sure enough
it was able to read in my three fields,
I will mark that the vendor ID is the key field.
I apply that, click OK,
I can right-click on that source,
and preview it,
and I can see that it's reading that in.
If I want I can remove it,
and go back to it under objects,
source adapters, text,
I could give it a better name than just "query 1"
by clicking the property button
and calling it "vendor file" or something like that,
so it's a little bit more readable,
it will rename it,
and then when I add the source, I go to text,
and there it is, vendor file, I need a destination,
I can add the destination,
looking in payables management,
selecting vendor, and the last thing
I need to do is just map it.
Vendor ID is mapped to vendor ID,
the name is mapped to vendor name,
and the class, I need to change the rule
from use default to use the source field,
and I point to my vendor class, now this is mapped,
I can save my integration, close that,
and it's ready to run.