Recently Written- How To – Template Sharing Part Two February 14, 2010
- Bento 3.0.3 Update Is A Hit! February 3, 2010
- Bento As A Motivational tool January 24, 2010
- An Update About The Bento Database Manager / Digestive January 17, 2010
- PDF Archive Option! January 15, 2010
- How To – Template Sharing Part One January 14, 2010
- Template Exchange Problems! January 11, 2010
- Bento 3.0.2: First Crash December 21, 2009
- Strange Bug. Anyone? December 19, 2009
- Free Bento 3.02 Update Released December 10, 2009
- Saving Space On Forms November 17, 2009
- User Finds Bento 3 Easter Egg November 17, 2009
- Bento 3 Crash Report: November 09 November 17, 2009
- Lame Bento 3 Free Holiday Pack November 17, 2009
- Bento Bug: Movie Aspect Ratio October 15, 2009
Apr
11
Field Orders In CSV Exports
Filed Under Bento News
When you export data from Bento to a CSV file there is no way to specify the order that the fields will be exported in and Bento simply exports the data in the order that the fields were created. This can be a problem if you are going to use the data in, for example, a pre-existing Numbers document where you need the columns to be displayed in a particular order.
The way to get around this is to follow these steps:
- Export the data from Bento as a CSV file.
- Open the CSV file in a spreadsheet such as Numbers or Excel.
- Re-order the columns in the spreadsheet.
- Export the data as a CSV file from the spreadsheet.
- Import this new CSV file into Bento, creating a new Library.
- If you want to, delete the original Library and rename the new one to give it the original Library’s name.
Now, whenever this Library is exported the fields will be in the correct order.
Comments
One Response to “Field Orders In CSV Exports”
Leave a Reply
Thanks for the work-around. I hope this bug is sorted quickly. It is a bug, isn’t it? Why on earth would anyone want the fields to be in the order of creation rather than the order displayed in table view?