Skip to main content
Question

Importing large Excel data to IFS

  • October 29, 2024
  • 2 replies
  • 84 views

Forum|alt.badge.img+5

Hello,

One of our customers is seeking a solution for handling large Excel files, which they currently enter manually into IFS Apps10 environment. They need a solution capable of processing up to 2 million records in a single upload. Could you suggest any available solutions?

2 replies

Forum|alt.badge.img+23
  • Superhero (Customer)
  • 1169 replies
  • October 29, 2024

Hi @himasha.abeywickrama 

did you test the simple migration tool?

What kind of records do they want to import to IFS?


Marcel.Ausan
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • 1142 replies
  • October 29, 2024

@himasha.abeywickrama Excel worksheet is limited to a little bit over 1 million rows (1,048,576 rows to be precise).

Normally as @Link mentioned, you can have a migration job (fndmig) created that would take that data and load it in IFS. With mig job you can import a csv file for even 2 million rows, but the file size would be big and it would require quite a bit of processing time. I’m also curious what kind of dataset your customer wants to import in IFS that’s so large.


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