Skip to main content
Question

Export data to Excel on 23R2

C
Sidekick (Partner)
Forum|alt.badge.img+9

Hi,

We try to export financial data  to Excel file (gen_led_voucher_row).

We have about 2 millions lines. is there a limit ?

customer infrastructure is on premise.

Regards, Christophe

ARCWIDE FRANCE / IFS Project Manager

3 replies

Marcel.Ausan
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Marcel.Ausan
  • Ultimate Hero (Partner)
  • 1145 replies
  • March 25, 2024

@Christophe BUSSI I think you will hit a Microsoft limitation when trying to export 2 million rows from IFS. Currently the limit in an Excel spreadsheet is 1,048,576 rows.

Excel specifications and limits - Microsoft Support

https://www.linkedin.com/in/marcelausan/
matt.watters
C
2 people like this
  • matt.watters
    matt.watters
  • C
    Christophe BUSSI
K
Hero (Partner)
Forum|alt.badge.img+10
  • kvbe
  • Hero (Partner)
  • 190 replies
  • March 25, 2024

@Marcel.Ausan  only way is to export to CSV using a datamigration job or external file assistant

C
1 person likes this
  • C
    Christophe BUSSI
C
Sidekick (Partner)
Forum|alt.badge.img+9

We use this functionnality and after 10 minutes we have a time out.

 

ARCWIDE FRANCE / IFS Project Manager

Reply


Terms & ConditionsCookie settings

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