Hey Tam sorry that I did not respond to your thread, I have been in training all week and have been unable to reply to threads. If you use the data loader to import your cases, whether new or old, You can do it via the data loader.
Are you using PHP to do any of your data syncs from internal systems to your salesforce instance? If so, it is easy to setup, you can create a local data schema if you are using either Oracle or MySQL to Salesforce and then either update or insert new cases whenever you like. It is easy to setup and I would be willing to help you if you need it.
The great thing about PHP and other open source software is that it is free and reliable. All of our scripts that update our parts, pricebookentries, accounts, contacts, and custom objects are done in PHP (which I have written) and they run on CRON jobs (Jobs in Linux that you can set to run anytime you wish). An example of this would be:
We run our account update process each week, every monday at 3:00 AM to sync the Account Object with all our local legacy system. These set of scripts have been running in production over a year and have never failed at all
Anyway I hope that helps and again I am sorry for the delay in responding to this
~Mike
|