What is Reddit's opinion of
DataTables?
From 3.5 billion Reddit comments
60 reviews of this app found across Reddit:
You could look into using Datatables, it has an extension that allows you to load a large dataset and only renders what is required. http://datatables.net/extensions/scroller/
Edit: Just in case it's not obvious in this example, Datatables has filtering, sorting, pagination etc. It's just not enabled. This is an example of Datatables with default/zero configuration http://datatables.net/examples/basic_init/zero_configuration.html
"Controls" aren't really a thing in MVC; that's a WebForms artifact. While WebGrid does exist, it's not something Microsoft really cares about (last commit around April 2012), which makes sense as it isn't "the MVC way".
If you need a grid, you build it using plain old Javascript and HTML. If you want a ton of features out of the box, you just use a library. The best one I've found is datatables. It has an absolutely huge amount of functionality out of the box, and writing plugins is pretty straightforward too. There are a bunch of others out there too.
Oh man. That's amazing. Notices a few things though.
- It's super important for the price polling to stop after the browser loses focus. Which kind of happens. And it should also start polling again when the browser is focused again. Which also kind of happens. But I notices a few times the price updating when the browser was not focused. And I don't want some ajax requests flying around if I'm not using it atm.
- The base currency is not saved when closing and reopening the site. Super important.
- Got this error in alert box when reopened the site - "DataTables warning: table id=table - Ajax error. For more information about this error, please see http://datatables.net/tn/7"
- Think about optimizing it for mobile - there are more than +100 resources/files that are being fetched on load. I would be happy with an option with images (or smaller ones) if that would optimize the performance.
- The share widget is annoyingly shown after page refresh even though I've hidden it before.
Might be more, but that's from 2 minutes usage.
Once again - superb. But keep improving. :)
Have a look at SmartListing if you need sortable tables with filters and in-place editing like DataTables with out the hassle of setting up DataTables. Check the Demo. Bootstrap 3 is supported and used out of the box.
It really depends heavily on how much content you would be loading if you do it all at once.
As an example, my company has an internal website where we compile information for websites that we work on. We use the strategy of loading all the data upfront and then filtering it with javascript. It's a table of about 325 rows, with around 20 columns each.
For me, it usually takes about 5 seconds or so to load all the data. Not bad, and the speed of filtering it with javascript is insanely better than filtering with AJAX. (side note: check out jQuery Datatables if you are ever displaying a lot of tabular data. This is like the coolest shit I've ever used)
In contrast, for other people in my company with the same internet, (high speed broadband cable) but with shittier/more bogged down computers, half the time the page hangs so long that the browser asks if you still want to continue loading. This is obviously a terrible user experience.
If you are going to be leaning more towards a lot of content, you will want to use AJAX. Perhaps the initial page load can load the "featured articles" or the newest 10 or so, something like that. Then adjust the list with AJAX.
> Chosen is like [1] http://datatables.net/ datatables.js. Neither of those plugins abandons the native HTML5 elements.
AHAHAHAHAHAHAHA. Oh man, for someone really trying to sound like they know their shit you really messed that up.
Tables and Select dropdowns are NOT HTML5 and predate HTML5 by quite a bit. But randomly throwing the word HTML5 in there you've managed to accomplish nothing more than muddying up the point you were failing to make, as well as sounding like a buzz word obsessed amateur.
Both Seth and snuggl are 100% correct. Your examples for select dropdowns merely style replacement divs, not the original elements. Though in my opinion, there's nothing wrong with that, and I've in fact used the examples you mention before, it fails to address OP's actual question.
Unfortunately, the reason for this is due to the fact that browsers have monumentally shitty support for styling form elements.
Passwords: Keepass.
Note keeping: Evernote for Windows or NixNote / Zim for Linux. Wikis are good when there's multiple people accessing it, but for just yourself, these note taking programs are much easier + quicker to use. They can all be accessed via the web too if you like.
Evernote/NixNote lets you do basic tables. But if want to associate more data with your IPs etc do a spreadsheet or even SQL with a basic presentation webpage, datatables is good for doing tables.
I love this tool and have used it many times. However, I tried to use it tonight and as soon as the page loads, it gives me an error that says:
"DataTables warning: table id=grid_opt - Ajax error. For more information about this error, please see http://datatables.net/tn/7"
Everything works, but when I try to run it for builds, it calculates the builds, but won't process them. Any idea if this is easily fixable? :)
If your result set isn't large you can use DataTables to search on some of the other fields. Its a jquery thing, so all the processing is done on the browser. Not sure if that is going to fit your needs or not, but it might be worth checking out.
What you describe is so not progressive enhancement, it's just "faffing with ajax". A site doing actual progressive enhancement would not have the problem you describe, as it would start with a fully functional if a bit clunky plain html page, and progressively enhance it with javascript based on device capabilities. e.g. wrapping a plain table with the jquery datatables widget.
Managed to upload the CSV file of Dom's spreadsheet. After saving, I got the following message:
DataTables warning: table id=pos_multiplier_table - Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1
Page throws a strange error:
DataTables warning: table id=tablepress-74 - Cannot reinitialise DataTable. For more information about this error, please see http://datatables.net/tn/3
Hey,
I wanted to rerune my whole box and I keep getting this message on RuneOptimizer..
DataTables warning: table id=grid_opt - Ajax error. For more information about this error, please see http://datatables.net/tn/7
... and it's not suggesting me any rune combinations no matter what I choose. Can someone help?
Thank you for your reply!
Just to be clear, is this what you're suggesting?
(...)
var dataSet = [ fetch('/data.json') .then(function(response) { return response.json() }).then(function(json) { console.log('parsed json', json) }).catch(function(ex) { console.log('parsing failed', ex) })];
(...)
When I'm doing so, I get the following error:
> DataTables warning: table id=example - Requested unknown parameter '0' for row 0. For more information about this error, please see http://datatables.net/tn/4
I'm also not sure where to add in the getURL method here. I should've mentioned that 90% of the code has been written by someone else. Any help would be greatly appreciated.
I'd suggest not to re-invent the wheel and try out something like DataTables with the Scroller extension:
Here's a post on the datatables forum that might help you: http://www.datatables.net/forums/discussion/6734/datatable-became-very-slow-when-large-amount-of-data-load-by-infinite-scroll
You can do infinite vertical scrolling in dataTables. While their guide mentions that the feature is deprecated, it still works, and they also offer scroller
I'm still going to look at what else this can offer. I know our clients ask for table filtering, and dataTables seems to offer a superior experience with filtering, but some of our tables do not necessarily require filtering.
I can click stuffs now, but when I apply a filter, i get the message "Data Tables warning: table id=DataTables_Table_0 - Ajax error. For more information about this error, please see http://datatables.net/tn/7"
Well I currently have to appeal because they want me to repay 11k back because my proof of self employment would not upload on the file exchange site. Thankfully I took screen shots of the message it gave every time since they requested I got this http://datatables.net/tn/7 I called and it said after me speaking with someone that the uploading proof of self employment would remain until problems were fixed
DataTables warning: table id=adlistsTable - Requested unknown parameter 'status' for row 0, column 1. For more information about this error, please see http://datatables.net/tn/4
In playing around in the admin interface, I am also now getting this error.
When I hit OK, everything seems to work fine.
I got a popup warning:
"DataTables warning: table id=facebookTable - Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1"
when I opened. Otherwise, looks good
Thank you. Clearing the cache did fix the graphs on the dashboard.
I'm still not able to see my blacklist, whitelist, or any of the clients and domains in group management.
I also ran into something I didn't catch before. If I go into Local DNS Records, the following error comes up:
DataTables warning: table id=customDNSTable - Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1
I also recieve an error when going to the query list.
It is DataTables warning: table id=all-queries - Requested unknown parameter '3' for row 48, column 3. For more information about this error, please see http://datatables.net/tn/4
Upon going to Group Management > Clients, I receive a DataTables warning: table id=clientsTable - Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1 error?
Also under Network I receive An unknown error occured while loading the data.
Error connecting to database
/etc/pihole/pihole-FTL.db: Unable to open database: unable to open database file
Am on CentOS
Yes, using firefox ESR now:
DataTables warning: table id=network-entries - Requested unknown parameter 'ip' for row 0, column 0. For more information about this error, please see http://datatables.net/tn/4
hello i have the same problem :
DataTables warning: table id=t_folders - Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1
Page throws a strange error:
​
DataTables warning: table id=tablepress-74 - Cannot reinitialise DataTable. For more information about this error, please see http://datatables.net/tn/3
I got this error:
DataTables warning: table id=dtEntries - Cannot reinitialise DataTable. For more information about this error, please see <code>http://datatables.net/tn/3</code>
How reproducible:
always
Steps to reproduce:
1. Choose EUNE
2. Pick roles in this order: Jungle, Mid, Support
3. See error
I no longer get a console error about length an now can see all rows from the employee table when open the inspector and go through network->XHR->infograp.php. I did this by changing infograb.php with a new script and that is reflected in my git repo. Now there are no errors in the console. But on refresh I see a javascript alert window saying
"DataTables warning: table id=example - Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1"
but when I check the data against a Validator
the output of the JSON data can be found here Nothing has populated visibly in the datatable this whole time, which kinda I expect given the errors I have been dealing with. I am only getting information from the inspector console, the XHR file and the alert popup.
Oh man. That's amazing. Notices a few things though. - It's super important for the price polling to stop after the browser loses focus. Which kind of happens. And it should also start polling again when the browser is focused again. Which also kind of happens. But I notices a few times the price updating when the browser was not focused. And I don't want some ajax requests flying around if I'm not using it atm. - The base currency is not saved when closing and reopening the site. Super important. - Got this error in alert box when reopened the site - "DataTables warning: table id=table - Ajax error. For more information about this error, please see http://datatables.net/tn/7" - Think about optimizing it for mobile - there are more than +100 resources/files that are being fetched on load. I would be happy with an option with images (or smaller ones) if that would optimize the performance. - The share widget is annoyingly shown after page refresh even though I've hidden it before. Might be more, but that's from 2 minutes usage.
Once again - superb. But keep improving. :)
Search keeps breaking ... maybe I typed too fast :)
DataTables warning: table id=table - Ajax error. For more information about this error, please see http://datatables.net/tn/7
I get the same when I switch pages sometimes. Else, useful and neat looking page.
Yeah, they aren't loading for me either. When I go to the weap section i get a loading circle with text under that says "Press nothing to interact" and it never loads up.
edit: after a while of loading. i get this message "DataTables warning: table id=melee - Ajax error. For more information about this error, please see http://datatables.net/tn/7"
Tables are not responsive. Especially tables you can sort and filter.
However, there are some okay workarounds. TablePress uses DataTables.net. You can get more out of TablePress with some JavaScript. One of which is enabling responsive mode and giving columns a responsive priority.
Example
If you have six columns:
- Product Name
- Price
- Model Number
- Weight
- Color
- Gluten Free
Let's assume that the first three are the most important. You can configure the columns to have responsive priority.
- 1
- 1
- 1
- 2
- 3
- 4
With this - the first three will always be shown. The other three will start to fall off as the screen gets narrower.
End Example
Another option is to consider if you need all the functionality of TablePress/whatever. Could you output the data in responsive-friendly markup? Think of Bootstraps (or any front end framework) grid system. It's made of rows and columns and they start to stack as the screen gets smaller.
You won't have anything fancy but it's the most responsive-friendly option.
reimported in 3.0.9 and no quality data in column. Did not reparse but don't see how that would affect it.
DataTables warning: table id=grid_runes - Requested unknown parameter 'quality' for row 0, column 6. For more information about this error, please see http://datatables.net/tn/4
Tried to do a query on a client through the new admin.
I got this error; http://i.imgur.com/78snOAU.png
Error; DataTables warning: table id=all-queries - Ajax error. For more information about this error, please see http://datatables.net/tn/7
Token; tece29sakp
Im getting error:
DataTables warning: table id=grid_runes - Requested unknown parameter 'unique_id' for row 799, column 24. For more information about this error, please see http://datatables.net/tn/4
I know might be the wrong "Site" to ask but on the Rune Optimizer SW Runes I get an error.
Here's the error Message DataTables warning: table id=grid_opt - Ajax error. For more information about this error, please see http://datatables.net/tn/7
Well, I'm receiving something similar I think. I have the local host setup. When I open localhost/swrunes, it comes up with a "DataTables warning: table id=grid_opt - Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1" When I press F12, go to Network tab and run the optimization, I saw the "optimize.php" come up in the list of names and if I click on it, it says "Unable to connect to Database!" My tool just shows it has calculated 0/XXXX builds and never comes up with any results. Hope this helps solve the issue with us local hosters. I don't want to jam the web version.
Not sure why others aren't answering this question. Posted my story here, too.
Hey /u/p3psey, site was working great for a bit, but I'm getting stuck on calculating number of permutations again. When I refresh the page it successfully imports past builds from cache, but gives me an error:
DataTables warning: table id=grid_opt - Ajax error. For more information about this error, please see http://datatables.net/tn/7
edit: working again as of 11:43am EST :)
Is anyone getting this error when using the optimizer tab?
DataTables Warning: tableid=grid_opt - Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1
I'm having a similar issue!
DataTables warning: table id=grid_opt - Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1
The local copy is working brilliantly but when calculating builds it won't process/display them.
Seems like an awesome program!
I'm running into an issue when trying to import the .json file to the optimizer though. It gives me the error:
"DataTables warning: table id=grid_runes - Requested unknown parameter 'id' for row 0. For more information about this error, please see http://datatables.net/tn/4"
twice, followed by:
"DataTables warning: table id=grid_subrunes - Requested unknown parameter 'id' for row 0. For more information about this error, please see http://datatables.net/tn/4"
twice.
Not sure exactly what it is trying to say is wrong since there is nothing in the json file labeled grid_runes or grid_subrunes. Capturing a new pcap file and producing a new json file still leaves me with the same errors.
Edit: When trying to use the same json file to upload onto swarfarm it gives me the error:
"Error with rune ID unknown. No runes have been imported. Please fix the errors and then import again.
Field: type
Unable to decode rune type."
I've looked through the file and none of the rune_id numbers seem to be abnormal, though they are just strings of numbers so who knows. I'd be happy to share the json file with you if it would help figure out what the issue is.
Yeah I'm currently using Telerik controls, which are easy for me to set up server side, but yeah not too efficient. Some of the other tables on the site (like on the home page) are using http://datatables.net/, which uses client side sorting and filtering.
I'd like to use that to replace all tables, but I haven't yet spent the time to learn how to make a master-detail table where the rows are expandable, like how I currently have on Match History
Is this what you are referring to:
http://datatables.net/reference/option/columns.render
If so, that'll take some time to figure out correctly, but it looks like it's definitely doable. Thanks for your help!
Try looking up afnFiltering - that's how I implemented filtering for my project. I'm not at a place where I can research the different datatables properties right now, but I know afnFiltering is what I used.
Another explorer is very good to have indeed. We'll put links to it on our sites. See a few errors checking it now DataTables warning: table id=recent-table - Ajax error. For more information about this error, please see http://datatables.net/tn/7
I'm having the same error when looking at the trading block. I'm on Firefox and it says v3.4 · 2015.05.21.1103 on the bottom
DataTables warning: table id=roster-user - Requested unknown parameter '2' for row 0. For more information about this error, please see http://datatables.net/tn/4
Hey man, I emailed you last night, just wanted to make sure you received it. I tried in both Chrome and IE, and both times once uploaded, I received an error message that told me to go to http://datatables.net/manual/tech-notes/7
If this is about protein, make your tables sorted by protein total, or protein/100 cals with the highest at the top. You appear to be using a datatable anyway so this should be very easy using http://datatables.net/reference/option/order
I'm getting DataTables errors: "DataTables warning: table id=OverallDataTable - Cannot reinitialise DataTable. For more information about this error, please see http://datatables.net/tn/3"
What do you use for your server-side processing & DB?
I really couldn't recommend anything more than datatables.net. I've used it many times... It's super easy to setup and comes with a bunch of great features(sorting, searching, searching by column, pagination). If you only have 100-1000 rows you can just load it all on one page. If your data grows you can use ajax/json to load more effectively. Also, if you want to take you sh*t to the next level checkout some of the admin themes at themeforest.net that include beautifully styled tables that use datatables.net. example
I've also used django admin for sorting and filtering. Both have their advantages.
I can find time to write up an example if you want but I think you just need to scrap what you are doing and basically do this: var obj1Keys = Object.keys(obj1);
var obj2Keys = Object.keys(obj2);
loop over the first set of keys and initially check if the other object had it (use indexOf). If not, you're done.
If it does, pull out obj2[obj2Keys[index]], loop over it's properties and check each against the single property value in obj1 for a match.
This should take an absolute maximum of 2 loops (one nested loop). You should be able to attach the properties you mentioned in your reply "on the fly" unless I am deeply misunderstanding the problem. If you are using underscore, I'd guess there is a very eloquent way to flatten out obj2 and find the match....As always....I'd recommend using something like underscore.
Edit: one final note. Based on the data layout/naming here I imagine you are using this: http://datatables.net/ ? If so, and these objects are truly massive as you say, you should consider doing this transformation server side if that is at all possible.
Not really a suggestion for the design of your site but, depending on how hardcore your tables need to be, you might want to look at DataTables. I just used it for a project and it takes a lot of the work out of complex tables. It's also configurable out the wazoo if you take the time to read the documentation.
You're looking for a javascript/jQuery implementation of tables? datatables is popular.
Or are you just looking for the ability to modify cells and save the results in your db? jQuery's $.ajax method is what you want for that.
In general, I feel like my workflow is fairly amateurish. It's hard to know which tasks to delegate to Django versus Javascript in a lot of cases. That's compounded by the fact that I'm using DataTables for displaying tickets which is written in Javascript where that stuff is probably better done in the Django. I'd rather do that than try to replicate the functionality DataTables offers on my own. I know I should probably be using TDD, but I don't really understand how to do that in Django. I'd really like to just watch a more experience coder do some things with Django to try to get in that same headspace a little bit. It would help tremendously to hear someone with some experience work through some problems aloud—to hear what their considerations are and to see how they use their tools...
I have some other more concrete questions I could better articulate to you when I'm in front of my project trying to work through them. Do you use any sort of IM? Maybe Skype or Google Talk?
I really appreciate your time.
This won't do all the work, but Data Tables is a truly amazing javascript library which can be interfaced with any backend capable of producing JSON. Combined with its many plugins, you can create a very advanced data display, entry, and editing system. Here is a quick example of a system created for quick CRUD operations.
It's 72 lines of formatted code long, and implements a nice data table, pagination, sorting, creating, editing, deleting, and search.
jQuery and AJAX are not languages. jQuery is a JavaScript library and AJAX is a way of passing information from a browser to a server asynchronously (without refreshing the page).
Now on to your question, for a reporting tool, a Drupal plugin sounds unnecessarily complicated. As long as you can get the data you need (which you indicated you can in XML form), you can use whatever language you want to parse it. PHP and Java already have built in XML parsers that are easy to use.
After parsing the data, it's just a simple matter to manipulate the data into whatever you need and displaying it with a graphical tool like Google Charts or jQuery DataTables depending on your needs.
DataTables is the best jQuery table thingy plugin I've used and could be suited for this purpose (for example use another hidden column for the value without unit and sort with it).
Well if you know a little bit of PHP to connect your DB and DataTables, go for it. What you need to do is described here: http://datatables.net/release-datatables/examples/server_side/server_side.html
With jQuery DataTables you can do very flashy tables with mostly configuration, try one of the examples:
http://datatables.net/release-datatables/examples/basic_init/table_sorting.html
The only real work will be to format your spreadsheet as JSON data structure (or put it in a DB, but this will be harder).
I needed to allow engineers access to DHCP info via a webpage so I have used a scheduled task to kick off powershell script that runs netsh and export to a csv which is then picked up by datatables and presents a nice easy to filter webpage where you can filter on mac address, ip or hostname or DHCP lease time.
its "out" by 3 minutes until the next scheduled task runs but works well.
you also I presume know they you can "identify" devices by mac address - http://www.coffer.com/mac_find/ or at least get a good idea of what it may be...
Its a bit sad that you can identify kit on your network by the first few bits of a mac address.