ADMIN REPROT

where you are getting problem

hi Peta,

thanks for replying , i have converted your macro(bend pml function) which is circulating in forum into a macro for outputting database. 

as we see in snap, my coloumn G 'DBNUM' is giving me incorrect details same for coloumn K,E

it seems my write up is very bad.

i will try to look more into the macro.

if you could provide me some advice, that would be of great help.

!DBS = !!collectallfor(|DB|,||,!!CE)
!result = array()
!P = CURRENT PROJECT
!projcode = 'Project Code =' & !p.code()
!ProjName = 'Project Name =' & !p.name()
var !name user
!name1 = 'Project User =' & !name
!Now = 'Date = ' & object DATETIME()
!result[1] = !projcode
!result[2] = !ProjName
!result[3] = !name1
!result[4] = !Now
!result[5] = ''
!result = ''
!result[7] = 'DB Name' & ',' & 'DB NUM' & ',' & 'Type DB'
!result = ''
do !DB values !DBS
!result.append(!DB.FLNM & |,| & !DB.NUMBDB & |,| & !DB.TYPEDB)
enddo
!file = object file(|%PDMSUSER%\UDAREPORT.CSV|)
!file.writefile(|OVERWRITE|,!result)
!file.close()
syscom 'start notepad++.exe $!file&'

SOME Attributes are changed

in addition to the above, i am trying to bring the details of file name as well but not coming correctly. this field i have updated to the code mark in bold please refer below code.

!DBS = !!collectallfor(|DB|,||,!!CE)
!result = array()
!P = CURRENT PROJECT
!projcode = 'Project Code =' & !p.code()
!ProjName = 'Project Name =' & !p.name()
var !name user
!name1 = 'Project User =' & !name
!Now = 'Date = ' & object DATETIME()
!result[1] = !projcode
!result[2] = !ProjName
!result[3] = !name1
!result[4] = !Now
!result[5] = ''
!result = ''
!result[7] = 'DB Name' & ',' & 'DB NUM' & ',' & 'Type DB' & ',' & 'DB filename'
!result = ''
do !DB values !DBS
!result.append(!DB.FLNM & |,| & !DB.NUMBDB & |,| & !DB.TYPEDB & |,| & !DB.filename)
enddo
!file = object file(|C:\Apps\PDMSUSER\DBREPORT.CSV|)
!file.writefile(|OVERWRITE|,!result)
!file.close()
--syscom 'start notepad.exe$!file&'

it seems when i try to take dbfilename it is just taking the system database information not the file name which is present in folder in below image. why i am seeking this arrangment , as lot of model are gatting handover to us, so i wanted to make myself sure the file name & db num philosophy is same

yes it is taking sys information, there is no attribute