batch file to change prices in ini

Dell / 8600
January 9, 2009 at 09:54:57
Specs: Windows XP, Intel Centrino 512MB
I need to create a script or batch file that will accept a value as input and then use that value to modify an .INI file. I have a customer that wants to do a uniform price increase/decrease of a certain percent on products. The POS system they use keeps track of pricing using an ini file named "Quality_Pricing.ini". For example, the customer wants to increase prices by 3%, the script/batch file should ask for the price change to be input by the customer, then the script/batch file should make a backup of the original ini. It should then read through all the lines of the ini file and modify the dollar amounts of each line by the percent that was entered. Then it should save the file using the original name "Quality_Pricing.ini". Here is an example of one of the lines from the ini, 002-02=3.99. The first number is a department code, the second is the pricing level, and the third is the actual price that would be modified. I am new to this scripting thing and am not sure I can get this done in the time alotted. If there is anyone that can help me out or point me in the right direction I would greatly appreciate it.
Thanks.

See More: batch file to change prices in ini

Report •


#1
January 10, 2009 at 02:19:04
Need a bit more info... When the increase calculated is say 23.51 cents should this be rounded to 24 cents. If yes, at what point does rounding start, does your customer round down .01 thru' .50 and round up .51 thru' .99?

Also, does your customer need the facility to increase/decrease prices by less than 1% (say .5% or .75%) or say 1.5% or 43.23% etc.

Also please confirm the operating system being used by your customer, XP Home or Pro?



Report •

#2
January 12, 2009 at 06:14:26
Yes, round down .01 thru .50 and up .51 thru .99. All price changes will be done in full percentages. I can email you a copy of the full .ini file to be modified if it will help.

Thanks


Report •

#3
January 12, 2009 at 16:21:23
No need for the .ini file copy, have already generated a test file using the info you gave that each record consists of dept code (3 digits) pricing level (2 digits) and finally the price.

Please respond to my query about the Operating System.


Report •

Related Solutions

#4
January 12, 2009 at 21:24:22
Sorry, I forgot to include the OS. The workstation is using XP. Thanks for your help. It is really appreciated!


Report •

#5
January 13, 2009 at 23:02:22
Below is a beta version of what I think you want. It won't update the QP.INI file but will display results on-screen so that you can check if the script is doing what's required. It's up to you to test and retest. No doubt you will want to clean up the script or comment it further. QB.INI seems like an important file in the operation so I have coded a couple of checks on the user input and given a couple of opportunities to cancel before files are updated. A backup file is created each time the script is run but I haven't included any method of purging old backups, neither have I coded a .LOG file which would show when the script was run and the user entries at that time. Good luck.

Updated code begins........

@echo off
cls
setlocal enabledelayedexpansion

:: Get user inputs & check for accuracy..
:: If an input is outside an acceptable range the job is aborted..

echo.&echo.&echo.&echo.&echo.&echo.&echo.&echo.&echo.

set /P op=            INCREASE OR DECREASE PRICES? (I/D)...
if %op% equ I set iord=+ & set updown=INCREASE& cls & goto percentage
if %op% equ D set iord=- & set updown=DECREASE& cls & goto percentage

set errormsge=I or D (case sensitive)


:error
cls

echo.&echo.&echo.&echo.&echo.&echo.&echo.&echo.&echo.
echo                  INVALID ENTRY "%op%"
echo                  ENTRY FORMAT IS %errormsge%
echo.
echo                  JOB TERMINATED..
echo                  FILES HAVE NOT BEEN COPIED OR AMENDED
echo.        
echo                  PRESS ANY KEY TO CONTINUE...
pause > nul
cls
exit/b


:percentage

echo.&echo.&echo.&echo.&echo.&echo.&echo.&echo.&echo.

