web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Without using rapid st...
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 Kishor T 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

I have the same question (0)
  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,166 Most Valuable Professional on at

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

  • Kishor T Profile Picture
    Kishor T 60 on at

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

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,243 Super User 2025 Season 2 on at

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

  • Kishor T Profile Picture
    Kishor T 60 on at

    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.  

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans