How to Import CSV file by removing the header column

(0) Share

Report

Posted on by Community Member

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

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Suggested answer

Nitin Verma 21,812 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi,

try as per below on Onbeforeinsertrecord() trigger

if GlobalVar = 0 then

currXMLport.SKIP;

GlobalVar += 1 ;

declare globalVar as global variable as Integer

Was this reply helpful? Yes No
Verified answer

Nrims 50 on at

Like (0)

Report
Copy link

Link copied!
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; }

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thank you Nitin Verma it helped

Was this reply helpful? Yes No
Elijah Stownton 192 on at

Like (0)

Report
Copy link

Link copied!

Another option to import CSV to Dynamics is to use Skyvia. It is a no code SaaS.

Was this reply helpful? Yes No