[Help] TOS+ with Roll20?

I use The Only Sheet (TOS+) for my Pathfinder games.  It is a comprehensive Excel based sheet that uses VBA macros.  The data files for the characters that are loaded are simple text files that could be parsed into roll20. (I'm hoping).  Who would I talk to about this to determine the feasibility of such a project and the challenges associated? Thank you for your help.

( Moving to API forum.)

I implemented something similar into the sheet I've been maintaining for Pokémon Tabletop United, using sheet workers, so I'm sure its possible, especially if the data files from TOS are JSONs.

So who should I contact about this??? &nbsp;I want to put that person in contact with the creator of TOS+ because I know next to nothing about it. &nbsp;I just don't know who to reach and how. &nbsp; <a href="mailto:admin@theonlysheet.com" rel="nofollow">admin@theonlysheet.com</a> &nbsp;Richard Taillon is the creator. Thanks for any ideas on how to proceed. (I don't really know what JSONs are either, unless they are knife wielding, hockey mask maniacs)

JSON = JavaScript Object Notation. &nbsp;It's a format for data interchange between systems. &nbsp;Similar in purpose to XML or YAML or a host of other formats. &nbsp;It looks like: { property: 'value', otherprop: [ 2,3,5,'taco'] } Your end goal would be to create a character in TOS+, then import that character into the Roll20 Pathfinder sheet?

Yes, I would create it in this excel sheet with and then it generates a .tos file which the creator says is just a text file. &nbsp;It's very small in size. &nbsp;Then there would need to be a way to get that file to ?parse? or be interpreted into roll20 somehow. &nbsp; I understand that the roll20 sheet would not have all the dynamic play features for on the fly calculations and automation that the excel sheet has, but it would save SOOOO much time to put the complete character into roll20 since the excel is a complete character generator. &nbsp;I would LOVE to know how to do this.

Why don't you upload one of those .tos files for a created character to <a href="http://gist.github.com" rel="nofollow">http://gist.github.com</a> and paste the link here. That way we can see the format.&nbsp;

okay, built a github account and dragged the file but it said we don't support that type of file. &nbsp;.tos &nbsp;it said to try again with jpg, gif, png, pdf, txt etc. I converted the file to a .txt and it didn't take it again. &nbsp;Now says try again with jpg png or gif only. Not sure what the issue is there. any ideas?

If it's just a text file, you should be able to load it up in a text editor on your computer and copy the contents, then paste them into the text area on the gist.

Let's see if this works <a href="https://gist.github.com/omegaman03/89f8b2885b70d40" rel="nofollow">https://gist.github.com/omegaman03/89f8b2885b70d40</a>...

Ah, that's commonly called INI Format ( <a href="https://en.wikipedia.org/wiki/INI_file" rel="nofollow">https://en.wikipedia.org/wiki/INI_file</a>) and it's a fairly easy format to parse. The biggest challenge would be matching up what to set in the character sheet from that data.

You mean like deciding which line on this text file goes to what section and ability name in the character sheet on roll20? &nbsp;Well I would think that the creator of the .tos file would be able to see the info and know what field it should match up to since he built the sheet. &nbsp; Assuming he can do that, does he need a special program to move that information to each individual field in the character sheet? &nbsp; I am trying to do the legwork so I can go back to the admin for TOS+ and let him know what the next step is. &nbsp;I know that I cannot parse this as I barely understand what is going on. &nbsp; Would sheet creators of Roll20 know how to integrate these things into a pathfinder roll20 character sheet? &nbsp;Or would they need input from the guy who actually made the excel version of the sheet to be able to figure it out?

What I mean is that: tSel_Age=1|1|16 tSel_AgeTag=1|1|Age is obviously saying that the age of the character is 16, and that the name for the field should be 'Age' (localization, I take it). &nbsp;On the Pathfinder Character sheet (whichever one you are targeting, there are several), there is probably an attribute named 'character_age', which would need to be set to the value 16. &nbsp;That's not terribly difficult. &nbsp;It's also not so bad to parse that structure and know that you have Age and can ignore AgeTag. &nbsp;What is likely to be tedious is knowing that ('Age' of 16 needs to be set in the attribute 'character_age') X (all the other fields for import). &nbsp;Someone has to build that lookup. &nbsp;Then it gets more complicated when you take things like: tSel_Race_HitDieType=1|1|=IF(COUNTIF(t_Types,tSel_Race_Type)=0,"d4","d"&VLOOKUP(tSel_Race_Type,t_Types,index_type_HD,FALSE)) (which may not need to be imported, but I didn't look at every line to find one I am certain would be) &nbsp;That's more than just data, thats a lookup in a collection of data that isn't in the export. &nbsp;That's logic that would either need to be replaced/parsed/ignored. So, speaking of special programs, he'd need an API script to do the import, or possibly a sheet worker script on the character sheet. &nbsp;If you could get the sheet maintainers interested in parsing this format and importing it into their sheets, they would likely know how to do it. &nbsp;I can't speak to if they would be willing, or what it would take. &nbsp;Character sheets are mostly community driven. &nbsp; The most likely scenario I can think of if the TOS+ author wants to get a smooth path into Roll20 characters would be for him to write his own character sheet and write the importer himself. &nbsp;That would allow him to control both sides to where he can make whatever changes to either one he wants without breaking the other.

Exactly the info I was looking for. &nbsp;I really appreciate it. &nbsp;I will reach out to the sheet people and see if I get any bites.

Vince and&nbsp; chris b. maintain the main Pathfinder sheet. &nbsp;Good hunting! =D