+ Start a Discussion
Edward chanEdward chan 

Way to directly check Back-end data

Hi,
I know there should be one Back-end place in which the records are stored. Is there one direct way to retrieve the records?


Many Thanks & Best Regards,
Edward Chan

Devendra@SFDCDevendra@SFDC
Hi,

You can export organization data using Salesforce Org.

Navigate to, Your Name--> Setup-->Administration Setup-->Data Management-->Data Export.

Thanks,
Devendra
Edward chanEdward chan
Thanks. Is there one way to interactively work with the back-end data?
Devendra@SFDCDevendra@SFDC
Hi,

What do you mean by interactively work with data? Can you please explain us the business case scenario? It would be helpful.

Thanks,
Devendra
Edward chanEdward chan

The way to work with the back-end data, just like we can do against Sql server/Oracle data schema.

 

And here is what I've got after having tried to export the data.

Monthly Export Service
 
Help for this Page
Data Export lets you prepare a copy of all your data in salesforce.com. From this page you can start the export process manually or schedule it to run automatically. When an export is ready for download you will receive an email containing a link that allows you to download the file(s). The export files are also available on this page for 48 hours, after which time they are deleted.
Information 
Next scheduled export:
A data export is currently in progress for your organization.
  
  Your export has been queued. You will receive an email notification when it is completed.
  
But I still do not receive any mails after half an hour.

Devendra@SFDCDevendra@SFDC
The export process might be in progress. You need to wait for some time. As this export all the object's record from your org.

Do you want to perform/run script on the exported data or schedule some script daily/weekly/monthly etc?

Thanks,
Devendra
Edward chanEdward chan
Yes, something like that.

Is there one direct way to select/update against the back-end data?
Devendra@SFDCDevendra@SFDC

1) You can write a batch class which can operate on existing data and do necessary DML operations.
2) You can use developer console and execute a apex script there itself.

Thanks,
Devendra
Edward chanEdward chan

Thanks. Can I have more details to work with Developer console?

 

And I did not receive anything from Salesforce for few hours already.

Many Thanks & Best Regards,
Edward Chan

Devendra@SFDCDevendra@SFDC
Hi,

Have you scheduled the Data export for particular time?

Here is the link of salesforce doc,
http://login.salesforce.com/help/doc/en/admin_exportdata.htm

Thanks,
Devendra
Edward chanEdward chan

Thanks. I did not schedule anything but I selected to do export and then got the message shown above. And your current url is not reachable.

Edward chanEdward chan

Dear all,
Any help to this?

Edward chanEdward chan
Dear all,
Any help to this?
Devendra@SFDCDevendra@SFDC
Hi,

At the time of Data Export, Are you using a User with System Administrator profile?

Thanks,
Devendra
Edward chanEdward chan
Yes.
Devendra@SFDCDevendra@SFDC
Hi,

I have tried Data Export in my developer org. I have selected couple of objects and I have received the email in few mins.

Steps I have followed,
1) Clicked on Export Now button
2) Selected Few objects to be exported

Are you missing any step?

Thanks,
Devendra

Edward chanEdward chan

Many thanks. It is OK for that. I see one Zip file is availbale there for download and it is with csv files inside as the data.

One other question is, is there any interface/tool for us to directly retrieve data from Developer cloud, per our specific data created in the cloud?

Devendra@SFDCDevendra@SFDC
Hi,

You can use Apex Dataloader : http://wiki.developerforce.com/page/Data_Loader

Also you can try, https://dataloader.io/

Thanks,
Devendra
Edward chanEdward chan
For Dataloader.io, there are functions like

Import
Export
Delete

is it true that we can further choose one specific csv file, which we get from exporting Salesforce data, and then Insert/Delete records per our needs?
Devendra@SFDCDevendra@SFDC
I have not tried with dataloader.io, but I have used Apex Dataloader.

Yes, you can perform DML operation using both.

Thanks,
Devendra

Edward chanEdward chan
Do you have one example to use DML in Apex Dataloader?
Edward_chanEdward_chan

Hi,
after the setup of ApexDataLoader, I try to login using the user name below, but I've got this
http://dl.dropbox.com/u/40211031/t422.png

while using the same user name I can login force.com fine!

Devendra@SFDCDevendra@SFDC
Hi,

Are those credentials for Sandbox or Production/developer Org?

Can you once check the data loader setting?

Navigate to Settings--> Server Host --> https://login.salesforce.com (For Developer and Production Org)

For Sandbox Org you need to change this to https://test.salesforce.com

One more thing, at the time of providing credentials to dataloader, in the password you need to provide password + security token.

Thanks,
Devendra
Edward_chanEdward_chan
Thanks.
Within Data loader, where can I do this?

Navigate to Settings--> Server Host --> https://login.salesforce.com (For Developer and Production Org)
Devendra@SFDCDevendra@SFDC
Hi,

Settings is the menu option (Second Menu Option) in Apex Data Loader.

Thanks,
Devendra
Edward_chanEdward_chan

Hi,
Is it true that "Select" is not available within Dataloader?

 

For instance, for "Update" which I just click below, it does prompt me for csv file, does it mean we need to provide csv files or other format to Dataloader every time for Update/Insert?
http://dl.dropbox.com/u/40211031/t7.png

Devendra@SFDCDevendra@SFDC
Hi,

You need to use Export option to export some data from any object.

For second question, you need to provide a CSV file to perform insert/update operation.

At the time of you should not provide Id of records, as Ids would be created after inserting records.

At the time of Update you need to provide a Id, so that System can understand which records needs to be updated.

Thanks,
Devendra
Edward_chanEdward_chan
Thanks. I have some records inside our DeveloperForce cloud. How can I know the names of the relevant tables for "these" records?
Devendra@SFDCDevendra@SFDC
Hi,

At the time of Export records from dataloader, you can see the list of objects available for export.

There you can select the object for which you want to export data.

I would suggest you to go through the Apex Data Loader documentation. That would really help you.

Thanks,
Devendra
Edward_chanEdward_chan
Is there one pdf file for this? Where is its download?
Data Loader 5Data Loader 5
You can easily retrieve Salesforce data even with atachments using Salesforce data loader (https://skyvia.com/data-integration/salesforce-data-loader) from Skyvia data integration service.