data extract - ad hoc

Question

I am working on a data import project where I need the unique ids associated to various tables.  I was able to obtain the ids for a few tables that  knew about, but then learned that I was missing one.  This Data Export feature doesn't allow a user to extract data when needed.  You can run it once, then you have to wait or schedule it to run at a later date.  Now I have to wait a whole week to get the data I need.  yikes. Is there another way to obtain this information quickly?  Namely, the pricebook entry ids - I don't seem them available in any reports or lists.

Thomas Hoffman · Accepted Answer

You can use any dataloader tool to typically run exports and quieries - whether that is dataloader (can find in setup menu), Dataloader.io, Jitterbit Dataloader, etc.

Dataloader.io is probably the easiest level of access if you are unfamiliar with all three tools, just go to dataloader.io, select login with Salesforce and validate using your Salesforce credentials. From there, hit new task, export. Type 'entry' in the quick find to find the pricebook entry object, and thens you can add all the fields from the entry, pricebook, and product records and run an export.

You can use any dataloader tool to typically run exports and quieries - whether that is dataloader (can find in setup menu), , Jitterbit Dataloader, etc.

Delsie Dunn · Answer

Perfect!  Thank you for the quick answer!!  I have DataLoader.. am new to the tool - intending to do an import.. and didn't consider the export function of that.. sheesh.

data extract - ad hoc

Data Management

Formation associée

Aide supplémentaire