Hi Victor,
The "U8;;D" format is someone redundant when it comes to files being created in DP, as all of its files will be created in the same case irrespective of the case in the RV. This is not a feature of DP but rather of the DOS operating system, With MS-DOS all fiels are converted to Uppercase, but other DOS operating system might use or be capable of using lowercase filenames (My web apps are on a Linux webserver with DOSEMU and FreeDOS, and it creates all its DOS files as lowercase) If your web server is using a Windows operating system, you can have the href link in lower, upper or mixed case as Windows treats the file TEST.HTM as being the same as Test.htm, however if you are using a Unix or Linux based webserver then the previous example would be two different files, so you would have to match the case in the href to be the same as the output from DP. Regards Brian _____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Victor Warner Sent: Tuesday, 21 October 2008 8:07 PM To: Dataperfect Users Discussion Group Subject: Re: [Dataperf] Reports query - sending each record toa differentfilename. This post is a follow up to this post and in particular the following: "cat.t[apply.format["U8;;D";<CategoryField>];".QQQ"]" I understand that U8 makes the resulting name in upper case. However, what I would like to happen is that the the 8 character filename (and the 8 characters are also used to generate <a href=" "> links as well) are all in lower case. Using A8 reproduces the case of the text in the appropriate field. EG if the field contains "Cycling" then that is what is produced with the apply.format. I have looked in the DP reference manual and in Mastering DataPerfect, but I cannot see a way of forcing the output all into lower case (as U8 forces the output into uppercase). Is this possible in DataPerfect? Help with this would be gratefully received. Victor Warner. Brian Hancock wrote: Hi Victor, How many records in the data and how many categories in the lookup? If there are not many data records (ie less than say 200 more than that gets tedious pressing Y to continue) then this is very simple, and doesn't require you to have set up any special indexes or to understand linking or virtual links in reports. I am also assuming that your category names are less than 8 characters long, or alternatively the first 8 characters are unique (ie you would have to do something if these were tow of the categories : "Australian Mammals", "Australian Marsupials"). Additionally my formula assumes that the category names do not include characters that would be invalid in the filename, eg ".,$&?/\" etc, (in which case you would need to create a formula to strip those characters 1. Create a report based on your data panel a. Open data panel (ie your first panel) b. Shift F7 - Built In Short Reports - Insert c. Press 8 (Edit report form) 2. Go to the Report Body 3. Create an RV and store the following: (this will strip spaces but not other invalid character, the QQQ is the extension I have given, but you can use your own, being careful that your naming can't clobber an existing file, cat.t[apply.format["U8;;D";<CategoryField>];".QQQ"] a. Replace <CategoryField> with F4 selection of the field 4. Immedately after the RV CTRL-F7, 1 (Select report Field), C (open Filename in RV" and select the RV that you assigned the previous formula to 5. Add the output fields to the report, if is it a comma separated file add a "," between each field and use the ;;B print indicator to remove leading and trailing blanks from your data 6. Exit the report editor, change 7. Print Margins to 0,0,0,0 otherwise you might get strange errors caused in the program using the output files (cause by page breaks) which can really spoil a nice day 7. Shift F7 to run the Report 8. At each Overwrite prompt press Y, and hope that you do not have too many, and continue until the report finishes. You will get a series of new files named with your category headings (well at least the first 8 characters. If the first 8 characters of the category are not unique, then you will accumulate the matching categories into one file. If you have invalid characters in the filename you will get errors running the report. If you run the report a second time you should delete the files previously created as the report above will append data to those files. The two-level report, or basing it on your category panel will be a better solution, but for a two level report you might have to play around with indexes to ensure that your first panel has an index based on the category index as the first element of a composite field index. In either case the issue of getting a valid unique filename will still be the same. Regards Brian -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Victor Warner Sent: Tuesday, 7 October 2008 9:41 AM To: Dataperfect Users Discussion Group Subject: Re: [Dataperf] Reports query - sending each record to a differentfilename. Don and Brian, Thank you both for the responses. Beyond a certain point (and what you describe is way beyond that point!) I do not have the knowledge to implement what is suggested. Would it be possible to have a few pointers on the mechanics of implementing one of the suggestions? Victor Warner. Brian Hancock wrote: Hi Victor, Don's suggestion sounds fine. Personally I have never been a fan of the two-level report, no specific reason just haven't found reason to use it much. I would base my report on the lookup panel, and in the report body of this panel store the required filename into an RV, depending on whether you want empty files for empty categories, or files only records exist for that category you would place an Open Filename in RV in the report body, of the Category Panel or in the FirstPage header of a Linked or Virtually Linked Panel to your second panel where the data is, and then output the data. You might need to turn file on and file off, to make sure you do not get appends, or prompts to overwrite. As yet an even third choice might be to let records append by basing the report solely on the second panel, without even using a Two-Level report. Just open the filename in RV changing it for the character heading for each report. Unless you use a Turn File Off the data is appended to the existing file. A big disadvantage of this however is that you will be asked whether you want to overwrite the existing record which you would have to answer yes to at each record which reopened an existing file, however for a a report with just a couple of hundred records is a nice quick and dirty method, which allows you to view records one by one as they are written Regards Brian -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Victor Warner Sent: Monday, 6 October 2008 10:58 PM To: [email protected] Subject: [Dataperf] Reports query - sending each record to a different filename. I would like whether the following is possible in DataPerfect: 1. There is a (first) panel where one field in each record acts as a category (which is obtained by a data link from a second panel). 2. In the first panel there be several records each having the same category heading. 3. I would to produce a report where all the records sharing the same category heading are sent to a file, then the report proceeds to the next category heading and sends all the records under that second category heading to a second file. (I can do this where the records are sorted and sent to the same file name.) Is this possible to run one report and that the files are automatically created or do I need to do separate reports? Help with this would be gratefully received. Regards Victor Warner. _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
