Skip to main content
Question

External Files

  • January 18, 2023
  • 5 replies
  • 122 views

Forum|alt.badge.img+2

Hello there, within external file template what can be done in such a way that the respective records are generated line by line, for example

 

 

This gives me  an output of repetitive records like - 

 

 

But I need the records to be printed as ST,BPR,ST,BPR,ST,BPR...

5 replies

Link
Superhero (Customer)
Forum|alt.badge.img+23
  • Superhero (Customer)
  • 1265 replies
  • January 25, 2023

Hi @Bhanu Prakash 

do you want import or export a file?

Can you provide a screenshot of the general tab of your template?


Forum|alt.badge.img+2
  • Author
  • Do Gooder
  • 5 replies
  • February 6, 2023

Hello there, I am trying to export a file and the picture of the general tab of my template - 

 


Link
Superhero (Customer)
Forum|alt.badge.img+23
  • Superhero (Customer)
  • 1265 replies
  • February 6, 2023

Hi @Bhanu Prakash 

your Separator ID is a * (Star).

Therefore you have something like this ST*820 etc.

Replace this with a , (comma) and try it again.


Forum|alt.badge.img+2
  • Author
  • Do Gooder
  • 5 replies
  • February 6, 2023

When the Separator ID is set as a comma the output is -

We are using parameters at the end window of exporting the file which are - 

 

The output needs to be in an ordered way which is 

 

ST

BPR

ST

BPR…

 

But when a parameter is entered an extra record is being created as well, any help would be appreciated.


Link
Superhero (Customer)
Forum|alt.badge.img+23
  • Superhero (Customer)
  • 1265 replies
  • February 6, 2023

Hi @Bhanu Prakash 

so you need only to export the first column , right?

On the first screenshot (external file tempalte) go there to the tab “Detail” and remove all columns you don’t need. Make a copy of your template at first then do it.