Tag Archives: timeline

Google Charts Timeline Group By Label Tutorial

It doesn’t take an Einstein to tell you that to keep reading and revisiting topics in I.T. is a good thing to do, if you have the time. We’ve been revisiting the Google Chart API documentation, specifically the Timeline Chart section today, and see ways to improve our PHP web application interface to this chart. We saw … that we could allow a user to tailor their own prefixing “label” (type of) data column … so that the two “title” type columns the user comma separates would appear to the left and on top of the timeline graphics, respectively … like with our “Stay A While Motel Room Number,Booking in the Name Of tutorial picture today … cater for SSL https: and http: protocol calls of the Timeline Chart with no “Mixed Content” implications … and we considered multi-line textarea changes, but the lack of room on the chart itself precluded us from going ahead with that part of the work. Now adding a column is no big deal data structure wise, but the tweaks required to continue with functional and accurate “Select” event logic needed some of the old “alert” commented out codelines we had left (in the PHP code) to be resurrected for an hour, to sort out the logic. Honestly, we’d have used a debugger if that would have been a better way, but this is not always the case. Lots of programmers use “console.log” instead of the Javascript alert box, and yes, that can be good practice. The two can have different affects in that if the “onfocus” event is involved, to whack in an “alert” box might introduce confusion, and if “focus” is an issue with a bug, it would definitely be safer (and “coding fairer”) to use “console.log”. Either way, the proliferation of “alert” codelines pointed us to where issues might arise, and probably saved a lot of time, in this way. So see what we’ve been up to timeline wise since HTML5 Time Tag Timeline Tutorial with the changed timeline_chart.php‘s live run. Previous relevant HTML5 Time Tag Timeline Tutorial is shown below. The recent HTML5 Time Tag Primer Tutorial introduced the time tag, an HTML5 initiative, into our frame of reference here at this blog. As soon as date and/or time come into the picture the “when” of life comes into focus, and the use of the fourth dimension. As such, this HTML … Continue reading →

Posted in eLearning, Event-Driven Programming, Tutorials | Tagged , , , , , , , , , , , , , | Leave a comment

Google Chart Annotated Timeline Whitespace Delimitation Tutorial

