Battler45 / SierraMigrationToGitHub

Migration from unfuddle to GitHub
0 stars 0 forks source link

Convert Raw HTML/ CSS / JS to working pro site for new JoeHaydenRealtor.com #185

Open Battler45 opened 4 years ago

Battler45 commented 4 years ago

Vihang & Vihar,

I know that both of you are working on several other tasks, but, as you have time, our next task will be to get underway on integrating the programming, etc. into the raw HTML / CSS / JS of the new JoeHaydenRealtor.com website.

Vihar, the reason I've included you on this ticket is that, as we've discussed, I believe we will need to create a set of duplicate content and blog posts for this new site, which we'll then be able to work with in development without affecting the current live site. Can either you or Vihang move forward with that when you have time? I suppose this will also involve duplicating the current Sites record to a new record, and then also duplicating the site's current AdminUser to a new user.

Vihang, I've also configured a new working website for the new site. You can find it here:

http://joehaydenrealtornew.sierrainteractivedev.com/index.html http://joehaydenrealtornew.sierrainteractivedev.com/inner.html

You can access this site via FTP using the usual credentials, with the username, joehaydenrealtornew_dev

Once you log in to the site, you'll see that common files such as default.asp, content.asp, etc. have already been added to the site. I'm not sure how those got there -- I may have added them in copying the site, or it's possible that Arthur added them after finishing the site HTML. If you examine them and find that they don't belong there, or that you prefer to proceed in a different way, it's fine to remove or change them as needed.

In configuring this site, we are going to need to make some changes to the Communities page, by adding an number of new top-level Communities sections, and then assigning the (duplicated) pages in the content manager to the appropriate sections using the attached spreadsheet.

As you'll see in the attached spreadsheet, the client would like to add 15 new top-level sections to the new site, and many of the pages currently in the main Communities section will be re-assigned to these newly created sections.

Once that's done, the main Communities page on the new site (which includes the alphabetized list) will need to pull neighborhoods from all of these sections (similar to what we are already doing with MLSKY.net).

Can you get started with the programming integration there when you have time? Please let me know if you have any questions.

Thanks.

Posted by Shah Vihang(unfuddle username: vihang)

Battler45 commented 4 years ago

Ben,

Please find below a few questions:

1-- I believe the new site will have sidebar navigation menu (similar to some of the standard sites) instead of drop-down navigation menu. Could you please confirm this?

2-- Could you please confirm that the Community Resources link in the footer would map to the "Community Info" section?

3-- Could you please let me know the corresponding page/section for the "Louisville MLS" and "Louisville Real Estate footer links"?

4-- There is a "Text HAYDEN to 87778" widget on the home page. Could you please let me know if the site would use our "Send us a text message" functionality?

5-- I believe we will not be using Chosen plugin in this site. Please let me know if I should try to implement the jQuery UI Autocomplete plugin in this site.

Thanks Posted by Shah Vihang(unfuddle username: vihang)

Battler45 commented 4 years ago

Vihang,

1 - Yes, that's correct.

2 - Yes, correct

3 - Louisville MLS will go to the Property Listings site map (which I believe will be "/louisville-mls/site-map/"), and I think that "Louisville Real Estate" will go to the main communities page.

4 - Good question. For now, please leave this as static content.

5 - Another good question. I believe we may need to implement jQuery UI Autocomplete because client wants address and mls # to be searchable from the main box along with city, county and subdivision. But let me get back to you on that.

Thanks. Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Vihar,

Thanks for doing this. I am still not feeling well and have not been able to work much the past few days. I hope to be feeling better by Monday, and I will review this in more detail at that time.

Thanks. Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Vihang,

A couple of additional items on the JoeHaydenRealtor.com site:

1 - For the Featured Listings widget on the home page, can you please make the entire photo a link to the detail view for the listing, rather than just the Details button?

2 - Also for the Featured Listings widget, can you please use the thumbnail version of the images rather than the larger size? These thumbnail images are formatted to 140px, and the images in the widget are at 148px, so they would have to be displayed at a slightly larger size than what they actually are, but I think the savings in page load time will outweigh a small decrease in image quality.

