6 replies
Sign in or join Beachball Help to reply.
- 0
Jerrold Green1 ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
JO,
Could you give us a little more detailed description of your project?
Jerry
- 0
Peggy ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
- 0
Rick Sustek ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
Wow Peg, how'd you get so many points, since it doesn't look like you actually read the question! 😉
In answer to the question:
You don't create an OFX file yourself. You download one from your financial institutions. This can usually be done from the secure login pages from the institutions web sites. Once you have downloaded such a file, you can add it to a Numbers document, as Peggy has described. There is actually a [very small] help topic about OFX and CSV files, in Numbers "Help".Note that the financial institution's web pages may not clearly indicate that you are getting an OFX file. They may obscure this fact, by calling it a Quicken file, a Web Connect file, or some other gibberish. Also, once downloaded, you may need to modify the file's name, to end in ".ofx", otherwise Numbers may not recognize it.
Also note that Numbers' support of OFX data seems to be quite lame and fragile. For example, it can easily crash or wedge-up when fed OFX data that it doesn't expect. And, it seems to only expect checking account data, e.g. it refuses to see my credit card account data.
As for truly creating your own OFX file, unless you are very skilled at computer programming/scripting/data manipulation, you probably don't want to waste your time! Faster to just type in the data right into a Numbers table.
Have fun,
-Rick - 0
KOENIG Yvan ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
Rick Sustek wrote:
Wow Peg, how'd you get so many points, since it doesn't look like you actually read the question! 😉It seems that you didn't read carefully what Peggy wrote.
She urged the OP to open the OFX file with Numbers.
The app will create a new document
Then you will be able to transfer this new document's contents in your main one.Even an old Frenchie like me is able to understand that 😉
Don't worry Peggy.
In France we say:
balaie devant ta porte avant de parler de celle de ton voisin
or, borrowed from Wikipedia:
+Parabole de la paille et de la poutre. Évangile de Luc, 6, 41+ : « Pourquoi vois-tu la paille qui est dans l'œil de ton frère et n'aperçois-tu pas la poutre qui est dans ton œil à toi ! Ou comment peux-tu dire à ton frère : Frère, laisse-moi ôter la paille qui est dans ton œil, toi qui ne vois pas la poutre qui est dans le tien ? Hypocrite, ôte premièrement la poutre de ton œil, et alors tu verras comment ôter la paille qui est dans l'œil de ton frère. »Yvan KOENIG (VALLAURIS, France) mardi 30 mars 2010 16:07:16
- 0
Rick Sustek ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
You can't open an OFX file if you don't have one!
Numbers does not create OFX files.Sorry, but I am deep into OFX issues right now, and you guys just are not the experts in this area.
Cheers.
- 0
Rick Sustek ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
This may be just one of those English language issues, i.e., the non-precise nature of the language.
In the OP's question, the subject of the sentence is "an OFX file", and they are asking how to create one.
The subject is not "a numbers spreadsheet". It appears that Peggy is interpreting the sentence in a different manner than I am.Without clarification from the OP, we can not be sure what it is they want to create. However, whichever it is, we have now answered both interpretations, so hopefully they shall return and learn. 😉
Cheers!
