Date Problem With csv Import

Hi,

thanks for your post, and sorry for the trouble.

Can you please post a link to the page with the table where this problem happens, so that I can take a direct look? Thanks!

Regards,
Tobias

Hi Tobias,

Thanks for your speedy reply.

I have imported some dummy data back into the test site for you to take a look at: https://www.table.cmsnetdesign.com.au/date-test/

The Test Date column is the one giving trouble. The other columns I populated by typing them instead of cut and paste.

I have left the date formula out until you have had a chance to take a look.

When you click on the Test Date Column it looks like it is sorting by the first digits.When you click on the other date columns its sort it out in some sort of order but not in the way that the Test Date is trying to,

Also I noticed that excel drops the zero from the first date digit, would this affect the import/export into Tablepress?

Let me know if you want me to put the European date code on the test page.

Thanks Tobias.

Hi,

the problem here might be all of those empty cells in that column. If I remember correctly, there must be a date in every cell.

The leading zero should not be critical, but you could try to tell Excel to export them by changing the data format to “Text”.

And you will of course need “Custom Command” to tell the JS library to use the European dates sorting for this column.

Regards,
Tobias

Great job Tobias – Thank you.

The problem was indeed the empty cells.I replaced all the empty cells with: 00/00/0000 and all the date sorting now works.

With reference to the same link above: for some reason I cant get the DataTables FixedHeader to work on the table.

I have installed the FixedHeader plugin and pasted the following code into the page:

[table id=7 datatables_fixedheader=”top” /]

Am I missing anything?

Thanks Tobias.

Hi,

good to hear that this worked! ??

Probably due to copy/paste, some HTML code slipped in that ruins the fonts a little bit and might also influence other things.
Please go the “Edit” screen of that page, and switch from the “Visual” to the “Text” editor in the upper right corner of the text input field. Then, you should see the Shortcode wrapped in HTML <pre> and </pre> tags.
Please remove those, so that the Shortcode is by itself on its own line.

Regards,
Tobias

Hi Tobias,

Removing the

 and 

sorted the fonts, but for some reason the header is still disappearing when scrolled.

Could it be the theme I am using?

Hi,

that’s good!

From what I can see, the FixedHeader is not initialized on the table. Are you sure that you added it to the Shortcode correctly?
Is the Extension activated in the WordPress plugins?

Regards,
Tobias

Hi Tobias,

Yes I can confirm the fixed header extension plugin is installed and activated.

This is the short code I pasted into the page:

[table id=7 datatables_fixedheader=”top” /]

I have also checked that the table id is correct.

Hi,

ok, that’s strange then.
If possible, I’d like to take a direct look at this on your site. Could you therefore please create a temporary admin account for me and send me the details via email (the address is in the main plugin file “tablepress.php”)? That way, I can investigate this directly. Thanks!

Regards,
Tobias

Hi Tobias,

Message on it way with the subject:

Fixed Header – Login Details

Hi,

thanks! I’ve received that and just took a look. I replied directly to your email. Basically, it’s a mixture of problems between the wrong Extension being installed and the theme JS code.

Regards,
Tobias

Tobias,

I consider this case to be resolved.

Keep up the great work – thank you.

Hi,

no problem, you are very welcome! ?? Always glad when I can help!

Best wishes,
Tobias

Hi TobiasBG

I love tablepress and would like to use it on my site.
I am race director and I need to post the results for my races.
Tablepress changes the time I enter for everyone to a decimal figure….I am late by a week trying to solve this….. while everyone is showing their dissatisfaction on facebook.

Please help, my time and pace column all changed to a decimal figure

Hi,

thanks for your post, and sorry for the trouble.

TablePress does not change any data, as it doesn’t actually now (for example) that a cell contains a date are a time value.
My assumption therefore is that the CSV file already contains that decimal figure and not the desired time. This is however caused during the export from Excel. To check this, please open the CSV file in a text editor.
To fix this, you’ll probably have to play with the cell format in Excel.

Regards,
Tobias