Exporting and importing .csv file

targy · 05-22-2003, 12:38 AM

When I export the .csv file and make any changes to it and them import it so the changes take place all the players heights read 0'0"

statfreak · 05-22-2003, 12:44 AM

What program are you using to edit the csv files?

targy · 05-22-2003, 01:05 AM

Excel

Kemp · 05-22-2003, 06:44 AM

I've run into this. Because the heights are listed as "6-1" (for example), Excel converts them to dates.

When you import them back, they get fouled up.

ctorg · 05-22-2003, 08:36 AM

All you have to do to fix this in Excel is this:

Select the column where the heights are. Go to Format and select Cells. Under the tab Number, select Custom. In the box, enter m-d. This reformats the numbers so that they look like they should. Since it's a csv file, you'll need to redo this anytime you open it to make changes. Hopefully Markus will change the format of this.

targy · 05-22-2003, 10:16 AM

I just decided to use the in game editor...I use the new program that allows you to exit manager mode, do all my fixes and the go back into manager mode

landru · 05-22-2003, 11:57 AM

Here's what I do
1. Export file
2. Open file in Wordpad
3. Search and replace all occurences of the characters "5-" and "6-" with "XXX5-" and "XXX6-". This takes all of two seconds.
4. Save file
5. Open file in Excel
6. Make changes that I need to and save
7. Open file in Wordpad again
8. Replace all occurences of "XXX" with nothing (i.e. just leave the replace text box blank.
9. Import file and see that heights are unchanged!

fhomess · 05-22-2003, 12:27 PM

On a related note, how can I export stats in an online league with a commish password? Does CommishJoe's exporter do this for version 5?

D Love · 05-22-2003, 12:28 PM

I think the simpler way is to just highlgiht the column in Excel, as discussed above, and then change formatting to m-d for Height AND also change the formatting of birthyear to mm/dd/yyyy rather than mm/dd/yy.

05-22-2003, 12:38 AM	#1
targy All Star Starter Join Date: Jan 2002 Location: Clearwater, FL Posts: 1,152	Exporting and importing .csv file When I export the .csv file and make any changes to it and them import it so the changes take place all the players heights read 0'0"

05-22-2003, 01:05 AM	#3
targy All Star Starter Join Date: Jan 2002 Location: Clearwater, FL Posts: 1,152	Excel __________________ www.emerge180.com

05-22-2003, 08:36 AM	#5
ctorg Global Moderator Join Date: Nov 2002 Location: Queens, NY Posts: 9,848	All you have to do to fix this in Excel is this: Select the column where the heights are. Go to Format and select Cells. Under the tab Number, select Custom. In the box, enter m-d. This reformats the numbers so that they look like they should. Since it's a csv file, you'll need to redo this anytime you open it to make changes. Hopefully Markus will change the format of this. __________________ My music "When the trees blow back and forth, that's what makes the wind." - Steven Wright Fjord emena pancreas thorax fornicate marmalade morpheme proteolysis smaxa cabana offal srue vitriol grope hallelujah lentils

05-22-2003, 10:16 AM	#6
targy All Star Starter Join Date: Jan 2002 Location: Clearwater, FL Posts: 1,152	I just decided to use the in game editor...I use the new program that allows you to exit manager mode, do all my fixes and the go back into manager mode __________________ www.emerge180.com

05-22-2003, 12:27 PM	#8
fhomess Hall Of Famer Join Date: Nov 2002 Posts: 3,693	On a related note, how can I export stats in an online league with a commish password? Does CommishJoe's exporter do this for version 5? __________________ StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development.

05-22-2003, 12:44 AM	#2
statfreak Hall Of Famer Join Date: Dec 2001 Location: Milwaukee, WI Posts: 2,434	What program are you using to edit the csv files?

05-22-2003, 06:44 AM	#4
Kemp All Star Starter Join Date: Feb 2002 Posts: 1,181	I've run into this. Because the heights are listed as "6-1" (for example), Excel converts them to dates. When you import them back, they get fouled up.

05-22-2003, 11:57 AM	#7
landru Minors (Double A) Join Date: Dec 2001 Posts: 101	Here's what I do 1. Export file 2. Open file in Wordpad 3. Search and replace all occurences of the characters "5-" and "6-" with "XXX5-" and "XXX6-". This takes all of two seconds. 4. Save file 5. Open file in Excel 6. Make changes that I need to and save 7. Open file in Wordpad again 8. Replace all occurences of "XXX" with nothing (i.e. just leave the replace text box blank. 9. Import file and see that heights are unchanged!

05-22-2003, 12:28 PM	#9
D Love All Star Reserve Join Date: Mar 2002 Location: Queens, NY Posts: 904	I think the simpler way is to just highlgiht the column in Excel, as discussed above, and then change formatting to m-d for Height AND also change the formatting of birthyear to mm/dd/yyyy rather than mm/dd/yy.