• Resolved HAYMAKER

    (@haydendarcy)


    When I upload via server it does not work.

    /public_html/wp-content/uploads/2017/06/DER.csv [Read from Filezilla]
    Thats the file I want to upload. It worked at random and then it hasn’t worked ever since.

    My other question is there a way to auto import every 30 seconds?

    Apologies if there is duplicate I think I posted in the wrong area.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    thanks for your question, and sorry for the trouble.

    Can you elaborate what “doesn’t work” means here? Do you get error messages?
    Something like this usually indicates file access rights problems on the server.

    An auto-import each 30 seconds is not really possible, as the WP Cron system is not the best for that. You could try modifying the PHP code of the TablePress Extension to add such a short interval, but would then also have to configure a real server cron job, similar to https://www.iceablethemes.com/optimize-wordpress-replace-wp_cron-real-cron-job/
    In addition, I highly recommend to set the WP_POST_REVISIONS constant in the wp-config.php file to a small number (see https://codex.www.ads-software.com/Revisions#Revision_Options ) to not fill your database.

    Regards,
    Tobias

    Thread Starter HAYMAKER

    (@haydendarcy)

    Hi thank you for your suggestions. I get: Error: The source for the import is invalid or could not be accessed.
    So the directory clearly isn’t matching FIlezilla. I tried put CSV in/public_html/Hahaha.csv and simply typed HAHAHA.csv and Tablepress read it. Not sure how I’d be able to get Tablepress to read other locations though and my Public_HTML file will get clogged up pretty quick

    I have also tried modifying the cron file and the files I have to change. The lines that I have to change don’t even seem to exist. Here’s the exact file to show you what I mean
    https://www.dropbox.com/s/usghthl4erm4nrb/wp-cron%20BACKUP.1php.txt?dl=0
    I believe you have an addon for modifying the PHP of Tablepress, correct? I’m not really sure how I’ll go about modifying that either but I’ll get there. I remember reading over that addon and you said it was unsafe or something.

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    TablePress should be able to read files that are below/inside the ABSPATH, which is the main folder where the WordPress files live on the server.
    That value for ABSPATH should also be the default value in the text fields on the configuration screen for the Auto Import.
    Unfortunately, it’s hard to debug this from externally ??

    Regarding the file modifications: I did not mean the WordPress cron PHP file here, but the tablepress-table-auto-update.php file.

    Regards,
    Tobias

    Thread Starter HAYMAKER

    (@haydendarcy)

    Thank you for your suggestions. I used the wordpress editor and I believe I can easily change the values for the time between each import. I am not sure how to adjust the WP_POST_REVISIONS and WP Cron system. Could you clarify some more. Am I to add [pre]define(‘DISABLE_WP_CRON’, true); to wordpress editor? I apologise for not understanding fully

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    these two constants need to be defined in the wp-config.php file on your server, see https://codex.www.ads-software.com/Editing_wp-config.php

    Regards,
    Tobias

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘When I upload via server it does not work.’ is closed to new replies.