Help
For the CSV export format from Bonsai desktop, are the column types/definitions defined somewhere?
Thanks!
-Taka
Page 1 of 1
Bonsai Export Csv Format - Columns? CSV Export format - Column types
#1
- Junior Member
- Group: Members
- Posts: 16
- Joined: 02-February 07
- Location:Atlanta
Posted 14 December 2009 - 08:46 AM
#2
- Junior Member
- Group: Members
- Posts: 16
- Joined: 02-February 07
- Location:Atlanta
Posted 14 December 2009 - 09:19 AM
Column 1: Item Text
Column 2: Item ID
Column 3: ?? (seems to be all 1's)
Column 4: Branch Level
Column 5: ?? (all 0's for me)
Column 6: Priority
Column 7: ?? (all 0's)
Column 8: Entered Date
Column 9: Start Date
Column 10: Due Date
Column 11: ?? (blank)
Column 12: Category
Column 13: Keyword(s)
Column 14: ?? (mostly blank; can't figure out relation)
Column 15: Notes
Column 2: Item ID
Column 3: ?? (seems to be all 1's)
Column 4: Branch Level
Column 5: ?? (all 0's for me)
Column 6: Priority
Column 7: ?? (all 0's)
Column 8: Entered Date
Column 9: Start Date
Column 10: Due Date
Column 11: ?? (blank)
Column 12: Category
Column 13: Keyword(s)
Column 14: ?? (mostly blank; can't figure out relation)
Column 15: Notes
#3
- Senior Member
-
- Group: Members
- Posts: 343
- Joined: 14-May 04
- Gender:Male
- Location:Sheffield, UK
-
Devices::Personal iPad (with iThoughtsHD), Employer's Blackberry Bold 9900 and Windows 7 Laptop
-
OS:Windows 7
Posted 14 December 2009 - 04:30 PM
Hello Takabanana,
It's in the manual, under:
Bonsai Outliner for Windows > How Do I ... ? > Export an Outline > Fixed Format
That says:
"The order of the columns for the CSV export is as follows;
1. Title
2. Unique Id
3. Item type ( 0=Simple, 1=To Do, 2=Task)
4. Outline depth (0=root)
5. Percent complete
6. Priority
<see below for the line which slots in here>
7. Create date
8. Start date
9. Due date
10. Competed date
11. Category text
12. Keywords
13. Contact
14. Note "
- So you were pretty close with your list. Since writing the manual, they've added a column new column 7 (which bumps all the later items up by one), for the "custom" numeric field.
Sorry to hear that all of your To-Dos are 0% complete, by the way. I have a similar relationship with my To-Do list, despite Bonsai and various books.
Regards,
Stéph
It's in the manual, under:
Bonsai Outliner for Windows > How Do I ... ? > Export an Outline > Fixed Format
That says:
"The order of the columns for the CSV export is as follows;
1. Title
2. Unique Id
3. Item type ( 0=Simple, 1=To Do, 2=Task)
4. Outline depth (0=root)
5. Percent complete
6. Priority
<see below for the line which slots in here>
7. Create date
8. Start date
9. Due date
10. Competed date
11. Category text
12. Keywords
13. Contact
14. Note "
- So you were pretty close with your list. Since writing the manual, they've added a column new column 7 (which bumps all the later items up by one), for the "custom" numeric field.
Sorry to hear that all of your To-Dos are 0% complete, by the way. I have a similar relationship with my To-Do list, despite Bonsai and various books.
Regards,
Stéph
Share this topic:
Page 1 of 1