I am trying to import a csv file through xml port, I Need to remove the header column , how is it possible , any help will be great,Thanks
Hi,
try as per below on Onbeforeinsertrecord() trigger
if GlobalVar = 0 then
currXMLport.SKIP;
GlobalVar += 1 ;
declare globalVar as global variable as Integer
Hey !
I'v got the same issue recently and i found a solution.
The goal is to initialize a boolean variable and to execute it only once.In the xmlport we create an OnPreXmlPort trigger which initializes the variable to true.Then in the table we create the OnAfterInitRecord trigger which executes the variable only once and which will use the currXMLport.Skip() function which allows to ignore the first line of the CSV file, the header.
Exemple:
xmlport ID "Name" { Format = VariableText; Direction = Import; UseRequestPage = false; schema { textelement(Root) { tableelement("Import CSV Table"; "Import CSV Table") { XmlName = 'Import'; fieldelement("Something"; "Table"."Something") { } fieldelement(Date; "Table".Date) { } fieldelement(Type; "Table".Type) { } trigger OnAfterInitRecord() begin if firstline then begin firstline := false; currXMLport.Skip(); end; end; } } } var firstline: Boolean; // Initialize the flag on pre-xmlport event trigger OnPreXmlPort() begin firstline := true; end; }
Thank you Nitin Verma it helped
Another option to import CSV to Dynamics is to use Skyvia. It is a no code SaaS.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Rishabh Kanaskar 4,237
Nimsara Jayathilaka. 3,425
Sumit Singh 2,907