Thanks. Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Ben,

I hope you are feeling better now. This is to clarify about publishing GLAR updater (comment-31) - pls note that publishing the new updater is not a must. The changes are at stored-procedure level only (to generate unique-id and move record to OffMarket table) so it would be fine to continue with the old GLAR updater by updating those stored-procedures. In that case however the old updater programming will need to be updated to create search-tool page links based on the UrlStructure and SearchToolsRootDirectory values (Sites table). This will ensure that correct links are added to the email-alerts.

Pls let me know if I should go ahead and update the stored-procedures and old updater programming for the same.

Thanks. Posted by Shah Vihar(unfuddle username: vshah)

Battler45 commented 4 years ago

Vihang,

Also on the JoeHayden site:

1 - Please update the "/louisville-communities/" section filename to "/subdivisions-and-neighborhoods/"

2 - Then, please update the section filenames for the different community sections as follows:

Thanks. Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Vihang,

Perfect, thank you. Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Ben,

In verifying front-end sites, I found that some sites like viewlouisvillehomes.com and allhomesinlouisville.com have the FormDetailLinkFromAddress defined in their local functions.asp file ([site-folder]/res/includes/functions.asp). This results in errors in loading search-tools pages; removing the FormDetailLinkFromAddress from the local file fixes the issue. Pls let me know if you encounter such issue or if a client reports similar issues.

Thanks. Posted by Shah Vihar(unfuddle username: vshah)

Battler45 commented 4 years ago

Vihang,

Thanks for doing that.

Actually, the client is in the process of creating these default pages. However, he reports that he is not able to enter a "/" for the Page Filename parameter (it tells him he must enter a value). I'm not sure why that would be -- it must be a permissions setting of some kind -- so, for now, he is creating these pages with the Page Filename of either "homes-for-sale" or "condominiums-for-sale".

If you go into the Content Manager for this site and sort by Last Updated, you'll see the pages he has already created in this way. Can you go through these and update the Page Filename to be just "/", so that they will work as the default pages for these sections and connect with the links you created in the Search by Area box?

Thanks. Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Vihar,

RE: #37

I would prefer to go ahead and publish the new GLAR updater sooner rather than later if you are confident that everything is in place there.

Thanks. Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Vihang,

I've discussed with the client and he is okay with waiting to merge content back together when the new site goes live. He is going to continue to need to make changes on the old (current) site until that time the new site is ready to launch. Will it be possible for us at that time to merge content between the new sites? I know it will be difficult, but the client feels it's an absolute necessity that he continue making changes on the current site until the new site goes live (for SEO purposes) and I was not able to deter him in this.

So, would you and Vihar be able to come up with a way that pulls the pages from both sites, and, for those that exist on both sites, compare the date last updated to select the most recent version and keep that as the current one?

I realize this may be somewhat difficult due to the fact that the sections are different between the two sites. Please let me know your thoughts on that.

Thanks. Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Vihang,

When you have time, we have a few more updates needed for the new JoeHaydenRealtor.com site:

1 - On the home page, please integrate the main content block with the content manager and change the content to: (H1) Louisville Real Estate with the Joe Hayden Real Estate Team (/H1) "Welcome to the premier website for Louisville Real Estate! It is our pleasure to share with you the journey of homeownership. You can perform a comprehensive Louisville MLS search, you can view all Homes for Sale in Louisville, including Jefferson, Oldham, Bullitt, and Shelby Counties. You can learn about Buying a Home and research Selling your Home. We are a highly-experienced team of agents ready to serve all of your real estate needs."

2 - Please add the following testimonials to the rotation on the home page: "The best part about working with Joe was that he was always more focused on answering our questions, giving us good advice, and finding homes that met our needs than he was on closing a deal. We would recommend him to anyone." John and Natalie Harris

"My wife and I have spent the past 12 years working in the Louisville area real estate market during which time we've met so many real estate agents. Joe is one of the very best and has the heart of a teacher. Joe's team is who we chose to sell our own home, and we would highly recommend them to anyone buying or selling a home in the Louisville area." Mike Roberts

