Navigation

    Monaca & Onsen UI
    • Register
    • Login
    • Search
    • Tags
    • Users
    • Blog
    • Playground
    1. Home
    2. tobimarsh
    T
    • Flag Profile
    • Profile
    • Following
    • Followers
    • Blocks
    • Topics
    • Posts
    • Best
    • Groups
    Save
    Saving

    tobimarsh

    @tobimarsh

    Having more than 3 years of experience in Tableau & DevOps with expertise in providing Enterprise Performance Engineering & integrated solutions.

    0
    Reputation
    4
    Posts
    542
    Profile views
    0
    Followers
    0
    Following
    Joined Last Online

    tobimarsh Follow

    Posts made by tobimarsh

    • formatting data and clicking next page in Zillow

      I am trying to get a VBA web scraping tool to pull the data from Zillow for all sold properties within the last 24 months and paste it in an analytical format. The issues I am running into are:

      1- the data is pulled as HTML format so it is stuffed into a single cell. I have tried A-tried first to do a blanket convert to column function but the lengths are all variable and it will also sometimes cut off anything past the address. B- tried to copy and paste to a .txt file but the path kept breaking somewhere and not all the data made it.

      2- click the “Next page” button. I have tried A-searching href tags to create the next URL, the keep coming back as “Null” and break the chain B- using CSS selector to pick the tag with the title “Next page”. I think this is working, but it just keeps clicking the pages without downloading the data after page 1.

      Bonus points if you can: -Also download the link href. See point 2 as I keep getting null whenever I try to get the href.

      Make it so the base URL pulls from a cell on sheet1 so I can make it more dynamic. Whenever I try it either tells me a specific range is not constant or the object is not valid.

      Any help or clarity on what I am doing wrong would be helpful! Code:

      Option Explicit
      
      Sub GetZillowSold()
      
          Dim XMLReq As New MSXML2.XMLHTTP60
          Dim HTMLDoc As New MSHTML.HTMLDocument
          
          Dim ListCards As MSHTML.IHTMLElementCollection
          Dim InfoCard As MSHTML.IHTMLElement
          
          Dim SoldList As MSHTML.IHTMLElementCollection
          Dim SoldDate As MSHTML.IHTMLElement
          
          Dim Zpages As MSHTML.IHTMLElementCollection
          Dim Zpage As MSHTML.IHTMLElement
          
          Dim CardID As Integer
          
          XMLReq.Open "GET", "https://www.zillow.com/the-colony-tx/sold/house_type/3-_beds/", False
          XMLReq.send
          
          If XMLReq.Status <> 200 Then
              MsgBox "Problem" & vbNewLine & XMLReq.Status & " - " & XMLReq.statusText
              Exit Sub
           End If
           
           Worksheets.Add
           Range("A1").Value = "Address"
           Range("b1").Value = "Price"
           Range("c1").Value = "Bedroom"
           Range("d1").Value = "Bath"
           Range("e1").Value = "Sqft"
           Range("f1").Value = "Date"
           Range("A2").Select
           
           HTMLDoc.body.innerhtml = XMLReq.responseText
           Set XMLReq = Nothing
          
           
           
            Set ListCards = HTMLDoc.getElementsByClassName("list-card-info")
            
               'Debug.Print ListCards.Length
             
             For Each InfoCard In ListCards
               ActiveCell.Value = InfoCard.innerText
               ActiveCell.Offset(1, 0).Select
               
             Next InfoCard
             
             Range("f2").Select
             Set SoldList = HTMLDoc.getElementsByClassName("list-card-top")
            'Debug.Print SoldList.Length,
          
            For Each SoldDate In SoldList
               ActiveCell.Value = Mid(SoldDate.innerText, 6)
               ActiveCell.Offset(1, 0).Select
           Next SoldDate
           
          Set Zpages = HTMLDoc.getElementsByTagName("a")
           
           For Each Zpage In Zpages
              If (Zpage.getAttribute("title") = "Next page") Then
              Zpage.Click
              End If
              Exit For
              Next Zpage
      End Sub
      

      From https://bit.ly/3pNk6hV

      posted in Developer Corner
      T
      tobimarsh
    • Struggling with subject to learn(django,game and app development, reverse engineering)

      I have been struggling to find a subject to deep study… the subjects(more like choices)are: Django, unity game programming, reverse engineering in assembly, and java app development. I would be happy if someone could light me up at one or more of the subjects from his own experience or recommending me about a new subject of his own(Note: Telling me to try and find out by myself won’t help…) I have knowledge in python, java, C#, and a little bit of html\css

      I have tried unity, java app developing in android studio and I messed with Django a little bit… but every time I started a project I didn’t actually finish it.

      I am interested in learning all of them but can’t decide which one to start with and I end up learning nothing:v

      Thanks in advance

      posted in Developer Corner
      T
      tobimarsh
    • JavaScript API between Tableau and TcVis 8.3

      We’ve been asked to provide a JavaScript API to pass X,Y,Z coordinates from a Tableau Workbook to VisMockup (Teamcenter Lifecycle Visualization). We’ve received the code from a similar function but the 3D Graphics Software was Integrating Vision Toolkit (IVT). https://bit.ly/30heLVu

      The hope was that our developer could change whatever connection parameters were required from IVT to those required by VisMockup.

      Can anyone point me toward sample documentation for TcVis APIs?

      Thanks.

      posted in Developer Corner
      T
      tobimarsh
    • How to embed Tableau into a web page using the tableau JavaScript API?

      I’m a beginner trying to embed Tableau visualization into my web page, such that whenever the link is clicked, visualization is rendered on the page. But the browser loads with an error on the tableau Software object. How can I initialize this object?

      I’m using the Tableau server trial version
      https://bit.ly/3bpWxUy

      <html>
      
          <head>
      
              <script type='text/javascript' src='http://localhost:85/javascripts/api/viz_v1.js'></script>
      
              <script>
      
                  function initializeViz() {
      
                      var placeholderDiv = document.getElementById("tableauViz");
      
                      var url2 = "http://localhost:85/views/test_page/Sheet1?:embed=y&:display_count=no";
      
                      viz = new tableauSoftware.Viz(placeholderDiv, url2);
      
                  }
      
              </script>
      
          </head>
      
          <body>
      
              <a href="#" onclick="$('#tableauViz').html(''); initializeViz()">visualize</a>
      
              <div class id ="tableauViz"></div>
      
          </body>
      
      </html>
      
      

      I get this error:

      alt text

      posted in Developer Corner
      T
      tobimarsh