Skip to main content
In Out
Search
Search ONESOURCE Global Trade LatAm Help and Support.

This article applies to:

  • Product: ONESOURCE Global Trade
  • Sub-Product: in-out

How to manage external files in In Out?

This functionality must be accessed to register external files (accessories) used on output interfaces. This registration requires you to provide, for example, the
relative path
 and the
content
of the new file. In addition, you can
generate SQL scripts
 from the registers.

Adding an external file

  1. Access the menu
    Interface > Interface Structure > External files
    .
  2. On the
    External Files used in Output Interfaces
     screen, click
    Add
     .
  3. According to the definitions, complete the fields on the
    Create External Files
     screen:
    * Required fields
    • File Name*
      : Name of the file that will be registered.
    • Description
      : Descriptive text about the file.
    • Relative Path
      : File access path.
    • Content*
      :
      What parameters should be passed to In Out package programs?
      • Importer_IN_OUT_New.exe %1 %2 %3 %4 %5
      • reports_executed_imports_obs %1 "Text" %2 %3 %4 %5
      • data_files.exe -> for directory FilesTXT or
      • data_files.exe <path> -SU -> for specific directory
      attention
      If there are parameters in the BAT call, the default parameters are shifted to the last 5, for example, if there are 2 parameters in the BAT, the ID_IMPORT becomes %3, the user becomes %4, and so on. So calls would be different, e.g.: "IMPORTER_IN_OUT_NEW %3 %4 %5 %6 %7".
      If it is a BAT file, try to use the importer parameters:
      • %1 - Import Id\n%2 - User\n%3 - Password\n%4 - TNS\n%5 - RemoteDBN
    • Macro Replacement FROM/TO
      : Key (DE) and replacement value (
      STOP
      ) of the file interface.
    • Copy to Clipboard
      : Click to copy the macro to clipboard (Ctrl+C).
  4. Click
    Save
    .

Editing an external file

  1. Access the menu
    Interface > Interface Structure > External files
    .
  2. In the table on the
    External Files Used in Output Interfaces
     screen, click the
    Edit
     button of the record whose information will be updated.
    To view or delete a record, click the
    View
     and
    Delete
     buttons, respectively.
  3. On the
    Edit External Files
     screen, change the required information.
  4. Click
    Save
    .

Generating a SQL script from an external file

  1. Access the menu
    Interface > Interface Structure > External files
    .
  2. In the table on the
    External Files Used in Output Interfaces
     screen, click the
    View
     button of the record to generate the script.
    Table data can be organized using the
    Hide Filters
    Show Grouper
    and
    Show/Hide Columns
    buttons.
  3. On the
    External Files Details
     screen, click
    Generate a SQL Script
     .
  4. On the
    Scripts
     screen, click
    Save SQL Script
    .
A SQL file will be generated with the file registry script.

Exporting external files

  1. Access the menu
    Interface > Interface Structure > External files
    .
  2. On the
    External Files used in Output Interfaces
     screen, mark the records of the files you want to export.
    To export data from all rows in the table, this marking is not required.
    Table data can be organized using the
    Hide Filters
    Show Grouper
    and
    Show/Hide Columns
    buttons.
  3. Click
    Export
    .
An Excel file will be generated with the information of the marked files, for example:

Related Content