playMaker

Author Topic: Editing PlayMakerGlobals.asset in Spreadsheet [SOLVED]  (Read 6202 times)

Fat Pug Studio

  • Beta Group
  • Hero Member
  • *
  • Posts: 1294
    • Fat Pug Studio
Editing PlayMakerGlobals.asset in Spreadsheet [SOLVED]
« on: June 23, 2017, 05:29:55 PM »
Hi,

is it safe to edit the asset file in spreadsheet software and save it as an asset file again (while unity's off, of course)? Are the values going to be updated?

I have few hundreds of them and it's getting tedious to mess with them in Unity itself.

I think there'll be no problems, but i better double check :)
« Last Edit: June 26, 2017, 06:06:20 AM by krmko »
Available for Playmaker work

gregacuna

  • Full Member
  • ***
  • Posts: 142
Re: Editing PlayMakerGlobals.asset in Spreadsheet
« Reply #1 on: June 24, 2017, 03:37:35 AM »
How did you get it into a spreadsheet? When I open it I didn't get anything editable.

Fat Pug Studio

  • Beta Group
  • Hero Member
  • *
  • Posts: 1294
    • Fat Pug Studio
Re: Editing PlayMakerGlobals.asset in Spreadsheet
« Reply #2 on: June 24, 2017, 09:04:24 AM »
It's just a delimited text file, try importing instead of opening if your spreadsheet software is not suggesting the import itself. You can open it in a simple text editor too.
« Last Edit: June 24, 2017, 10:01:37 AM by krmko »
Available for Playmaker work

djaydino

  • Administrator
  • Hero Member
  • *****
  • Posts: 7615
    • jinxtergames
Re: Editing PlayMakerGlobals.asset in Spreadsheet
« Reply #3 on: June 24, 2017, 10:17:29 AM »
Hi,
I have no idea if it is safe or not.
Before you do, make a backup from your project so you can try it out :)
without having permanent damage if it goes wrong :)

Fat Pug Studio

  • Beta Group
  • Hero Member
  • *
  • Posts: 1294
    • Fat Pug Studio
Re: Editing PlayMakerGlobals.asset in Spreadsheet
« Reply #4 on: June 26, 2017, 05:56:19 AM »
Just sorted it out with the help of Easy Save 2, Joel mailed me action from Easy Save 3 beta, you can export all your global variables to a neatly comma delimited file, do what you want, and then simply load it back. This is a huge time saver as i already have 700 global variables.
Available for Playmaker work

tcmeric

  • Beta Group
  • Hero Member
  • *
  • Posts: 768
Re: Editing PlayMakerGlobals.asset in Spreadsheet [SOLVED]
« Reply #5 on: June 26, 2017, 10:29:01 AM »
That sounds awesome! A reason to buy Easy Save 3.

Fat Pug Studio

  • Beta Group
  • Hero Member
  • *
  • Posts: 1294
    • Fat Pug Studio
Re: Editing PlayMakerGlobals.asset in Spreadsheet [SOLVED]
« Reply #6 on: June 26, 2017, 05:23:59 PM »
Ah, my bad, can't be loaded back in because csv does not support deserialization. But having them all in spreadsheet for analysis and graphs is quite convenient, tho they plan on load from spreadsheet feature in ES3.
« Last Edit: June 27, 2017, 10:09:23 AM by krmko »
Available for Playmaker work

gregacuna

  • Full Member
  • ***
  • Posts: 142
Re: Editing PlayMakerGlobals.asset in Spreadsheet [SOLVED]
« Reply #7 on: July 01, 2017, 10:31:39 PM »
Hey Krmko...I finally got around to trying this and it isn't working for me. Are you talking about the file which Playmaker can export of the globals? When I've tried to open that in a text editor or import it into Excel I'm not getting anything readable.

Hope you can point out how I can create a list of globals. Thanks!

Fat Pug Studio

  • Beta Group
  • Hero Member
  • *
  • Posts: 1294
    • Fat Pug Studio
Re: Editing PlayMakerGlobals.asset in Spreadsheet [SOLVED]
« Reply #8 on: September 27, 2017, 04:51:29 AM »
Hey Gregacuna, sorry for late response, i haven't been visiting the forum in a while. You can open the playmakerglobals.asset from the resources folder with notepad++ or excel if you like.

TBH can't wait for easy save 3 to export and import variables from and into a spreadsheet, this is beginning to be a nightmare.
Available for Playmaker work

gregacuna

  • Full Member
  • ***
  • Posts: 142
Re: Editing PlayMakerGlobals.asset in Spreadsheet [SOLVED]
« Reply #9 on: September 27, 2017, 05:17:03 AM »
Hey krmko...when I open it with notepad++ I'm getting a lot of junk. Is there some trick to opening it?

Fat Pug Studio

  • Beta Group
  • Hero Member
  • *
  • Posts: 1294
    • Fat Pug Studio
Re: Editing PlayMakerGlobals.asset in Spreadsheet [SOLVED]
« Reply #10 on: September 27, 2017, 05:42:50 AM »
Hmm, are we opening the same file?

ProjectName\Assets\Playmaker\Resources\PlaymakerGlobals.asset

Do you have a screenshot of how it looks when you open it? HerŠµ's how it looks on my side

« Last Edit: September 27, 2017, 06:03:25 AM by krmko »
Available for Playmaker work

gregacuna

  • Full Member
  • ***
  • Posts: 142
Re: Editing PlayMakerGlobals.asset in Spreadsheet [SOLVED]
« Reply #11 on: September 27, 2017, 08:08:54 AM »
Wow...yours looks so beautiful. I'm envious. :) Mine's attached.

Fat Pug Studio

  • Beta Group
  • Hero Member
  • *
  • Posts: 1294
    • Fat Pug Studio
Re: Editing PlayMakerGlobals.asset in Spreadsheet [SOLVED]
« Reply #12 on: September 27, 2017, 09:00:16 AM »
How's your encoding set up? UTF-8?
Available for Playmaker work

gregacuna

  • Full Member
  • ***
  • Posts: 142
Re: Editing PlayMakerGlobals.asset in Spreadsheet [SOLVED]
« Reply #13 on: September 28, 2017, 12:23:10 AM »
It defaults to ANSI, but I tried switching to UTF-8 and not much change...looks pretty much like in the image I sent you. This is very strange. Any ideas?

Fat Pug Studio

  • Beta Group
  • Hero Member
  • *
  • Posts: 1294
    • Fat Pug Studio
Re: Editing PlayMakerGlobals.asset in Spreadsheet [SOLVED]
« Reply #14 on: September 28, 2017, 12:58:21 AM »
Can you attach the file so i can try opening it to see what will it look like?
Available for Playmaker work