Results 1 to 2 of 2

Thread: How to modify the existing data in E1 with a bold data upload?

  1. #1

    Post How to modify the existing data in E1 with a bold data upload?

    Hi,

    Can anyone help me with this problem?

    I'm trying to upload new data into E1 but at the same time, I want to modify the existing data. For example, an account needs to be assigned with a new sale rep and expired the old one. I know how to do a bold upload but do not know how to change the existing data with a bold upload...

    Please help!

  2. #2
    So lets say you are doing this via an application (now in an application depending on your jas settings , gird rows to load , how many columns you have have how many rows you have ) may have some issue and overhead on jas and html servers when you do this upload via interactive application , you can have a grid , have business view , import to grid , once you press ok , grid will events like "Add rec to D before " Add rec to DB after " . In the evnt add rec to DB after , write custom code to fetch all rows which are not updated by current audit fields (the ones you added will have audit fields of today ) ,so fetch which are not , get them , write a while loop and fetch update them back or expire them . This shud take care of your new records add , as well as old records expire .

    Hope this helps .

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.