Storing multiple parameters with different values using arrays in JSON

Question

0.00/5 (No votes)

See more:

I'm having 3 classes namely A, B and C...! Each class having different parameters, i.e, A-->a,b,c,d,e,f, B--> g,h,i,j and C--> k,l,m,n...! Each parameter having 4 values namely min,max,def and cur...!

`var obja="A": {
"a":{"Default":0.0,"Current":30.0,"Min":0.0,"Max":200.0},
"b":{"Default":0.0,"Current":60.0,"Min":0.0,"Max":10.44},
"c":{"Default":0.0,"Current":60.0,"Min":0.0,"Max":89.0},
"d":{"Default":1.0,"Current":60.0,"Min":1.0,"Max":255.0},
"e":{"Default":1.0,"Current":60.0,"Min":1.0,"Max":255.0},
"f":false
}

var objb="B":{
"g":{"Default":0.0,"Current":15.0,"Min":10.0,"Max":20.4},
"h":{"Default":1.0,"Current":120.0,"Min":1.0,"Max":255.0},
"i":{"Default":0.0,"Current":60.0,"Min":0.0,"Max":10.44},
"j":{"Default":1.0,"Current":60.0,"Min":1.0,"Max":255.0}
}

var objc="C":{
"k":{"Default":0.0,"Current":10.0,"Min":0.0,"Max":3.06},
"l":{"Default":1.0,"Current":3.5,"Min":0.0,"Max":2.55},
"m":{"Default":0.0,"Current":3.0,"Min":0.0,"Max":2.55},
"n":{"Default":0.0,"Current":401.0,"Min":0.0,"Max":1270.0}
}`

Is it correct way in JSON as am new to JSON..!

I appreciate for any suggestion on this..!

What I have tried:

`var obja="A": {
"a":{"Default":0.0,"Current":30.0,"Min":0.0,"Max":200.0},
"b":{"Default":0.0,"Current":60.0,"Min":0.0,"Max":10.44},
"c":{"Default":0.0,"Current":60.0,"Min":0.0,"Max":89.0},
"d":{"Default":1.0,"Current":60.0,"Min":1.0,"Max":255.0},
"e":{"Default":1.0,"Current":60.0,"Min":1.0,"Max":255.0},
"f":false
}

var objb="B":{
"g":{"Default":0.0,"Current":15.0,"Min":10.0,"Max":20.4},
"h":{"Default":1.0,"Current":120.0,"Min":1.0,"Max":255.0},
"i":{"Default":0.0,"Current":60.0,"Min":0.0,"Max":10.44},
"j":{"Default":1.0,"Current":60.0,"Min":1.0,"Max":255.0}
}

var objc="C":{
"k":{"Default":0.0,"Current":10.0,"Min":0.0,"Max":3.06},
"l":{"Default":1.0,"Current":3.5,"Min":0.0,"Max":2.55},
"m":{"Default":0.0,"Current":3.0,"Min":0.0,"Max":2.55},
"n":{"Default":0.0,"Current":401.0,"Min":0.0,"Max":1270.0}
}`

Posted 26-Sep-16 20:29pm

Member 11373970

Updated 26-Sep-16 20:34pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Karthik_Mahalingam · Answer 1 · 2016-09-26T20:34:00

Solution 1

it should be something like this

JavaScript

var obj = {
                "A": {
                    "a": { "Default": 0.0, "Current": 30.0, "Min": 0.0, "Max": 200.0 },
                    "b": { "Default": 0.0, "Current": 60.0, "Min": 0.0, "Max": 10.44 },
                    "c": { "Default": 0.0, "Current": 60.0, "Min": 0.0, "Max": 89.0 },
                    "d": { "Default": 1.0, "Current": 60.0, "Min": 1.0, "Max": 255.0 },
                    "e": { "Default": 1.0, "Current": 60.0, "Min": 1.0, "Max": 255.0 },
                    "f": false
                },
                "B": {
                    "g": { "Default": 0.0, "Current": 15.0, "Min": 10.0, "Max": 20.4 },
                    "h": { "Default": 1.0, "Current": 120.0, "Min": 1.0, "Max": 255.0 },
                    "i": { "Default": 0.0, "Current": 60.0, "Min": 0.0, "Max": 10.44 },
                    "j": { "Default": 1.0, "Current": 60.0, "Min": 1.0, "Max": 255.0 }
                },
                "C": {
                    "k": { "Default": 0.0, "Current": 10.0, "Min": 0.0, "Max": 3.06 },
                    "l": { "Default": 1.0, "Current": 3.5, "Min": 0.0, "Max": 2.55 },
                    "m": { "Default": 0.0, "Current": 3.0, "Min": 0.0, "Max": 2.55 },
                    "n": { "Default": 0.0, "Current": 401.0, "Min": 0.0, "Max": 1270.0 }
                }
            }

            // example
            var aCur = obj.A.a.Current;
            var bmin = obj.B.g.Min;

refer JSON.parse()[^] method for parsing the JSON string

