Results 1 to 6 of 6

Thread: Import into JDE Table via XML instead of CSV

  1. #1
    New Member
    Join Date
    Mar 2014
    Location
    South Africa
    Posts
    4

    Question Import into JDE Table via XML instead of CSV

    Hi,

    Has anyone been able to load from a XML file into JDE?

    A customer is currently loading a CSV file into JDE, but now need this input file to be XML.

    The XML file sample would contain the following:
    [I]<upload>
    <shipments>
    <shipmentCode>Test2_20180901</shipmentCode>
    <containers>
    <containerNumber>Container1</containerNumber>
    <sealNumbers>Seal1</sealNumbers>
    </containers>
    </shipments>
    </upload>[/
    I]

    Below is a sample of their current CSV source data for importing into JDE.
    Test2_20180901;Container1;Seal1

    Does anyone have any idea what would be the simplest solution to do this?

    Can this be done via ER code, or a Table Conversion.

    Any response will be much appreciated.
    JD Edwards Developer/Engineer
    BI Publisher Developer/Specialist

  2. #2
    Senior Member Alex_Pastuhov's Avatar
    Join Date
    Jul 2001
    Location
    Australia
    Posts
    1,738
    I think R98403XB would be the easiest solution, but it expects a complete table XML and in a specific format. If you can reformat your XML to match what JDE expects, this can be a way forward. It's extremely fast. And this UBE offers some flexibility through its PO's.


    As for importing custom XML, I do not think JDE has ready functionality with sufficient flexibility for this. But of course anything can be developed either inside or outside of JDE to do such things, if there's sufficient desire.

  3. #3
    Member
    Join Date
    Dec 2000
    Location
    Australia
    Posts
    564
    Have a look at this Oracle support document: E1: BSFN: How to Import Data in XML file to JDE Table ? (Doc ID 1674702.1)

    It is not particularly helpful other than listing some existing business functions/UBE's that process XML that you can then study to implement your custom import. They use the Xerces API's that are exposed by the JDE runtime.

    Is this data going through to a Z-File? If so, I would personally try to leverage the database or an integration platform to do the heavy lifting of XML parsing and inserting into the Z-File and then triggering a Z-File load UBE.

    If you need to stick with the JDE tool set then studying the few standard JDE objects that import XML should give you what you need.
    Justin Miller

  4. #4
    Member craig_welton's Avatar
    Join Date
    Oct 2000
    Location
    Litchfield, CT
    Posts
    959
    Without any practical experience, is XSLT a possibility here? From what I understand, it's a way to transform XML into other forms, including another XML document. Since the target XML (JDE format) is static, could this transformation work? (Obviously, it's different for each implementation)

    Craig
    Craig Welton
    PatWel Group Inc.
    http://www.patwel.com
    Home of the FREE JDE Object Browser, JDETrace and NERDup Tools

    E1 9.0 8.98.4.2 Wintel SQL 2008
    E1 9.2 9.2.1.4 iSeries

  5. #5
    Senior Member johndanter's Avatar
    Join Date
    Sep 2003
    Location
    Cork, Ireland
    Posts
    1,321
    XML can be varied, so no BSFN will exist to do exactly as you want, you'd have to use it tandem with other stuff.

    As Alex says, use R98403XA to extract data (from E1) and R98403XB to load it back in. I use it all the time for copying data around and to quickly setup test data

  6. #6
    New Member
    Join Date
    Mar 2014
    Location
    South Africa
    Posts
    4
    Thank you all for your valued responses. Since the XML input file will always be the same elements, I used the B76B0220 BSFN (Fetch Next Line From Fat File), to scrub and retrieve the values on line 3, 5, and 6 in a looping statement.
    JD Edwards Developer/Engineer
    BI Publisher Developer/Specialist

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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.