DBF batch editing

Discussion about NBA Live 2004.

DBF batch editing

Postby avig1 on Wed Oct 08, 2014 1:59 pm

I've started to try playing the older NBA live games, and I wanted to try out the Dynasty mode in live 2004. I'm trying to edit all the birthdate values in the players.dbf back by 11 years so the ages will be right in Dynasty mode, but I dont know of any dbf editor that can do that without manually editing each value.
Thanks
avig1
 
Posts: 4
Joined: Wed Oct 17, 2012 9:58 pm

Re: DBF batch editing

Postby Andrew on Wed Oct 08, 2014 8:11 pm

The method I use, as devised by JaoSming:

JaoSming wrote:well what I do is copy out the entire column to a new spreadsheet

paste it in then a few cells away, in the same row though, type = then click the top birthdate then add the -50000

once that is in, select the cell with the updated birthdate, youll see a little black square in the bottom right of the cell

click, hold, and drag that down till you edit all of the values

then copy it back into the dbf


For reference, -50000 = five years.
NLSC Webmaster/Administrator
Image
Contact: Email | Twitter
Release Threads: NBA Live 08 | NBA Live 07 | NBA Live 06 | NBA Live 2005
Story Threads: NBA 2K13 | NBA Live 06 (Part 2) | NBA Live 06 (HOF) | NBA Live 2004 (HOF)
NLSC: Podcast | The Friday Five | Monday Tip-Off | Wayback Wednesday | 20th Anniversary of NBA Live | Facebook | Twitter | YouTube


Support The NLSC Hosting Fund: Patreon | GoFundMe

Image
Like my work? Want to help out with the NLSC Hosting Fund? Please consider leaving a tip!
User avatar
Andrew
Orange Juice, haha!
Administrator
 
Posts: 98746
Joined: Thu Aug 22, 2002 9:51 pm
Location: Australia

Re: DBF batch editing

Postby avig1 on Wed Oct 08, 2014 8:26 pm

Yeah thats exactly what I've been trying to do, but how do you copy the entire column over from a spreadsheet into the dbf. Doesnt seem to work for me.
avig1
 
Posts: 4
Joined: Wed Oct 17, 2012 9:58 pm

Re: DBF batch editing

Postby Andrew on Wed Oct 08, 2014 9:32 pm

Use a program like MS Excel. You just have to be careful to save in the correct format (.dbf, DBASE IV), otherwise you'll corrupt the database.
NLSC Webmaster/Administrator
Image
Contact: Email | Twitter
Release Threads: NBA Live 08 | NBA Live 07 | NBA Live 06 | NBA Live 2005
Story Threads: NBA 2K13 | NBA Live 06 (Part 2) | NBA Live 06 (HOF) | NBA Live 2004 (HOF)
NLSC: Podcast | The Friday Five | Monday Tip-Off | Wayback Wednesday | 20th Anniversary of NBA Live | Facebook | Twitter | YouTube


Support The NLSC Hosting Fund: Patreon | GoFundMe

Image
Like my work? Want to help out with the NLSC Hosting Fund? Please consider leaving a tip!
User avatar
Andrew
Orange Juice, haha!
Administrator
 
Posts: 98746
Joined: Thu Aug 22, 2002 9:51 pm
Location: Australia


Return to NBA Live 2004

Who is online

Users browsing this forum: No registered users and 1 guest