Search Unity

  1. Welcome to the Unity Forums! Please take the time to read our Code of Conduct to familiarize yourself with the forum rules and how to post constructively.

Discussion scriptObject Exel database

Discussion in 'Editor & General Support' started by bplc, Jul 15, 2022.

  1. bplc

    bplc

    Joined:
    Mar 10, 2022
    Posts:
    98
    Hello,
    I am looking for information to integrate a scriptObject database, with an Exel file, I have to manage a lot of objects, it seems easier to me to manage this, with an Exel file.

    If there is another method, I'm listening.
     
  2. spiney199

    spiney199

    Joined:
    Feb 11, 2021
    Posts:
    3,445
    It's not difficult. You just read off the spread sheet or a csv file and use that data to generate scriptable objects.

    Otherwise you can use existing editor tooling or make your own to streamline editing large numbers of scriptable objects.
     
    bplc likes this.
  3. bplc

    bplc

    Joined:
    Mar 10, 2022
    Posts:
    98
    Ok thank you, so it is possible :)
    So i also assume that my scriptsObjects can be created with mysql and that I can modify my database with my exel file ?
     
  4. JeffDUnity3D

    JeffDUnity3D

    Unity Technologies

    Joined:
    May 2, 2017
    Posts:
    14,446
    bplc likes this.
  5. bplc

    bplc

    Joined:
    Mar 10, 2022
    Posts:
    98
    There are several ways to import a csv, with phpMyAdmin or with the terminal, or with ODBC, but it's a bit more complicated.

    I need to be able to modify a large number of objects, in a simple and fast way on a server, and since this is a method that I use on sales websites, this seems to me the most logical.
     
    JeffDUnity3D likes this.
  6. JeffDUnity3D

    JeffDUnity3D

    Unity Technologies

    Joined:
    May 2, 2017
    Posts:
    14,446
    Yes manual vs automated.