I have a simple html file in which there's javascript code referring to google charts.

The code I use is this (I'll show the important part):

function drawChart(){
    var data = google.visualization
                     .arrayToDataTable([ ['Label', 'Value'],['Temp', 22.75],]);

    // etc...
}

I use a bash mand (sed) to replace that 22.75 value with a new one from the last line of a .txt file. However, this throws some errors which I haven't been able to neither correct nor ever identify.

So is there any javascript code that takes that file, extracts the last value and simply displays it on the right place of the code?

UPDATE:

Sorry for the lack of info in this question, I really appreciate all the people that took the time on reading my question. I'll try to fill with more information in the next minutes.

I am able to extract the last line of the .txt file, extract the value on the right part of the '-' symbol and store it in a variable. Then that value is taken to update the html file with a sed mand. The error es when the value is updated but with no value. I guess that happends due to a failed record of temperature in the txt file, then the extracted value is a null. Finally is the html fiel with javascrit code happens to be like this:

(...)['Temp', ],]);

Then the updater can't update the value since due to the way that sed mand is written I guess there's no way that it can detect a no-number-value in there. So the html remains without a value all the time.

TXT File structure:

(...)
20:25:03-23.312
20:26:02-23.312
20:27:03-23.375
20:28:03-23.375
20:29:02-23.375
20:30:02-23.312

Bash script:

# (...code...)
lastRecord=`cat /home/pi/scripts/temp_control/logs/"$today".log | awk 'END{print}'`

function rightNow {
  lastTemp=`echo $lastRecord | cut -d'-' -f2`

  timeOfTemp=`echo $lastRecord | cut -d'-' -f1` # Not used yet

  #Command used to update
  sed -i "s/['Temp', [0-9]\{1,2\}.[0-9]\{1,3\}]/$lastTemp]/" /var/www/rightnow.html
}

rightNow

I have a simple html file in which there's javascript code referring to google charts.

The code I use is this (I'll show the important part):

function drawChart(){
    var data = google.visualization
                     .arrayToDataTable([ ['Label', 'Value'],['Temp', 22.75],]);

    // etc...
}

I use a bash mand (sed) to replace that 22.75 value with a new one from the last line of a .txt file. However, this throws some errors which I haven't been able to neither correct nor ever identify.

So is there any javascript code that takes that file, extracts the last value and simply displays it on the right place of the code?

UPDATE:

Sorry for the lack of info in this question, I really appreciate all the people that took the time on reading my question. I'll try to fill with more information in the next minutes.

I am able to extract the last line of the .txt file, extract the value on the right part of the '-' symbol and store it in a variable. Then that value is taken to update the html file with a sed mand. The error es when the value is updated but with no value. I guess that happends due to a failed record of temperature in the txt file, then the extracted value is a null. Finally is the html fiel with javascrit code happens to be like this:

(...)['Temp', ],]);

Then the updater can't update the value since due to the way that sed mand is written I guess there's no way that it can detect a no-number-value in there. So the html remains without a value all the time.

TXT File structure:

(...)
20:25:03-23.312
20:26:02-23.312
20:27:03-23.375
20:28:03-23.375
20:29:02-23.375
20:30:02-23.312

Bash script:

# (...code...)
lastRecord=`cat /home/pi/scripts/temp_control/logs/"$today".log | awk 'END{print}'`

function rightNow {
  lastTemp=`echo $lastRecord | cut -d'-' -f2`

  timeOfTemp=`echo $lastRecord | cut -d'-' -f1` # Not used yet

  #Command used to update
  sed -i "s/['Temp', [0-9]\{1,2\}.[0-9]\{1,3\}]/$lastTemp]/" /var/www/rightnow.html
}

rightNow

• javascript
• sed

