Re: [Hardhats-members] Template Question
Aren't multiples treated in fileman as subfiles? Don't the functions that would work with a separate file also work with the subfile number? And if they don't then that would be an area of completion that would be needed in fileman. Kevi --- Greg Kreis [EMAIL PROTECTED] wrote: This is a good example of the danger of multiples in FM. They can create non-normalized databases, forcing folks to stand on their head to get some results. It is much easier, when reporting, to deal with files that have pointers that link the records. Having said that, these pointed files can be a pain in templates for editing. Bob Beckley wrote: Greg, I finally ended up with this, and it seems to do the trick when I tie it to a print-type menu option. I want to report just instances of where one sub-field equals another sub-sub-field. Any additional comments are certainly welcome. TSTD Q^DI VA FileMan 22.0 Select OPTION: PRINT FILE ENTRIES OUTPUT FROM WHAT FILE: PRINT TEMPLATE// 458 TIME ATTENDANCE RECORDS (281 entries) SORT BY: PAY PERIOD// START WITH PAY PERIOD: FIRST// 04-12 GO TO PAY PERIOD: LAST// 04-12 WITHIN PAY PERIOD, SORT BY: 1 EMPLOYEE (multiple) EMPLOYEE SUB-FIELD: 10 DAY # (multiple) DAY # SUB-FIELD: APP. SUPERVISOR=TIMEKEEPER POSTING WITHIN APP. SUPERVISOR=TIMEKEEPER POSTING, SORT BY: STORE IN 'SORT' TEMPLATE: ZZBBSEARCH1 Are you adding 'ZZBBSEARCH1' as a new SORT TEMPLATE? No// Y (Yes) DESCRIPTION: No existing text Edit? NO// YES ==[ WRAP ]==[ INSERT ]= DESCRIPTION ===[ PF1H=Help ] Search template for APP. SUPERVISOR = TIMEKEEPER POSTING fields in TA file. ===T===T===T===T===T===T===T===T===T== SHOULD TEMPLATE USER BE ASKED 'FROM'-'TO' RANGE FOR 'PAY PERIOD'? NO// y YES FIRST PRINT FIELD: .01 PAY PERIOD THEN PRINT FIELD: 1 EMPLOYEE (multiple) THEN PRINT EMPLOYEE SUB-FIELD: 2 APP. SUPERVISOR THEN PRINT EMPLOYEE SUB-FIELD: 10 DAY # (multiple) THEN PRINT DAY # SUB-FIELD: 102 TIMEKEEPER POSTING THEN PRINT DAY # SUB-FIELD: THEN PRINT EMPLOYEE SUB-FIELD: THEN PRINT FIELD: Heading: TIME ATTENDANCE RECORDS LIST Replace ... With TA Check Replace TA Check STORE PRINT LOGIC IN TEMPLATE: ZZBBPRINT1 Are you adding 'ZZBBPRINT1' as a new PRINT TEMPLATE? No// Y (Yes) START AT PAGE: 1// DEVICE: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Greg Kreis Sent: Saturday, January 29, 2005 4:24 PM To: hardhats-members@lists.sourceforge.net Subject: Re: [Hardhats-members] Template Question Why not create a computed field that figures out if the condition exists and then sets its value (S X=...) to what you want to print? Here is a general form for the code. S X= S:condition X=sub-field retrieval code_ _sub-sub-field retrieval code In the code for condition, sub-field and sub-sub-field you can refer to the variables D1 for the sub-field record number and D2 for the sub-sub-field record number. The above approach means you need to create this field in the sub-sub-file so that when it is accessed, the values of D1 and D2 exist. But, is that what you want? For instance, aren't you going to have to go through all the sub-sub-file records to compare their field to sub-field? I am not quite sure I understand a database situation where this makes sense. Can you give some more details? Bob Beckley wrote: I think I figured it out, all you late risers. :) Almost . . . I drilled down to the lower sub-field and entered a boolean expression (which used both sub-fields), which returns 0 or 1 in X. Then, at the next prompt, I can work with X. Now I just need to figure out how to suppress the printing of the 0's and print only the 1's. If I mess with the boolean at all, it doesn't like it (I get ?? back.). Right now I have SUB-FIELD=SUB-FIELD for the boolean, and when I try something like I (SUB-FIELD=SUB-FIELD)=1 W MORE INFO, it blows up. Any ideas. Thanks again in advance. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bob Beckley Sent: Saturday, January 29, 2005 6:22 AM To: hardhats-members@lists.sourceforge.net Subject: [Hardhats-members] Template Question I'm building a print template and want to compare the values of two sub-fields in the same file. One sub-field is one level down in multiple A, while the other is two levels down in multiple A. If they are the same, I want to print both fields; if different, then print nothing. The problem lies in knowing what to write at the AND THEN FIELD: prompt. If this were pointer-related instead of sub-field-related, I would write something like (A:B=A:C:D) and then do something with the return value of 0 or 1. I guess what I'm asking is
[Hardhats-members] FileMan in Cache
If you look at a global listing in the Cache/VMS environment, you'll notice that the global array to the left of the = sign is listed only once. Subsequent entries with the same global array are blank to the left of the = sign, with new data to the right, like so: ^ABC(1,ID)=123^124 =321^421 =534^543 ... This apparently carries over into FileMan reports, like so: Jones, John 12344 Yes Vet 43214 No Vet Both entries are for John Jones, but his name is listed only once. Does anyone know how to make, in this example, John Jones appear on each and every line instead of a blank? I don't know of any print qualifiers that cover this. (Perhaps I should take it up with Intersystems?) Thanks in advance. --- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag--drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl ___ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members
Re: [Hardhats-members] FileMan in Cache
Bob Witkop from Intersystems hangs his hat here at times, so he will see this. On Sunday 30 January 2005 02:25 pm, Bob Beckley wrote: If you look at a global listing in the Cache/VMS environment, you'll notice that the global array to the left of the = sign is listed only once. Subsequent entries with the same global array are blank to the left of the = sign, with new data to the right, like so: ^ABC(1,ID)=123^124 =321^421 =534^543 ... This apparently carries over into FileMan reports, like so: Jones, John 12344 Yes Vet 43214 No Vet Both entries are for John Jones, but his name is listed only once. Does anyone know how to make, in this example, John Jones appear on each and every line instead of a blank? I don't know of any print qualifiers that cover this. (Perhaps I should take it up with Intersystems?) Thanks in advance. --- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag--drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl ___ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members -- Nancy Anthracite --- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag--drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl ___ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members
Re: [Hardhats-members] Template Question
Kevin Toppenberg wrote: Aren't multiples treated in fileman as subfiles? Sort of. Don't the functions that would work with a separate file also work with the subfile number? You can't point to a sub-file. You will notice that it is harder to search a file with sub-files in it as you have to control the entries in the sub-file that you are interested in seeing. And if they don't then that would be an area of completion that would be needed in fileman. As I understand it, there is frustration from some developers in the VA because the VA has long ago chosen to put these infrastructure components on maintenance. For instance, the last FM release was v22 in the mid-90s. While some patches add new functionality, these are not typically the source of large changes. So, yes, there are some things that many would like to see addressed in FM, but that isn't the direction the VA is going. I am not arguing for or against the current status quo, just pointing out factors that might explain partially why things are as they are. Kevi --- Greg Kreis [EMAIL PROTECTED] wrote: This is a good example of the danger of multiples in FM. They can create non-normalized databases, forcing folks to stand on their head to get some results. It is much easier, when reporting, to deal with files that have pointers that link the records. Having said that, these pointed files can be a pain in templates for editing. Bob Beckley wrote: Greg, I finally ended up with this, and it seems to do the trick when I tie it to a print-type menu option. I want to report just instances of where one sub-field equals another sub-sub-field. Any additional comments are certainly welcome. TSTD Q^DI VA FileMan 22.0 Select OPTION: PRINT FILE ENTRIES OUTPUT FROM WHAT FILE: PRINT TEMPLATE// 458 TIME ATTENDANCE RECORDS (281 entries) SORT BY: PAY PERIOD// START WITH PAY PERIOD: FIRST// 04-12 GO TO PAY PERIOD: LAST// 04-12 WITHIN PAY PERIOD, SORT BY: 1 EMPLOYEE (multiple) EMPLOYEE SUB-FIELD: 10 DAY # (multiple) DAY # SUB-FIELD: APP. SUPERVISOR=TIMEKEEPER POSTING WITHIN APP. SUPERVISOR=TIMEKEEPER POSTING, SORT BY: STORE IN 'SORT' TEMPLATE: ZZBBSEARCH1 Are you adding 'ZZBBSEARCH1' as a new SORT TEMPLATE? No// Y (Yes) DESCRIPTION: No existing text Edit? NO// YES ==[ WRAP ]==[ INSERT ]= DESCRIPTION ===[ PF1H=Help ] Search template for APP. SUPERVISOR = TIMEKEEPER POSTING fields in TA file. ===T===T===T===T===T===T===T===T===T== SHOULD TEMPLATE USER BE ASKED 'FROM'-'TO' RANGE FOR 'PAY PERIOD'? NO// y YES FIRST PRINT FIELD: .01 PAY PERIOD THEN PRINT FIELD: 1 EMPLOYEE (multiple) THEN PRINT EMPLOYEE SUB-FIELD: 2 APP. SUPERVISOR THEN PRINT EMPLOYEE SUB-FIELD: 10 DAY # (multiple) THEN PRINT DAY # SUB-FIELD: 102 TIMEKEEPER POSTING THEN PRINT DAY # SUB-FIELD: THEN PRINT EMPLOYEE SUB-FIELD: THEN PRINT FIELD: Heading: TIME ATTENDANCE RECORDS LIST Replace ... With TA Check Replace TA Check STORE PRINT LOGIC IN TEMPLATE: ZZBBPRINT1 Are you adding 'ZZBBPRINT1' as a new PRINT TEMPLATE? No// Y (Yes) START AT PAGE: 1// DEVICE: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Greg Kreis Sent: Saturday, January 29, 2005 4:24 PM To: hardhats-members@lists.sourceforge.net Subject: Re: [Hardhats-members] Template Question Why not create a computed field that figures out if the condition exists and then sets its value (S X=...) to what you want to print? Here is a general form for the code. S X="" S:condition X=sub-field retrieval code_" "_sub-sub-field retrieval code In the code for condition, sub-field and sub-sub-field you can refer to the variables D1 for the sub-field record number and D2 for the sub-sub-field record number. The above approach means you need to create this field in the sub-sub-file so that when it is accessed, the values of D1 and D2 exist. But, is that what you want? For instance, aren't you going to have to go through all the sub-sub-file records to compare
Re: [Hardhats-members] FileMan in Cache
The Cache display of globals that suppresses the subscripts is just a formatting choice. It is just how they chose to present them. It doesn't influence how globals work or how FM works. FM can be made to suppress repeating values in a column through the use of a suffix of ;N for a field specification in the print template. Look at the print template of the report that you showed here. The fields normally repeat. You have to work to suppress them. Bob Beckley wrote: If you look at a global listing in the Cache/VMS environment, you'll notice that the global array to the left of the = sign is listed only once. Subsequent entries with the same global array are blank to the left of the = sign, with new data to the right, like so: ^ABC(1,ID)=123^124 =321^421 =534^543 ... This apparently carries over into FileMan reports, like so: Jones, John 12344 Yes Vet 43214 No Vet Both entries are for John Jones, but his name is listed only once. Does anyone know how to make, in this example, John Jones appear on each and every line instead of a blank? I don't know of any print qualifiers that cover this. (Perhaps I should take it up with Intersystems?) Thanks in advance. --- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag--drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl ___ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members -- Greg Kreis http://www.PioneerDataSys.com You are today where your thoughts have brought you, you will be tomorrow where your thoughts take you. (James Lane Allen) --- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag--drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl ___ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members
Re: [Hardhats-members] FileMan in Cache
Nancy; The global listed does not look like a valid Fileman Global structure, (but it is a fine MUMPS global just the same). If you are trying to access this with fileman, it may not be evaluating it the way you think. I'm kind of surprised that the global list utility does not yield the difference in the subsequent nodes. - Original Message - From: Nancy E. Anthracite [EMAIL PROTECTED] To: hardhats-members@lists.sourceforge.net Sent: Sunday, January 30, 2005 12:43 PM Subject: Re: [Hardhats-members] FileMan in Cache Bob Witkop from Intersystems hangs his hat here at times, so he will see this. On Sunday 30 January 2005 02:25 pm, Bob Beckley wrote: If you look at a global listing in the Cache/VMS environment, you'll notice that the global array to the left of the = sign is listed only once. Subsequent entries with the same global array are blank to the left of the = sign, with new data to the right, like so: ^ABC(1,ID)=123^124 =321^421 =534^543 ... This apparently carries over into FileMan reports, like so: Jones, John 12344 Yes Vet 43214 No Vet Both entries are for John Jones, but his name is listed only once. Does anyone know how to make, in this example, John Jones appear on each and every line instead of a blank? I don't know of any print qualifiers that cover this. (Perhaps I should take it up with Intersystems?) Thanks in advance. --- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag--drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl ___ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members
RE: [Hardhats-members] FileMan in Cache
Greg, we're running Cache/VMS and have no choice (as far as I can figure) regarding consecutive duplicate value suppression. Our global listings automatically (it seems) employ it, and now I've noticed it in a print menu option I just created. I just want to un-suppress them. Here's an example: print template: FIRST PRINT FIELD: PAY PERIOD THEN PRINT FIELD: EMPLOYEE THEN PRINT EMPLOYEE SUB-FIELD: EMPLOYEE;C12;L18 THEN PRINT EMPLOYEE SUB-FIELD: APP. SUPERVISOR;C35;L18 THEN PRINT EMPLOYEE SUB-FIELD: DAY # THEN PRINT DAY # SUB-FIELD: TIMEKEEPER POSTING;C58;L18 THEN PRINT DAY # SUB-FIELD: THEN PRINT EMPLOYEE SUB-FIELD: THEN PRINT FIELD: Heading: TIME ATTENDANCE RECORDS LIST Replace ... With TA Check Replace TA Check STORE PRINT LOGIC IN TEMPLATE: ZZBBPRINT1 Are you adding 'ZZBBPRINT1' as a new PRINT TEMPLATE? No// Y (Yes) printout: TA Check JAN 29,2005 21:41PAGE 1 PAY PERIOD EMPLOYEE APP. SUPERVISORTIMEKEEPER POSTING 04-06 ,OSCAR L JR These are null matches, which we want. xxx,ALVIN Cxx,SANDRA Mxx,SANDRA M xx,SANDRA M xx,SANDRA M xx,SANDRA M No suppression employed via the print template. Where's it coming from, then? Weird, huh? Thanks for your time. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Greg Kreis Sent: Sunday, January 30, 2005 7:27 PM To: hardhats-members@lists.sourceforge.net Subject: Re: [Hardhats-members] FileMan in Cache The Cache display of globals that suppresses the subscripts is just a formatting choice. It is just how they chose to present them. It doesn't influence how globals work or how FM works. FM can be made to suppress repeating values in a column through the use of a suffix of ;N for a field specification in the print template. Look at the print template of the report that you showed here. The fields normally repeat. You have to work to suppress them. Bob Beckley wrote: If you look at a global listing in the Cache/VMS environment, you'll notice that the global array to the left of the = sign is listed only once. Subsequent entries with the same global array are blank to the left of the = sign, with new data to the right, like so: ^ABC(1,ID)=123^124 =321^421 =534^543 ... This apparently carries over into FileMan reports, like so: Jones, John 12344 Yes Vet 43214 No Vet Both entries are for John Jones, but his name is listed only once. Does anyone know how to make, in this example, John Jones appear on each and every line instead of a blank? I don't know of any print qualifiers that cover this. (Perhaps I should take it up with Intersystems?) Thanks in advance. --- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag--drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl ___ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members -- Greg Kreis http://www.PioneerDataSys.com You are today where your thoughts have brought you, you will be tomorrow where your thoughts take you. (James Lane Allen) --- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag--drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl ___ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members --- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag--drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl ___ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members
RE: [Hardhats-members] FileMan in Cache
Chris, you're right about the validity. I just made up the example on-the-fly. The real problem is that under the Cache/VMS environment, my FileMan report automatically suppresses consecutive duplicate values, which is very weird, since there is a FileMan print qualifier (;N) used to suppress them. I want to un-suppress them somehow. Please see my reply to Greg. Thanks. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Chris Richardson Sent: Sunday, January 30, 2005 7:26 PM To: hardhats-members@lists.sourceforge.net Subject: Re: [Hardhats-members] FileMan in Cache Nancy; The global listed does not look like a valid Fileman Global structure, (but it is a fine MUMPS global just the same). If you are trying to access this with fileman, it may not be evaluating it the way you think. I'm kind of surprised that the global list utility does not yield the difference in the subsequent nodes. - Original Message - From: Nancy E. Anthracite [EMAIL PROTECTED] To: hardhats-members@lists.sourceforge.net Sent: Sunday, January 30, 2005 12:43 PM Subject: Re: [Hardhats-members] FileMan in Cache Bob Witkop from Intersystems hangs his hat here at times, so he will see this. On Sunday 30 January 2005 02:25 pm, Bob Beckley wrote: If you look at a global listing in the Cache/VMS environment, you'll notice that the global array to the left of the = sign is listed only once. Subsequent entries with the same global array are blank to the left of the = sign, with new data to the right, like so: ^ABC(1,ID)=123^124 =321^421 =534^543 ... This apparently carries over into FileMan reports, like so: Jones, John 12344 Yes Vet 43214 No Vet Both entries are for John Jones, but his name is listed only once. Does anyone know how to make, in this example, John Jones appear on each and every line instead of a blank? I don't know of any print qualifiers that cover this. (Perhaps I should take it up with Intersystems?) Thanks in advance. --- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag--drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl ___ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members --- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag--drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl ___ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members
Re: [Hardhats-members] FileMan in Cache
FM only prints the higher level entry once when printing subfile info. If you want the higher level info printed on each line, you need to specify it to print within the multiple. So in your case, you would hold off on specifying the employee, supervisor info until within the day subfile. For your example (FM might ask some questions which I'm not showing, just to be sure it knows what you want): FIRST PRINT FIELD: PAY PERIOD THEN PRINT FIELD: EMPLOYEE THEN PRINT EMPLOYEE SUB-FIELD: DAY # THEN PRINT DAY # SUB-FIELD: EMPLOYEE;C12;L18 THEN PRINT DAY # SUB-FIELD: APP. SUPERVISOR;C35;L18 THEN PRINT DAY # SUB-FIELD: TIMEKEEPER POSTING;C58;L18 THEN PRINT DAY # SUB-FIELD: THEN PRINT EMPLOYEE SUB-FIELD: THEN PRINT FIELD: Bob Beckley wrote: Greg, we're running Cache/VMS and have no choice (as far as I can figure) regarding consecutive duplicate value suppression. Our global listings automatically (it seems) employ it, and now I've noticed it in a print menu option I just created. I just want to "un-suppress" them. Here's an example: print template: FIRST PRINT FIELD: PAY PERIOD THEN PRINT FIELD: EMPLOYEE THEN PRINT EMPLOYEE SUB-FIELD: EMPLOYEE;C12;L18 THEN PRINT EMPLOYEE SUB-FIELD: APP. SUPERVISOR;C35;L18 THEN PRINT EMPLOYEE SUB-FIELD: DAY # THEN PRINT DAY # SUB-FIELD: TIMEKEEPER POSTING;C58;L18 THEN PRINT DAY # SUB-FIELD: THEN PRINT EMPLOYEE SUB-FIELD: THEN PRINT FIELD: Heading: TIME ATTENDANCE RECORDS LIST Replace ... With TA Check Replace TA Check STORE PRINT LOGIC IN TEMPLATE: ZZBBPRINT1 Are you adding 'ZZBBPRINT1' as a new PRINT TEMPLATE? No// Y (Yes) printout: TA Check JAN 29,2005 21:41 PAGE 1 PAY PERIOD EMPLOYEE APP. SUPERVISOR TIMEKEEPER POSTING 04-06 ,OSCAR L JR These are null matches, which we want. xxx,ALVIN C xx,SANDRA M xx,SANDRA M xx,SANDRA M xx,SANDRA M xx,SANDRA M No suppression employed via the print template. Where's it coming from, then? Weird, huh? Thanks for your time. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Greg Kreis Sent: Sunday, January 30, 2005 7:27 PM To: hardhats-members@lists.sourceforge.net Subject: Re: [Hardhats-members] FileMan in Cache The Cache display of globals that suppresses the subscripts is just a formatting choice. It is just how they chose to present them. It doesn't influence how globals work or how FM works. FM can be made to suppress repeating values in a column through the use of a suffix of ";N" for a field specification in the print template. Look at the print template of the report that you showed here. The fields normally repeat. You have to work to suppress them. Bob Beckley wrote: >If you look at a global listing in the Cache/VMS environment, you'll notice >that the global array to the left of the "=" sign is listed only once. >Subsequent entries with the same global array are blank to the left of the >"=" sign, with "new" data to the right, like so: > >^ABC(1,"ID")=123^124 > =321^421 > =534^543 > ... > >This apparently carries over into FileMan reports, like so: > >Jones, John 12344 Yes Vet > 43214 No Vet > >Both entries are for John Jones, but his name is listed only once. > >Does anyone know how to make, in this example, "John Jones" appear on each >and every line instead of a blank? I don't know of any print qualifiers >that cover this. (Perhaps I should take it up with Intersystems?) Thanks >in advance. > > > > >--- >This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting >Tool for open source databases. Create drag--drop reports. Save time >by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. >Download a FREE copy at http://www.intelliview.com/go/osdn_nl >___ >Hardhats-members mailing list >Hardhats-members@lists.sourceforge.net >https://lists.sourceforge.net/lists/listinfo/hardhats-members > > > -- Greg Kreis http://www.PioneerDataSys.com "You are today where your thoughts have brought you, you will be tomorrow where your thoughts take you." (James Lane Allen) --- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag--drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl ___ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members --- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag--drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at
RE: [Hardhats-members] FileMan in Cache
It is not undocumented (you can always associate a label with a field) and it has nothing to do with Cache. Printing in Fileman is unrelated to the global lister. --- Bob Beckley [EMAIL PROTECTED] wrote: Thank you, Marianne. That did the trick. Is this an undocumented feature of FileMan? I'm looking for it in the manuals, but so far no luck. I'll have to make a special note of it in the margin. Thanks again. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Marianne Susaanti Follingstad Sent: Sunday, January 30, 2005 8:29 PM To: hardhats-members@lists.sourceforge.net Subject: Re: [Hardhats-members] FileMan in Cache FM only prints the higher level entry once when printing subfile info. If you want the higher level info printed on each line, you need to specify it to print within the multiple. So in your case, you would hold off on specifying the employee, supervisor info until within the day subfile. For your example (FM might ask some questions which I'm not showing, just to be sure it knows what you want): FIRST PRINT FIELD: PAY PERIOD THEN PRINT FIELD: EMPLOYEE THEN PRINT EMPLOYEE SUB-FIELD: DAY # THEN PRINT DAY # SUB-FIELD: EMPLOYEE;C12;L18 THEN PRINT DAY # SUB-FIELD: APP. SUPERVISOR;C35;L18 THEN PRINT DAY # SUB-FIELD: TIMEKEEPER POSTING;C58;L18 THEN PRINT DAY # SUB-FIELD: THEN PRINT EMPLOYEE SUB-FIELD: THEN PRINT FIELD: Bob Beckley wrote: Greg, we're running Cache/VMS and have no choice (as far as I can figure) regarding consecutive duplicate value suppression. Our global listings automatically (it seems) employ it, and now I've noticed it in a print menu option I just created. I just want to un-suppress them. Here's an example: print template: FIRST PRINT FIELD: PAY PERIOD THEN PRINT FIELD: EMPLOYEE THEN PRINT EMPLOYEE SUB-FIELD: EMPLOYEE;C12;L18 THEN PRINT EMPLOYEE SUB-FIELD: APP. SUPERVISOR;C35;L18 THEN PRINT EMPLOYEE SUB-FIELD: DAY # THEN PRINT DAY # SUB-FIELD: TIMEKEEPER POSTING;C58;L18 THEN PRINT DAY # SUB-FIELD: THEN PRINT EMPLOYEE SUB-FIELD: THEN PRINT FIELD: Heading: TIME ATTENDANCE RECORDS LIST Replace ... With TA Check Replace TA Check STORE PRINT LOGIC IN TEMPLATE: ZZBBPRINT1 Are you adding 'ZZBBPRINT1' as a new PRINT TEMPLATE? No// Y (Yes) printout: TA Check JAN 29,2005 21:41 PAGE 1 PAY PERIOD EMPLOYEE APP. SUPERVISOR TIMEKEEPER POSTING 04-06 ,OSCAR L JR These are null matches, which we want. xxx,ALVIN Cxx,SANDRA M xx,SANDRA M xx,SANDRA M xx,SANDRA M xx,SANDRA M No suppression employed via the print template. Where's it coming from, then? Weird, huh? Thanks for your time. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Greg Kreis Sent: Sunday, January 30, 2005 7:27 PM To: hardhats-members@lists.sourceforge.net Subject: Re: [Hardhats-members] FileMan in Cache The Cache display of globals that suppresses the subscripts is just a formatting choice. It is just how they chose to present them. It doesn't influence how globals work or how FM works. FM can be made to suppress repeating values in a column through the use of a suffix of ;N for a field specification in the print template. Look at the print template of the report that you showed here. The fields normally repeat. You have to work to suppress them. Bob Beckley wrote: If you look at a global listing in the Cache/VMS environment, you'll notice that the global array to the left of the = sign is listed only once. Subsequent entries with the same global array are blank to the left of the = sign, with new data to the right, like so: ^ABC(1,ID)=123^124 =321^421 =534^543 ... This apparently carries over into FileMan reports, like so: Jones, John 12344 Yes Vet 43214 No Vet Both entries are for John Jones, but his name is listed only once. Does anyone know how to make, in this example, John Jones appear on each and every line instead of a blank? I don't know of any print qualifiers that cover this. (Perhaps I should take it up with Intersystems?) Thanks
[Hardhats-members] Remove Me
Re: [Hardhats-members] FileMan in Cache
The effect you are seeing is because you are printing multiples. The main record's field doesn't repeat so you understand that the multiple fields that print on each line are part of that record. If it repeated, you wouldn't be sure if you had several records, with the same value, and one multiple entry per record or one record with several records in the multiple. Does that make sense? Bob Beckley wrote: Chris, you're right about the validity. I just made up the example on-the-fly. The real problem is that under the Cache/VMS environment, my FileMan report automatically suppresses consecutive duplicate values, which is very weird, since there is a FileMan print qualifier (;N) used to suppress them. I want to "un-suppress" them somehow. Please see my reply to Greg. Thanks. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Chris Richardson Sent: Sunday, January 30, 2005 7:26 PM To: hardhats-members@lists.sourceforge.net Subject: Re: [Hardhats-members] FileMan in Cache Nancy; The global listed does not look like a valid Fileman Global structure, (but it is a fine MUMPS global just the same). If you are trying to access this with fileman, it may not be evaluating it the way you think. I'm kind of surprised that the global list utility does not yield the difference in the subsequent nodes. - Original Message - From: "Nancy E. Anthracite" [EMAIL PROTECTED] To: hardhats-members@lists.sourceforge.net Sent: Sunday, January 30, 2005 12:43 PM Subject: Re: [Hardhats-members] FileMan in Cache Bob Witkop from Intersystems hangs his hat here at times, so he will see this. On Sunday 30 January 2005 02:25 pm, Bob Beckley wrote: If you look at a global listing in the Cache/VMS environment, you'll notice that the global array to the left of the "=" sign is listed only once. Subsequent entries with the same global array are blank to the left of the "=" sign, with "new" data to the right, like so: ^ABC(1,"ID")=123^124 =321^421 =534^543 ... This apparently carries over into FileMan reports, like so: Jones, John 12344 Yes Vet 43214 No Vet Both entries are for John Jones, but his name is listed only once. Does anyone know how to make, in this example, "John Jones" appear on each and every line instead of a blank? I don't know of any print qualifiers that cover this. (Perhaps I should take it up with Intersystems?) Thanks in advance. --- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag--drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl ___ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members --- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag--drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl ___ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members -- Greg Kreis http://www.PioneerDataSys.com "You are today where your thoughts have brought you, you will be tomorrow where your thoughts take you." (James Lane Allen)
RE: [Hardhats-members] VISTA NUMBER OF USERS
Nancy. Given the time differential, you keep some pretty late hours. Thanks for the assistance. Maybe it is that short of jobs killing ZU. Just keep thinking I am missing somethingtx/t -Original Message- From: [EMAIL PROTECTED] [mailto:hardhats- [EMAIL PROTECTED] On Behalf Of Nancy E. Anthracite Sent: Sunday, January 30, 2005 11:05 PM To: hardhats-members@lists.sourceforge.net Subject: Re: [Hardhats-members] VISTA NUMBER OF USERS Have you run afoul of a combination of fixing the number of jobs for #38 on the installation instructions for VistA on Cache on the Hardhats.org site and setting up VistA so there are some jobs left to use for accessing VistA to fix things in case all of the Taskman jobs were used up doing things? We discussed the latter on the list when talking about setting the various parameters for Taskman, RPC Broker, etc, so you might have done that and have forgotten about it. On Sunday 30 January 2005 09:25 pm, Thurman Pedigo wrote: I still have a problem getting the November version of VistA to run As a reminder, from a past post, I have one version of VistA running fine. It is about 1.5 years old. The newer version ZU halts with the message below. Older version works just fine. Cache 5.xxx 25 licensed users: Y=$system.License.LUConsumed() results Y=2. Am I on the wrong track? Advice appreciated. Thanks, thurman OLDER VERSION ROUTINE VISTAZL %ZOSV ZP %ZOSV;SFISC/AC - $View commands for Open M for NT. ;12/04/2001 15:30 ;;8.0;KERNEL;**34,94,107,118,136,215**;Jul 10, 1995 ACTJ() ;# Active jobs N Y,% S %=0 F Y=0:1 S %=$ZJ(%) Q:%= Q Y NEW VERSION ROUTINE VISTCZL %ZOSV ZP %ZOSV;SFISC/AC - $View commands for Open M for NT. ;09/22/2004 11:56 ;;8.0;KERNEL;**34,94,107,118,136,215,293,284**;Jul 10, 1995 ACTJ() ;# Active jobs N %,V,Y S V=$$VERSION() I V5 D Q Y . S %=0 F Y=0:1 S %=$ZJ(%) Q:%= S Y=$system.License.LUConsumed() Q Y = ERROR AND HALT ON ZU: VISTCd ^ZU Volume set: ROU:CACHEMAW UCI: VISTC Device: |TNT|vistasvr:2422|5228 (vistasvr/ 2422) Device: |TNT|vistasvr:2422|5228 Maximum number of users already signed on to this processor. --- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag--drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl ___ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members -- Nancy Anthracite --- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag--drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl ___ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members --- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag--drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl ___ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members
Re: [Hardhats-members] Another problem with mailman due to taskman
Hi Finally I found the culprit. Actually the Taskman was in WAIT state. As soon as I changed the state, all the messages reached their corresponding recipients. Bye Nick --- Nancy E. Anthracite [EMAIL PROTECTED] wrote: My guess it that you didn't have any problems only because you put UCI in all the places that needed UCI and VOL in all of the places that needed VOL. Had you called whatever was in UCI in the VistA you started with, and VOL what was in the VOL, you would have had to have changed it in fewer places. I think the key is always with D GETENV^%ZOSV and then setting all of the parameters correctly with NO TYPOS and all that good stuff the first time around. At the risk of being a broken record, that happens to be broken in the same place as Lloyd's record that broke from all the times he used it to tell me to do this ... VISTAD GETENV^%ZOSV VISTAW Y Which give you in the output in the respective places: UCI^VOL^NODE^BOX:VOLUME This is actually written right into VistA at one of the ?? points, although I don't recall which one. Although I have not done configuration, I sure have had lots of chances to help people with installations, and this is where all of the problems are. Lloyd knows it so well, he can even tell by the error message where the typos are. Now that is what I call experienced! On Saturday 29 January 2005 04:26 pm, Kevin Toppenberg wrote: For what it is worth, it seems that most of the problems that I have hear people talk about on this board in regards to taskman, is a problem with the VOL,UCI etc. issue. Most recommend using the defaults provided by the system, but it seems that this leads poeple to problems. I cleared out all the other entries, and called my UCI UCI, and called my VOL, VOL. It seems like I haven't had the problems that others have... Kevin --- Nick James [EMAIL PROTECTED] wrote: Hi The CPRS problem was due to the change in file access rights. That has been solved. But the Waiting for a partition problem, does not seem to be over yet. Nick --- Kevin Toppenberg [EMAIL PROTECTED] wrote: Nick, Do you have a way to make your server accessible on the internet for someone else to poke around on? I'd be willing to look at it for a couple of minutes if you want to contact me off-board. I'm self taught, so no promises as to whether or not I can get you up. Kevin [EMAIL PROTECTED] --- Nick James [EMAIL PROTECTED] wrote: Hi I was able to overcome the previous problem with the command GO^XMKPLQ and GO^XMTDT, to run the MOVER and TICKLER. But still I was unable to send and receive messages. So I just checked to see the tasks running in TASKMAN, whose screen shot I am giving below : 510: ^LRCAPPH, COLLECT PHLEBOTOMY CAP WORKLOAD. No device. VAH,ROU. From 1/24/2005 at 18:14, By you. Waiting for a partition. --- 511: ^LRCAPBB, COLLECT BLOOD BANK WORKLOAD. No device. VAH,ROU. From 1/24/2005 at 18:14, By you. Waiting for a partition. ... 720: GO^XMTDL, MailMan: Message Delivery Queue 1. No device. ROU,ROU. From Today at 11:49, By you. Waiting for a partition. --- 721: GO^XMTDL, MailMan: Message Delivery Queue 1. No device. ROU,ROU. From Today at 11:50, By you. Waiting for a partition. --- 722: GO^XMTDL, MailMan: Message Delivery Queue 1. No device. ROU,ROU. From Today at 11:51, By you. Waiting for a partition. .. === message truncated === __ Do you Yahoo!? Yahoo! Mail - Helps protect you from nasty viruses. http://promotions.yahoo.com/new_mail --- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag--drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl ___ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members
