Создать скрипт заполнения базы
Заказчик
[no-member:pro]Энергомаш[/no-member:pro]Энергомаш
Параметры проекта
Вариант сотрудничестваПериодическая занятость
РазделРазработка программ
Предоплатабез предоплат
Способы оплатыБанковский перевод
Приём заявокзавершён
Описание проекта
Описание работы на английском языке, т.к. работу необходимо выполнить для канадской фирмы.
We have a platform that we use to build websites and utilize real estate listing information in other ways. The platform is developed in Windows environment, so our servers are Windows servers and all the software is coded in ASP.
We have central databases that contain real estate listing information and every website connects to them. This listing information comes from external database that each local Real Estate Board has. For example TREB (Toronto Real Estate Board) has all of the listings in GTA and surrounding areas. CREB (Calgary Real Estate Board) has listings for Calgary & Edmonton, and so on. The way we connect to these external databases is through something called RETS standard. There is a lot of documentation online on how to connect, how to use it etc.
We are growing really fast and we need someone dedicated to connecting and integrating with new Real Estate Boards all the time. Our next move is going to USA market, and they have thousands of these local boards. And also we want to organize our back-end so each board connection is easy to setup initially and efficient to maintain going forward (this will be a future project for your developer that I can explain later on).
For this first task, I'd like your developer to create a database with 2 tables, then connect to the our Real Estate board database and setup the data pull for their listing information.
The production server that we are going to run this on is Windows 2012 (attached is the screenshot with specs).
1. Create database with 2 tables (attached are text files main_table.txt and table_photos.txt with already defined fields and SQL queries to create tables)
3. Create RETS connection to database
4. Do initial data pull and match up the fields that are received from Board to the ones we have in our main_table.txt, please have them match it up as close as possible and also create a list of fields that they are not able to match up.
5. Run the initial pull and populate our main_table.txt and table_photos.txt with the live data.
6. Create a script that we can run on a daily basis. The script will need to do the following:
A) Connect to database and get listing updates from the last 48 hours
B) Update listing information and photos that was changed in the last 48 hours
C) Insert new listings
D) Get a list of all active listings currently on database
E) De-activate listings in our database that are not in the list of active listings
7. Create a Windows service that will automatically run the above script once a day (the "once a day" setting will need to be customizable for the future as sometimes we will be running the update multiple times per day)
Срок выполнения 3-4 дня. Потом будут аналогичные/похожие задачи с таким же сроком выполнения.
We have a platform that we use to build websites and utilize real estate listing information in other ways. The platform is developed in Windows environment, so our servers are Windows servers and all the software is coded in ASP.
We have central databases that contain real estate listing information and every website connects to them. This listing information comes from external database that each local Real Estate Board has. For example TREB (Toronto Real Estate Board) has all of the listings in GTA and surrounding areas. CREB (Calgary Real Estate Board) has listings for Calgary & Edmonton, and so on. The way we connect to these external databases is through something called RETS standard. There is a lot of documentation online on how to connect, how to use it etc.
We are growing really fast and we need someone dedicated to connecting and integrating with new Real Estate Boards all the time. Our next move is going to USA market, and they have thousands of these local boards. And also we want to organize our back-end so each board connection is easy to setup initially and efficient to maintain going forward (this will be a future project for your developer that I can explain later on).
For this first task, I'd like your developer to create a database with 2 tables, then connect to the our Real Estate board database and setup the data pull for their listing information.
The production server that we are going to run this on is Windows 2012 (attached is the screenshot with specs).
1. Create database with 2 tables (attached are text files main_table.txt and table_photos.txt with already defined fields and SQL queries to create tables)
3. Create RETS connection to database
4. Do initial data pull and match up the fields that are received from Board to the ones we have in our main_table.txt, please have them match it up as close as possible and also create a list of fields that they are not able to match up.
5. Run the initial pull and populate our main_table.txt and table_photos.txt with the live data.
6. Create a script that we can run on a daily basis. The script will need to do the following:
A) Connect to database and get listing updates from the last 48 hours
B) Update listing information and photos that was changed in the last 48 hours
C) Insert new listings
D) Get a list of all active listings currently on database
E) De-activate listings in our database that are not in the list of active listings
7. Create a Windows service that will automatically run the above script once a day (the "once a day" setting will need to be customizable for the future as sometimes we will be running the update multiple times per day)
Срок выполнения 3-4 дня. Потом будут аналогичные/похожие задачи с таким же сроком выполнения.