"Joe Hayden is a very professional real estate agent who listened to our specific wants and needs. Since we from out of town his knowledge about East Louisville and Oldham County was most helpful. I needed handicap accessibility which is hard to find, and Joe did not waste our time looking at property that had no potential to meet my requirements. We highly recommend for all your real estate needs." Wayne and Becky Hartigan

3 - The client has finished creating the rest of the default pages for the community sections. Please update the Page Filenames for these pages from "/homes-for-sale/" to "/"

4 - For each of the community sections, the client would like to create "Featured Searches" as we have done for a few other sites (MLSHomesKY.com, MLSKY.net, etc.) The client would like the following searches for each section:

Can you create Price Reductions, Short Sales and Foreclosures searches for each community section based on the criteria the client has used for creating the active listings widget on the default page for each section?

The client is then going to provide us with default text for the corresponding pages for each of the above, and we will use that to create community pages once he has given that to us.

5 - On the property listing detail pages in Internet Explorer, the four buttons across the top of the page are not all displaying in one line, but are wrapping to a second line. I'm sure this is a CSS issue with something defined on a global basis in the stylesheet. Can you see if you can figure this out? If you're not able to, let me know and I will ask Evgen to take a look.

6 - On the property listing detail pages in Firefox, the tabs are not displaying correctly (Overview, Maps & Street View, etc.) Again, I'm sure this has to do with a definition in the stylesheet -- please see if you can figure this out, but don't spend too much time on it. We will ask Evgen to look at it otherwise.

7 - On the property listing detail page (both the old and new version) can you change the title text of the Neighborhood links to exactly match the text that is being linked? So, for example, if the neighborhood link said, "See all homes for sale in Academy Ridge" the title text on the link would say that same thing instead of "See all Academy Ridge Listings"

8 - The client asked about the photos / images in the content pages. I can't remember now whether we are going to stick with the new site ID (340) or revert to the ID of the current site (182) when we make this site live. If we are going to move to a new site ID, can you add a 301 redirect in the .htaccess file of the CAA that would redirect any requests for content-manager images / photos on the old site to the corresponding location on the new site?

So, for example, a request to the following URL:

http://client.sierrainteractivedev.com/UserFiles/182/image/Louisville_Real_Estate_and_Homes.jpg

Would be 301'd to this URL instead:

http://client.sierrainteractivedev.com/UserFiles/340/image/Louisville_Real_Estate_and_Homes.jpg

I think that's it for now. These changes would be highest priority at the moment, as the client is very anxious to get this site up and running, and he is one of our most important clients.

Thanks. Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Ben,

I have updated the links in the search by area box. Please note that when I click any of these links, I am redirected to 404 page as we have not yet added default pages for these sections. Please let me know if I should add the same or make an existing page the default page of each of these sections.

Thanks Posted by Shah Vihang(unfuddle username: vihang)

Battler45 commented 4 years ago

Ben,

I have fixed the detail page issue.

Regarding blog, please note, that the RSS feed icon is added in the shared /global/sicm/blog/blog_posts_body.asp file and the span tag within the H1 tag was workaround to address the issue, RSS feed icon not being clickable when the Cufon font is used. So makinng any change in the RSS feed icon display for this site would also apply on other sites. Please let me know if this would be fine.

Thanks

Posted by Shah Vihang(unfuddle username: vihang)

Battler45 commented 4 years ago

Vihar,

Unfortunately, I'm feeling a bit ill tonight and so am not going to be able to research this as I had thought. Would you mind taking a look at the programming in those xml_feeds/ pages. You can ignore the luxury real estate file (that creates a text file once per day), and you can also ignore the newpanda.asp file (same thing -- creates a text file once per day).

The trulia and zillow feeds could be tested on the joehaydenrealtor.com site -- I think by passing in the id of the featured listings search on that site.

Thanks. Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Ben,

