How to Skip lines in CSV in dataport

scs_sathish · 2014-05-29

Hi all,

while importing Data port i want to skip some lines in csv file... is that possible..??

e.g: im importing purchase line, purchase line has the item no. which does not exist in item master, so error says like-->item no. does not exist in the related table item..now i want to skip that line & import the remaining line...and also i want skip the document type if its not an option other than in purchase line.(the existing options are Quote,Order,Invoice,Credit Memo,Blanket Order,Return Order). If user wrongly typed an option as payment or shipment, so in that case i want to skip that line too..

thanks & regards,
Sathish

Luc_VanDyck · 2014-05-29

You can use

CurrDataport.SKIP;

in the OnAfterImportRecord-trigger to skip a line.

PS: You are talking about Dataports, so this posting is in the wrong forum, right?

scs_sathish · 2014-05-29

Hi, Sorry im new to this forum..

I have used CurrDataport.SKIP , its working fine.

But if i used for option field, it shows error instead of skipping the line.

For E.g: I'm importing purchase line data, in one of the line has a document type as "Shipment" but there is no shipment in document type options.the existing options are Quote,Order,Invoice,Credit Memo,Blanket Order,Return Order. so error says like--> there is no option called Shipment, the existing options are...

In that case i need to skip that line instead of showing the error..

Regards,
Sathish

Luc_VanDyck · 2014-05-29

Instead of importing the CSV directly in the table, use text-fields instead. Then you can validate the input, before writing to the Purchase Line table. Create some variables of type Text, and replace your Dataport Fields with these variables.

Savatage · 2014-05-30

Luc Van Dyck wrote:

Instead of importing the CSV directly in the table, use text-fields instead. Then you can validate the input, before writing to the Purchase Line table. Create some variables of type Text, and replace your Dataport Fields with these variables.

:thumbsup:

How to Skip lines in CSV in dataport

Comments

Categories