set/P op=             WHAT PERCENTAGE PRICE %updown%? (1 thru' 100)..   


:: Check for non-numeric characters in percentage.

echo %op%|findstr /r "[^0-9]" > nul
if %errorlevel% equ 0 (
   set errormsge=1 thru 100 ^(non-numeric chars not permitted^) & goto error
)


:: Check percentage is within the range 1 thru' 100

if %op% gtr 0 if %op% lss 101 (
   goto accept
   ) else (
   set errormsge=1 thru' 100 & goto error
)


:: User warnings..

:accept
cls

set notproceed=YOU HAVE OPTED NOT TO PROCEED.  
set notproceed1=FILES HAVE NOT BEEN COPIED OR UPDATED.
set notproceed2=THE CURRENT PRICING FILE REMAINS INTACT.
set notproceed3=ENTER C TO RETURN TO WINDOWS.

set choices=YOU HAVE CHOSEN TO %UPDOWN% ALL PRICES BY %OP%%%.
set choices1=PLEASE CONFIRM OR CANCEL.

echo.&echo.&echo.&echo.&echo.&echo.&echo.&echo.&echo.

echo                  %choices%
echo.&echo.
echo                  %choices1%
echo.&echo.
set/p choice=                 ENTER Y TO CONFIRM, C TO CANCEL..   
cls

if %choice% equ Y (
   goto continue
   ) else (
   echo.&echo.&echo.&echo.&echo.&echo.&echo.&echo.&echo.
   echo                  %notproceed%
   echo                  %notproceed1%
   echo.&echo.
   echo                  %notproceed3%
   pause > nul
   cls
   exit/b
)

:continue
cls

echo.&echo.&echo.&echo.&echo.&echo.&echo.&echo.&echo.

echo                  FINAL CHANCE TO ABORT CHANGES.....
echo                  ==================================
echo.&echo.
echo                  %choices%
echo.&echo.
echo                  %choices1%
echo.&echo.
set/p choice=                 ENTER Y TO CONFIRM, C TO CANCEL..   

cls


if %choice% equ Y (
   goto proceed
   ) else (
   echo.&echo.&echo.&echo.&echo.&echo.&echo.&echo.&echo.
   echo               %notproceed%
   echo               %notproceed1%
   echo               %notproceed2%
   echo.&echo.
   echo               %notproceed3%
   pause > nul
   cls
   exit/b
)


:proceed
cls

echo.&echo.&echo.&echo.&echo.&echo.&echo.&echo.&echo.


echo                  File Quality_Pricing.ini will be copied for backup
echo                  and a new file created with changes applied.
echo.&echo.
echo                  Please wait....
ping -n 4 127.0.0.1 > nul
cls


:: Create folder for backup files if not already existing

if not exist "c:\backups\" md "c:\backups\"


:: Get date and time to include in backup filename..

:: Dias De Verano  25.Dec.2008

set vbsfile=%temp%\newdate.vbs
echo        Newdate = (Date())>%vbsfile%
echo       DateYear = DatePart("YYYY", Newdate)>>%vbsfile%
echo      DateMonth = DatePart("M"   , Newdate)>>%vbsfile%
echo        DateDay = DatePart("D"   , Newdate)>>%vbsfile%
echo     WeekOfYear = DatePart("WW"  , Newdate)>>%vbsfile%
echo      DayOfYear = DatePart("Y"   , Newdate)>>%vbsfile%
echo  WeekDayNumber = DatePart("W"   , Newdate)>>%vbsfile%
echo TodayNameShort = WeekdayName(WeekDayNumber,True)>>%vbsfile%
echo  TodayNameFull = WeekdayName(WeekDayNumber,False)>>%vbsfile%
echo       TimeHour = Hour(Time)>>%vbsfile%
echo     TimeMinute = Minute(Time)>>%vbsfile%
echo     TimeSecond = Second(Time)>>%vbsfile%
echo If TimeHour^<12 Then>>%vbsfile%
echo   AMorPM="AM">>%vbsfile%
echo Else>>%vbsfile%
echo   AMorPM="PM">>%vbsfile%
echo End If>>%vbsfile%
echo Wscript.Echo DateYear^&" "^&DateMonth^&" "^&DateDay^&" "^&Week^
OfYear^&" "^&DayOfYear^&" "^&WeekDayNumber^&" "^&Today^
NameShort^&" "^&TodayNameFull^&" "^&TimeHour^&" "^&Time^
Minute^&" "^&TimeSecond^&" "^&AMorPM>>%vbsfile%


for /f "tokens=1-12 delims= " %%A in ('cscript //nologo %vbsfile%') do (
   set yyyy=%%A
   set mm=%%B
   set dd=%%C
   set hour=%%I
   set mins=%%J
)

del %vbsfile%

if %mm% lss 10 set mm=0%mm%
if %dd% lss 10 set dd=0%dd%
if %hour% lss 10 set hour=0%hour%
if %mins% lss 10 set mins=0%mins%


set datime=%yyyy%%mm%%dd%_%hour%%mins%

:: Copy file, make backup read only, update .ini

set outfil=c:\backups\Quality_Pricing_%datime%.bak
set infil=c:\quality_pricing.ini


copy "%infil%" "%outfil%" > nul
attrib +r "%outfil%"

echo.&echo.&echo.&echo.&echo.&echo.&echo.&echo.&echo.
echo                  Backup file created....                               
echo                  Now updating Quality_Pricing.ini
echo.&echo.
echo                  Please wait....
ping -n 4 127.0.0.1 > nul


set output=c:\quality_pricing.txt

for /f "tokens=1-3 delims=,=" %%1 in (c:\quality_pricing.ini) do (
    set first=%%1
    set second=%%2
    set third=%%3
    call :writit
)

more < %output%
exit/b

:writit

if %first% equ [QUALITY_LABELS] (
    echo %first%>%output% & goto :eof
)

if %first:~0,5% equ PRICE (
    echo %first%=%second%>>%output% & goto :eof
)

if "%second%"=="x" (
    echo %first%=%second%>>%output% & goto :eof
)

if %first% equ [QUALITY_PRICES] (
    echo.>>%output%
    echo %first%>>%output% & goto :eof 
)

set amount=%second:.=%
   if %amount% lss 100 set amount=%amount:~-2%
   set/a amtpct=%amount%*%op%

if %amtpct:~-2% gtr 50 (
   set/a finalamt=%amtpct:~0,-2%+1
   ) else (
   set finalamt=%amtpct:~0,-2%
)

set/a penult=%amount%%iord%%finalamt%
if %penult% lss 100 set penult=0%penult%
set ult=%penult:~0,-2%.%penult:~-2%


if not "!third!"=="" set third=,!third!
echo !first!=!ult!!third!>>!output!
set third=

Updated code ends........


Report •

#6
January 14, 2009 at 06:10:46
Thanks so much for your help. I have run the file and it seems to be on the right track but there are some things that I did not forsee. In the ini file there are several lines at the top that have to do with labels not prices. This section starts with the header [QUALITY_LABELS]. There are two lines for each label. Example:
PRICE_LABEL1=Good
PRICE_LABEL1_COLOR=#D6D557;
There are several of these lines. Then we get to the prices which starts with the header [QUALITY_PRICES]. As you know there are 3 sections in each line(000-01=0.79) however I have noticed that several of the lines have a comma after the price followed by a number (000-02=0.99,1) some lines are like this also (000-12=8.99,#). I even found a few like this (020-12=10.99,3#). Then there is a section of 12 lines like this (700-01=x). What are you thoughts on getting around this problem. I need to make sure that these non-numerical lines and characters remain intact. You have been such a GREAT help that I hate to bother you any more but I am kinda stuck on solving this problem. Hope you can bail me out once more. Thanks again, you are AWESOME!!!

Report •

#7
January 14, 2009 at 07:34:05
Here is what the top of the file looks like.
[QUALITY_LABELS]
PRICE_LABEL1=Good
PRICE_LABEL1_COLOR=#D6D557;
PRICE_LABEL2=Better
PRICE_LABEL2_COLOR=#5BD657;
PRICE_LABEL3=Excellent
PRICE_LABEL3_COLOR=#D6575E;
PRICE_LABEL4=REALLY COOL
PRICE_LABEL4_COLOR=#FF0000;
PRICE_LABEL5=GETTING CRAZY
PRICE_LABEL5_COLOR=#FF0000;
PRICE_LABEL6=YAWN
PRICE_LABEL6_COLOR=#FF0000;

[QUALITY_PRICES]
000-01=0.79
000-02=0.99,1
000-03=1.49
000-04=1.99,2
000-05=2.49
000-06=2.99,3

I would have mentioned this at the start but the customer only gave me a sample of the price lines not the entire file. I have it now and could send you an entire copy of it if that will help. Thank you for all of your time and effort!!!


Report •

#8
January 14, 2009 at 10:20:03
It seems to me that the format of the records might not be static so using a scripting language to update just the prices might not be possible and you should be looking at VB or C++. It doesn't matter if records are added/deleted in the course of processing, it's the FORMAT of the records that's important.

OK, please send me a copy of the entire file and I'll decide whether or not to proceed.


Report •

#9
January 14, 2009 at 11:59:52
Here is the file. I was forced to remove alot of the lines because it was just to long to send as open text on this forum but this will give you the general idea. Thanks again for all of your help.

[QUALITY_LABELS]
PRICE_LABEL1=Good
PRICE_LABEL1_COLOR=#D6D557;
PRICE_LABEL2=Better
PRICE_LABEL2_COLOR=#5BD657;
PRICE_LABEL3=Excellent
PRICE_LABEL3_COLOR=#D6575E;
PRICE_LABEL4=REALLY COOL
PRICE_LABEL4_COLOR=#FF0000;
PRICE_LABEL5=GETTING CRAZY
PRICE_LABEL5_COLOR=#FF0000;
PRICE_LABEL6=YAWN
PRICE_LABEL6_COLOR=#FF0000;

[QUALITY_PRICES]
000-01=0.79
000-02=0.99,1
000-03=1.49
000-04=1.99,2
000-05=2.49
000-06=2.99,3
000-07=3.99
000-08=4.99
000-09=5.99
000-10=6.99
000-11=7.99
000-12=8.99,#
001-01=0.79,#
001-02=0.99,#
001-03=1.49,#
001-04=1.99,#
001-05=2.49,#
001-06=2.99,#
001-07=3.99,#
001-08=4.99,#
001-09=5.99,#
001-10=6.99,#
001-11=7.99,#
001-12=8.99,#
002-01=2.99
002-02=3.99
002-03=4.99,1
002-04=5.99
002-05=6.99
002-06=7.99
002-07=8.99,2
002-08=9.99
002-09=10.99
002-10=12.99
002-11=14.99,3
002-12=16.99,#
016-01=0.99
016-02=1.49
016-03=1.99
016-04=2.49,1
016-05=2.99
016-06=3.99
016-07=4.99,2
016-08=5.99
016-09=6.99,3
016-10=7.99
016-11=8.99
016-12=9.99,#
017-01=0.99
017-02=1.49
017-03=1.99
017-04=2.49,1
017-05=2.99
017-06=3.99
017-07=4.99,2
017-08=5.99
017-09=6.99,3
017-10=7.99
017-11=8.99
017-12=9.99,#
018-01=0.99
018-02=1.49
018-03=1.99
018-04=2.49,1
018-05=2.99
018-06=3.99
018-07=4.99,2
018-08=5.99
018-09=6.99,3
018-10=7.99
018-11=8.99
018-12=9.99,#
019-01=0.99
019-02=1.49
019-03=1.99
019-04=2.49,1
019-05=2.99
019-06=3.99
019-07=4.99,2
019-08=5.99
019-09=6.99,3
019-10=7.99
019-11=8.99
019-12=9.99,#
020-01=1.49
020-02=1.99
020-03=2.49
020-04=2.99
020-05=3.99
020-06=4.99,1
020-07=5.99
020-08=6.99
020-09=7.99
020-10=8.99,2
020-11=9.99
020-12=10.99,3#
021-01=1.49
021-02=1.99
021-03=2.49
021-04=2.99
021-05=3.99
021-06=4.99,1
021-07=5.99
021-08=6.99
021-09=7.99
021-10=8.99,2
021-11=9.99
021-12=10.99,3#
022-01=1.49
022-02=1.99
022-03=2.49
022-04=2.99
022-05=3.99
022-06=4.99,1
022-07=5.99
022-08=6.99
022-09=7.99
022-10=8.99,2
022-11=9.99
022-12=10.99,3#
023-01=1.49
023-02=1.99
023-03=2.49
023-04=2.99
023-05=3.99
023-06=4.99,1
023-07=5.99
023-08=6.99
023-09=7.99
023-10=8.99,2
023-11=9.99
023-12=10.99,3#
024-01=2.99
024-02=3.99
024-03=4.99,1
024-04=5.99
024-05=6.99
024-06=7.99
024-07=8.99,2
024-08=9.99
024-09=10.99,3
024-10=12.99
024-11=14.99
024-12=16.99,#
025-01=2.99
025-02=3.99
025-03=4.99,1
025-04=5.99
025-05=6.99
025-06=7.99
025-07=8.99,2
025-08=9.99
025-09=10.99,3
025-10=12.99
025-11=14.99
025-12=16.99,#
026-01=2.99
026-02=3.99
026-03=4.99,1
026-04=5.99
026-05=6.99
026-06=7.99
026-07=8.99,2
026-08=9.99
026-09=10.99,3
026-10=12.99
026-11=14.99
026-12=16.99,#
027-01=2.99
027-02=3.99
027-03=4.99,1
027-04=5.99
027-05=6.99
027-06=7.99
027-07=8.99,2
027-08=9.99
027-09=10.99,3
027-10=12.99
027-11=14.99
027-12=16.99,#
028-01=3.99
028-02=4.99
028-03=5.99
028-04=6.99
028-05=7.99,1
028-06=8.99
028-07=9.99
028-08=10.99
028-09=12.99
028-10=14.99,2
028-11=16.99
028-12=19.99,3#
029-01=3.99
029-02=4.99
029-03=5.99
029-04=6.99
029-05=7.99,1
029-06=8.99
029-07=9.99
029-08=10.99
029-09=12.99
029-10=14.99,2
029-11=16.99
029-12=19.99,3#
030-01=3.99
030-02=4.99
030-03=5.99
030-04=6.99
030-05=7.99,1
030-06=8.99
030-07=9.99
030-08=10.99
030-09=12.99
030-10=14.99,2
030-11=16.99
030-12=19.99,3#
031-01=3.99
031-02=4.99
031-03=5.99
031-04=6.99
031-05=7.99,1
031-06=8.99
031-07=9.99
031-08=10.99
031-09=12.99
031-10=14.99,2
031-11=16.99
031-12=19.99,3#
036-01=1.99
036-02=2.49
036-03=2.99
036-04=3.99,1
036-05=4.99
036-06=5.99
036-07=6.99,2
036-08=7.99
036-09=8.99,3
036-10=9.99
036-11=10.99
036-12=12.99,#
037-01=1.99
037-02=2.49
037-03=2.99
037-04=3.99,1
037-05=4.99
037-06=5.99
037-07=6.99,2
037-08=7.99
037-09=8.99,3
037-10=9.99
037-11=10.99
037-12=12.99,#
038-01=1.99
038-02=2.49
038-03=2.99
038-04=3.99,1
038-05=4.99
038-06=5.99
038-07=6.99,2
038-08=7.99
038-09=8.99,3
038-10=9.99
038-11=10.99
038-12=12.99,#
039-01=1.99
039-02=2.49
039-03=2.99
039-04=3.99,1
039-05=4.99
039-06=5.99
039-07=6.99,2
039-08=7.99
039-09=8.99,3
039-10=9.99
039-11=10.99
039-12=12.99,#
040-01=1.99
040-02=2.49
040-03=2.99
040-04=3.99,1
040-05=4.99
040-06=5.99
040-07=6.99,2
040-08=7.99
040-09=8.99,3
040-10=9.99
040-11=10.99
040-12=12.99,#
041-01=1.99
041-02=2.49
041-03=2.99
041-04=3.99,1
041-05=4.99
041-06=5.99
041-07=6.99,2
041-08=7.99
041-09=8.99,3
041-10=9.99
041-11=10.99
041-12=12.99,#
042-01=1.99
042-02=2.49
042-03=2.99
042-04=3.99,1
042-05=4.99
042-06=5.99
042-07=6.99,2
042-08=7.99
042-09=8.99,3
042-10=9.99
042-11=10.99
042-12=12.99,#
043-01=1.99
043-02=2.49
043-03=2.99
043-04=3.99,1
043-05=4.99
043-06=5.99
043-07=6.99,2
043-08=7.99
043-09=8.99,3
043-10=9.99
043-11=10.99
043-12=12.99,#
044-01=1.99
044-02=2.49
044-03=2.99
044-04=3.99,1
044-05=4.99
044-06=5.99
044-07=6.99,2
044-08=7.99
044-09=8.99,3
044-10=9.99
044-11=10.99
044-12=12.99,#
045-01=1.99
045-02=2.49
045-03=2.99
045-04=3.99,1
045-05=4.99
045-06=5.99
045-07=6.99,2
045-08=7.99
045-09=8.99,3
045-10=9.99
045-11=10.99
045-12=12.99,#
046-01=1.99
046-02=2.49
046-03=2.99
046-04=3.99,1
046-05=4.99
046-06=5.99
046-07=6.99,2
046-08=7.99
046-09=8.99,3
046-10=9.99
046-11=10.99
046-12=12.99,#
047-01=1.99
047-02=2.49
047-03=2.99
047-04=3.99,1
047-05=4.99
047-06=5.99
047-07=6.99,2
047-08=7.99
047-09=8.99,3
047-10=9.99
047-11=10.99
047-12=12.99,#
048-01=1.99
048-02=2.49
048-03=2.99
048-04=3.99,1
048-05=4.99
048-06=5.99
048-07=6.99,2
048-08=7.99
048-09=8.99,3
048-10=9.99
048-11=10.99
048-12=12.99,#
049-01=1.99
049-02=2.49
049-03=2.99
049-04=3.99,1
049-05=4.99
049-06=5.99
049-07=6.99,2
049-08=7.99
049-09=8.99,3
049-10=9.99
049-11=10.99
049-12=12.99,#
050-01=1.99
050-02=2.49
050-03=2.99
050-04=3.99,1
050-05=4.99
050-06=5.99
050-07=6.99,2
050-08=7.99
050-09=8.99,3
050-10=9.99
050-11=10.99
050-12=12.99,#
051-01=1.99
051-02=2.49
051-03=2.99
051-04=3.99,1
051-05=4.99
051-06=5.99
051-07=6.99,2
051-08=7.99
051-09=8.99,3
051-10=9.99
051-11=10.99
051-12=12.99,#
052-01=1.99
052-02=2.49
052-03=2.99
052-04=3.99,1
052-05=4.99
052-06=5.99
052-07=6.99,2
052-08=7.99
052-09=8.99,3
052-10=9.99
052-11=10.99
052-12=12.99,#
053-01=1.99
053-02=2.49
053-03=2.99
053-04=3.99,1
053-05=4.99
053-06=5.99
053-07=6.99,2
053-08=7.99
053-09=8.99,3
053-10=9.99
053-11=10.99
053-12=12.99,#
054-01=1.99
054-02=2.49
054-03=2.99
054-04=3.99,1
054-05=4.99
054-06=5.99
054-07=6.99,2
054-08=7.99
054-09=8.99,3
054-10=9.99
054-11=10.99
054-12=12.99,#
055-01=1.99
055-02=2.49
055-03=2.99
055-04=3.99,1
055-05=4.99
055-06=5.99
055-07=6.99,2
055-08=7.99
055-09=8.99,3
055-10=9.99
055-11=10.99
055-12=12.99,#
056-01=1.99
056-02=2.49
056-03=2.99
056-04=3.99,1
056-05=4.99
056-06=5.99
056-07=6.99,2
056-08=7.99
056-09=8.99,3
056-10=9.99
056-11=10.99
056-12=12.99,#
057-01=1.99
057-02=2.49
057-03=2.99
057-04=3.99,1
057-05=4.99
057-06=5.99
057-07=6.99,2
057-08=7.99
057-09=8.99,3
057-10=9.99
057-11=10.99
057-12=12.99,#
058-01=1.99
058-02=2.49
058-03=2.99
058-04=3.99,1
058-05=4.99
058-06=5.99
058-07=6.99,2
058-08=7.99
058-09=8.99,3
058-10=9.99
058-11=10.99
058-12=12.99,#
059-01=1.99
059-02=2.49
059-03=2.99
059-04=3.99,1
059-05=4.99
059-06=5.99
059-07=6.99,2
059-08=7.99
059-09=8.99,3
059-10=9.99
059-11=10.99
059-12=12.99,#
060-01=1.99
060-02=2.49
060-03=2.99
060-04=3.99,1
060-05=4.99
060-06=5.99
060-07=6.99,2
060-08=7.99
060-09=8.99,3
060-10=9.99
060-11=10.99
060-12=12.99,#
061-01=1.99
061-02=2.49
061-03=2.99
061-04=3.99,1
061-05=4.99
061-06=5.99
061-07=6.99,2
061-08=7.99
061-09=8.99,3
061-10=9.99
061-11=10.99
061-12=12.99,#
062-01=1.99
062-02=2.49
062-03=2.99
062-04=3.99,1
062-05=4.99
062-06=5.99
062-07=6.99,2
062-08=7.99
062-09=8.99,3
062-10=9.99
062-11=10.99
062-12=12.99,#
063-01=1.99
063-02=2.49
063-03=2.99
063-04=3.99,1
063-05=4.99
063-06=5.99
063-07=6.99,2
063-08=7.99
063-09=8.99,3
063-10=9.99
063-11=10.99
063-12=12.99,#
064-01=1.99
064-02=2.49
064-03=2.99
064-04=3.99,1
064-05=4.99
064-06=5.99
064-07=6.99,2
064-08=7.99
064-09=8.99,3
064-10=9.99
064-11=10.99
064-12=12.99,#
065-01=1.99
065-02=2.49
065-03=2.99
065-04=3.99,1
065-05=4.99
065-06=5.99
065-07=6.99,2
065-08=7.99
065-09=8.99,3
065-10=9.99
065-11=10.99
065-12=12.99,#
069-01=1.99
069-02=2.49
069-03=2.99
069-04=3.99,1
069-05=4.99
069-06=5.99
069-07=6.99,2
069-08=7.99
069-09=8.99,3
069-10=9.99
069-11=10.99
069-12=12.99,#
072-01=1.99
072-02=2.49
072-03=2.99
072-04=3.99,1
072-05=4.99
072-06=5.99
072-07=6.99,2
072-08=7.99
072-09=8.99,3
072-10=9.99
072-11=10.99
072-12=12.99,#
073-01=1.99
073-02=2.49
073-03=2.99
073-04=3.99
073-05=4.99,1
073-06=5.99
073-07=6.99
073-08=7.99,2
073-09=8.99
073-10=9.99,3
073-11=10.99
073-12=12.99,#
074-01=1.99
074-02=2.49
074-03=2.99
074-04=3.99
074-05=4.99,1
074-06=5.99
074-07=6.99
074-08=7.99,2
074-09=8.99
074-10=9.99,3
074-11=10.99
074-12=12.99,#
075-01=1.99
075-02=2.49
075-03=2.99
075-04=3.99
075-05=4.99,1
075-06=5.99
075-07=6.99
075-08=7.99,2
075-09=8.99
075-10=9.99,3
075-11=10.99
075-12=12.99,#
076-01=3.99
076-02=4.99
076-03=5.99
076-04=6.99
076-05=7.99,1
076-06=8.99
076-07=9.99
076-08=10.99,2
076-09=12.99
076-10=14.99,3
076-11=16.99
076-12=19.99,#
077-01=3.99
077-02=4.99
077-03=5.99
077-04=6.99
077-05=7.99,1
077-06=8.99
077-07=9.99
077-08=10.99,2
077-09=12.99
077-10=14.99,3
077-11=16.99
077-12=19.99,#
078-01=3.99
078-02=4.99
078-03=5.99
078-04=6.99
078-05=7.99,1
078-06=8.99
078-07=9.99
078-08=10.99,2
078-09=12.99
078-10=14.99,3
078-11=16.99
078-12=19.99,#
079-01=3.99
079-02=4.99
079-03=5.99
079-04=6.99
079-05=7.99,1
079-06=8.99
079-07=9.99
079-08=10.99,2
079-09=12.99
079-10=14.99,3
079-11=16.99
079-12=19.99,#
080-01=3.99
080-02=4.99
080-03=5.99
080-04=6.99
080-05=7.99,1
080-06=8.99
080-07=9.99
080-08=10.99,2
080-09=12.99
080-10=14.99,3
080-11=16.99
080-12=19.99,#
081-01=3.99
081-02=4.99
081-03=5.99
081-04=6.99
081-05=7.99,1
081-06=8.99
081-07=9.99
081-08=10.99,2
081-09=12.99
081-10=14.99,3
081-11=16.99
081-12=19.99,#
082-01=3.99
082-02=4.99
082-03=5.99
082-04=6.99
082-05=7.99,1
082-06=8.99
082-07=9.99
082-08=10.99,2
082-09=12.99
082-10=14.99,3
082-11=16.99
082-12=19.99,#
083-01=3.99
083-02=4.99
083-03=5.99
083-04=6.99
083-05=7.99,1
083-06=8.99
083-07=9.99
083-08=10.99,2
083-09=12.99
083-10=14.99,3
083-11=16.99
083-12=19.99,#
084-01=3.99
084-02=4.99
084-03=5.99
084-04=6.99
084-05=7.99,1
084-06=8.99
084-07=9.99
084-08=10.99,2
084-09=12.99
084-10=14.99,3
084-11=16.99
084-12=19.99,#
085-01=3.99
085-02=4.99
085-03=5.99
085-04=6.99
085-05=7.99,1
085-06=8.99
085-07=9.99
085-08=10.99,2
085-09=12.99
085-10=14.99,3
085-11=16.99
085-12=19.99,#
086-01=4.99
086-02=5.99
086-03=6.98
086-04=7.99
086-05=8.99,1
086-06=9.99
086-07=10.99
086-08=12.99
086-09=14.99,2
086-10=16.99
086-11=19.99,3
086-12=24.99,#
088-01=4.99
088-02=5.99
088-03=6.98
088-04=7.99
088-05=8.99,1
088-06=9.99
088-07=10.99
088-08=12.99
088-09=14.99,2
088-10=16.99
088-11=19.99,3
088-12=24.99,#
090-01=5.99
090-02=6.99
090-03=7.99
090-04=8.99
090-05=9.99
090-06=10.99,1
090-07=12.99
090-08=14.99
090-09=16.99
090-10=19.99,2
090-11=24.99
090-12=29.99,3#
094-01=5.99
094-02=6.99
094-03=7.99
094-04=8.99
094-05=9.99
094-06=10.99,1
094-07=12.99
094-08=14.99
094-09=16.99
094-10=19.99,2
094-11=24.99
094-12=29.99,3#
096-01=5.99
096-02=6.99
096-03=7.99
096-04=8.99
096-05=9.99
096-06=10.99,1
096-07=12.99
096-08=14.99
096-09=16.99
096-10=19.99,2
096-11=24.99
096-12=29.99,3#
097-01=5.99
097-02=6.99
097-03=7.99
097-04=8.99
097-05=9.99
097-06=10.99,1
097-07=12.99
097-08=14.99
097-09=16.99
097-10=19.99,2
097-11=24.99
097-12=29.99,3#
098-01=5.99
098-02=6.99
098-03=7.99
098-04=8.99
098-05=9.99
098-06=10.99,1
098-07=12.99
098-08=14.99
098-09=16.99
098-10=19.99,2
098-11=24.99
098-12=29.99,3#
099-01=5.99
099-02=6.99
099-03=7.99
099-04=8.99
099-05=9.99
099-06=10.99,1
099-07=12.99
099-08=14.99
099-09=16.99
099-10=19.99,2
099-11=24.99
099-12=29.99,3#
100-01=0.49
100-02=0.79,1
100-03=0.99
100-04=1.49,2
100-05=1.99,3
100-06=2.49
100-07=2.99
100-08=3.99
100-09=4.99
100-10=5.99
100-11=6.99
100-12=7.99,#
101-01=0.49,#
101-02=0.79,#
101-03=0.99,#
101-04=1.49,#
101-05=1.99,#
101-06=2.49,#
101-07=2.99,#
101-08=3.99,#
101-09=4.99,#
101-10=5.99,#
101-11=6.99,#
101-12=7.99,#
116-01=0.99
116-02=1.49
116-03=1.99,1
116-04=2.49
116-05=2.99
116-06=3.99,2
116-07=4.99
116-08=5.99,3
116-09=6.99
116-10=7.99
116-11=8.99
116-12=9.99,#
117-01=0.99
117-02=1.49
117-03=1.99,1
117-04=2.49
117-05=2.99
117-06=3.99,2
117-07=4.99
117-08=5.99,3
117-09=6.99
117-10=7.99
117-11=8.99
117-12=9.99,#
118-01=0.99
118-02=1.49
118-03=1.99,1
118-04=2.49
118-05=2.99
118-06=3.99,2
118-07=4.99
118-08=5.99,3
118-09=6.99
118-10=7.99
118-11=8.99
118-12=9.99,#
119-01=0.99
119-02=1.49
119-03=1.99,1
119-04=2.49
119-05=2.99
119-06=3.99,2
119-07=4.99
119-08=5.99,3
119-09=6.99
119-10=7.99
119-11=8.99
119-12=9.99,#
120-01=1.99
120-02=2.49
120-03=2.99
120-04=3.99
120-05=4.99
120-06=5.99,1
120-07=6.99
120-08=7.99
120-09=8.99
120-10=9.99,2
120-11=10.99
120-12=12.99,3#
121-01=1.99
121-02=2.49
121-03=2.99
121-04=3.99
121-05=4.99
121-06=5.99,1
121-07=6.99
121-08=7.99
121-09=8.99
121-10=9.99,2
121-11=10.99
121-12=12.99,3#
122-01=1.99
122-02=2.49
122-03=2.99
122-04=3.99
122-05=4.99
122-06=5.99,1
122-07=6.99
122-08=7.99
122-09=8.99
122-10=9.99,2
122-11=10.99
122-12=12.99,3#
123-01=1.99
123-02=2.49
123-03=2.99
123-04=3.99
123-05=4.99
123-06=5.99,1
123-07=6.99
123-08=7.99
123-09=8.99
123-10=9.99,2
123-11=10.99
123-12=12.99,3#
124-01=2.99
124-02=3.99
124-03=4.99,1
124-04=5.99
124-05=6.99
124-06=8.99,2
124-07=9.99
124-08=10.99,3
124-09=12.99
124-10=14.99
124-11=16.99
124-12=19.99,#
125-01=2.99
125-02=3.99
125-03=4.99,1
125-04=5.99
125-05=6.99
125-06=8.99,2
125-07=9.99
125-08=10.99,3
125-09=12.99
125-10=14.99
125-11=16.99
125-12=19.99,#
126-01=2.99
126-02=3.99
126-03=4.99,1
126-04=5.99
126-05=6.99
126-06=8.99,2
126-07=9.99
126-08=10.99,3
126-09=12.99
126-10=14.99
126-11=16.99
126-12=19.99,#
127-01=2.99
127-02=3.99
127-03=4.99,1
127-04=5.99
127-05=6.99
127-06=8.99,2
127-07=9.99
127-08=10.99,3
127-09=12.99
127-10=14.99
127-11=16.99
127-12=19.99,#
128-01=3.99
128-02=4.99
128-03=5.99
128-04=6.99
128-05=7.99,1
128-06=8.99
128-07=9.99
128-08=10.99
128-09=12.99
128-10=14.99,2
128-11=16.99
128-12=19.99,3#
129-01=3.99
129-02=4.99
129-03=5.99
129-04=6.99
129-05=7.99,1
129-06=8.99
129-07=9.99
129-08=10.99
129-09=12.99
129-10=14.99,2
129-11=16.99
129-12=19.99,3#
130-01=3.99
130-02=4.99
130-03=5.99
130-04=6.99
130-05=7.99,1
130-06=8.99
130-07=9.99
130-08=10.99
130-09=12.99
130-10=14.99,2
130-11=16.99
130-12=19.99,3#
131-01=3.99
131-02=4.99
131-03=5.99
131-04=6.99
131-05=7.99,1
131-06=8.99
131-07=9.99
131-08=10.99
131-09=12.99
131-10=14.99,2
131-11=16.99
131-12=19.99,3#
132-01=2.99
132-02=3.99
132-03=4.99
132-04=5.99,1
132-05=6.99
132-06=8.99
132-07=9.99,2
132-08=10.99
132-09=12.99
132-10=14.99,3
132-11=16.99
132-12=19.99,#
133-01=2.99
133-02=3.99
133-03=4.99
133-04=5.99,1
133-05=6.99
133-06=8.99
133-07=9.99,2
133-08=10.99
133-09=12.99
133-10=14.99,3
133-11=16.99
133-12=19.99,#
140-01=2.49
140-02=2.99
140-03=3.99
140-04=4.99,1
140-05=5.99
140-06=6.99
140-07=7.99
140-08=8.99,2
140-09=9.99
140-10=10.99,3
140-11=12.99
140-12=14.99,#
141-01=2.49
141-02=2.99
141-03=3.99
141-04=4.99,1
141-05=5.99
141-06=6.99
141-07=7.99
141-08=8.99,2
141-09=9.99
141-10=10.99,3
141-11=12.99
141-12=14.99,#
142-01=2.49
142-02=2.99
142-03=3.99
142-04=4.99,1
142-05=5.99
142-06=6.99
142-07=7.99
142-08=8.99,2
142-09=9.99
142-10=10.99,3
142-11=12.99
142-12=14.99,#
143-01=2.49
143-02=2.99
143-03=3.99
143-04=4.99,1
143-05=5.99
143-06=6.99
143-07=7.99
143-08=8.99,2
143-09=9.99
143-10=10.99,3
143-11=12.99
143-12=14.99,#
144-01=2.49
144-02=2.99
144-03=3.99
144-04=4.99,1
144-05=5.99
144-06=6.99
144-07=7.99
144-08=8.99,2
144-09=9.99
144-10=10.99,3
144-11=12.99
144-12=14.99,#
145-01=2.49
145-02=2.99
145-03=3.99
145-04=4.99,1
145-05=5.99
145-06=6.99
145-07=7.99
145-08=8.99,2
145-09=9.99
145-10=10.99,3
145-11=12.99
145-12=14.99,#
146-01=2.49
146-02=2.99
146-03=3.99
146-04=4.99,1
146-05=5.99
146-06=6.99
146-07=7.99
146-08=8.99,2
146-09=9.99
146-10=10.99,3
146-11=12.99
146-12=14.99,#
147-01=2.49
147-02=2.99
147-03=3.99
147-04=4.99,1
147-05=5.99
147-06=6.99
147-07=7.99
147-08=8.99,2
147-09=9.99
147-10=10.99,3
147-11=12.99
147-12=14.99,#
148-01=2.49
148-02=2.99
148-03=3.99
148-04=4.99,1
148-05=5.99
148-06=6.99
148-07=7.99
148-08=8.99,2
148-09=9.99
148-10=10.99,3
148-11=12.99
148-12=14.99,#
149-01=2.49
149-02=2.99
149-03=3.99
149-04=4.99,1
149-05=5.99
149-06=6.99
149-07=7.99
149-08=8.99,2
149-09=9.99
149-10=10.99,3
149-11=12.99
149-12=14.99,#
150-01=2.49
150-02=2.99
150-03=3.99
150-04=4.99,1
150-05=5.99
150-06=6.99
150-07=7.99
150-08=8.99,2
150-09=9.99
150-10=10.99,3
150-11=12.99
150-12=14.99,#
151-01=2.49
151-02=2.99
151-03=3.99
151-04=4.99,1
151-05=5.99
151-06=6.99
151-07=7.99
151-08=8.99,2
151-09=9.99
151-10=10.99,3
151-11=12.99
151-12=14.99,#
152-01=2.49
152-02=2.99
152-03=3.99
152-04=4.99,1
152-05=5.99
152-06=6.99
152-07=7.99
152-08=8.99,2
152-09=9.99
152-10=10.99,3
152-11=12.99
152-12=14.99,#
156-01=2.49
156-02=2.99
156-03=3.99
156-04=4.99,1
156-05=5.99
156-06=6.99
156-07=7.99
156-08=8.99,2
156-09=9.99
156-10=10.99,3
156-11=12.99
556-01=4.99
556-02=5.99
556-03=6.99
556-04=7.99
556-05=8.99
556-06=9.99
556-07=10.99
556-08=12.99
556-09=14.99,1
556-10=16.99
556-11=19.99,2
556-12=24.99,3#
557-01=4.99
557-02=5.99
557-03=6.99
557-04=7.99
557-05=8.99
557-06=9.99
557-07=10.99
557-08=12.99
557-09=14.99,1
557-10=16.99
557-11=19.99,2
557-12=24.99,3#
560-01=4.99
560-02=5.99
560-03=6.99
560-04=7.99
560-05=8.99
560-06=9.99
560-07=10.99
560-08=12.99
560-09=14.99,1
560-10=16.99
560-11=19.99,2
560-12=24.99,3#
600-01=0.49,#
600-02=0.79,#
600-03=0.99,#
600-04=1.49,#
600-05=1.99,#
600-06=2.49,#
600-07=2.99,#
600-08=3.99,#
600-09=4.99,#
600-10=5.99,#
600-11=6.99,#
600-12=7.99,#
601-01=0.49,#
601-02=0.79,#
601-03=0.99,#
601-04=1.49,#
601-05=1.99,#
601-06=2.49,#
601-07=2.99,#
601-08=3.99,#
601-09=4.99,#
601-10=5.99,#
601-11=6.99,#
601-12=7.99,#
602-01=0.49,#
602-02=0.79,#
700-01=x
700-02=x
700-03=x
700-04=x
700-05=x
700-06=x
700-07=x
700-08=x
700-09=x
700-10=x
700-11=x
700-12=x


Report •

#10
January 14, 2009 at 23:07:43
I've reposted the code, hopefully to take into account all the record formats you supplied. When I copy/pasted the records I got four blanks at the start of each one, I'm assuming that these were the result of forum indenting and that they're not present in the QP.ini file. I haven't done much testing, again leaving you to confirm the script is performing as you want.

I'm going bush for three days so will check back on Monday hoping that it's good news day.

V.


Report •

#11
January 15, 2009 at 06:41:42
It works great. I made just a few minor changes but you nailed it!!! Thank you so much for your help. Have a great weekend and I hope to talk to you again.

Thanks again.

Paul


Report •

#12
January 18, 2009 at 12:56:43
Thanks for coming back with your good news. No charge for the assist but a donation to your local Breast Cancer Support Group or Cancer Support Group would, I'm sure, be appreciated.

All the best.

Valerie.


Report •

#13
January 19, 2009 at 07:05:11
Funny you should mention that. Our company does donations to that cause already. I did have one more question. the batch file works great, I have modified it to over write the exisiting INI instead of writing out to a txt file. It works great the first time through but when I try to run it again on the INI that has already been modified I see several "missing opperand" statements and when I look at the ini again the one section that has nothing but x's (700 section) is messed up. Instead of x's it has the price from the last 600 section line in place of all the x's. I am sure I can figure this out but I thought I would get your input as well.

Thanks for all your help.


Report •

#14
January 19, 2009 at 18:52:33
Good on the donation front, your company heads are to be congratulated.

On the problem you've encountered - yes - it's a bug in the code though not a really obvious one. I'll leave you to sweat it out!!!


Report •

#15
January 28, 2009 at 07:06:47
Well, I got it all working! Sorry I didnt let you know sooner. You were a big help and if you were closer I would take you out to dinner!

Thanks again.


Report •


Ask Question