I ended up testing all most all front-end sites. There were a few sites which had issues in loading "featured listings" / search-tool pages. I've made changes to temporarily address those issues. I'll look into this in detail and get back to you on the same tomorrow.

The following sites have been updated

a -- to remove "FormDetailLinkFromAddress" function from the local functions.asp file

b -- to update listing-carousel-1/2.asp files to pass additional parameters to the FormDetailLinkFromAddress function.

Pls note that to fix this issue (b) I also needed to

i - reference common_functions.asp in local master.asp

ii - define some constants used in the common_functions.asp. These constants are added in the listing-carousel file.

If any client reports similar issues, pls check

1 -- if the site's local function.asp file defines the FormDetailLinkFromAddress function. If yes, pls remove the function.

2 -- if correct number of parameters are passed to the FormDetailLinkFromAddress function. This function is defined in the \MLS_Tools_Integrated\res\includes\common_functions.asp file.

Thanks.

Posted by Shah Vihar(unfuddle username: vshah)

Battler45 commented 4 years ago

Vihang,

We've had some feedback from Joe Hayden on his new site, and so far he likes it a lot, but he does have a couple of requests:

1 - With the quick search, it seems to be agressive in auto-selecting the first option. For example, he says that if he starts typing in "Lake" with the intention of typing "Lake Forest" it jumps to "Boulders of Mallard Lake." Is there a way to make it function in this regard more like the Chosen plugin, where the first option is highlighted so that if they hit Enter or Tab it is selected, but that it does not automatically populate without that? Then, if they don't select from the drop-down list, the value would be nulled out? (Meaning, they would not be able to enter a value without selecting from the auto-complete list.)

2 - Can you copy over to the new site all pages that Joe has added or updated since you and Vihar did the original export of pages to the new site?

3 - Also, can you create a new spreadsheet of neighborhoods in exactly the same format as the original one, but this one picking up with neighborhood pages added after the last one was created? (I believe the cutoff date was November 28.)

4 - On the customer-facing sitemap on the new site please include all site pages including those in all community sections.

Thanks. Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Vihang,

RE: #32

The auto-complete plugin seems to be working great, thank you. Can you please:

1 - Update the default text of the search box to, "City or Neighborhood or Zip or Address or MLS #"

2 - Update the order of the results returned to be in that order as well. So, city results would be the first returned, then neighborhood, then zip, etc. That way, a neighborhood result would be selected by default rather than an address result, which I think will be the more common use case. Also, a question: if the client wishes to add Area to the list of options (in place of City or in addition to the options already there), would that be a problem?

3 - In the formatting of the options in the results list, can you format them more closely to how they are presented in the chosen drop-down, matching the colors, line-spacing and indentation used there? I believe the Chosen results list formatting is a bit easier to read.

It really seems to be quick at returning results, and the user interface is very intuitive -- nice job!

Regarding the additional points:

1 - That's fine. I am going to be making some further updates in this regard tomorrow.

2 - Yes, I agree it's best to leave that for now. I will ask the client to let us know his wishes there.

3 - Yes, I apologize that I forgot to mention this, but it's fine (and necessary) to use the Strict Doctype. I should have realized this would cause problems for you.

4 - Yes, I agree about waiting to update the links to site assets / photos until we are ready to make the site live, because then we will be able to do it all at once rather than in multiple steps. But, please do go ahead and update the "/property-search/" links to use the new "/louisville-mls/" URL structure.

Thanks. Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Ben,

I agree - the second option sounds easier. I'll work on restoring the latest sierrainteractive-1 db today. And, we can continue to make changes to the contents via the live CAA.

Thanks. Posted by Shah Vihar(unfuddle username: vshah)

Battler45 commented 4 years ago

Vihang,

One other thing -- regarding the quick search, we may need to take an approach on this site similar to what we are doing on HardestWorkingRealtor.org, and load the Quick Search contents via AJAX rather than via an iframe. The reason is that, on this site, as with the HardestWorkingRealtor.org site, the bottom border of the iframe is very close to the bottom border of the quick search box, and so we would not be able to display enough of the search box (auto-complete) options while the drop-down height is limited by the iframe height.

