Auto Import

  • Resolved ganaxi

    (@ganaxi)


    11 years, 9 months ago

    Hi Tobias,

    Sorry if this is too basic of a question.

    I have installed your Auto Import Extension, to have one or two of the columns in all 130+ Tables update once a day. Here is my problem.

    So far I import CSV files directly from my PC into TablePress, and then use the short-code to display the Table on the site, and thanks to your plugin, everything works beautifully.
    https://www.gurufundpicks.com/indrpt-4q2-guru-sample

    When trying to use the Auto Import extension plugin, it asks me for the https:// address of the source (CSV) file. I have never updated the excel CSV files to my server before to use TablePress (or WP-Tables), so I am unsure of the next step. I have used FileZilla, e.g., to update server files, but I don’t know what specific directory to put the TablePress CSV files in. I want to make sure that I don’t mess up the database by uploading to the incorrect directory.

    Also, the way it would work is, the stock prices, e.g., would be in one specific file, updated once a day manually, and all other files/tables would be pulling the price info from that file to update specific columns in all 130+ Tables. I am assuming that this would be possible, once I uploaded the Tables, but please let me know if there is a fatal flaw with this plan.

    Thanks,

    Ganaxi

    https://www.ads-software.com/extend/plugins/tablepress/

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

    (@tobiasbg)

    Hi,

    thanks for your question.

    Unfortunately, the “fatal flaw” as you call it, is that this will not work like this. You can not update multiple tables from a single file, as the auto import process can not pick individual columns from a file, but only import the entire table.
    So, for 130+ tables to auto-update, you would need to upload/maintain 130+ files on the server.

    To obtain that URL that is needed: You can upload the CSV files to almost any folder on the server, I recommend a new folder inside the “wp-content” folder, like “csvfiles”. The URL would then be https://www.example.com/wp-content/csvfiles/filename.csv
    But as mentioned above, this will not work with the workflow that you have in mind. Sorry. ??

    Regards,
    Tobias

    Thread Starter ganaxi

    (@ganaxi)

    Hi Tobias,

    Thanks for the response.

    I wasn’t meaning for auto-import to pick a single column, but rather the whole table, for all 132 tables. So, let me clarify.

    So, in the example table linked above, there is a column on fund holding, that relies on the price of the underlying stock. What changes everyday (for simplification) is really just the price, as the no. of shares held would be updated end-of-quarter.

    My idea was to have an equation for each cell in that ‘fund holding ($)’ column, as in,

    No. of shares (from another col. in same table) * Price (from the daily updated table).

    So, the idea, was that when the TablePress did the auto-import on all 132 tables once a day, it would import new values for that column based on the latest price info, based on the equation in that column.

    If that makes sense, would you still say that it is a fatal flaw?

    Thanks,

    Ganaxi

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    yes, there still is a flaw. Formulas can not reference cells from other tables.

    So, while the auto import part of the 132 tables from 132 different files should work, that formula part will not really work (except if you use a trick with another Shortcode for the single cell content).

    Something like this is really better be done in a real database solution.

    Regards,
    Tobias

    Thread Starter ganaxi

    (@ganaxi)

    Thank you, Tobias.

    I will mark this as resolved.

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    alright. Sorry that I didn’t have a solution here.

    Best wishes,
    Tobias

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Auto Import’ is closed to new replies.