Application Engine (AE) uses File Layout to Import the date from CSV file

Application Engine (AE) uses File Layout to Import the date from CSV file

Step #1 : Create Stage Record Field

File > New Select Field

Choose Field Type to Number

Enter Field Labels

Save the Field  - EMU_PROD_NO

Press F7 to insert the Field into Project workspace – Development  

As similarly create one more field EMU_PROC_DESC as Filed Type Charater  and Save the Field as EMU_PROC_DESC

Press F7 to insert the Field into Project workspace – Development  

Step 2 : Create a Stage Record

File > New  Select Record

Menu > Insert > Field  - Search by Field Name and Click the Insert Button to insert the fields into your record

Click Record Type  - SQL Table

From Menu > build > Current Definition – To build the Record

Note : Choose the table space if you create the table at first time

Step # 3 : Create a File Layout

Select File Layout from File > New

From menu > Insert > Record which we recently created

Step # 4 : Create a CVS File to import your data into a SQL table ( EMU_PROD)

Step #5 :  Go back to your File Layout Property – Choose Type CSV

Preview Tab  Provide the Default File Name and Preview

Save the File Layout

Press F7 to include File Layout into your Project  WorkSpace

Step # 6 : Create an Application Engine

File > New > Choose App Engine Program

Choose  Auto Commit After Step Check Box

Right click and insert Action

Choose Action Type to PeopleCode

Save Application Engine – EMU_PROD_IMP and press F7 to insert AE to your project workspace

Double Click the PeopleCode Action to open the code window

From a Project window , click the File Layout (EMU_FILE_LAYOUT ) drag to your code window  then entire code logic will be created by default for you.

Verify your CSV file location is correct from the generated code.

Save the AE

From Tool bar  Press Run Program button

Choose the log option and click OK

In the system task bar you can see the below AE running icon

Now go to the log file location and verify the log file – It should ended normally

Step # 7 : Verify the Data in the back end

Note : Problem is data get inserted with CSV file column header to avoid please remove the column header on your CV file.