File Layout Order

One problem with the file layout editor in Application Designer is that you cannot see the fields in order in which they appear in the file. For XML files, this does not matter, but for CSV files or flat files, the order is very important, especially in troubleshooting.

Here is some SQL that will show you the fields in the correct order (Just replace the <File Layout Here>):

WHERE FLDDEFNNAME = '<File Layout Name>'

2 Responses to “File Layout Order”

  1. anilreddy Says:

    how to import excel files in to peoplesoft

  2. digitaleagle Says:

    PeopleSoft has a tool called Excel To CI, which allows you to load data from an Excel spreadsheet into a PeopleSoft Component Interface. You can read more about it in PeopleBooks:

    Another option is using CSV files. In Excel, you can save your spreadsheet as a CSV file with the Save As option. Then, File Layouts have a CSV file type option. Open the properties for a file layout to change it to a CSV file type.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: