Importing xml data into macdive update#
Importing xml data into macdive upgrade#
Importing xml data into macdive code#
Importing xml data into macdive free#

For ease of description, I copied my file to '/tmp' and exported it there.ģ) In the Terminal, navigate to that folder using 'cd /tmp/apple_health_export'. It will be expanded into a folder named 'apple_health_export'. You'll definitely need a Mac to fix this.Ģ) Go into your iCloud Drive, or wherever you saved the file and expand the 'export.zip' file. I will write this out as a longer sequence of steps just to make things crystal clear.ġ) Export your health data.

There are two distinct fixes you will have to apply. But if you roll your own, you've got to do it correctly. So often, developers take shortcuts and just spit out text that they hope will be valid XML. And sometimes, vendors who provide XML-processing libraries release buggy ones (that dig's for you, too, Apple 😄 ). But those old XML libraries are cryptic and difficult to use. The standard rule of thumb is to use a proper XML-processing library to generate XML for output. Next, Apple scrambled the output of some elements, repeating the 'startDate' attribute twice.

I fixed the scrambled syntax and was able to get 'xmllint' happy, but it still failed validation. No other way to say it.Įdit: in addition to the above, Apple flat-out did the DTD incorrectly. Note to Apple, use a schema instead and do it correctly. Most importantly, Apple scrambled the syntax so it won't ever work. Plus, it is embedded rather than referencing a URL. Not even close.įirst of all, Apple is still using DTD files. But this case, Apple completely screwed this up. I usually try to give Apple the benefit of the doubt. I saved a copy of my iOS 15 Health Data for comparison.

Importing xml data into macdive update#

I just did the update this afternoon, so I suppose my next step is to try the most sophisticated technique I know of and turn my phone off and turn it back on and hope for something different. I'm hoping I'm not alone having a new problem with this version. I've done quite a bit of work with the XML export previously. My export.xml is now 1.7 GB so it makes it awkward to try to check it out with a text editor. I've tried a couple of different R packages to do the import with no luck.

Importing xml data into macdive upgrade#

Given that I just did the upgrade I thought I'd see if anyone else was having a new problem with the export. Read_xml.character('~/Downloads/apple_health_export/export.xml') :

Importing xml data into macdive code#

I'm using the same code I used in August, but now I get the following error: $xslfile = new DOMDocument('1.0', 'UTF-8') įile_put_contents('Output.For several years I have been exporting my Apple Health Export to XML and then importing it into R for analysis. One important item is to rename the database field names, specifically removing spaces, #, and periods to properly fit xml tag names (which even follows best design practices in RDBMS). Like most general purpose languages, PHP comes equipped with an XSLT 1.0 processor. Your original format has quite a bit of namespaces and other nested elements that my interfere with the MySQL upload. `Inventory Status` varchar(4) DEFAULT NULL,Ĭonsider running XSLT to transform the original XML into the format MySQL requires of LOAD XML INFILE.

`Reference Status` varchar(50) DEFAULT NULL, `Planning Type` varchar(50) DEFAULT NULL, `Part Description` varchar(50) DEFAULT NULL, However just to show my own efforts at solving it, here's the table structure I used: DROP TABLE IF EXISTS `part_no`

Importing xml data into macdive free#

You are free to assume any table structure for the answer that suits you and solves the problem.

NOTE: I'm not looking for a database table to specifically fit this data in. Here's the data that needs to be imported. How can I then import this data into my MySQL database table? I assumed this data is not in the format required by LOAD XML INFILE to work. The table got filled with NULL values everywhere. OR LOAD XML INFILE 'D://Secondary/wamp64/tmp/Part_Info.xml' However when I tried to do so either by the query LOAD XML INFILE 'D://Secondary/wamp64/tmp/Part_Info.xml' I looked into the LOAD XML INFILE query to load XML into one of the tables I built in my local database. I'm trying to import data (that was exported to me by an admin) from this XML file into my phpMyAdmin MySQL database table for local development purposes.