File
Add library
Share
Login or Register
Help
HTMLSaved
 
<!DOCTYPE html>
<html>
  <head>
<script src="https://code.jquery.com/jquery-1.11.0.min.js"></script>
    <script src="https://code.jquery.com/jquery-1.11.1.min.js"></script>
​
    <link href="//datatables.net/download/build/nightly/jquery.dataTables.css" rel="stylesheet" type="text/css" />
    <script src="//datatables.net/download/build/nightly/jquery.dataTables.js"></script>
​
    <meta charset=utf-8 />
    <title>DataTables - JS Bin</title>
  </head>
  <body>
    <div class="container">
      <table id="example" class="display" width="100%">
        <thead>
          <tr>
            <th>File Name</th>
            <th>Status</th>
            <th>Downloaded</th>
            <th># of Rows</th>
            <th># of Errors</th>
            <th>Error</th>
          </tr>
        </thead>
      </table>
    </div>
  </body>
</html>
CSSSaved
 
body {
  font: 90%/1.45em "Helvetica Neue", HelveticaNeue, Verdana, Arial, Helvetica, sans-serif;
  margin: 0;
  padding: 0;
  color: #333;
  background-color: #fff;
}
​
​
div.container {
  min-width: 980px;
  margin: 0 auto;
}
​
​
JavaScriptSaved
 
$(document).ready( function () {
  var data = '{[{"ID":41864,"fileName":"REQ_014_20141030_0002.CSV","statusText":"Completed","statusCode":"C ","numberOfRows":16,"downloaded":1,"rowsInError":0,"errorText":"","sortOrder":20,"uploadedDate":"\/Date(1414695588830)\/","lastProcessedDate":"\/Date(1414695602789)\/","responseFileCreationDate":"\/Date(1414695602805)\/","completedDate":"\/Date(1414695602805)\/","downloadAttempts":2,"lastDownloadDate":"\/Date(1414695668327)\/","rowsPosted":14,"rowsCanceled":2,"uploadedBy":"14rhahn"},{"ID":41863,"fileName":"REQ_014_20141030_0001.CSV","statusText":"Completed","statusCode":"C ","numberOfRows":25,"downloaded":1,"rowsInError":0,"errorText":"","sortOrder":20,"uploadedDate":"\/Date(1414694831247)\/","lastProcessedDate":"\/Date(1414694851208)\/","responseFileCreationDate":"\/Date(1414694851223)\/","completedDate":"\/Date(1414694851223)\/","downloadAttempts":1,"lastDownloadDate":"\/Date(1414694852993)\/","rowsPosted":6,"rowsCanceled":19,"uploadedBy":"14rhahn"},{"ID":41813,"fileName":"REQ_014_20141029_0002.CSV","statusText":"Completed","statusCode":"C ","numberOfRows":8,"downloaded":1,"rowsInError":0,"errorText":"","sortOrder":20,"uploadedDate":"\/Date(1414600400960)\/","lastProcessedDate":"\/Date(1414600456288)\/","responseFileCreationDate":"\/Date(1414600456303)\/","completedDate":"\/Date(1414600456303)\/","downloadAttempts":1,"lastDownloadDate":"\/Date(1414600596683)\/","rowsPosted":6,"rowsCanceled":2,"uploadedBy":"14rhahn"},{"ID":41812,"fileName":"REQ_014_20141029_0001.CSV","statusText":"Completed","statusCode":"C ","numberOfRows":13,"downloaded":1,"rowsInError":0,"errorText":"","sortOrder":20,"uploadedDate":"\/Date(1414599483087)\/","lastProcessedDate":"\/Date(1414599512435)\/","responseFileCreationDate":"\/Date(1414599512450)\/","completedDate":"\/Date(1414599512450)\/","downloadAttempts":1,"lastDownloadDate":"\/Date(1414599521790)\/","rowsPosted":2,"rowsCanceled":11,"uploadedBy":"14rhahn"},{"ID":41775,"fileName":"REQ_014_20141028_0002.CSV","statusText":"Completed","statusCode":"C ","numberOfRows":14,"downloaded":1,"rowsInError":0,"errorText":"","sortOrder":20,"uploadedDate":"\/Date(1414522415593)\/","lastProcessedDate":"\/Date(1414522543630)\/","responseFileCreationDate":"\/Date(1414522543645)\/","completedDate":"\/Date(1414522543645)\/","downloadAttempts":1,"lastDownloadDate":"\/Date(1414522556480)\/","rowsPosted":11,"rowsCanceled":3,"uploadedBy":"14rhahn"},{"ID":41773,"fileName":"REQ_014_20141028_0001.CSV","statusText":"Completed","statusCode":"C ","numberOfRows":26,"downloaded":1,"rowsInError":0,"errorText":"","sortOrder":20,"uploadedDate":"\/Date(1414521641930)\/","lastProcessedDate":"\/Date(1414521660118)\/","responseFileCreationDate":"\/Date(1414521660134)\/","completedDate":"\/Date(1414521660134)\/","downloadAttempts":1,"lastDownloadDate":"\/Date(1414521732223)\/","rowsPosted":11,"rowsCanceled":15,"uploadedBy":"14rhahn"},{"ID":41735,"fileName":"REQ_014_20141027_0002.CSV","statusText":"Completed","statusCode":"C ","numberOfRows":29,"downloaded":1,"rowsInError":0,"errorText":"","sortOrder":20,"uploadedDate":"\/Date(1414427091083)\/","lastProcessedDate":"\/Date(1414427119949)\/","responseFileCreationDate":"\/Date(1414427119965)\/","completedDate":"\/Date(1414427119981)\/","downloadAttempts":1,"lastDownloadDate":"\/Date(1414427127150)\/","rowsPosted":26,"rowsCanceled":3,"uploadedBy":"14rhahn"},{"ID":41733,"fileName":"REQ_014_20141027_0001.CSV","statusText":"Completed","statusCode":"C ","numberOfRows":30,"downloaded":1,"rowsInError":0,"errorText":"","sortOrder":20,"uploadedDate":"\/Date(1414425779020)\/","lastProcessedDate":"\/Date(1414425921113)\/","responseFileCreationDate":"\/Date(1414425921129)\/","completedDate":"\/Date(1414425921129)\/","downloadAttempts":1,"lastDownloadDate":"\/Date(1414425922730)\/","rowsPosted":15,"rowsCanceled":15,"uploadedBy":"14rhahn"}]}';
  var table = $('#example').dataTable({
    "ajax": "data",
    "Columns": [
                { "data": 'fileName' },
                { "data": 'statusText' },
                { "data": 'downloaded' },
                { "data": 'numberOfRows' },
                { "data": 'rowsInError' },
                { "data": 'errorText' }
            ],
            "paging": true,
            "ordering": true
  });
} );
​
Output 300px

You can jump to the latest bin by adding /latest to your URL

Dismiss x
public
Bin info
anonymouspro
0viewers