Forum Replies Created

Viewing 15 replies - 1 through 15 (of 24 total)
  • I have a very rough and ready fix for this! As you can see the info in the filters is being sorted alphabetically rather than as numbers. Rather than look at a fix which will then break other filters, you can rearrange the numbers so that they will show in the right order. You can do that by adding leading 0’s into the numbers. So if your biggest number is in the thousands for example a low number like 12 would need to be displayed as 0012. Obviously this isn’t the best, but it does work and the filter becomes usable.

    I should add too that if you have large tables like me that I import from Excel, Excel will do this work for you. Just highlight the cells you want to format (all the numbers), right mouse click them and select Format Cells. In the format cells dialogue box, hit custom and type 0# for two digit, 00# for 3 digits, 000# for 4 digits etc. In my case I was using this to filters sizes up into their thousands, so I used 000#. You can then save the file as an CSV and import and everything should then be in number order. I guess if you really wanted to go to town you could write a script that runs at the end that then deletes all these leading 0’s.

    Thread Starter funkygorilla

    (@funkygorilla)

    Thanks RavanH, that worked a treat. I can move it on to the live site after a bit of styling now.

    I always forget those fancybox options tucked over there! Lesson learned!

    Thread Starter funkygorilla

    (@funkygorilla)

    Hi RavanH

    Thanks for the reply. That’s what I would have expected too. I used different code as follows: –

    <a class="fancybox"  href="#fancyboxID-5">Buy In-Store</a>
    ....
    <?php	
    echo "<!-- Electrical Wholesaler Location Map -->";
    echo "<div class=\"fancybox-hidden\" style=\"display: none;\">";
    echo "<div id=\"fancyboxID-5\" class=\"hentry\" style=\"width: 460px; max-width: 100%;\">";
    ?>
    <iframe src="https://www.electrical-wholesaler.com.au/location-map-for-iframe" style="width:100%;max-width:940px;height:900px;"></iframe>
    </div></div>

    This was seeming to load the iframe in the background, which was odd. I swapped over to your code and that is now live on https://brau.wpmudev.host/products/fr/ but you can see that this doesn’t open a fancybox window it just links straight through to the site (so the class isn’t working). Am I doing something wrong?
    Cheers

    Thread Starter funkygorilla

    (@funkygorilla)

    Hi Tobias

    Thanks, that worked a treat.

    Cheers

    Hi Chicsmart,

    I think I have an answer for you! I’ve just had the same issue in Australia and managed to fix it.

    When you enter your Google Maps Javascript API V3 Key (public) on /wp-admin/options-general.php?page=wp_simple_locator, Simple Locator must just take that as a variable and add it to the normal Google maps link. As luck would have it, following that key in their code, you can add a variable to set a default country code. I added the following after my key: –

    &region=AU

    Once I had done that, my searches default to Australia, so it picks post codes and locations a lot better than the default.

    To find your country code, use http://www.nationsonline.org/oneworld/country_code_list.htm. Yours should be ES, so your code should be something like: –

    YOUR_API_KEY&region=ES

    Hope this works for you. I’ll add it as a seperate localisation post too as I’m not sure the author is working on this anymore, which is a shame as I would have paid for more features.

    Cheers
    Funkygorilla

    Hi Guys,
    I’m just looking at this plugin but I would need a URL replacement too. Did this ever happen?

    Thread Starter funkygorilla

    (@funkygorilla)

    Hi,

    That’s a tricky one! It was only this particular site that had issues. Even the staging site didn’t. It might be something to do with the HHVM server configuration (which we don’t have in staging). We had a lot of trouble with HHVM after a server move and have eventually removed it completely.

    What I might do is try the update again late one night next weekend and see what happens. I’ll let you know if it falls over again!

    Cheers

    Thread Starter funkygorilla

    (@funkygorilla)

    Hi,

    I can confirm that it’s this latest update that causes this problem. I rolled back to the 3.0.10 version and all seems ok.

    Cheers

    Thread Starter funkygorilla

    (@funkygorilla)

    After switching themes and all the other things that we were supposed to do, all with no luck, I noticed that the latest WordPress update included a fix for Oembed and I can confirm that it now seems to work.

    I occasionally seem to need to add the ‘[embed] [/embed]‘ shortcode around links to get it to recognise it, but apart from that the problem seems to be solved for the moment at least.

    Thread Starter funkygorilla

    (@funkygorilla)

    Hi Ronniej6987,

    I’m still try to get through this one! Could you tell me what theme your site uses? I’ve seen a few reports about switching themes, then going back again. I use a child theme on top of twenty twelve and was wondering if you had something similar? I’ve tried going to just twenty twelve (as I don’t have any other themes installed) and that doesn’t work, but I’m just wondering whether I should try adding a theme, then switching to it and back again!

    Cheers
    Simon

    Hi Tobias,

    That’s what I thought too. I was wondering whether the way dropbox duplicates in chunks rather than files might not show that an update had taken place, but I have also tried a static location with no luck either.

    Do you think looking at alternate file formats apart from csv would make a difference?

    Cheers
    Simon

    I have just tried moving the file to a different location too and that one didn’t work either.

    Hi Tobias,

    I’ve just deleted the old table, then imported it in again with no issues. I then set up auto import on this single table making sure it was set to CSV and gave it the same url on dropbox public folder.

    After that I have run the cron manually and get a response that it has “Successfully executed the cron event tablepress_table_auto_import_hook”. All looks good at this point except that the table stays the same.

    I have the cache switched off, I have tried looking in a different browser and in incognito mode, still it is the same. Memory is now showing as
    · WP Memory Limit: 40M
    · Server Memory Limit: 512M
    So that all seems good, but I can up it more if you want. We are actually on a VPS running 6GB of memory, so that shouldn’t be an issue.

    I have tried the auto import on other sites too with no luck, although these are on shared hosting with low memory.

    Any other ideas? I’d really like to get this running on one of this companies sites at least, but at the moment I am really struggling with it.

    Thread Starter funkygorilla

    (@funkygorilla)

    Any ideas on this anyone? It’s driving me nuts! Some sites seem to work and others don’t and there doesn’t seem to be anything that I can see that is common to them all.

    Hi Tobias,

    Sorry for the delay in getting back to you. I had various issues to fix but seem to have them all working now.

    – Cron jobs – These weren’t running at all, so my host has now fixed these up and I can confirm that they are running. Other plugins like Wordfence are running automatically, but tablepress auto import (tablepress_table_auto_import_hook) seems to refuse to run at regular intervals. – I seem to have fixed this now, so it is running hourly.

    – Memory – Both tablepress and wordfence were reporting a lot less memory than the site has available. I wasn’t able to set this as normal, but changing the default values seemed to allow WordPress to report more memory to the plugins and both now show 512MB (HHVM actually gives it 6GB).

    Having said all that, I am still nowhere further forward. I could see if I can get the host to sort out cron on the server as the links above, but as I can now run this one manually, all others run ok and I still get nothing, I’m not sure that is really the problem. Have you any other thoughts on what it might be?

    Wp-Cron is showing that I am running the following: –
    Hook name: tablepress_table_auto_import_hook
    Arguements: []
    Next Run: 2016-05-16 03:12:16
    Event Schedule: Once Hourly

    Is there anywhere I can see what is actually running to make sure that isn’t corrupted or anything?

    Cheers
    Simon

Viewing 15 replies - 1 through 15 (of 24 total)