Embed images in word linked from external sources

It took me a while to realize how to embed images in word, linked to the external files. Normally this case arises when you open html files in word and save it. Amazingly you will find "Edit Links to Files" in such case. It would have been great to find that option while saving not in the internet.

On clicking that an option box will appear.

Select all the files, click "Break Link" and check "Save pictures in document". And you are done.

Auto-map Network drives

The command lines for connecting, disconnecting and mapping the network drive are trivia once you know them.

net use X: \\192.168.10.17\www

maps X: to 192.168.10.17\www

net use /DELETE X:

removes the mapped network drive

Now I can just run this batch file .. easy!

net use /DELETE X:
net use X: \\192.168.10.17\www

Samba Cheatmap

I created this mindmap for Samba Configuration using freemind- hence cheatmap. I am always baffled with what to do next. I find this very useful to move ahead while configuring.
First you create a group for accessing samba directory, add samba users and change their primary group to newly created group. This group is used to access the samba folder with directory mask and create mask set. Any user with this group will have read and write access to the folder. You have to open some ports for samba - i directly make change in iptables file. Command is recommended. In fedora, you also have to make changes in SELinux. Finally after making changes in the configuration file, start/restart the samba service.
You  may also download the pdf or freemind file from github.

Looping in bash for multiple operations

Just learned that bash also supports looping that can be used to do the multiple operations on the files in a given folder.

for old in *.png; do  convert $old `basename $old .png`.eps;done

converts all the png files in a given folder to postscript file.

If there are i1.png, i2.png and i3.png then expansion of above loop will be

convert i1.png e1.eps

convert i2.png e2.eps

convert i3.png e3.eps

Note there is space between $old and .png

Similarly renaming *.png to mt_*.png

for old in *.png; do cp $old my_.`basename $old .png`;done

Update: PHP eval is powerful indeed

I came up with a solution though not very elegant one to the options dependent looping, by using eval() function once more. Took time to came up with the solution, especially it's not very easy to debug, except for outputting the code to the screen before executing eval().

"Person A", "PROJECT"=>1, "COUNTRY"=>1, "HOURS"=>40),
  array("NAME"=>"Person A", "PROJECT"=>1, "COUNTRY"=>1, "HOURS"=>30),
  array("NAME"=>"Person A", "PROJECT"=>1, "COUNTRY"=>2, "HOURS"=>70),
  array("NAME"=>"Person A", "PROJECT"=>2, "COUNTRY"=>2, "HOURS"=>10),
  array("NAME"=>"Person A", "PROJECT"=>3, "COUNTRY"=>1, "HOURS"=>50),
  array("NAME"=>"Person B", "PROJECT"=>1, "COUNTRY"=>2, "HOURS"=>40),
  array("NAME"=>"Person B", "PROJECT"=>1, "COUNTRY"=>2, "HOURS"=>10),
  array("NAME"=>"Person B", "PROJECT"=>2, "COUNTRY"=>2, "HOURS"=>50),
  );
$expecteddata1 = array(
  array("NAME"=>"Person A", "HOURS"=>200),
  array("NAME"=>"Person B", "HOURS"=>100),
);
$expecteddata2 = array(
  array("NAME"=>"Person A", "PROJECT"=>1, "HOURS"=>140),
  array("NAME"=>"Person A", "PROJECT"=>2, "HOURS"=>10),
  array("NAME"=>"Person A", "PROJECT"=>3, "HOURS"=>50),
  array("NAME"=>"Person B", "PROJECT"=>1, "HOURS"=>50),
  array("NAME"=>"Person B", "PROJECT"=>2, "HOURS"=>50),
);

function groupData($input, $byOptions) {
  $str = "";
  foreach($byOptions as $option) {
    $str .= '[$row['.$option.']]';
  }
  $data = array();
  foreach($input as $rowid=>$row) {
    eval("@\$data".$str."['hours'] += ".$row['HOURS'].";");
  }
  
  $newdata = array();
  
  $str = ""; 
  $count = 0;
  foreach($byOptions as $option) {
    $str .= '"'.$option.'"=>"$id'.$count.'",';
    $count ++;
  }
  $str='array('.$str.'"HOURS"=>"$hours")';

  $count = 0;
  $forstr = 'foreach($data as $id'.($count).'=>$arr'.($count).') {';
  foreach($byOptions as $option) {
    if($count >= (sizeof($byOptions)-1))  {
      $forstr .= '$hours=$arr'.$count.'["hours"];';
      break;
    }
    $forstr .= 'foreach($arr'.$count.' as $id'.($count+1).'=>$arr'.($count+1).') {';
    $count++;
  }
  $forstr .= '$newdata[]='.$str.';';
  $count = 0;
  foreach($byOptions as $option) {
    if($count >= (sizeof($byOptions)-1))  {
      break;
    }
    $forstr .= '}';
    $count ++;
  }
  $forstr .= '}';
  
  //print $forstr;
  eval("$forstr");
  return $newdata;
}

$output1 = groupData($data, array("NAME"));
print ($expecteddata1 == $output1)?"Same":"Different Objects";

$output2 = groupData($data, array("NAME", "PROJECT"));
print ($expecteddata2== $output2)?"Same":"Different Objects";  
?>

PHP eval is powerful indeed!

