Hi Experts,
There is a requirement to automate the process to upload the data from external DB(SAP) into IFS FSM DB.
I know that we can use folder listener to achieve this requirement.
Is there a better way to achieve this than folder listener option?
Thanks,
Hasara
Best answer by thilinaweliwita
Hi
I think T-Tables will be a better option in this case. T-tables can be used in order to import data from a table on an outside system to FSM.
Any table in FSM has related T-table starting with “T_”. The data from the external table has to be copied to the relevant t-table.
Once data copied to T-table, it can be seen from the T-table editor.
Next, the entries in the T-table can be added to the actual table by using import functionality (perform_import_from_t_table). You might be able to create a scheduled process to import from t-table.
You can refer to below post for more details.
https://community.ifs.com/troubleshooting-310/how-is-the-t-table-editor-used-3292
+24Hi
It would entirely depend on what is being copied, how closely it matches FSM table structure, how often change would be sent and the size of each upload.
Kind regards,
Lee Pinchbeck
Hi
I think T-Tables will be a better option in this case. T-tables can be used in order to import data from a table on an outside system to FSM.
Any table in FSM has related T-table starting with “T_”. The data from the external table has to be copied to the relevant t-table.
Once data copied to T-table, it can be seen from the T-table editor.
Next, the entries in the T-table can be added to the actual table by using import functionality (perform_import_from_t_table). You might be able to create a scheduled process to import from t-table.
You can refer to below post for more details.
https://community.ifs.com/troubleshooting-310/how-is-the-t-table-editor-used-3292
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
