DEV Community: karthik22061993

Cannot read back correct JSON from excel workbook

karthik22061993 — Sun, 28 Jun 2020 20:55:51 +0000

I am using npm module xlsx to write and read JSON data.

I want to write this JSON to excel
{ "name": "John", "class": 1, "address" : [ { "street": "12th Cross" , "city": "London" }, { "street": "22nd Cross" , "city": "Cade" } ] }

Later when I read back I want to get same JSON from excel file

If you already solved, any suggestion or help will be of great help :)

Here is what I have tried

var XLSX = require("xlsx");
console.log("Node Version: " + process.versions.node);
console.log("XLSX Version: " + XLSX.version);

/* GENERATE TEST FILE */
(function() {
  // create workbook
  var wb = XLSX.utils.book_new();
  var ws = XLSX.utils.json_to_sheet([
    { "name": "John", "class": 1, "address" : [ { "street": "12th Cross" , "city": "London" }, { "street": "22nd Cross" , "city": "Cade" } ] }
    ], {header:["name","class","address","street","city"]});

XLSX.utils.book_append_sheet(wb, ws, "Sheet1");
XLSX.writeFile(wb, "testfile.xlsx");
let worksheet = wb.Sheets['Sheet1'];
let jsonArray= XLSX.utils.sheet_to_json(worksheet);
console.log(JSON.stringify(jsonArray));
})();

This returns

Node Version: 8.12.0
XLSX Version: 0.16.2
[{"name":"John","class":1}]

But I was expecting 
 { "name": "John", "class": 1, "address" : [ { "street": "12th Cross" , "city": "London" }, { "street": "22nd Cross" , "city": "Cade" } ] }

Any help or suggestion will be of great help :)

How to create/ update large quantity records in azure cosmos database

karthik22061993 — Sat, 13 Jun 2020 15:19:47 +0000

I have 1500 records to be created in azure cosmos database, I just loop through using Javascript code. I have REST API connection to the database. I feed the data to be updated as JSON array.

The problem is when I pass entire data, azure database timesout or send ECONNECTIONRESET. Many of you would create huge amount of records in the database and there is might be some efficient way to overcome this problem. I want your suggestion.

Since majority of records is not found, many times create new record part is hit and I have never pushed such huge amount of data before. Any suggestion or new idea will really help me.

Note : I run this javascript code using mocha unit test

Below is code snippet

Record.js

const fetch = require('node-fetch');
let connectionAzureDataBase = "abc...";
let SubscriptionKey = "xyz";
let promises = [];
let j = -1;

module.exports = {
checkRecord
}
function checkRecord (req) {
 for (let i = 0; i < req.body.length; i++) {
    promises[j] = new Promise(async function(resolve, reject) {
      //check if record exist in azure
      var apiUrl = APICheckRecord( req.body[i].recordName);
            fetch(apiUrl , { headers:connectionAzureDataBase})
            .then(res => res.json())
            .then(record => {
              if(record) {
                console.log("Record Found");
              } else {
                console.log("Record not Found, calling API to create Record");
                var apiUrl = APICreateNewRecord( req.body[i].recordName);
                fetch(apiUrl , { headers:connectionAzureDataBase})
                .then(res => res.json())
                .then(recordCreated => {
                  if(recordCreated) {
                   console.log("record created successfully");
                   resolve("record created successfully");
                  } else {
                   console.log("Encountered some unexpected condition");
                   resolve("Encountered some unexpected condition");
                  }
                 }).catch(err => {
                     console.log("record could not be created");
                      resolve("record could not be created");
                 }) 
              }
             }).catch(err => {
                console.log("record not found");
                resolve("record not found");
             })
     })// close promise

 }// close for

 let replies = await Promise.all(promises); 
 let promise1 = new Promise (function(resolve,reject) {
   resolve(replies);
 }) 
}

Record.spec.js

const Records = require("Record.js);

 it("should find/create records", async function() {
        this.timeout(6000000);
        try { 
         let req =[
          {
            "recordName": "Xyz",
            "recordDate": "12-06-2020"
          },
          {
            "recordName": "Abc",
            "recordDate": "13-06-2020"
           }
          ]
          let reply = await Records.checkRecord(req);
          console.log(JSON.stringify(reply));

        } catch(err) {
            console.log(err);
        }     
    })

Error

  message: 'request to https://apim-dev.azure-api.net/api/portal/records/?recordName="Xyz" failed, reason: read ECONNRESET',
  type: 'system',
  errno: 'ECONNRESET',
  code: 'ECONNRESET' }

