Designer listing

[MacolaHelp]

Anyone know how to print out a list of all customized screensets? I thought, silly me, that I could look in PCC, but naturally, the srcfil.btrs are not in the ddf. Short of looking up one module, one screen at a time, has anyone got a "quick report" or lookup for me? Thanks.

 

[dgillz]

You need to write a SQL query for this and join all screen files into one query and select only those records where the user is not Macola.

We have done this before and I will try to get you a copy of this SQL if you can get me an email address.



Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[dgillz]

I think I misunderstood you. If you are using pervasive, I do not know how to do this. As you have said, this is not in the .ddfs. If you are using MS SQL Server, launch the following from Query Analyzer and it will give you the modified screens and who the user is.

select screen_id, screen_name from adscrfil_sql where (screen_name <> 'MACOLA') union
select screen_id, screen_name from apscrfil_sql where (screen_name <> 'MACOLA') union
select screen_id, screen_name from arscrfil_sql where (screen_name <> 'MACOLA') union
select screen_id, screen_name from bbscrfil_sql where (screen_name <> 'MACOLA') union
select screen_id, screen_name from bcscrfil_sql where (screen_name <> 'MACOLA') union
select screen_id, screen_name from bmscrfil_sql where (screen_name <> 'MACOLA') union
select screen_id, screen_name from cmscrfil_sql where (screen_name <> 'MACOLA') union
select screen_id, screen_name from crscrfil_sql where (screen_name <> 'MACOLA') union
select screen_id, screen_name from edscrfil_sql where (screen_name <> 'MACOLA') union
select screen_id, screen_name from glscrfil_sql where (screen_name <> 'MACOLA') union
select screen_id, screen_name from hzscrfil_sql where (screen_name <> 'MACOLA') union
select screen_id, screen_name from imscrfil_sql where (screen_name <> 'MACOLA') union
select screen_id, screen_name from jcscrfil_sql where (screen_name <> 'MACOLA') union
select screen_id, screen_name from jescrfil_sql where (screen_name <> 'MACOLA') union
select screen_id, screen_name from lpscrfil_sql where (screen_name <> 'MACOLA') union
select screen_id, screen_name from mcscrfil_sql where (screen_name <> 'MACOLA') union
select screen_id, screen_name from mrscrfil_sql where (screen_name <> 'MACOLA') union
select screen_id, screen_name from msscrfil_sql where (screen_name <> 'MACOLA') union
select screen_id, screen_name from oescrfil_sql where (screen_name <> 'MACOLA') union
select screen_id, screen_name from pkscrfil_sql where (screen_name <> 'MACOLA') union
select screen_id, screen_name from poscrfil_sql where (screen_name <> 'MACOLA') union
select screen_id, screen_name from ppscrfil_sql where (screen_name <> 'MACOLA') union
select screen_id, screen_name from prscrfil_sql where (screen_name <> 'MACOLA') union
select screen_id, screen_name from scscrfil_sql where (screen_name <> 'MACOLA') union
select screen_id, screen_name from sfscrfil_sql where (screen_name <> 'MACOLA') union
select screen_id, screen_name from srscrfil_sql where (screen_name <> 'MACOLA') union
select screen_id, screen_name from ssscrfil_sql where (screen_name <> 'MACOLA') union
select screen_id, screen_name from syscrfil_sql where (screen_name <> 'MACOLA')




Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[MacolaHelp]

Yes, in MSSQL you have access to the screen files & I could write a report, view, update query, etc., on that platform. Since this client is on p.sql, we are going to see about modifying the ddf to include the screens. Between btfiler & what is visible in mssql, maybe we have enough of the file definition to get it added to the ddf. If so, I will use it often to update screensets instead of the putsy way we have to do it now, one at time. And, in PWE, you have to close out of designer & go back in to make multiple changes. Ugh.

For now, I am going to use btfiler to list out & export my modified screensets, which will at least give me the documentation on where to start.

 

[dgillz]

MacolaHelp,

I have one of our people working on a set of modified .ddfs now for version 7.6.100a. I will forward it to you if you give me an email address.

Don Gilsdorf

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com