Free Export To Excel (Free Modification)

[KrisW]

Andres,

I have sent you another email and CC'd in the info address also.

I look forward to hearing from you soon.

Many thanks for your continued support.

Kris

[KrisW]

Originally Posted by KrisW

Andres,

I have sent you another email and CC'd in the info address also.

I look forward to hearing from you soon.

Many thanks for your continued support.

Kris

I want to just update everyone here.

Many thanks to Andres who helped my IT Network Manager quickly and effectively. Between we had our issue resolved within 2 hours.

We are now running Export to Excel with out any issues.

Thank you for your support.

Kris

[Matthew]

For anyone using the versions of this mod which include the Department Summary (dwk_excel_department.php), and you find that it simply doesn't work, then you can try two things:

First, make sure that ImageMagick is installed (thanks to Carlos Orozco at Dewak for pointing this out, albeit a bit late ). This is needed to convert jpg files generated by jdgraph into bmp files.

Second, patch your dwk_excel_department.php file by replacing the entire function makeGraphic with the following code. As it says in the comment, this will fix problems with extraction of department names from the department cache and will replace the '&' character in jpg file names, since ImageMagick can't seem to process these.

Took me ages to figure this out. Enjoy.

PHP Code:

// Modified by Matthew Arciniega
// Corrects problems with extraction of department names from the department cache
// Also replaces '&' character in jpg file names, since ImageMagick can't seem to process these
function makeGraphic($workbook,$departmentid, $result)
{
    global $dbCore, $_SWIFT;    
      $cache = './cache/'; // relative or absolute path to a cache folder, depending on your needs
      $departmenttitle = $_SWIFT["departmentcache"][strval($departmentid)]["title"]; // extract department title
      $filename = preg_replace("/&|\s/","",$departmenttitle); // ImageMagick can't process '&' chars
      
        $index = 1;
        $xsort = array();
        $ysort = array();
        
        $_stat = $result[0];
        $_statstatus = $result[1];
        $_statdep = $result[2];
        
      if (_is_array($_stat[$departmentid]))
        {
            foreach ($_stat[$departmentid] as $key=>$val)
            {
                $_chartindex[] = $key;
                $_chartvalue[] = $val;
                $index++;
            }
            
            $xsort = $_chartindex;
            $ysort = $_chartvalue;
            
            sort($xsort);
            reset($xsort);
            
            sort($ysort);
            reset($ysort);
            
            $ymin=$ysort[0]-1;
            $ymax=$ysort[count($ysort)-1]+1;    
            
            $graph = new Graph(750,250);

            $graph->SetScale('intint', $ymin, $ymax);
            $graph->img->SetMargin(20,20,20,40);    
            $graph->SetBox(true,'green',2);
            $graph->SetMarginColor('white');
            $graph->SetColor('white');
            $graph->SetFrame(true);
            $graph->SetBox(true);
                
            $graph->xaxis->SetTickLabels($_chartindex);
            $graph->xaxis->HideTicks(false,true);

            
            $graph->ygrid->Show();            
            $graph->ygrid->SetColor('black');
            
            $graph->yaxis->SetColor('black');
            $graph->yaxis->HideTicks(false,true);
            
            $p1 = new LinePlot($_chartvalue);
            $p1->SetColor('#0000FF'); 
            $graph->Add($p1);
            
            $graph->Stroke($cache.$filename.".jpg");
            
            // LO UNICO QUE TE INTERESA ES ESTO, COJES LA IMAGEN EN JPG Y LA CONVERTIS A BMP CON ESTO
            $output = shell_exec('convert '.$cache.$filename.'.jpg '.$cache.$filename.'.bmp');
            
             // Creating the first worksheet
             $worksheet =& $workbook->addWorksheet($departmenttitle);
             $worksheet->insertBitmap(3, 0, $cache.$filename.".bmp",0,0);                      
             
             //    Title color
                $workbook->setCustomColor(14, 165, 194, 240);
                $formatot =& $workbook->addFormat();
                $formatot->setFgColor(14);    
                $formatot->setSize(10);
                $formatot->setAlign('center');
                $formatot->setColor('white');
                $formatot->setPattern();
                
            //    cell color
                $workbook->setCustomColor(15, 247, 250, 255);
                $formatot1 =& $workbook->addFormat();
                $formatot1->setFgColor(15);    
                $formatot1->setSize(10);
                $formatot1->setAlign('center');
                $formatot1->setColor('black');
                $formatot1->setPattern();
                
                $worksheet->writeString(0,0,$departmenttitle." (". intval($_statdep[$departmentid]) .")",$formatot);
                
                $index = 0;
                foreach ($_SWIFT["statuscache"] as $statkey=>$statval)
                {
                    $worksheet->setColumn($index,$index,15);
                    $worksheet->writeString(1,$index,$statval["title"].": ".intval($_statstatus[$departmentid][$statval["ticketstatusid"]]),$formatot1);                    
                    $index++;
                }
                
            unlink($cache.$filename.'.jpg'); 
            unlink($cache.$filename.'.bmp');     
        }
} 


[Dewak]

Thanks for the share Matthew!

[zheka]

Hi folks,
Can someone share this mod? I believe it won't be against any copyright? Keep waiting for guys from dewak to answer my request but no luck yet.

Eugene

[Dewak]

Hi, please do not share this mod. This module is copyrighted by us and we are the only one authorized to distribute it.

We always reply to free mod requests in less than 24 hours. Sometimes email filters or firewalls block the attachment so you might have to check your email client. Just send me us an email once again and provide us an alternate email address. Awaiting for your email.

best regards,