Share
ReportI 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
You’re offline. This is a read only version of the page.
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
Another option to import CSV to Dynamics is to use Skyvia. It is a no code SaaS.
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:
All responses (
Answers (
192
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;
}
Hi,
try as per below on Onbeforeinsertrecord() trigger
if GlobalVar = 0 then
currXMLport.SKIP;
GlobalVar += 1 ;
declare globalVar as global variable as Integer
