how can i import data from a Json file with difference format?

Question

How can i add such this to ui-grid? I have a .Json with below format :

0:["date","numberOfTransaction", "price"]
1:["20170207", "3029223", "5294194476028"]
2:["20170208", "2176469", "1479374036275"]
3:["20170209", "2902111", "6971208095034"]
4:["all", "8107803", "13744776607337"]

That is not valid json...show actual sample – charlietfl Apr 30 '17 at 12:47 — charlietfl, Apr 30 '17 at 12:47

Hadi J · Accepted Answer · 2017-04-30T12:04:55.400

1

You should init ui-grid option manually. i.e you should init columnDefs and data array of ui-grid.

Like to this.

  angular.forEach($scope.myData,function(data,j){
    angular.forEach(data,function(d,i){
      if(j ==  0)
          $scope.gridOptions.columnDefs.push({field:d});
     else if(i == 0){
        var date = $scope.gridOptions.columnDefs[0];
        var numberOfTransaction = $scope.gridOptions.columnDefs[1];
        var price = $scope.gridOptions.columnDefs[2];
    $scope.gridOptions.data.push({date:data[0],numberOfTransaction:data[1],price:data[2]});
  }  
  }  
 })
})

Demo

edited Apr 30 '17 at 12:04

answered Apr 30 '17 at 11:59

Hadi J

16,989
4
36
62

if i have a column header with space . for example "number of transaction" What changes are needed? – Saeed Aliakbari May 01 '17 at 05:28
You do not need to change anything.Try test it in demo. – Hadi J May 01 '17 at 06:12
if i change var "numberOfTransaction" to "number of transaction" in demo making the syntax error – Saeed Aliakbari May 01 '17 at 06:17
why you change `var numberOfTransaction` to `var number Of Transaction`. its wrong. – Hadi J May 01 '17 at 06:28
the displayName of header must be "number of transaction" – Saeed Aliakbari May 01 '17 at 06:35
what i see something that you want to. please see demo. – Hadi J May 01 '17 at 06:37
can you help me to this link : https://stackoverflow.com/questions/44158461/angularjs-how-to-export-ui-grid-data-to-excel-with-custom-html – Saeed Aliakbari May 24 '17 at 12:44

score 0 · Answer 2 · answered Apr 30 '17 at 11:43

if your JSON is an object you need to access it by the property name.

 <div ng-app="app" ng-controller="ctrl">
     {{arr['0']}}
 </div>

angular.module("app",[])
.controller("ctrl",function($scope){
$scope.arr = {0:["date","numberOfTransaction", "price"],
1:["20170207", "3029223", "5294194476028"],
2:["20170208", "2176469", "1479374036275"],
3:["20170209", "2902111", "6971208095034"],
4:["all", "8107803", "13744776607337"]}

})

<script src="https://ajax.googleapis.com/ajax/libs/angularjs/1.2.23/angular.min.js"></script>
<div ng-app="app" ng-controller="ctrl">
 {{arr['0']}}
</div>

thank you can you describe this to ui-grid in plnkr? – Saeed Aliakbari Apr 30 '17 at 11:50 — Saeed Aliakbari, Apr 30 '17 at 11:50

how can i import data from a Json file with difference format?

2 Answers2