I have this array probem.
A set of data

$data = array(
  array("NAME"=>"Person A", "PROJECT"=>1, "COUNTRY"=>1, "HOURS"=>40),
  array("NAME"=>"Person A", "PROJECT"=>1, "COUNTRY"=>1, "HOURS"=>30),
  array("NAME"=>"Person A", "PROJECT"=>1, "COUNTRY"=>2, "HOURS"=>70),
  array("NAME"=>"Person A", "PROJECT"=>2, "COUNTRY"=>2, "HOURS"=>10),
  array("NAME"=>"Person A", "PROJECT"=>3, "COUNTRY"=>1, "HOURS"=>50),
  array("NAME"=>"Person B", "PROJECT"=>1, "COUNTRY"=>2, "HOURS"=>40),
  array("NAME"=>"Person B", "PROJECT"=>1, "COUNTRY"=>2, "HOURS"=>10),
  array("NAME"=>"Person B", "PROJECT"=>2, "COUNTRY"=>2, "HOURS"=>50),
  );

which i want in this format

$expecteddata1 = array(
  array("NAME"=>"Person A", "HOURS"=>200),
  array("NAME"=>"Person B", "HOURS"=>100),
);

and also this,

$expecteddata2 = array(
  array("NAME"=>"Person A", "PROJECT"=>1, "HOURS"=>140),
  array("NAME"=>"Person A", "PROJECT"=>2, "HOURS"=>10),
  array("NAME"=>"Person A", "PROJECT"=>3, "HOURS"=>50),
  array("NAME"=>"Person B", "PROJECT"=>1, "HOURS"=>50),
  array("NAME"=>"Person B", "PROJECT"=>2, "HOURS"=>50),
);

The expected data need grouping among multiple numbers of options. Note the Total.

It took some time to come with the solution after working a bit with the powerful eval() function.

It's much easy to do the looping and grouping as follows

for($data as $rowid=>$row) {
  $newdata[$row["NAME"]] += $row["HOURS]; //gives the data required for $expecteddata1
  $newdata[$row["NAME"]][$row["PROJECT]] += $row["HOURS]; //gives the data required for $expecteddata2
}

which can be made to work for any number of options with
for first case $byOptions = array("NAME");
and for second case $byOptions = array("NAME", "PROJECT");

$str = "";
  foreach($byOptions as $option) {
    $str .= '[$row['.$option.']]';
  }
  $data = array();
  foreach($input as $rowid=>$row) {
    eval("@\$data".$str."['hours'] += ".$row['HOURS'].";");
  }

and next loop through $newdata and generate the expecteddata. This part of code needs to be refactored. If any of you can come up with good solution to remove the options dependent looping, it would be great. [update: I came up with solution in next post that eliminates the options dependent looping using eval]

function groupData($input, $byOptions) {
  $str = "";
  foreach($byOptions as $option) {
    $str .= '[$row['.$option.']]';
  }
  $data = array();
  foreach($input as $rowid=>$row) {
    eval("@\$data".$str."['hours'] += ".$row['HOURS'].";");
  }
  
  $newdata = array();
  foreach($data as $id=>$arr) {
    if(isset($arr['hours'])) {
      $newdata[] = array($byOptions[0]=>$id, 'HOURS'=>$arr['hours']);
    } else {
      foreach($arr as $id1=>$arr1) {
        if(isset($arr1['hours'])) {
          $newdata[] = array($byOptions[0]=>$id, $byOptions[1]=>$id1, 'HOURS'=>$arr1['hours']);      
        } else {
          foreach($arr1 as $id2=>$arr2) {
            $newdata[] = array($byOptions[0]=>$id, $byOptions[1]=>$id1, $byOptions[2]=>$id2, 'HOURS'=>$arr2['hours']);     
          }
        }
      }
    }
  }  
  return $newdata;
}

Test the function. It should work.

$output1 = groupData($data, array("NAME"));
print ($expecteddata1 == $output1)?"Same":"Different Objects";

$output2 = groupData($data, array("NAME", "PROJECT"));
print ($expecteddata2== $output2)?"Same":"Different Objects";  

Split big image to two in Latex with ease

If you have one large image that doesn't fit in your page, then you open some photo editor, split the image into two and put those images in two images. Nice! Now your text gets edited (added, removed, updated) and the split images do not seem to fit as they were. You again open up image editor and do the process, hoping that no more edits are required.

You are in luck if you are latex user, you can just change some numbers and split the image on the fly without having to tinker with image editors.

(0,1500)                (600,1500)

 ---------------------
|                               |

|                               |

|                               |

 ---------------------

(0,900)                  (600,900)

 ---------------------

|                               |

|                               |

|                               |

 ---------------------

(0,0)                     (600,0)

First display the first half image with the coordinates(0,900) and (600,1500).

\begin{figure}[h]
 \centering
  \fbox{
   \scalebox{0.5}{\includegraphics*[viewport=0 900 600 1500]{large_image.png}}
  }
\end{figure}

Now display the second part of the image.

\begin{figure}[h]
 \centering
  \fbox{
   \scalebox{0.5}{\includegraphics*[viewport=0 0 600 900]{large_image.png}}
  }
 \caption{Caption only here}
 \label{Label only here}
\end{figure}