Dataport issue

nverma · 2012-04-12

I have created a dataport, to bring in the following fields from my excel file.

Fields in excel file
Description1
Description2
"Serial No."
"Office No.”
"Make/Brand Name"
"Model No."
"RESP Employee No."
"FA Class Code"
"Cost Center Code"
"Shortcut Dimension 7 Code"
"Depreciation Book Code"
"FA Posting Group"
"Depreciation Method"
"Depreciation Starting Date"
"No. of Depreciation Years"

For some reason it only brings the information from the following fields:
"Depreciation Book Code"
"FA Posting Group"
"Depreciation Method"
"Depreciation Starting Date"
"No. of Depreciation Years"

The rest of the fields are just left as blank. Any idea why the dataport might only be bringing in certain fields.

Savatage · 2012-04-12

Did you learn anything from this post?
viewtopic.php?f=23&t=52286

Note: there is a section on Dataports in the Application Designers Guide. Good for reference.

nverma · 2012-04-12

nevermind...

I figured it out...I made a newbie mistake.

Savatage · 2012-04-12

You should always post what you did to solve your problem.

That's way those in the future who come across the same problem can find a solution on their own.

That's what makes these types of forums great, when people give.

nverma · 2012-04-13

the reason some of the fields werent showing up was because...when i was defining dataport fields...i manually typed the name of them...rather then using the lookup botton to add them...

Savatage · 2012-04-13

The manual entry of the Field names is fine as long as you spell them correctly.

And for all my dataports - I love importing the data into global variables I created and mapping them back to nav fields, validating where necessary. It gives you more control over the port. And by doing that I always type in my Dataport Fields.

Dataport issue

Answers

Categories