Adding Custom Field in External File Template

Hi @andrei.borromeo,

May I know the Track of the IFS Application which you are using?

A bug fix has been created by RnD in IFSAPP08(bug fix - 110506) for the below issue.

Symptom:
Issue when data is loaded to custom LU

Test Plan:

1)Create a Custom LU and add a few attributes and a Custom Page
2)Go to the Custom Page and add some data
3)Create File Type and File Template (for both input and output)
  =>Here when selecting the view select the base view of the Custom LU under component CUSOBJ
4)Create an input file to add a new record to the LU
5)Import through External File Assistant
  =>"There is no valid check method in package XXXXX_CLP" error appears

Solution:
It should be possible to Input/output data after adding the custom LU without any issue

If you believe that the above issue is similar to your issue, you may report a case to IFS Support to request the bug fix.

Hope this information would help you 

Best Regards,
Thanushi

Hello Thanushi, thank you for your reply

I had to forward your reply to our IT person and this is his reply:

We are running Apps 9 UPD 13. We are not trying to do an external load to a Custom LU. We are trying to do an external load to a system defined LU with custom fields mapped. FA_OBJECT Import is working and now we are trying to import to FA_OBJECT_CFV.

Does this answer your initial question?

Hi @andrei.borromeo,

Thank you for taking time to answer my query. 
I am not very on how to solve this,but I will look into this a bit more and get back to you 

Best Regards,
Thanushi 

HI Andrei.borromeo

Currently, external file templates created using view definitions only support insert/update rows into a single table.

Yet In custom fields implementation, there are two tables involved. RowKey is inserted into the main table and the actual value of the custom field is saved to custom field table and they are referenced through the rowkey column.

If we import an external file with a custom field, same logic should follow. Data related to the original table should be inserted to the primary table (Table of the particular LU) and the custom field value should be inserted to the custom field table and they should be referenced through the rowkey column.

Since There are different types of custom fields (read-only, persistent, reference, expression) supported by the custom objects framework and they have different implementations. I’m afraid, current business requirement is not supported in the Application.