drneau.com Forum Index drneau.com
A discussion board for drneau.com
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

import old DB?

 
Post new topic   Reply to topic    drneau.com Forum Index -> Rosters & Player Databases
View previous topic :: View next topic  
Author Message
i8dbear
Founding Father
Founding Father


Joined: 22 Feb 2005
Posts: 181
Location: Los Angeles

PostPosted: Wed Jan 07, 2009 4:06 am    Post subject: import old DB? Reply with quote

any way to do it?
Back to top
View user's profile Send private message
drneau
Site Admin


Joined: 13 Feb 2005
Posts: 2385
Location: Woodbury, MN

PostPosted: Wed Jan 07, 2009 8:37 am    Post subject: Reply with quote

Well, in leiu of me creating a way to do it, you could:

Export a v3 database to CSV to get the template.
Open the file, type all of your players in quickly.
Re-import the updated database CSV file.

Of course, if we're talking 1000 players, that's a lot of work for you.
_________________
--
Dr. Neau (not a real doctor)
http://drneau.com
http://home.comcast.net/~jneau
Back to top
View user's profile Send private message Send e-mail Visit poster's website
i8dbear
Founding Father
Founding Father


Joined: 22 Feb 2005
Posts: 181
Location: Los Angeles

PostPosted: Fri Jan 23, 2009 3:45 am    Post subject: Reply with quote

hmmmm...

an upgrade path would be helpful. some sort of import tool.
Back to top
View user's profile Send private message
i8dbear
Founding Father
Founding Father


Joined: 22 Feb 2005
Posts: 181
Location: Los Angeles

PostPosted: Tue Jan 27, 2009 1:01 pm    Post subject: Reply with quote

did it.

    followed your suggestion and exported a blank db from v3 for structure, and opened in Excel.
    opened old player DB in text editor (BBEdit for Mac).
    copied all tect to a Word doc.
    Used Word's superior find and replace functions to strip out all coding and insert commas where needed to delimitate first, last and nicknames.
    inserted commas where they otherwise didn't insert.
    converted text to table.
    rearranged columns to match v3 form.
    cut and pasted into Excell spreadsheet.
    imported into v3.
    voilá!
Back to top
View user's profile Send private message
drneau
Site Admin


Joined: 13 Feb 2005
Posts: 2385
Location: Woodbury, MN

PostPosted: Tue Jan 27, 2009 8:30 pm    Post subject: Reply with quote

Well don't panic. I've got the feature in for the next release...but if you can't wait, there's how to do it.
_________________
--
Dr. Neau (not a real doctor)
http://drneau.com
http://home.comcast.net/~jneau
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    drneau.com Forum Index -> Rosters & Player Databases All times are GMT - 6 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group