for visual representation Json Parser Online[^]

Posted 26-Sep-16 20:34pm

Karthik_Mahalingam

Updated 26-Sep-16 20:36pm

v2

Comments

Karthik_Mahalingam 27-Sep-16 4:33am

pls provide the same output.
or if you have some screenshot

Member 11373970 27-Sep-16 5:01am

It should be like this in grid format as 1st and 2nd row.(Unable to attach screenshot here)
5 2 4 200 50 10 1 600 5 51 50 1

8 4 2 620 10 55 2 150 8 16 25 0

Displays only current value of each parameter..!
Provided by you is for one row..!

Karthik_Mahalingam 27-Sep-16 5:04am

how did you format this data
https://snag.gy/ for screenshot

Member 11373970 27-Sep-16 5:33am

Thanks Karthik for your response..!
https://snag.gy/8MGxLn.jpg (For Screenshot)

Displays only current values of each parameter and it was not required to mention Min, Max and default vales.
Instead it should be only with current values like below.

var obj = {
"A": {
"a": { "Current": 30.0},
"b": { "Current": 60.0},
"c": { "Current": 60.0},
"d": { "Current": 60.0},
"e": { "Current": 60.0},
"f": false
},
"B": {
"g": { "Current": 30.0},
"h": { "Current": 60.0},
"i": { "Current": 60.0},
"j": { "Current": 60.0},
},
"C": {
"k": { "Current": 30.0},
"l": { "Current": 60.0},
"m": { "Current": 60.0},
"n": { "Current": 60.0},
}
}

Please suggest me the best way..!

Karthik_Mahalingam 27-Sep-16 5:39am

what is the logic to display the data in the screenshot.

Member 11373970 27-Sep-16 5:48am

I will take care of the logic to read the data from JSON file and display the same in my grid.
But, my question is..the data should be in JSON structure..!

Karthik_Mahalingam 27-Sep-16 5:54am

the above comment json is a valid one..
what question in that.

Member 11373970 27-Sep-16 5:57am

That's fine Karthik.
The above one was fine for 1st row.
How to add the values of 4 rows (in JSON text file) in best way..!

Karthik_Mahalingam 27-Sep-16 6:06am

rajesh
still i am not getting your exact need.

Member 11373970 27-Sep-16 6:10am

Need four current values of each parameter and that should be in JSON format to display as four rows in grid.

The above one was with 1 current value..!

Karthik_Mahalingam 27-Sep-16 6:12am

which 4 current values? be more specific, then only i can help you. else its difficult for me to understand your issue.

Member 11373970 27-Sep-16 6:26am

3 classes namely A, B and C.
Each class having different parameters, i.e, A-->a,b,c,d,e,f, B--> g,h,i,j and C--> k,l,m,n...!
Each parameter having 4 values.. i.e., a.value--> 10, 45, 85,1 and b.value --> 4,55,98,4.(In JSON format).

Hope you understand..!

Karthik_Mahalingam 27-Sep-16 6:39am

so now you need only the values of all clas?

Member 11373970 27-Sep-16 6:48am

Yes..!

Karthik_Mahalingam 27-Sep-16 6:59am

how you need, in an array?>

Member 11373970 27-Sep-16 7:16am

Yes Karthik..!

Karthik_Mahalingam 27-Sep-16 7:42am

Member 11373970 27-Sep-16 8:17am

Great Karthik..!
But, am expecting text file with the values in JSON structure/format..!

Karthik_Mahalingam 27-Sep-16 8:20am

how can you use text file ?

Member 11373970 27-Sep-16 8:31am

It will be done like below..!

JObject o1 = JObject.Parse(File.ReadAllText(@"c:\videogames.json"));

// read JSON directly from a file
using (StreamReader file = File.OpenText(@"c:\videogames.json"))
using (JsonTextReader reader = new JsonTextReader(file))
{
JObject o2 = (JObject)JToken.ReadFrom(reader);
}

Accordingly,need .json file with all values, as mentioned earlier..!

Karthik_Mahalingam 27-Sep-16 10:05am

newton soft?

Member 11373970 28-Sep-16 1:20am

Exactly Karthikk..!

Karthik_Mahalingam 28-Sep-16 1:23am

Always use Reply button, to maintain the conv chain.

Karthik_Mahalingam 28-Sep-16 1:24am

so now what is the issue

Member 11373970 28-Sep-16 1:37am

Sure..!
Need .json file with all values, as mentioned earlier..!

Karthik_Mahalingam 28-Sep-16 2:02am

i have given you the code, you can use that in web page to get only the values.

Member 11373970 28-Sep-16 2:07am

Not code am looking for..!
It should be in JSON format like below.

var obj = {
"A": {
"a": { "Current": 30.0},
"b": { "Current": 60.0},
"c": { "Current": 60.0},
"d": { "Current": 60.0},
"e": { "Current": 60.0},
"f": false
},
"B": {
"g": { "Current": 30.0},
"h": { "Current": 60.0},
"i": { "Current": 60.0},
"j": { "Current": 60.0},
},
"C": {
"k": { "Current": 30.0},
"l": { "Current": 60.0},
"m": { "Current": 60.0},
"n": { "Current": 60.0},
}
}

