You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

BULK Insert - Best practice?

Received Response
19
Views
1
Comments
edited Jan 16, 2019 12:04PM in Customer Portal 1 comment

Content

Hi,

We are looking at automating uploads into custom objects. To expand on that slightly:

  1. Every X hours, we have Y CSV files produced into folder Z.
  2. The files are overwritten each time.
  3. We currently have an automated system in place that takes the CSV files and uses the data import wizard to upload the data
  4. Each file is uploaded (added where needed, otherwise update a current one)

*HOWEVER*

Going forward this isn't workable as the automated process (let's call it a robot) isn't flexible enough for this type of work.

My question is other than using the data import wizard, what are the best practices for uploading each file into its own custom object, adding if it doesn't exist already or updating where it does? Each file will contain over 10k rows

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!