How to Import CSV Using XMLPort with parameter taken from User ?

aftab.khokhar@hotmail.com
aftab.khokhar@hotmail.com Member Posts: 5
in NAV Three Tier
Hello
I am trying to import CSV file using XMLPort with some user defined parameter
UserParameter is 'EmplyeeName'
EmplyeeName:= 'Text'

When i use
File.OPEN(FilePath + FileRec.Name);
File.CREATEINSTREAM(FileInStream);
XMLPORT.IMPORT(50031,FileInStream );
File.CLOSE;
How can i pass EmployeeName to XMLPort ?

Answers

  • RockWithNAV
    RockWithNAV Member Posts: 1,172
    Instead of XmlPort use the xmlport variable of that xmlport as reference then use it,

    File.OPEN(FilePath + FileRec.Name);
    File.CREATEINSTREAM(FileInStream);
    X.Setvalue(Employeename);
    X.Setsource(FileInStream);
    X.Import;
    File.CLOSE;

    X is the variable of that xmlport
    Setvalue is the new function in xmlport. pass emplyeename as parameter


    Setvalue
    GetValue := Employeename;

    GetValue is a Global Variable
    Apply this filter on PreXmlport.

    You are good to go now.
    Thanks

    Blog - rockwithnav.wordpress.com/
    Twitter - https://twitter.com/RockwithNav
    Facebook - https://facebook.com/rockwithnav/

Categories