Hello - I'm attempting to create an editable table from an existing excel file. I can import the table just fine using the wpDataTable Constructor and the "I would like to read the initial table data from an input file" option. After the initial import it reads the columns and data properly. After selecting the "Create the table and open in editor" option and the "Make Table editiable from front-end" option, the plugin moves all the data over to the next column.
Ex - There is a column called "EmployeeID". To the right of that column is another column called "Property". After selecting the "Make Table editable in front-end" the plug moves the data in the "EmployeeID" column into the "Property column.
Please provide me a temporary WP-admin login for your site where this happens, 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 party. You can write credentials here because this ticket is private and nobody can see it except us.
I can't reproduce this behaviour with your Excel file as you can see in the attachment. Could you send me a screenshot of your table settings or better a screencast in which you will create that table so I could possible catch what is going on.
Please also try to create table from file that you sent me, maybe that one will work normally.
I noticed one more thing. First column in your screenshot, the "id" one, doesn't exist in your excel. Did you add it after table creation?
Hello - I'm attempting to create an editable table from an existing excel file. I can import the table just fine using the wpDataTable Constructor and the "I would like to read the initial table data from an input file" option. After the initial import it reads the columns and data properly. After selecting the "Create the table and open in editor" option and the "Make Table editiable from front-end" option, the plugin moves all the data over to the next column.
Ex - There is a column called "EmployeeID". To the right of that column is another column called "Property". After selecting the "Make Table editable in front-end" the plug moves the data in the "EmployeeID" column into the "Property column.
Thanks.
HI Steve,
Please provide me a temporary WP-admin login for your site where this happens, 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 party. You can write credentials here because this ticket is private and nobody can see it except us.
Hey Miljko - The site is an internal Intranet site so it is not public facing.
Hi Steve,
Could you send me an Excel file so I can take a look
Just sent the spreadsheet to your email.
Hi Steve,
I can't reproduce this behaviour with your Excel file as you can see in the attachment. Could you send me a screenshot of your table settings or better a screencast in which you will create that table so I could possible catch what is going on.
Please also try to create table from file that you sent me, maybe that one will work normally.
I noticed one more thing. First column in your screenshot, the "id" one, doesn't exist in your excel. Did you add it after table creation?