|
|
|
SSC Eights!
 
Group: General Forum Members
Last Login: Today @ 1:26 PM
Points: 871,
Visits: 1,215
|
|
Someone must be doing this successfully somewhere... it wasn't more than a couple of years ago that I ran across a company that had written code to sync up Quick Books (multi-user version only) data with SQL Server. All I need is a way to parse the "not quite SGML" that a QFX file contains.
Anyone? Pretty please with sugar on top?
Steve
(aka smunson)
:):):)
|
|
|
|
|
SSC Eights!
Group: General Forum Members
Last Login: Today @ 1:26 PM
Points: 871,
Visits: 1,215
|
|
BUMP...
No one has ever imported a Quicken QFX file into SQL Server? I did manage to find a database program for MAC OS X that will import such files into it, but then I'd need a MAC computer, which isn't a practical solution. There doesn't appear to be a Windows version of the program. Any and all assistance will be most appreciated...
Steve
(aka smunson)
:):):)
|
|
|
|
|
SSCrazy
Group: General Forum Members
Last Login: Today @ 11:40 AM
Points: 2,071,
Visits: 3,429
|
|
|
|
|
|
SSC Eights!
Group: General Forum Members
Last Login: Today @ 1:26 PM
Points: 871,
Visits: 1,215
|
|
Ok, I've found SX.exe, which can at least output well-formed XML. Unfortunately, trying to import it's resultant XML is still a problem, as while all the tags are now closed, they contain unnecessary levels and multiple content types (both text and numbers), and that is apparently not ok with SQL Server. Thus I'm wondering if anyone has any solution to "flatten" the XML, such that it retains only the nodes that contain values. Perhaps then I can at least get it into Excel, if not SQL Server...
I've seen at least two examples of XSL code that was written to flatten a specific example of XML, but I have no idea how you actually get that transformation to take place. Can someone help out with that? Thanks in advance for any / all assistance.
Steve
(aka smunson)
:):):)
|
|
|
|
