Results 1 to 4 of 4

Thread: Import different sheets of single CSV file in to different E1 Tables

  1. #1
    New Member
    Join Date
    Jun 2008
    Posts
    2

    Question Import different sheets of single CSV file in to different E1 Tables

    Hello,

    I need your assistance on the requirements as "To import a single input CSV file which has three sheets to the three different custom JDE Tables" .
    Do we have any options in UBE to import different sheets of a single CSV to the three different E1 tables at a time.

    Appreciate your valuable inputs.

    JDE Application :E900
    Tools :9.1.5.3

    Regards,
    Joshua

  2. #2
    Senior Member Larry_Jones's Avatar
    Join Date
    Nov 2000
    Location
    Spokane, WA, USA
    Posts
    3,200
    Unless I'm quite mistaken CSV files don't have "sheets". A CSV file is just a text file with a .CSV extension that has comma separated values.
    Your requestor probably doesn't realize this.
    Larry Jones
    E1 9.2 - TR 9.2.2.6 on Win 2016 R2. SQL Server 2016
    Wintel, BI Publisher

  3. #3
    New Member
    Join Date
    Jun 2008
    Posts
    2
    Thank you Larry for your reply.

    I am sorry. It is a Microsoft Excel document with three sheets which needs to be imported to E1 Custom tables.

    Thanks in advance for your assistance.

    Regards,
    Joshua

  4. #4
    Senior Member johndanter's Avatar
    Join Date
    Sep 2003
    Location
    Cork, Ireland
    Posts
    1,338
    If you spread those sheets out into single files, you have many options open to you. Does your data need to be in one file?

    I am not sure if Dropzone made by Stelitx can do multiple sheets, but it's designed to take an excel file and suck data into forms via 'magic' (AIS) Works really good.
    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 and, or Oracle.