Are there any LOOKUP.INI limitations ?

[Kitaro]

Hey guys,

Are there any limitations for the LOOKUP.INI file such as how large it is or the number of calculations you can have?

I have several calculations that are performed in my lookup.ini file. I test the file each time with goldmine to make sure my latest addition is working before going any further.

I created a custom screen tab labled "Pricing Calculator" and have several USERDEFxx fields where you can choose values/taxes/quantities etc.... and it totals up each field. I then use LOOKUP.INI to perform calculations and assign the resulting answer to a defined USERDEFxx field. This defined USERDEFxx field value is then exported to a MS WORD .doc (.dot) template I created to produce an invoice for clients.

All calculations are working as designed by my last LOOKUP.INI calculation (simple calculation to add 2 fields together) is not funcitoning like the rest of my calculations. The defined USERDEFxx field it is suppose to assign the value to is not working.

I was just wondering if I have too many calculations or values in my LOOKUP.INI file.

Here is a copy of my LOOKUP.INI file, the last calculation [USERDEF81] is the calculation that is not passing the result to goldmine.

[AutoUpdate]
USERDEF19=USERDEF29,USERDEF80
USERDEF28=USERDEF29,USERDEF80
USERDEF41=USERDEF71,USERDEF80
USERDEF51=USERDEF71,USERDEF80
USERDEF61=USERDEF71,USERDEF80
USERDEF42=USERDEF72,USERDEF80
USERDEF52=USERDEF72,USERDEF80
USERDEF62=USERDEF72,USERDEF80
USERDEF43=USERDEF73,USERDEF80
USERDEF53=USERDEF73,USERDEF80
USERDEF63=USERDEF73,USERDEF80
USERDEF44=USERDEF74,USERDEF80
USERDEF54=USERDEF74,USERDEF80
USERDEF64=USERDEF74,USERDEF80
USERDEF45=USERDEF75,USERDEF80
USERDEF55=USERDEF75,USERDEF80
USERDEF65=USERDEF75,USERDEF80
USERDEF46=USERDEF76,USERDEF80
USERDEF56=USERDEF76,USERDEF80
USERDEF66=USERDEF76,USERDEF80
USERDEF47=USERDEF77,USERDEF80
USERDEF57=USERDEF77,USERDEF80
USERDEF67=USERDEF77,USERDEF80
USERDEF48=USERDEF78,USERDEF80
USERDEF58=USERDEF78,USERDEF80
USERDEF68=USERDEF78,USERDEF80
USERDEF49=USERDEF79,USERDEF80
USERDEF59=USERDEF79,USERDEF80
USERDEF69=USERDEF79,USERDEF80
USERDEF29=USERDEF81
USERDEF80=USERDEF81


[USERDEF29]
Otherwise = &Contact2->USERDEF19 * Contact2->USERDEF28
OverWrite = 1

[USERDEF71]
Otherwise = &Contact2->USERDEF41 * Contact2->USERDEF51 * (Contact2->USERDEF61 + 1)
Overwrite = 1

[USERDEF72]
Otherwise = &Contact2->USERDEF42 * Contact2->USERDEF52 * (Contact2->USERDEF62 + 1)
Overwrite = 1

[USERDEF73]
Otherwise = &Contact2->USERDEF43 * Contact2->USERDEF53 * (Contact2->USERDEF63 + 1)
Overwrite = 1

[USERDEF74]
Otherwise = &Contact2->USERDEF44 * Contact2->USERDEF54 * (Contact2->USERDEF64 + 1)
Overwrite = 1

[USERDEF75]
Otherwise = &Contact2->USERDEF45 * Contact2->USERDEF55 * (Contact2->USERDEF65 + 1)
Overwrite = 1

[USERDEF76]
Otherwise = &Contact2->USERDEF46 * Contact2->USERDEF56 * (Contact2->USERDEF66 + 1)
Overwrite = 1

[USERDEF77]
Otherwise = &Contact2->USERDEF47 * Contact2->USERDEF57 * (Contact2->USERDEF67 + 1)
Overwrite = 1

[USERDEF78]
Otherwise = &Contact2->USERDEF48 * Contact2->USERDEF58 * (Contact2->USERDEF68 + 1)
Overwrite = 1

[USERDEF79]
Otherwise = &Contact2->USERDEF49 * Contact2->USERDEF59 * (Contact2->USERDEF69 + 1)
Overwrite = 1

[USERDEF80]
Otherwise = &Contact2->USERDEF71 + Contact2->USERDEF72 + Contact2->USERDEF73 + Contact2->USERDEF74 + Contact2->USERDEF75 + Contact2->USERDEF76 + Contact2->USERDEF77 + Contact2->USERDEF78 + Contact2->USERDEF79
Overwrite = 1

[USERDEF81]
Otherwise = &Contact2->USERDEF29 + Contact2->USERDEF80
Overwrite = 1

The USERDEF80 Calculation is the calculation I figured I would have a problem with but it works beautifully.

 

[Kitaro]

I figured it out. I just changed the [USERDEF81] calculations to do similar calculations as the [USERDEF80] formula. Everything works again.

Thanx Anyway guys!