MCrawford: If you want to turn the temporary work-around into a production macro, you can edit the macro's .arq file with any text editor that honors unix & windows CRLFs. Just replace the path recorded in the macro with a prompt, such as $Path_for_Report$, and replace the file name with $Report_File_Name$. Your prompts might have to be named pretty explicitly, depending on your user community (especially regarding including/excluding trailing (back)slashes in path names). HTH, --Phil PS: Who says ARS 3.x skills are useless? :-^
----- Original Message ---- From: MCrawford <[EMAIL PROTECTED]> To: [email protected] Sent: Thursday, June 5, 2008 9:25:45 AM Subject: Re: ARS 7.1 Macro Recording and Reporting Oddity I turned on Macro logging and it show no obvious errors. It says that the amount of results returned was 98, but again when I hit F5 or try to run a report it only displays ~15 results. I turned on Macro and Active Link logging, ran the macro and then hit F5 to change the results and the log is several pages long. It will take some time to go through this to see exactly what is happening. Misi - I recorded a Macro exactly as you instructed and it worked just fine, however I need my customers to be able to name and place the file exported wherever they want. This is a great temporary work around, thank you very much. It appears that this error is only present when creating a macro to display results. Any actions taken on the displayed results causes the query to reset or change somehow. I don't have access to our SQL server and our Sys Engineer is out today, so I can't watch SQL just yet. Thank you both, MCrawford On Jun 5, 3:17 am, Misi Mladoniczky <[EMAIL PROTECTED]> wrote: > Hi, > > Try turning on all kinds of logging on the client to see what happens. > > Maybe you have som active link that modifies the search criteria? > > When I do something like this, I typically do it in a single step. > > 1. Open form in search mode and press cntrl-e to clear everything > 2. Fill in your query in the advanced search > 3. Turn on macro recording > 4. Choose Tools -> Reporting > 5. Choose/define your report layout > 6. Report -> Export -> To File > 7. Save your macro > > I do not know if this will help you... > > Best Regards - Misi, RRR AB,http://www.rrr.se > > Products from RRR Scandinavia: > * RRR|License - Not enough Remedy licenses? Save money by optimizing. > * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. > * RRR|Translator - Manage and automate your language translations. > Find these products, and many free tools and utilities, athttp://rrr.se. > > > > > > > Greetings, > > > I have run across something rather strange in regards to recording > > macros and exporting the data returned to csv. When I record a macro > > for an incident query/search it returns the correct results, however > > when I export the data to .csv it is only exporting a fraction of the > > items shown in the results window. Furthermore, when I run these > > macros as said before the correct results are returned, but when I > > press F5 to refresh the results it shows those 'fractions of the > > results' that are being reported. It's difficult to explain, but I > > will walk you through my process. > > > To create these macros I do the following: > > 1. Open Incident in Search mode. > > 2. Click the macro record button. > > 3. Click 'Advanced' button to display advanced search bar. > > 4. Paste a query into the Advanced search bar: 'Submit Date' > ( $DATE > > $ - ( 60 * 60 * 24 * 1 ) ) AND 'Status*' < "Resolved" AND > > '260000001' = "NYA" > > > 5. Click the 'Search' Button and the results appear (in this example ~ > > 125 results) > > 6. Click the macro save button, and name the macro. > > > To run the Macro: > > 1. Click the macro name from the drop down list. > > > This displays the same ~125 results. However, when I select all 125 > > items, and export the items to a .csv file it only shows ~15 results. > > I go back to the macro results and run them again, same ~125 results. > > This time I hit the F5 key and the results drop down to ~15. This is > > very very strange. > > > I tried the query manually, and it returns ~125 results. Then I hit > > F5 and the results stay the same, and I can report on the entire > > list. What am I doing wrong? I can create a video of this if needed. > > > _______________________________________________________________________________ > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are" > > > -- > > This message was scanned by ESVA and is believed to be clean. > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are"- Hide > quoted text - > > - Show quoted text - _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
