Creating File Layouts
The file layout is the main record in the file building structure. It aggregates all the other records required to generate or import electronic data files.
File layouts include settings such as the type of layout, decimal separator, and column and line delimiters. The record is also where you set the plug-in implementation that generates or imports the electronic data file.
When you import or generate a file, a map/reduce script uses the information you defined on the file layout and associated child records, to process the file.
After you save the file layout, create layout sections, section sources, and source fields to complete your file building structure.
To create a file layout:
-
Go to Setup > Latam File Builder > File Layout > New.
-
In the Name field, enter a name for the file layout.
-
In the Plug-in Implementation ID field, enter the ID of the plug-in implementation you want to associate with this layout.
To find a plug-in implementation's ID:
-
Go to Customization > Plug-ins > Plug-in Implementations.
-
Click View next to the plug-in implementation you want to associate with the file layout.
-
Verify the plug-in implementation's ID on the ID column.
Take note of the ID to enter it in the Plug-in Implementation ID field.
-
-
In the Type field, select the type of layout you want to use to build files.
-
If you want to use fixed numbers of characters to define the width for each field, select Fixed-width.
-
If you want to use special characters as delimiters to separate the fields, select Delimited.
-
-
If you chose Delimited as the type of layout, select the line and column delimiters.
-
In the Line Delimiter field, select the character you want to use as a line separator for the files generated with this layout.
Line delimiters appear at the beginning and end of each line.
-
In the Column Delimiter field, select the character you want to use as a column separator for the files generated with this layout.
Column delimiters appear between the columns in a line.
-
-
In the Default Value for Unused Positions field, select the value you want to include in the positions that the source fields do not fill.
-
In the Decimal Separator field, select the character you want to set as the default decimal separator for the fields from this layout.
-
In the Character Encoding field, select the type of character encoding you want to apply to files generated with this layout.
-
In the App ID field, enter the ID of the SuiteApp associated with this file layout.
NetSuite uses this information to define for which SuiteApp the file layout will be available.
-
In the Generated File Folder ID field, enter the internal ID of the File Cabinet folder in which to save the files generated with this layout.
To find a File Cabinet folder's internal ID:
-
Set the Show Internal IDs preference.
For more information, see Setting the Show Internal IDs Preference.
-
Go to Documents > Files > File Cabinet.
-
Find the folder to which you want to save the generated files.
-
Verify the folder's internal ID on the Internal ID column.
Take note of the ID to enter it in the Generated File Folder ID field.
When you enter an internal ID in this field, the Generated File Folder field displays the name of the folder that matches the ID you entered.
If you do not select a folder, NetSuite saves bank slips in the User Documents folder (ID -20).
-
-
In the Line Break field, select the characters that indicate the end of a line and the start of another in the generated files.
-
In the Version of the File Generation API field, select the version of the LATAM File Builder's API with which you want to generate the files.
-
If you generate or import files with up to a thousand rows, select Version 1.
-
If you generate or import files with larger amounts of data and millions of rows, select Version 2.
If you do not select an API version, NetSuite uses version 1 by default.
-
-
Click Save.