Friday, July 26, 2019

Convert CSV to Json using javascript


<html>
<head>
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<script type="text/javascript" >
//Function for converting from CSV to JSON. This function is consider as a backend component for performing this task.
var csvjsonConverter = (csvdata, delimiter) => {
//This array will store the each of the patterns from the regular expression below.
let arrmatch = [];
//This array will store the data from the CSV.
let array = [[]];
//Stores matched values for quoted values.
let quotevals = "";
//Storing JSON array
let jsonarray = [];
//Increment value
let k = 0;
//Uses regular expression to parse the CSV data and determines if any values has their own quotes in case if any
// delimiters are within.
let regexp = new RegExp(("(\\" + delimiter + "|\\r?\\n|\\r|^)" + "(?:\"([^\"]*(?:\"\"[^\"]*)*)\"|" +
"([^\"\\" + delimiter + "\\r\\n]*))"), "gi");
//This will loop to find any matchings with the regular expressions.
while (arrmatch = regexp.exec(csvdata)) {
//This will determine what the delimiter is.
let delimitercheck = arrmatch[1];
//Matches the delimiter and determines if it is a row delimiter and matches the values to the first rows.
//If it reaches to a new row, then an empty array will be created as an empty row in array.
if ((delimitercheck !== delimiter) && delimitercheck.length) {
array.push([]);
}
//This determines as to what kind of value it is whether it has quotes or not for these conditions.
if (arrmatch[2]) {
quotevals = arrmatch[2].replace('""', '\"');
}
else {
quotevals = arrmatch[3];
}
//Adds the value from the data into the array
array[array.length - 1].push(quotevals);
}
//This will parse the resulting array into JSON format
for (let i = 0; i < array.length - 1; i++) {
jsonarray[i - 1] = {};
for (let j = 0; j < array[i].length && j < array[0].length; j++) {
let key = array[0][j];
jsonarray[i - 1][key] = array[i][j]
}
}
//This will determine what the properties of each values are from the JSON
//such as removing quotes for integer value.
for(k = 0; k < jsonarray.length; k++){
let jsonobject = jsonarray[k];
for(let prop in jsonobject){
if(!isNaN(jsonobject[prop]) && jsonobject.hasOwnProperty(prop)){
jsonobject[prop] = +jsonobject[prop];
}
}
}
//This will stringify the JSON and formatting it.
let formatjson = JSON.stringify(jsonarray, null, 2);
//Returns the converted result from CSV to JSON
return formatjson;
};
//This jQuery will perform in the front-end to convert from CSV to JSON.
$(function () {
//When the 'Convert' button is clicked, it will first make sure if the csv file is uploaded and then it goes to the
//convert function above to convert it from CSV to JSON. Afterwards, it will print the result in a textarea.
$("#convert").click(function () {
var csv = $("#csv")[0].files[0];
if (csv !== undefined) {
var reader = new FileReader();
reader.onload = function (e) {
var rows = e.target.result;
var convertjson = csvjsonConverter(rows, $("#delimiter").val());
$("#json").val(convertjson);
};
reader.readAsText(csv);
}
else{
$("#json").val("");
alert("Please upload your csv file.");
}
});
//After the user clicks on 'Download JSON Result" button, it will download the converted JSON file.
$("#download").click(function () {
var result = $("#json").val();
if (result === null || result === undefined || result === "") {
alert("Please make sure there is JSON data in the text area.");
}
else {
$("<a />", {
"download": "data.json",
"href": "data:application/json;charset=utf-8," + encodeURIComponent(result),
}).appendTo("body")
.click(function () {
$(this).remove()
})[0].click()
}
}
);
});
</script>
</head>
<body>
<div class="container clearfix">
<div id="content">
<h1>Convert CSV To JSON Example</h1>
<p>Click here to upload your CSV file:</p>
<input type="file" id="csv" />
<br />
<br />
<p>Select your delimiter:</p>
<select id="delimiter">
<option id="comma" value=",">,</option>
<option id="pipe" value="|">|</option>
</select>
<br />
<br />
<button class="btn btn-danger" id="convert">Convert</button>
<br />
<br />
<textarea id="json" class="textareasize"></textarea>
<br/>
<button class="btn btn-danger" id="download">Download JSON Results</button>
</div>
</div>
</body>
</html>
view raw convertcsvtojsonjs hosted with ❤ by GitHub
Posted by at 0 Comments

Friday, October 26, 2018

How to configure ssh login with out password in Mac OS X and Linux


When ever we want to connect to remote server (or) host using SSH we will provide the host name after it prompt for password. If we follow the below step it won't ask for the password on each time.
ssh password less login


STEP 1 - Generating the key pair

Create your set of keys:
Start up the Terminal application and run:
ssh-keygen -t rsa -b 4096



STEP2 - Copy Generated public to our remote server


Copy the newly created public key to the SSH server(s) you need to auto login into by using your favourite transport method.

Please be careful not to overwrite ~/.ssh/authorized_keys if it already exist! This is how I personally copy the key, might not be your preferred method:

If authorized_keys exist:
cat ~/.ssh/id_rsa.pub | ssh username@example.com "cat - >> ~/.ssh/authorized_keys"
If authorized_keys does not exist:
scp ~/.ssh/id_rsa.pub username@example.com:~/.ssh/authorized_keys


Check your file permissions. A lot of different *nix system is picky when it comes to permissons. Setting your .ssh directory to 0700 and .ssh/authorized_keys to 0600.

  chmod 0700 ~/.ssh
  chmod 0600 ~/.ssh/authorized_keys
Posted by at 0 Comments
Labels: , , ,

Tuesday, May 29, 2018

Read the data from server using Backbone js collection fetch data




<html>
<head>
<title>TODO supply a title</title>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
</head>
<body>
<div>Tag List</div>
<div id="tagTab">
<input type="text" name="name" id="name" />
<button id="addTag"> Add</button>
<ul id="tagList">
</ul>
</div>
<script type="text/template" id="tag-name-template">
<li>
<%= title %>
</li>
</script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/underscore.js/1.9.0/underscore-min.js"></script>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/backbone.js/1.3.3/backbone-min.js"></script>
<script>
var app = {};
var tagModel = Backbone.Model.extend({
defaults: {
title: 'mak',
status: false
},
initialize: function() {
}
});
var tagCollection = Backbone.Collection.extend({
model: tagModel,
initialize: function() {
// console.log("collection added creation");
// this.fetch();
},
url: 'https://jsonplaceholder.typicode.com/posts',
parse: function(response) {
return response;
}
});
var tagNameView = Backbone.View.extend({
template: _.template($('#tag-name-template').html()),
initialize: function() {
this.render();
},
render: function() {
this.$el.html(this.template(this.model.toJSON()));
return this;
// return this.template(this.mode);
}
});
var tagTabView = Backbone.View.extend({
el: $('#tagTab'),
model: new tagCollection(),
initialize: function() {
this.render();
this.model.on('add', this.render, this);
this.model.fetch();
},
render: function() {
this.$('#tagList').html(''); // clean the todo list
// console.log(this.model);
for (var i = 0; i < this.model.length; ++i) {
// console.log(this.model.at(i));
this.$('#tagList').append(new tagNameView({
model: this.model.at(i)
}).el);
}
},
events: {
'click #addTag': 'add'
},
//To add the item to collections
add: function() {
// this.model.add(new tagModel({title:$("#name").val()}));
this.model.add({
title: $("#name").val()
});
$("#name").val("");
}
});
app.view = new tagTabView();
</script>
</body>
</html>
view raw postList.html hosted with ❤ by GitHub



Posted by at 0 Comments

Linux-Shell Script to Move to specific folder using "cd" command




Shell scripts are run inside a subshell, and each subshell has its own concept of what the current directory is. The cd succeeds, but as soon as the subshell exits, you're back in the interactive shell and nothing ever changed there.

 To Resolve that we use bash command. 




#!/bin/sh
#!/bin/bash

cd "/opt/azw/webapp/src/";
bash



Posted by at
Labels: , ,

Thursday, January 4, 2018

To pull specific directory with git


To pull specific folder from git repository or git repo

mkdir directoryName
cd directoryName
git init
git remote add origin -f <>
git config core.sparsecheckout true
echo / >> .git/info/sparse-checkout
git pull origin master




Posted by at
Labels:

Monday, October 16, 2017

Python Cheat Sheet

Python Cheat Sheet





Posted by at 0 Comments

Friday, October 6, 2017

Connect to Microsoft SQL Server Using PHP

Connect to Microsoft SQL Server Using PHP


Below Code will connect to the Microsoft Sql Server using php script.

<?php
$serverName = "*****.*****.****.**";//Host Name
$uid = "mtcdb";//User Name
$pwd = "******";//Password
$databaseName = "Mobile_Dev";//Database Name
$connectionInfo = array("UID" => $uid,
"PWD" => $pwd,
"Database" => $databaseName);
/* Connect using SQL Server Authentication. */
$conn = sqlsrv_connect($serverName, $connectionInfo);
if( $conn )
{
echo "Connected";
}
else
{
echo "<pre>";
die( print_r( sqlsrv_errors(), true));
}
//var_dump($conn);exit;
$tsql = "SELECT * FROM users";
/* Execute the query. */
$stmt = sqlsrv_query($conn, $tsql);
if ($stmt) {
echo "Statement executed.<br>\n";
} else {
echo "Error in statement execution.\n";
die(print_r(sqlsrv_errors(), true));
}
/* Iterate through the result set printing a row of data upon each iteration. */
while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_NUMERIC)) {
// print_r($row);exit;
echo "Col1: " . $row[0] . "\n";
echo "Col2: " . $row[1] . "\n";
echo "Col3: " . $row[2] . "<br>\n";
echo "-----------------<br>\n";
}
/* Free statement and connection resources. */
sqlsrv_free_stmt($stmt);
sqlsrv_close($conn);
view raw mssqlserver.php hosted with ❤ by GitHub
Posted by at 0 Comments
Labels: , , ,
Subscribe to: Posts (Atom)