Find Jobs
Hire Freelancers

C# RETS client

$250-750 USD

Закрито
Опублікований almost 11 years ago

$250-750 USD

Оплачується при отриманні
Looking for a developer to develop a RETS client for in .Net to import data into SQL Server. Imports will be bulk daily therefore the client will need to be developed as a Windows Service. Only bid on this project if you know what a RETS client is and if you have experience working with RETS. Real Estate Transaction Standard (RETS) ## Deliverables This whole project is to support a website I have online that search MLS properties. If we are successful in this project there are multiple other projects ready, the point being I am hoping to develop a long term relationship with good coders.... for this project, there is 1 RETS database that we will be connecting too, it is version 1.7. I prefer that the client you right be done in c# .net and be a windows service project. You should use best practices and setup an xml config file where I can make setting tweaks, for example - setting the db connection string and the time interval for which to download the RETS data and any other information that is relevant. I want something simple, and if you can re-use libraries that is even better - I encourage the use of libRETS and there is .NET documentation available for it. On the database side, we will be using MS SQL Server 2012. You can create all new tables that you need for this project from scratch because the website looks at views to populate its data and I can create those or we can make a seperate project in the future for that link. However, the tables MUST have apporpriate data types for the fields... meaning do not simple choose varchar(max) for all the fields, if the field is a price, it should be numeric, etc... I have a copy of the metadata and that should indicate the data type and length for what to expect. The primary goal of this project is to keep an updated local copy of the RETS database, but when you do your inserts / updates / deletes you must use stored procedures. This could be done with 1 stored procedure or multiple, whatever makes the most sense to keep it simple. The goal is to not have a bunch of logic tied into the Client, rather utilize the client to make the connections and transfer data... there are maybe approx 6 tables of interest and all will operate the same way, they have an ID, they have a record creation date, they have a record last modified date, and lots of other fields of data which varied by table. You will create these tables (with appropriate data field types - again I will send metadata to you to help, I have it in one xls file) and the stored procedures to manipulate the tables. In addition create 2 more tables for internal use: 1 will log errors and 1 will log updates that were made (i.e. table name, id, field changed, old value, new value) the values can be generic varchar -- this is just to create a change log for properties the users are monitoring. The logic of the service should be like this: every X hours, query the RETs server by the "record last modified field" to get every record that was modified since the start of the last query. (we may want to store that date / time in the config file to use for next run ). then for each record returned, run the stored proc which will: insert if its a new ID or update if its an existing ID w/ a newer modified date. during the update, write changes to the internal changes table, if at anytime an error occurs, log it to the internal erros (may be data type mismatch) and keep going when all the records have been processed, run a cleanup stored procedure to delete any records that have been flaged as inactive (i will tell you which field to look at or I will write this stored proc myself and might need your help), this cleanup can also delete data from the internal tables that matches the IDs being [login to view URL] required: C# Programming, Microsoft, MySQL, Script Install, Shell Script, Software Architecture, SQL, Windows Desktop
ID проекту: 4635883

Про проект

16 пропозицій(-ї)
Дистанційний проект
Активність 11 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
16 фрілансерів(-и) готові виконати цю роботу у середньому за $593 USD
Аватарка користувача
Hello, I am an expert .NET programmer with over 15 years of application design and development experience. I have completed dozens of Windows service projects, and have experience with RETS so I believe I am a very good fit for your project. I too am looking to build professional relationships and most of my Freelancer.com work comes from my repeat client. If selected, and once I receive the details on the RETS database, I will be able to deliver an initial version of the program within a few days of bid acceptance. I will then complete the project based on your feedback. Please let me know if you have any questions. I look forward to working with you.
$526 USD за 10 дні(-в)
4,9 (128 відгуки(-ів))
7,2
7,2
Аватарка користувача
Hi, I would like to do this project please.
$555 USD за 3 дні(-в)
5,0 (181 відгуки(-ів))
6,2
6,2
Аватарка користувача
Hi, I (Myself a senior ASP.NET programmer using C# and VB) have a team having experience of more than 5 years in developing web and mobile applications. I have a team of expert programmers who write robust and bug-free codes at the very first instance. After seeing our quality of work and the cooperation offered to you even after the work has been delivered to you, you'll come to us again and again to avail our services. I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I can achieve the results that you are asking for within your timeframe and budget. I am confident I can exceed your expectations and I would love to work on your project. Thanks, Murtaza
$750 USD за 12 дні(-в)
5,0 (9 відгуки(-ів))
4,4
4,4
Аватарка користувача
Hi, I am an experienced C#,C++ programmer. I like to do this job. Please look at your PMB for details.
$555 USD за 15 дні(-в)
4,9 (14 відгуки(-ів))
4,4
4,4
Аватарка користувача
Freelancer Professional, I have 8 years experience in programming with c, c + +, C #, Java, J2SE, J2ME, J2EE, Matlab, ASM, python, AutoLISP, Java Script, aspx, php, html5, css3, ajax, jquery, MVC , NET, WCF, Win32, MFC, STL, ATL, MSSQL, MySQL, Silverlight.
$721 USD за 4 дні(-в)
4,8 (8 відгуки(-ів))
3,9
3,9
Аватарка користувача
I can do it
$900 USD за 30 дні(-в)
5,0 (13 відгуки(-ів))
3,7
3,7
Аватарка користувача
Please see PMB, Thanks.
$500 USD за 7 дні(-в)
5,0 (1 відгук)
1,7
1,7
Аватарка користувача
Hello, after reading though your description I got interested in working on your project. I can guarantee extraordinary and quality result in a short time.
$555 USD за 3 дні(-в)
5,0 (1 відгук)
1,0
1,0
Аватарка користувача
Plz check your PMB for details
$666 USD за 20 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
i am interested having 5year of mobile and web development experience
$666 USD за 30 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
I will do it for free for exchange of user review as i want to take my profile to the next level. I have made many applications that i can you show as a portfolio of my work last application i made was an mass mailing applications in C# .NET
$555 USD за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
Hello! We're interested in taking up your project. Please PM us and we'll discuss the details. Thank you!
$688 USD за 8 дні(-в)
0,0 (1 відгук)
0,0
0,0
Аватарка користувача
Will get the job done fast.
$400 USD за 7 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
I have built many windows services for similar tasks .. Not Rets I am bidding low to secure the work and build a relationship with the idea of ongoing work. Consider it a trial run
$333 USD за 10 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
Hi, I can help you with this project: C# programmer & experience in working with PHP/PHRETS, CARETS (California), MRED (Illinois). Regards. Gerard
$555 USD за 15 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0

Про клієнта

Прапор UNITED STATES
North Wales, United States
5,0
1
На сайті з черв. 18, 2013

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.