Writing batch file for .dbf

[T-Wave]

I had another idea which seems to bring me closer to a solution. Check this code out:

Code: [Select]

@echo off
for /f "tokens=* delims=" %%A in ('type Wing.txt') do (
echo "cdbflite.exe" appearance.dbf /case /filter:APPEARID=%%A /filter:HEIGHT{78 /field:HEIGHT=78 /update>auth.bat
)
What this does, thus far, is to write the instruction into another auth.bat, which I can later run. The only problem thus far, is that after it is run, the auth.bat file contains only one line of instruction at the end, probably due to the FOR loop overwriting what was already in the auth.bat file every time it is iterated. At the end, I have only the following line in the auth.bat file, which confirms my suspicion because 4103 is the last number in the Wing.txt file:

"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4103 /filter:HEIGHT{78 /field:HEIGHT=78 /update

How do we get it not to overwrite the auth.bat file each time the instruction is reiterated, but rather to add a different line so that at the end, the auth.bat file could look something like this instead:


"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4017 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4019 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4023 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4025 /filter:HEIGHT{78 /field:HEIGHT=78 /update

...

"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4103 /filter:HEIGHT{78 /field:HEIGHT=78 /update

[fireballs]

Code: [Select]

@echo off
for /f "tokens=* delims=" %%A in ('type Wing.txt') do (
echo "cdbflite.exe" appearance.dbf /case /filter:APPEARID=%%A /filter:HEIGHT{78 /field:HEIGHT=78 /update>>auth.bat
)
try that.


FB

[T-Wave]

Great, that works, thanks. Now, hopefully, one last problem 

As seen from my results below, there is always a space between APPEARID= and the number, e.g APPEARID= 4017. This is causing the filter to be invalid. When the space is taken away so that it looks like "APPEARID=4017", the auth.bat file works. Is there any way for the results written into the auth.bat file to be written without that space? Oh man, so close to the final solution, I can taste it

"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4017 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4019 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4020 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4024 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4026 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4029 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4032 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4035 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4040 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4042 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4045 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4047 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4049 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4051 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4052 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4053 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4054 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4055 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4056 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4058 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4059 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4060 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4061 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4062 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4063 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4065 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4066 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4071 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4077 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4078 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4079 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4081 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4082 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4085 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4086 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4088 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4090 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4092 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4093 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4095 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4097 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4098 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4101 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4102 /filter:HEIGHT{78 /field:HEIGHT=78 /update
"cdbflite.exe" appearance.dbf /case /filter:APPEARID= 4103 /filter:HEIGHT{78 /field:HEIGHT=78 /update

[fireballs]

we need to figure out where the space is coming from, all i can do with my system is say that the space doesn't come from expanding the variable. So is it in the original wing.txt? There's definitely no space between appearid= and %%A?

FB

[T-Wave]

In my instruction, there is definitely no space between appearid= and %%A. However, in the Wing.txt file, there is always a space before the number on every line.

The code that creates the Wing.txt file is as follows:

Code: [Select]

"cdbflite.exe" players.dbf /case /filter:TEAM=39 /filter:POSITION=3;POSITION=2 /out:Wing.txt /select:PLAYERID /update

[fireballs]

Code: [Select]

@echo off
for /f "tokens=* delims= " %%A in ('type Wing.txt') do (
echo "cdbflite.exe" appearance.dbf /case /filter:APPEARID=%%A /filter:HEIGHT{78 /field:HEIGHT=78 /update>>auth.bat
)
this should work.

FB

[T-Wave]

Marvelous, the whole thing works now!!!  You've been awesome, Fireballs.

[fireballs]

W00t! it works! You did most of the work... you wrote the CDBflite.exe codes and the Batch code to create Auth!

FB

[T-Wave]

No way I'm taking that credit, but I guess we could go on and on ... I'm just ecstatic that it's actually working. It's a problem that has been bugging me for years playing NBA Live, and no matter how often a fix has been requested from EA sports, they kept making lots of undersized generated players. Yesterday, I got so fed up with it, I decided to take things into my own hands... and with all your effort, we() came through.