Hi,
thanks for your question, and sorry for the trouble.
Where are you CSV files stored now? On your computer?
You would then have to upload them to some server/website, e.g. to your site’s wp-content directory, via an FTP program.
Regards,
Tobias
Thread Starter
sbing
(@sbing)
Thanks Tobias,
The files are stored on my computer. Can I use Filezilla to upload the files? Again, I’m a beginner at this stuff so sorry if these are dumb questions.
Shawn
Thread Starter
sbing
(@sbing)
OK, All good with moving files with Filezilla, where in the wp-content directory should I put the files? I see three different tablepress directories under plugins or is there a database location?
Thanks
Hi,
You would upload them to “wp-content” directly, or to a newly created “tables” sub folder there, is my recommendation.
After that, the CSV files are available as a URL at http://www.your-site.com/wp-content/tables/filename.csv
Now, just to be sure: Why don’t you simply use the “File Upload” method to import the CSV file into TablePress? I don’t yet see why you want to use the Extension.
Regards,
Tobias
Thread Starter
sbing
(@sbing)
Tobias,
Thanks, what I am trying to do is have the ability for my CSV files which I update every day to auto update in Table Press without having to manually load each one. I will probably have close to 100 different tables when my site is complete. The CSV files are updated from Excel programs and I don’t want to switch to Google sheets. Each table is replaced by the new version each day. Perhaps there is a better way to do this? I have loaded the files into wp-content with FileZilla but the URL loads as an ftsp:// file not http://. Can’t seem to get TablePress to recognize the files. Also I’m not even sure if the files I upload will update when I change them each day or if I will have to reload from FileZilla each day?
Shawn
Hi,
okay, that makes sense, and you can use the Extension for this.
You can ignore the ftps:// URLs here, just construct the URLs as per my scheme above.
You would then indeed have to upload all changed CSV files again via FileZilla after making changes to them.
Regards,
Tobias
Thread Starter
sbing
(@sbing)
That worked! Thanks for all your help.
Hi,
no problem, you are very welcome! 🙂 Good to hear that this helped!
Best wishes,
Tobias
P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!
Thread Starter
sbing
(@sbing)
Tobias,
Sorry to bother you again, but I am still having an issue. I was able to connect the URL to TablePress and it shows that it is successful. It seems to work fine until I update the CSV file. When I overwrite the files with FileZilla to the remote site TablePress does not update as scheduled even though connection is successful. I am not changing the name or moving into another directory. I am using http://www.your-site.com/wp-content/tables/filename.csv as you suggested even though the actual path has my host, username etc.. Any suggestions? FYI, I am having the same issue thru Visualizers auto update.
Thanks
Shawn
Hi,
have you installed and activated the TablePress Auto Update Extension? Did you configure the URL for each table? This is mandatory for this to work.
I’m not sure what “Visualizers auto update”, so I can’t really help with that.
Regards,
Tobias
Thread Starter
sbing
(@sbing)
Yes I have the TablePress Extension: Table Auto Update. I also have Auto URL conversion that I did not realize, could this be changing the URL? Also, yes I have configured each table with the specific URL.
Thread Starter
sbing
(@sbing)
Here is what the URL looks like when I copy it to the clipboard directly from FileZilla.
sftp://[email protected]/home/user/html/wp-content/CSVFiles/Corn_OHLC.csv
I changed the actual user ID so it is not on this forum.
Hi,
The Auto URL conversion Extension has nothing to do with this, it serves a different purpose.
Don’t just copy the URLs from FileZilla. Those will not help. Please create them per the scheme above. Then try that URL in the browser and check if it offers you the CSV file for download.
Then, go to the “Import” screen of TablePress and configure the auto import for each table, each time pasting in the correct URL.
Regards,
Tobias
Thread Starter
sbing
(@sbing)
Hi,
Here is the exact URL I am pasting into the TablePress Auto Import.
https://absrresearch.com/wp-content/Corn_OHLC.csv
This works perfect until I update the CSV file and upload it with Filezilla. The file has uploaded correctly but Tablepress keeps pulling the old file version even though I directly overwrote the old file.
thanks
Thread Starter
sbing
(@sbing)
