How to global edit DBF files

[Nbalive4ever]

Ok guys here you go

1st step http://www.legendsoft.com/downloads/DBF ... werPRO.exe

get this program then install it


then open it up and load the players.dbf file


then go to the top where it says file....table...tools....help

and click table the update multiple records.


next step go to EXAMPLE"number 52 FGPBASE and click the check box
then the expression box will open and say FGPBASE all you do is this

write either + number or - number there

in the result field you will see the final result of the plus or minus for that record.

then since you have the box checked you can continue and update as many fields as you like or just do that one.


when you have selected all the fileds you like click BEGIN UPDATE and it will update the records.


Tips

1) Be carefull in certain fileds not to minus to much cause if the previous number was 10 and you tried to minus 15 gloabal it will lock up. A field that does this is 3ptpct

2) once you click begin update and it updates all the fileds make sure to uncheck that box before editing more cause it will continue to minus or add the previous expression

GL


Matt

[Bredrin]

great post man

[fvdmc]

CHEERS!!!

[cocobee]

Great post! Thanks man. Will you be adding a tutorial about other things we can do with this--I'm not really too familiar with dbf files and whatnot.


Thanks again

[CountryBumpkin]

Excellent Post!...Now if I can only get the darned game! Should be in today at EB...

[DoubleA]

this is a good post......

but i did all that and got lost bad
could u either save the file, or maybe even send me an email, coz i tell ya,, after getting beat by the warriors as the mavs on all-star, due to 17 steals to 1, i feel cheated of a decent game, gotta turn thoes damn steals down!!

anyway, would u be able to help me out man??

thanks

[Alanb]

All this is fine with DB Commander, but if you have Access and Excel editing the dbf file is much easier.

As someone has posted before, all you need to do is load the dbf in Access, copy a column to Excel, do the calculations, and paste it back to Access.

Then copy the newly edited dbf file to all the places it needs to be copied. Besides copying the file to the /database, etc., directory in the main-game directory, you also have to look where else the file is located.

A simple search on the file will tell you where else the file appears. With XP, I think there are four instances of the same file in your /application data directory (or something to that effect).

I did quite a lot of editing and once you get used to it, it takes very little time.

Alanb

[froggyboy]

Sorry I am really new to Excel(Never used it before due to no need), now just starting to learn. Can any expert please direct me how to Add OR Subtract a number from ALL the numbers in a column? I once selected the whole column, I stucked...this might be REALLY easy if I get to understand that, because as I go through the help file it only teach me more complecated things but no mention of this. Sorry to ask stupid question~but I really want to learn it and edit Player.dbf on my own~

On the other hand, if I subtract a number that is too big that some of the original numbers in the column will go Below zero, would there be any method that you can set the Minimum so it will at least go down as only 1?

[DoubleA]

i can help

ok

in a cell on the spreadsheet, right the number u want to subtract/divide/ watever
now, copy in from access, the row u want to edit
copy that first cell (with the number u want)
it will be come highlighted
now select the whole column, by clicking on the letter
then select "paste special" then a box will appear
on the bottom half of this box, it will say "subtract, addition"
click watever u want to do
and thats it

[squidy37]

what if the number become negative? would that make the game freeze or something? or will it count as 0.

[Adan10]

Is anyone else who is trying to use the DBF viewer from the link experiencing errors when trying to edit globally?
I've followed the instructions but when I get to the Update Multiple Records screen and I try to update I get:
Error while updating record #1
Any assistance would be appreciated!

[daHiVE]

what if the number become negative? would that make the game freeze or something? or will it count as 0.

you can decrease the numbers by a certain amount of %-points, that way the numbers won´t get negative.

[Bredrin]

yea I'm havin problems

[p_rushing]

Copy the column you are editing from access into excel.

Select all the values in column A, If you are using Office XP there will be an exlamation point there, click it and select convert to numbers. If not, you should be able to right click and format the cells as numbers.

Then decide how many points you want to subtract from each rating.(I will use 5 in the example)

Then click on the B1 cell.

Then click the function button or hit =.

Type IF(cell>#,true do this 'cell-#, not true do this 'cell')

Using 5 it would be IF(A1>5,A1-5,A1)

Then press enter and it will be changed.

Press ctrl-c to copy cell B1 and then select the rest of the cells in column B that have numbers in column A.

Press ctrl-v and the formula will be pasted and all values adjusted without values going negative.

Then just paste column B back into access.

[squidy37]

ah.. %points. That's cool~! It's more proportional that way =p