• Almost certainly. How is the text file structured? – Scott Sauyet Commented Sep 14, 2013 at 23:15
• Please add the last part (say the last 2..3 lines) of the file to your question. Also, is there also java involved? If not, delete that tag. Also, what environment runs the html-file? I'm guessing a browser, so please state what browser you use (since I'm guessing the txt file is a local file ?) ? – GitaarLAB Commented Sep 14, 2013 at 23:21
• @OneOfOne The errors are not erros themselves. The bash script that updates the html file, updates it with no value. Then the script (due to the way that sed mand was written) is not capable of updating the value again. So when the updater script updates it as "['Temp', ],]);" the sed mand can't replace the gap again with a new temperature value. – ederollora Commented Sep 15, 2013 at 18:39
• @ScottSauyet It's made this way: (new line)20:27:03-23.375 (new line)20:28:03-23.375 (new line)20:29:02-23.375 (new line)20:30:02-23.312 – ederollora Commented Sep 15, 2013 at 18:40

3 Answers 3

You cud get your file just like any other ajax request.

Using javascript

var request = new XMLHttpRequest();
request.open('GET', 'public_path_to_file.txt', false);
request.send();

var textFileContent = request.responseText

Using jQuery

var textFileContent;
$.get('public_path_to_file.txt', function(data) {
  textFileContent = data;
});

Whats left is to get the right part from textFileContent. Dependent of the structure of the file we can do this in different ways. Without an example file you are on your own but here is some examples.

If you need the last line

var lines = textFileContent.split("\n");
var lastLine = lines[lines.length - 1];

If you need to use regex

var regex = //* some regex to get your content*//gm;
var result = regex.exec(textFileContent);
// result should now the content who matches your regex

First I'll assume that you ultimately want to read a local file with your browser and your current workflow is something like a local 'bash-script' that

1. first updates/modifies an inline piece of javascript (inside a locally stored html file) with the last occurring value retrieved from a local txt-file (using sed)
2. opens the (just modified html-) file (via mandline) inside a mon browser.

