Skip to main content
amritjyotiv3475
March 30, 2022
Question

Need to use "Text Doc From Template Smart Service" for exporting more than 300 columns data from a table. Can anyone help me out how to configure this smart service and use it in PM?

  • March 30, 2022
  • 3 replies
  • 0 views

Need to use "Text Doc From Template Smart Service" for exporting more than 300 columns data from a table. Can anyone help me out how to configure this smart service and use it in PM which will give data in csv format or excel format.

3 replies

gopalk2865
Participating Frequently
March 30, 2022

Hi Amrit, Is there any specific reason you are using this smart service ? becasue  using this smart service for data export, i dont think a good idea. can you tell us about your requirement little more?

amritjyotiv3475
March 30, 2022

Export Database to csv is having limitation of 50 columns for export that's why I want to use this smart service "Text Doc From Template" because we have requirement to export more than 300 columns.

gopalk2865
Participating Frequently
March 30, 2022

Its not feasible to use this smart service  for data export, instead you can use export data store entity excel smart service and run this node in loop and export first 50 columns and then next 50 and so on . once loop ends you can merge these generated excel files.