Can you look into changing that functionality to load the quick seearches via AJAX rather than in an iframe?

Thanks. Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Vihar,

Ah, I see. Well, whichever way you prefer is fine with me -- it does seem like the latter way might be easier. I suppose we could continue to make changes to the content for the new site via the live CAA, even if we were not able to preview those changes on the development site?

Thanks. Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Ben,

I've created new Sites record for the new JoeHaydenRealtor site (340) and have also added a new AdminUser record for Joe Hayden (1026). Pls note that the user-name for the new AdminUser is joe_new so that it could be used for accessing new site. We've also created duplicated contents / saved-searches records and have associated them with the new site.

Pls note the following points:

1 -- New sections have been added as listed in the attached spreadsheet. They have been associated with appropriate pages. Pls note that the number of pages listed in the spreadsheet is 670 whereas the total number of community pages (associated with the Communities section) is 797. Pls let me know if we need to associate those remaining 127 pages with appropriate section.

2 -- For now I haven't created duplicate blog records for the new site. I believe it would be fairly straightforward to associate blog-records with the new site as and when we launch it. For now the client can continue adding / updating blog entries. Pls let me know your inputs.

Vihang will start working on adding programming for the new front-end site.

Thanks. Posted by Shah Vihar(unfuddle username: vshah)

Battler45 commented 4 years ago

Ben,

RE #44:

I have updated the autocomplete implementation per point-1 and included all new section pages on the site-map page per point-4. Please check the same.

RE #46:

Yes, it would be difficult to merge the newly added/ updated content into the new site but we will try to find a solution for this. Thinking more about this, I believe it would be good to add new sections in the old site (182) and assign pages to the appropriate section per the spreadsheet when new site goes live. We can then discard the new site (340). This will require us to update the constants in the new front-end site but this would be easier compared to migrating newly added/updated content to the new site. This will also save us from re-assigning leads, admin-user and blog records and assets (images/files) to the new site. All we need to do would be to:

1-- Add new sections in the old site (182)

2-- Assign pages to appropriate sections per the spreadsheet

3-- Replace the "/property-search/" to "/louisville-mls/" in the post/pages contents.

Please let me know your thoughts on this.

Thanks Posted by Shah Vihang(unfuddle username: vihang)

Battler45 commented 4 years ago

Ben,

I have updated the Featured Listings widget per comment-15 and updated Market Statistics page to show stats for Indian Hills instead of Cherokee Triangle.

