Okay
  Public Ticket #3575286
can import google spreadshit
Closed

Comments

  • Giannoula started the conversation

    Hello i am trying to import a google spreadsheet and i follow your instructions ( https://wpdatatables.com/documentation/creating-wpdatatables/creating-wpdatatables-from-google-spreadsheets/ ) but the problem is that i never fetch the data and the screen shows loading spinner. I see from my console the message


    Uncaught TypeError: Bootstrap's tooltips require Popper.js (https://popper.js.org/)
        at new t (bootstrap.min.js?ver=1.2.6:6:40556)
        at HTMLInputElement.<anonymous> (bootstrap.min.js?ver=1.2.6:6:49674)
        at Function.each (load-scripts.php?c=0&load%5Bchunk_0%5D=jquery-core,jquery-migrate,utils,moxiejs,plupload&ver=6.0.7:2:3003)
        at s.fn.init.each (load-scripts.php?c=0&load%5Bchunk_0%5D=jquery-core,jquery-migrate,utils,moxiejs,plupload&ver=6.0.7:2:1481)
        at t._jQueryInterface [as tooltip] (bootstrap.min.js?ver=1.2.6:6:49548)
        at Object.fillColumnsBlock (table_config_object.js?ver=6.1:1665:67)
        at Object.initFromJSON (table_config_object.js?ver=6.1:1486:28)
        at Object.success (main.js?ver=6.1:1609:44)
        at c (load-scripts.php?c=0&load%5Bchunk_0%5D=jquery-core,jquery-migrate,utils,moxiejs,plupload&ver=6.0.7:2:28327)
        at Object.fireWith [as resolveWith] (load-scripts.php?c=0&load%5Bchunk_0%5D=jquery-core,jquery-migrate,utils,moxiejs,plupload&ver=6.0.7:2:29072)

  •   Giannoula replied privately
  •  1,846
    Miloš replied


    Hi Giannoula,

    Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

    -

    You said you were importing a Sheet, but you sent the Documentation Page where we link a source Sheet to sync it with a Table.

    Can you please confirm, when you are trying to Create a new Table, are you choosing the option :

    Create a data table linked to an existing data source

    or the option :

    Create a data table by importing data from a data source?

    3408118849.png


    2. This error you are seeing, it is related to dropdown issue caused by Bootstrap Version conflict.

    Your current WP Theme probably has Bootstrap 4 or higher, while our Plugin currently is still using Bootstrap 3.

    That causes that error, that mentioned "popper.js" since Bootstrap 4 requires it.

    -

    Can you show me some screenshots or a Video, how far you get during Table creation?
    If you are linking a Table, it should load when you hit "Save Changes" after you insert the Google Sheet URL.

    But if you are importing the Sheet, then the dropdown Bootstrap issue could happen, since you need to choose from the Dropdown to open the generated Table in editor :

    7401199278.png
    9290978171.png

    So, to test if it is the dropdown Bootstrap conflict, you can change to any default WP Theme, then try to import your file again - let me know if it works with another Theme?


    3. Another issue it could happen, if you got too many rows in the source Sheet.

    Can you tell me how many rows it has?

    In regards to importing the data via  a file,

    Data that has more than few thousand rows can  sometimes not be imported in this way directly via the plugin ( depending on the server) - this is a limitation that is coming from WordPress itself combined with server performance.

    But there is a solution.

    What you can do is, if you get errors, and it does not work importing directly through our plugin,

     you can then import the file, in form of Excel, CSV, or spreadsheet directly in your database via your database management tool, such as PhPMyAdmin.

    And then you will be able to create a simple SQL query based table from this database table, by using this query (for example):

    SELECT * FROM table_1


    Let me know if that helps.

    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

  • Giannoula replied

    Hello Milos. Thanks for the reply. 

    1. I am using create a data table linked to an existing data source

    2. I found the problem and solved it. Popper js wasnt loading right. I solved it and i am ok with the link

    However i am facing some other issues


    The first one is that i hit duplicate in browse Tables page ( wpdatatables option ) and nothing happens. I checked the console for errors but nothing pops up. So i tried looking at the code and it seems that there is a blank href ( # ).

    <a type="button" class="wdt-duplicate-table" data-table_id="1" data-table_name="Ready ΣΗΜΕΙΑ" data-table_type="google_spreadsheet" data-toggle="tooltip" href="#" aria-label="Duplicate" data-bs-original-title="Duplicate"><i class="wpdt-icon-clone"></i></a>

    the other two icon buttons ( settings and delete ) work as expected.


    The second problem is that when i go in the settings in my linked table and i select "Column List", again doesnt work. But again no errors in console

    8055570930.png



    After checking the HTML of the page i saw that there is a modal in both cases that is hidden ( display:none ), but when i hit the buttons a class .show is added. It has "display:block" but the modal is not visible. I checked that my CSS does not affect the modal. have you got a solution?

  •  1,846
    Miloš replied

    Hi Giannoula,

    Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

    -

    1. I am happy to see you resolved the Popper JS issue.


    2.  In regards to the Duplicate button not responding :

    Can you please create a separate ticket for this issue, and on that ticket, if you can send us remote access so that we can log in and try to debug the issue for you?

    We will need a WP-admin (administrator) user access for your website where this happens, 

    as well as FTP credentials 

    so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. 

    We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties. 

    You can write credentials there just check PRIVATE Reply so nobody can see them except us. ( or create a Private ticket)



    3. For the second problem :

    The second problem is that when i go in the settings in my linked table and i select "Column List", again doesnt work. But again no errors in console

    8055570930.png

    After checking the HTML of the page i saw that there is a modal in both cases that is hidden ( display:none ), but when i hit the buttons a class .show is added. It has "display:block" but the modal is not visible. I checked that my CSS does not affect the modal. have you got a solution?

    Our developers should be able to help us resolve both issues, but please open another separate ticket for the issue of the Column List Button, and we can use the same Access you send us from the second Ticket there.


    When you have multiple questions or issues which are for different subjects/topics,

     please open a new ticket for each subject, and we will help/advise more effectively. 

    In that way, issues and questions which are related to different subjects will be in separate tickets so other users or our support agents can find them easily. 

    Our policy is to have one issue or question per ticket for the reasons described already.

    Thank you for understanding.


    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