The recent Google Charts Annotated Timeline Chart interfacings in the name of “Trip Planning” with the recent blog posting thread post called Window LocalStorage Client Versus Server Map Tutorial‘s web application worked for the majority of cases, but we did note down some weaknesses (not even in the glint of the eye of proceedings when we wrote Calendar iCal Integration Timeline Tutorial) that it is time to attend to … dealing with lots of data sometimes failed … to cut a long story short, we needed to use $_POST rather than $_GET more often … but new to discussions at this blog were also … whitespace lack of functionality … and … delimitation weaknesses How did we start getting into more worry about “whitespace” with Trip Planning Itinerary coding logic? So we started turning some HTML input type=text elements into textarea elements to facilitate this. But even entering multi-line entries they all translated to either nothing or a single space getting to the report phase of the Annotated Timeline Chart goings on. Well, we wanted to allow for multi-line Itinerary comments, and keep the line feeds, because we know how “wordy” Itineraries can be, and how their “layout” might rely on these linefeeds being preserved. “Whitespace” is an open ended term when talking about web pages, and the code underlying creating those web pages. Let’s outline just a subset of what we might mean by “whitespace” in some of these “webpage” contexts … <br> HTML element tag for a line feed as far as “display” goes with a webpage and for the line feed in the data of an HTML textarea element “innerHTML” property “\n” in PHP and Javascript (or String.fromCharCode(10) also in Javascript) can describe whitespace line feed in the data of an HTML textarea element “value” attribute and can come into play as the user keys in the “return” key of their keyboard within that textarea as displayed in the webpage &nbsp; is a whitespace space character guaranteed not to be scrunched up by the web browser renderers, whereas ascii 32 is a whitespace space character which can be scrunched up depending on the CSS and HTML content by the web browser renderers “\t” in PHP and Javascript (or String.fromCharCode(9) also in Javascript, or “%09” when encodeURIComponent’ed into a $_GET or $_POST URL data component) can describe whitespace horizontal tab “and can only be programmatically appearing” (as we … Continue reading →

Posted in Not Categorised | Tagged , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

Window LocalStorage Client Versus Server Map Tutorial

Get a good map, and a goodly number of times you’ll want a map of smaller or larger scale than the one you have. Murphy’s Law? This is probably why in the wonderful woooooooorrrrrrrrlllllld of Google Charts they have included … Geo Chart topographic map of the world or of regions Map Chart terrestrial/satellite map of your group of markers at a zoom level of your choosing … and hope you can see that the latter can save the day for a Short Distance Trip (corner shop, anyone?!). So we’ve added onto yesterday’s Window LocalStorage Client Versus Server Timeline Tutorial progress a new toggling button to view a scenario in either Google Chart scenario above. You can see this integration work with our changed wls_vs_php.htm‘s Capital City Find Matching Country Report live run link supervising a tweaked geo_chart.php Geo Chart interfacer. Previous relevant Window LocalStorage Client Versus Server Timeline Tutorial is shown below. Up to yesterday’s Window LocalStorage Client Versus Server User Tutorial‘s progress, our Capital City Find Matching Country Report web application project was all about … where (and capital of “what”) … but we often seek out a way to add into the mix that 4th dimension … when (ie. time) … and regarding the current project, a … where “map” … can interface with a … when “Trip Plan Itinerary” … and for this purpose, we’re going to interface to the excellent Google Charts Annotated Timeline Chart, thanks, because it combines links of “time” to “user annotations” in a timeline way, that similar way you might describe the qualities of a Trip, even before you’ve gone on that trip. We’ve also added it so that an unordered places list can be turned into a Trip Plan Itinerary at the click/touch of a new map 🗺 &#128506; emoji button. Again, see how these timeline amendments were achieved with our changed

Posted in Ajax, eLearning, Event-Driven Programming, Tutorials | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

Window LocalStorage Client Versus Server Timeline Tutorial

Up to yesterday’s Window LocalStorage Client Versus Server User Tutorial‘s progress, our Capital City Find Matching Country Report web application project was all about … where (and capital of “what”) … but we often seek out a way to add into the mix that 4th dimension … when (ie. time) … and regarding the current project, a … where “map” … can interface with a … when “Trip Plan Itinerary” … and for this purpose, we’re going to interface to the excellent Google Charts Annotated Timeline Chart, thanks, because it combines links of “time” to “user annotations” in a timeline way, that similar way you might describe the qualities of a Trip, even before you’ve gone on that trip. We’ve also added it so that an unordered places list can be turned into a Trip Plan Itinerary at the click/touch of a new map 🗺 &#128506; emoji button. Again, see how these timeline amendments were achieved with our changed

Posted in Ajax, eLearning, Event-Driven Programming, Trips, Tutorials | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

Google Chart via CSV or JSON or XML Tutorial

Building on yesterday’s Google Chart via CSV or JSON Sharing Tutorial, again, we have a dual purpose set of improvements for you today regarding our CSV or JSON to Google Chart web application, those being … XML input data functionality data column prefix or suffix exclusion (characters) allowing scope for numerical sorting of currency data for example We want to thank this great webpage for the heads up about the possibility to use PHP’s simplexml methodologies to convert XML data to CSV (in the simple and well formed data cases) that we’ve discussed before regarding a similar scenario with XML to HTML PHP Three Ways Translation Tutorial. In order to make all this happen for both … Ajax call … and … XML local file browsed for … scenarios we needed to write a PHP XML to CSV converter called xml_to_csv.php which we show you in action below … Allowing for character exclusions at the start or end of column data, to allow currency data be sorted (and filtered) numerically is just a case of offering a link that brings up a Javascript prompt box to ask the user for a whole of CSV or JSON or XML document file application of this character exclusion rule. You can see both of these concepts playing out with the URL https://www.rjmprogramming.com.au/HTMLCSS/csv_to_bubblechart.htm?title=Breakfast+Menu&onclick=y&wouldlikeyoutoseekpermission=y&task=Price&desc=Calories&label=%27name%27&value=Life+Expectancy%2CFertility+Rate%2C%27Region%27%2CPopulation&country=Country&popularity=Popularity&area=Area&width=556&height=347&desc1=Sold+Pencils&title1=Sold+Pencils+title1&text1=Sold+Pencils+text1&desc2=Sold+Pens&title2=Sold+Pens+title2&text2=Sold+Pens+text2&nf=1%2C3&exclude=%24&data=HtTp%3A%2F%2Fwww.rjmprogramming.com.au%2FHTMLCSS%2Fbreakfast_menu.xml%23https%3A%2F%2Fwww.rjmprogramming.com.au%2FPHP%2FPieChart%2Fpie_chart.php%3Ftitle%3DPie%2520Chart%2520via%2520CSV%26onclick%3Dy%26task%3DTask%26desc%3DPercentage as shown live below … So see what we did to get to where we are today … supervisor CSV to Google Chart csv_to_bubblechart.htm‘s live run link web application changed this way … calls and uses … external Javascript csv_to_bubblechart.js changed this way Maybe you have some of your own CSV or JSON or XML data to show in chart form, yourself? We hope these ideas help you out. Previous relevant Google Chart via CSV or JSON Sharing Tutorial is shown below. Building on the recent Google Chart via CSV or JSON Filtering Tutorial we have a dual purpose set of improvements for you today regarding our CSV or JSON to Google Chart web application, that being … email sharing of scenarios where your input CSV or JSON data is a URL via the user’s email client application means of emailing … and that long promised … correlation data examples for the Bubble Chart are shown today You may know that whenever we talk about “user’s email client application” that means we are excluding PHP method=POST mail function approaches, and using, … Continue reading →

Posted in Ajax, eLearning, Event-Driven Programming, Tutorials | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

Google Chart via CSV or JSON Sharing Tutorial

Building on the recent Google Chart via CSV or JSON Filtering Tutorial we have a dual purpose set of improvements for you today regarding our CSV or JSON to Google Chart web application, that being … email sharing of scenarios where your input CSV or JSON data is a URL via the user’s email client application means of emailing … and that long promised … correlation data examples for the Bubble Chart are shown today You may know that whenever we talk about “user’s email client application” that means we are excluding PHP method=POST mail function approaches, and using, quite often large URLs (but not large enough to spill outside the URL length limits of the web server involved). How can we do this with the amounts of data involved? We break the issue into two parts … initial pass collects header information including, crucially, an input data URL arrangement that is started with “HtTp” the bother of using is the user’s way to flag that they may want to share the eventual output Google Chart via email (using the client email application … ie. “a” “mailto:” link) … that navigates to the same HTML and Javascript that has enough information to have a … second pass uses an Ajax approach to then fleshing out the “data” part to the whole issue, augmenting the header data passed in so as to be able to use HTML iframe element as an HTML form’s target=[iframeName] method=POST so that it can show the Google Chart asked for and be able to allow for emails that are making use of new HTML as per … <div id=dpremyiframe><a id=premyiframe href=’#myh1′ title=’Back to top’>^</a></div><br> … to have the new Javascript DOM statement as per … document.getElementById(‘dpremyiframe’).innerHTML+=’&nbsp;&nbsp;<a id=aemail href=”mailto:?subject=’ + encodeURIComponent(document.getElementById(‘title’).value) + ‘&body=’ + encodeURIComponent(document.URL) + ‘” title=”Email Chart”>Email this Chart</a>’; … allow for this new email sharing functionality to happen Now let’s show you a couple of Bubble Chart data correlation ideas we are thankful to this great webpage for sharing. U.S. Consumer Confidence Post WWII Data Example //www.rjmprogramming.com.au/HTMLCSS/csv_to_bubblechart.htm?title=United+States+Consumer+Confidence+Post+WWII&onclick=y&wouldlikeyoutoseekpermission=y&task=Task&desc=Percentage&label=%27Year%27&value=Unemployment%2CInflation%2C%27Presidential+Approval+Rate%27%2CConsumer+Confidence&country=Country&popularity=Popularity&area=Area&width=556&height=347&desc1=Sold+Pencils&title1=Sold+Pencils+title1&text1=Sold+Pencils+text1&desc2=Sold+Pens&title2=Sold+Pens+title2&text2=Sold+Pens+text2&nf=0%2C1%2C2%2C3%2C4&data=HtTps%3A%2F%2Fwww.rjmprogramming.com.au%2FHTMLCSS%2FEconData.csv%23https%3A%2F%2Fwww.rjmprogramming.com.au%2FPHP%2FBubbleChart%2Fbubble_chart.php%3Ftitle%3DUnited%2520States%2520Consumer%2520Confidence%2520Post%2520WWII%26onclick%3Dy%26label%3D%2527Year%2527%26value%3DUnemployment%252CInflation%252C%2527Presidential%2520Approval%2520Rate%2527%252CConsumer%2520Confidence World Poverty Data Example //www.rjmprogramming.com.au/HTMLCSS/csv_to_bubblechart.htm?title=Female+Life+Expectancy+and+Birth+Rate+Correlation+to+GNP+Worldwide&onclick=y&wouldlikeyoutoseekpermission=y&task=Task&desc=Percentage&label=%27Country%27&value=Female+Life+Expectancy%2CBirth+Rate%2C%27Region%27%2CGNP&country=Country&popularity=Popularity&area=Area&width=556&height=347&desc1=Sold+Pencils&title1=Sold+Pencils+title1&text1=Sold+Pencils+text1&desc2=Sold+Pens&title2=Sold+Pens+title2&text2=Sold+Pens+text2&nf=7%2C4%2C0%2C6%2C5&data=HtTps%3A%2F%2Fwww.rjmprogramming.com.au%2FHTMLCSS%2FPoverty.csv%23https%3A%2F%2Fwww.rjmprogramming.com.au%2FPHP%2FBubbleChart%2Fbubble_chart.php%3Ftitle%3DFemale%2520Life%2520Expectancy%2520and%2520Birth%2520Rate%2520Correlation%2520to%2520GNP%2520Worldwide%26onclick%3Dy%26label%3D%2527Country%2527%26value%3DFemale%2520Life%2520Expectancy%252CBirth%2520Rate%252C%2527Region%2527%252CGNP So see what we did to get to where we are today after yesterday’s Google Chart Date Time Charts via CSV Tutorial … supervisor CSV to Bubble Chart csv_to_bubblechart.htm‘s live run link web application changed this way … calls and uses … external Javascript csv_to_bubblechart.js needed no changes today Previous relevant Google … Continue reading →

Posted in Ajax, eLearning, Event-Driven Programming, Tutorials | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

Google Chart via CSV or JSON Filtering Tutorial

One of the more challenging parts of data representation can be filtering out too much data, for presentation purposes. We are going to refer to this issue as a “filtering” issue. Building on yesterday’s Google Chart via CSV or JSON Tutorial this filtering doesn’t care about the format of the data, just if the user is interested to apply it to any column of interest to them within a CSV (as the common denominator) column. As you can imagine, this involves reading through all the CSV data to arrive at some … minimum range to maximum range …. values for each column, always in terms of … alphabetical sorting … and sometimes also in terms of … numerical sorting … depending on the nature of the column data involved … and once collected, in a Javascript function called via a setTimeout timer so as not to interfere with the main workflow of the web application, we present to a user who hovers or clicks on a column dropdown “a” links to the up to 4 potential ranges of interest, ready for the user to redefine as they wish to “filter” data that goes to the Google Chart interfacer of interest. Think the search engines, and they have algorithms to determine what shows above the fold for search results. This is a “filtering” mechanism they apply to a set of data too complex to present in a first come, first served way. Again, see what we did to get to where we are today, below … supervisor CSV to Bubble Chart csv_to_bubblechart.htm‘s live run link web application changed this way … calls and uses … external Javascript csv_to_bubblechart.js changed this way Previous relevant Google Chart via CSV or JSON Tutorial is shown below. Our progression with the “CSV to Google Charts” web application today, building on yesterday’s Google Chart via CSV Header Data Tutorial, is to widen the net and name the web application “CSV or JSON to Google Charts”. The JSON protocol represents a common means by which hierarchical data can be represented in the online world. As such, though we cannot guarantee the more complex hierarchy of data found in JSON data, we thank the contributors to this great webpage for the all but tinkering Javascript function we end up with that converts JSON data to CSV for usage in our web application. Also, today, now that we can … Continue reading →

Posted in eLearning, Event-Driven Programming, Tutorials | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

Google Chart via CSV or JSON Tutorial

Our progression with the “CSV to Google Charts” web application today, building on yesterday’s Google Chart via CSV Header Data Tutorial, is to widen the net and name the web application “CSV or JSON to Google Charts”. The JSON protocol represents a common means by which hierarchical data can be represented in the online world. As such, though we cannot guarantee the more complex hierarchy of data found in JSON data, we thank the contributors to this great webpage for the all but tinkering Javascript function we end up with that converts JSON data to CSV for usage in our web application. Also, today, now that we can edit header column data we can help out the “statistical” Google Charts … Area Chart Bar Chart Column Chart Line Chart … by allowing the user to add fields or rename fields of the default 3 fields expected by these chart types. With this, we expect any new such fields to be numerical. The implication of this is that some quite complex scenarios can be reflected through the use of these chart types with this web application. So see what we did to get to where we are today, below … supervisor CSV to Bubble Chart csv_to_bubblechart.htm‘s live run link web application changed this way … calls and uses … external Javascript csv_to_bubblechart.js changed this way Thanks to the data of ASX Historical Data for the underpinnings of today’s Line Chart some ASX Stocks data on 20180730 tutorial picture. Previous relevant Google Chart via CSV Header Data Tutorial is shown below. Many jobs that involve data form themselves into a … header details … data model. It happens all the time in Information Technology. Just think of General Ledgers in accounting. At the database table level supporting these arrangements there’ll be a smaller sized header table off which there will be a mechanism to “drill down” into the details database table. In our current project, up until today, we’ve only taken a cursory interest in the “header” data thinking for it, offering only a pretty awkward and clunky mechanism for the user to enter a Google Chart title with that “#” method on the top textbox. In our priorities for this job we were much more focussed on how to deal with the larger volumes of data, and this is always associated with the “details” of the Google Chart data. Within what … Continue reading →

Posted in eLearning, Event-Driven Programming, Tutorials | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment