Results 1 to 3 of 3

Thread: Importing 159000 F41061 records into E1, every months

  1. #1
    Senior Member johndanter's Avatar
    Join Date
    Sep 2003
    Location
    Cork, Ireland
    Posts
    1,231

    Importing 159000 F41061 records into E1, every months

    Hi folks,

    I've been tasked with coming up with a way of allowing users to import over 159000 Supplier Price records into E1 F41061

    We all know APPLs only allow 1000 unless you amend the INI but this is a lot bigger than 1K

    Options I've come up with

    Excel file dropped and then the call a TC UBE (I haven't used these in an age!)
    Generate XML data somehow and use R98403XB

    Are there any others I could consider? EBI and a table population etc

    Thanks

    John
    John Danter
    You don't go out looking for a job dressed like that do you, on a weekday?

    E900 TR 9.1.5.3 Unix

  2. #2
    Member David Robertson's Avatar
    Join Date
    Nov 2000
    Location
    UK
    Posts
    266
    We'd probably do it as a CSV dropped into a specific location, and a custom UBE.
    In theory, a TC UBE would save you some work with reading the CSV, but in practice, it ends up easier to read it in and parse it manually as otherwise I always end up with something not doing quite what you want.

    Developer / CNC
    E9.1 TR 9.1.4.6 AS/400
    WebSphere 8.5.0.2 AS/400
    DB2 AS/400

  3. #3
    Senior Member johndanter's Avatar
    Join Date
    Sep 2003
    Location
    Cork, Ireland
    Posts
    1,231
    Cheers Dave

    Do mean a normal UBE using this B76B0220.FetchNextLineFromFlatFile and B98220D.ParseString for example to read the file and split it out yourself?
    John Danter
    You don't go out looking for a job dressed like that do you, on a weekday?

    E900 TR 9.1.5.3 Unix

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company, Oracle or Peoplesoft.