Initializing DataTables that has the markup inside javascript

Question

I am running into a problem here. I parse a .CSV file and I need to show them into a DataTables format.

The problem is The markups are all inside javascript as shown below

    $("#upload").bind("click", function () {
        var regex = /^([a-zA-Z0-9\s_\\.\-:])+(.csv|.xlsx|.xls)$/;
        if (regex.test($("#fileUpload").val().toLowerCase())) {
            if (typeof (FileReader) != "undefined") {
                var reader = new FileReader();
                reader.onload = function (e) {
                    var table = $("<table id='comp-monitor' class='table table-condensed table-striped'> \n\
            <tr><th>No.</th><th>DESKRIPSI ASSEMBLY</th><th>Drawing No.</th><th>QTY3</th><th>WEIGHT</th><th>-</th></tr>");
                    var rows = e.target.result.split("\n");
                    var no = 0;
                    for (var i = 0; i < rows.length; i++) {
                        no++;
//                        console.log(i);
                        var row = $("<tr />");
                        var cells = rows[i].split(",");
                        // Column No
                        var cell_no = $("<td />");
                        cell_no.html(no);
                        row.append(cell_no);

                        for (var j = 0; j < cells.length; j++) {
                            var cell = $("<td />");
                            cell.html(cells[j]);
                            row.append(cell);
                        }

                        table.append(row);
                    }
                    $("#dvCSV").html('');
                    $("#dvCSV").append(table);
                }
                reader.readAsText($("#fileUpload")[0].files[0]);

            } else {
                alert("This browser does not support HTML5.");
            }
        } else {
            alert("Please upload a valid CSV file.");
        }

    });

and the jquery initialization is just outside that function

$('#comp-monitor').DataTable();

Somehow the datatables doesn't run and I need some help with this where to put the initialization.

Thanks a bunch,

no error. its just the data doesnt fill up and show as a datatable format — Konz Mama
– Konz Mama, Commented Oct 8, 2015 at 7:28

marc_s · Accepted Answer · 2016-08-23 21:36:03Z

3

You can Initialize the datatable inside javascript itself

$("#upload").bind("click", function () {
    var regex = /^([a-zA-Z0-9\s_\\.\-:])+(.csv|.xlsx|.xls)$/;
    if (regex.test($("#fileUpload").val().toLowerCase())) {
        if (typeof (FileReader) != "undefined") {
            var reader = new FileReader();
            reader.onload = function (e) {
                var table = $("<table id='comp-monitor' class='table table-condensed table-striped'> \n\
            <tr><th>No.</th><th>DESKRIPSI ASSEMBLY</th><th>Drawing No.</th>    <th>QTY3</th><th>WEIGHT</th><th>-</th></tr>");
                var rows = e.target.result.split("\n");
                var no = 0;
                for (var i = 0; i < rows.length; i++) {
                    no++;
//                        console.log(i);
                    var row = $("<tr />");
                    var cells = rows[i].split(",");

                    // Column No
                    var cell_no = $("<td />");
                    cell_no.html(no);
                    row.append(cell_no);

                    for (var j = 0; j < cells.length; j++) {
                        var cell = $("<td />");
                        cell.html(cells[j]);
                        row.append(cell);
                    }

                    table.append(row);
                }
                $("#dvCSV").html('');
                $("#dvCSV").append(table);
//HERE
               $('#comp-monitor').DataTable();

            }
            reader.readAsText($("#fileUpload")[0].files[0]);

        } else {
            alert("This browser does not support HTML5.");
        }
    } else {
        alert("Please upload a valid CSV file.");
    }

});

let me know if this work.

edited Aug 23, 2016 at 21:36

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Oct 8, 2015 at 7:18

vedbhawsar

758 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Konz Mama Over a year ago

It doesnt work.. it shows the data table when i enter the page but when i click upload the data doesnt fill up the datatable

vedbhawsar Over a year ago

@KonzMama You can try Using the onloadend() on reader object and inside that initialize the datatable as reader.onloadend = function(e){ $('#comp-monitor').DataTable(); }

Konz Mama · Accepted Answer · 2015-10-08 08:55:04Z

I found an answer by using addrow

var t = $('#comp-monitor').DataTable({

    });
    $("#upload").bind("click", function () {
        var regex = /^([a-zA-Z0-9\s_\\.\-:])+(.csv|.xlsx|.xls)$/;
        if (regex.test($("#fileUpload").val().toLowerCase())) {
            if (typeof (FileReader) != "undefined") {
                var reader = new FileReader();
                reader.onload = function (e) {
                    var table = $("#comp-monitor tbody");
                    var rows = e.target.result.split("\n");
                    var no = 0;
                    table.empty();
                    for (var i = 0; i < rows.length; i++) {
                        no++;
                        var row = $("<tr class='odd' role='row' />");
                        var cells = rows[i].split(",");
                            t.row.add([
                                no,
                                cells[0],
                                cells[1],
                                cells[2],
                                cells[3],
                                cells[4]
                            ]).draw(false);
                        table.append(row);
                    }
                }
                reader.readAsText($("#fileUpload")[0].files[0]);

            } else {
                alert("This browser does not support HTML5.");
            }
        } else {
            alert("Please upload a valid CSV file.");
        }
    });

Collectives™ on Stack Overflow

Initializing DataTables that has the markup inside javascript

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related