Large table loading problems, wont load after 16th row?
Large table loading problems, wont load after 16th row?
veranopage
Posts: 24Questions: 0Answers: 0
I am having problems with my code as you can see below, it displays nothing in IE per referenced CSV file after row 16. Meaning if I include rows 17-2000 IE displays nothing, If I show only row 1-15 in the csv then it does display. Why is this occuring?
[code]<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
DataTables example
@import "../../media/css/demo_page.css";
@import "../../media/css/jquery.dataTables.css";
$(function() {
$('#CSVTable').CSVToTable('data/prize.csv', {
loadingImage: 'res/theme/loading.gif',
startLine: 0,
tableClass: "dataTable"
})
}).on("loadComplete",function() {
var $table = $('#CSVTable').find('TABLE');
var numCols = $table.find('tr')[0].cells.length;
$("tr:gt(0)",$table).each(function(i,row) {
var checkedStatus = $(this).find('td').eq(numCols - 1).text();
$(this).find('td').eq(numCols - 1).empty();
var check = '';
$(this).find('td').eq(numCols - 1).append(check);
});
$table.dataTable({sortList:[[0,0]], widgets: ['zebra']});
});
function SaveTableData(){
// CODE ADDED FOR TABLE TO CSV CONVERSION AND SAVING FILE AGAIN WITH DIFFERENT NAME WITHIN SAME FOLDER
var str = $('#CSVTable').tableToCSV();
String.prototype.toLocalPath=function(){
return unescape(this.slice(this.search(/[A-Z]:\/[^\/]/i)).replace(/\//g,'\\'))
};
String.prototype.folderOf=function(no_slash){
return this.slice(0,this.lastIndexOf('\\',this.length-(/\\$/.test(this)?2:0))+(no_slash?0:1))
};
var app_path=location.href.toLocalPath().folderOf();
var filepath = $.twFile.convertUriToLocalPath(app_path + '\\data\\prize.csv');
$.twFile.save(filepath, str);
}
Worksheet
[/code]
[code]<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
DataTables example
@import "../../media/css/demo_page.css";
@import "../../media/css/jquery.dataTables.css";
$(function() {
$('#CSVTable').CSVToTable('data/prize.csv', {
loadingImage: 'res/theme/loading.gif',
startLine: 0,
tableClass: "dataTable"
})
}).on("loadComplete",function() {
var $table = $('#CSVTable').find('TABLE');
var numCols = $table.find('tr')[0].cells.length;
$("tr:gt(0)",$table).each(function(i,row) {
var checkedStatus = $(this).find('td').eq(numCols - 1).text();
$(this).find('td').eq(numCols - 1).empty();
var check = '';
$(this).find('td').eq(numCols - 1).append(check);
});
$table.dataTable({sortList:[[0,0]], widgets: ['zebra']});
});
function SaveTableData(){
// CODE ADDED FOR TABLE TO CSV CONVERSION AND SAVING FILE AGAIN WITH DIFFERENT NAME WITHIN SAME FOLDER
var str = $('#CSVTable').tableToCSV();
String.prototype.toLocalPath=function(){
return unescape(this.slice(this.search(/[A-Z]:\/[^\/]/i)).replace(/\//g,'\\'))
};
String.prototype.folderOf=function(no_slash){
return this.slice(0,this.lastIndexOf('\\',this.length-(/\\$/.test(this)?2:0))+(no_slash?0:1))
};
var app_path=location.href.toLocalPath().folderOf();
var filepath = $.twFile.convertUriToLocalPath(app_path + '\\data\\prize.csv');
$.twFile.save(filepath, str);
}
Worksheet
[/code]
This discussion has been closed.