Search Unity

  1. Megacity Metro Demo now available. Download now.
    Dismiss Notice
  2. Unity support for visionOS is now available. Learn more in our blog post.
    Dismiss Notice

Discussion scriptObject Exel database

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

  1. bplc

    bplc

    Joined:
    Mar 10, 2022
    Posts:
    113
    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:
    7,606
    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:
    113
    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

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

    bplc

    Joined:
    Mar 10, 2022
    Posts:
    113
    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

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