Google maps MODULE GEOCODED COUNTS export leads empty file

Please help me.
I export all URLs leads in file but it is empty(full addresses in need of geocodeing information). This is file name Accounts_Addresses_20200126. Only this text i see inside: address,lat,lng. May be before export i must do this: Cron URL:
To process the geocoding requests it is recommended to setup a nightly Cron-Job. A custom entry point has been created for this purpose and can be accessed without authentication. The URL shown below is meant to be used with an Administrative Scheduled Task. Please see the documentation for more information.
./index.php?module=jjwg_Maps&entryPoint=jjwg_Maps&cron=1

GEOCODING TEST
Address:
Bulgaria Yambol 8600 Panaiot Volov 19

Array
(
    [results] => Array
        (
            [0] => Array
                (
                    [address_components] => Array
                        (
                            [0] => Array
                                (
                                    [long_name] => Yambol
                                    [short_name] => Yambol
                                    [types] => Array
                                        (
                                            [0] => locality
                                            [1] => political
                                        )

                                )

                            [1] => Array
                                (
                                    [long_name] => Jambol
                                    [short_name] => Jambol
                                    [types] => Array
                                        (
                                            [0] => administrative_area_level_1
                                            [1] => political
                                        )

                                )

                            [2] => Array
                                (
                                    [long_name] => Bulgaria
                                    [short_name] => BG
                                    [types] => Array
                                        (
                                            [0] => country
                                            [1] => political
                                        )

                                )

                        )

                    [formatted_address] => Yambol, Bulgaria
                    [geometry] => Array
                        (
                            [bounds] => Array
                                (
                                    [northeast] => Array
                                        (
                                            [lat] => 42.5067417
                                            [lng] => 26.5412634
                                        )

                                    [southwest] => Array
                                        (
                                            [lat] => 42.4475374
                                            [lng] => 26.4646359
                                        )

                                )

                            [location] => Array
                                (
                                    [lat] => 42.4841999
                                    [lng] => 26.5035023
                                )

                            [location_type] => APPROXIMATE
                            [viewport] => Array
                                (
                                    [northeast] => Array
                                        (
                                            [lat] => 42.5067417
                                            [lng] => 26.5412634
                                        )

                                    [southwest] => Array
                                        (
                                            [lat] => 42.4475374
                                            [lng] => 26.4646359
                                        )

                                )

                        )

                    [partial_match] => 1
                    [place_id] => ChIJtRC3Vik0pkARaluYYwp8F_Q
                    [types] => Array
                        (
                            [0] => locality
                            [1] => political
                        )

                )

        )

    [status] => OK
)

Hi, welcome to the Community! :tada:

Do you have any errors in your logs while attempting the export that appears blank, with no data?

@Vlado, Are you able to resolve this issue. @pgr We have Suitecrm 7.13, under ‘MODULE GEOCODED COUNTS’ we are getting table but headers are missing.

We don’t have errors in any log files.

2 Likes

Thank you so much @pgr

To get back headers for table. We’ve replaced code lines in our file(view.geocoded_counts.php) using code from below GitHub link.

Lines 31 to 63

 echo '<div class="list-view-rounded-corners">';

        echo '<table cellspacing="0" cellpadding="0" border="0" class="list view" style="width: 50% !important;">';
        echo '<thead>';
        echo '<tr><th>'.$GLOBALS['mod_strings']['LBL_MODULE_HEADING'].'</th>';
        foreach ($this->bean->geocoded_headings as $heading) {
            echo '<th>'.$GLOBALS['mod_strings']['LBL_'.$heading].'</th>';
        }
        echo '<th>'.$GLOBALS['mod_strings']['LBL_MODULE_TOTAL_HEADING'].'</th>';
        echo '<th>'.$GLOBALS['mod_strings']['LBL_MODULE_RESET_HEADING'].'</th>';
        echo '</tr>'."\n";
        echo '</thead>';

        echo '<tbody>';
        foreach ($GLOBALS['jjwg_config']['valid_geocode_modules'] as $module) {
            $geocode_url = './index.php?module=jjwg_Maps&action=geocode_addresses&display_module='.$module;
            $reset_url = './index.php?module=jjwg_Maps&action=reset_geocoding&display_module='.$module;

            echo '<tr>';
            echo '<td><strong><a href="'.htmlspecialchars($geocode_url).'">'.$GLOBALS['app_list_strings']['moduleList'][$module].'</a></strong></td>';
            foreach ($this->bean->geocoded_headings as $heading) {
                echo '<td>'.($this->bean->geocoded_counts[$module][$heading] ?? "").'</td>';
            }
            echo '<td><strong>'.($this->bean->geocoded_module_totals[$module] ?? "").'</strong></td>';
            echo '<td><strong><a href="'.htmlspecialchars($reset_url).'">'.$GLOBALS['mod_strings']['LBL_MODULE_RESET_HEADING'].'</a.</strong></td>';
            echo '</tr>'."\n";
        }

        echo '</tbody></table>';

        echo '</div>';

        echo '<br /><br />';