• Products
  • Solutions
  • Made with Unity
  • Learning
  • Support & Services
  • Community
  • Asset Store
  • Get Unity

UNITY ACCOUNT

You need a Unity Account to shop in the Online and Asset Stores, participate in the Unity Community and manage your license portfolio. Login Create account
  • Blog
  • Forums
  • Answers
  • Evangelists
  • User Groups
  • Beta Program
  • Advisory Panel

Navigation

  • Home
  • Products
  • Solutions
  • Made with Unity
  • Learning
  • Support & Services
  • Community
    • Blog
    • Forums
    • Answers
    • Evangelists
    • User Groups
    • Beta Program
    • Advisory Panel

Unity account

You need a Unity Account to shop in the Online and Asset Stores, participate in the Unity Community and manage your license portfolio. Login Create account

Language

  • Chinese
  • Spanish
  • Japanese
  • Korean
  • Portuguese
  • Ask a question
  • Spaces
    • Default
    • Help Room
    • META
    • Moderators
    • Topics
    • Questions
    • Users
    • Badges
  • Home /
avatar image
1
Question by Gilead7 · Mar 20, 2019 at 05:02 PM · c#arraylistjsonlinq

Instantiate a prefab from jsonarray?

I'm using php and mysql to get a json string from the database via the www and using the simplejson library. From what I understand the www comes in as a string. What I want to do is convert it to a jsonarray, which I did: WWW VehicleData = new WWW ("http://localhost/CMVM/ViewVehicle.php", VehicleDataForm);

         yield return VehicleData;
         string VD = VehicleData.text;
         JSONArray VehicleArray = JSON.Parse (VD).AsArray;

I did a debug on it and it works very well. Now I need to instantiate my prefab with text components, but I only know how to do that using a list

 for(int i = 0; i< VehicleArray.Count; i++)
         {
             GameObject vObj = Instantiate(VehiclePrefab);
             VehicleIndex tmpVehicle = VehicleArray[i];
             vObj.GetComponent<VehicleIndexScript> ().DisplayVehicles ("ID:" + tmpVehicle.ID, "Vehcile Make: " + tmpVehicle.Make, "Vehicle Model:" + tmpVehicle.Model, "Vehicle Year: " + tmpVehicle.Year, "Vehicle Mileage:" + tmpVehicle.Mileage + tmpVehicle.Location, "Location:");
             vObj.transform.SetParent(DatabasedisplayParent); 
         }

I tried just using the array, but it gave me a conversion error: error CS0029: Cannot implicitly convert type SimpleJSON.JSONNode' to VehicleIndex'

What's the best way to proceed? Do I try to convert the jsonarray to a list? If so how do I do that? linq? Do I try to instantiate using the jsonarray? if so how do I do that?

Thanks!!

Comment
Add comment · Show 1
10 |3000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users
avatar image mchts · Mar 20, 2019 at 08:56 PM 0
Share

Create a serializable class for your VehicleData array.

 [Serializable]
 public void VehicleDataArray{
     public VehicleData[] array;
 }

Instantiate a new VehicleDataArray and add all your VehicleData instances to array(i assume your VehicleData is also [Serializable]. Cause it must be). Then do following to convert it to json array and save the result:

 var jsonArray = JsonUtility.ToJson([your VehicleDataArray instance]);
 //save jsonArray

When you want to retrieve data just do following:

 //load your jsonArray text file again
 var vehicleDataArray = JsonUtility.FromJson<VehicleDataArray>(jsonArray);

Now you can reach your each VehicleData from vehicleDataArray.array. Just use a for loop or whatever you want...

1 Reply

· Add your reply
  • Sort: 
avatar image
1
Best Answer

Answer by Bunny83 · Mar 20, 2019 at 10:18 PM

What does your json actually look like? Give an example. JSON is just an object notation. Keep in mind that SimpleJSON is not an object deserializer. It just provides the json data in a structured manner. You don't need any extra classes for your json data when using SimpleJSON. Just access the fields you want to access.


Just from your code fragments i guess your json would look something like this:

 [
     {
         "ID" : 1,
         "Make" : "aaaa",
         "Model" : "bbbb",
         "Year" : "cccc",
         "Mileage" : "dddd",
         "Location" : "eeee"
     },
     {
         "ID" : 2,
         "Make" : "aaaa",
         "Model" : "bbbb",
         "Year" : "cccc",
         "Mileage" : "dddd",
         "Location" : "eeee"
     }
 ]

If that's the case you would read that data like this:

 var vehicles = JSON.Parse(jsonText);
 foreach(JSONNode v in vehicles)
 {
     GameObject vObj = Instantiate(VehiclePrefab);
     vObj.GetComponent<VehicleIndexScript> ().DisplayVehicles (
         "ID:" + v["ID"].AsInt,
         "Vehcile Make: " + v["Make"].Value;
         "Vehicle Model:" + v["Model"].Value,
         "Vehicle Year: " + v["Year"].Value,
         "Vehicle Mileage:" + v["Mileage"].Value,
         "Location:"+ v["Location"].Value
     );
 }

This assumes you're using the latest version from github.


If your actual json data looks different, please edit your question and include an example

Comment
Add comment · Show 1 · Share
10 |3000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users
avatar image Gilead7 · Mar 21, 2019 at 06:21 PM 0
Share

In this case, the ID is a string, so I changed it to Value. In order for the id to show up, the index has to read VehicleID.Value. It is working! Thanks Bunny!

Your answer

Hint: You can notify a user about this post by typing @username

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Welcome to Unity Answers

The best place to ask and answer questions about development with Unity.

To help users navigate the site we have posted a site navigation guide.

If you are a new user to Unity Answers, check out our FAQ for more information.

Make sure to check out our Knowledge Base for commonly asked Unity questions.

If you are a moderator, see our Moderator Guidelines page.

We are making improvements to UA, see the list of changes.



Follow this Question

Answers Answers and Comments

608 People are following this question.

avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image

Related Questions

Adding more than one item to the list and saving it into JSON file problem 1 Answer

Detecting OnMouseDown from colliders in an array 1 Answer

How to make a or array of GUI.Button's? 1 Answer

Pick between two floats 2 Answers

C#, LINQ and Lists - help with 1 line of code? 1 Answer


Enterprise
Social Q&A

Social
Subscribe on YouTube social-youtube Follow on LinkedIn social-linkedin Follow on Twitter social-twitter Follow on Facebook social-facebook Follow on Instagram social-instagram

Footer

  • Purchase
    • Products
    • Subscription
    • Asset Store
    • Unity Gear
    • Resellers
  • Education
    • Students
    • Educators
    • Certification
    • Learn
    • Center of Excellence
  • Download
    • Unity
    • Beta Program
  • Unity Labs
    • Labs
    • Publications
  • Resources
    • Learn platform
    • Community
    • Documentation
    • Unity QA
    • FAQ
    • Services Status
    • Connect
  • About Unity
    • About Us
    • Blog
    • Events
    • Careers
    • Contact
    • Press
    • Partners
    • Affiliates
    • Security
Copyright © 2020 Unity Technologies
  • Legal
  • Privacy Policy
  • Cookies
  • Do Not Sell My Personal Information
  • Cookies Settings
"Unity", Unity logos, and other Unity trademarks are trademarks or registered trademarks of Unity Technologies or its affiliates in the U.S. and elsewhere (more info here). Other names or brands are trademarks of their respective owners.
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Default
  • Help Room
  • META
  • Moderators
  • Explore
  • Topics
  • Questions
  • Users
  • Badges