Results 1 to 4 of 4

Thread: Importing csv data into custom table in jde

  1. #1

    Importing csv data into custom table in jde

    HI everyone ,

    I just had my training on jde, and as i am still fresh i need some help. I have a custom table , based on F4141 . The whole point is , i am supposed to receive a csv file , check the quantity , and if it's different than the original that was stored on the F4141 , to update the custom table . I am stuck , at the very begging. I don't know how to retrieve column data from a csv file ...If anyone can help i would appreciate it , i am kind of stuck ... i figured out what to do next , but no idea on how to begin with ..

    Thanks in advance ,
    NF

  2. #2
    Senior Member
    Join Date
    Mar 2004
    Location
    Fort Worth, Texas
    Posts
    1,529
    The only "out of the box" tool in JDE (that I know of) to parse a CSV file is a table conversion (TC) UBE, so you should probably start there. I would assume that TCs were covered in you training.
    Brian Oster
    Application Development Manager
    E1: 9.0 (TR9.1.5.1) / 9.2 (TR9.2.2.2)
    JAS/BSSV: Weblogic 12.1.2 / Weblogic 12.2
    ES: Win2008 / Win2016
    DB: MSSQL 2014 / 2016
    WebDev Client: Win7Pro / Win10Pro

  3. #3
    New Member
    Join Date
    Sep 2002
    Posts
    29
    Flat file Import to custom table. Then custom UBE to process your custom table into your F4141, as per Z file processing or EDI F47's
    ERP8 SP22, ERP8.9, AS/400, SQL2K, ORACLE, UDB

  4. #4
    Senior Member johndanter's Avatar
    Join Date
    Sep 2003
    Location
    Cork, Ireland
    Posts
    1,346
    Depending on how many rows are on your table you could use a headerless detail and place the logic in the Update / Add grid row events when a user clicks OK/Save

    Or you could use some of the handy BSFNs in E1 to read the external CSV yourself and parse the fields out, but this way is long winded and your UBe needs access to the file address folder.

    Example
    Function Name:; FetchNextLineFromFlatFile
    Souce Module: B76B0220
    Description: Fetch Next Line from Flat File

    00001 -FetchNextLineFromFlatFile(B76B0220.FetchNextLineFr omFlatFile)
    FC Path_PTH [PTH] -> szFlatFileName [PTH]
    VA frm_GenericLongFilePtr_GENLNG [GENLNG] <> idFilePtr [GENLNG]
    FC Record for A/P Bank Tape - EnterpriseOne [APTA] <- szFlatFileRecord [APTA]
    "1500" -> mnRecordLength [RECL]
    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)

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.