Auto Update CSV Files with URL

Hi,

Won’t connect, Error: The source for the import is invalid or could not be accessed.

FYI I never added the code to the wp-config to limit the revisions. Is it possible that tablepress is looking at a revision after I change the file?

Hi,

no, I don’t think it’s looking at an old revision (TablePress technically doesn’t even know about revisions, they just exist). (I still recommend to add this to the wp-config.php then.)

Just to be sure: Did you adjust the server path to the correct user, etc.? You could also try the manual “File on server” import first (outside of the Auto Import Extension). This should show give you the first part of the server path, to which you might only have to add wp-content/<filename>.csv

Regards,
Tobias

I tried just about every file path I could think of with the main one being:
/home/”user”/html/wp-content/CSVFiles/A1-TestFile1.csv

I have been creating the import file first all the time. Should I not create the connect from the import first and just start with the auto import? Will try

Shawn

cont.
Well you cant create the file from auto but I created a blank table then linked the URL from the CSV file to it in auto which was successful and it loaded the file. Then I manually changed the file and oddly for the first time FileZilla asked if I wanted to update the file on the server too. I said yes and it updated on the server. I resaved the auto configuration to see if changed it did not pull the new version of the file.

Hi,

ah, bummer ?? Too bad that doesn’t work either. Unfortunately, I’m out of ideas here, sorry.

Regards,
Tobias

I think there is a program or plugin that is restricting TablePress and Visualizer from accessing the server. Both plugins work fine when pulling from google docs. Going to try disabling some things that might be an issue or work with GoDaddy to create a test site with that server. Will keep you posted if I get anywhere.

Thanks for all your help.
Shawn

Hi,

thanks, that would be great!

Best wishes,
Tobias

Update,
A couple new things I have tried: First I deleted the test file off the server and then did a URL import from tablepress to the file. Amazingly, it pulled a test file that was at least three files older. Next I put the file back into the server and added the auto import to the file. It pulled the same old file. Next I tried a URL import of a new file which loaded fine. Then I changed the file on the server before adding it to the auto update which successfully connected but again pulled the original file. Going to start disabling plugins and see if anything changes. Also I did read something about server owner not matching wordpress user causing similar problems with permissions. Will look into that as well.

Hi,

this gets stranger and stranger every time…
Permissions issues could indeed be possible. Thanks for checking that as well!

Regards,
Tobias

Well I am still trying to figure out my server issues which now also includes any media files….However I found a work around which is better than downloading to the server. Since the files I update are on dropbox, I just shared the files and pointed Tablepress to the dropbox URL. So far works perfect and now I don’t have to mess with the FTP client everyday. If I ever find a server solution I will let you know. Thanks again for all your help.

Best,
Shawn

Hi Shawn,

awesome! Using Dropbox is a great idea, too!

Best wishes,
Tobias