• Resolved sagolfer

    (@sagolfer)


    I have create a page with a ‘wpdadiehard’ shortcode.
    
    I have create the project and page with “Bulk actions allowed” and “Import allowed”.
    
    If , on my page, page_id=4749 , I cliked on import, I get the prompt for import, I chose the file, which is an SQL file, and press “import”.
    
    It import no rows.
    
    What I am trying to accoplish is to import new participants for an event. 
    But I would also like to update a specific field for existing participants 
    
    Is this possible from a Front_end WordPress Page without having to log into the Admin pages?
    
    I nee a easy way to update participants of an event
    
    Examle SQL:
    Update existing participants :
    
    update g_tour_entries set tour_handcap = ‘1’ where tour_id = ‘2024-04’;
    
    Inserting new participants :
    
    INSERT INTO g_tour_entriestour_entry_id,member_idtour_id,tour_handicapgolfmealraffeltour_tee,flight_pos,flight_nr,team_id,start_time,2_pot,game_id,reserved) Values (‘2024-01-395′,’395′,’2024-01′,(get_handicap(395)),’1′,’Kabeljauw’,”,’LT’,’2′,’Flight01′,”,’16:00′,”,”,’0′);
    INSERT INTO g_tour_entriestour_entry_id,member_idtour_id,tour_handicapgolfmealraffeltour_tee,flight_pos,flight_nr,team_id,start_time,2_pot,game_id,reserved) Values (‘2024-01-523′,’523′,’2024-01′,(get_handicap(523)),’1′,”,”,’M’,’3′,’Flight03′,”,’16:00′,”,”,’0′);
    

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

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Contributor Kim L

    (@kimmyx)

    Hi @sagolfer,

    We responded to your previous post about this here. Please see our reply below for your convenience:

    It’s currently not possible to clear out a table on the front end. 😔

    You need to log in and be a user with administrator privileges to access the main WP Data Access plugin page and clear a database table.

    Let us know if you have other questions. 🙏

    Please let us know if you have additional questions.

    Thread Starter sagolfer

    (@sagolfer)

    my question id NOT about “ clear out a table on the front end. “

    it is about inserting and updating

    Plugin Contributor Kim L

    (@kimmyx)

    Hi @sagolfer,

    Apologies for the confusion. It’s the same with importation.

    You may be able to do updates per row but you cannot do a mass insert/update on the front-end. Only on the backend and as an administrator.

    This is mainly for security purposes.

    We appreciate your understanding. 🙏

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Update table using SQL or CSV’ is closed to new replies.