• Resolved sbing

    (@sbing)


    Beginner Question: I want to use the TablePress auto update via URL but I have no idea how to link my CSV files to (or as?) a URL. I’m sure this is pretty straight forward but I cannot find it in the forums. Just for clarification, I need to update the entire table from the CSV file not just a single cell. The CSV files are created via Excel.

    Thanks in Advance,
    sbing

    The page I need help with: [log in to see the link]

Viewing 11 replies - 31 through 41 (of 41 total)
  • Thread Starter sbing

    (@sbing)

    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?

    Plugin Author TobiasBg

    (@tobiasbg)

    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

    Thread Starter sbing

    (@sbing)

    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

    Thread Starter sbing

    (@sbing)

    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.

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

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

    Regards,
    Tobias

    Thread Starter sbing

    (@sbing)

    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

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    thanks, that would be great!

    Best wishes,
    Tobias

    Thread Starter sbing

    (@sbing)

    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.

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

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

    Regards,
    Tobias

    Thread Starter sbing

    (@sbing)

    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

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi Shawn,

    awesome! Using Dropbox is a great idea, too!

    Best wishes,
    Tobias

Viewing 11 replies - 31 through 41 (of 41 total)
  • The topic ‘Auto Update CSV Files with URL’ is closed to new replies.