Please login or register.

Login with username, password and session length
Pages: [1]
French Maid
Xifanie (Webmistress) [Posts: 4261]
  • View Profile
  • Final Fantasy Hacktics
  • http://steamcommunity.com/id/Xifanie
  • share
  • [January 01, 2016, 12:09:22 AM]
FFTText Editor (last update 2016/01/06)
« on: January 01, 2016, 12:09:22 AM »
FFTText Editor v1.00

Easily locate text, in this convenient, neatly ordered editor!

See live what your text looks like in game, along with line lengths! (minus font colours)

Lots of settings!

What is this?
This tool allows to conveniently edit a .ffttext file generated by FFTacText, then generate a new one to load in FFTacText and easily + quickly generate/update your resources.zip. It is used by many of my tools to directly fetch text data for my hacks so that you know what is what without typing everything yourself.

Requirements
  • Microsoft Windows
  • Excel 2007 or higher (with macros enabled)

Instructions
  • Extract Altima_8.ttf from FFT_Font.zip to C:\Windows\Fonts
  • Open FFTText Editor.xlsm
  • Check out the tutorial in the next post

Download
« Last Edit: January 07, 2016, 01:48:11 AM by Xifanie »
    • Modding version: PSX
  • <R999> My target market is not FFT mod players
    <Raijinili> remember that? it was awful
    French Maid
    Xifanie (Webmistress) [Posts: 4261]
    • View Profile
    • Final Fantasy Hacktics
    • http://steamcommunity.com/id/Xifanie
    • share
    • [January 01, 2016, 12:10:12 AM]
    Re: FFTText Editor (last update 2015/12/31)
    « Reply #1 on: January 01, 2016, 12:10:12 AM »
    This tutorial is still in construction 'n stuff

    Introduction
    The first thing you want to do, is open the Add-Ins ribbon (tab if you prefer, but I will be using the term ribbon as it is the official name used by Microsoft Excel). If you are on the FFTText sheet (or if you switch to it), this Custom Toolbar will appear:


    Edit Selection
    Opens the "Edit" sheet with the current selection.
    Edit All
    Opens the "Edit" sheet with every entry of the current section from the first to the last non-blank one.
    Import .ffttext
    Imports a .ffttext file generated by FFTTactext.
    Export .ffttext
    Exports a .ffttext file generated by the spreadsheet ready for immediate patching to a FFT Image using FFTTactext.
    Clear Sheet
    Wipes a sheet of its .ffttext contents.
    Resources.zip
    Generates or Updates an existing Resources.zip with the information data of the spreadsheet.

    Now, if you are instead in the Edit sheet, you will see different options:


    Save Edits
    Straightforward, saves the Edit sheet's changes back into the FFTText sheet.
    Exit without saving
    Back to the FFTText sheet.
    Add Pages
    Append a number of pages at the end of the current entry. *
    Delete Pages
    Removes a number of pages at the end of the current entry. *
    Notepad Emulator
    I created a tool that is essentially a super notepad to help you out with your line lengths and such. Give it a try, you'll love it!
    Show/Hide End of Line
    Sometimes you need to pad at the end of the line with spaces to give the text proper formatting. You can choose to show/hide a character to see where the line actually ends.

    * About Pages:
    A page is a given number of lines. For example, quotes are 3 lines. If the section only contains unit quotes (be it spell quotes, removal quotes, proposition quotes), I set the workbook to assume the page length is 3 lines. So unless you have all sorts of data inside the same section, a page should be as long as the number of lines the game would normally allow. 3 lines for unit dialogues, 4 for help/check boxes, 10 lines for brave story/propositions, etc.


    Legend
    PSX/PSP Resources.zip text
    QuickEdit: The text present under these columns is used in multiple sections.
    Japanese... stuff.: ¯\(°_o)/¯ Just delete it.
    Copied Resources: Fetches information from a QuickEdit column. There should never be a need to edit those.
    Copied Section: Fetches information from a QuickEdit column. There should never be a need to edit those.
    Empty Section: Contains literally nothing. You might be able to use these sections with ASM hacks for your needs.
    References: They are purely used as references and never exported into .ffttext files or resources.zip.
    Any other color: I just tried to mix and match to have sections of the same "type" the same colour.

    Editing
    Only ever use zoom multiples of 100% in the Edit sheet! Otherwise, the Altima Font will not be proportionate with the column width, and you won't be able to tell how close/far to the line limit you will be with that visual reference. There's always the numbers, but I really recommend using these zoom values only.
    « Last Edit: January 07, 2016, 02:40:06 AM by Xifanie »
    • Modding version: PSX
  • <R999> My target market is not FFT mod players
    <Raijinili> remember that? it was awful
    Rodil [Posts: 4]
    • View Profile
    • share
    • [January 05, 2016, 09:05:34 AM]
    Re: FFTText Editor (last update 2015/12/31)
    « Reply #2 on: January 05, 2016, 09:05:34 AM »
    I was finally able to start using this tool today and it was extremely convenient.  I was able to change over half of the ability names and descriptions in the game in a very short amount of time in a simple spreadsheet format.  An easy view of how the descriptions will look in the game was also super nice.  I haven't had a chance to test many features at all yet, but those I have have been really great.  Thanks Xifanie!
    Choto [Posts: 818]
    • View Profile
    • share
    • [January 06, 2016, 01:53:30 AM]
    Re: FFTText Editor (last update 2015/12/31)
    « Reply #3 on: January 06, 2016, 01:53:30 AM »
    I did run into an exception with TacText while trying to patch a an iso with a file edited with the FFTText Editor >_>

    I gotta try editing it again from a fresh base and see if I can find out what's causing it. Maybe a bad character like an ! or something?

    but that aside, this thing is nothing short of friggin awesome :)
    French Maid
    Xifanie (Webmistress) [Posts: 4261]
    • View Profile
    • Final Fantasy Hacktics
    • http://steamcommunity.com/id/Xifanie
    • share
    • [January 06, 2016, 02:45:25 AM]
    Re: FFTText Editor (last update 2015/12/31)
    « Reply #4 on: January 06, 2016, 02:45:25 AM »
    Oh... I completely forgot. The Microsoft Office suite has an option enabled by default where it will convert characters... for example "..." will be converted into a single character (unicode). I think that's the most likely reason you're getting that error.

    I'm pretty sure it's under Excel Options/Proofing/Autocorrect Options, type "..." and remove that entry.
    But you'll still have to replace all instances of that unicode character into "...".
    I forgot if there's another common character like this... tell me how that works out. x.x

    • Modding version: PSX
  • <R999> My target market is not FFT mod players
    <Raijinili> remember that? it was awful
    French Maid
    Xifanie (Webmistress) [Posts: 4261]
    • View Profile
    • Final Fantasy Hacktics
    • http://steamcommunity.com/id/Xifanie
    • share
    • [January 07, 2016, 01:52:00 AM]
    Re: FFTText Editor (last update 2016/01/06)
    « Reply #5 on: January 07, 2016, 01:52:00 AM »
    v1.01
    • Added "Scan for Invalid Chars" function, which searches in all FFTText cells for characters that would prevent a .ffttext file from working properly
    • Added the "Convert Characters" section in the "Settings" page. It automatically converts characters when importing/exporting files to ensure ease of use and proper .ffttext/resources.zip formats.
    • Changed Formula 0x64 to "Dmg_(PA * WP); if using Spear (PA * 3/2 * WP); if weaponless (PA * Brave /100 * WP)"
    Note to self:
    • Change scan for invalid chars icon to a magnifying glass
    • Add Music/Songs column
    • Add PSP/Items/Strings.xml for PSX release (because the shop progression values for the PSX version are stored in there, for .483+)

    Download me
    « Last Edit: June 10, 2016, 02:22:29 PM by Xifanie »
    • Modding version: PSX
  • <R999> My target market is not FFT mod players
    <Raijinili> remember that? it was awful
    Heisho [Posts: 58]
    • View Profile
    • share
    • [March 11, 2017, 02:10:35 PM]
    Re: FFTText Editor (last update 2016/01/06)
    « Reply #6 on: March 11, 2017, 02:10:35 PM »
    Hi there,

    I downloaded the file and using Excel 2010 but I'm keep getting this error message:

    Run-time error 1004:
    Unable to get VLookup property of the Worksheet Function class

    What's wrong on my end?
    French Maid
    Xifanie (Webmistress) [Posts: 4261]
    • View Profile
    • Final Fantasy Hacktics
    • http://steamcommunity.com/id/Xifanie
    • share
    • [March 30, 2017, 07:46:26 PM]
    Re: FFTText Editor (last update 2016/01/06)
    « Reply #7 on: March 30, 2017, 07:46:26 PM »
    Are you trying to use it for WotL? Because I've been told I've gone at it all wrong since FFTactext uses completely different Section Names for WotL vs PSX, meaning my spreadsheet is just not going to work for WotL.

    • Modding version: PSX
  • <R999> My target market is not FFT mod players
    <Raijinili> remember that? it was awful
    Heisho [Posts: 58]
    • View Profile
    • share
    • [April 01, 2017, 04:33:12 AM]
    Re: FFTText Editor (last update 2016/01/06)
    « Reply #8 on: April 01, 2017, 04:33:12 AM »
    Thanks for replying.

    And yes, for the disgust of all, I'm doing a project on WotL.
    Anyway it's ok, I think I'll have to handle it manually. The main attraction for me was the possibility to update the resources file, something that I found pretty convenient.

    So I think I'll use it when I'm finished with this and start working on the PSX. I'm kinda fond of the PSP version and the headaches for being very hard to hack are part of my "training" on this. In fact I discovered a way to add additional fully functional Iaido abilities with no ASM hacks, which I'll implement on this project.

    So thanks for the tool anyway I'll check it on its due time.

    Regards
    messiahgov [Posts: 17]
    • View Profile
    • share
    • [September 02, 2017, 06:59:12 PM]
    Re: FFTText Editor (last update 2016/01/06)
    « Reply #9 on: September 02, 2017, 06:59:12 PM »
    Hello Xifanie,

    I run into a problem to actually use the spreadsheet. All macros and VBA is allowed, but whenever I press any of the Add-Ins buttons on the FFTText sheet, Excel gives me an error. The macro can't be executed etc. I totally allowed them at the Trust Center and pressing ALT+F11 shows the VBA stuff. But I'm a bit lost on how to fix that at all. Do I need some missing runtime or could there be some setting? I installed the "Altima_8" font, have a clean .ffttext and also the resources.zip in the same folder. Hoped it would help, but no, not at all. :D I'm using Excel 2016. Maybe I forgot to install some module for Excel at the Office setup?
    French Maid
    Xifanie (Webmistress) [Posts: 4261]
    • View Profile
    • Final Fantasy Hacktics
    • http://steamcommunity.com/id/Xifanie
    • share
    • [September 02, 2017, 07:37:31 PM]
    Re: FFTText Editor (last update 2016/01/06)
    « Reply #10 on: September 02, 2017, 07:37:31 PM »
    No... the Altima thing is the only thing you should have to install.
    I have no idea what could cause that to happen, and I only have Excel 2007 so I can't quite test 2016, sorry. :/

    This is very confusing to me because it sounds like a problem allowing VBA to run, but you get the Add-Ins buttons (which does require VBA for them to appear), so I really have no clue. I don't know if anyone else with Excel 2016 successfully or unsuccessfully used this spreadsheet before.

    • Modding version: PSX
  • <R999> My target market is not FFT mod players
    <Raijinili> remember that? it was awful
    messiahgov [Posts: 17]
    • View Profile
    • share
    • [September 02, 2017, 08:16:24 PM]
    Re: FFTText Editor (last update 2016/01/06)
    « Reply #11 on: September 02, 2017, 08:16:24 PM »
    Thanks for your quick answer! So it might actually be a problem with Excel 2016 itself in combination with a Excel 2007 created file. Okay. I have the chance to use Excel 2007 on work (also 2010). I will try it there Monday. The VBA stuff should be installed by default at the Office setup, or? Means they should be there on work. I'm expecting some kind of pop window to let me choose the *.ffttext file etc. and the last time I at least tried to use some Excel spreadsheet, was here from FFHacktics and it's long ago (~2013). I was sure that's not a problem with the spreadsheet itself, but on my side. So after searching the whole forum/Google for spreadsheet + vba problems like mine, without any luck, I posted here and digged up your thread. In 2013 my main goal was to translate FFT to German and I got stuck at the hardcoded menu bitmaps, too long location names on map etc. I think I want to revive my project in the near future and was in search for new tools etc. and stumbled upon your FFTText Editor, which sounded to good to be true. :D
    messiahgov [Posts: 17]
    • View Profile
    • share
    • [September 02, 2017, 10:35:01 PM]
    Re: FFTText Editor (last update 2016/01/06)
    « Reply #12 on: September 02, 2017, 10:35:01 PM »
    Just to clear the problem, it seems to be a problem for Excel if the sheet is placed deep on a HDD. Just moving the folder with the sheet at the HDD root solved the VBA problem. I can now load my *.ffttext without any problem as it seems. Also there where a problem with the "ChDir FolderFromPath" value, it couldn't find the last path from "HKEY_CURRENT_USER\Software\FFHacktics\Last Tactext FilePath", just deleting those entry at the registry fixed it. Somehow it created registry values without any real path and errors as soon as it tried to open the file path window. But now it works, even with Excel 2016. ;)
    « Last Edit: September 03, 2017, 05:11:41 PM by messiahgov »
    daft_inquisitor [Posts: 2]
    • View Profile
    • share
    • [October 02, 2017, 04:41:34 AM]
    Re: FFTText Editor (last update 2016/01/06)
    « Reply #13 on: October 02, 2017, 04:41:34 AM »
    Any way to have this sheet work with Libre Office? I don't really have access to Excel, and don't want to pay for a copy for literally just this.  :|
    French Maid
    Xifanie (Webmistress) [Posts: 4261]
    • View Profile
    • Final Fantasy Hacktics
    • http://steamcommunity.com/id/Xifanie
    • share
    • [October 03, 2017, 02:38:54 AM]
    Re: FFTText Editor (last update 2016/01/06)
    « Reply #14 on: October 03, 2017, 02:38:54 AM »
    No.

    But how many people who use my spreadsheets do you think actually pay for Microsoft Office? ¬_¬

    • Modding version: PSX
  • <R999> My target market is not FFT mod players
    <Raijinili> remember that? it was awful
    daft_inquisitor [Posts: 2]
    • View Profile
    • share
    • [October 03, 2017, 05:40:11 AM]
    Re: FFTText Editor (last update 2016/01/06)
    « Reply #15 on: October 03, 2017, 05:40:11 AM »
    One more quick question, for the "Copied" sections, are they vital to be exported? Like, does the game itself just reference those sections normally, or is it something that can be cleaned up a bit to save some space? I figure it's only a "copied" section in your spreadsheet to minimize the amount of text that needs to be modified, but just want to be sure before I end up breaking something.
    French Maid
    Xifanie (Webmistress) [Posts: 4261]
    • View Profile
    • Final Fantasy Hacktics
    • http://steamcommunity.com/id/Xifanie
    • share
    • [October 03, 2017, 06:18:33 AM]
    Re: FFTText Editor (last update 2016/01/06)
    « Reply #16 on: October 03, 2017, 06:18:33 AM »
    They're essential. For example, item names are used in different files and different sections whether you're on the formation screen, or on the squad screen, or the battle rewards screen and so on. So they should be identical.

    • Modding version: PSX
  • <R999> My target market is not FFT mod players
    <Raijinili> remember that? it was awful
    Pages: [1]