Build a report for a dashboard which takes each account and gives the last 6 month sales history. Right now we don't enter sales data in SalesForce. This is in our proprietary web based system. We input our unique account number in sales force, so this number could be used to grab sales data from our system.
What would be the best way to push our sales data into some custom data types (whatever those types are), so I can create a datasource on the custom data types to pull 6 months worth of data? Figure the custom data type would contain (account number, sales date (Y-m-d), and sales amount).
Any help here would be grately appreciated.
Hi,
You may upload your data using Dataloader application (http://wiki.developerforce.com/page/Data_Loader), as long as you can export your data to a CSV file.
Regards,
Jesús Arcas.
Nice, so all I have to do is import some custom data feed, create a data source using the feed and bing bango I've got a report.
You could use https://workbench.developerforce.com to load data .
FYI ,Workbench is a salesforce site,which takes your salesforce UserName and Password and redirects you to your org.
You can query data ther like a SQL Server.\
Not only that,you can Edit,Delete,Insert ,Bulk Insert,Bulk Delete,Import ,Export everything from there .
Its basically a DataLoader with improved funtionalities like you dont have to Dowload any agent.You can query there which you cant do in data loader and it can be opened as a webpage .