Microsoft Dynamics GP (Archived)

How do I use the Table Import?

(0) Share

Report

Posted on by Community Member

Administration->Setup->Company->Company

Then select Tools->Integrate->Table Import and select the VAT Country Code MSTR and click OK.

What do I do here? I don't understand how I am supposed to import data using this form. How do I do it?

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

callen 4,595 on at

Like (0)

Report

RE: How do I use the Table Import?

It's important to know that Table Import only imports new records and does not update existing records. So, now, here's what you do. You need a file in a comma-delimited or tab-delimited format.

Enter a Definition ID and Description. These just need to describe what you're doing.

For the Source File Format, select one of the two options.

Select your file as the Source File.

The Destination Table should be VAT Country Code MSTR.

For fields present in your source file, double-click on them to select the source fields, one field at a time. For example, if Country Code is in your file, double-click the Country Code field and select the appropriate field from your file. Repeat this step for each field you have in your source file.

For fields not in your source file, you can hard-code a value by typing it in the Constant field and clicking Add. Make sure the field to which you are assigning the constant is selected first.

For fields you do not need, like, probably, the Note Index, leave it blank.

Lastly, once you map your data, back up your text file and remove the header row. If you leave the header row in the file, that row will be imported into GP. You don't want that junk.

Then click the Import button. A file with rjt will be created. Hopefully, it's blank. If it isn't, it's because you have duplicate values based on what GP allows in the destination table. You can use Notepad to open the file.

That's it!

Was this reply helpful? Yes No
Brenda Willey 2,520 on at

Like (0)

Report

RE: How do I use the Table Import?

Just a quick question. What happens if there is data in the table. will it clear it and re import or will it just add the new records?

Was this reply helpful? Yes No
callen 4,595 on at

Like (1)

Report

RE: How do I use the Table Import?

The data in the table is unaffected. All Table Import does is add new records.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

RE: How do I use the Table Import?

I want to import an item/pricing file into GP. I understand the steps to import except for the Import Definition. Where do you go to the Import Definition? I have watched so many videos and read so many blogs but they all assume the import definition is already existing.

Thanks

Was this reply helpful? Yes No
Mariano Gomez 26,225 on at

Like (1)

Report

RE: How do I use the Table Import?

Take a look at my article dynamicsgpblogster.blogspot.com/.../often-overlooked-yet-powerful-table.html. I have a concrete example on importing data.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: How do I use the Table Import?

Thank you. I read your article a few days ago. What is the menu path to create the import definition? We have no definitions created yet. This is the first import I am attempting. I will be working with a consultant in a few days but want to have some of the infrastructure in place.

Was this reply helpful? Yes No