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.

Evner: .NET, C# Programmering, Microsoft SQL Server, PHP, SQL

Se mere: 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

Om arbejdsgiveren:
( 0 bedømmelser ) Vladivostok, Russian Federation

Projekt ID: #19790013

26 freelancere byder i gennemsnit $589 på dette 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 Flere

$750 USD in 7 dage
(278 bedømmelser)

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 dage
(212 bedømmelser)

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

$750 USD in 14 dage
(39 bedømmelser)

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 Flere

$450 USD in 7 dage
(92 bedømmelser)

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 Flere

$600 USD in 10 dage
(160 bedømmelser)

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 Flere

$250 USD in 15 dage
(158 bedømmelser)

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, Flere

$700 USD in 10 dage
(44 bedømmelser)

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 Flere

$500 USD in 7 dage
(43 bedømmelser)

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 Flere

$500 USD in 11 dage
(3 bedømmelser)

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 Flere

$555 USD in 10 dage
(13 bedømmelser)

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 Flere

$500 USD in 10 dage
(6 bedømmelser)

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 dage
(11 bedømmelser)

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 Flere

$600 USD in 10 dage
(8 bedømmelser)

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 Flere

$555 USD in 3 dage
(11 bedømmelser)

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 Flere

$666 USD in 10 dage
(5 bedømmelser)

***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 Flere

$500 USD in 7 dage
(2 bedømmelser)

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 Flere

$450 USD in 15 dage
(4 bedømmelser)

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 Flere

$712 USD in 7 dage
(0 bedømmelser)

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 Flere

$500 USD in 7 dage
(0 bedømmelser)

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 Flere

$500 USD in 7 dage
(0 bedømmelser)