Question

FSM-T Table Editor

  • 5 August 2020
  • 3 replies
  • 334 views

Userlevel 5
Badge +9

How we can use T-table editor in FSM. Whats the use of it in general?any document for this.

There is no help document for this also please guide.


3 replies

Userlevel 6
Badge +20

Hi,

 

T-tables are used to import bulk data from external database to FSM. To import through T-tables your person record’s role must have the function “IMPORTEXPORTTTABLE”. Any table in FSM have related T-table starting with “T_”.Once data copied to T-table, we can see it from T-table editor. Once you select any table there is a column called Transaction type, you can enter the action you want to perform as ‘A- add new, U- update, X- Update exist or add new, D- delete’. If there are any errors, you can observe them under column ‘Interface errors’. 

 

Kind Regards,

Kalpani

Userlevel 6
Badge +13

Hi @PinmayaK ,

In addition to the above comment, you can also search for the ‘Reference Guide’ document in the smart client and get some more information regarding the T-Table Editor.

 

Best Regards,

Shageesha 

Userlevel 5
Badge +8

Hi,

Please refer the attached document here. You can find the information which are related to the T-table.

 

Thanks & Best regards,

Randika

Reply