Need help in Macros

[sathik]

Hi All,
I need help in macros.
I am plainning to create tablepace growth report for my 106 databases.
For this, I have created a separate BAT file script. It will provide a csv file having 2 columns named total_space,used space like below. but rows will be 1150.

300 300
50 50
36 36
800 800
10000 10000
9000 9000
20696 20696
2000 2000
12100 12100
4000 4000
8000 8000
700 700
128 128
50 50
900 900
1000 1000
3000 3000
5 5
3000 3000

Now I need macros code to copy the 1st column data resides in the above excel sheet and paste it in the 3rd column (column c) of below excel sheet, when I click a button on the 1st day.At the same time, the 2nd column of above excel sheet has to go to 3rd column of 2nd sheet.

similarly when I click the same button on 2nd day, the 1st column data has to go to column D of 1st sheet and the
2nd column data has to go to column D of 2nd sheet.

Db name  Tablespace name     Total_space
 
CDB          AUDIT_DATA 
CDB         BDB_DATA 
CDB      BDB_IDX 
CDB      CDB_DATA1 
CDB      CDB_DATA2 
CDB      CDB_DATA3 
CDB      CDB_DATA4 
CDB      CDB_IDX1 
CDB      CDB_IDX2 
CDB      CDB_IDX3 
CDB      CDB_IDX4 
CDB      CDB_SFT_DATA 
CDB      CDB_SFT_IDX 
CDB      SYMANTEC_I3_ORCL 
CDB      SYSAUX 
CDB      SYSTEM 
CDB      UNDOTBS1 
CDB      USERS 
CDB      USER_DATA

 

[CharlesChuckieCharles]

That would be easy enough BUT

why can't your php script get the drive name at the same time as the size

Because you are effectively pre-supposing that the two lists will always be in the same order and of the same size

You probably need to work on the php script for the size to extract that other two parts plus an extract date... rather than mess about in excel (at least for now )

 

[sathik]

Thanks for your response.

Yes I will place my raw data excel sheet in a location at every time with the same name.

So I can mention that excel sheet name and location in the code.

But the issue for me is, I dont know how to write php script. Thatswhy I need help from you kind of people.

 

[CharlesChuckieCharles]

The issue is
can you prove
CDB AUDIT_DATA
and
300 300
match up correctly
and not just cos they are both at the Top of their respective lists

I for one wouldn't trust the data