change in status column field order breaks Phlogiston
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	• JAufrecht
	Feb 23 2016, 3:43 PM

Description

iOS is broken (all missing tables) while others are not; not sure exactly why some projects are affected and not others, but the essential problem is probably related to the status column now having some numbers (looks like priority values) instead of status values, which probably traces back to a changed field position in the JSON dump.

source |        date         |      category      |   status   | points | count |    maint_type     
--------+---------------------+--------------------+------------+--------+-------+-------------------
 ios    | 2015-10-02 00:00:00 | Other              | "25"       |      1 |    11 | 
 ios    | 2015-10-02 00:00:00 | Other              | "open"     |     72 |    65 | New Functionality
 ios    | 2015-10-02 00:00:00 | Other              | "25"       |      0 |    14 | New Functionality

It could be that some projects are completely regenerated and others aren't.

Related Objects
Search...

		Status	Subtype	Assigned	Task
		Resolved		• JAufrecht	T125698 Phabricator dump used by Phlogiston should be updated when Phabricator is upgraded
		Resolved		• JAufrecht	T127837 change in status column field order breaks Phlogiston

Event Timeline

• JAufrecht created this task.Feb 23 2016, 3:43 PM

Why is it relying on the positions of the fields?

What are the alternatives?

Map from header rows. Python handles this automatically for CSV, but I don't think the JSON file has header rows. Can you add header rows?

Read a JSON schema. This would be non-trivial for Phlogiston; not sure how much work it is to add and maintain a schema to Chase's script.

Does the json only contain arrays without column names anywhere? That seems odd if that is the case, then json isn't really being utilized very well :(

• JAufrecht added a project: User-JAufrecht.Feb 23 2016, 11:33 PM

• JAufrecht moved this task from Incoming to Team requests for Phlogiston on the User-JAufrecht board.Mar 2 2016, 12:02 AM

fix added last week; several automatic runs in a row seem okay

• JAufrecht added a project: Phlogiston (Technical Debt).Apr 19 2016, 10:49 PM

Restricted Application added subscribers: TerraCodes, Urbanecm. · View Herald TranscriptApr 19 2016, 10:49 PM

• JAufrecht removed a project: Phlogiston↝Technical Debt.Apr 19 2016, 10:52 PM