Question

Export data to Excel on 23R2

  • 25 March 2024
  • 3 replies
  • 40 views
C
Rank
Userlevel 3
Badge +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
Rank
Userlevel 6
Badge +15

@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/
K
Rank
Userlevel 4
Badge +9

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

C
Rank
Userlevel 3
Badge +9

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

 

ARCWIDE FRANCE / IFS Project Manager

Reply


Terms & ConditionsCookie settings