• General
  • Request for Assistance with Storing 3D and Floor Plan Data in Database

I have purchased your package bundle and am currently working on a project that involves handling 3D models and floor plan data. However, I noticed that there is no information on how to connect to a database or store this data. Could you please advise me on how to save 3D and floor plan data into a database, or provide relevant resources or documentation?

    4 days later

    nabiela Hi! There is no support for database storage in the plugin. All 3D models (interior objects must be present in the project, or you have to handle the external loading on your own with asset bundles for example) and all generated meshes are procedural, they are stored locally as json data files.
    There is an "online module" that helps you save/load these json files to an online server, and it's up to you to place them in a database if that what you need.
    The online module is part of the HOME DESIGNER BUNDLE package and there is a documentation that comes with it.

    Hope that helps!

      Thank you for your response. I checked the json code. Some of the part in json I understand but need your help me to understand a part in json code after saved. Can you advise us for this part:-

      "spaces": [
      {
      "type": "Room",
      "name": "test",
      "width": 1.0,
      "height": 1.0,
      "ypos": 1.0,
      "hasWindow": false,
      "windowFrameSize": 0.0,
      "windowSizeH": 0.0,
      "windowSizeV": 0.0,
      "windowSubDivH": 0,
      "windowSubDivV": 0,
      "normalizedPositions": [
      {
      "x": -0.15,
      "y": 2.9,
      "z": 0.0,
      "normalized": {
      "x": -0.0516550876,
      "y": 0.998665,
      "z": 0.0,
      "magnitude": 1.0,
      "sqrMagnitude": 1.0
      },
      "magnitude": 2.90387678,
      "sqrMagnitude": 8.432501
      },
      {
      "x": -0.4,
      "y": 2.3,
      "z": 0.0,
      "normalized": {
      "x": -0.171341181,
      "y": 0.9852118,
      "z": 0.0,
      "magnitude": 1.0,
      "sqrMagnitude": 1.00000012
      },
      "magnitude": 2.33452344,
      "sqrMagnitude": 5.45
      },
      {
      "x": 0.1,
      "y": 2.05,
      "z": 0.0,
      "normalized": {
      "x": 0.048722554,
      "y": 0.9988123,
      "z": 0.0,
      "normalized": {
      "x": 0.0487225577,
      "y": 0.9988124,
      "z": 0.0,
      "magnitude": 1.0,
      "sqrMagnitude": 1.0
      },
      "magnitude": 0.99999994,
      "sqrMagnitude": 0.99999994
      },
      "magnitude": 2.05243754,
      "sqrMagnitude": 4.21249962
      },
      {
      "x": 0.3,
      "y": 2.65,
      "z": 0.0,
      "normalized": {
      "x": 0.112489015,
      "y": 0.993653,
      "z": 0.0,
      "magnitude": 1.0,
      "sqrMagnitude": 1.00000012
      },
      "magnitude": 2.666927,
      "sqrMagnitude": 7.11250067
      }
      ],
      "directions": [
      {
      "x": 0.0,
      "y": 0.0,
      "z": 0.0,
      "magnitude": 0.0,
      "sqrMagnitude": 0.0
      },
      {
      "x": 0.0,
      "y": 0.0,
      "z": 0.0,
      "magnitude": 0.0,
      "sqrMagnitude": 0.0
      },
      {
      "x": 0.0,
      "y": 0.0,
      "z": 0.0,
      "magnitude": 0.0,
      "sqrMagnitude": 0.0
      },
      {
      "x": 0.0,
      "y": 0.0,
      "z": 0.0,
      "magnitude": 0.0,
      "sqrMagnitude": 0.0
      }
      ]
      }
      ]

        Anthony Hi! We would like to request a meet at your earliest convenience to discuss some important details, particularly regarding API and touch input. Your insights would be invaluable to us. Alternatively, if that is inconvenient, could you please provide documentation on API and touch input? We look forward to your response.

          5 days later

          nabiela Hi! Can you describe what you don't understand from the json you posted? I will try to explain in more details.
          As for the undo/redo there is no feature like that at the moment.

            6 days later

            Anthony Hi, ⁠We already know a few attributes like types, name, width, height ect. We want to know about normalizedPositions. Is the x,y,z follow the base grid (Unity xyz position) or floorplan that we made? ⁠Can you clarify these attributes in json, magnitude and sqrMagnitude?!

            also if you look at the video I included, you can see where the floor plan exceeds the line border, can I know why this can happen, please assist me
            https://drive.google.com/drive/folders/1UGhRnRmQHZzARSntcix2P048bVRQBWdw?usp=sharing

              Anthony ⁠How do we change / rename the assets / furnitures, including the sizes, color, variant?

                14 days later

                nabiela Hi! Sorry for the late reply.
                normalizedPositions are some local positions on the Grid object, I suggest to have a look at the grid.cs component to understand. it's just a way to have points on the grid, so that we can move/rotate/scale the grid and impact the all floor plan.
                Don't worry about magnitude and sqrMagnitude, these are properties part of the Vector3 class that are being serialized in the json but they are not actually used, we just need the x,y,z values.

                  if the buliding goes out of the border, it means you had drawn the bulding too far, or you have changed the boundaries. just increase the size of the boundaries to your needs.

                    nabiela Have you seen the video tutorial and read the manual? it should cover all your questions. There is an editor window to manage all your assets and generate the json files for the application.

                      nabiela This is not done unfortunately you will have to edit the code base to add them.

                        Write a Reply...