Results 1 to 4 of 4

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,288

    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
    275
    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,288
    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

  4. #4
    New Member Olavo Henrique Dias's Avatar
    Join Date
    Nov 2004
    Location
    Brigham City, UT, USA
    Posts
    34
    I agree with David Robertson. Create a custom UBE and read/parse the CSV file.
    I would use the B76B0220 to fetch the line from the text file, parse it, and perform the necessary inserts on the table.

    The little piece of extra advice I would give you is to use Buffered Inserts. This speeds up a little bit the insert process.
    If you are not familiar with the Buffered Inserts, you have to first Open the table using F41061.Open and, on the Advanced Options, you have an option to enable buffered inserts. You need to call the Flush to finalize it before you close the table.
    Regards,

    Olavo Henrique Dias
    JDE Distribution Consultant / Senior Developer
    olavodias@gmail.com

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 and, or Oracle.