<MvEXPORT>

   Also See:   file_append file_create file_read MvIMPORT  

Report a language bug  |  Report a documentation error
Appends a single line of data to an external output file in the data folder, at the end of the output file, on a new line. It does not automatically loop. See .
Syntax 
<MvEXPORT FILE = "string: {  expression } | literal"
          FIELDS = "{ expression } | variable list"
          DELIMITER = "string: {  expression } | literal">
  • Empty Tag

Designed for exporting flat file information <MvEXPORT> can be used to export database files or other information in a delimited format. Unlike <MvIMPORT>,  <MvEXPORT> does not automatically loop.

Attributes

  • FILE: Required, path and file name relative to the data folder.
  • FIELDS: Required, comma separated list of variables. If null only the delimiter value will be written.
  • DELIMITER: Required, delimiter can be null, a single character. or multiple characters. If null only the fields value will be written.

Examples

This example writes a single line of data to an output file. If the file does not exist, it will be created the first time the command is executed.

Example:

<MvEXPORT FILE = "{ l.months }" DELIMITER = "{ l.tab }" FIELDS = "var1,var2,var3">

This example write a header line then loops through an open products database outputting 3 variables on each line. New lines are appended to the end of the file.

Example:

<MvASSIGN NAME="l.tab" VALUE="{ asciichar(9) }">

<MvEXPORT FILE = "{ l.flat_product_file }" DELIMITER = "" FIELDS = "l.header_export">
<MvWHILE EXPR = "{ NOT products.d.eof }">
    <MvEXPORT FILE = "{ l.flat_product_file }" 
              DELIMITER = "{ l.tab }" 
              FIELDS = "products.d.id,products.d.code,products.d.name">
    <MvSKIP NAME = "products" ROWS = "1">
</MvWHILE>

resulting file : 
1,ks0421,Kiki Shirt
4,ps0121,Polo Shirt
etc.

Writes a single line of data to an external output file.

+ Add a note
User Annotations: MvEXPORT