• Resolved jeff35kl

    (@jeff35kl)


    Hi,

    Thank you for this very nice plugin.

    I imported a csv file into a table and it worked flawlessy and looks great.

    The problem is that the first line of data started in the heading row of the table. Of course, I would like the description of the data to be in the heading row of the table and the first row of data to start on the row below the heading row.

    How can I fix this? An example is here: http://www.avcotraining.com/instructor-resources/mq1-mathematics

    (‘02.01(a)’ and ‘[Nature of matter: the chemical atoms, structure of atoms, molecules]’ are actually data and should be on the next row. In the header I want ‘Item number’ and ‘Description’ or something similar)

    Thank you.

    Jeff

    http://wordpress.org/extend/plugins/wp-table-reloaded/

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    Hi Jeff,

    thanks for your question.

    This is quite easy: Either simply add that heading data in the CSV file (or the program that generates the CSV file), or (which likely is what you need now) just insert a new row before the first one. To do that, simply check the checkbox for the first row and click the “Insert” button below the table text fields. After that, you will have an (initially empty) new row, which you can fill with the headings that you want.

    Regards,
    Tobias

    Thread Starter jeff35kl

    (@jeff35kl)

    Thanks for the quick response, Tobias.

    I tried inserting a row but nothing happens. Here is what I did: (1) I checked the box to the left of row 1. (2)I scrolled to the bottom of the table (more than 400 rows)to the ‘Data Manipulation’ box. (3)Next to ‘Selected rows:’ I checked the’Insert Row’ button. The progress indicator works and the page resets to the top of the table, but nothing changes.

    Addionally, I tried to ‘uncheck’ the ‘The first row of your table is the table head (HTML tags <thead> and <th>).” box. When I click on ‘Update changes’ the page appears to save, but the check mark reappears.

    Any ideas?

    Jeff

    Thread Starter jeff35kl

    (@jeff35kl)

    Additional info, Tobias. I just tried to add a row to a much smaller table and it worked (I should have tried that before I sent you the last post). Is there a limit on the number of rows I can use?

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    Hi Jeff,

    that’s actually the correct procedure.
    Now, your description however (and unfortunately) hints that you might be affected by the “Suhosin” problem, see for example http://wordpress.org/support/topic/plugin-wp-table-reloaded-long-csv-file-import-with-578-rows

    This prohibits editing of large tables 🙁

    Regards,
    Tobias

    Thread Starter jeff35kl

    (@jeff35kl)

    Thanks alot, Tobias. I’ll research the link.

    Greetings from Berlin.

    Thread Starter jeff35kl

    (@jeff35kl)

    One more question, Tobias.

    Here is the code for my .htaccess file. Do you know where to paste the fix (php_flag suhosin.simulation On)? Can I paste it anywhere?

    # BEGIN WPSuperCache
    # END WPSuperCache

    # BEGIN WordPress
    <IfModule mod_rewrite.c>
    RewriteEngine On
    RewriteBase /
    RewriteRule ^index\.php$ – [L]
    RewriteCond %{REQUEST_FILENAME} !-f
    RewriteCond %{REQUEST_FILENAME} !-d
    RewriteRule . /index.php [L]
    </IfModule>

    # END WordPress

    Thank you

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    Hi,

    I’m not an expert with .htaccess files, but probably in the first line is ok.
    (Note that the solution might not be as easy as this, but it works for many people.)

    Regards,
    Tobias

    Thread Starter jeff35kl

    (@jeff35kl)

    I used your first suggestion and modified the csv file which took care of the heading issue. Right now I have a table with more than 1500 items that displays fine on my site. The only issue is editing it, but I can live with the results. ttp://www.avcotraining.com/instructor-resources/mq3-electrical-fundamental

    Thanks for you help, Tobias.

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    Hi,

    the workaround with the CSV files is then indeed the best choice for you.
    Thanks for sharing the link with the table!

    Best wishes,
    Tobias

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

The topic ‘wp-table-reloaded Header in table with csv import’ is closed to new replies.