Kayako logo
Modifications & Addon Releases Modification guides and addons are posted here to share with the community. Do not post requests in here!

Notices

Reply
 
LinkBack Thread Tools Search this Thread Rating: Thread Rating: 13 votes, 5.00 average. Display Modes
  (#46) Old
KrisW Offline
New Member
 
Posts: 20
Join Date: Nov 2008
Location: United Kingdom
12-11-2008, 02:15 PM

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


Technical Consultant
Hugh Symons Communications
www.yourhsc.com
   
Reply With Quote
  (#47) Old
KrisW Offline
New Member
 
Posts: 20
Join Date: Nov 2008
Location: United Kingdom
20-11-2008, 08:40 AM

Quote:
Originally Posted by KrisW View Post
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


Technical Consultant
Hugh Symons Communications
www.yourhsc.com
   
Reply With Quote
  (#48) Old
Matthew Offline
Member
 
Matthew's Avatar
 
Posts: 197
Join Date: Oct 2007
Location: Jakarta, Indonesia
24-11-2008, 10:49 AM

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(30$cache.$filename.".bmp",0,0);                      
             
             
//    Title color
                
$workbook->setCustomColor(14165194240);
                
$formatot =& $workbook->addFormat();
                
$formatot->setFgColor(14);    
                
$formatot->setSize(10);
                
$formatot->setAlign('center');
                
$formatot->setColor('white');
                
$formatot->setPattern();
                
            
//    cell color
                
$workbook->setCustomColor(15247250255);
                
$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');     
        }



Matthew Arciniega
+ Free: Ticket List & Search Mods
| Dept. Display Names
+ Free: (Almost) Perfect Outlook/HTML Tickets
+ Tutorials: SLA System Explained
| Using Template Groups
Kayako v3.20.02 | PHP: 5.2.6 | MySQL: 5.0.58 | CentOS 4
   
Reply With Quote
  (#49) Old
Dewak Offline
Member
 
Dewak's Avatar
 
Posts: 151
Join Date: Feb 2008
22-12-2008, 03:54 PM

Thanks for the share Matthew!


Andres Berdugo
Email & MSN: andres[at]dewak.com
Skype: andres.dewak
Dewak: Kayako Development, Consultancy and Support
http://www.dewak.com
   
Reply With Quote
  (#50) Old
zheka Offline
New Member
 
Posts: 23
Join Date: Oct 2007
02-01-2009, 09:37 AM

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
   
Reply With Quote
  (#51) Old
Dewak Offline
Member
 
Dewak's Avatar
 
Posts: 151
Join Date: Feb 2008
05-01-2009, 04:08 PM

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,


Andres Berdugo
Email & MSN: andres[at]dewak.com
Skype: andres.dewak
Dewak: Kayako Development, Consultancy and Support
http://www.dewak.com
   
Reply With Quote
Reply

Tags
excel, export, modification

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Free Autologon mod. (free download here) jc11 Modifications & Addon Releases 74 24-08-2008 10:43 PM
Free Office Status Module (Free modification) jc11 Modifications & Addon Releases 18 10-06-2008 10:18 PM
Crucial Paradigm - 15000MB-300GB - 50% MORE!, 50% Off YEARLY! + FREE WHMCS! crucial Offers 9 13-03-2008 02:04 AM
How to Export Ticket Lists/Info into MS Excel Nintendo Developers & Code 3 17-12-2007 12:33 AM
Branding free is NOT Branding Free! NC Software SupportSuite, eSupport and LiveResponse 10 29-09-2006 05:33 PM



Powered by vBulletin® Version 3.7.5
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
Help desk software by Kayako.


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48