Okay
  Public Ticket #3718098
data updates
Closed

Comments

  • Ted Northrup started the conversation

    Will I need to subscribe to one of the premium options to make edits to this table?  I will have occasional need to update one of the cells or add a row. If the only way I can make a change is to re-import the Excel, then I will need to buy one of the premium packages. The next question would be which one?

  •  1,846
    Miloš replied

    Hi Ted,

    I can see this is a table linked to an Excel source.

    This table can not be made editable in our Plugin, even with the premium Plugin - but we do have easy ways to edit a table if you import the data from Excel;

    later on you will be able to upload an updated versio of the file to update that editable table, too.


    Here are more details to explain the difference between a 'linked table from Excel' and 'imported/editable table' :

    1. If you Create a table linked to an existing Excel file,

    5150506007.png

    if you choose to Create a wpDataTable and upload the Excel file :

     in which case you get to select the file (upload it) that'll be used to pull the data.

     This file will be stored in ../wp-content/uploads/YEAR/MONTH/ folder. 

    The file on that location can be changed/edited, but the column structure can't. 

    So, if you have the file with the same name,

     the same number of columns, same headers, and the same order of columns - you'd be able to replace the original file with the new file, and wpDataTables would pick that up automatically.


    Alternatively, if you select "URL from any domain"

    5896577008.png

    Creating a table linked to an Excel file by providing its URL is pretty much the same as it is for creating a table by uploading an Excel file. 

    The only difference is that you would choose the URL from any domain option instead of the WordPress Media Library option under File location when creating the table,

    and when you want to edit the source file,   you don't have to edit the one that is now in your Media Library folder, but you can edit the original source file which is connected with the Table.

    Please note:  For the option of “URL from any domain”, this source file needs to be accessible online in order to create a table from it, and the path to the file has to end with the file extention, for example with “.XLSX” or other Excel format. If the URL path to the source file does not end with a dot and its extension, it will not work.

    This table can not be edited from our Plugin.


    2. Or,  If you import the file, the plugin reads the source file and creates a manual table

    It makes a new 'stand alone' SQL Table in your Database with its own set of columns and rows.

    4321063618.png

    Once the table is created, it is no longer linked to the source file, so changing data in the table will not show up in Excel or Google Spreadsheet, and vice-versa. 


    This table is fully editable in our Plugin.


    To modify this table for quicker editing, you can either switch to the Excel-like view

    and then select and copy the range of cells you want to paste from the source file, and paste it in the Excel-like view, 

    or you can import a new/edited CSV to update the table, as well, in the following ways :

    • Replace data within an existing table.
    • Add data to an existing table.
    •   Replace the entire table with new data.

    You can see more details on Updating manual tables from source files (CSV, Excel or Google sheet) here.


    And i just wanted to point out that you can try wpDataTables before purchasing

     on our sandbox Demo sites ( you can find links for the main plugin Demo,  

    as well as add-on Demos, in my signature),

    and there is a 15-day money-back guarantee period, 

    so if you purchase the plugin, you can safely fully test it out, and if it doesn't fit your needs you can request and receive a refund in that period. ( same goes for all plugins and add-ons)



    3. When it comes to choosing the right licence to have editable tables :

    You can compare the features between all Plans from Lite(free), then Premium versions from the Starter all the way up to the Developer Level, in the Plugin back-end Dashboard, under "Lite vs Premium".

    You can also see this on the pricing Page, but here in the Dashboard, we show more details about each specific feature, etc.

    If you don't have any installation now on your WordPress, you can easily see this on our Demo Sandbox Website.

    4723876837.png


    Let me know if you have any additional questions. smile.png

    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables