[Wolves] Dbase to SQL sync

[Ron Wellsted]

On Wed, Mar 18, 2009 at 04:08:02PM +0000, dick_turpin wrote:
> Hi All
> 
> Here's an interesting one (Maybe for you Ron?)
> Have a customer who is running ACT6 which uses Dbase they want to sync
> to a CRM on an Interanet which will be SQL based. I suspect the Intranet
> is MS based, for those that don't know, ACT is a CRM that runs on
> Windows only.
> 
> Any of you DB bods got any ideas? I've posted to the ACT group on
> LinkedIN but so far its not been very helpful.
> "You'll have to write something" Duh!
> 
> 
I did this for us when we moved over to SugarCRM.

I exported the DB with ACT! to csv files, then imported to SugarCRM.

This will not pass over notes etc. and you may have to take several
attempts at it in order to get the data in the right places.  You may
also have to split the import into small chunks in order to get over
file upload/memory restrictions e.g. 2,000 - 5,000 records at a time.

The biggest pain is how different dbs hold an address, I still have
records with too many commas in them (& don't get me started on apps
that force USA phone number formats!).

HTH

-- 
Ron Wellsted
ron at wellsted.org.uk http://www.wellsted.org.uk
N 52.567623, W 2.136111 Linux Counter No. 202120
Ekiga: 645022
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 481 bytes
Desc: Digital signature
Url : http://mailman.lug.org.uk/pipermail/wolves/attachments/20090318/8b5c2edc/attachment.pgp