CSV Saving
by Goblin Hero
Moderators: charmer, CCGHQ Admins
CSV Saving
by woogerboy21 » 09 Jan 2010, 19:38
Maybe I am doing something wrong but when I choose to save my inventory as a .CSV file it appears that the saved file is not formated properly for comma seperation. It appears to be tab seperated. It also does not include all the columns listed in the inventory view of the program.
Not sure if this is by design but it would be nice if either you had the option to set the delimiter (ex: tab or delimiter), or save the file with the proper .tab extension rather than .csv. Also have all the columns experted that exist in the inventory view.
Not sure if this is by design but it would be nice if either you had the option to set the delimiter (ex: tab or delimiter), or save the file with the proper .tab extension rather than .csv. Also have all the columns experted that exist in the inventory view.
-
woogerboy21 - HQ Team Member
- Posts: 1136
- Joined: 19 Jul 2009, 00:15
- Location: USA
- Has thanked: 21 times
- Been thanked: 152 times
Re: CSV Saving
by Goblin Hero » 12 Jan 2010, 21:12
CSV files can use different delimiters. I've chosen tab because this symbol is not used in MA database fields. AFAIK all modern spreadsheet apps detect delimiter automatically. As for the all colmns export - add this to wishlist.
When you´re a goblin, you don´t have to step forward to be a hero -- everyone else just has to step back.
-
Goblin Hero - Site Admin
- Posts: 1992
- Joined: 23 Oct 2005, 09:37
- Location: Russia
- Has thanked: 218 times
- Been thanked: 351 times
Re: CSV Saving
by woogerboy21 » 13 Jan 2010, 18:50
Will do about the wishlist.CSV files can use different delimiters. I've chosen tab because this symbol is not used in MA database fields. AFAIK all modern spreadsheet apps detect delimiter automatically. As for the all colmns export - add this to wishlist.
And yea I have noticed that over the last year or so that most programs are saving any delimiter in the csv file name extension. Since its just a flat file with a common delimiter in the file contents the name really doesn't matter. Just a personal pet p'v of mine since the extension name indicates a comma delimiter and putting any other delimiter in the file seems to be just lazyness (not on your part just overall lazyness of the market).
Old school programming mentality kicking in I guess.
So far over all seems like a good app to use for collection inventoring. Good Job.
-
woogerboy21 - HQ Team Member
- Posts: 1136
- Joined: 19 Jul 2009, 00:15
- Location: USA
- Has thanked: 21 times
- Been thanked: 152 times
CSV Saving
by jackdenial » 25 Jan 2010, 08:00
You can read your data from the excel file using "report generation" to an array. Then you can save it as *.csv using "write to spreadsheet file".you can select the separator.If you don't know how to use "report generation",install it and see the examples.It's simple.
- jackdenial
- Posts: 3
- Joined: 23 Jan 2010, 12:32
- Has thanked: 0 time
- Been thanked: 0 time
Re: CSV Saving
by woogerboy21 » 25 Jan 2010, 18:26
Yea I was just making sure of the formating. I usually just open it up in openoffice calc and choose the "tab" seperator and it opens right upjackdenial wrote:You can read your data from the excel file using "report generation" to an array. Then you can save it as *.csv using "write to spreadsheet file".you can select the separator.If you don't know how to use "report generation",install it and see the examples.It's simple.
-
woogerboy21 - HQ Team Member
- Posts: 1136
- Joined: 19 Jul 2009, 00:15
- Location: USA
- Has thanked: 21 times
- Been thanked: 152 times
5 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 39 guests