Federated General Assembly » #OWSdirectory

duplicate header rows¶

I thought this might be related to the views filter being exposed as a block, combined with the "Parent sort" option in the CSV download, which attempts to re-order content before export based on said filters.

I disabled the context which renders the views filter on /occupations, unchecked "parent sort" and downloaded a .csv that stil contained 2 headers.

Also unchecked "Make first row a list of column headers" which (surprise) renders no headers.

missing data¶

I compared the CSV to the data import based on occupation name to confirm 101 missing occupations. See attached file.
I can't discern a pattern here. I thought there may be escape characters or something, but I didn't see anything initially jarring.

Geofield was missing from the fieldset; I added that back in.

UUIDs don't correspond to imported values¶

Incidentally, I noticed that UUID isn't an INT. Basically what we imported there is bunk. The UUID ends up like: d425968a-3e69-c8b4-615b-3412836001dd when I regenerated missing UUIDs.
If we could get all our records exported as a CSV, it would be a simple matter to update the original google doc so we can match and update.

So the missing record issue is all that's left it seems. Unassigning myself from this, since I haven't been able to solve the matter.

I just downloaded a CSV which had 1325 rows compared to 1416 in the Directory...91 missing.

When this issue initially came up, I created a notepad with the 45 missing Occupations listed (attached).

Also of note: there are two Hamilton's in the Directory, in both exports, the one in Canada was exported and the one in NY was not.

Occupy Los Angeles, Phoenix were not exported the first time...but they are present in the export file this time.

Andrew, this does not appear to have fixed itself ;)

Testing this with @inga and @andrew just now, the number of records in the db and the number of records in the exported .csv are the same. Marking this one as fixed.