Request Form in Dataport

lavanyaballurgi · 2012-11-02

Hello Experts,

How to add a request form in Dataport. I tried to add it the way I add in Reports but then I cant see the "FILE NAME" & text box (from which i used to browse the file to be uploaded) when I run the Dataport (where we give the path of csv file).

Help....

Chinmoy · 2012-11-02

We have all done this so many times. I can't figure out what you may have done wrong. But if you add some variables in the request form, the Options tab is definitely displayed when you run the dataport. Check for potential issues, like, did you add anything in the request form? etc.

Chn

lavanyaballurgi · 2012-11-02

Oh yes I added an OPTION VARIABLE in the request form. Is that allowed?

lavanyaballurgi · 2012-11-02

I am sorry for the mistake... Actually I can see the option tab but cant see the import/export box from which I used to brows the file for uploading

Chinmoy · 2012-11-02

Sure!

Set the property LookupMode in the Dataport as Yes. NAV will automatically add the selection of the file and path.

Chn

lavanyaballurgi · 2012-11-02

Not able to find lookupmode in property of dataport

NAV2009 R2 version... screenshot attached..

Dev · 2012-11-02

Yoy have to customise file selecting Dialogue box with your added field.

Chinmoy · 2012-11-02

Sorry typo... it is the property of the request form...

Chinmoy · 2012-11-02

Nope... you don't need to customize anything to get the filename from the OS.

lavanyaballurgi · 2012-11-02

thanks Chinmoy but still it wont work.. What I found is this (and it works)

To enter the Filename I created a textbox with ID 1 (FileExplorer-Feature!), SourceExpression as some TextVariable "VarFilename" and code in OnAssist of this TextBox:
CurrDataport.FILENAME := VarFilename;

I guess this is what DEV meant right?

Dev · 2012-11-02

Making LookUpMode = Yes is hiding all the default option of Request form. In my idea we cant alter the Request form of a DP

Dev · 2012-11-02

Yes, lavanyaballurgi you have done in right now.

Gud

Chinmoy · 2012-11-02

Can't agree with you both. No code is needed to get filename for import/export on NAV dataports.

lavanyaballurgi: Please let me know what you find from the sample dataport I have sent you.

Chn

Chinmoy · 2012-11-02

Oh yes... I think I got it... Are you fetching values of some more variables in the request form? In that case you need to follow Dev I guess. But if it is only Filename no need to write any code.

Chn

lavanyaballurgi · 2012-11-02

Well thanks to both of you & sorry for confusing you Chinmoy

kine · 2012-11-02

Just conclusion:
If you add something to the request form, you need to add all "standard funcionality" manually. It means, if you need to have Export/Import radiobuttons, you need to add them and use appropriate CurrDataport.Import value. If you need filename selection, add textbox, set Control ID to 1, enable assistedit = yes on it. Than use the value as CurrDataport.FILENAME. I think this is teached on first day of developer classes... 8)

lavanyaballurgi · 2012-11-02

And where are these developer classes given? I am tired of searching such course in India ](*,)

Chinmoy · 2012-11-02

lavanyaballurgi: check with Microsoft India, they organize these (through other training partners though) periodically. If you are subscribed to their news letters, you will come to know when and where these classes are held.

Chn

lavanyaballurgi · 2012-11-02

Thanks Chinmoy.. will try to get into one..

Request Form in Dataport

Answers

Categories