message: 'request to https://apim-dev.azure-api.net/api/portal/createRecords/ failed, reason: read ECONNRESET',
  type: 'system',
  errno: 'ECONNRESET',
  code: 'ECONNRESET' }

This is sample of data that is passed, I have 1500 such records
SampleData

[
 {
   "recordName": "Xyz",
    "recordDate": "12-06-2020"
 },
{
   "recordName": "Abc",
    "recordDate": "13-06-2020"
 }
]

How to format the file containing json objects to json array

karthik22061993 — Sat, 16 May 2020 07:14:24 +0000

I am writing a javascript to format JSON objects to array of JSON objects.
My input is,
{
Name:"nom1",
Cities:['city1','city2']
}
{
Name:"nom2",
Cities:['city4','city5']
}

And I want the output as,

var data = [ { Name:"nom1", Cities:['city1','city2'] }, { Name:"nom2", Cities:['city3','city4'] } ]};

How to write a script to achieve this?

Electron app opening multiple windows or processes in spectron test

karthik22061993 — Thu, 16 Apr 2020 21:25:31 +0000

My electron app works as expected but it keeps on opening new windows when I run spectron test that tests for number of windows opened.

Versions Installed
npm ls --depth=0 demoelectronapp@1.0.0 C:\demoCLS\demoElectronApp +-- assert@2.0.0 +-- electron@8.2.2 +-- electron-packager@14.2.1 +-- mocha@7.1.1 +-- path@0.12.7 `-- spectron@10.0.1

I am just running a small demo, below I will give code snippet

Note: I am running the spectron test pointing to .exe file generated by electron-packager.

Does Anyone have an idea what is the issue if possible how to solve it?

main.js
`
const { app, BrowserWindow } = require('electron')

function createWindow () {

let win = new BrowserWindow({
width: 800,
height: 600,
webPreferences: {
nodeIntegration: true
}
})

win.loadFile('index.html')
}

app.whenReady().then(createWindow)

` **index.js** `
<!DOCTYPE html>

Hello World!

`

**test.js**

`

const assert = require('assert');
const path = require('path');
const Application = require('spectron').Application;
const electronPath = require('electron');

const app = new Application({
path: 'C:/demoElectronApp/winx64/demoelectronapp-win32-x64/demoelectronapp.exe',
});

describe('client_settings_app', function () {
this.timeout(10000);

beforeEach(() => {
  return app.start();
});

it('shows only one initial window', async () => {
  const count = await app.client.getWindowCount();
  return assert.equal(count, 1);
});

})

