Thank you for this video. I have a question: Is possible using xmlport to import XML invoice composed by header and lines? Actually i use XmlDocument datatype to do this. Thank you for your answer!
Apologies for the delayed reply. Yes, it is possible to use XMLports in Dynamics 365 Business Central to import XML invoices composed of headers and lines. XMLports are specifically designed for importing and exporting XML data, making them well-suited for this task. Here's a brief overview of how you can structure an XMLport to import an XML invoice with headers and lines: Create an XMLport object in Business Central. Define the structure of your XML invoice, including both header and line elements. Map the XML elements to corresponding fields in your Business Central tables (e.g., Sales Header and Sales Line tables). Use the XMLport's built-in functions to handle the data import process.
Hi Mam, Really you are doing a good job. Your videos are very helpful to us we learn lot of things to your videos. Than i request to you can you make a full video about Debugger in Business Central and how we can use the debugger how can we see the watch time in it and all the things about debugger. Thankyou Mam
Thank you for your question! Yes, creating different tableElements based on the fields will help you keep your data organized and make it easier to work with.
Hi mam, In this video i think you import the csv file with the help of xml. But can you make a video how we can import the XML fie by code in AL. In this video we don't have import any CSV file we want to import the XML file so please make the video on it. Thankyou Mam.
I'll certainly consider this for our upcoming content schedule. Your suggestion is valuable, and I always strive to create videos that are beneficial to our viewers. Keep an eye on our channel for updates, and thanks again for your suggestion!
Thanks for the video mam. everything went well until when i tried import the file i made in notepad, this the error i got (Data at the root level is invalid. Line 1, position 1.) how can i solve that
The XMLPort can import and export data. If the XMLPort uses a request page, as specified by the UseRequestPage Property, then an option appears on the request page that enables the users to choose to import or export data. This is the default value.
code is not working. which extension use to save the file .xml when write on notepad and save it and use like this item.xml file but not import in Business central
@@gomstechtalks first i create a file using notepad and save it using .XML extension and after I write a same code but when I go for import choose file and than salect file but data import not show in items list
To import fields from a CSV file from 2 tables, you can use JOIN operation in your query to combine the data from both tables. Make sure you have a common column between the tables to join them effectively.
Hi, Thankyou for making this video series, Your videos are really very helpful.✌
Thank you.
Thank you for this video. I have a question: Is possible using xmlport to import XML invoice composed by header and lines? Actually i use XmlDocument datatype to do this. Thank you for your answer!
Apologies for the delayed reply.
Yes, it is possible to use XMLports in Dynamics 365 Business Central to import XML invoices composed of headers and lines. XMLports are specifically designed for importing and exporting XML data, making them well-suited for this task.
Here's a brief overview of how you can structure an XMLport to import an XML invoice with headers and lines:
Create an XMLport object in Business Central.
Define the structure of your XML invoice, including both header and line elements.
Map the XML elements to corresponding fields in your Business Central tables (e.g., Sales Header and Sales Line tables).
Use the XMLport's built-in functions to handle the data import process.
Hi Mam,
Really you are doing a good job. Your videos are very helpful to us we learn lot of things to your videos. Than i request to you can you make a full video about Debugger in Business Central and how we can use the debugger how can we see the watch time in it and all the things about debugger.
Thankyou Mam
Sure Sourabh. Thank you.
Oh, Perfect. Thank You gomathi❤🔥. what about .xlsx and .csv file uploading? Do you check emails?😕
Yes, I will check today. Was a little busy due to official work.
I have to import a CSV and it has several fields from different tables. Do I have to create different tableElements based on the fields?
Thank you for your question! Yes, creating different tableElements based on the fields will help you keep your data organized and make it easier to work with.
Hi mam,
In this video i think you import the csv file with the help of xml. But can you make a video how we can import the XML fie by code in AL. In this video we don't have import any CSV file we want to import the XML file so please make the video on it.
Thankyou Mam.
Sure.
@@gomstechtalks thanks mam..
Hi, Can you please make the same video for a sales order in which simultaneously we import the data in the sales header as well as the sales line?
I'll certainly consider this for our upcoming content schedule. Your suggestion is valuable, and I always strive to create videos that are beneficial to our viewers. Keep an eye on our channel for updates, and thanks again for your suggestion!
Hi mam, i am preparing MB 800 exam , i have refer some document from MS Learn ,can you plz tell me the correct way of preparing for the exam.
Hi, please proceed with Microsoft learn.
Thanks for making this series please make videos on event in business cenral
Sure.
Please find here th-cam.com/video/EaT17W3fBHo/w-d-xo.html
Thanks for the video mam. everything went well until when i tried import the file i made in notepad, this the error i got (Data at the root level is invalid. Line 1, position 1.) how can i solve that
Please check the source file. I can clear the error by only seeing the file.
ma'am can you explain with both like including export also
xmlport 50101 "GSXMLImportitem and Export"
{
format = varialeText;
Direction = Both;
The XMLPort can import and export data.
If the XMLPort uses a request page, as specified by the UseRequestPage Property, then an option appears on the request page that enables the users to choose to import or export data. This is the default value.
ma'am if by the way i don't need standard table we need own table than first we will make a table using snippet (ttable)
Yes. Create table, create page, then create XML port and in the page action, call the XML port.
@@gomstechtalks ok thanks ma'am
code is not working. which extension use to save the file .xml when write on notepad and save it and use like this item.xml file but not import in Business central
Can you please brief it clearly. Unable to understand.
@@gomstechtalks first i create a file using notepad and save it using .XML extension and after I write a same code but when I go for import choose file and than salect file but data import not show in items list
How can I import fields of a CSV file from 2 tables??
To import fields from a CSV file from 2 tables, you can use JOIN operation in your query to combine the data from both tables. Make sure you have a common column between the tables to join them effectively.
Please help me
Postman api get request records to store in business Central table