Skip to main content
Question

External Files

  • January 18, 2023
  • 5 replies
  • 113 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)
  • 1227 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)
  • 1227 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)
  • 1227 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. 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings