How to exclude some fileds from CSV Import/Export

How to exclude some fileds from CSV Import/Export

sbresch86sbresch86 Posts: 8Questions: 1Answers: 0

Hi,
i use datatable editor with csv import, searchbuilder and searchpanes extension. How can i exclude one or more fields from csv import and csv export extension? There are some fields (e.g. file upload) for which an export does not make sense. Does somebody has any idea?

Thx and regards
Simon

Replies

  • colincolin Posts: 15,142Questions: 1Answers: 2,586

    For the import, I'm guessing you're using code similar to this example. To remove some of those fields, you would add logic to either the loop on line 10 or line 36, depending on the flow that you want.

    For the export, you would specify which columns you want in the Buttons columns selector - see example here,

    Colin

  • sbresch86sbresch86 Posts: 8Questions: 1Answers: 0

    Hi Colin,
    thx for your reply and for the valuable tip. The adjustment of the export worked great with the ExportOptions. I use this example as a basis for the import. Since all fields are run through with two for loops. Do you have any idea how to adjust that to exclude individual fields? Possibly work without loops and specify the fields statically?

This discussion has been closed.