Mr Mirchi Posted April 5, 2019 Report Share Posted April 5, 2019 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 } ] } Quote Link to comment Share on other sites More sharing options...
afacc123 Posted April 5, 2019 Report Share Posted April 5, 2019 Nothing on google or stackoverflow? i believe you are not the first person doing this Quote Link to comment Share on other sites More sharing options...
Mitron Posted April 5, 2019 Report Share Posted April 5, 2019 Just now, afacc123 said: Nothing on google or stackoverflow? i believe you are not the first person doing this Quote Link to comment Share on other sites More sharing options...
vendettaa Posted April 5, 2019 Report Share Posted April 5, 2019 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 Quote Link to comment Share on other sites More sharing options...
Biskot2 Posted April 5, 2019 Report Share Posted April 5, 2019 nuvvu aa technology no cheppa ledhu kabatti.. general tool csv to json here http://www.convertcsv.com/csv-to-json.htm Quote Link to comment Share on other sites More sharing options...
vendettaa Posted April 5, 2019 Report Share Posted April 5, 2019 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 1 Quote Link to comment Share on other sites More sharing options...
Mitron Posted April 5, 2019 Report Share Posted April 5, 2019 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. Quote Link to comment Share on other sites More sharing options...
Mr Mirchi Posted April 5, 2019 Author Report Share Posted April 5, 2019 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 Quote Link to comment Share on other sites More sharing options...
afacc123 Posted April 5, 2019 Report Share Posted April 5, 2019 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 Quote Link to comment Share on other sites More sharing options...
Biskot2 Posted April 5, 2019 Report Share Posted April 5, 2019 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..) Quote Link to comment Share on other sites More sharing options...
Katara Posted April 5, 2019 Report Share Posted April 5, 2019 Save file as csv , use online csv https://www.csvjson.com/csv2json 1 Quote Link to comment Share on other sites More sharing options...
Mr Mirchi Posted April 5, 2019 Author Report Share Posted April 5, 2019 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 Quote Link to comment Share on other sites More sharing options...
karthikn Posted April 5, 2019 Report Share Posted April 5, 2019 14 minutes ago, Mitron said: ok. you work on spark. understood. Quote Link to comment Share on other sites More sharing options...
Mr Mirchi Posted April 5, 2019 Author Report Share Posted April 5, 2019 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 Quote Link to comment Share on other sites More sharing options...
BhagBhagDKBose Posted April 5, 2019 Report Share Posted April 5, 2019 use kondachiluva 3.x kathi lanti grandhalayalu untayi aa bhasha lo Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.