Skip to main content
Question

Migration Job Output File with Line break

  • February 12, 2025
  • 5 replies
  • 62 views

Forum|alt.badge.img+2
  • Do Gooder (Customer)
  • 3 replies

Hi,

Is it possible to create multiple lines in the output files.

 

 

The csv file gets like this.

 

I want it to be like this

 

I was referring to other community posts. But did not manage to get it correct

5 replies

Jens
Hero (Employee)
Forum|alt.badge.img+10
  • Hero (Employee)
  • 123 replies
  • February 12, 2025

Hi ​@GDISNO 

are you using a group by (tab Formatting) in your CREATE_OUTPUT_FILE migration job?

Can you create a screenshot of the tab Formatting please because I would like to see the source name (I assume it’s currency_rate) and the different settings?

/Jens


Forum|alt.badge.img+2
  • Author
  • Do Gooder (Customer)
  • 3 replies
  • February 12, 2025

Yes,

 

 


Jens
Hero (Employee)
Forum|alt.badge.img+10
  • Hero (Employee)
  • 123 replies
  • February 12, 2025

Hi ​@GDISNO 

If you change the File Location to OnClient and execute the migration job again what will you see in the tab Detail of the Execute Job window?

Can you provide a screenshot please?

And can you also provide an export of this migration job please (you can use the migration job FNDMIG_EXPORT for that purpose which needs to be adjusted based on your migration job id = intface_name)?

/Jens


Forum|alt.badge.img+2
  • Author
  • Do Gooder (Customer)
  • 3 replies
  • February 13, 2025

I see it like this.

 


Jens
Hero (Employee)
Forum|alt.badge.img+10
  • Hero (Employee)
  • 123 replies
  • February 13, 2025

Ok, this seems to be correct.

So please make a cleanup on the Detail screen in the Execute window, change the File Location in the migration job back to “OnServer” and also add a character set, e.g. UTF8 or WE8ISO8859P1.

After that execute the migration job again please.

And possibly you need to activate/show the line break in your editor or use a different editor, e.g. notepad++, and then we can see if the CR / LF is really missing.

/Jens


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