Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Without using rapid start I need to import the data(txt file) through codeunit. The text file is mixed with some unwanted data. So I need to import valid data into item master.

(0) ShareShare
ReportReport
Posted on by 60

I have never done Integration with any 3rd party API and I don't have much more knowledge about integration.  Using Web service Import data to item table 

data Example

014 A03934  0CONE        000010000000100000000125M0009102000320NN00000000000000310S      0      002C 

The Above Given model text File  import data 

item no :=A03934    Des := Cone min Qty := 3 maxqty := 20

*This post is locked for comments

  • Kishor T Profile Picture
    60 on at
    RE: Without using rapid start I need to import the data(txt file) through codeunit. The text file is mixed with some unwanted data. So I need to import valid data into item master.

    The above data is imported and stored into temp table through the below code. in action button when click button store data into item table.

    Rec.RESET;
    IF Rec.FINDSET THEN REPEAT
    Item.INIT;
    Item."No." :=COPYSTR(Rec."Master information",4,8);
    Item.Description :=COPYSTR(Rec."Master information",14,11);
    Item.INSERT;
    UNTIL Rec.NEXT=0;
    Rec.DELETEALL;

    Actually Required  

     The data is insert directly Item table with out button click insert data in to item table.  

  • Suggested answer
    Suresh Kulla Profile Picture
    47,688 on at
    RE: Without using rapid start I need to import the data(txt file) through codeunit. The text file is mixed with some unwanted data. So I need to import valid data into item master.

    What do you mean by Button Click, you don't want to use Xmlport ?

  • Kishor T Profile Picture
    60 on at
    RE: Without using rapid start I need to import the data(txt file) through codeunit. The text file is mixed with some unwanted data. So I need to import valid data into item master.

    Already tried this its working..but it should be uploaded in a text file by a button click.

  • Suggested answer
    Stefano Demiliani Profile Picture
    37,166 Most Valuable Professional on at
    RE: Without using rapid start I need to import the data(txt file) through codeunit. The text file is mixed with some unwanted data. So I need to import valid data into item master.

    If this is a TXT file, you can use an XMLPort for loading and parsing it.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics NAV (Archived)

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans