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

Vacation time: I will be on vacation from October 3rd to October 15th, please expect a delay in my support. Thank you for your understanding.

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

nabiela

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?

Anthony

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!

nabiela

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.

nabiela

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

nabiela Hi, you can book a 30min with me using this link:
https://calendly.com/anthonylotte/one-on-one-with-anthony

We can talk about the json variables on the call directly then.

For the API documentation about Home Designer, I don't have any yet but for the touch library, it's based on Lean Touch, you can a documentation here:
https://carloswilkes.com/Documentation/LeanTouch

Anthony

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.

nabiela

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

nabiela

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

nabiela

Anthony How to insert wall and floor materials in quotes?

Anthony

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.

Anthony

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.

Anthony

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

Anthony

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.