` **package.json** `
{
"name": "demoelectronapp",
"version": "1.0.0",
"description": "",
"main": "main.js",
"scripts": {
"test": "echo \"Error: no test specified\" && exit 1",
"electronpackage": "electron-packager . --out winx64"
},
"author": "",
"license": "ISC",
"dependencies": {
"path": "^0.12.7"
},
"devDependencies": {
"electron": "^8.2.2",
"electron-packager": "^14.2.1",
"assert": "^2.0.0",
"mocha": "^7.1.1",
"spectron": "^10.0.1"
}
}
`

Is setting position of elements relative or absolute elements to move left, right, top, bottom correct

karthik22061993 — Thu, 20 Feb 2020 11:11:38 +0000

To make elements move left, right, top, bottom I have to set position property to relative or absolute but when I resize the window, I see elements are rearranged incorrect way. I want to move elements left, right, top, bottom as well on window resize element to show in correct manner. How to achieve this?

Button and input elements doesn't get applied css style : background

karthik22061993 — Thu, 20 Feb 2020 11:09:03 +0000


I want to bring output similar to one shown in the figure. I build the table in table2() and build buttons using ButtonDOM().

I want to get the layout shown in figure, so I make the button elements move to right by some pixels. I have a basic question in css,

To make elements move left, right, top, bottom I have to set position property to relative or absolute but when I resize the window, I see elements are rearranged incorrect way. I want to move elements left, right, top, bottom as well on window resize element to show in correct manner. How to achieve this?

I have applied background color to whole div but I see the buttons and date input element appear outside the div, though all these elements are within this div.

Note : I had to position the input date and button elements relative and absolute and the div #buttonsdiv relative just to position elements where I needed

To know more about this question https://stackoverflow.com/questions/60318158/button-and-input-elements-doesnt-get-applied-css-style-background?noredirect=1#comment106697427_60318158

function maintest () {


   table2();
   ButtonDOM();
   addClasses();
  }



function table2 () {
    let h = $("<h3>").html("Borrowable Features:").prop("class","underline").appendTo("#BorrowableTable");
    let h1 = $("<h3>").html("Features:").prop("class","underline").appendTo("#BorrowableTable");
    let $table = $('<table>').attr({"id" : "borrowable"}).css({"width":"50%"});
    let $row1 = $('<tr>').appendTo($table);
    $('<td>').appendTo($row1);
    let header = $('<td>').text("Feature").appendTo($row1); 
    let $row2 = $('<tr>').prop("id","autocompleterow").appendTo($table);
    let $cell0 = $('<td>').appendTo($row2);



        let $cell1 = $('<td>').appendTo($row2);
        let $autocomplete1 = $("<input>").attr({"id" : "selector0","class":"creamcolorInput"}).appendTo($cell1);


        $("#BorrowableTable").append($table);
        autocomplete2 = $("#selector0").autocomplete( {"source": ['c++','java','javascript']}, {select: function(event, ui) { 
            selectedObj = ui.item.value; 


        } });

}



function addClasses () {
    let tableRows = $('tr').addClass('tableRows');
    let tableDefn = $('td').attr({"class":"tableDefn"});
    let tableHeader = $('th').attr({"class":"tableHeader"});
    let tbodyDOM = $('tbody').attr({"class" : "tbodyDOM"});
}


function ButtonDOM() {
  let buttonsdiv =  $("<div></div>").attr({"id":"buttonsdiv"}).css({"width":"50%"}).appendTo($("#BorrowableTable")); 
  let returnDate = $("<input>").attr({"id":"returnDate"}).appendTo($('#buttonsdiv'));
   $( "#returnDate" ).datepicker({ dateFormat: 'yy-mm-dd' }).attr({"class":"creamcolorInput"});

   $("<td>").html("Return Date").insertBefore(returnDate).css({"position":"relative","left":"350px","display":"inline"});
    $("<button>Borrow</button>").attr({"value":"Save","id":"borrowButton"}).appendTo(buttonsdiv)

}

#buttonsdiv {
     height: unset !important;
     width:50%;
     position: relative;
     left :50px !important;
     bottom :0px !important;
     background-color: papayawhip !important;
  }

  #BorrowableTable {
    display: flex !important; 
    flex-direction: column;
    height:fit-content !important;

  }


  #borrowable {
      display: unset !important; 
      border-collapse: collapse;
      border-spacing :unset !important;
      margin-left:100px;
  }




  #BorrowableTable,.creamcolorInput,#buttonsdiv {
    background-color: papayawhip;

  }

  #borrowButton {
    position: absolute;
    left: 325px;
    top: 50px;
    height: 36px;
    width: 205px;
    cursor: pointer;
    border: solid 1px;
    background-color:whitesmoke;
    font-family: ffunit;
    font-size: 14px;
    margin-top: 35px;
    margin-left: 2px;
}

     #returnDate {
      position: absolute;
      left : 330px !important;
      top:25px;
      height:36px;
      width:200px; 
  }
   .tableRows, .tableDefn, .tableHeader { /*added from addClasses() */

      padding: 0; 
      margin: 0;
      font-family: ffunit;
      font-size: 14px;
      font-weight: bold;
      padding-right: 50px !important;
    }



   button {
      height:36px;
      width:205px;
      cursor: pointer;
      border: solid 1px;
      background-color:whitesmoke;
      font-family: ffunit;
      font-size: 14px;
      margin-top:35px;
      margin-left: 2px;
  }


  input {
    height: 30px;
    width: 250px;
    font-size: 20px;
    text-indent: 6px;
  }



 .tbodyDOM {
   float:  left !important;
  } 

   .images {
      position: relative !important;
      cursor: pointer !important;
      width:35px !important;
      height:35px !important;
      left: 35px !important;

  } 

   .underline {
     text-decoration: underline;
  }

<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
<script src="https://code.jquery.com/ui/1.12.1/jquery-ui.min.js"></script>
<body onload="maintest()">

   <div id="BorrowableTable"></div>
</body>