I have also made changes to load the Quick Search form via AJAX. However, there seems to be some issue with the listing counts row display. I spent some to on this but I am not able to fix the styling issue. Also, please note that the overflow property of the search form container (div#fadeBox) is set to hidden, as a result not all search options are visible. When I removed the overflow property the "Fewer Options" button was not working. Can you please ask Arthur/Evgen to look in to this?

Thanks

Posted by Shah Vihang(unfuddle username: vihang)

Battler45 commented 4 years ago

Ben,

I have made changes in the site per comment #56. Please note that, I have not removed the previously added testimonials. Please let me know if I should remove the same.

Regarding adding 301 rules for the image links:

Please note that, we haven't yet copied the images to the new site and updated the image links in the page contents. Per our earlier discussion, we had decided to do so at the time of launch. So, if we add the redirect rules now, the images would not be displayed on the new site.

Also, I am not sure if you had a chance to review my response in comment #47 to your question (in comment #46) about merging the new/updated content pages/saved-searches into the new site. As mentioned, it would be quite difficult to merge the contents from the old site into the new site. If you think it would be good to stick to the old site and add new sections into the old site, then we will need to perform following steps in addition to the three steps mentioned in comment #47:

1-- Update the site-id of the newly added pages/saved-searches in the new site (340) to 182

2-- There are four old content pages that have been updated in the new site (340) so we will need to update these content pages in the olds site (182).

3-- Run the script to add community pages and subdivision associations on the old site (182)

I think this would be straightforward and less time consuming then merging contents from the old site into the new site. Please let me know your thoughts on this.

Thanks

Posted by Shah Vihang(unfuddle username: vihang)

Battler45 commented 4 years ago

Ben,

I will work on point-1 and 4 tomorrow.

Regarding 2:

When we migrated saved-searches/content-pages to the new site, we thought this would be a one-time operation and the client would add/update saved-searches/content pages to the new site. So we created script accordingly. We will need to make changes in the scripts to migrate added/updated saved-searches and content pages to the new site. Please let me know if it would be fine to do so when we make the site live.

Please find attached a spreadsheet listing all the neighborhood pages added on or after 28 November 2011.

Thanks Posted by Shah Vihang(unfuddle username: vihang)

Battler45 commented 4 years ago

Vihang,

Can you please add the following testimonial to the home page for the new Joe Hayden website?

"Our family can honestly say that we were completely satisfied with the services we received through Joe Hayden and his entire team. From the beginning, we were impressed with his personal approach, professionalism, attention to detail, and hard work." Christina and Bobby W.

Also, the client is going to have a couple of additional testimonials, and would like these to rotate on the home page (fading in and out, each approx 8 seconds). Can you go ahead and set that up?

Thanks. Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Ben,

Glad to hear that you're feeling better now.

I also thought about referencing the common programming for those sites but they have some differences in the way data is retrieved so I didn't make the change. I agree that it would be good to revisit this later.

As for launching the GLAR updater - the imported data appears to be in order so I'm confident about that. The only thing I'm concerned about is the photo migration. As mentioned earlier, the photo-migration app was built to process weekly photos so I'll need to revisit it once before we initiate the transfer.

That said, the new updater is needed to be launched so that the email-alerts contain correct links. As I understand we won't be launching the new JoeHaydenRealtor site for another few days so we can continue with the old GLAR updater for another couple of days. That will give us time to prepare for the launch of the new GLAR updater, which is critical considering the number of sites we have in that region.

The only change that would be needed for now would be to update the spInsertUpdateMLSListing and spRemoveListingByMLSNumber stored-procedures so that they start moving records to the OffMarket table. Pls let me know if now would be the correct time to update those stored-procedures. If the old updater has already started then perhaps I'll do that my early tomorrow.

In any case, I've changed the new JoeHaydenRealtor site to point to the live db and use the live search-tools programming.

Thanks. Posted by Shah Vihar(unfuddle username: vshah)

Battler45 commented 4 years ago

Vihang,

1 - Good question. On this site, though, I think it is fine to include sidebar content on all site pages (except for the new property listing detail page).

2 - Also a good question, but, no, in this case, I think it will be best to use the free_market_analysis_2.asp form in the /property-search/ folder, as on this site: http://www.buildingstapleton.com/property-search/free-market-analysis/

3 - Yes, that would be great. The programming will be slightly different because we will not have the tabs at the top of the box switching states as they do on the PWPrudential.com site, but, yes, the plugins will be the same and the basic functionality will also be the same. The links to the clients profiles are:

4 - Yes, exactly, the functionality will be very similar to what you see on http://www.weselllouisville.com, and you can use the same code and the same style overlay as on that site. The client does not yet have the finished video ready, so, for now, please use this video as a placeholder:

http://www.youtube.com/watch?v=MX0D4oZwCsA&feature=relmfu

5 - Yes, good question. For some reason, I had failed to notice that. We do not actually have several of the stats listed in that box. So, please use the following instead:

Then, beneath the Averages header, please use:

Please let me know if you have any other questions.

Thanks. Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Ben,

RE: #13 - point-1 - I think we'll need to push all related changes in order to integrate the dev search-tools back into the live branch. That is, in addition to the changes made to the front-end sites' programming, it would be good to publish changes to the CAA as well. Then, once we are ready to launch the site, we can publish changes to the updaters (old and new) to be able to handle new detail-page url (spid). Pls let me know if I should treat this as the highest priority task.

Thanks. Posted by Shah Vihar(unfuddle username: vshah)