Then I assume the sed-route once worked but now doesn't work anymore (probably because the html file has changed?) and now you'd like the inline javascript (in the html file) to fetch that value from the textfile itself and subsequently use it (thus without the need for the 'bash-script'/sed solution.

Thus, the answer (based on above assumptions) to your final question: 'is there any javascript code that takes that file, extracts the last value and simply displays it on the right place of the code?', depends on your final requirement:
are you ok with a file-input where you select the text-file every time you view the html-file?

If your answer is YES, then, (depending on the browser you use) you can read a local file (and work your magic on it's contents).
In modern browsers, using the File API (which was added to the DOM in HTML5) it's now possible for web content to ask the user to select local files, then read the contents of those files.

For example, using FireFox's 'FileReader' you could do:

html:

<input type="file" id="fileinput" multiple />

javascript:

function readAllFiles(evt){
    var files = evt.target.files, i = 0, r, f;
    if(files){
        for(; f = files[i++]; ){
            r = new FileReader();
            r.onload = (function(f){
                return function(e){
                    alert(e.target.result);
                };
            })(f);
            r.readAsText(f);
        }
    } else {
        alert("Error loading files");
    }
}
document.getElementById('fileinput')
        .addEventListener('change', readAllFiles, false);

  

Note that for accessing local files in Chrome you must start Chrome with this switch: chrome --disable-web-security

However,
if the answer is NO (so you want to specify the file, and more importantly it's path, inside the 'code', so you don't have to select the text-file every time your local app runs) then you (usually) can't (because you can't get/set the path, thank the great maker)...
Unless you choose a specific older/unpatched browser (specifically for this task) where you know of a (hack) way to do this anyway (like the IE xml vulnerability or the XMLHTTP vulnerability or etc... you get the picture..).

Some alternative solutions (that don't require you to select the correct textfile over and over again)

1. Setup a fullblown web (LAMP) server (to use the XMLHttpRequest way as used in aross answer, but this might feel like shooting at a mosquito with a cannon..)
2. Explore different script languages (but effectively still do the same as your now broken sed-solution)
3. Combine 1 and 2, choosing from php (the latest version has a small webserver included, you might start/stop it when needed (even in the bash-script workflow) OR using node.js (which is 'javascript' and where you can program/control a small task-specific server in just a couple of lines).

Hope this helps!

The browser will never see the php code, only what php inserted to your page (in this example the last found value or 0).

You'd rename the rightnow.html file to rightnow.php and modify it (something like) this:

<!DOCTYPE html>
<html><head>
  <!-- your header code -->

<script type="text/javascript">
//parts of your javascript

<?php                                // start php script
$logFile= '/pathToYour/logFile.log'; // <-Modify
if( $fp= @fopen($logFile, "r") ){    // if logfile succesfully opened,
    fseek($fp, -30, SEEK_END);       // set pointer 30 chars from EOF
    $val= array_pop(explode("-", rtrim(fread($fp, 30))));  //get last value
    fclose($fp);                     // close file
} 
?>                                   // end php script

function drawChart(){
  var data=google.visualization
                 .arrayToDataTable([ ['Label', 'Value'],
                                     ['Temp', <?php echo $val? $val : "0"; ?>],
                                   ]);     // ^php above inserts value or 0

  // etc...
}

//parts of your javascript
</script>

</head><body>

  <!-- your body code -->

</body></html>

Note that fopen in bination with setting the filepointer via fseek and sequentially fread-ing from the pointer to EOF does not load the plete logfile (60min * 24hour=1440 lines of 16 bytes=22.5kB at the end of the day) into memory (good for this purpose), but only the last 30 chars (as in this example).

The variable to your logfile and path must still be modified to your situation (I don't know the format of your $today variable).

Depending on your further needs you might want to perform some extra checks/logic on the array of values that explode returns (instead of popping the last value). Or what about modifying the html a little so you could also include the last temperature's time reading, etc. (But this tested piece of code should get you started and explains the procedure of going the php way).

So, instead of requesting http://url_to_my_rpi/file_to_download.txt, you could request http://url_to_my_rpi/read_last_temperature.PHP which should fetch the last known value out of the log-file (set proper security/access) and send it to the browser (set proper headers), just like your text-file did. You wouldn't have to change anything in the html/javascript except the url you request.

The advantage would be (depending on how your current bash-scripts works) that your PI now only does this 'work' (of getting the last value of your logfile) when you are viewing your monitor-page. And that you are not writing that file in your www-root every minute of every day (as I suspect).

The solution achieved, finally, was like this:

I did it with a jQuery statement and reusing the javascript code of Google Charts.

First I added javascript and jQuery tags in the html file:

<script src="//ajax.googleapis./ajax/libs/jquery/1.10.2/jquery.min.js"></script>
<script type='text/javascript' src='https://www.google./jsapi'></script>

Then I merged jquery code and javascript code that I had in one script:

<script type='text/javascript'>

  // Needed this var so that I could use it in other places of the code 
  var t;

  jQuery.get('http://url_to_my_rpi/file_to_download.txt',function(data){
  console.log(data)

  t=data;

  },'text');    

  google.load('visualization', '1', {packages:['gauge']});
  google.setOnLoadCallback(drawChart);
  function drawChart() {

    t=eval(t);

    var data = google.visualization.arrayToDataTable([
      ['Label', 'Value'],
      ['Temp', t],]);

   // (... more javascript with Google Charts options, display parameters..)

</script>

Finally, and even if it's not listed as the main question, be sure to enable *mod_headers* on your apache and add Header set to apache2.conf file (In my case: /etc/apache2/apache2.conf)

1) Enable the module:

a2enmod headers

2) Add the line on your configuration file

Header set Access-Control-Allow-Origin "*"

3) Restart apache 2

4) In case the 3 steps above didn't work, follow the instrcutions by entering in this website or reinstall apache2.