Changing CSV Attributes

CSV Attributes is the information defined for workfiles. On the CSV Attributes Definition page you can customize a workfile's parameters, such as the external name, usage, and file headers. After a workfile is changed, it will not inherit the defined values in the locale.
  1. On the Lawson Portal homepage, click the search box and specify Multi-Step Job Definition.
  2. On the Multi-Step Job Definition page, inquire about a job with CSV Attributes by searching for the Job Name or Job Name with a User Name.
  3. In Operations, click CSV Attributes.
    Note: For a job without a CSV Attributes option, the CSV Attributes button is disabled. If your version of LSF does not support the feature, the CSV Attributes button is not visible .
  4. On the CSV Attributes Definition page, specify this information:
    External Name
    The external name (for work file storage) of this CSV file.
    Usage
    Select Output, Input, or Input/Output from the drop-down to specify whether the file is write-only, read-only, or both.
    File Header

    Click Off (no file header) or On (file header) to specify whether a file header containing field names should be written to the CSV file or, if the file is being read, if the header exists.

    If the header exists, the system assumes it is in a mixed-case format without spaces or dashes. For example, Company Nbr, not COMPANY-NBR. When writing a CSV file with a header, this format is also used.

    Xlt Header Names
    Click Off or On to specify whether to translate header names. If you are writing to a file and you choose On, it translates the header names as specified in the user's Locale record.
    Field Separator

    The symbol separating fields in the file. Valid entries are comma (,), Tab, Space, and None (fixed-length field format)..

    If you select Custom Char, specify the character in the Custom FldSep Char field.

    Custom FldSep Char
    The symbol separating fields in the file.
    Date Format

    The date format to use in any date fields that might be included in the file. Valid entries are:

    ccyymmdd - Date in century, year, month, day order.

    mmddccyy - Date in month, day, century, year order.

    ddmmccyy - Date in day, month, century, year order.

    yymmdd - Date in year, month, day order.

    mmddyy - Date in month, day, year order.

    ddmmyy - Date in day, month, year order.

    Date Separator
    The symbol separating month, day, and year formats. If you type a space, dates are compressed (a space is not used as a separator) and date fields are not enclosed with quote characters.
    Time Separator
    The symbol separating hours and minutes in any time formats that might be included in the file.
    Decimal Separator
    The symbol separating the parts of a number that has decimal places.
    Thousands Separator
    The symbol separating the thousands place from the hundreds, and so on.
    Quote Character
    The symbol to use for delimiting strings.
    Line Terminator
    The code that denotes the end of each line in the file. Valid entries are cr, nl, and hex 0D0A.
    File Terminator
    The code that denotes the end of the file. Valid entries are None and hex 1A.
  5. To save the changes, click Change.
    To undo the changes, click Delete.