How to do remote processing for DataTables on a file instead of a database?
I have been reading an excellent article from:
https://www.codeproject.com/Articles/1158982/Using-DataTables-with-Web-API-Part-Paging-Sorting by levelness posted 2 Dec 2016. What are the changes I would make if the source of the data is a file instead of a database table? I can read the entire file into memory, but when I try to process on the client side, if I put more than about 50 rows into the table, there is an internal jQuery error that cause all paging, sorting, etc. to disappear. I thought maybe I could read in the file on the server, then do something like levelnis describes. By storing the rows into a List, it would be easy to return the next set of 50 or so. Does this make sense?
If someone knows why the error occurs on jQuery when the number of rows is greater than 50, I'd appreciate knowing as that would be simpler.
jquery datatables remote-server
asked Nov 12 at 20:19
John Wooten
179111
add a comment |
I have been reading an excellent article from:
https://www.codeproject.com/Articles/1158982/Using-DataTables-with-Web-API-Part-Paging-Sorting by levelness posted 2 Dec 2016. What are the changes I would make if the source of the data is a file instead of a database table? I can read the entire file into memory, but when I try to process on the client side, if I put more than about 50 rows into the table, there is an internal jQuery error that cause all paging, sorting, etc. to disappear. I thought maybe I could read in the file on the server, then do something like levelnis describes. By storing the rows into a List, it would be easy to return the next set of 50 or so. Does this make sense?
If someone knows why the error occurs on jQuery when the number of rows is greater than 50, I'd appreciate knowing as that would be simpler.
jquery datatables remote-server
asked Nov 12 at 20:19
John Wooten
179111
check json-server out, I think this will help you. If not, it IS cool, objectively ;).
– Todd
Nov 12 at 20:25
Could put all the data into a json file and just use the ajax options
– charlietfl
Nov 12 at 20:32
I have done as charlietfl suggested and read about jason-server. I now have the data as a json structure 'data' with each row as an array. I'm trying to use an MVC approach and have the view with the table outline and the datable info there. It worked when I created the rows using a List of strings that comprised the row data where I put in the <tr> and <td> 's as needed. All of the examples assume databases. I want to use the json structure in perhaps a model, and have a controller tell the model to load create the json then connect to paging, sorting, and hand to the view. How?
– John Wooten
Nov 14 at 21:37
add a comment |
I have been reading an excellent article from:
https://www.codeproject.com/Articles/1158982/Using-DataTables-with-Web-API-Part-Paging-Sorting by levelness posted 2 Dec 2016. What are the changes I would make if the source of the data is a file instead of a database table? I can read the entire file into memory, but when I try to process on the client side, if I put more than about 50 rows into the table, there is an internal jQuery error that cause all paging, sorting, etc. to disappear. I thought maybe I could read in the file on the server, then do something like levelnis describes. By storing the rows into a List, it would be easy to return the next set of 50 or so. Does this make sense?
If someone knows why the error occurs on jQuery when the number of rows is greater than 50, I'd appreciate knowing as that would be simpler.
jquery datatables remote-server
asked Nov 12 at 20:19
John Wooten
179111
I have been reading an excellent article from:
https://www.codeproject.com/Articles/1158982/Using-DataTables-with-Web-API-Part-Paging-Sorting by levelness posted 2 Dec 2016. What are the changes I would make if the source of the data is a file instead of a database table? I can read the entire file into memory, but when I try to process on the client side, if I put more than about 50 rows into the table, there is an internal jQuery error that cause all paging, sorting, etc. to disappear. I thought maybe I could read in the file on the server, then do something like levelnis describes. By storing the rows into a List, it would be easy to return the next set of 50 or so. Does this make sense?
If someone knows why the error occurs on jQuery when the number of rows is greater than 50, I'd appreciate knowing as that would be simpler.
jquery datatables remote-server
jquery datatables remote-server
asked Nov 12 at 20:19
John Wooten
179111
asked Nov 12 at 20:19
John Wooten
179111
asked Nov 12 at 20:19
John Wooten
179111
asked Nov 12 at 20:19
John Wooten
179111
asked Nov 12 at 20:19
John Wooten
179111
179111
check json-server out, I think this will help you. If not, it IS cool, objectively ;).
– Todd
Nov 12 at 20:25
Could put all the data into a json file and just use the ajax options
– charlietfl
Nov 12 at 20:32
I have done as charlietfl suggested and read about jason-server. I now have the data as a json structure 'data' with each row as an array. I'm trying to use an MVC approach and have the view with the table outline and the datable info there. It worked when I created the rows using a List of strings that comprised the row data where I put in the <tr> and <td> 's as needed. All of the examples assume databases. I want to use the json structure in perhaps a model, and have a controller tell the model to load create the json then connect to paging, sorting, and hand to the view. How?
– John Wooten
Nov 14 at 21:37
add a comment |
check json-server out, I think this will help you. If not, it IS cool, objectively ;).
– Todd
Nov 12 at 20:25
Could put all the data into a json file and just use the ajax options
– charlietfl
Nov 12 at 20:32
I have done as charlietfl suggested and read about jason-server. I now have the data as a json structure 'data' with each row as an array. I'm trying to use an MVC approach and have the view with the table outline and the datable info there. It worked when I created the rows using a List of strings that comprised the row data where I put in the <tr> and <td> 's as needed. All of the examples assume databases. I want to use the json structure in perhaps a model, and have a controller tell the model to load create the json then connect to paging, sorting, and hand to the view. How?
– John Wooten
Nov 14 at 21:37
check json-server out, I think this will help you. If not, it IS cool, objectively ;).
– Todd
Nov 12 at 20:25
check json-server out, I think this will help you. If not, it IS cool, objectively ;).
– Todd
Nov 12 at 20:25
Could put all the data into a json file and just use the ajax options
– charlietfl
Nov 12 at 20:32
Could put all the data into a json file and just use the ajax options
– charlietfl
Nov 12 at 20:32
I have done as charlietfl suggested and read about jason-server. I now have the data as a json structure 'data' with each row as an array. I'm trying to use an MVC approach and have the view with the table outline and the datable info there. It worked when I created the rows using a List of strings that comprised the row data where I put in the <tr> and <td> 's as needed. All of the examples assume databases. I want to use the json structure in perhaps a model, and have a controller tell the model to load create the json then connect to paging, sorting, and hand to the view. How?
– John Wooten
Nov 14 at 21:37
I have done as charlietfl suggested and read about jason-server. I now have the data as a json structure 'data' with each row as an array. I'm trying to use an MVC approach and have the view with the table outline and the datable info there. It worked when I created the rows using a List of strings that comprised the row data where I put in the <tr> and <td> 's as needed. All of the examples assume databases. I want to use the json structure in perhaps a model, and have a controller tell the model to load create the json then connect to paging, sorting, and hand to the view. How?
– John Wooten
Nov 14 at 21:37
add a comment |
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53269494%2fhow-to-do-remote-processing-for-datatables-on-a-file-instead-of-a-database%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53269494%2fhow-to-do-remote-processing-for-datatables-on-a-file-instead-of-a-database%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
check json-server out, I think this will help you. If not, it IS cool, objectively ;).
– Todd
Nov 12 at 20:25
Could put all the data into a json file and just use the ajax options
– charlietfl
Nov 12 at 20:32
I have done as charlietfl suggested and read about jason-server. I now have the data as a json structure 'data' with each row as an array. I'm trying to use an MVC approach and have the view with the table outline and the datable info there. It worked when I created the rows using a List of strings that comprised the row data where I put in the <tr> and <td> 's as needed. All of the examples assume databases. I want to use the json structure in perhaps a model, and have a controller tell the model to load create the json then connect to paging, sorting, and hand to the view. How?
– John Wooten
Nov 14 at 21:37