excel data to json - help

[Mr Mirchi]

400K records vunnavi na excel file lo...e 400k records ni (each row one object) json objects ga one or multiple files ki elaa convert cheyaali .....server sql server...

 

each row lo e data vuntadhi

{

 fname: test

lname: test

courses : [

   {

        course: abc

      date: 12/12/2009

  },

{

        course: xyz

      date: 12/12/2010

    }

]

}

[afacc123]

Nothing on google or stackoverflow?

i believe you are not the first person doing this

[Mitron]

Just now, afacc123 said:

Nothing on google or stackoverflow?

i believe you are not the first person doing this

[vendettaa]

Cool your excel data might be csv or text file format right 

you can use spark 

read it as csv and save it as json 

[Biskot2]

nuvvu aa technology no cheppa ledhu kabatti.. general tool csv to json here

http://www.convertcsv.com/csv-to-json.htm

[vendettaa]

nenaite ila chesta

i will read that csv file in spark and create a dataframe out of it

then i will load it to sql server as format json . idanta spark lo cheyochu 

[Mitron]

Just now, vendettaa said:

nenaite ila chesta

i will read that csv file in spark and create a dataframe out of it

then i will load it to sql server as format json . idanta spark lo cheyochu 

 

3 minutes ago, vendettaa said:

Cool your excel data might be csv or text file format right 

you can use spark 

read it as csv and save it as json 

ok. you work on spark.

understood.

[Mr Mirchi]

6 minutes ago, Biskot2 said:

nuvvu aa technology no cheppa ledhu kabatti.. general tool csv to json here

http://www.convertcsv.com/csv-to-json.htm

java.... java program radham anukuntunna to write to a text file....emanna tools vunnavemo easy ga fast fga avataniki checking....google chesthunnaaale.. oka online tool dhorikidhi, but nested array ela ravalo teliyatam ledhu....

acutally na data database table lo vundhi....but oracle 12.1 suport cheyatam ledhu json functions.

 

sql server lo teliyadhu

 

www.csvjson.com/csv2json  -- idhi work avuthundhi but nested array elaa ani trying

[afacc123]

2 minutes ago, Mr Mirchi said:

java.... java program radham anukuntunna to write to a text file....emanna tools vunnavemo easy ga fast fga avataniki checking....google chesthunnaaale.. oka online tool dhorikidhi, but nested array ela ravalo teliyatam ledhu....

 

www.csvjson.com/csv2json  -- idhi work avuthundhi but nested array elaa ani trying

Use java 8 streams with collections with functional programming for better performances 

[Biskot2]

1 minute ago, Mr Mirchi said:

java.... java program radham anukuntunna to write to a text file....emanna tools vunnavemo easy ga fast fga avataniki checking....google chesthunnaaale.. oka online tool dhorikidhi, but nested array ela ravalo teliyatam ledhu....

 

www.csvjson.com/csv2json  -- idhi work avuthundhi but nested array elaa ani trying

nuvvu akkada object declare chesi, break chesi , assign cheyalsi vasthadhi bro.. (nested arrays ke..)

[Katara]

Save file as csv , use online csv

https://www.csvjson.com/csv2json

[Mr Mirchi]

6 minutes ago, Katara said:

Save file as csv , use online csv

https://www.csvjson.com/csv2json

pyna nenu cheppinattu idhi worked bro...but nested arrays ki option ledhu dheenilo 

[karthikn]

14 minutes ago, Mitron said:

 

ok. you work on spark.

understood.

[Mr Mirchi]

7 minutes ago, Biskot2 said:

nuvvu akkada object declare chesi, break chesi , assign cheyalsi vasthadhi bro.. (nested arrays ke..)

yaa..java lo i can...but 400k records dbbase numdi read chesi convert chesi text file ki raayaali...aa file vere team ki ivvaali.....performance concern IO streams kabatti..java coding option naa last option ...sql server lo option vunnattu vundhi but how does it perform anedhi chudaali

[BhagBhagDKBose]

use kondachiluva 3.x kathi lanti grandhalayalu untayi aa bhasha lo