Skip to main content
Question

FSM-T Table Editor

  • August 5, 2020
  • 3 replies
  • 369 views

PinmayaK
Sidekick (Partner)
Forum|alt.badge.img+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

Kalpani Dissanayake
Superhero (Employee)
Forum|alt.badge.img+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


Forum|alt.badge.img+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 


Randika Costa
Hero (Employee)
Forum|alt.badge.img+8
  • Hero (Employee)
  • August 7, 2020

Hi,

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

 

Thanks & Best regards,

Randika