function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Excel connector for Opportunity upload

Anybody using excel connector for opportunity uploads?
Yep - as we speak....
Ron HessRon Hess
I use it also, but I would like to recomend also the java based data loader as it may yeild a higher performance on large loads and it supports the 7.0 API features, the connector is currently tested only to the 6.0 API level.


Before I try using excel connector I was wondering if I could upload oppty's without stage or probability(it is required field)?  Since it is required can I use a generic stage & %  to get around the req field?        

Ron HessRon Hess
yes, you can pump in bogus or generic data to a required field, but you end up cleaning it later... :smileysad:

Because the API doesn't enforce most required fields, you can upload the records with the unknown information blank (or not set). 

The first time that someone tries to update the records through the UI, however, they'll be forced to update any required fields before saving the record.