Above one for 1 value...in the same way need 4 values for each parameter of a class in JSON format..!

Member 11373970 28-Sep-16 2:27am

Need to add 3 more values for each parameter of a class in above mentioned format..!

Karthik_Mahalingam 28-Sep-16 3:53am

what is the input?

Member 11373970 28-Sep-16 3:57am

I'll get these values programmatically from Hardware Kit..!
But, for this time being Input is JSON file with all values..!

Karthik_Mahalingam 28-Sep-16 4:04am

post the sample data of input file.

Member 11373970 28-Sep-16 4:29am

PFB...!

Class A --> a,b,c,d,e,f
Class B --> g,h,i,j
Clacc C --> k,l,m,n

Sample Values:
a --> 5,8,10,12
b --> 2,4,3.5,6
c --> 4,2,3,5
d --> 200,620,401,124
e --> 5,10.1,15
f --> True/false

g --> 10,55,120,69
h --> 15,2.65,7.5,9
i --> 600,1.5,2,8
j --> 5,8,16,55

k --> 5,16,18,12
l --> 10.1,5,15,85
m --> 13,21,9,75
n --> 5,75,20,1

Karthik_Mahalingam 28-Sep-16 4:37am

post a screenshot on the input file data

Member 11373970 28-Sep-16 4:42am

Same provided above.
For Screenshot: https://snag.gy/gPxpWK.jpg

Karthik_Mahalingam 28-Sep-16 6:56am

this is not a json

Member 11373970 28-Sep-16 7:10am

Yes Karthik..I know that..!
But,for demo purpose to the client need some values in JSON format.

Karthik_Mahalingam 28-Sep-16 9:19am

its difficult to convert to json.
unless we know the exact data format in the file.

Member 11373970 28-Sep-16 9:39am

Thanks for your response Karthik..!
I will take care of conversion to/from JSON....just need values for each parameter of a class in json format(in text file) like mentioned above..!

Karthik_Mahalingam 28-Sep-16 12:45pm

hmm ok.. try it.

Member 11373970 29-Sep-16 2:14am

Hey Karthik,
Need your help..! To create text file with all values in json format like below.

var obj = {
"A": {
"a": { "Current": 30.0},
"b": { "Current": 60.0},
"c": { "Current": 60.0},
"d": { "Current": 60.0},
"e": { "Current": 60.0},
"f": false
},
"B": {
"g": { "Current": 30.0},
"h": { "Current": 60.0},
"i": { "Current": 60.0},
"j": { "Current": 60.0},
},
"C": {
"k": { "Current": 30.0},
"l": { "Current": 60.0},
"m": { "Current": 60.0},
"n": { "Current": 60.0},
}
}

Need to add more three values to each parameter in above format..!

Like --> a--Current: 30.0,42.0,12.5,788

Karthik_Mahalingam 29-Sep-16 2:19am

just save it in text file
https://msdn.microsoft.com/en-us/library/8bh11f1k.aspx

Member 11373970 29-Sep-16 2:33am

No Karthik..! Not program am looking for.
Instead I just want you to create file with all values manually in json format(in txt file)..!

Later will read the data from that txt file to display the same in grid format.

Karthik_Mahalingam 29-Sep-16 2:37am

ok from where will you get the data

Karthik_Mahalingam 29-Sep-16 2:38am

from where you are getting the data

Member 11373970 29-Sep-16 3:08am

Actually will get the data from Hardware KIT(In final stage) and will convert all values to txt file in JSON format.
But,for this time being,need dummy data in txt file to check the functionally ..that too JSON format..
So, that data you have enter manually in txt file because you're aware of JSON and it's format.

Karthik_Mahalingam 29-Sep-16 4:17am

just put these values in text file and parse it as json , it will work.
{
"A": {
"a": { "Current": 30.0},
"b": { "Current": 60.0},
"c": { "Current": 60.0},
"d": { "Current": 60.0},
"e": { "Current": 60.0},
"f": false
},
"B": {
"g": { "Current": 30.0},
"h": { "Current": 60.0},
"i": { "Current": 60.0},
"j": { "Current": 60.0},
},
"C": {
"k": { "Current": 30.0},
"l": { "Current": 60.0},
"m": { "Current": 60.0},
"n": { "Current": 60.0},
}
}

Member 11373970 29-Sep-16 4:26am

Please add three more values to each parameter of a class manually in above mentioned, because am not aware how to/where to add in above mentioned.

Karthik_Mahalingam 29-Sep-16 4:51am

seriously you are into a blind approach, pls ask your team lead to expalin the requirements

Member 11373970 29-Sep-16 5:26am

Thanks Karthik..!
https://www.sitepoint.com/google-maps-json-file/ (this is what am looking for)

No problem..my problem got solved from above link.

Karthik_Mahalingam 29-Sep-16 5:31am

good.