Exporting from Synolia Reports

[robert_f]

Hi All

Hope someone can assist and that I've posted this in the right place!

I have installed Sugar CE (Windows 2008 / MS SQL 2008) & added Synolia reports as a module. I have been experiencing a problem whereby if the query in Synolia returns more than approx 10-15 records then when trying to export the report to CSV the system just "hangs" & eventually I get a page timed out error.

I've tried exporting large lists e.g. all contacts which is approx 70 records with no problems, the issue only appears when exporting from Synolia.

Hope someone can help, thanks in advance.

Rob

[cmourizard]

Hello Rob,

Thanks for using our module.
We don't have any problems to extract data by Export Buttons. By example, I can extract all customers with success.

Do you have complex query ?
What are your PHP settings like memory_limit and execution_time_out ?

PS: I haven't test on MSSql server, but we use standard SugarCRM database access method...

[robert_f]

Hi

Thanks for getting back to me ... the query is quite complex. I've attached to this post.

I have ran a query against the accounts table in Synolia and it is working fine even though its pulling back a lot of records, it just appears to have a problem with the query I've set up ... hope you can spot where the fault lies in my code!

Once again, thanks for the help.

Regards

Rob

[cmourizard]

Hello Rob,

I think that your query is very slow (isn't appear in slow query log ?)

• One way to follow is to add index on your database to optimize the result.
• An other way is to growth up your PHP settings like memory_limit and execution_time_out

[robert_f]

Hi, thanks for taking a look.

If I run the query direct in MS SQL query manager it runs in under a second so I dont think its because its running slow. With regards the PHP settings these are currently set to :

max_execution_time = 60 ; Maximum execution time of each script, in seconds
max_input_time = 60000 ; Maximum amount of time each script may spend parsing request data (also increased this one)
memory_limit = 256M ; Maximum amount of memory a script may consume (128MB) (I've increased this from 128MB)

Are these acceptable values do you think?

Many thanks for your help.

Rob

[cmourizard]

Hello,

You can try with this setting, if it's OK, you should modify file modules/SYNO_Reports/SYNO_Reports.php, at the beginning of method create_export_query, add ini_set with your good configuration to override php setting only in this case.

[robert_f]

Hi,

You will have to excuse me I'm not particularly good with PHP, I'm setting this up for a friend .... could you be more specific on the entries I need to make in the syno_reports.php file? I dont understand what is meant by "add ini_set with your good configuration to override php setting only in this case".

Thanks for your patience.

Rob

[robert_f]

Hi

Managed to get this rectified based on another post on the forums with a similar issue ...

http://www.sugarcrm.com/forums/showt...640#post199640

I actually had to comment out the same line but the file was called export.php and was located in the root folder of the sugar site.

Many thanks for your help with the above.

Cheers

Rob

[cmourizard]

If your php settings resolve your problem, you can try to modify file module/SYNO_Reports/SYNO_Reports.php to add this line

          if (isset($line['description'])) {
            @set_time_limit(60);
            @ignore_user_abort(TRUE);
            ini_set("memory_limit", "256M");
            ini_set("max_input_time", "60000 ");

            return $line['description'];
          }

to replace these original lines

          if (isset($line['description'])) {
            return $line['description'];
          }

[robert_f]

cmourizard, many thanks for all your help on this!

I tried just using the code alterations you suggested but still had the same issue unfortunately. When I went back and commented out the line in export.php it worked fine again.

However, I was having a problem with a "larger" version of my query running which your code changes in conjunction with the line commentted out in export.php seemed to cure.

Once again many thanks for your assistance.

Regards

Rob