Sync contact info from cloud based CRM website using their API to our local POS software SQL DB

We need to connect our web based CRM software with our local SQL database using. We would like contacts synced between the 2. Here is the URL for the CRM software API: (link removed) The SQL database lives on our local server.

I like the idea of a tray application with a simple UI. The local database does already exist. I could provide an offline copy of it for you to use as a reference. We would only want the sync to happen one way, from ActivCampaign to our local SQL database. I would say have the sync happen automatically once a day with the option of syncing using the utility in the tray. Currently, anyone that is in ActivCampaign has already been entered into the local database manually. They want a continuous sync so if fields are changed in ActivCampaign, they would be updated in the local database, but only if they've been changed in ActivCampaign. As for the fields, the local database has a field for gender, but in ActivCampaign, they enter the gender as a "tag", which is a catchall. If this can be synced somehow, then great, but not worried if it can't be. In the local database, first and last name are separate fields, but they are together as one field in ActivCampaign. Spouse/Partner is linked to another customer within our local database but in ActivCampaign, it's just a field, there is no linking. Client number fields are the same on both. Birthday and Anniversary fields are the same on both. Date Entered field is the same on both. Addresses, phone numbers, type's of contact methods, etc. will have to be synced and be figured out. We are concerned about users entering new information in the local SQL database and then it getting auto written over during the sync. We need some options to prevent this. We also need a name parser.

Skills: .NET, C# Programming, Microsoft SQL Server, PHP, SQL

See more: act crm, zoho crm, free customer database software for small business, hubspot crm, crm software examples, crm software free, crm comparison, best crm, free flash contact form website using asp, using contact form hack simple easy website, website owner contact info, website form contact info image upload, code capture contact info website, collect website contact info, extract contact info website, extract contact info website excel, using crm website, cloud based website development, cloud based crm pos, copy contact info website

About the Employer:
( 0 reviews ) Vladivostok, Russian Federation

Project ID: #19790013

26 freelancers are bidding on average $589 for this job


Hi, Is the active campaign database is also sql server? We can implement inbuild sql server replication to solve this problem, which allows one way sync. I have 10+ year exp. in mvc c# web development and de More

$750 USD in 7 days
(278 Reviews)

Hello, I'm Abu Gosia. I'm interesting in your project very well. I m quite well experienced in these jobs. Let's go ahead with me. Thanks

$444 USD in 15 days
(212 Reviews)

Добрый день, у меня было несколько проектов связанных с синхронизацией между базами данных. В первую очередь можно попробовать "родные" средства: репликация, SQL Data Sync и т.п. если это не подойдет по каким-то причин More

$750 USD in 14 days
(39 Reviews)

hi. I have 6+ years of experience in C#. I have worked with ActiveCampaign API already, for syncing contacts. I have built similar applications for syncing data between API and Database. here are a couple of my past p More

$450 USD in 7 days
(92 Reviews)

Hi there, I am interested in the project. I have expertise in system integration solution development and I am sure I can provide you the best service you are looking for. The solution could be developed as an windows More

$600 USD in 10 days
(160 Reviews)

Sir, I can give this work with 100% satisfaction within a time limit, and also I have great hands-on HTML, CSS, JS, jQuery, PHP, Laravel, MySQL. Very familiar with WordPress, Magneto, woo-commerce, Bootstrap, Plugin More

$250 USD in 15 days
(158 Reviews)

Hi, i can do this using .net c# scheduler application sysc data to local sql db. you can scheduler the sysc or manually. so it will easy to use. I have more than 15 years experience in C#, MVC, ASP.NET, VB.NET, ASP, More

$700 USD in 10 days
(44 Reviews)

I am 9+ years experienced Senior Software Engineer with team of additional 4 experienced developers working under my guidance having excellent skills in web apps development along with desktop apps and mobile apps deve More

$500 USD in 7 days
(43 Reviews)

Hi, I have gone through your post and I can definitely provide solution as desired. We have done similar featured modules in various application and thus can provide you a quick & quality solution. Please visit below More

$500 USD in 11 days
(3 Reviews)

Let's just rest a moment.<A gift in season is a double favor to the needy!> Nice to meet You. I have read through your project and I am incredibly interested in taking on your project. I am an experienced developer More

$555 USD in 10 days
(13 Reviews)

hello,how are you.i read your bid carefully. i am POS expert and have full experience for 12 years. java/javafx is my top skill and i can handle your project by using java/javafx. i can provide most quality and high More

$500 USD in 10 days
(6 Reviews)

Expert programmer having great experience working with different parsers and cron jobs. I can complete this task easily. feel free to discuss further to start the project immediately.

$500 USD in 3 days
(11 Reviews)

Hello, How are you? I’ve carefully gone through your job post. I am very much interested in your project with all of your requirements. Also i think i can help you by my skills and my efforts, because i have rich exp More

$600 USD in 10 days
(8 Reviews)

Hi,dear. I've just checked all requirements of your project 'Sync contact info from cloud based CRM website using their API to our local POS software SQL DB'. I'm a senior software developer and I'm able to fulfill you More

$555 USD in 3 days
(11 Reviews)

Hello! Greeting to you After going through your project description, I came to know you are looking for API integration with cloud CRM and POS system. Please find my experience - I have more then 7 years of expe More

$666 USD in 10 days
(5 Reviews)

***EXPERTISE IN C# PRGRAMMING,ASP.NET,MVC,VB.NET AND READY FOR LIVE INTERVIEW*** With over 12 years of producing corporate marketing projects for some of the most innovative companies in world, I’m here to bring your More

$500 USD in 7 days
(2 Reviews)

Hello, Hope you are doing well. I have gone through the project requirement and find my self in good position to complete this project. I have Over 12 years of experience in software development and support. On tec More

$450 USD in 15 days
(4 Reviews)

Greetings, Thanks for the opportunity. Pavnai Info Solution (Expert Web & App Developers) is a dedicated team with over 20 years' experience and a strong workforce of 10+ Professionals. Relevant Skills and Experie More

$712 USD in 7 days
(0 Reviews)

Hello dear How are you? I read your requirement carefully I am very interested in your post project. I am sure i can give you great result. I have rich experience on it. so please discuss more detail via chat. loo More

$500 USD in 7 days
(0 Reviews)

Hello, Greetings from Lexx Digital!! We are a team of developers who have a built our own custom POS software for retail and for the Bar and restaurants. We have made it after an extensive R&D and also have seen what More

$500 USD in 7 days
(0 Reviews)