[Plugin: WP-Table Reloaded] Numerical Sorting Issue

travis.hill
(@travishill)

13 years, 9 months ago

I have a table with a column of numbers (representing Alexa Ranking) ranging from 0 to millions.

However, sorting the column returns results like:

11,199,994
112,349
115,372
12,211,034
12,338
12,893,418
123,943
13,018,427
13,233
13,474,162

Obviously not correct. Is there a something simple I’ve overlooked?

Thanks again for your time Tobias!

Travis

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

Thread Starter travis.hill
(@travishill)

13 years, 9 months ago

OK, I think I’m onto something:

http://datatables.net/plug-ins/sorting#formatted_numbers

Where would this “plugin” be implemented?

Thread Starter travis.hill
(@travishill)

13 years, 9 months ago

Another question:

Where are the AUTO_INCREMENT ID’s for the forms generated from?

Plugin Author TobiasBg
(@tobiasbg)

13 years, 9 months ago

Hi,

regarding that sorting code: Please contact me by email (address is in the main plugin file) and I will get the necessary got to you. I didn’t yet have the time to publish it on my website, so sorry for the extra trouble.

Regarding the IDs of the tables (not forms!): There is a variable for that in the WP-Table Reloaded Options, which is automatically incremented whenever a new table is created or imported. I don’t really recommend messing with that number though, as it might have unexpected consequences.

Best regards,
Tobias

Thread Starter travis.hill
(@travishill)

13 years, 9 months ago

Thanks Tobias, I’ve sent the email.

Yeah, tables, not forms! lol.

kgagne
(@kgagne)

13 years, 9 months ago

I too need to implement a plugin:

http://datatables.net/plug-ins/sorting#numbers_html

How do I do so? Someone else had a similar issue but I see no answer:

http://wordpress.org/support/topic/400658

kgagne
(@kgagne)

13 years, 9 months ago

Thanks for the email, Tobias! I followed these instructions and got the files to work:

http://tobias.baethge.com/wordpress-plugins/wp-table-reloaded-english/extensions/

Zac123
(@zac123)

13 years, 7 months ago

how can i implement this plugin? Date (dd/mm/yyyy)

http://datatables.net/plug-ins/sorting#formatted_numbers

Thanks for your help.

Plugin Author TobiasBg
(@tobiasbg)

13 years, 7 months ago

Hi,

if you want, I can send you the code for the other extension (with the commas). Starting with that you would only need to replace the JavaScript code with the one for the date sorting.

Please contact me by email then, so that I can send you the file. (My address is in the main plugin file of WP-Table Reloaded.)

Best wishes,
Tobias

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

The topic ‘[Plugin: WP-Table Reloaded] Numerical Sorting Issue’ is closed to new replies.