Tracker CSV import of checkbox fields does not set 'y' data properly
- Status
- Closed
- Subject
- Tracker CSV import of checkbox fields does not set 'y' data properly
- Version
- 12.x
13.x - Category
- Error
- Feature
- Trackers
- Resolution status
- Fixed or Solved
- Submitted by
- Geoff Brickell
- Volunteered to solve
- Jonny Bradley
- Lastmod by
- lindon
- Rating
- Description
When tracker data with checkbox field is exported as a csv file the checkbox data is displayed as either y or n - just as it in the DB
However if this same data is re-imported any checkbox data with a 'y' is not set properly and is actually set to 'n' which will inadvertently corrupt existing data
If the spreadsheet data is manually update to change y into 1 then it is correctly interpreted as a y
I've rated this as a 10 for importance even though there is this workaround because of the data corruption that can occur if you do not know about the problem
This is being reported as 12.x bug but I suspect it also exists in 13.x and trunk - but not tested there
- Solution
r52554 in 13.x? (will backport to 12.x when tested)
I'm guessing this issue has been fixed so I am closing this report. Please re-open if still any issues.
- Importance
- 10 high
- Priority
- 50
- Demonstrate Bug on Tiki 19+
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show2.tiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Demonstrate Bug (older Tiki versions)
-
This bug has been demonstrated on show.tikiwiki.org
Please demonstrate your bug on show.tikiwiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show.tikiwiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Ticket ID
- 5467
- Created
- Thursday 18 September, 2014 12:50:47 UTC
by Geoff Brickell - LastModif
- Saturday 14 November, 2015 01:38:41 UTC