Table of Contents

 

Ad Hoc Reports Help File Definition Help Report Definition Help
Archive Help File Name Help Report format Help
Backup Help FTP Help Repository Help
Browser Help INB (Internet-native Banner) Help Restore Help
CD Help Incoming Help Security Help
Conversion Help Junk pages Help Server Help
Copy Help Login Help Sort Help
CSV Help Logo Help Temporary File Help
Date Help Missing Report Help Time Help
Demo Help Page break Help Usage Help
Download Help Page Key Help User group Help
e-Mail Help Parser Help User ID Help
Error Message Help Print Help View Help
Recover Help Year-end Help


ePrint FAQ Topics

Ad Hoc Reports Help
  1. I was asked about posting non-Ellucian reports to ePrint. Wouldn't this be a nightmare, since headings and page breaks wouldn't be the same? I fear that we may open up a can of worms and get stuck rewriting everybody's reports so they look good in ePrint. Any advice?
Archive Help
  1. Currently my ePrint server does not have a CD burner. Can I archive to a file locally and then FTP that file to one of my servers with a CD burner?
  2. If you cannot fit your selected reports on one CD, do you have to reduce your data, or will the system prompt you to enter in a second CD?
Backup Help
  1. We are about to go live with ePrint and our network folks have requested information about what files/directories on the server need to be backed up (in addition to the whole server) in order to facilitate a data recovery, if required. Can you provide us with this information, please?
  2. One of my repositories was inadvertently deleted. Can I selectively restore from the backup tape (that thankfully is not backed up every night)? And if so, are there instructions for doing this?
Browser Help
  1. Our Provost is having a problem viewing a .pdf file in ePrint, regardless of who logs in. The system will let you initially log in and go to the listing of viewable reports, but once you click the pdf icon it kicks you out to the login screen. He can view other pdf files in other applications. Can you suggest anything for us to check?
  2. Is there a reason we keep getting the error 'Warning - Page Expired'? I notice it when I've been in the reports and I either have to click refresh or keep clicking the back arrow.
  3. I have received the following messages from two users. What is the problem?
    /home/eprint/cgi-bin/../prod/repository/finance/config/.xml not found, not readable, or not writable at /home/eprint/cgi-bin/../code/Pinnacle/UIGetreport.pm line 684.Dept: Student Fin. Planning
  4. I was wondering is there a way to open more than one screen and compare the reports from different repository at the same time?
  5. When a person is in a report in ePrint and they click the back button, they get: Page has expired. If they click the back button again, it goes back to the ePrint menu. Any suggestions? Should they reload Adobe Acrobat Reader? It works fine for me.
  6. Our Apple users are using SAFARI to access ePrint because of a problem with Internet Explorer. To you know of any compatibility or encryption problems using this browser? Should it work with the 128-bit encryption?
  7. I'm having a problem setting up a report using the CSV setting. I create the definition for the report in CSV, but when I go to Stored Reports and click Data, it shows up in a text document. Ive checked my settings and they seem to be the same as the values that work in other repositories. Any pointers?
  8. We have outsourced some things to companies who have certain access to our system and have access to ePrint for their reports. The reports I speak of are CSV'd for them in order for them to save to an Excel spreadsheet and send to their corporate office. If I log in and click DATA, these reports automatically ask me if I want to save them as an Excel spreadsheet. In their case if they click DATA it never asks them if they want to save it, but it immediately pulls the report up and it is one big mass of information. I have discovered if you right click the drill, ePrint will prompt you for what you want to do. At this point, if a save target as is done and the document saved as an Excel Worksheet, then the document will appear as an Excel spreadsheet. In other words, anytime they want to run and view a CSV document, they must download it to their hard drive. Is there a way around this? I have examined their version of Excel (which is the same as mine). I have also performed an Explore (right click Start, Explore, Tools, File Types) and viewed how their CSV is set up. Everything is set exactly as on my computer, therefore I do not feel that is the problem. Any help I could receive on this matter would be greatly appreciated.
  9. I have Banner documentation in pdf format that I want to FTP to ePrint and make available to users. These pdf files are on my hard drive. Is it possible to FTP them to ePrint through my PC?
  10. We are experiencing a repetitive problem. When users try to download a report, it brings up the login screen instead of the data.
  11. I am getting the following message: "File does not begin with '%pdf-" when trying to access the report from E-mail URL.
  12. Were having a problem retrieving FRRGRNT reports in our ePrint repository. As an administrator there is no problem, but as a user it seems to hang indefinitely and never retrieves the pdf format. The text portion comes back successfully. I have even turned off VBS and it continues to be a problem.
  13. An end-user with Windows and Internet Explorer said she has been getting this message since last week whenever she tries to log in. The user account seems to be okay. /home/eprint/cgi-bin/../prod/repository/frs/config/.xml not found, not readable, or not writable at /home/eprint/cgi-bin/../code/Pinnacle/UIGetreport.pm line 684.
  14. Does ePrint support Mac users? If so, which Mac OS and which browsers?
CD Help
  1. Currently my ePrint server does not have a CD burner. Can I archive to a file locally and then FTP that file to one of my servers with a CD burner?
  2. If you cannot fit your selected reports on one CD, do you have to reduce your data, or will the system prompt you to enter in a second CD?
Conversion Help
  1. We are beginning to look more seriously at the time frame we would need for getting ePrint ready for Banner and Banner ready for e-Print. Some HR/Payroll conversion reports should be ready to run shortly and the desire is to start out on ePrint from the get go. There is still a lot of discussion here about who will do what as far as the security side of the Banner so things are not quite ready. But my question then, is what kind of time frame should we be looking at for the configuration on Banner/ePrint to make this a reality?
Copy Help
  1. Our users requested that we create separate repositories for different fiscal years. The reports will be much the same except the next fiscal year reports will have an extension of the new year attached. I would like to copy all report definition templates from one repository to another that will be using the same reports, then modify the report definition for the new year.
  2. A user has requested that reports from one repository be put into another repository. I know I can copy the report definition to the new repository, but is there a method to copy over the actual reports? The files that were used to FTP to ePrint are no longer available (to be parsed). There are a lot of reports that they want copied to the new repository.
  3. Would it be possible to generate an input file for the ePrint parser to be used in a new repository from an existing ePrint report in the original repository? That would resolve the complexity of managing the databases.
  4. I received a request to copy over 3 files to the ePrint server. I have copied over the fgrbdsc and one of the fgrodta files the user created. I am trying to copy over the third file, which is another fgrodta file only much larger. I don't have an error in the Report Incoming Error, but I can see the fgrodta.lis and fgrodta.done files in the Reports Incoming. Can you explain to me what is wrong with this report?
CSV Help
  1. With the identical report, I get an error message when I use a Banner repository but not when I use the MVS repository. Here is my scenario:

    I created a new repository and named it findevl, which is a Banner finance repository. I then copied the report definitions from the mvstest repository. I FTP'd the reports to the new repository and they were loaded correctly from what I can see, but the "DATA" portion did not appear as it does on the original mvstest repository. Shouldn't both repositories show the same information?
    The incoming log stated the following:

    FINDEVL: Starting Parser: FRSP0921
    FINDEVL: Could not get lock on repository: FINDEVL
    FINDEVL: Could not get lock on repository: FINDEVL
    FINDEVL: Parser successful.
    FINDEVL: Starting Parser: FRSP0922
    FINDEVL: Could not get lock on repository: FINDEVL
    FINDEVL: Could not get lock on repository: FINDEVL>
    FINDEVL: Parser successful.
    FINDEVL: Starting Parser: FRSP0922
    FINDEVL: Parser successful.
  2. I'm trying to set up the CSV on a report and it fails to load the whole report into Excel. It stops at line 65,536. We will be adding VBS to this report, but if anyone has access to the whole report they wouldn't be able to view the entire report in Excel. Is there a way around this problem?
  3. We used FOCUS to create a report in comma-delimited format. We created an application in ePrint that works fine and displays the DATA icon, but the system continues to display the TEXT and pdf icons as well. Of course, there is no pdf version and if you try, Adobe shows garbage. Did we do something wrong, or does ePrint require a report version regardless?
  4. Our ePrint reports currently give users view options of a text file or a pdf file. How do I create an ePrint report that also has the view option of a data file?
  5. I'm having a problem setting up a report using the CSV setting. I create the definition for the report in CSV, but when I go to Stored Reports and click Data, it shows up in a text document. I've checked my settings and they seem to be the same as the values that work in other repositories. Any pointers?
  6. We have outsourced some things to companies who have certain access to our system and have access to ePrint for their reports. The reports I speak of are CSV'd for them in order for them to save to an Excel spreadsheet and send to their corporate office. If I log in and click DATA, these reports automatically ask me if I want to save them as an Excel spreadsheet. In their case if they click DATA it never asks them if they want to save it, but it immediately pulls the report up and it is one big mass of information. I have discovered if you right click the drill, ePrint will prompt you for what you want to do. At this point, if a 'save target as' is done and the document saved as an Excel Worksheet, then the document will appear as an Excel spreadsheet. In other words, anytime they want to run and view a CSV'd document, they must download it to their hard drive. Is there a way around this? I have examined their version of Excel (which is the same as mine). I have also performed an Explore (right click Start, Explore, Tools, File Types) and viewed how their CSV is set up. Everything is set exactly as on my computer, therefore I do not feel that is the problem. Any help I could receive on this matter would be greatly appreciated.
Date Help
  1. I sent a report to ePrint that had been previously defined and stored. I got a log that says everything is fine, yet this report is not being stored where the other reports have been stored. I checked the parser, the error section, and can find no problems. The report is identical to past runs, but it simply dropped out of sight! I have looked at the report and ePrint definition and can see no errors. Nor has anyone changed this report or its definition since it was run last. Any suggestions?
  2. In our SIS repository report RBA121publ4 seems to have a date way in the future. We have attempted to reload this report but it still gives the wrong date. Can you fix this?
  3. We have set up some reports to use the SYSTEM date and time when the report is processed on the ePrint server. The time is not accurate when we follow this procedure. Can we adjust the time on the ePrint server, and if so, how?
Demo Help
  1. Is there a good reason to keep the ePrint Demo Repository? We are beginning to roll ePrint campus wide. Folks are seeing the Demo Repository and thinking it is a demo they need to go through before using ePrint.
Download Help
  1. We are experiencing a repetitive problem. When users try to download a report, it brings up the login screen instead of the data.
e-Mail Help
  1. If I have a report in ePrint that is defined with both department level Value Based Security and with e-mail notification of a new report occurrence, will e-mail notifications be sent to all users who can view the report? Or will notifications only be sent to those users who have are able to view pages within the report?
  2. We have just added e-mail notifications to a couple of our reports on ePrint. We want to send a notification to about 110 people on one report. Our campus limits the number of e-mails it will allow at one time to 100. I have entered the e-mail addresses in several records. My question is, will ePrint send a separate e-mail for each record or will it lump them all together to send one e-mail to all 110 at one time?
  3. I thought if you entered a user with an e-mail address and he was assigned to a repository to which a report was sent, that he would automatically get notification of that report or any other reports sent to that repository. Do you have to change anything in the report definitions?
  4. Our problem seems to be maintaining the user's e-mail address. This value is not fed as part of the security update, yet if the security update is run in Batch mode the update wipes out this field. This makes it impossible to do e-mail notification by User Group. Doing e-mail notification by e-mail address on the report definition is prohibitive due to the effort involved. Are there other ePrint clients who use e-mail notification? How are they maintaining the e-mail address?
  5. Is there a limit on how many e-mail notifications you can send out? I can't really test this, so I thought I would ask. We have close to 2000 e-mail notifications we will be sending out with a particular report.
  6. I have e-mails for reports that failed to parse on 9/13/04. When I go to the Report Parser for this week it starts with 9/14/2004, last week's ends with 9/11/04. Where are the log entries for 9/13/04?
Error Message Help
  1. I get the following message in the Incoming log and reports are in Reports Incoming. Please help!

    SCH: Could not get lock on repository: SCH
  2. Is there a reason we keep getting the error 'Warning - Page Expired'? I notice it when I've been in the reports and I either have to click refresh or keep clicking the back arrow.
  3. I have received the following messages from two users. What is the problem?

    /home/eprint/cgi-bin/../prod/repository/finance/config/.xml not found, not readable, or not writable at /home/eprint/cgi-bin/../code/Pinnacle/UIGetreport.pm line 684.Dept: Student Fin. Planning
  4. When a person is in a report in ePrint and they click the back button, they get: "Page has expired." If they click the back button again, it goes back to the ePrint menu. Any suggestions? Should they reload Adobe Acrobat Reader? It works fine for me.
  5. This report has parsed fine about a dozen times but today it has failed. I have checked the report on the mainframe against the report definition and cannot see anything wrong. The log message is: "Thu May 20 08:41:02 2004 parse.pl: Exiting, reached end of file while skipping pages in REPORT1."
  6. A report from Banner, FABCHKR, in the fin_devl repository cannot be parsed. The error we get is:

    parse.pl: Reached end of page, verify string not found: Report: FABCHKR; Looking for: 'FABCHKR'

    We tried changing the column and the row, but that did not work. Any ideas? Should we just give up and delete this report from the error queue?
  7. I had two people call with the following error:

    "There are no pages for you to view on this report. If you think this is an error, contact your ePrint administrator. Otherwise, return to ePrint and select another report."
  8. Our payroll repository administrator sees this message repeatedly in the Report Parser log:

    Tue Jul 6 14:00:26 2004 parse.pl: Warning: Unable to remove sortkey file
    Tue Jul 6 14:00:27 2004 parse.pl: Successful parse of report REPT246

    He notes that he always gets the message and it does not seem to interfere with the report creation. He adds that his indexing, based on the department number, is not working but he thinks that is due to an error in the way he has it set up. The sortkey error is in the online list of report parser log messages.
  9. I noticed this in the log this morning

    Sat Aug 28 12:01:00 2004 parse.pl: Warning: page too long on 1 pages for report BBD120.
    Sat Aug 28 12:01:00 2004 parse.pl: Successful parse of report BBD120

    Is there any way to determine which page this occurred on other than a manual comparison?
  10. We use ePrint in our automated nightly process. Last night a file was sent to ePrint but ePrint did not parse it. I checked the INCOMING log and we did have an error when the file was being parsed. I need to know what caused the error so we can prevent it. Here is the portion of the INCOMING log with the error:

    Fri Sep 10 01:10:05 2004 PRODUCTION: Starting Parser: bbd120
    Fri Sep 10 01:11:01 2004 PRODUCTION: Could not get lock on repository: PRODUCTION
    Fri Sep 10 01:12:00 2004 PRODUCTION: Could not get lock on repository: PRODUCTION
    Fri Sep 10 01:13:01 2004 PRODUCTION: Could not get lock on repository: PRODUCTION
    Fri Sep 10 01:13:30 2004 PRODUCTION: Parser successful.
  11. With the identical report, I get an error message when I use a Banner repository but not when I use the MVS repository. Here is my scenario: I created a new repository and named it findevl, which is a Banner finance repository. I then copied the report definitions from the mvstest repository. I FTP'd the reports to the new repository and they were loaded correctly from what I can see, but the "DATA" portion did not appear as it does on the original mvstest repository. Shouldn't both repositories show the same information?

    The incoming log stated the following:

    FINDEVL: Starting Parser: FRSP0921
    FINDEVL: Could not get lock on repository: FINDEVL
    FINDEVL: Could not get lock on repository: FINDEVL
    FINDEVL: Parser successful.
    FINDEVL: Starting Parser: FRSP0922
    FINDEVL: Could not get lock on repository: FINDEVL
    FINDEVL: Could not get lock on repository: FINDEVL
    FINDEVL: Parser successful.
    FINDEVL: Starting Parser: FRSP0922
    FINDEVL: Parser successful.
  12. Can someone tell me what the parser message, "Unable to remove sortkey file" means? I get the message, "Successful parse of report fgrctrl" after the warning message.
  13. A report was created last night, but had not been defined. After the report was defined this morning, the system tried to parse the report. We got this error:

    6 09:33:01 2004 SIS: Starting Parser: bc220044
    6 09:34:02 2004 SIS: Could not get lock on repository: SIS
    6 09:35:02 2004 SIS: Could not get lock on repository: SIS
    6 09:36:01 2004 SIS: Could not get lock on repository: SIS

    The parse has not ended and we continue to get these error messages.
  14. I have encountered an error when sending the security file to ePrint:

    220 eprint.ncarts.edu FTP server (Version wu-2.6.1-20) ready.
    Connected to 192.154.33.232.
    331 Password required for frss.
    230 User frss logged in. Access restrictions apply.
    200 PORT command successful.
    553 zwoffl: Permission denied on server. (Overwrite)
    221-You have transferred 0 bytes in 0 files.
    221-Total traffic for this session was 389 bytes in 0 transfers.
    221 Thank you for using the FTP service on eprint.ncarts.edu.

    Since this file is failing, I have not tried to send the FWOAFL file. In referencing a past event, you suggested deleting and re-defining a file that returned this "permission" type error. Are there any implications with re-defining the ZWOFFL or FWOAFL files? Is this even possible, since it is an FRSS user file?
  15. We are having trouble transferring the FWOAFL and the accompanying VBS.DONE file to our ePrint server. The ePrint parser is not processing the files. Here is the error we receive:

    securityload.pl: Unable to open input file FWOAFL, No such file or directory
  16. I am getting the following message:

    "File does not begin with '%pdf-" when trying to access the report from E-mail URL.
  17. We have transferred the FRS A/P User's Guide to our Programmer's repository. ePrint processed the file for us, but when we try to look at the pdf we get the following message:

    "Object label badly formatted"

    Is there something we did to the file as we FTP'd it?
  18. An end-user with Windows and Internet Explorer said she has been getting this message since last week whenever she tries to log in. The user account seems to be okay.

    /home/eprint/cgi-bin/../prod/repository/frs/config/.xml not found, not readable, or not writable at
    /home/eprint/cgi-bin/../code/Pinnacle/UIGetreport.pm line 684.
File Definition Help
  1. I sent a report to my test repository, after which I created the report definition. The definition appears to be proper and the report name appears to be correct in the incoming area; however, the report parser does not appear to be trying to parse the report. Any suggestions?
  2. Can someone tell me what the parser message, "Unable to remove sortkey file" means? I get the message, "Successful parse of report fgrctrl" after the warning message.
  3. We have several non-Banner report definitions with 15-character names. Is there a limit on the length of report definition name? It seems that the report definition is limited to the length of the Create New File name box. Is this right?
  4. How do I get a pdf file into ePrint?
  5. Our Finance person is for the first time starting to enter ePrint report objects into GSASECR form. An example of our report names is "fn04_telecomm." Our entry person believes he can only enter an 8-character code for new object name, for example, a.Banner encumbrance report is FGROPNE.
File Name Help
  1. Are file names case sensitive?
  2. Do all report files go to the "incoming" folder first, even if a report definition does not exist for the file? If so, do they remain there indefinitely awaiting the creation of a definition?
  3. In FTPing a report to ePrint, the report did not parse on the ePrint server. Is it because the file name is different from the report definition?
  4. I received a request to copy over 3 files to the ePrint server. I have copied over the fgrbdsc and one of the fgrodta files the user created. I am trying to copy over the third file, which is another fgrodta file only much larger. I don't have an error in the Report Incoming Error, but I can see the fgrodta.lis and fgrodta.done files in the Reports Incoming. Can you explain to me what is wrong with this report?
  5. Some folks want to enhance our current reports. Here are some of the questions that have been raised:

    Within the ePrint interface they would like to change from using the report identifier name in the report column, e.g., fgrbdsc, and call it Finance - Budget Status. The manual states that there should be no spaces and the admin interface states that this field is optional. I changed the report label and the change worked. What are the restrictions for using no spaces and how many characters are allowed?

    How many characters are allowed for the report description field?
  6. I sent files named 'sisuser' and 'sisunit' to ePrint and used the same names in the security VBS setup. It looks like ePrint expects to see a file with a different name. Here's my error message:

    Cannot open file '/home/eprint/cgi-bin/../prod/repository/test/security/user.vbs': No such file or directory

    Also, I have two new VBS security files sitting in the Security Incoming Directory and they aren't moving. Can you tell me why they are still sitting there, and why the first one shows no data when there are five lines.
  7. How do I get a pdf file into ePrint?
  8. Our Finance person is for the first time starting to enter ePrint report objects into GSASECR form. An example of our report names is "fn04_telecomm." Our entry person believes he can only enter an 8-character code for new object name, for example, a.Banner encumbrance report is FGROPNE.
FTP Help
  1. Once I create the report definition and FTP it to ePrint without assigning it to a particular group it automatically defaults to the USERS group, which could pose a problem keeping information confidential.
  2. Currently my ePrint server does not have a CD burner. Can I archive to a file locally and then FTP that file to one of my servers with a CD burner?
  3. In FTPing a report to ePrint, the report did not parse on the ePrint server. Is it because the file name is different from the report definition?
  4. With the identical report, I get an error message when I use a Banner repository but not when I use the MVS repository. Here is my scenario: I created a new repository and named it findevl, which is a Banner finance repository. I then copied the report definitions from the mvstest repository. I FTP'd the reports to the new repository and they were loaded correctly from what I can see, but the "DATA" portion did not appear as it does on the original mvstest repository. Shouldn't both repositories show the same information?

    The incoming log stated the following:

    FINDEVL: Starting Parser: FRSP0921
    FINDEVL: Could not get lock on repository: FINDEVL
    FINDEVL: Could not get lock on repository: FINDEVL
    FINDEVL: Parser successful.
    FINDEVL: Starting Parser: FRSP0922
    FINDEVL: Could not get lock on repository: FINDEVL
    FINDEVL: Could not get lock on repository: FINDEVL
    FINDEVL: Parser successful.
    FINDEVL: Starting Parser: FRSP0922
    FINDEVL: Parser successful.
  5. I am attempting to FTP a pdf file from my PC to ePrint. I have Ftp'd the pdf file to Test-SIS repository along with a .done file. I had created a report definition for this with the new pdf as input. The file is still sitting in the report incoming directory. What have I setup wrong? The reports are called das.pdf and das.done. My report definition is das. (These are just practice files.)
  6. One of our users is going through a process whereby she uses multiple Internet Native Banner forms (~5), one after the other. Each Form creates an ePrint defined report which is then sent to a Banner printer defined for the ePrint repository. Only the first and the last of the reports show up in the ePrint repository. Any idea what is causing this?
  7. I created a pdf file and set it up in ePrint, which I really like. Can I FTP the pdf from my desktop to the ePrint server? I copied the pdf to my UNIX account on our database and put it on the ePrint server using FTP. It worked, but this seems like a lot to get a pdf file to the ePrint server.
  8. Is it possible to have multiple FTP users for one repository?
  9. I am trying to route an output report file from a foreign MVS system to my ePrint server via FTP. Security will not allow me access to my ePrint server to pass the information. Any suggestions?
  10. A report was created last night, but had not been defined. After the report was defined this morning, the system tried to parse the report. We got this error:

    6 09:33:01 2004 SIS: Starting Parser: bc220044
    6 09:34:02 2004 SIS: Could not get lock on repository: SIS
    6 09:35:02 2004 SIS: Could not get lock on repository: SIS
    6 09:36:01 2004 SIS: Could not get lock on repository: SIS

    The parse has not ended and we continue to get these error messages.
  11. What software is normally used to FTP to ePrint and where do you specify the repository and report definition? When sending a pdf file to ePrint, you can use FTP (or SFTP) software. Whether you use FTP or SFTP software, the repository is determined by the FTP ID/password used in the FTP process, and the report definition is determined by the file name sent to ePrint.
  12. I have encountered an error when sending the security file to ePrint:

    220 eprint.nnn.edu FTP server (Version wu-2.6.1-20) ready.
    Connected to 192.154.33.232.
    331 Password required for frss.
    230 User frss logged in. Access restrictions apply.
    200 PORT command successful.
    553 zwoffl: Permission denied on server. (Overwrite)
    221-You have transferred 0 bytes in 0 files.
    221-Total traffic for this session was 389 bytes in 0 transfers.
    221 Thank you for using the FTP service on eprint.nnn.edu.

    Since this file is failing, I have not tried to send the FWOAFL file. In referencing a past event, you suggested deleting and re-defining a file that returned this "permission" type error. Are there any implications with re-defining the ZWOFFL or FWOAFL files? Is this even possible, since it is an FRSS user file?
  13. I have Banner documentation in pdf format that I want to FTP to ePrint and make available to users. These pdf files are on my hard drive. Is it possible to FTP them to ePrint through my PC?
INB (Internet-native Banner) Help
  1. Does a user have to be set up as an INB user to have ePrint do report authorization to ensure only specific reports are seen? We had been planning on just setting users as SSB (Self-Service Banner.)
Incoming Help
  1. Do all report files go to the "incoming" folder first, even if a report definition does not exist for the file? If so, do they remain there indefinitely awaiting the creation of a definition?
  2. We use ePrint in our automated nightly process. Last night a file was sent to ePrint but ePrint did not parse it. I checked the INCOMING log and we did have an error when the file was being parsed. I need to know what caused the error so we can prevent it. Here is the portion of the INCOMING log with the error:

    Fri Sep 10 01:10:05 2004 PRODUCTION: Starting Parser: bbd120
    Fri Sep 10 01:11:01 2004 PRODUCTION: Could not get lock on repository: PRODUCTION
    Fri Sep 10 01:12:00 2004 PRODUCTION: Could not get lock on repository: PRODUCTION
    Fri Sep 10 01:13:01 2004 PRODUCTION: Could not get lock on repository: PRODUCTION
    Fri Sep 10 01:13:30 2004 PRODUCTION: Parser successful.
  3. I sent a report to my test repository, after which I created the report definition. The definition appears to be proper and the report name appears to be correct in the incoming area; however, the report parser does not appear to be trying to parse the report. Any suggestions?
  4. I received a request to copy over 3 files to the ePrint server. I have copied over the fgrbdsc and one of the fgrodta files the user created. I am trying to copy over the third file, which is another fgrodta file only much larger. I don't have an error in the Report Incoming Error, but I can see the fgrodta.lis and fgrodta.done files in the Reports Incoming. Can you explain to me what is wrong with this report?
  5. I am attempting to FTP a pdf file from my PC to ePrint. I have Ftp'd the pdf file to Test-SIS repository along with a .done file. I had created a report definition for this with the new pdf as input. The file is still sitting in the report incoming directory. What have I setup wrong? The reports are called das.pdf and das.done. My report definition is das. (These are just practice files.)
  6. I sent a report to my test repository, after which I created the report definition. The definition appears to be proper and the report name appears to be correct in the incoming area; however, the report parser does not appear to be trying to parse the report. Any suggestions?
Junk Pages Help
  1. This report has parsed fine about a dozen times but today it has failed. I have checked the report on the mainframe against the report definition and cannot see anything wrong. The log message is: "Thu May 20 08:41:02 2004 parse.pl: Exiting, reached end of file while skipping pages in REPORT1."
    This would lead me to believe that we have a problem with the pages we are skipping (1-3). I have tried both FOCUS_VMS and IBM_GENERIC for TOP OF FORM with the same results. I tried changing the number of pages we skipped to 2 rather than 3 but then it could not find the VERIFY STRING, which is what I would expect if it were counting the pages correctly. I don't know what to try next. The log message is stating that there are only 3 pages on the report, so there is nothing to parse once we get rid of the 3 junk pages.
  2. A report from Banner, FABCHKR, in the fin_devl repository cannot be parsed. The error we get is:
    parse.pl: Reached end of page, verify string not found: Report: FABCHKR; Looking for: 'FABCHKR'
    We tried changing the column and the row, but that did not work. Any ideas? Should we just give up and delete this report from the error queue?
  3. I defined FGLTRNR log and was able to send it to the ePrint server. When I view it in the STORED REPORTS area, I can see the report name. When I open it, there is no information. It should not be blank. What am I missing?
  4. The problem I am having is that the 1st page of FAM reports puts an extra line at the top of the report. Therefore the FAM reports do not work because each subsequent page the unique identified (SBA590) is on line 3 but on line 4 on page 1. We used another report we have as a template for this one.
Login Help
  1. A user might have tried to login too many times and the system logged her out. How can I unlock her ID, or is it an auto time out?
  2. Our Provost is having a problem viewing a .pdf file in ePrint, regardless of who logs in. The system will let you initially log in and go to the listing of viewable reports, but once you click the pdf icon it kicks you out to the login screen. He can view other pdf files in other applications. Can you suggest anything for us to check?
  3. I am signing on using the normal "admin" account that was set up by you, but cannot see a way to set up a new administrator. This person will not be a repository admin, but an overall system administrator as myself. Should I be signing on a different way?
  4. I was wondering is there a way to open more than one screen and compare the reports from different repository at the same time?
Logo Help
  1. How do we add our school logo to our ePrint server?
Missing Report Help
  1. I have emails for reports that failed to parse on 9/14. When I go to the Report Parser for this week it starts with 9/15, last week's ends with 9/13. Where are the log entries for 9/14?
  2. I sent a report to ePrint that had been previously defined and stored. I got a log that says everything is fine, yet this report is not being stored where the other reports have been stored. I checked the parser, the error section, and can find no problems. The report is identical to past runs, but it simply dropped out of sight! I have looked at the report and ePrint definition and can see no errors. Nor has anyone changed this report or its definition since it was run last. Any suggestions?
  3. One of our users is going through a process whereby she uses multiple Internet Native Banner forms, one after the other. Each Form creates an ePrint defined report which is then sent to a Banner printer defined for the ePrint repository. Only the first and the last of the reports show up in the ePrint repository. Any idea what is causing this?
Page break Help
  1. The problem I am having is that the 1st page of FAM reports puts an extra line at the top of the report. Therefore the FAM reports do not work because on each subsequent page the unique identifier (SBA590) is on line 3 but on line 4 on page 1. We used another report we have as a template for this one.
Page Key Help
  1. I have two questions when setting up Page Keys and using Type=SCAN in the Report Definition section of ePrint. (1) When selecting Type = SCAN, will it start from Line 1, Position 1, and scan left to right and then down each line until it finds the 1st SCAN FOR VALUE, which then becomes the key index for that page? (2) Once it finds the first match, does it continue scanning on the same page?
  2. On p. 2 of the Finance report, FGRBDSC, for a particular Fund/Org, the report does not repeat the Fund/Org at the top of the page. So when ePrint reads the data, it drops this page from what is displayed in ePrint.
Parser Help
  1. How often does the parser run?
  2. I get the following message in the Incoming log and reports are in Reports Incoming. Please help!
    SCH: Could not get lock on repository: SCH
  3. Once I create the report definition and FTP it to ePrint without assigning it to a particular group it automatically defaults to the USERS group, which could pose a problem keeping information confidential.
  4. This report has parsed fine about a dozen times but today it has failed. I have checked the report on the mainframe against the report definition and cannot see anything wrong. The log message is: "Thu May 20 08:41:02 2004 parse.pl: Exiting, reached end of file while skipping pages in REPORT1."
    This would lead me to believe that we have a problem with the pages we are skipping (1-3). I have tried both FOCUS_VMS and IBM_GENERIC for TOP OF FORM with the same results. I tried changing the number of pages we skipped to 2 rather than 3 but then it could not find the VERIFY STRING, which is what I would expect if it were counting the pages correctly. I don't know what to try next. The log message is stating that there are only 3 pages on the report, so there is nothing to parse once we get rid of the 3 junk pages.
  5. A report from Banner, FABCHKR, in the fin_devl repository cannot be parsed. The error we get is:
    parse.pl: Reached end of page, verify string not found: Report: FABCHKR; Looking for: 'FABCHKR'
    We tried changing the column and the row, but that did not work. Any ideas? Should we just give up and delete this report from the error queue?
  6. In FTPing a report to ePrint, the report did not parse on the ePrint server. Is it because the filename is different from the report definition?
  7. Our repository administrator (payroll repository) is seeing this message repeatedly in the Report Parser log:
    Tue Jul 6 14:00:26 parse.pl: Warning: Unable to remove sortkey file Tue Jul 6 14:00:27 parse.pl: Successful parse of report REPT246
    He notes that he always gets the message and it does not seem to interfere with the report creation. He adds that his indexing, based on the department number, is not working but he thinks that is due to an error in the way he has it set up. The sortkey error is in the online list of report parser log messages.
  8. I noticed this in the log this morning

    Sat Aug 28 12:01:00 2004 parse.pl: Warning: page too long on 1 pages for report BBD120.
    Sat Aug 28 12:01:00 2004 parse.pl: Successful parse of report BBD120

    Is there any way to determine which page this occurred on other than a manual comparison?
  9. We use ePrint in our automated nightly process. Last night a file was sent to ePrint but ePrint did not parse it. I checked the INCOMING log and we did have an error when the file was being parsed. I need to know what caused the error so we can prevent it. Here is the portion of the INCOMING log with the error:

    Fri Sep 10 01:10:05 2004 PRODUCTION: Starting Parser: bbd120
    Fri Sep 10 01:11:01 2004 PRODUCTION: Could not get lock on repository: PRODUCTION
    Fri Sep 10 01:12:00 2004 PRODUCTION: Could not get lock on repository: PRODUCTION
    Fri Sep 10 01:13:01 2004 PRODUCTION: Could not get lock on repository: PRODUCTION
    Fri Sep 10 01:13:30 2004 PRODUCTION: Parser successful.
  10. I have emails for reports that failed to parse on 9/14. When I go to the Report Parser for this week it starts with 9/15, last week's ends with 9/13. Where are the log entries for 9/14?
  11. I sent a report to my test repository, after which I created the report definition. The definition appears to be proper and the report name appears to be correct in the incoming area; however, the report parser does not appear to be trying to parse the report. Any suggestions?
  12. Would it be possible to generate an input file for the ePrint parser to be used in a new repository from an existing ePrint report in the original repository? That would resolve the complexity of managing the databases.
  13. With the identical report, I get an error message when I use a Banner repository but not when I use the MVS repository. Here is my scenario:

    I created a new repository and named it findevl, which is a Banner finance repository. I then copied the report definitions from the mvstest repository. I FTP'd the reports to the new repository and they were loaded correctly from what I can see, but the "DATA" portion did not appear as it does on the original mvstest repository. Shouldn't both repositories show the same information?
    The incoming log stated the following:

    FINDEVL: Starting Parser: FRSP0921
    FINDEVL: Could not get lock on repository: FINDEVL
    FINDEVL: Could not get lock on repository: FINDEVL
    FINDEVL: Parser successful.
    FINDEVL: Starting Parser: FRSP0922
    FINDEVL: Could not get lock on repository: FINDEVL
    FINDEVL: Could not get lock on repository: FINDEVL>
    FINDEVL: Parser successful.
    FINDEVL: Starting Parser: FRSP0922
    FINDEVL: Parser successful.
  14. Can someone tell me what the parser message, "Unable to remove sortkey file" means? I get the message, "Successful parse of report fgrctrl" after the warning message.
  15. A report was created last night, but had not been defined. After the report was defined this morning, the system tried to parse the report. We got this error:

    6 09:33:01 2004 SIS: Starting Parser: bc220044
    6 09:34:02 2004 SIS: Could not get lock on repository: SIS
    6 09:35:02 2004 SIS: Could not get lock on repository: SIS
    6 09:36:01 2004 SIS: Could not get lock on repository: SIS

    The parse has not ended and we continue to get these error messages.
  16. We have a problem with a mainframe job that runs very fast. When we schedule the same job to run twice in a row, one right after the other, the ePrint file from the first job gets overlaid with the second file and the first report is lost. How long we should wait between jobs so that this will not happen? Can the time interval be changed so that ePrint checks for the files sooner? The job takes about 1 to 2 minutes to run.
  17. We are having trouble transferring the FWOAFL and the accompanying VBS.DONE file to our ePrint server. The ePrint parser is not processing the files. Here is the error we receive:
    securityload.pl: Unable to open input file FWOAFL, No such file or directory
Print Help
  1. I am creating a print queue. The printer name should be equal to the ePrint Report FTP user name, but is the user name the report name or is it the repository name?
    SCH: Could not get lock on repository: SCH
  2. How can I separate Banner reports that are run in PROD and TEST, and sent to ePrint, so they show up in separate "prod" and "test" repositories?
Recover Help
  1. We are about to go live with ePrint and our network folks have requested information about what files/directories on the server need to be backed up (in addition to the whole server) in order to facilitate a data recovery, if required. Can you provide us with this information, please?
  2. One of my repositories was inadvertently deleted. Can I selectively restore from the backup tape (that thankfully is not backed up every night)? And if so, are there instructions for doing this?
    SCH: Could not get lock on repository: SCH
Report Definition Help
  1. One of my repositories was inadvertently deleted. Can I selectively restore from the backup tape (that thankfully is not backed up every night)? And if so, are there instructions for doing this?
    SCH: Could not get lock on repository: SCH
  2. I thought if you entered a user with an email address and he was assigned to a repository to which a report was sent, that he would automatically get notification of that report or any other reports sent to that repository. Do you have to change anything in the report definitions?
  3. Are file names case sensitive?
  4. Once I create the report definition and FTP it to ePrint without assigning it to a particular group it automatically defaults to the USERS group, which could pose a problem keeping information confidential.
  5. How do you configure a report definition file in ePrint to accept non-Banner reports? How do the name entries for the report definition file: the initial report definition name, the label entry and the filename entry match with the incoming files (i.e., .lis and .done files) entering ePrint? I am guessing that the filename entry should match with incoming files.
    With the few Banner reports that I have defined, the Banner filenames (e.g., fgropne.lis, fgropne.done) match with the ePrint report definition name FGROPNE and the report definition label FGROPNE. The filename entry is blank. Are these differences in treatment of names between Banner and non-Banner reports?
  6. This report has parsed fine about a dozen times but today it has failed. I have checked the report on the mainframe against the report definition and cannot see anything wrong. The log message is: "Thu May 20 08:41:02 2004 parse.pl: Exiting, reached end of file while skipping pages in REPORT1."
    This would lead me to believe that we have a problem with the pages we are skipping (1-3). I have tried both FOCUS_VMS and IBM_GENERIC for TOP OF FORM with the same results. I tried changing the number of pages we skipped to 2 rather than 3 but then it could not find the VERIFY STRING, which is what I would expect if it were counting the pages correctly. I don't know what to try next. The log message is stating that there are only 3 pages on the report, so there is nothing to parse once we get rid of the 3 junk pages.
  7. Do all report files go to the "incoming" folder first, even if a report definition does not exist for the file? If so, do they remain there indefinitely awaiting the creation of a definition?
  8. A report from Banner, FABCHKR, in the fin_devl respository cannot be parsed. The error we get is:
    parse.pl: Reached end of page, verify string not found: Report: FABCHKR; Looking for: 'FABCHKR'
    We tried changing the column and the row, but that did not work. Any ideas? Should we just give up and delete this report from the error queue?
  9. I created a report for frrgrnt in the pprod repository. It has been brought to my attention that the end users run the report once a month, but they run it in 18 different grant ranges. It seems that they have to run the report in groups to exclude certain data. My question would be, is it possible to identify these reports individually other than by just the date and time stamp?
  10. What drives the sort order for reports? I thought it was the label because all the reports fall in alphabetical order such as, fgracci, fgracth, fgrbdsc, and so on. I changed the report labels in pprodd for fzrlabr and nhrsdst to reflect the following : HR - Labor Distribution
    HR - Employee Payroll Summary by Orgn

    I was hoping the reports would be grouped together, but they remained in the same position as before.
    We want to group the reports together so it looks similar to this:
    Finance - Account Index Report
    Finance - Account Hierarchy Report
    HR - Labor Distribution
    HR - Employee Payroll
  11. I sent a report to my test repository, after which I created the report definition. The definition appears to be proper and the report name appears to be correct in the incoming area; however, the report parser does not appear to be trying to parse the report. Any suggestions?
  12. Can someone tell me what the parser message, "Unable to remove sortkey file" means? I get the message, "Successful parse of report fgrctrl" after the warning message.
  13. We have several non-Banner report definitions with 15-character names. Is there a limit on the length of report definition name? It seems that the report definition is limited to the length of the Create New File name box. Is this right?
  14. How do I get a pdf file into ePrint?
  15. Our Finance person is for the first time starting to enter ePrint report objects into GSASECR form. An example of our report names is "fn04_telecomm." Our entry person believes he can only enter an 8-character code for new object name, for example, a.Banner encumbrance report is FGROPNE.
Report format Help
  1. Does ePrint support the posting of pre-existing Windows documents in formats such as pdf, Word, Excel, etc.?
  2. We have some clients in our phone billing department who would like to use ePrint. Their reports do not come from the mainframe; they use Crystal Reports to generate the reports. Is it possible to use ePrint with their reporting tool?
  3. We used FOCUS to create a report in comma-delimited format. We created an application in ePrint that works fine and displays the DATA icon, but the system continues to display the TEXT and pdf icons as well. Of course, there is no pdf version and if you try, Adobe shows garbage. Did we do something wrong, or does ePrint require a report version regardless?
  4. We have outsourced some things to companies who have certain access to our system and have access to ePrint for their reports. The reports I speak of are CSV'd for them in order for them to save to an Excel spreadsheet and send to their corporate office. If I log in and click DATA, these reports automatically ask me if I want to save them as an Excel spreadsheet. In their case if they click DATA it never asks them if they want to save it, but it immediately pulls the report up and it is one big mass of information. I have discovered if you right click the drill, ePrint will prompt you for what you want to do. At this point, if a 'save target as' is done and the document saved as an Excel Worksheet, then the document will appear as an Excel spreadsheet. In other words, anytime they want to run and view a CSV'd document, they must download it to their hard drive. Is there a way around this?
    I have examined their version of Excel (which is the same as mine). I have also performed an Explore (right click Start, Explore, Tools, File Types) and viewed how their CSV is set up. Everything is set exactly as on my computer, therefore I do not feel that is the problem. Any help I could receive on this matter would be greatly appreciated.
  5. Our ePrint reports currently give users view options of a text file or a pdf file. How do I create an ePrint report that also has the view option of a data file?
Repository Help
  1. Is there a good reason to keep the ePrint Demo Repository? We are beginning to roll ePrint campus wide. Folks are seeing the Demo Repository and thinking it is a demo they need to go through before using ePrint.
  2. I thought if you entered a user with an email address and he was assigned to a repository to which a report was sent, that he would automatically get notification of that report or any other reports sent to that repository. Do you have to change anything in the report definitions?
  3. As we move to Banner, how do you suggest we handle security in ePrint, since we won't have operator numbers to use from Banner? Will I have to manually maintain users in Banner and assign each person an operator number?
  4. I was wondering is there a way to open more than one screen and compare the reports from different repository at the same time?
  5. Do all report files go to the "incoming" folder first, even if a report definition does not exist for the file? If so, do they remain there indefinitely awaiting the creation of a definition?
  6. I created a Finance repository and initialized it. When I tried to sign on from the ePrint login, I do not see Finance on the list. Can you let me know what I am missing?
  7. One of my repositories was inadvertently deleted. Can I selectively restore from the backup tape (that thankfully is not backed up every night)? And if so, are there instructions for doing this?
  8. We use ePrint in our automated nightly process. Last night a file was sent to ePrint but ePrint did not parse it. I checked the INCOMING log and we did have an error when the file was being parsed. I need to know what caused the error so we can prevent it. Here is the portion of the INCOMING log with the error:

    Fri Sep 10 01:10:05 2004 PRODUCTION: Starting Parser: bbd120
    Fri Sep 10 01:11:01 2004 PRODUCTION: Could not get lock on repository: PRODUCTION
    Fri Sep 10 01:12:00 2004 PRODUCTION: Could not get lock on repository: PRODUCTION
    Fri Sep 10 01:13:01 2004 PRODUCTION: Could not get lock on repository: PRODUCTION
    Fri Sep 10 01:13:30 2004 PRODUCTION: Parser successful.
  9. We are missing some of our View Log info in the Report Parser for certain Repositories. I received a number of ePrint error e-mails for Friday and Saturday. When I viewed the Report Parser for our FRS repository for last week, I was able to see activity for Saturday only. In fact nothing between 11/25 thru 12/03 showed in the Report Parser for the FRS repository. Other repositories show activity during this time. All the reports, whether they are in the Report Parser or not, did FTP successfully, but they don't appear in the Report Parser view Log. Can you shed some light on this?
  10. Our users requested that we create separate repositories for different fiscal years. The reports will be much the same except the next fiscal year reports will have an extension of the new year attached. I would like to copy all report definition templates from one repository to another that will be using the same reports, then modify the report definition for the new year.
  11. A user has requested that reports from one repository be put into another repository. I know I can copy the report definition to the new repository, but is there a method to copy over the actual reports? The files that were used to FTP to ePrint are no longer available (to be parsed). There are a lot of reports that they want copied to the new repository
  12. Would it be possible to generate an input file for the ePrint parser to be used in a new repository from an existing ePrint report in the original repository? That would resolve the complexity of managing the databases.
  13. Can you assign an unlimited number of groups to a repository or is there a limit?
  14. Have any reports been developed that list detail for each repository and show a breakdown by groups and what reports and users are in each group/repository?
  15. With the identical report, I get an error message when I use a Banner repository but not when I use the MVS repository. Here is my scenario: I created a new repository and named it findevl, which is a Banner finance repository. I then copied the report definitions from the mvstest repository. I FTP'd the reports to the new repository and they were loaded correctly from what I can see, but the "DATA" portion did not appear as it does on the original mvstest repository. Shouldn't both repositories show the same information?
    The incoming log stated the following:

    FINDEVL: Starting Parser: FRSP0921
    FINDEVL: Could not get lock on repository: FINDEVL
    FINDEVL: Could not get lock on repository: FINDEVL
    FINDEVL: Parser successful.
    FINDEVL: Starting Parser: FRSP0922
    FINDEVL: Could not get lock on repository: FINDEVL
    FINDEVL: Could not get lock on repository: FINDEVL
    FINDEVL: Parser successful.
    FINDEVL: Starting Parser: FRSP0922
    FINDEVL: Parser successful.
  16. We would like to move reports from one repository to another repository. How can I do that?
  17. Is it possible to have multiple FTP users for one repository?
  18. What software is normally used to FTP to ePrint and where do you specify the repository and report definition? When sending a pdf file to ePrint, you can use FTP (or SFTP) software. Whether you use FTP or SFTP software, the repository is determined by the FTP ID/password used in the FTP process, and the report definition is determined by the file name sent to ePrint.
  19. I created a new repository for FRS for FY03 called FRS03. I used my existing and working FRS04 repository as a template. But ZWOFFL was just sitting in the Security Incoming area. So I deleted the FRS03 repository I had created and tried again. At the same time I was trying to get the Authentication file over, another administrator was running ZJPS10 for another repository. Nothing seems to happening. Our files have been sent, but they are just sitting there.
  20. I have been setting up a new repository. Initially I loaded a user file from SIS, but then I decided to construct a user list separately. When I set the repository update mode to "batch," it loaded my list and deleted the other user IDs from the list of users in that repository. It seems to have left all those (now nonexistent) users in the *group* named "users." I've been manually deleting them. Is it supposed to do this?
  21. How can I separate Banner reports that are run in PROD and TEST, and sent to ePrint, so they show up in separate "prod" and "test" repositories?
Restore Help
  1. One of my repositories was inadvertently deleted. Can I selectively restore from the backup tape (that thankfully is not backed up every night)? If so, are there instructions for doing this?
Security Help
  1. If I have a report in ePrint that is defined with both department level Value Based Security and with email notification of a new report occurrence, will email notifications be sent to all users who can view the report? Or will notifications only be sent to those users who have are able to view pages within the report?
  2. Our problem seems to be maintaining the user's email address. This value is not fed as part of the security update, yet if the security update is run in Batch mode the update wipes out this field. This makes it impossible to do email notification by User Group. Doing email notification by email address on the report definition is prohibitive due to the effort involved. Are there other ePrint clients who use email notification? How are they maintaining the email address?
  3. As we move to Banner, how do you suggest we handle security in ePrint, since we won't have operator numbers to use from Banner? Will I have to manually maintain users in Banner and assign each person an operator number?
  4. We are in our year-end process and some folks are restricted to the current year, while others are locked into the future year. We have been running fbps10 with FY=04. This morning, some folks cannot access their pages, and I think it's because they are restricted to FY05 in FRS. How do we run fbps10 to accounts for both years?
  5. I am trying to route an output report file from a foreign MVS system to my ePrint server via FTP. Security will not allow me access to my ePrint server to pass the information. Any suggestions?
  6. How can I make sure that the fwoafl file has processed properly in the security loader?
  7. I created a new repository for FRS for FY03 called FRS03. I used my existing and working FRS04 repository as a template. But ZWOFFL was just sitting in the Security Incoming area. So I deleted the FRS03 repository I had created and tried again. At the same time I was trying to get the Authentication file over, another administrator was running ZJPS10 for another repository. Nothing seems to happening. Our files have been sent, but they are just sitting there.
  8. I have encountered an error when sending the security file to ePrint:

    220 eprint.nnn.edu FTP server (Version wu-2.6.1-20) ready.
    Connected to 192.154.33.232.
    331 Password required for frss.
    230 User frss logged in. Access restrictions apply.
    200 PORT command successful.
    553 zwoffl: Permission denied on server. (Overwrite)
    221-You have transferred 0 bytes in 0 files.
    221-Total traffic for this session was 389 bytes in 0 transfers.
    221 Thank you for using the FTP service on eprint.nnn.edu.

    Since this file is failing, I have not tried to send the FWOAFL file. In referencing a past event, you suggested deleting and re-defining a file that returned this "permission" type error. Are there any implications with re-defining the ZWOFFL or FWOAFL files? Is this even possible, since it is an FRSS user file?
  9. Can you tell me the difference in shared security on the repository config between Banner Finance, HR, Student, and Generic? Also, how does single sign-on work?
  10. We know that by running the ZJPS10.COM and AJPS10.COM, our security data from SIS is FTP'ed to ePrint. We noticed that on subsequent runs the new data that was entered/changed in SIS will be updated in ePrint; however, users who have been deleted from SIS security do not appear to be deleted from ePrint. Is this by design, so that we have to manually delete them from ePrint or is this a flaw in the system?
  11. I thought the "No Overlay" option would allow us to use the ePrint password routines and drop users as they fall off of FRS -- but that's not happening.

    We decided to use the ePrint passwords because they were more secure, could use any length and combination of characters, and allow users to change their own passwords instead of calling IT. So I was pleased that we could accommodate that concern with ePrint. But it looks like the burden now falls on IT to manually remove users from ePrint when they are removed from FRS.
    Would you consider making this an enhancement in the future where folks can use the ePrint passwords and still drop users off the system if they don't exist in Plus anymore? IT would be thrilled!
  12. What is the maximum length that ePrint will accept for a password?
  13. We receive a daily Suspense report from our SIS Batch Maintenance program and I would like to use Value Based Security (VBS) in ePrint to split up the report so that each user area sees only their own section of the report. I've looked at the documentation on setting up VBS operator files, containing samples for FRS and HRS using a header record with FY in it. Do we need a header for SIS and if so, what needs to be in it? Is it going to be possible for me to manually create my own VBS file? Will that affect the ability of these users to see any of their other reports? I have other reports indexed by page keys.
  14. I sent files named 'sisuser' and 'sisunit' to ePrint and used the same names in the security VBS setup. It looks like ePrint expects to see a file with a different name. Here's my error message:
    Cannot open file '/home/eprint/cgi-bin/../prod/repository/test/security/user.vbs': No such file or directory
    Also, I have two new VBS security files sitting in the Security Incoming Directory and they aren't moving. Can you tell me why they are still sitting there, and why the first one shows no data when there are five lines.
  15. The help on the security screen says the following: This field indicates how the security is updated. Select BATCH if batch files sent from the mainframe via FTP will only update the security. The batch file will overlay all data. Select ONLINE if user security is only to be updated online. (This option disables the batch process.) Select BOTH if security will be updated both by batch process and online via the administrative interface. Select NO_OVERLAY to load new users to ePrint without changes to existing users. Batch overlays the data. Online allows only online updates. No overlay loads only new users.
    My question has to do with BOTH. It seems that when I specify BOTH and run a batch update, it does not overlay the existing data. Is BOTH actually NO_OVERLAY and ONLINE? If not, can you explain what BOTH should do?
  16. Does a user have to be set up as an INB user to have ePrint do report authorization to ensure only specific reports are seen? We had been planning on just setting users as SSB (Self-Service Banner.)
Server Help
  1. The production department is going to be doing some technical work in the server room. The ePrint server is in this room and we want it shut down so we can perform the work. Can you give us a user account so we can shut it down from here?
  2. I have encountered an error when sending the security file to ePrint:

    220 eprint.nnn.edu FTP server (Version wu-2.6.1-20) ready.
    Connected to 192.154.33.232.
    331 Password required for frss.
    230 User frss logged in. Access restrictions apply.
    200 PORT command successful.
    553 zwoffl: Permission denied on server. (Overwrite)
    221-You have transferred 0 bytes in 0 files.
    221-Total traffic for this session was 389 bytes in 0 transfers.
    221 Thank you for using the FTP service on eprint.nnn.edu.

    Since this file is failing, I have not tried to send the FWOAFL file. In referencing a past event, you suggested deleting and re-defining a file that returned this "permission" type error. Are there any implications with re-defining the ZWOFFL or FWOAFL files? Is this even possible, since it is an FRSS user file?
Sort Help
  1. What drives the sort order for reports? I thought it was the label because all the reports fall in alphabetical order such as, fgracci, fgracth, fgrbdsc, and so on. I changed the report labels in pprodd for fzrlabr and nhrsdst to reflect the following : HR - Labor Distribution
    HR - Employee Payroll Summary by Orgn

    I was hoping the reports would be grouped together, but they remained in the same position as before.
    We want to group the reports together so it looks similar to this:
    Finance - Account Index Report
    Finance - Account Hierarchy Report
    HR - Labor Distribution
    HR - Employee Payroll
Temporary file Help
  1. ePrint gives you the ability to view files in pdf or text format. Are these just views, or are there really two copies of the report on the server?
Time Help
  1. My ePrint machine seems to be gaining time. Currently it is about 35 minutes fast. Is there an option to adjust the time (Solaris UNIX 'date -a xxx' command), or is there an option to hook up to a time source and adjust the time accordingly?
  2. We use ePrint in our automated nightly process. Last night a file was sent to ePrint but ePrint did not parse it. I checked the INCOMING log and we did have an error when the file was being parsed. I need to know what caused the error so we can prevent it. Here is the portion of the INCOMING log with the error:

    Fri Sep 10 01:10:05 2004 PRODUCTION: Starting Parser: bbd120
    Fri Sep 10 01:11:01 2004 PRODUCTION: Could not get lock on repository: PRODUCTION
    Fri Sep 10 01:12:00 2004 PRODUCTION: Could not get lock on repository: PRODUCTION
    Fri Sep 10 01:13:01 2004 PRODUCTION: Could not get lock on repository: PRODUCTION
    Fri Sep 10 01:13:30 2004 PRODUCTION: Parser successful.
  3. We have a problem with a mainframe job that runs very fast. When we schedule the same job to run twice in a row, one right after the other, the ePrint file from the first job gets overlaid with the second file and the first report is lost. How long we should wait between jobs so that this will not happen? Can the time interval be changed so that ePrint checks for the files sooner? The job takes about 1 to 2 minutes to run.
Usage Help
  1. Our VP wants to know how much ePrint is being used. Is there any easy way to determine how many people are signing on and looking at reports? We have over 150 reports on ePrint and about 100 people have access to them. This is too much to try to tally by looking at each report, each day, to see who has viewed it.
User Group Help
  1. Once I create the report definition and FTP it to ePrint without assigning it to a particular group it automatically defaults to the USERS group, which could pose a problem keeping information confidential.
  2. I've been asked to rename one of my Groups in ePrint but don't see an option to change the name of the group. I could delete the current group and recreate the group under the new name, but I assume this new group would not be able to access all the reports from previous months that were in the group under the old name. Is this a correct assumption? If so, how should I handle this?
  3. Can you assign an unlimited number of groups to a repository or is there a limit?
  4. Have any reports been developed that list detail for each repository and show a breakdown by groups and what reports and users are in each group/repository?
  5. I have been setting up a new repository. Initially I loaded a user file from SIS, but then I decided to construct a user list separately. When I set the repository update mode to "batch," it loaded my list and deleted all of the other user IDs from the list of users in that repository. It seems to have left all those (now nonexistent) users in the *group* named "users." I've been manually deleting them. Is it supposed to do this?
  6. I have been attempting to assign a user group to a defined report as a way of notifying users that reports are available on ePrint. I know that I can add individual user emails to a report, but would like to notify an entire group. I believe I can also manually enter email addresses on each individual user but wouldn't they be overlaid (blanked) by my ZWOFFL? We currently have the UPDATE MODE set to BATCH because we want users that are removed from SIS to also be removed from ePrint. My current understanding is that an email address could reside on the ZWOFFL file that we FTP and we could use the security screens to tell ePrint where the email address starts and its length. Do we need to write something to place the email address on this file?
User ID Help
  1. A user might have tried to login too many times and the system logged her out. How can I unlock her ID, or is it an auto time out?
  2. As we move to Banner, how do you suggest we handle security in ePrint, since we won't have operator numbers to use from Banner? Will I have to manually maintain users in Banner and assign each person an operator number?
  3. I am signing on using the normal "admin" account that was set up by you, but cannot see a way to set up a new administrator. This person will not be a repository admin, but an overall system administrator as myself. Should I be signing on a different way?
  4. Does a user have to be set up as an INB user to have ePrint do report authorization to ensure only specific reports are seen? We had been planning on just setting users as SSB (Self-Service Banner.)
View Help
  1. ePrint gives you the ability to view files in pdf or text format. Are these just views, or are there really two copies of the report on the server?
  2. Our Provost is having a problem viewing a .pdf file in ePrint, regardless of who logs in. The system will let you initially log in and go to the listing of viewable reports, but once you click the pdf icon it kicks you out to the login screen. He can view other pdf files in other applications. Can you suggest anything for us to check?
  3. I was wondering if there is a way to open more than one screen and compare the reports from different repositories at the same time?
  4. Two people called with the following error:
    "There are no pages for you to view on this report. If you think this is an error, contact your ePrint administrator. Otherwise, return to ePrint and select another report."
  5. What drives the sort order for reports? I thought it was the label because all the reports fall in alphabetical order such as, fgracci, fgracth, fgrbdsc, and so on. I changed the report labels in pprodd for fzrlabr and nhrsdst to reflect the following : HR - Labor Distribution
    HR - Employee Payroll Summary by Orgn

    I was hoping the reports would be grouped together, but they remained in the same position as before.
    We want to group the reports together so it looks similar to this:
    Finance - Account Index Report
    Finance - Account Hierarchy Report
    HR - Labor Distribution
    HR - Employee Payroll
  6. I defined FGLTRNR log and was able to send it to the ePrint server. When I view it in the STORED REPORTS area, I can see the report name. When I open it, there is no information. It should not be blank. What am I missing?
  7. We are missing some of our View Log info in the Report Parser for certain Repositories. I received a number of ePrint error e-mails for Friday and Saturday. When I viewed the Report Parser for our FRS repository for last week, I was able to see activity for Saturday only. In fact nothing between 11/25 thru 12/03 showed in the Report Parser for the FRS repository. Other repositories show activity during this time. All the reports, whether they are in the Report Parser or not, did FTP successfully, but they don't appear in the Report Parser view Log. Can you shed some light on this?
  8. How would I darken a report to make it easier to read?
  9. I sent a report to ePrint that had been previously defined and stored. I got a log that says everything is fine, yet this report is not being stored where the other reports have been stored. I checked the parser, the error section, and can find no problems. The report is identical to past runs, but it simply dropped out of sight! I have looked at the report and ePrint definition and can see no errors. Nor has anyone changed this report or its definition since it was run last. Any suggestions?
  10. I'm trying to set up the CSV on a report and it fails to load the whole report into Excel. It stops at line 65,536. We will be adding VBS to this report, but if anyone has access to the whole report they wouldn't be able to view the entire report in Excel. Is there a way around this problem?
  11. We used FOCUS to create a report in comma-delimited format. We created an application in ePrint that works fine and displays the DATA icon, but the system continues to display the TEXT and pdf icons as well. Of course, there is no pdf version and if you try, Adobe shows garbage. Did we do something wrong, or does ePrint require a report version regardless?
  12. I'm having a problem setting up a report using the CSV setting. I create the definition for the report in CSV, but when I go to Stored Reports and click Data, it shows up in a text document. I've checked my settings and they seem to be the same as the values that work in other repositories. Any pointers?
  13. We have outsourced some things to companies who have certain access to our system and have access to ePrint for their reports. The reports I speak of are CSV'd for them in order for them to save to an Excel spreadsheet and send to their corporate office. If I log in and click DATA, these reports automatically ask me if I want to save them as an Excel spreadsheet. In their case if they click DATA it never asks them if they want to save it, but it immediately pulls the report up and it is one big mass of information. I have discovered if you right click the drill, ePrint will prompt you for what you want to do. At this point, if a 'save target as' is done and the document saved as an Excel Worksheet, then the document will appear as an Excel spreadsheet. In other words, anytime they want to run and view a CSV'd document, they must download it to their hard drive. Is there a way around this?
    I have examined their version of Excel (which is the same as mine). I have also performed an Explore (right click Start, Explore, Tools, File Types) and viewed how their CSV is set up. Everything is set exactly as on my computer, therefore I do not feel that is the problem. Any help I could receive on this matter would be greatly appreciated.
  14. The problem I am having is that the 1st page of FAM reports puts an extra line at the top of the report. Therefore the FAM reports do not work because each subsequent page the unique identified (SBA590) is on line 3 but on line 4 on page 1. We used another report we have as a template for this one.
  15. Our ePrint reports currently give users view options of a text file or a pdf file. How do I create an ePrint report that also has the view option of a data file?
  16. We are experiencing a repetitive problem. When users try to download a report, it brings up the login screen instead of the data.
Year-end Help
  1. We are in our year-end process and some folks are restricted to the current year, while others are locked into the future year. We have been running fbps10 with FY=04. This morning, some folks cannot access their pages, and I think it's because they are restricted to FY05 in FRS. How do we run fbps10 to accounts for both years?
  2. Our users requested that we create separate repositories for different fiscal years. The reports will be much the same except the next fiscal year reports will have an extension of the new year attached. I would like to copy all report definition templates from one repository to another that will be using the same reports, then modify the report definition for the new year.

Banner ePrint FAQ's Answers

Ad Hoc Reports Help
  1. I was asked about posting non-Ellucian reports to ePrint. Wouldn't this be a nightmare, since headings and page breaks wouldn't be the same? I fear that we may open up a can of worms and get stuck rewriting everybody's reports so they look good in ePrint. Any advice?

    Many factors must be considered. What type of reports do you mean? What report writer is generating the reports? The process you would follow is the same as with the standard Plus reports. There is a little work but it's not a large task. The biggest consideration is what is used as the carriage control for the top-of-page. After that it is just where are fields located on the report. Since all the Plus reports have the same format, this makes adding new reports easy -- just select a template, copy, and make a few changes.

    When setting up ad-hoc reports, develop a standard format that all reports would use regardless of the tool used to create the report. This is fine if you are starting out, but if you have reports already created, do you want to change all of them to this new format or just bring them in as is? Bottom line is that it would be a little more work if the formats are different, but it's more like 2-5 minutes, not 20-50 minutes.

Archive Help
  1. Currently my ePrint server does not have a CD burner. Can I archive to a file locally and then FTP that file to one of my servers with a CD burner?

    As of the 3.3-1 release of ePrint, the archiving process now allows the creation and download of ISO images suitable for download and burning of CDs and DVDs.

  2. If you cannot fit your selected reports on one CD, do you have to reduce your data, or will the system prompt you to enter in a second CD?

    There is no way for archive sets to span multiple CDs. However, the 3.3-1 release of ePrint supports burning DVDs, which have approximately 5 times the capacity of a CD.

Backup Help
  1. We are about to go live with ePrint and our network folks have requested information about what files/directories on the server need to be backed up (in addition to the whole server) in order to facilitate a data recovery, if required. Can you provide us with this information, please?

    These are important directories that you want to back up in order to facilitate a data recovery if necessary: /etc and /home. Anything taking up space in /home is important, so it is best to grab the whole thing. The /home directory holds all the ePrint data and the mysql data.

  2. One of my repositories was inadvertently deleted. Can I selectively restore from the backup tape (that thankfully is not backed up every night)? And if so, are there instructions for doing this?

    There is no way for you to selectively restore from the backup tape. Basically, the backup created is for disaster recovery situations and for full system restores in the event of something such as a hardware failure.

Browser Help
  1. Our Provost is having a problem viewing a .pdf file in ePrint, regardless of who logs in. The system will let you initially log in and go to the listing of viewable reports, but once you click the pdf icon it kicks you out to the login screen. He can view other pdf files in other applications. Can you suggest anything for us to check?

    Have him clear the cache in his browser and try again. This normally will resolve the problem.

  2. Is there a reason we keep getting the error 'Warning - Page Expired'? I notice it when I've been in the reports and I either have to click refresh or keep clicking the back arrow.

    The reason you keep getting that message is because by default, Internet Explorer (IE) is set to create this warning message as a security precaution. To eliminate this message, in IE go to Tools -> Internet Options. Under the Advanced tab, deselect, "Do not save encrypted pages to disk." You shouldn't receive the IE warning message anymore.

  3. I have received the following messages from two users. What is the problem?
    /home/eprint/cgi-bin/../prod/repository/finance/config/.xml not found, not readable, or not writable at /home/eprint/cgi-bin/../code/Pinnacle/UIGetreport.pm line 684.Dept: Student Fin. Planning

    This error can be caused by a couple of things -- either the browser is not clearing the cache, or they are using the browser BACK button when they should be using the ePrint navigation bar. The only time that the browser BACK button should be used is to get back from reading a pdf report from within the browser. Have them clear the cache.

  4. I was wondering is there a way to open more than one screen and compare the reports from different repository at the same time?

    You can open ePrint in another browser window and compare the reports. This means that you would be logged in twice.

  5. When a person is in a report in ePrint and they click the back button, they get: Page has expired. If they click the back button again, it goes back to the ePrint menu. Any suggestions? Should they reload Adobe Acrobat Reader? It works fine for me.

    If a user is using Internet Explorer (IE), it is better to open Adobe outside of the browser. Also, if the user is using https to access the reports, the problem may be because of a security precaution in IE relating to encrypted pages. To eliminate this message, try this: In IE go to Tools -> Internet Options. Under the Advanced tab, de-select "Do not save encrypted pages to disk". Once this option is no longer selected, the warning message should go away.

  6. Our Apple users are using SAFARI to access ePrint because of a problem with Internet Explorer. Do you know of any compatibility or encryption problems using this browser? Should it work with the 128-bit encryption?

    According to the Safari web site, the latest version handles 128-bit encryption fine. Almost all browsers today support 128-bit encryption. The reason that Mac/IE has problems may be due to the fact that they stopped development on it and didn't fix the problem before they did so. Safari is the default browser for Mac's so I imagine they did a better job with the SSL 3 support then what Microsoft did with their Mac version of IE.

  7. I'm having a problem setting up a report using the CSV setting. I create the definition for the report in CSV, but when I go to Stored Reports and click Data, it shows up in a text document. Ive checked my settings and they seem to be the same as the values that work in other repositories. Any pointers?

    If you are using Internet Explorer as your browser, right mouse click, save target as, and save the file to your desktop (or wherever you want). Then go to the file and open it, this should open Excel and display the report in CSV format. If you use the primary mouse button to click the "Data" icon, this will cause Excel to open within the browser and not perform the CSV processing.

  8. We have outsourced some things to companies who have certain access to our system and have access to ePrint for their reports. The reports I speak of are CSV'd for them in order for them to save to an Excel spreadsheet and send to their corporate office. If I log in and click DATA, these reports automatically ask me if I want to save them as an Excel spreadsheet. In their case if they click DATA it never asks them if they want to save it, but it immediately pulls the report up and it is one big mass of information. I have discovered if you right click the drill, ePrint will prompt you for what you want to do. At this point, if a save target as is done and the document saved as an Excel Worksheet, then the document will appear as an Excel spreadsheet. In other words, anytime they want to run and view a CSV'd document, they must download it to their hard drive. Is there a way around this? I have examined their version of Excel (which is the same as mine). I have also performed an Explore (right click Start, Explore, Tools, File Types) and viewed how their CSV is set up. Everything is set exactly as on my computer, therefore I do not feel that is the problem. Any help I could receive on this matter would be greatly appreciated.

    As far as being prompted to save the file rather then just opening it, this is neither an ePrint nor an Excel issue. Rather, this is dependent on which Web browser is being used and how the browser is configured. When dealing with the CSV files, they should always save them to their hard drive first (right click and "save target as"), otherwise they will display incorrectly, just as you have described.

  9. I have Banner documentation in pdf format that I want to FTP to ePrint and make available to users. These pdf files are on my hard drive. Is it possible to FTP them to ePrint through my PC?

    Yes, you can FTP the files from your PC to the ePrint server. We would need the IP address of your PC and put that on the server as an address that can FTP to the server. When sending over pdf files, be sure to transfer them using "binary" mode which should be an option with your FTP client. Otherwise, the file may become corrupted and display incorrectly.

  10. We are experiencing a repetitive problem. When users try to download a report, it brings up the login screen instead of the data.

    It sounds like they losing their login session. Make sure their browsers are set to accept cookies. Also make sure their "Privacy Settings" are not too high. Anything higher than "Medium" may cause problems such as the one you are describing.

  11. I am getting the following message:"File does not begin with '%pdf-" when trying to access the report from E-mail URL.

    If you are using Internet Explorer (IE) as your default browser, be sure to configure Adobe Reader to open outside of the browser. There are known problems with the Adobe/IE plug-in that occasionally causes a dynamically built pdf to not open correctly.

  12. Were having a problem retrieving FRRGRNT reports in our ePrint repository. As an administrator there is no problem, but as a user it seems to hang indefinitely and never retrieves the pdf format. The text portion comes back successfully. I have even turned off VBS and it continues to be a problem.

    This may be the result of a browser upgrade that changed the pdf file association in Windows from Adobe Reader to an Internet Explorer (IE) mime-plugin for Acrobat. I ran into this after an IE update and took the following steps to fix it: Click My Computer, then Tools > Folder Options. In the box that opens up click the tab FILE TYPES. Scroll down to pdf (or Adobe Acrobat Document) and click Change. In the new dialog box, Select Adobe Acrobat and click OK. This will give the correct path to launch Acrobat Reader when clicking on a pdf file.

  13. An end-user with Windows and Internet Explorer said she has been getting this message since last week whenever she tries to log in. The user account seems to be okay. /home/eprint/cgi-bin/../prod/repository/frs/config/.xml not found, not readable, or not writable at /home/eprint/cgi-bin/../code/Pinnacle/UIGetreport.pm line 684.

    This message could be caused by a couple of things. First, cache is not being cleared in the browser. Clear cache and see is the message still displays. Second, the user is using the browser BACK button instead of the navigation bar within ePrint. If this is the case, use the navigation bar and the message should stop appearing.

  14. Does ePrint support Mac users? If so, which Mac OS and which browsers?

    Mac users shouldn't have any problems accessing ePrint. However there are known problems with Mac's Internet Explorer (IE) SSL implementation and since Microsoft stopped development on it, the issues will probably not get fixed. With that said, I highly recommend that Mac users DO NOT use IE. Also, I have heard there are users running Safari, Mac's default browser, and no problems have been reported with it.

CD Help
  1. Currently my ePrint server does not have a CD burner. Can I archive to a file locally and then FTP that file to one of my servers with a CD burner?

    This is what you can do:
    Create an archive as you normally would.
    Log into the ePrint server with the eprintop login.
    Select the archive set that you want.
    Continue as you normally would.
    The reports will be generated, but the process will error because there is no burner. There will be a file in /scratch/image/ called "test1.raw"

    This will be the image you will want to burn. Transfer the file to another machine, then burn the image to CD.

  2. If you cannot fit your selected reports on one CD, do you have to reduce your data, or will the system prompt you to enter in a second CD?

    Prior to the physical burning of the CD, you will be informed as to how much of the CD will be used. If you exceed 100%, you will need to remove data before burning. The process will not continue if you exceed 100% of a CD.

Conversion Help
  1. We are beginning to look more seriously at the time frame we would need for getting ePrint ready for Banner and Banner ready for e-Print. Some HR/Payroll conversion reports should be ready to run shortly and the desire is to start out on ePrint from the get go. There is still a lot of discussion here about who will do what as far as the security side of the Banner so things are not quite ready. But my question then, is what kind of time frame should we be looking at for the configuration on Banner/ePrint to make this a reality?

    The time frames vary for each site and are based on the number of people involved, their skill sets, and the time available for the configuration task. Last week we had a customer finish the entire configuration steps in four days. This was one person working part-time each day, about an hour or so, on the configuration. She had access to the Oracle database as a DBA, so she was able to create the ePrint server user and configure the ePrint classes herself. She was familiar with Unix so she was comfortable loading the automated FTP scripts. Most of all, she was familiar with ePrint so she was comfortable creating a Banner repository. She also spent time up-front reading the documentation and understanding the steps involved. The average time frame is a few weeks of part-time work for one or two resources. You will need a minimum of two skill sets for the conversion, a Banner DBA and an ePrint administrator. Later on for testing you will want to involve someone with functional ties to the repository, either Finance or HR. We have had sites take from 4 - 5 weeks for a variety of reasons including inadequate skill sets and resources with no time to invest in the configuration. So, if you are the DBA, I would estimate two weeks, just to be safe. You will be doing the work part-time and you will have many demands pop up that take you away from the project.

Copy Help
  1. Our users requested that we create separate repositories for different fiscal years. The reports will be much the same except the next fiscal year reports will have an extension of the new year attached. I would like to copy all report definition templates from one repository to another that will be using the same reports, then modify the report definition for the new year.

    When you create your new fiscal year repository using the report definition wizard, on the first page, you will find a "radio" button next to "Copy multiple report definitions as templates." Select the original repository from the drop-down list and then highlight the report definitions that you want to copy. You may use the Shift key to select a range or the CTRL key to select different individual definitions. Click the CREATE button and this will copy all of the selected report definitions to your new repository. Make individual adjustments to each report definition and you are all set.

  2. A user has requested that reports from one repository be put into another repository. I know I can copy the report definition to the new repository, but is there a method to copy over the actual reports? The files that were used to FTP to ePrint are no longer available (to be parsed). There are a lot of reports that they want copied to the new repository.

    No, the process of moving reports from one repository to another is not supported by ePrint. This is not a simple task, due in part to the databases behind ePrint and the many dependences that would need to be in place before the reports could be moved.

  3. Would it be possible to generate an input file for the ePrint parser to be used in a new repository from an existing ePrint report in the original repository? That would resolve the complexity of managing the databases.

    Here is one method that you can use. First copy the report definition from the original repository to the "new" one. In the "new" repository's report definition, change the "Top of Form" to Fixed_length and save these changes. Now go back to your original repository. Go to Stored Reports and download the "TEXT" version of the report you want to move. FTP the downloaded file to the "new" repository -- don't forget the .done file! The report will parse and it will now be in the "new" repository. Repeat the download of the TEXT and FTP steps for each instance of the report that you want to bring over. The only issue may be that the IP address of the desktop that you will be doing this from is not defined to the server as a valid IP address for FTP. Just let us know and we can make that change for you.

  4. I received a request to copy over 3 files to the ePrint server. I have copied over the fgrbdsc and one of the fgrodta files the user created. I am trying to copy over the third file, which is another fgrodta file only much larger. I don't have an error in the Report Incoming Error, but I can see the fgrodta.lis and fgrodta.done files in the Reports Incoming. Can you explain to me what is wrong with this report?

    In the report definition for fgrodta, the file name is "fgrodta," so that is what ePrint is looking for. Rename fgrodta.lis to fgrodta and you should be all set.

CSV Help
  1. With the identical report, I get an error message when I use a Banner repository but not when I use the MVS repository. Here is my scenario:
    I created a new repository and named it findevl, which is a Banner finance repository. I then copied the report definitions from the mvstest repository. I FTP'd the reports to the new repository and they were loaded correctly from what I can see, but the "DATA" portion did not appear as it does on the original mvstest repository. Shouldn't both repositories show the same information?
    The incoming log stated the following:

        FINDEVL: Starting Parser: FRSP0921
        FINDEVL: Could not get lock on repository: FINDEVL
        FINDEVL: Could not get lock on repository: FINDEVL
        FINDEVL: Parser successful.
        FINDEVL: Starting Parser: FRSP0922
        FINDEVL: Could not get lock on repository: FINDEVL
        FINDEVL: Could not get lock on repository: FINDEVL>
        FINDEVL: Parser successful.
        FINDEVL: Starting Parser: FRSP0922
        FINDEVL: Parser successful.

    The DATA icon will only appear if you define CSV parsing for that report. When you use a report definition from one repository as a template for that same report in another repository, ePrint will just copy the report definition. If you want the DATA icon you can copy the CSV definition from the MVS repository as a template for the new FINDEVL CSV definition. The CSV definition is totally separate from the report definition.

  2. I'm trying to set up the CSV on a report and it fails to load the whole report into Excel. It stops at line 65,536. We will be adding VBS to this report, but if anyone has access to the whole report they wouldn't be able to view the entire report in Excel. Is there a way around this problem?

    The 65,536 line is the limit Excel can accept. The only workaround would be to split the report. With VBS the number of people who can see the entire report should be limited. The main question would be, is someone who has access to all the information likely to download to Excel?

  3. We used FOCUS to create a report in comma-delimited format. We created an application in ePrint that works fine and displays the DATA icon, but the system continues to display the TEXT and pdf icons as well. Of course, there is no pdf version and if you try, Adobe shows garbage. Did we do something wrong, or does ePrint require a report version regardless?

    The CSV function of ePrint assumes that it is working with a text report. From the text report ePrint will create the comma-delimited file as output. Because of this ePrint will always display the pdf and TEXT icons. A simple solution is to send the file as straight data and have ePrint create the comma-delimited file. In this case, the users can see the raw data to see what was input.

  4. Our ePrint reports currently give users view options of a text file or a pdf file. How do I create an ePrint report that also has the view option of a data file?

    To get the DATA view option for a report, define a CSV definition. A report has to be defined first before you can do the CSV definition. Most likely a report that has columns of data are candidates for CSV. Define the columns of data that will be extracted to a comma-delimited dataset. You can review the help for defining CSV for a report. Once you have the CSV definition, the DATA icon will appear for all instances of the report.

  5. I'm having a problem setting up a report using the CSV setting. I create the definition for the report in CSV, but when I go to Stored Reports and click Data, it shows up in a text document. I've checked my settings and they seem to be the same as the values that work in other repositories. Any pointers?

    If you are using Internet Explorer as your browser, right mouse click, save target as, and save the file to your desktop (or wherever you want). Then go to the file and open it, this should open Excel and display the report in CSV format. If you use the primary mouse button to click the "Data" icon, this will cause Excel to open within the browser and not perform the CSV processing.

  6. We have outsourced some things to companies who have certain access to our system and have access to ePrint for their reports. The reports I speak of are CSV'd for them in order for them to save to an Excel spreadsheet and send to their corporate office. If I log in and click DATA, these reports automatically ask me if I want to save them as an Excel spreadsheet. In their case if they click DATA it never asks them if they want to save it, but it immediately pulls the report up and it is one big mass of information. I have discovered if you right click the drill, ePrint will prompt you for what you want to do. At this point, if a 'save target as' is done and the document saved as an Excel Worksheet, then the document will appear as an Excel spreadsheet. In other words, anytime they want to run and view a CSV'd document, they must download it to their hard drive. Is there a way around this? I have examined their version of Excel (which is the same as mine). I have also performed an Explore (right click Start, Explore, Tools, File Types) and viewed how their CSV is set up. Everything is set exactly as on my computer, therefore I do not feel that is the problem. Any help I could receive on this matter would be greatly appreciated.

    As far as being prompted to save the file rather then just opening it, this is neither an ePrint nor an Excel issue. Rather, this is dependent on which Web browser is being used and how the browser is configured. When dealing with the CSV files, they should always save them to their hard drive first (right click and "save target as"), otherwise they will display incorrectly, just as you have described.

Date Help
  1. I sent a report to ePrint that had been previously defined and stored. I got a log that says everything is fine, yet this report is not being stored where the other reports have been stored. I checked the parser, the error section, and can find no problems. The report is identical to past runs, but it simply dropped out of sight! I have looked at the report and ePrint definition and can see no errors. Nor has anyone changed this report or its definition since it was run last. Any suggestions?

    In looking at the reports, they are filed under 09/04/2003 but the report date is 02/09/04. When I compared these reports against the last "good one" (1/29/04), I noticed that the report is different. The "good" reports have on the heading line, DATE RUN: nn/nn/nn; the reports in question had, DATE:nn/nn/nn.

    The date is in a different place, that's why they are not listed under the correct date. Change the date setting on the report definition in ePrint or on the heading of the report.

  2. In our SIS repository report RBA121publ4 seems to have a date way in the future. We have attempted to reload this report but it still gives the wrong date. Can you fix this?

    The location of the date changed from 119 (which is where your report definition is set) to 121. As a result, it was picking up the year as 20 (2004). So somewhere the report was changed. Adjust the report or the definition.

  3. We have set up some reports to use the SYSTEM date and time when the report is processed on the ePrint server. The time is not accurate when we follow this procedure. Can we adjust the time on the ePrint server, and if so, how?

    Yes, you can adjust the time. Here is an example to set it to 2:57 PM: date -s 14:57:00. If you have a time server on campus that we can use, we can synchronize the time on the server in case if drifts.

Demo Help
  1. Is there a good reason to keep the ePrint Demo Repository? We are beginning to roll ePrint campus wide. Folks are seeing the Demo Repository and thinking it is a demo they need to go through before using ePrint.

    Do not delete this repository! The ePrint demo repository is used as the template for all new repositories. This is why you don't want to delete it. You can hide it so users will not see it on the drop-down list. To hide it, go to the repository config, select the ePrint demo repository and click the EDIT button. At the bottom of the Repository Config page is the Hidden setting; set this to YES.

Download Help
  1. We are experiencing a repetitive problem. When users try to download a report, it brings up the login screen instead of the data.

    It sounds like they losing their login session. Make sure their browsers are set to accept cookies. Also make sure their "Privacy Settings" are not too high. Anything higher than "Medium" may cause problems such as the one you are describing.

eMail Help
  1. If I have a report in ePrint that is defined with both department level Value Based Security and with e-mail notification of a new report occurrence, will e-mail notifications be sent to all users who can view the report? Or will notifications only be sent to those users who have are able to view pages within the report?

    The e-mail will go to all users who have access to the report (and have their e-mail addresses in ePrint). Even if there are no pages for them to view, they would get an e-mail. ePrint does not check every user's report access to see if there is anything for them to see, it just knows that the report is ready.

  2. We have just added e-mail notifications to a couple of our reports on ePrint. We want to send a notification to about 110 people on one report. Our campus limits the number of e-mails it will allow at one time to 100. I have entered the e-mail addresses in several records. My question is, will ePrint send a separate e-mail for each record or will it lump them all together to send one e-mail to all 110 at one time?

    If you set the "ID Type" to "E-MAIL" in the report definition, and put several e-mail addresses in the list, one e-mail will be sent from the ePrint server. If you have multiple "Notification IDs" set up, and each has a list of users, one e-mail will be sent from the ePrint server for each "Notification ID" that is set up.

  3. I thought if you entered a user with an e-mail address and he was assigned to a repository to which a report was sent, that he would automatically get notification of that report or any other reports sent to that repository. Do you have to change anything in the report definitions?

    In the report definition, you must set up the "Notification" section. If you specify an "E-MAIL" address, when that report is parsed the e-mail notification will be sent.

  4. Our problem seems to be maintaining the user's e-mail address. This value is not fed as part of the security update, yet if the security update is run in Batch mode the update wipes out this field. This makes it impossible to do e-mail notification by User Group. Doing e-mail notification by e-mail address on the report definition is prohibitive due to the effort involved. Are there other ePrint clients who use e-mail notification? How are they maintaining the e-mail address?

    One Plus school added the user's e-mail address to the ZCFILE. They used a couple of fields that they did not use in ZSS and made it e-mail address. They added this field to the extract file and to the security definition in ePrint so they could continue to use Batch mode update. With Batch mode update you can maintain your users with ZSS and ePrint reflects those changes. After further discussion, we concluded that an update mode of "Both" would work for you. This will keep the e-mail addresses in ePrint. The drawback here is that when you delete a user from ZSS, you must also delete the user from ePrint. Another solution would be to include all the users e-mail addresses, separated by commas on the "Notification" page of the report definition. The drawback here is that you would need to add/delete e-mail addresses as the list of users changes. Each of these solutions requires some change on your part. Select the one that best works for you.

  5. Is there a limit on how many e-mail notifications you can send out? I can't really test this, so I thought I would ask. We have close to 2000 e-mail notifications we will be sending out with a particular report.

    There is no limit on e-mail notifications; they should go out fine.

  6. I have e-mails for reports that failed to parse on 9/13/04. When I go to the Report Parser for this week it starts with 9/14/2004, last week's ends with 9/11/04. Where are the log entries for 9/13/04?

    Change the number of lines to display to something like 999. You will see all the entries in the log. The display on the log files is the last x number of lines, where x is the number from the page (default is 100).

Error Message Help
  1. I get the following message in the Incoming log and reports are in Reports Incoming. Please help!

    SCH: Could not get lock on repository: SCH

    You sent the report and the .done file before you created the report definition file. This caused the parser to go into a loop. We stopped the parser and you will have to re-send the report and .done files.

  2. Is there a reason we keep getting the error 'Warning - Page Expired'? I notice it when I've been in the reports and I either have to click refresh or keep clicking the back arrow.

    The reason you keep getting that message is because by default, Internet Explorer (IE) is set to create this warning message as a security precaution. To eliminate this message, in IE go to Tools -> Internet Options. Under the Advanced tab, deselect, "Do not save encrypted pages to disk." You shouldn't receive the IE warning message anymore.

  3. I have received the following messages from two users. What is the problem?

    /home/eprint/cgi-bin/../prod/repository/finance/config/.xml not found, not readable, or not writable at /home/eprint/cgi-bin/../code/Pinnacle/UIGetreport.pm line 684.Dept: Student Fin. Planning

    This error can be caused by a couple of things -- either the browser is not clearing the cache, or they are using the browser BACK button when they should be using the ePrint navigation bar. The only time that the browser BACK button should be used is to get back from reading a pdf report from within the browser. Have them clear the cache.

  4. When a person is in a report in ePrint and they click the back button, they get: "Page has expired." If they click the back button again, it goes back to the ePrint menu. Any suggestions? Should they reload Adobe Acrobat Reader? It works fine for me.

    If a user is using Internet Explorer (IE), it is better to open Adobe outside of the browser. Also, if the user is using https to access the reports, the problem may be because of a security precaution in IE relating to encrypted pages. To eliminate this message, try this: In IE go to Tools -> Internet Options. Under the Advanced tab, deselect "Do not save encrypted pages to disk". Once this option is no longer selected, the warning message should go away.

  5. This report has parsed fine about a dozen times but today it has failed. I have checked the report on the mainframe against the report definition and cannot see anything wrong. The log message is: "Thu May 20 08:41:02 2004 parse.pl: Exiting, reached end of file while skipping pages in REPORT1."

    This would lead me to believe that we have a problem with the pages we are skipping (1-3). I have tried both FOCUS_VMS and IBM_GENERIC for TOP OF FORM with the same results. I tried changing the number of pages we skipped to 2 rather than 3 but then it could not find the VERIFY STRING, which is what I would expect if it were counting the pages correctly. I don't know what to try next. The log message is stating that there are only 3 pages on the report, so there is nothing to parse once we get rid of the 3 junk pages.

    Unless the report is being generated differently, or is coming from a different source, there should be no need to change this setting in the report definition. So you will want to set it to your original "Top Of Form" value.

    ePrint looks for the VERIFY STRING on the first page of the report (after getting rid of the junk pages). Since you are getting rid of two pages, we look on the third page for the verify string and the value "PAGE" is not on the page, so the verification fails. What you should be able to do is set junk pages to 1, and then "PAGE" should be found since it is on the what is now the first page (actually Page 2, but ePrint gets rid of 1). It looks as though you may have to adjust the location in the report definition, since "PAGE 2" doesn't appear to be in the same column as "PAGE 1."

  6. A report from Banner, FABCHKR, in the fin_devl respository cannot be parsed. The error we get is:

    parse.pl: Reached end of page, verify string not found: Report: FABCHKR; Looking for: 'FABCHKR'

    We tried changing the column and the row, but that did not work. Any ideas? Should we just give up and delete this report from the error queue?

    You are receiving that message because there is a blank line before the first page delimiter (page break) on the report. When ePrint finds the blank line, it considers it a page. Then it finds the control character and treats that as a page break, and it handles the proceeding lines as page 2 data. To get the report to parse correctly, either define a junk page to get rid of the first page (page that contains just the blank line) or eliminate that blank line when the report is generated.

  7. I had two people call with the following error:

    "There are no pages for you to view on this report. If you think this is an error, contact your ePrint administrator. Otherwise, return to ePrint and select another report."

    Even though a user has access to a report, there may be no data on the report for them to look at. This may occur when a report is controlled by value-based security. One month they have pages to view but next month there is no activity, so there are no pages for them to view.

  8. Our payroll repository administrator sees this message repeatedly in the Report Parser log:

    Tue Jul 6 14:00:26 2004 parse.pl: Warning: Unable to remove sortkey file
    Tue Jul 6 14:00:27 2004 parse.pl: Successful parse of report REPT246

    He notes that he always gets the message and it does not seem to interfere with the report creation. He adds that his indexing, based on the department number, is not working but he thinks that is due to an error in the way he has it set up. The sortkey error is in the online list of report parser log messages.

    There are duplicate page keys defined for this report. There are two DEPT at level 0.

  9. I noticed this in the log this morning

    Sat Aug 28 12:01:00 2004 parse.pl: Warning: page too long on 1 pages for report BBD120.
    Sat Aug 28 12:01:00 2004 parse.pl: Successful parse of report BBD120

    Is there any way to determine which page this occurred on other than a manual comparison?

    That information is not logged. It is a warning only. When reports are created they will be created based on a certain number of lines per page. The number of lines per page is recorded in the report definition file. If you received this warning, I recommend that you increase the value for the number of lines per page in the report definition.

  10. We use ePrint in our automated nightly process. Last night a file was sent to ePrint but ePrint did not parse it. I checked the INCOMING log and we did have an error when the file was being parsed. I need to know what caused the error so we can prevent it. Here is the portion of the INCOMING log with the error:

    Fri Sep 10 01:10:05 2004 PRODUCTION: Starting Parser: bbd120
    Fri Sep 10 01:11:01 2004 PRODUCTION: Could not get lock on repository: PRODUCTION
    Fri Sep 10 01:12:00 2004 PRODUCTION: Could not get lock on repository: PRODUCTION
    Fri Sep 10 01:13:01 2004 PRODUCTION: Could not get lock on repository: PRODUCTION
    Fri Sep 10 01:13:30 2004 PRODUCTION: Parser successful.

    This message is not an error. This message was displayed because it took over one minute to parse a report (bbd120). When ePrint parses a report the repository is placed in a "locked" state. The parser will "wake" after one minute to see if there is something to do. Since the report was still parsing, ePrint displayed the message. This will continue until the parsing is complete. This condition only exists when a large report is sent. The report parsed successfully.

  11. With the identical report, I get an error message when I use a Banner repository but not when I use the MVS repository. Here is my scenario: I created a new repository and named it findevl, which is a Banner finance repository. I then copied the report definitions from the mvstest repository. I FTP'd the reports to the new repository and they were loaded correctly from what I can see, but the "DATA" portion did not appear as it does on the original mvstest repository. Shouldn't both repositories show the same information?

    The incoming log stated the following:

    FINDEVL: Starting Parser: FRSP0921
    FINDEVL: Could not get lock on repository: FINDEVL
    FINDEVL: Could not get lock on repository: FINDEVL
    FINDEVL: Parser successful.
    FINDEVL: Starting Parser: FRSP0922
    FINDEVL: Could not get lock on repository: FINDEVL
    FINDEVL: Could not get lock on repository: FINDEVL
    FINDEVL: Parser successful.
    FINDEVL: Starting Parser: FRSP0922
    FINDEVL: Parser successful.

    The DATA icon will only appear if you define CSV parsing for that report. When you use a report definition from one repository as a template for that same report in another repository, ePrint will just copy the report definition. If you want the DATA icon you can copy the CSV definition from the MVS repository as a template for the new FINDEVL CSV definition. The CSV definition is totally separate from the report definition.

  12. Can someone tell me what the parser message, "Unable to remove sortkey file" means? I get the message, "Successful parse of report fgrctrl" after the warning message.

    In your report definition for FGRCTRL, you have two page keys defined and both are level 0. The page keys are for acct and account (both of these are used in FRS but not Banner). You may have these left from either the default or you copied the definition from an FRS report and didn't change it. Make sure you have the correct page defined because you are trying to use VBS and it won't work without the correct page key defined.

  13. A report was created last night, but had not been defined. After the report was defined this morning, the system tried to parse the report. We got this error:

    6 09:33:01 2004 SIS: Starting Parser: bc220044
    6 09:34:02 2004 SIS: Could not get lock on repository: SIS
    6 09:35:02 2004 SIS: Could not get lock on repository: SIS
    6 09:36:01 2004 SIS: Could not get lock on repository: SIS

    The parse has not ended and we continue to get these error messages.

    In the future, remember not to FTP a report file (or at least not the .done) until after the report definition has been completed.

  14. I have encountered an error when sending the security file to ePrint:

    220 eprint.nnn.edu FTP server (Version wu-2.6.1-20) ready.
    Connected to 192.154.33.232.
    331 Password required for frss.
    230 User frss logged in. Access restrictions apply.
    200 PORT command successful.
    553 zwoffl: Permission denied on server. (Overwrite)
    221-You have transferred 0 bytes in 0 files.
    221-Total traffic for this session was 389 bytes in 0 transfers.
    221 Thank you for using the FTP service on eprint.nnn.edu.

    Since this file is failing, I have not tried to send the FWOAFL file. In referencing a past event, you suggested deleting and re-defining a file that returned this "permission" type error. Are there any implications with re-defining the ZWOFFL or FWOAFL files? Is this even possible, since it is an FRSS user file?

    The message that you received on the FTP step, zwoffl: Permission denied on server (Overwrite), means that the ZWOFFL file already exists in the security incoming directory of this repository. To move the new ZWOFFL file into the correct repository/directory, delete the existing ZWOFFL file in ePrint. To do this:
    1. Log in as the Administrator
    2. Go to Security Incoming, located under the File Maintenance heading
    3. On the Security Incoming Directory page, highlight the file (ZWOFFL)
    4. Click the delete button. You will be asked to confirm the delete. Click OK

  15. We are having trouble transferring the FWOAFL and the accompanying VBS.DONE file to our ePrint server. The ePrint parser is not processing the files. Here is the error we receive:

    securityload.pl: Unable to open input file FWOAFL, No such file or directory

    When loading security, you need to send at least four files: ZWOFFL (the output from ZBPS10), the authentication.done, FWOAFL (output from FBPS10, if FRS VBS is used) and vbs.done. Make sure you have all four and try it again.

  16. I am getting the following message:

    "File does not begin with '%pdf-" when trying to access the report from E-mail URL.

    If you are using Internet Explorer (IE) as your default browser, be sure to configure Adobe Reader to open outside of the browser. There are known problems with the Adobe/IE plug-in that occasionally causes a dynamically built pdf to not open correctly

  17. We have transferred the FRS A/P User's Guide to our Programmer's repository. ePrint processed the file for us, but when we try to look at the pdf we get the following message:

    "Object label badly formatted"

    Is there something we did to the file as we FTP'd it?

    When you FTP'd the pdf file you should use Binary, not ACSII.

  18. An end-user with Windows and Internet Explorer said she has been getting this message since last week whenever she tries to log in. The user account seems to be okay.

    /home/eprint/cgi-bin/../prod/repository/frs/config/.xml not found, not readable, or not writable at
    /home/eprint/cgi-bin/../code/Pinnacle/UIGetreport.pm line 684.

    This message could be caused by a couple of things. First, cache is not being cleared in the browser. Clear cache and see is the message still displays. Second, the user is using the browser BACK button instead of the navigation bar within ePrint. If this is the case, use the navigation bar and the message should stop appearing.

File Definition Help
  1. I sent a report to my test repository, after which I created the report definition. The definition appears to be proper and the report name appears to be correct in the incoming area; however, the report parser does not appear to be trying to parse the report. Any suggestions?

    The parser got hung up on the report. This happened because the report definition was created while the report was already in the incoming directory with its corresponding .done file. In the future, you will want to set up the report definition before sending the files, or you will want to hold off on sending the .done file until you have the report definition created.

  2. Can someone tell me what the parser message, "Unable to remove sortkey file" means? I get the message, "Successful parse of report fgrctrl" after the warning message.

    In your report definition for FGRCTRL, you have two page keys defined and both are level 0. The page keys are for acct and account (both of these are used in FRS but not Banner). You may have these left from either the default or you copied the definition from an FRS report and didn't change it. Make sure you have the correct page defined because you are trying to use VBS and it won't work without the correct page key defined.

  3. We have several non-Banner report definitions with 15-character names. Is there a limit on the length of report definition name? It seems that the report definition is limited to the length of the Create New File name box. Is this right?

    The limit on the Report Definition Name is 30 characters. The limit for the Label and Description are both 60 characters.

  4. How do I get a pdf file into ePrint?

    Defining a pdf to be loaded into ePrint is similar to defining any other report in ePrint. Log in as an administrator; go to "Report Definitions" under "Report Tasks." "Create" a new definition. Once you are in the report definition wizard, enter a "Label" (optional), a "Description," and a "Filename" (optional). Next, toggle the "Input File Format" to "pdf." Then you will just need to FTP the report to the ePrint server with it's corresponding.done file. When FTPing a pdf to the ePrint server, be sure to use binary mode, otherwise the pdf may become corrupted during the file transfer.

  5. Our Finance person is for the first time starting to enter ePrint report objects into GSASECR form. An example of our report names is "fn04_telecomm." Our entry person believes he can only enter an 8-character code for new object name, for example, a.Banner encumbrance report is FGROPNE.

    Banner objects do have a character limit. If you are using the auto FTP you will need to follow the naming conventions in Banner. If it is a legacy report, in Banner you can assign an object name to the report, in ePrint create a report definition with the same object name, and in the report definition add the report file name. The report .done file that is FTP to ePrint will need to match the report configuration name or the Banner object name.

File name Help
  1. Are file names case sensitive?

    Yes, file names are case sensitive. By default, if you do not specify a file name in your report definition, then ePrint assumes that the file name that will be sent over for the corresponding report definition will be lowercase. Otherwise, whatever you specify in the report definition for the "Filename" (upper or lowercase), is what you should name the file that you send to the ePrint server.

  2. Do all report files go to the "incoming" folder first, even if a report definition does not exist for the file? If so, do they remain there indefinitely awaiting the creation of a definition?

    Yes, all reports go into the incoming directory of the repository. If no report definition uses that file name, then the file will remain in the incoming directory until you take some action -- either delete the file or rename it. A file in the incoming directory with no definition will cause ePrint to lock the repository. If you try to define the report any further processing will be halted. The recommendation would be to rename the file in the incoming directory, define the report, and then rename the file to its original name.

  3. In FTPing a report to ePrint, the report did not parse on the ePrint server. Is it because the file name is different from the report definition?

    The report did not parse for two reasons -- the file name, and the missing .done file. The report name should match the report definition, which is fgrbdsc. Also, the parser will not start until there is a fgrbdsc.done file in the incoming directory. The auto FTP process will automatically rename the fgrbdsc_6302.lis to fgrbdsc and also create and FTP the fgrbdsc.done file.

  4. I received a request to copy over 3 files to the ePrint server. I have copied over the fgrbdsc and one of the fgrodta files the user created. I am trying to copy over the third file, which is another fgrodta file only much larger. I don't have an error in the Report Incoming Error, but I can see the fgrodta.lis and fgrodta.done files in the Reports Incoming. Can you explain to me what is wrong with this report?

    In the report definition for fgrodta, the file name is "fgrodta," so that is what ePrint is looking for. Rename fgrodta.lis to fgrodta and you should be all set.

  5. Some folks want to enhance our current reports. Here are some of the questions that have been raised:

    Within the ePrint interface they would like to change from using the report identifier name in the report column, e.g., fgrbdsc, and call it Finance - Budget Status. The manual states that there should be no spaces and the admin interface states that this field is optional. I changed the report label and the change worked. What are the restrictions for using no spaces and how many characters are allowed?

    How many characters are allowed for the report description field?

    When an end-user logs on to ePrint they are presented the "Repository List," the list of reports that the user can view. For each report, this information is displayed:
    REPORT - The value of the LABEL from the report definition.
    DESCRIPTION - The description from the report definition.
    When they drill down on a specific report, then the title of the report is displayed. This comes from the location defined in the report definition. As an administrator, you can change the LABEL value at any time. This field can include spaces and is 60 characters long. The report description field is 60 characters long.

  6. I sent files named 'sisuser' and 'sisunit' to ePrint and used the same names in the security VBS setup. It looks like ePrint expects to see a file with a different name. Here's my error message:

    Cannot open file '/home/eprint/cgi-bin/../prod/repository/test/security/user.vbs': No such file or directory

    Also, I have two new VBS security files sitting in the Security Incoming Directory and they aren't moving. Can you tell me why they are still sitting there, and why the first one shows no data when there are five lines.

    Are you receiving this error when you try to open the report? The page keys defined in the report definition must match the VBS values that you use in the security VBS setup. In other words, in the report definition you will either have to use "sisuser" for the page key value, or use "user" in the security VBS setup.

    As for the reports sitting in the Security Incoming Directory, the security loader also needs an "authentication.done" file. Once it is there, the security files should process.

  7. How do I get a pdf file into ePrint?

    Defining a pdf to be loaded into ePrint is similar to defining any other report in ePrint. Log in as an administrator; go to "Report Definitions" under "Report Tasks." "Create" a new definition. Once you are in the report definition wizard, enter a "Label" (optional), a "Description," and a "Filename" (optional). Next, toggle the "Input File Format" to "pdf." Then you will just need to FTP the report to the ePrint server with it's corresponding.done file. When FTPing a pdf to the ePrint server, be sure to use binary mode, otherwise the pdf may become corrupted during the file transfer.

  8. Our Finance person is for the first time starting to enter ePrint report objects into GSASECR form. An example of our report names is "fn04_telecomm." Our entry person believes he can only enter an 8-character code for new object name, for example, a.Banner encumbrance report is FGROPNE.

    Banner objects do have a character limit. If you are using the auto FTP you will need to follow the naming conventions in Banner. If it is a legacy report, in Banner you can assign an object name to the report, in ePrint create a report definition with the same object name, and in the report definition add the report file name. The report .done file that is FTP to ePrint will need to match the report configuration name or the Banner object name.

FTP Help
  1. Once I create the report definition and FTP it to ePrint without assigning it to a particular group it automatically defaults to the USERS group, which could pose a problem keeping information confidential.

    To get around this you need to assign a report to a group BEFORE parsing the report. Once you have created a report definition you can easily assign the report to a group, then FTP the report. If the report is assigned to something, it will not go to the default (USERS) group.

  2. Currently my ePrint server does not have a CD burner. Can I archive to a file locally and then FTP that file to one of my servers with a CD burner?

    This is what you can do:
    Create an archive as you normally would.
    Log into the ePrint server with the eprintop login.
    Select the archive set that you want.
    Continue as you normally would.
    The reports will be generated, but the process will error because there is no burner. There will be a file in /scratch/image/ called "test1.raw"

    This will be the image you will want to burn. Transfer the file to another machine, then burn the image to CD.

  3. In FTPing a report to ePrint, the report did not parse on the ePrint server. Is it because the filename is different from the report definition?

    The report did not parse for two reasons -- the file name, and the missing .done file. The report name should match the report definition, which is fgrbdsc. Also, the parser will not start until there is a fgrbdsc.done file in the incoming directory. The auto FTP process will automatically rename the fgrbdsc_6302.lis to fgrbdsc and also create and FTP the fgrbdsc.done file.

  4. With the identical report, I get an error message when I use a Banner repository but not when I use the MVS repository. Here is my scenario: I created a new repository and named it findevl, which is a Banner finance repository. I then copied the report definitions from the mvstest repository. I FTP'd the reports to the new repository and they were loaded correctly from what I can see, but the "DATA" portion did not appear as it does on the original mvstest repository. Shouldn't both repositories show the same information?

    The incoming log stated the following:

    FINDEVL: Starting Parser: FRSP0921
    FINDEVL: Could not get lock on repository: FINDEVL
    FINDEVL: Could not get lock on repository: FINDEVL
    FINDEVL: Parser successful.
    FINDEVL: Starting Parser: FRSP0922
    FINDEVL: Could not get lock on repository: FINDEVL
    FINDEVL: Could not get lock on repository: FINDEVL
    FINDEVL: Parser successful.
    FINDEVL: Starting Parser: FRSP0922
    FINDEVL: Parser successful.

    The DATA icon will only appear if you define CSV parsing for that report. When you use a report definition from one repository as a template for that same report in another repository, ePrint will just copy the report definition. If you want the DATA icon you can copy the CSV definition from the MVS repository as a template for the new FINDEVL CSV definition. The CSV definition is totally separate from the report definition.

  5. I am attempting to FTP a pdf file from my PC to ePrint. I have Ftp'd the pdf file to Test-SIS repository along with a .done file. I had created a report definition for this with the new pdf as input. The file is still sitting in the report incoming directory. What have I setup wrong? The reports are called das.pdf and das.done. My report definition is das. (These are just practice files.)

    The .done file name should be das.pdf.done. I changed it in your report incoming directory and the report parsed fine. The .done file should be the report file name.done; for example, report.file > report.file.done.

  6. One of our users is going through a process whereby she uses multiple Internet Native Banner forms (~5), one after the other. Each Form creates an ePrint defined report which is then sent to a Banner printer defined for the ePrint repository. Only the first and the last of the reports show up in the ePrint repository. Any idea what is causing this?

    Are all the forms producing the same report name? If so, that is the problem. You produce the report and send it to the print queue. While the second one is being produced, the first one is being FTP'd to ePrint. The FTP function will not send another report by the same name until the current one (report #1) has parsed completely. This would explain why the first and last are in ePrint. Is there anything in the ePrint print queue on the Banner server? If you are running the same report, you need to delay the FTP so each instance can be parsed individually in ePrint.

  7. I created a pdf file and set it up in ePrint, which I really like. Can I FTP the pdf from my desktop to the ePrint server? I copied the pdf to my UNIX account on our database and put it on the ePrint server using FTP. It worked, but this seems like a lot to get a pdf file to the ePrint server.

    The ePrint server allows an FTP only from the hosts we have defined on the server. If you give us your IP address, we can make sure that the ePrint server will accept FTP traffic from it. Then you will be able to FTP directly from your desktop to the ePrint server. FYI: When transferring pdfs to the ePrint server, make sure that you use binary file transfers, not ASCII.

  8. Is it possible to have multiple FTP users for one repository?

    No, there is only one FTP User/Password per repository, but you may use the user/password from multiple locations to ePrint. I'm assuming you want to send reports from more than one location? If so, they can all use the same FTP User ID. This should work fine as long as they are not all sending the same report at the same time.

  9. I am trying to route an output report file from a foreign MVS system to my ePrint server via FTP. Security will not allow me access to my ePrint server to pass the information. Any suggestions?

    The reason that you can't FTP to the server is because the server will only allow certain IP addresses to FTP to it. If you send us the IP address of the machine where you FTP from, we can add that to the server.

  10. A report was created last night, but had not been defined. After the report was defined this morning, the system tried to parse the report. We got this error:

    6 09:33:01 2004 SIS: Starting Parser: bc220044
    6 09:34:02 2004 SIS: Could not get lock on repository: SIS
    6 09:35:02 2004 SIS: Could not get lock on repository: SIS
    6 09:36:01 2004 SIS: Could not get lock on repository: SIS

    The parse has not ended and we continue to get these error messages.

    In the future, remember not to FTP a report file (or at least not the .done) until after the report definition has been completed.

  11. What software is normally used to FTP to ePrint and where do you specify the repository and report definition? When sending a pdf file to ePrint, you can use FTP (or SFTP) software. Whether you use FTP or SFTP software, the repository is determined by the FTP ID/password used in the FTP process, and the report definition is determined by the file name sent to ePrint.

    If you you establish the FTP connection from a PC, you will use the FTP ID/password (from the repository initialization) and send the pdf file and the .done file. When sending a pdf file, send it in binary mode not ACSII. The ePrint server will need the IP address of the PC defined so the FTP transfer can take place. The process of sending a pdf file is the same as sending any other report to ePrint.

  12. I have encountered an error when sending the security file to ePrint:

    220 eprint.nnn.edu FTP server (Version wu-2.6.1-20) ready.
    Connected to 192.154.33.232.
    331 Password required for frss.
    230 User frss logged in. Access restrictions apply.
    200 PORT command successful.
    553 zwoffl: Permission denied on server. (Overwrite)
    221-You have transferred 0 bytes in 0 files.
    221-Total traffic for this session was 389 bytes in 0 transfers.
    221 Thank you for using the FTP service on eprint.nnn.edu.

    Since this file is failing, I have not tried to send the FWOAFL file. In referencing a past event, you suggested deleting and re-defining a file that returned this "permission" type error. Are there any implications with re-defining the ZWOFFL or FWOAFL files? Is this even possible, since it is an FRSS user file?

  13. I have Banner documentation in pdf format that I want to FTP to ePrint and make available to users. These pdf files are on my hard drive. Is it possible to FTP them to ePrint through my PC?

    Yes, you can FTP the files from your PC to the ePrint server. We would need the IP address of your PC and put that on the server as an address that can FTP to the server. When sending over pdf files, be sure to transfer them using "binary" mode which should be an option with your FTP client. Otherwise, the file may become corrupted and display incorrectly.

INB (Internet-native Banner) Help
  1. Does a user have to be set up as an INB user to have ePrint do report authorization to ensure only specific reports are seen? We had been planning on just setting users as SSB (Self-Service Banner.)

    The user will need to be set up as an Internet Native Banner user if you are going to be using Self-Service. Refer to chapter 6 of the Banner ePrint Integration Guide for more information.

Incoming Help
  1. Do all report files go to the "incoming" folder first, even if a report definition does not exist for the file? If so, do they remain there indefinitely awaiting the creation of a definition?

    Yes, all reports go into the incoming directory of the repository. If no report definition uses that file name, then the file will remain in the incoming directory until you take some action -- either delete the file or rename it. A file in the incoming directory with no definition will cause ePrint to lock the repository. If you try to define the report any further processing will be halted. The recommendation would be to rename the file in the incoming directory, define the report, and then rename the file to its original name.

  2. We use ePrint in our automated nightly process. Last night a file was sent to ePrint but ePrint did not parse it. I checked the INCOMING log and we did have an error when the file was being parsed. I need to know what caused the error so we can prevent it. Here is the portion of the INCOMING log with the error:

    Fri Sep 10 01:10:05 2004 PRODUCTION: Starting Parser: bbd120
    Fri Sep 10 01:11:01 2004 PRODUCTION: Could not get lock on repository: PRODUCTION
    Fri Sep 10 01:12:00 2004 PRODUCTION: Could not get lock on repository: PRODUCTION
    Fri Sep 10 01:13:01 2004 PRODUCTION: Could not get lock on repository: PRODUCTION
    Fri Sep 10 01:13:30 2004 PRODUCTION: Parser successful.

    This message is not an error. This message was displayed because it took over one minute to parse a report (bbd120). When ePrint parses a report the repository is placed in a "locked" state. The parser will "wake" after one minute to see if there is something to do. Since the report was still parsing, ePrint displayed the message. This will continue until the parsing is complete. This condition only exists when a large report is sent. The report parsed successfully.

  3. I sent a report to my test repository, after which I created the report definition. The definition appears to be proper and the report name appears to be correct in the incoming area; however, the report parser does not appear to be trying to parse the report. Any suggestions?

    The parser got hung up on the report. This happened because the report definition was created while the report was already in the incoming directory with its corresponding .done file. In the future, you will want to set up the report definition before sending the files, or you will want to hold off on sending the .done file until you have the report definition created.

  4. I received a request to copy over 3 files to the ePrint server. I have copied over the fgrbdsc and one of the fgrodta files the user created. I am trying to copy over the third file, which is another fgrodta file only much larger. I don't have an error in the Report Incoming Error, but I can see the fgrodta.lis and fgrodta.done files in the Reports Incoming. Can you explain to me what is wrong with this report?

    In the report definition for fgrodta, the file name is "fgrodta," so that is what ePrint is looking for. Rename fgrodta.lis to fgrodta and you should be all set

  5. I am attempting to FTP a pdf file from my PC to ePrint. I have Ftp'd the pdf file to Test-SIS repository along with a .done file. I had created a report definition for this with the new pdf as input. The file is still sitting in the report incoming directory. What have I setup wrong? The reports are called das.pdf and das.done. My report definition is das. (These are just practice files.)

    The .done file name should be das.pdf.done. I changed it in your report incoming directory and the report parsed fine. The .done file should be the report file name.done; for example, report.file > report.file.done.

  6. I sent a report to my test repository, after which I created the report definition. The definition appears to be proper and the report name appears to be correct in the incoming area; however, the report parser does not appear to be trying to parse the report. Any suggestions?

    The parser got hung up on the report. This happened because the report definition was created while the report was already in the incoming directory with its corresponding .done file. In the future, you will want to set up the report definition before sending the files, or you will want to hold off on sending the .done file until you have the report definition created.

Junk Page Help
  1. This report has parsed fine about a dozen times but today it has failed. I have checked the report on the mainframe against the report definition and cannot see anything wrong. The log message is: "Thu May 20 08:41:02 2004 parse.pl: Exiting, reached end of file while skipping pages in REPORT1."
    This would lead me to believe that we have a problem with the pages we are skipping (1-3). I have tried both FOCUS_VMS and IBM_GENERIC for TOP OF FORM with the same results. I tried changing the number of pages we skipped to 2 rather than 3 but then it could not find the VERIFY STRING, which is what I would expect if it were counting the pages correctly. I don't know what to try next. The log message is stating that there are only 3 pages on the report, so there is nothing to parse once we get rid of the 3 junk pages.

    Unless the report is being generated differently, or is coming from a different source, there should be no need to change this setting in the report definition. So you will want to set it to your original "Top Of Form" value.

    ePrint looks for the VERIFY STRING on the first page of the report (after getting rid of the junk pages). Since you are getting rid of two pages, we look on the third page for the verify string and the value "PAGE" is not on the page, so the verification fails. What you should be able to do is set junk pages to 1, and then "PAGE" should be found since it is on the what is now the first page (actually Page 2, but ePrint gets rid of 1). It looks as though you may have to adjust the location in the report definition, since "PAGE 2" doesn't appear to be in the same column as "PAGE 1."

  2. A report from Banner, FABCHKR, in the fin_devl repository cannot be parsed. The error we get is:
    parse.pl: Reached end of page, verify string not found: Report: FABCHKR; Looking for: 'FABCHKR'
    We tried changing the column and the row, but that did not work. Any ideas? Should we just give up and delete this report from the error queue?

    You are receiving that message because there is a blank line before the first page delimiter (page break) on the report. When ePrint finds the blank line, it considers it a page. Then it finds the control character and treats that as a page break, and it handles the proceeding lines as page 2 data. To get the report to parse correctly, either define a junk page to get rid of the first page (page that contains just the blank line) or eliminate that blank line when the report is generated.

  3. I defined FGLTRNR log and was able to send it to the ePrint server. When I view it in the STORED REPORTS area, I can see the report name. When I open it, there is no information. It should not be blank. What am I missing?

    The report contains only one page of data and you have it defined with the last page as a junk page. ePrint is removing the last page, which in this case happens to also be the first page, and this leaves you with no pages. Remove the junk page and you should be all set.

  4. The problem I am having is that the 1st page of FAM reports puts an extra line at the top of the report. Therefore the FAM reports do not work because each subsequent page the unique identified (SBA590) is on line 3 but on line 4 on page 1. We used another report we have as a template for this one.

    Define the report with a junk page of type = LINES and Line = 1. ePrint will ignore the first line of the report. A number of the FAM reports place a page break before the first page, which causes problems in ePrint. This is not a "known issue," but just the way FAM reports are formatted. If the reports are printed, there is no problem. This is something that you will need to be aware of when defining FAM reports to ePrint. The FAM ActionLine looked into a change, but the effort was too great and would affect all of FAM.

Login Help
  1. A user might have tried to login too many times and the system logged her out. How can I unlock her ID, or is it an auto time out?

    If a user tries to login and is not successful after five attempts, that ID will be locked. To unlock the ID, go to the "Users" page on the Administrator Interface, type in the ID (or use the clipboard to find the ID). Click the "edit" button and click the "unlock" button. The user will now be able to log in.

  2. Our Provost is having a problem viewing a .pdf file in ePrint, regardless of who logs in. The system will let you initially log in and go to the listing of viewable reports, but once you click the pdf icon it kicks you out to the login screen. He can view other pdf files in other applications. Can you suggest anything for us to check?

    Have him clear the cache in his browser and try again. This normally will resolve the problem.

  3. I am signing on using the normal "admin" account that was set up by you, but cannot see a way to set up a new administrator. This person will not be a repository admin, but an overall system administrator as myself. Should I be signing on a different way?

    There is only one Super Administrator ID in ePrint. More than one person can use that ID/Password.

  4. I was wondering is there a way to open more than one screen and compare the reports from different repository at the same time?

    You can open ePrint in another browser window and compare the reports. This means that you would be logged in twice.

Logo Help
  1. How do we add our school logo to our ePrint server?

    We can add the logo -- all you need to do is send us a .gif file with the logo that you want to use.

Missing Report Help
  1. I have emails for reports that failed to parse on 9/14. When I go to the Report Parser for this week it starts with 9/15, last week's ends with 9/13. Where are the log entries for 9/14?

    Change the number of lines to display to something like 999. You will see all the entries in the log. The display on the log files is the last x number of lines, where x is the number from the page (default is 100).

  2. I sent a report to ePrint that had been previously defined and stored. I got a log that says everything is fine, yet this report is not being stored where the other reports have been stored. I checked the parser, the error section, and can find no problems. The report is identical to past runs, but it simply dropped out of sight! I have looked at the report and ePrint definition and can see no errors. Nor has anyone changed this report or its definition since it was run last. Any suggestions?

    In looking at the reports, they are filed under 09/04/2003 but the report date is 02/09/04. When I compared these reports against the last "good one" (1/29/04), I noticed that the report is different. The "good" reports have on the heading line, DATE RUN: nn/nn/nn; the reports in question had, DATE:nn/nn/nn.

    The date is in a different place, that's why they are not listed under the correct date. Change the date setting on the report definition in ePrint or on the heading of the report.

  3. One of our users is going through a process whereby she uses multiple Internet Native Banner forms, one after the other. Each Form creates an ePrint defined report which is then sent to a Banner printer defined for the ePrint repository. Only the first and the last of the reports show up in the ePrint repository. Any idea what is causing this?

    Are all the forms producing the same report name? If so, that is the problem. You produce the report and send it to the print queue. While the second one is being produced, the first one is being FTP'd to ePrint. The FTP function will not send another report by the same name until the current one (report #1) has parsed completely. This would explain why the first and last are in ePrint. Is there anything in the ePrint print queue on the Banner server? If you are running the same report, you need to delay the FTP so each instance can be parsed individually in ePrint.

Page break Help
  1. 1. The problem I am having is that the 1st page of FAM reports puts an extra line at the top of the report. Therefore the FAM reports do not work because on each subsequent page the unique identifier (SBA590) is on line 3 but on line 4 on page 1. We used another report we have as a template for this one.

    Define the report with a junk page of type = LINES and Line = 1. ePrint will ignore the first line of the report. A number of the FAM reports place a page break before the first page, which causes problems in ePrint. This is not a "known issue," but just the way FAM reports are formatted. If the reports are printed, there is no problem. This is something that you will need to be aware of when defining FAM reports to ePrint. The FAM ActionLine looked into a change, but the effort was too great and would affect all of FAM.

Page Key Help
  1. I have two questions when setting up Page Keys and using Type=SCAN in the Report Definition section of ePrint. (1) When selecting Type = SCAN, will it start from Line 1, Position 1, and scan left to right and then down each line until it finds the 1st SCAN FOR VALUE, which then becomes the key index for that page? (2) Once it finds the first match, does it continue scanning on the same page?

    Yes, when using Type = SCAN, it will start at the top of the page (Line 1, Position 1) and proceed as you have described. Once it finds that value, it will use that for the page key, and will not look for that value again until it gets to a new page. Only one occurrence of the page key is indexed per page.

  2. On p. 2 of the Finance report, FGRBDSC, for a particular Fund/Org, the report does not repeat the Fund/Org at the top of the page. So when ePrint reads the data, it drops this page from what is displayed in ePrint.

    To find this patch (66653 version 5.4.0.1), in Action Web, go to Extended Search and query on Known Issues. Select Banner Finance, status Posted, and process FGRBDSC. You will see this defect listed.
    Also, you may go to Downloads, select Banner Finance and List Releases. Select your release (5.4) and List Files. The first file listed is always contents.txt. This is a combination of all the text for all the posted defects for that release. If you open contents.txt and search for your process name, you will find all patches that reference this process. Or you can search for patch 6653 and download the patch directly.

Parser Help
  1. How often does the parser run?

    A script is run every minute to check if there are any reports to parse. If it finds any reports that need parsing the parser starts and processes the reports.

  2. I get the following message in the Incoming log and reports are in Reports Incoming. Please help!
    SCH: Could not get lock on repository: SCH

    You sent the report and the .done file before you created the report definition file. This caused the parser to go into a loop. We stopped the parser and you will have to re-send the report and .done files.

  3. Once I create the report definition and FTP it to ePrint without assigning it to a particular group it automatically defaults to the USERS group, which could pose a problem keeping information confidential.

    To get around this you need to assign a report to a group BEFORE parsing the report. Once you have created a report definition you can easily assign the report to a group, then FTP the report. If the report is assigned to something, it will not go to the default (USERS) group.

  4. This report has parsed fine about a dozen times but today it has failed. I have checked the report on the mainframe against the report definition and cannot see anything wrong. The log message is: "Thu May 20 08:41:02 2004 parse.pl: Exiting, reached end of file while skipping pages in REPORT1."
    This would lead me to believe that we have a problem with the pages we are skipping (1-3). I have tried both FOCUS_VMS and IBM_GENERIC for TOP OF FORM with the same results. I tried changing the number of pages we skipped to 2 rather than 3 but then it could not find the VERIFY STRING, which is what I would expect if it were counting the pages correctly. I don't know what to try next. The log message is stating that there are only 3 pages on the report, so there is nothing to parse once we get rid of the 3 junk pages.

    Unless the report is being generated differently, or is coming from a different source, there should be no need to change this setting in the report definition. So you will want to set it to your original "Top Of Form" value.

    ePrint looks for the VERIFY STRING on the first page of the report (after getting rid of the junk pages). Since you are getting rid of two pages, we look on the third page for the verify string and the value "PAGE" is not on the page, so the verification fails. What you should be able to do is set junk pages to 1, and then "PAGE" should be found since it is on the what is now the first page (actually Page 2, but ePrint gets rid of 1). It looks as though you may have to adjust the location in the report definition, since "PAGE 2" doesn't appear to be in the same column as "PAGE 1."

  5. A report from Banner, FABCHKR, in the fin_devl repository cannot be parsed. The error we get is:
    parse.pl: Reached end of page, verify string not found: Report: FABCHKR; Looking for: 'FABCHKR'
    We tried changing the column and the row, but that did not work. Any ideas? Should we just give up and delete this report from the error queue?

    You are receiving that message because there is a blank line before the first page delimiter (page break) on the report. When ePrint finds the blank line, it considers it a page. Then it finds the control character and treats that as a page break, and it handles the proceeding lines as page 2 data. To get the report to parse correctly, either define a junk page to get rid of the first page (page that contains just the blank line) or eliminate that blank line when the report is generated.

  6. In FTPing a report to ePrint, the report did not parse on the ePrint server. Is it because the filename is different from the report definition?

    The report did not parse for two reasons -- the file name, and the missing .done file. The report name should match the report definition, which is fgrbdsc. Also, the parser will not start until there is a fgrbdsc.done file in the incoming directory. The auto FTP process will automatically rename the fgrbdsc_6302.lis to fgrbdsc and also create and FTP the fgrbdsc.done file.

  7. Our payroll repository administrator sees this message repeatedly in the Report Parser log:

    Tue Jul 6 14:00:26 2004 parse.pl: Warning: Unable to remove sortkey file
    Tue Jul 6 14:00:27 2004 parse.pl: Successful parse of report REPT246

    He notes that he always gets the message and it does not seem to interfere with the report creation. He adds that his indexing, based on the department number, is not working but he thinks that is due to an error in the way he has it set up. The sortkey error is in the online list of report parser log messages.

    There are duplicate page keys defined for this report. There are two DEPT at level 0.

  8. I noticed this in the log this morning

    Sat Aug 28 12:01:00 2004 parse.pl: Warning: page too long on 1 pages for report BBD120.
    Sat Aug 28 12:01:00 2004 parse.pl: Successful parse of report BBD120

    Is there any way to determine which page this occurred on other than a manual comparison?

    That information is not logged. It is a warning only. When reports are created they will be created based on a certain number of lines per page. The number of lines per page is recorded in the report definition file. If you received this warning, I recommend that you increase the value for the number of lines per page in the report definition.

  9. We use ePrint in our automated nightly process. Last night a file was sent to ePrint but ePrint did not parse it. I checked the INCOMING log and we did have an error when the file was being parsed. I need to know what caused the error so we can prevent it. Here is the portion of the INCOMING log with the error:

    Fri Sep 10 01:10:05 2004 PRODUCTION: Starting Parser: bbd120
    Fri Sep 10 01:11:01 2004 PRODUCTION: Could not get lock on repository: PRODUCTION
    Fri Sep 10 01:12:00 2004 PRODUCTION: Could not get lock on repository: PRODUCTION
    Fri Sep 10 01:13:01 2004 PRODUCTION: Could not get lock on repository: PRODUCTION
    Fri Sep 10 01:13:30 2004 PRODUCTION: Parser successful.

    This message is not an error. This message was displayed because it took over one minute to parse a report (bbd120). When ePrint parses a report the repository is placed in a "locked" state. The parser will "wake" after one minute to see if there is something to do. Since the report was still parsing, ePrint displayed the message. This will continue until the parsing is complete. This condition only exists when a large report is sent. The report parsed successfully.

  10. I have emails for reports that failed to parse on 9/14. When I go to the Report Parser for this week it starts with 9/15, last week's ends with 9/13. Where are the log entries for 9/14?

    Change the number of lines to display to something like 999. You will see all the entries in the log. The display on the log files is the last x number of lines, where x is the number from the page (default is 100).

  11. I sent a report to my test repository, after which I created the report definition. The definition appears to be proper and the report name appears to be correct in the incoming area; however, the report parser does not appear to be trying to parse the report. Any suggestions?

    The parser got hung up on the report. This happened because the report definition was created while the report was already in the incoming directory with its corresponding .done file. In the future, you will want to set up the report definition before sending the files, or you will want to hold off on sending the .done file until you have the report definition created.

  12. Would it be possible to generate an input file for the ePrint parser to be used in a new repository from an existing ePrint report in the original repository? That would resolve the complexity of managing the databases.

    Here is one method that you can use. First copy the report definition from the original repository to the "new" one. In the "new" repository's report definition, change the "Top of Form" to Fixed_length and save these changes. Now go back to your original repository. Go to Stored Reports and download the "TEXT" version of the report you want to move. FTP the downloaded file to the "new" repository -- don't forget the .done file! The report will parse and it will now be in the "new" repository. Repeat the download of the TEXT and FTP steps for each instance of the report that you want to bring over. The only issue may be that the IP address of the desktop that you will be doing this from is not defined to the server as a valid IP address for FTP. Just let us know and we can make that change for you.

  13. With the identical report, I get an error message when I use a Banner repository but not when I use the MVS repository. Here is my scenario:
    I created a new repository and named it findevl, which is a Banner finance repository. I then copied the report definitions from the mvstest repository. I FTP'd the reports to the new repository and they were loaded correctly from what I can see, but the "DATA" portion did not appear as it does on the original mvstest repository. Shouldn't both repositories show the same information?
    The incoming log stated the following:

        FINDEVL: Starting Parser: FRSP0921
        FINDEVL: Could not get lock on repository: FINDEVL
        FINDEVL: Could not get lock on repository: FINDEVL
        FINDEVL: Parser successful.
        FINDEVL: Starting Parser: FRSP0922
        FINDEVL: Could not get lock on repository: FINDEVL
        FINDEVL: Could not get lock on repository: FINDEVL>
        FINDEVL: Parser successful.
        FINDEVL: Starting Parser: FRSP0922
        FINDEVL: Parser successful.

    The DATA icon will only appear if you define CSV parsing for that report. When you use a report definition from one repository as a template for that same report in another repository, ePrint will just copy the report definition. If you want the DATA icon you can copy the CSV definition from the MVS repository as a template for the new FINDEVL CSV definition. The CSV definition is totally separate from the report definition.

  14. Can someone tell me what the parser message, "Unable to remove sortkey file" means? I get the message, "Successful parse of report fgrctrl" after the warning message.

    In your report definition for FGRCTRL, you have two page keys defined and both are level 0. The page keys are for acct and account (both of these are used in FRS but not Banner). You may have these left from either the default or you copied the definition from an FRS report and didn't change it. Make sure you have the correct page defined because you are trying to use VBS and it won't work without the correct page key defined.

  15. A report was created last night, but had not been defined. After the report was defined this morning, the system tried to parse the report. We got this error:

    6 09:33:01 2004 SIS: Starting Parser: bc220044
    6 09:34:02 2004 SIS: Could not get lock on repository: SIS
    6 09:35:02 2004 SIS: Could not get lock on repository: SIS
    6 09:36:01 2004 SIS: Could not get lock on repository: SIS

    The parse has not ended and we continue to get these error messages.

    In the future, remember not to FTP a report file (or at least not the .done) until after the report definition has been completed.

  16. We have a problem with a mainframe job that runs very fast. When we schedule the same job to run twice in a row, one right after the other, the ePrint file from the first job gets overlaid with the second file and the first report is lost. How long we should wait between jobs so that this will not happen? Can the time interval be changed so that ePrint checks for the files sooner? The job takes about 1 to 2 minutes to run.

    The ePrint parser starts up every minute. I would suggest a delay of 5 minutes between the jobs. Run the first job and FTP the output; once in ePrint, wait a maximum of 1 minute for parser, another minute to execute and store the first job. With a 2-3 minute buffer you can be sure that the second job will run.

  17. 17. We are having trouble transferring the FWOAFL and the accompanying VBS.DONE file to our ePrint server. The ePrint parser is not processing the files. Here is the error we receive:
    securityload.pl: Unable to open input file FWOAFL, No such file or directory

    When loading security, you need to send at least four files: ZWOFFL (the output from ZBPS10), the authentication.done, FWOAFL (output from FBPS10, if FRS VBS is used) and vbs.done. Make sure you have all four and try it again.

Print Help
  1. I am creating a print queue. The printer name should be equal to the ePrint Report FTP user name, but is the user name the report name or is it the repository name?

    The print queue name is the same as the Report FTP ID created when you initialized your repository. For example, if the Report FTP ID was "find," then the print queue in Banner would be "find." The instructions mention appending _ept. To follow this example through, the Report FTP ID would be find_ept as would the Banner print queue name. This information can be found in the Banner Interface document.

  2. How can I separate Banner reports that are run in PROD and TEST, and sent to ePrint, so they show up in separate "prod" and "test" repositories?

    If you are using the script we delivered with Banner, you would be sending the reports to different "printers." You will be defining a "printer" for each Banner repository. Each instance of Banner will be a separate repository. So send the report to the correct "printer" and the script will send it to the proper repository.

Recover Help
  1. We are about to go live with ePrint and our network folks have requested information about what files/directories on the server need to be backed up (in addition to the whole server) in order to facilitate a data recovery, if required. Can you provide us with this information, please?

    These are important directories that you want to back up in order to facilitate a data recovery if necessary: /etc and /home. Anything taking up space in /home is important, so it is best to grab the whole thing. The /home directory holds all the ePrint data and the mysql data.

  2. One of my repositories was inadvertently deleted. Can I selectively restore from the backup tape (that thankfully is not backed up every night)? And if so, are there instructions for doing this?

    There is no way for you to selectively restore from the backup tape. Basically, the backup created is for disaster recovery situations and for full system restores in the event of something such as a hardware failure.

Report Definition Help
  1. 1. I get the following message in the Incoming log and reports are in Reports Incoming. Please help!
    SCH: Could not get lock on repository: SCH

    You sent the report and the .done file before you created the report definition file. This caused the parser to go into a loop. We stopped the parser and you will have to re-send the report and .done files.

  2. I thought if you entered a user with an email address and he was assigned to a repository to which a report was sent, that he would automatically get notification of that report or any other reports sent to that repository. Do you have to change anything in the report definitions?

    In the report definition, you must set up the "Notification" section. If you specify an "EMAIL" address, when that report is parsed the email notification will be sent.

  3. Are file names case sensitive?

    Yes, file names are case sensitive. By default, if you do not specify a file name in your report definition, then ePrint assumes that the file name that will be sent over for the corresponding report definition will be lowercase. Otherwise, whatever you specify in the report definition for the "Filename" (upper or lowercase), is what you should name the file that you send to the ePrint server.

  4. Once I create the report definition and FTP it to ePrint without assigning it to a particular group it automatically defaults to the USERS group, which could pose a problem keeping information confidential.

    To get around this you need to assign a report to a group BEFORE parsing the report. Once you have created a report definition you can easily assign the report to a group, then FTP the report. If the report is assigned to something, it will not go to the default (USERS) group.

  5. How do you configure a report definition file in ePrint to accept non-Banner reports? How do the name entries for the report definition file: the initial report definition name, the label entry and the filename entry match with the incoming files (i.e., .lis and .done files) entering ePrint? I am guessing that the filename entry should match with incoming files.
    With the few Banner reports that I have defined, the Banner filenames (e.g., fgropne.lis, fgropne.done) match with the ePrint report definition name FGROPNE and the report definition label FGROPNE. The filename entry is blank. Are these differences in treatment of names between Banner and non-Banner reports?

    A non-Banner report is defined just like a Banner report. Nothing is different. A non-Banner report will need to be defined as an object in Banner and that object name must match the Report Definition name. In ePrint, if you leave the filename in the report definition blank, ePrint will expect the input filename to be the same as the Report definition name. This file is case sensitive.

  6. This report has parsed fine about a dozen times but today it has failed. I have checked the report on the mainframe against the report definition and cannot see anything wrong. The log message is: "Thu May 20 08:41:02 2004 parse.pl: Exiting, reached end of file while skipping pages in REPORT1."
    This would lead me to believe that we have a problem with the pages we are skipping (1-3). I have tried both FOCUS_VMS and IBM_GENERIC for TOP OF FORM with the same results. I tried changing the number of pages we skipped to 2 rather than 3 but then it could not find the VERIFY STRING, which is what I would expect if it were counting the pages correctly. I don't know what to try next. The log message is stating that there are only 3 pages on the report, so there is nothing to parse once we get rid of the 3 junk pages.

    Unless the report is being generated differently, or is coming from a different source, there should be no need to change this setting in the report definition. So you will want to set it to your original "Top Of Form" value.

    ePrint looks for the VERIFY STRING on the first page of the report (after getting rid of the junk pages). Since you are getting rid of two pages, we look on the third page for the verify string and the value "PAGE" is not on the page, so the verification fails. What you should be able to do is set junk pages to 1, and then "PAGE" should be found since it is on the what is now the first page (actually Page 2, but ePrint gets rid of 1). It looks as though you may have to adjust the location in the report definition, since "PAGE 2" doesn't appear to be in the same column as "PAGE 1."

  7. Do all report files go to the "incoming" folder first, even if a report definition does not exist for the file? If so, do they remain there indefinitely awaiting the creation of a definition?

    Yes, all reports go into the incoming directory of the repository. If no report definition uses that file name, then the file will remain in the incoming directory until you take some action -- either delete the file or rename it. A file in the incoming directory with no definition will cause ePrint to lock the repository. If you try to define the report any further processing will be halted. The recommendation would be to rename the file in the incoming directory, define the report, and then rename the file to its original name.

  8. A report from Banner, FABCHKR, in the fin_devl repository cannot be parsed. The error we get is:
    parse.pl: Reached end of page, verify string not found: Report: FABCHKR; Looking for: 'FABCHKR'
    We tried changing the column and the row, but that did not work. Any ideas? Should we just give up and delete this report from the error queue?

    You are receiving that message because there is a blank line before the first page delimiter (page break) on the report. When ePrint finds the blank line, it considers it a page. Then it finds the control character and treats that as a page break, and it handles the proceeding lines as page 2 data. To get the report to parse correctly, either define a junk page to get rid of the first page (page that contains just the blank line) or eliminate that blank line when the report is generated.

  9. I created a report for frrgrnt in the pprod repository. It has been brought to my attention that the end users run the report once a month, but they run it in 18 different grant ranges. It seems that they have to run the report in groups to exclude certain data. My question would be, is it possible to identify these reports individually other than by just the date and time stamp?

    Use the "Include Parameter" function to add the control parameter of your choice to the description of the report. For example, if you run frrgrnt for a selected chart-of-account (COAS), you can include this parameter in the description. When a user looks at the list they might see "Grant Report COAS=A". The include parameter is located on the File Verification and Report Title page at the bottom.

  10. What drives the sort order for reports? I thought it was the label because all the reports fall in alphabetical order such as, fgracci, fgracth, fgrbdsc, and so on. I changed the report labels in pprodd for fzrlabr and nhrsdst to reflect the following : HR - Labor Distribution
    HR - Employee Payroll Summary by Orgn

    I was hoping the reports would be grouped together, but they remained in the same position as before.
    We want to group the reports together so it looks similar to this:
    Finance - Account Index Report
    Finance - Account Hierarchy Report
    HR - Labor Distribution
    HR - Employee Payroll

    Currently, the report ID orders the reports. The ID is the name that was used to create the report definition. If you wanted to group those reports together, you would have to change the names of the report IDs (report definitons).

  11. I sent a report to my test repository, after which I created the report definition. The definition appears to be proper and the report name appears to be correct in the incoming area; however, the report parser does not appear to be trying to parse the report. Any suggestions?

    The parser got hung up on the report. This happened because the report definition was created while the report was already in the incoming directory with its corresponding .done file. In the future, you will want to set up the report definition before sending the files, or you will want to hold off on sending the .done file until you have the report definition created.

  12. Can someone tell me what the parser message, "Unable to remove sortkey file" means? I get the message, "Successful parse of report fgrctrl" after the warning message.

    In your report definition for FGRCTRL, you have two page keys defined and both are level 0. The page keys are for acct and account (both of these are used in FRS but not Banner). You may have these left from either the default or you copied the definition from an FRS report and didn't change it. Make sure you have the correct page defined because you are trying to use VBS and it won't work without the correct page key defined.

  13. We have several non-Banner report definitions with 15-character names. Is there a limit on the length of report definition name? It seems that the report definition is limited to the length of the Create New File name box. Is this right?

    The limit on the Report Definition Name is 18 characters. The limit for the Label and Description are both 60 characters.

  14. How do I get a pdf file into ePrint?

    Defining a pdf to be loaded into ePrint is similar to defining any other report in ePrint. Log in as an administrator; go to "Report Definitions" under "Report Tasks." "Create" a new definition. Once you are in the report definition wizard, enter a "Label" (optional), a "Description," and a "Filename" (optional). Next, toggle the "Input File Format" to "pdf." Then you will just need to FTP the report to the ePrint server with it's corresponding.done file. When FTPing a pdf to the ePrint server, be sure to use binary mode, otherwise the pdf may become corrupted during the file transfer.

  15. Our Finance person is for the first time starting to enter ePrint report objects into GSASECR form. An example of our report names is "fn04_telecomm." Our entry person believes he can only enter an 8-character code for new object name, for example, a.Banner encumbrance report is FGROPNE.

    Banner objects do have a character limit. If you are using the auto FTP you will need to follow the naming conventions in Banner. If it is a legacy report, in Banner you can assign an object name to the report, in ePrint create a report definition with the same object name, and in the report definition add the report file name. The report .done file that is FTP to ePrint will need to match the report configuration name or the Banner object name.

Report format Help
  1. Does ePrint support the posting of pre-existing Windows documents in formats such as pdf, Word, Excel, etc.?

    Yes, you can load reports that are generated using Word, Excel, and existing pdf files. Defining each of these reports requires different settings. Refer to your training manual, Section 5 - Reports for details.

  2. We have some clients in our phone billing department who would like to use ePrint. Their reports do not come from the mainframe; they use Crystal Reports to generate the reports. Is it possible to use ePrint with their reporting tool?

    Yes, you can import reports from Crystal Reports into ePrint. Refer to your training manual, Section 5 - Reports for details.

  3. We used FOCUS to create a report in comma-delimited format. We created an application in ePrint that works fine and displays the DATA icon, but the system continues to display the TEXT and pdf icons as well. Of course, there is no pdf version and if you try, Adobe shows garbage. Did we do something wrong, or does ePrint require a report version regardless?

    The CSV function of ePrint assumes that it is working with a text report. From the text report ePrint will create the comma-delimited file as output. Because of this ePrint will always display the pdf and TEXT icons. A simple solution is to send the file as straight data and have ePrint create the comma-delimited file. In this case, the users can see the raw data to see what was input.

  4. We have outsourced some things to companies who have certain access to our system and have access to ePrint for their reports. The reports I speak of are CSV'd for them in order for them to save to an Excel spreadsheet and send to their corporate office. If I log in and click DATA, these reports automatically ask me if I want to save them as an Excel spreadsheet. In their case if they click DATA it never asks them if they want to save it, but it immediately pulls the report up and it is one big mass of information. I have discovered if you right click the drill, ePrint will prompt you for what you want to do. At this point, if a 'save target as' is done and the document saved as an Excel Worksheet, then the document will appear as an Excel spreadsheet. In other words, anytime they want to run and view a CSV'd document, they must download it to their hard drive. Is there a way around this?
    I have examined their version of Excel (which is the same as mine). I have also performed an Explore (right click Start, Explore, Tools, File Types) and viewed how their CSV is set up. Everything is set exactly as on my computer, therefore I do not feel that is the problem. Any help I could receive on this matter would be greatly appreciated.

    As far as being prompted to save the file rather then just opening it, this is neither an ePrint nor an Excel issue. Rather, this is dependent on which Web browser is being used and how the browser is configured. When dealing with the CSV files, they should always save them to their hard drive first (right click and "save target as"), otherwise they will display incorrectly, just as you have described.

  5. Our ePrint reports currently give users view options of a text file or a pdf file. How do I create an ePrint report that also has the view option of a data file?

    To get the DATA view option for a report, define a CSV definition. A report has to be defined first before you can do the CSV definition. Most likely a report that has columns of data are candidates for CSV. Define the columns of data that will be extracted to a comma-delimited dataset. You can review the help for defining CSV for a report. Once you have the CSV definition, the DATA icon will appear for all instances of the report.

Repository Help
  1. Is there a good reason to keep the ePrint Demo Repository? We are beginning to roll ePrint campus wide. Folks are seeing the Demo Repository and thinking it is a demo they need to go through before using ePrint.

    Do not delete this repository! The ePrint demo repository is used as the template for all new repositories. This is why you don't want to delete it. You can hide it so users will not see it on the drop-down list. To hide it, go to the repository config, select the ePrint demo repository and click the EDIT button. At the bottom of the Repository Config page is the Hidden setting; set this to YES.

  2. I thought if you entered a user with an email address and he was assigned to a repository to which a report was sent, that he would automatically get notification of that report or any other reports sent to that repository. Do you have to change anything in the report definitions?

    In the report definition, you must set up the "Notification" section. If you specify an "EMAIL" address, when that report is parsed the email notification will be sent.

  3. As we move to Banner, how do you suggest we handle security in ePrint, since we won't have operator numbers to use from Banner? Will I have to manually maintain users in Banner and assign each person an operator number?

    In moving to Banner with ePrint there are a couple of things to keep in mind. First, ePrint will connect directly to Banner security, so there is no need for a security extract/load. This means that every Banner ID is a potential ePrint user. Next, you will be creating repositories for your Banner reports because different security is used in Banner compared to Plus.

    When a user logs into their Banner repositories, they use their Banner ID/password. To access their Plus repositories, they use their Plus ID/password.

  4. I was wondering is there a way to open more than one screen and compare the reports from different repository at the same time?

    You can open ePrint in another browser window and compare the reports. This means that you would be logged in twice.

  5. Do all report files go to the "incoming" folder first, even if a report definition does not exist for the file? If so, do they remain there indefinitely awaiting the creation of a definition?

    Yes, all reports go into the incoming directory of the repository. If no report definition uses that file name, then the file will remain in the incoming directory until you take some action -- either delete the file or rename it. A file in the incoming directory with no definition will cause ePrint to lock the repository. If you try to define the report any further processing will be halted. The recommendation would be to rename the file in the incoming directory, define the report, and then rename the file to its original name.

  6. I created a Finance repository and initialized it. When I tried to sign on from the ePrint login, I do not see Finance on the list. Can you let me know what I am missing?

    You have the "Hidden" flag on the Repositories page set to YES. This setting will hide the repository from the list. Just highlight NO and click Finished to change the setting.

  7. One of my repositories was inadvertently deleted. Can I selectively restore from the backup tape (that thankfully is not backed up every night)? And if so, are there instructions for doing this?

    There is no way for you to selectively restore from the backup tape. Basically, the backup created is for disaster recovery situations and for full system restores in the event of something such as a hardware failure.

  8. We use ePrint in our automated nightly process. Last night a file was sent to ePrint but ePrint did not parse it. I checked the INCOMING log and we did have an error when the file was being parsed. I need to know what caused the error so we can prevent it. Here is the portion of the INCOMING log with the error:

    Fri Sep 10 01:10:05 2004 PRODUCTION: Starting Parser: bbd120
    Fri Sep 10 01:11:01 2004 PRODUCTION: Could not get lock on repository: PRODUCTION
    Fri Sep 10 01:12:00 2004 PRODUCTION: Could not get lock on repository: PRODUCTION
    Fri Sep 10 01:13:01 2004 PRODUCTION: Could not get lock on repository: PRODUCTION
    Fri Sep 10 01:13:30 2004 PRODUCTION: Parser successful

    This message is not an error. This message was displayed because it took over one minute to parse a report (bbd120). When ePrint parses a report the repository is placed in a "locked" state. The parser will "wake" after one minute to see if there is something to do. Since the report was still parsing, ePrint displayed the message. This will continue until the parsing is complete. This condition only exists when a large report is sent. The report parsed successfully.

  9. We are missing some of our View Log info in the Report Parser for certain Repositories. I received a number of ePrint error e-mails for Friday and Saturday. When I viewed the Report Parser for our FRS repository for last week, I was able to see activity for Saturday only. In fact nothing between 11/25 thru 12/03 showed in the Report Parser for the FRS repository. Other repositories show activity during this time. All the reports, whether they are in the Report Parser or not, did FTP successfully, but they don't appear in the Report Parser view Log. Can you shed some light on this?

    Try changing the "Lines" setting to 999. That will display the first 999 lines of the log file. The default is 100, so that is all you are viewing.

  10. Our users requested that we create separate repositories for different fiscal years. The reports will be much the same except the next fiscal year reports will have an extension of the new year attached. I would like to copy all report definition templates from one repository to another that will be using the same reports, then modify the report definition for the new year.

    When you create your new fiscal year repository using the report definition wizard, on the first page, you will find a "radio" button next to "Copy multiple report definitions as templates." Select the original repository from the drop-down list and then highlight the report definitions that you want to copy. You may use the Shift key to select a range or the CTRL key to select different individual definitions. Click the CREATE button and this will copy all of the selected report definitions to your new repository. Make individual adjustments to each report definition and you are all set.

  11. A user has requested that reports from one repository be put into another repository. I know I can copy the report definition to the new repository, but is there a method to copy over the actual reports? The files that were used to FTP to ePrint are no longer available (to be parsed). There are a lot of reports that they want copied to the new repository.

    No, the process of moving reports from one repository to another is not supported by ePrint. This is not a simple task, due in part to the databases behind ePrint and the many dependences that would need to be in place before the reports could be moved.

  12. Would it be possible to generate an input file for the ePrint parser to be used in a new repository from an existing ePrint report in the original repository? That would resolve the complexity of managing the databases.

    Here is one method that you can use. First copy the report definition from the original repository to the "new" one. In the "new" repository's report definition, change the "Top of Form" to Fixed_length and save these changes. Now go back to your original repository. Go to Stored Reports and download the "TEXT" version of the report you want to move. FTP the downloaded file to the "new" repository -- don't forget the .done file! The report will parse and it will now be in the "new" repository. Repeat the download of the TEXT and FTP steps for each instance of the report that you want to bring over. The only issue may be that the IP address of the desktop that you will be doing this from is not defined to the server as a valid IP address for FTP. Just let us know and we can make that change for you.

  13. Can you assign an unlimited number of groups to a repository or is there a limit?

    There is no limit on the number of groups you can have or the number of users within a group.

  14. Have any reports been developed that list detail for each repository and show a breakdown by groups and what reports and users are in each group/repository?

    Yes, the Statistical Reports added in the 2.1 Release have this detail. For Banner-defined repositories, you will find report epruobj, Objects by User, and report eprouse, User by Object. For Plus repositories, look for report eprugrp, Groups/Reports by User, eprrgrp, Groups/Users by Report, and eprgusr, Users by Group.

  15. With the identical report, I get an error message when I use a Banner repository but not when I use the MVS repository. Here is my scenario: I created a new repository and named it findevl, which is a Banner finance repository. I then copied the report definitions from the mvstest repository. I FTP'd the reports to the new repository and they were loaded correctly from what I can see, but the "DATA" portion did not appear as it does on the original mvstest repository. Shouldn't both repositories show the same information?

  16. The incoming log stated the following:

    FINDEVL: Starting Parser: FRSP0921
    FINDEVL: Could not get lock on repository: FINDEVL
    FINDEVL: Could not get lock on repository: FINDEVL
    FINDEVL: Parser successful.
    FINDEVL: Starting Parser: FRSP0922
    FINDEVL: Could not get lock on repository: FINDEVL
    FINDEVL: Could not get lock on repository: FINDEVL
    FINDEVL: Parser successful.
    FINDEVL: Starting Parser: FRSP0922
    FINDEVL: Parser successful.

    The DATA icon will only appear if you define CSV parsing for that report. When you use a report definition from one repository as a template for that same report in another repository, ePrint will just copy the report definition. If you want the DATA icon you can copy the CSV definition from the MVS repository as a template for the new FINDEVL CSV definition. The CSV definition is totally separate from the report definition.

  17. We would like to move reports from one repository to another repository. How can I do that?

    The process for copying reports from one repository to another is manual and a time-consuming task. It is not a simple file move; it also involves the movement of report records. Here are the steps involved for two different situations: first, for copying each instance of a report from one repository to another that does not contain any instances of the report, and second, for copying specific instances of report to a repository that contains other instances of the report 1. Copying each instance of a report from one repository to another that does not contain any instances of the report: a) Copy the folder structure b) Edit the control backup file for each instance of the report to reflect the new repository parameters c) Add the report index record(s) to the repository report_index table d) Copy or import the report page data into the new repository e) If VBS is applied to the report, copy or import the VBS data into the new repository f) Add the report to the report authorization table g) Copy the report configuration file to the new repository 2. Copying specific instances of report to a repository that contains other instances of the report: a) Copy the folder structure b) Edit the control backup file for each instance of the report to reflect the new repository parameters c) Add the report index record(s) to the repository report_index table d) Copy or import the report page data into the new repository e) If VBS is applied to the report, copy or import the VBS data into the new repository.

  18. Is it possible to have multiple FTP users for one repository?

    No, there is only one FTP User/Password per repository, but you may use the user/password from multiple locations to ePrint. I'm assuming you want to send reports from more than one location? If so, they can all use the same FTP User ID. This should work fine as long as they are not all sending the same report at the same time.

  19. What software is normally used to FTP to ePrint and where do you specify the repository and report definition? When sending a pdf file to ePrint, you can use FTP (or SFTP) software. Whether you use FTP or SFTP software, the repository is determined by the FTP ID/password used in the FTP process, and the report definition is determined by the file name sent to ePrint.

    If you you establish the FTP connection from a PC, you will use the FTP ID/password (from the repository initialization) and send the pdf file and the .done file. When sending a pdf file, send it in binary mode not ASCII. The ePrint server will need the IP address of the PC defined so the FTP transfer can take place. The process of sending a pdf file is the same as sending any other report to ePrint.

  20. I created a new repository for FRS for FY03 called FRS03. I used my existing and working FRS04 repository as a template. But ZWOFFL was just sitting in the Security Incoming area. So I deleted the FRS03 repository I had created and tried again. At the same time I was trying to get the Authentication file over, another administrator was running ZJPS10 for another repository. Nothing seems to happening. Our files have been sent, but they are just sitting there.

    When loading security into a repository you need at least three files for the security parser to run: the authentication file (usually ZWOFFL), authentication.done (empty file), and vbs.done (also empty file). If you have defined value-based security (VBS) elements in your security definition, you also need to send those files (ex., FWOAFL for accounts in FRS), before the vbs.done file.

  21. I have been setting up a new repository. Initially I loaded a user file from SIS, but then I decided to construct a user list separately. When I set the repository update mode to "batch," it loaded my list and deleted the other user IDs from the list of users in that repository. It seems to have left all those (now nonexistent) users in the *group* named "users." I've been manually deleting them. Is it supposed to do this?

    Yes, the User ID will be left in the groups in which they where originally in. Otherwise, you would have to re-create all the groups every time you loaded them via BATCH update. Having the User IDs stay assigned to the groups is only a problem if you re-use the Operator ID for a different user.

  22. How can I separate Banner reports that are run in PROD and TEST, and sent to ePrint, so they show up in separate "prod" and "test" repositories?

    If you are using the script we delivered with Banner, you would be sending the reports to different "printers." You will be defining a "printer" for each Banner repository. Each instance of Banner will be a separate repository. So send the report to the correct "printer" and the script will send it to the proper repository.

Restore Help
  1. One of my repositories was inadvertently deleted. Can I selectively restore from the backup tape (that thankfully is not backed up every night)? If so, are there instructions for doing this?

    There is no way for you to selectively restore from the backup tape. Basically, the backup created is for disaster recovery situations and for full system restores in the event of something such as a hardware failure.

Security Help
  1. If I have a report in ePrint that is defined with both department level Value Based Security and with email notification of a new report occurrence, will email notifications be sent to all users who can view the report? Or will notifications only be sent to those users who have are able to view pages within the report?

    The email will go to all users who have access to the report (and have their email addresses in ePrint). Even if there are no pages for them to view, they would get an email. ePrint does not check every user's report access to see if there is anything for them to see, it just knows that the report is ready.

  2. Our problem seems to be maintaining the user's email address. This value is not fed as part of the security update, yet if the security update is run in Batch mode the update wipes out this field. This makes it impossible to do email notification by User Group. Doing email notification by email address on the report definition is prohibitive due to the effort involved. Are there other ePrint clients who use email notification? How are they maintaining the email address?

    One Plus school added the user's email address to the ZCFILE. They used a couple of fields that they did not use in ZSS and made it email address. They added this field to the extract file and to the security definition in ePrint so they could continue to use Batch mode update. With Batch mode update you can maintain your users with ZSS and ePrint reflects those changes.

    After further discussion, we concluded that an update mode of "Both" would work for you. This will keep the email addresses in ePrint. The drawback here is that when you delete a user from ZSS, you must also delete the user from ePrint.

    Another solution would be to include all the users email addresses, separated by commas on the "Notification" page of the report definition. The drawback here is that you would need to add/delete email addresses as the list of users changes.

    >

    Each of these solutions requires some change on your part. Select the one that best works for you.

  3. As we move to Banner, how do you suggest we handle security in ePrint, since we won't have operator numbers to use from Banner? Will I have to manually maintain users in Banner and assign each person an operator number?

    In moving to Banner with ePrint there are a couple of things to keep in mind. First, ePrint will connect directly to Banner security, so there is no need for a security extract/load. This means that every Banner ID is a potential ePrint user. Next, you will be creating repositories for your Banner reports because different security is used in Banner compared to Plus.

    When a user logs into their Banner repositories, they use their Banner ID/password. To access their Plus repositories, they use their Plus ID/password.

  4. We are in our year-end process and some folks are restricted to the current year, while others are locked into the future year. We have been running fbps10 with FY=04. This morning, some folks cannot access their pages, and I think it's because they are restricted to FY05 in FRS. How do we run fbps10 to accounts for both years?

    When you change the accounts that an operator has access to from one fiscal year to another, this requires a new repository in ePrint. The security load program (FBPS10) is looking at VBS based on the fiscal year in FRS. That is why the users cannot see their "old" accounts on the reports, and this will be true for all instances of the report.

    You will need to run FBPS10 for FY04 and reload security in your repository. Next, create a FY05 repository and load your FY05 security. Then copy the report definitions from your "old" FY04 repository to your new FY05 repository. To copy the report definitions, log on to the FY05 repository and go to the report definition wizard. Use the "Copy multiple report definition files as templates " function and select the report definitions that you want to copy.

    You are now ready to start loading the reports into your FY05 repository. Users will need to be in the correct fiscal year to see the right accounts.

  5. I am trying to route an output report file from a foreign MVS system to my ePrint server via FTP. Security will not allow me access to my ePrint server to pass the information. Any suggestions?

    The reason that you can't FTP to the server is because the server will only allow certain IP addresses to FTP to it. If you send us the IP address of the machine where you FTP from, we can add that to the server.

  6. How can I make sure that the fwoafl file has processed properly in the security loader?

    As long as it is defined in your security setup, ePrint will require that file. If it's not there, then the parser fails and you get the error message, "file not found." Otherwise, if the parser is successful, then all is good.

  7. I created a new repository for FRS for FY03 called FRS03. I used my existing and working FRS04 repository as a template. But ZWOFFL was just sitting in the Security Incoming area. So I deleted the FRS03 repository I had created and tried again. At the same time I was trying to get the Authentication file over, another administrator was running ZJPS10 for another repository. Nothing seems to happening. Our files have been sent, but they are just sitting there.

    When loading security into a repository you need at least three files for the security parser to run: the authentication file (usually ZWOFFL), authentication.done (empty file), and vbs.done (also empty file). If you have defined value-based security (VBS) elements in your security definition, you also need to send those files (ex., FWOAFL for accounts in FRS), before the vbs.done file.

  8. I have encountered an error when sending the security file to ePrint:

    220 eprint.nnn.edu FTP server (Version wu-2.6.1-20) ready.
    Connected to 192.154.33.232.
    331 Password required for frss.
    230 User frss logged in. Access restrictions apply.
    200 PORT command successful.
    553 zwoffl: Permission denied on server. (Overwrite)
    221-You have transferred 0 bytes in 0 files.
    221-Total traffic for this session was 389 bytes in 0 transfers.
    221 Thank you for using the FTP service on eprint.nnn.edu.

    Since this file is failing, I have not tried to send the FWOAFL file. In referencing a past event, you suggested deleting and re-defining a file that returned this "permission" type error. Are there any implications with re-defining the ZWOFFL or FWOAFL files? Is this even possible, since it is an FRSS user file?

    The message that you received on the FTP step, zwoffl: Permission denied on server (Overwrite), means that the ZWOFFL file already exists in the security incoming directory of this repository. To move the new ZWOFFL file into the correct repository/directory, delete the existing ZWOFFL file in ePrint. To do this: 1. Log in as the Administrator
    2. Go to Security Incoming, located under the File Maintenance heading
    3. On the Security Incoming Directory page, highlight the file (ZWOFFL)
    4. Click the delete button. You will be asked to confirm the delete. Click OK

  9. Can you tell me the difference in shared security on the repository config between Banner Finance, HR, Student, and Generic? Also, how does single sign-on work?

    The difference between the four Banner security methods is in how page level security is applied. Banner Finance will pull a user's security elements from the FOMPROF form. HR will pull a user's security elements from the form PTRUSR. Currently, Student and General do not apply page level security, but we plan to incorporate Student page level security into ePrint.

  10. We know that by running the ZJPS10.COM and AJPS10.COM, our security data from SIS is FTP'ed to ePrint. We noticed that on subsequent runs the new data that was entered/changed in SIS will be updated in ePrint; however, users who have been deleted from SIS security do not appear to be deleted from ePrint. Is this by design, so that we have to manually delete them from ePrint or is this a flaw in the system?

    If the "Update Mode" in your Security definition is set to "Both," then you would need to delete those users from the repository via ePrint. If "Update Mode" is set to "Batch," then those users would be deleted from ePrint when security is reloaded (by running and FTP'ing the output files from ZBPS10 and APS10). The reason that "Update Mode" may be set to Both, is to allow you to create users directly in ePrint (using the User create function).

  11. I thought the "No Overlay" option would allow us to use the ePrint password routines and drop users as they fall off of FRS -- but that's not happening.
    We decided to use the ePrint passwords because they were more secure, could use any length and combination of characters, and allow users to change their own passwords instead of calling IT. So I was pleased that we could accommodate that concern with ePrint. But it looks like the burden now falls on IT to manually remove users from ePrint when they are removed from FRS.
    Would you consider making this an enhancement in the future where folks can use the ePrint passwords and still drop users off the system if they don't exist in Plus anymore? IT would be thrilled!

    The NO_OVERLAY security update option works the same as BOTH option. With either of these security update options, ePrint does not delete users when a batch file is used because you can also create users directly into ePrint with this setting.

  12. What is the maximum length that ePrint will accept for a password?

    ePrint will accept a password field as long as you need it. Define the location and size of the password in your security definition.

  13. We receive a daily Suspense report from our SIS Batch Maintenance program and I would like to use Value Based Security (VBS) in ePrint to split up the report so that each user area sees only their own section of the report. I've looked at the documentation on setting up VBS operator files, containing samples for FRS and HRS using a header record with FY in it. Do we need a header for SIS and if so, what needs to be in it? Is it going to be possible for me to manually create my own VBS file? Will that affect the ability of these users to see any of their other reports? I have other reports indexed by page keys.

    Yes, you can create your own VBS file for that report. This will not have any impact on any other report to which those users have access. Your VBS file will be made up of the Header record, which will contain the fiscal year (not used in SIS), element number (this will match a value you entered as the Verify string in your security definition of this element), the length of the element, and the number of times it will occur on the detail record.

    Following the Header record your Detail records contain the Operator IDs and the values of the element to which this operator has access. An operator may have more than one detail record.

  14. I sent files named 'sisuser' and 'sisunit' to ePrint and used the same names in the security VBS setup. It looks like ePrint expects to see a file with a different name. Here's my error message: Cannot open file '/home/eprint/cgi-bin/../prod/repository/test/security/user.vbs': No such file or directory
    Also, I have two new VBS security files sitting in the Security Incoming Directory and they aren't moving. Can you tell me why they are still sitting there, and why the first one shows no data when there are five lines.

    Are you receiving this error when you try to open the report? The page keys defined in the report definition must match the VBS values that you use in the security VBS setup. In other words, in the report definition you will either have to use "sisuser" for the page key value, or use "user" in the security VBS setup.

    As for the reports sitting in the Security Incoming Directory, the security loader also needs an "authentication.done" file. Once it is there, the security files should process.

  15. Are you receiving this error when you try to open the report? The page keys defined in the report definition must match the VBS values that you use in the security VBS setup. In other words, in the report definition you will either have to use "sisuser" for the page key value, or use "user" in the security VBS setup.
    As for the reports sitting in the Security Incoming Directory, the security loader also needs an "authentication.done" file. Once it is there, the security files should process.

    The BOTH security option will only "append" new data and anything that has changed. It will not remove any records. For example, say you have Operator 1234 on the mainframe and load that ID into ePrint. Then you delete Operator 1234 in ZSS and re-load security in ePrint. Operator 1234 will remain in ePrint.

    In BATCH mode for the above example, when you re-load security after deleting operator 1234 in ZSS, it will be removed because ePrint is in a "replace" mode with BATCH mode.

  16. Does a user have to be set up as an INB user to have ePrint do report authorization to ensure only specific reports are seen? We had been planning on just setting users as SSB (Self-Service Banner.)

    The user will need to be set up as an Internet Native Banner user if you are going to be using Self-Service. If you refer to page 7 of the ePrint Banner Interface documentation, you will see that for the Oracle ID of rlocke, they have an INB ID of 111111111. They will log into Web Tailor with 111111111 but their Oracle ID is used to process their Finance security. ePrint will be using the Oracle ID, just as Self-Service Finance does behind the scenes to process security.

Server Help
  1. The production department is going to be doing some technical work in the server room. The ePrint server is in this room and we want it shut down so we can perform the work. Can you give us a user account so we can shut it down from here?

    If you or your group would like to shut the machine down yourself, here are the instructions. 1) Log in as the root user
    2) At the prompt type: SHUTDOWN NOW
    3) When the screen stops scrolling, power off the server

  2. I have encountered an error when sending the security file to ePrint:

    220 eprint.nnn.edu FTP server (Version wu-2.6.1-20) ready.
    Connected to 192.154.33.232.
    331 Password required for frss.
    230 User frss logged in. Access restrictions apply.
    200 PORT command successful.
    553 zwoffl: Permission denied on server. (Overwrite)
    221-You have transferred 0 bytes in 0 files.
    221-Total traffic for this session was 389 bytes in 0 transfers.
    221 Thank you for using the FTP service on eprint.nnn.edu.

    Since this file is failing, I have not tried to send the FWOAFL file. In referencing a past event, you suggested deleting and re-defining a file that returned this "permission" type error. Are there any implications with re-defining the ZWOFFL or FWOAFL files? Is this even possible, since it is an FRSS user file?

    The message that you received on the FTP step, zwoffl: Permission denied on server (Overwrite), means that the ZWOFFL file already exists in the security incoming directory of this repository. To move the new ZWOFFL file into the correct repository/directory, delete the existing ZWOFFL file in ePrint. To do this: 1. Log in as the Administrator
    2. Go to Security Incoming, located under the File Maintenance heading
    3. On the Security Incoming Directory page, highlight the file (ZWOFFL)
    4. Click the delete button. You will be asked to confirm the delete. Click OK

Sort Help
  1. What drives the sort order for reports? I thought it was the label because all the reports fall in alphabetical order such as, fgracci, fgracth, fgrbdsc, and so on. I changed the report labels in pprodd for fzrlabr and nhrsdst to reflect the following : HR - Labor Distribution
    HR - Employee Payroll Summary by Orgn

    I was hoping the reports would be grouped together, but they remained in the same position as before.
    We want to group the reports together so it looks similar to this:
    Finance - Account Index Report
    Finance - Account Hierarchy Report
    HR - Labor Distribution
    HR - Employee Payroll

    Currently, the report ID orders the reports. The ID is the name that was used to create the report definition. If you wanted to group those reports together, you would have to change the names of the report IDs (report definitons).

Temporary File Help
  1. ePrint gives you the ability to view files in pdf or text format. Are these just views, or are there really two copies of the report on the server?

    There is only one copy of the report. ePrint will create a pdf file if it is needed, but it is only a temporary file.

Time Help
  1. My ePrint machine seems to be gaining time. Currently it is about 35 minutes fast. Is there an option to adjust the time (Solaris UNIX 'date -a xxx' command), or is there an option to hook up to a time source and adjust the time accordingly?

    You can use this format to set the date: date -s HH:MM:SS (H = Hour, M = Minute, S = Seconds). For example, if it was 1:36 PM you would use: date -s 13:36:00. After that, you may want to synchronize the hardware clock: hwclock -systohc

  2. We use ePrint in our automated nightly process. Last night a file was sent to ePrint but ePrint did not parse it. I checked the INCOMING log and we did have an error when the file was being parsed. I need to know what caused the error so we can prevent it. Here is the portion of the INCOMING log with the error:

    Fri Sep 10 01:10:05 2004 PRODUCTION: Starting Parser: bbd120
    Fri Sep 10 01:11:01 2004 PRODUCTION: Could not get lock on repository: PRODUCTION
    Fri Sep 10 01:12:00 2004 PRODUCTION: Could not get lock on repository: PRODUCTION
    Fri Sep 10 01:13:01 2004 PRODUCTION: Could not get lock on repository: PRODUCTION
    Fri Sep 10 01:13:30 2004 PRODUCTION: Parser successful.

    This message is not an error. This message was displayed because it took over one minute to parse a report (bbd120). When ePrint parses a report the repository is placed in a "locked" state. The parser will "wake" after one minute to see if there is something to do. Since the report was still parsing, ePrint displayed the message. This will continue until the parsing is complete. This condition only exists when a large report is sent. The report parsed successfully.

  3. We have a problem with a mainframe job that runs very fast. When we schedule the same job to run twice in a row, one right after the other, the ePrint file from the first job gets overlaid with the second file and the first report is lost. How long we should wait between jobs so that this will not happen? Can the time interval be changed so that ePrint checks for the files sooner? The job takes about 1 to 2 minutes to run.

    The ePrint parser starts up every minute. I would suggest a delay of 5 minutes between the jobs. Run the first job and FTP the output; once in ePrint, wait a maximum of 1 minute for parser, another minute to execute and store the first job. With a 2-3 minute buffer you can be sure that the second job will run.

Usage Help
  1. Our VP wants to know how much ePrint is being used. Is there any easy way to determine how many people are signing on and looking at reports? We have over 150 reports on ePrint and about 100 people have access to them. This is too much to try to tally by looking at each report, each day, to see who has viewed it.

    Use the Statistical Reports section of the administrative Interface to generate a report that can display this information. You can get summary and detail information about who is looking at which reports. Report eprusgs will give you a summary of activity on a report. Report eprusgd will display detail information on each instance of a report, which includes who viewed it, and the date and time it was viewed.

User Group Page Help
  1. Once I create the report definition and FTP it to ePrint without assigning it to a particular group it automatically defaults to the USERS group, which could pose a problem keeping information confidential.

    To get around this you need to assign a report to a group BEFORE parsing the report. Once you have created a report definition you can easily assign the report to a group, then FTP the report. If the report is assigned to something, it will not go to the default (USERS) group.

  2. I've been asked to rename one of my Groups in ePrint but don't see an option to change the name of the group. I could delete the current group and recreate the group under the new name, but I assume this new group would not be able to access all the reports from previous months that were in the group under the old name. Is this a correct assumption? If so, how should I handle this?

    Yes, currently there is no way to rename a group in ePrint. You should be able to create a new group and assign it the same users as the old group. You also should be able to do the same with reports since the reports assigned to a group are based on the name of the report, and not based on each individual instance of the report.

  3. Can you assign an unlimited number of groups to a repository or is there a limit?

    There is no limit on the number of groups you can have or the number of users within a group.

  4. Have any reports been developed that list detail for each repository and show a breakdown by groups and what reports and users are in each group/repository?

    Yes, the Statistical Reports added in the 2.1 Release have this detail. For Banner-defined repositories, you will find report epruobj, Objects by User, and report eprouse, User by Object. For Plus repositories, look for report eprugrp, Groups/Reports by User, eprrgrp, Groups/Users by Report, and eprgusr, Users by Group.

  5. I have been setting up a new repository. Initially I loaded a user file from SIS, but then I decided to construct a user list separately. When I set the repository update mode to "batch," it loaded my list and deleted all of the other user IDs from the list of users in that repository. It seems to have left all those (now nonexistent) users in the *group* named "users." I've been manually deleting them. Is it supposed to do this?

    Yes, the User ID will be left in the groups in which they where originally in. Otherwise, you would have to re-create all the groups every time you loaded them via BATCH update. Having the User IDs stay assigned to the groups is only a problem if you re-use the Operator ID for a different user.

  6. I have been attempting to assign a user group to a defined report as a way of notifying users that reports are available on ePrint. I know that I can add individual user emails to a report, but would like to notify an entire group. I believe I can also manually enter email addresses on each individual user but wouldn't they be overlaid (blanked) by my ZWOFFL? We currently have the UPDATE MODE set to BATCH because we want users that are removed from SIS to also be removed from ePrint. My current understanding is that an email address could reside on the ZWOFFL file that we FTP and we could use the security screens to tell ePrint where the email address starts and its length. Do we need to write something to place the email address on this file?

    You are correct in that you need to load the users email address into ePrint in order to have it send out a notification of the reports. Because you have the update mode set to BATCH, if you manually entered the email addresses, they would be "wiped out" the next time security was loaded. The best solution is to take the output file from ZBPS10 (ZWOFFL) and add the email addresses to the security extract from ZBPS10. This could be time-consuming, depending on the number of email addresses that you are loading. A couple of schools have used a field in the ZSFILE that they were not using and made it email address, then added a line of code in ZBPS10 to move the email to the extract file.

User ID Page Help
  1. A user might have tried to login too many times and the system logged her out. How can I unlock her ID, or is it an auto time out?

    If a user tries to login and is not successful after five attempts, that ID will be locked. To unlock the ID, go to the "Users" page on the Administrator Interface, type in the ID (or use the clipboard to find the ID). Click the "edit" button and click the "unlock" button. The user will now be able to log in.

  2. As we move to Banner, how do you suggest we handle security in ePrint, since we won't have operator numbers to use from Banner? Will I have to manually maintain users in Banner and assign each person an operator number?

    In moving to Banner with ePrint there are a couple of things to keep in mind. First, ePrint will connect directly to Banner security, so there is no need for a security extract/load. This means that every Banner ID is a potential ePrint user. Next, you will be creating repositories for your Banner reports because different security is used in Banner compared to Plus.

    When a user logs into their Banner repositories, they use their Banner ID/password. To access their Plus repositories, they use their Plus ID/password.

  3. I am signing on using the normal "admin" account that was set up by you, but cannot see a way to set up a new administrator. This person will not be a repository admin, but an overall system administrator as myself. Should I be signing on a different way?

    There is only one Super Administrator ID in ePrint. More than one person can use that ID/Password.

  4. Does a user have to be set up as an INB user to have ePrint do report authorization to ensure only specific reports are seen? We had been planning on just setting users as SSB (Self-Service Banner.)

    The user will need to be set up as an Internet Native Banner user if you are going to be using Self-Service. If you refer to page 7 of the ePrint Banner Interface documentation, you will see that for the Oracle ID of rlocke, they have an INB ID of 111111111. They will log into Web Tailor with 111111111 but their Oracle ID is used to process their Finance security. ePrint will be using the Oracle ID, just as Self-Service Finance does behind the scenes to process security.

View Help
  1. ePrint gives you the ability to view files in pdf or text format. Are these just views, or are there really two copies of the report on the server?

    There is only one copy of the report. ePrint will create a pdf file if it is needed, but it is only a temporary file.

  2. Our Provost is having a problem viewing a .pdf file in ePrint, regardless of who logs in. The system will let you initially log in and go to the listing of viewable reports, but once you click the pdf icon it kicks you out to the login screen. He can view other pdf files in other applications. Can you suggest anything for us to check?

    Have him clear the cache in his browser and try again. This normally will resolve the problem.

  3. I was wondering if there is a way to open more than one screen and compare the reports from different repositories at the same time?

    You can open ePrint in another browser window and compare the reports. This means that you would be logged in twice.

  4. Two people called with the following error:
    "There are no pages for you to view on this report. If you think this is an error, contact your ePrint administrator. Otherwise, return to ePrint and select another report."

    Answer

  5. What drives the sort order for reports? I thought it was the label because all the reports fall in alphabetical order such as, fgracci, fgracth, fgrbdsc, and so on. I changed the report labels in pprodd for fzrlabr and nhrsdst to reflect the following : HR - Labor Distribution
    HR - Employee Payroll Summary by Orgn

    I was hoping the reports would be grouped together, but they remained in the same position as before.
    We want to group the reports together so it looks similar to this:
    Finance - Account Index Report
    Finance - Account Hierarchy Report
    HR - Labor Distribution
    HR - Employee Payroll

    Currently, the report ID orders the reports. The ID is the name that was used to create the report definition. If you wanted to group those reports together, you would have to change the names of the report IDs (report definitions).

  6. I defined FGLTRNR log and was able to send it to the ePrint server. When I view it in the STORED REPORTS area, I can see the report name. When I open it, there is no information. It should not be blank. What am I missing?

    The report contains only one page of data and you have it defined with the last page as a junk page. ePrint is removing the last page, which in this case happens to also be the first page, and this leaves you with no pages. Remove the junk page and you should be all set.

  7. We are missing some of our View Log info in the Report Parser for certain Repositories. I received a number of ePrint error e-mails for Friday and Saturday. When I viewed the Report Parser for our FRS repository for last week, I was able to see activity for Saturday only. In fact nothing between 11/25 thru 12/03 showed in the Report Parser for the FRS repository. Other repositories show activity during this time. All the reports, whether they are in the Report Parser or not, did FTP successfully, but they don't appear in the Report Parser view Log. Can you shed some light on this?

    Try changing the "Lines" setting to 999. That will display the first 999 lines of the log file. The default is 100, so that is all you are viewing.

  8. How would I darken a report to make it easier to read?

    To darken the print and display of a report, use the LANDSCAPE_BOLD setting in the Page Format of the report definition. After making this change you would need to re-parse the report. This will only effect reports parsed after the change.

  9. I sent a report to ePrint that had been previously defined and stored. I got a log that says everything is fine, yet this report is not being stored where the other reports have been stored. I checked the parser, the error section, and can find no problems. The report is identical to past runs, but it simply dropped out of sight! I have looked at the report and ePrint definition and can see no errors. Nor has anyone changed this report or its definition since it was run last. Any suggestions?

    In looking at the reports, they are filed under 09/04/2003 but the report date is 02/09/04. When I compared these reports against the last "good one" (1/29/04), I noticed that the report is different. The "good" reports have on the heading line, DATE RUN: nn/nn/nn; the reports in question had, DATE:nn/nn/nn.

    The date is in a different place, that's why they are not listed under the correct date. Change the date setting on the report definition in ePrint or on the heading of the report.

  10. I'm trying to set up the CSV on a report and it fails to load the whole report into Excel. It stops at line 65,536. We will be adding VBS to this report, but if anyone has access to the whole report they wouldn't be able to view the entire report in Excel. Is there a way around this problem?

    The 65,536 line is the limit Excel can accept. The only workaround would be to split the report. With VBS the number of people who can see the entire report should be limited. The main question would be, is someone who has access to all the information likely to download to Excel?

  11. We used FOCUS to create a report in comma-delimited format. We created an application in ePrint that works fine and displays the DATA icon, but the system continues to display the TEXT and pdf icons as well. Of course, there is no pdf version and if you try, Adobe shows garbage. Did we do something wrong, or does ePrint require a report version regardless?

    The CSV function of ePrint assumes that it is working with a text report. From the text report ePrint will create the comma-delimited file as output. Because of this ePrint will always display the pdf and TEXT icons. A simple solution is to send the file as straight data and have ePrint create the comma-delimited file. In this case, the users can see the raw data to see what was input.

  12. I'm having a problem setting up a report using the CSV setting. I create the definition for the report in CSV, but when I go to Stored Reports and click Data, it shows up in a text document. I've checked my settings and they seem to be the same as the values that work in other repositories. Any pointers?

    If you are using Internet Explorer as your browser, right mouse click, save target as, and save the file to your desktop (or wherever you want). Then go to the file and open it, this should open Excel and display the report in CSV format. If you use the primary mouse button to click the "Data" icon, this will cause Excel to open within the browser and not perform the CSV processing.

  13. We have outsourced some things to companies who have certain access to our system and have access to ePrint for their reports. The reports I speak of are CSV'd for them in order for them to save to an Excel spreadsheet and send to their corporate office. If I log in and click DATA, these reports automatically ask me if I want to save them as an Excel spreadsheet. In their case if they click DATA it never asks them if they want to save it, but it immediately pulls the report up and it is one big mass of information. I have discovered if you right click the drill, ePrint will prompt you for what you want to do. At this point, if a 'save target as' is done and the document saved as an Excel Worksheet, then the document will appear as an Excel spreadsheet. In other words, anytime they want to run and view a CSV'd document, they must download it to their hard drive. Is there a way around this?
    I have examined their version of Excel (which is the same as mine). I have also performed an Explore (right click Start, Explore, Tools, File Types) and viewed how their CSV is set up. Everything is set exactly as on my computer, therefore I do not feel that is the problem. Any help I could receive on this matter would be greatly appreciated.

    As far as being prompted to save the file rather then just opening it, this is neither an ePrint nor an Excel issue. Rather, this is dependent on which Web browser is being used and how the browser is configured. When dealing with the CSV files, they should always save them to their hard drive first (right click and "save target as"), otherwise they will display incorrectly, just as you have described.

  14. The problem I am having is that the 1st page of FAM reports puts an extra line at the top of the report. Therefore the FAM reports do not work because each subsequent page the unique identified (SBA590) is on line 3 but on line 4 on page 1. We used another report we have as a template for this one.

    Define the report with a junk page of type = LINES and Line = 1. ePrint will ignore the first line of the report. A number of the FAM reports place a page break before the first page, which causes problems in ePrint. This is not a "known issue," but just the way FAM reports are formatted. If the reports are printed, there is no problem. This is something that you will need to be aware of when defining FAM reports to ePrint. The FAM ActionLine looked into a change, but the effort was too great and would affect all of FAM.

  15. Our ePrint reports currently give users view options of a text file or a pdf file. How do I create an ePrint report that also has the view option of a data file?

    To get the DATA view option for a report, define a CSV definition. A report has to be defined first before you can do the CSV definition. Most likely a report that has columns of data are candidates for CSV. Define the columns of data that will be extracted to a comma-delimited dataset. You can review the help for defining CSV for a report. Once you have the CSV definition, the DATA icon will appear for all instances of the report.

  16. We are experiencing a repetitive problem. When users try to download a report, it brings up the login screen instead of the data.

    It sounds like they losing their login session. Make sure their browsers are set to accept cookies. Also make sure their "Privacy Settings" are not too high. Anything higher than "Medium" may cause problems such as the one you are describing.

Year-end Help
  1. We are in our year-end process and some folks are restricted to the current year, while others are locked into the future year. We have been running fbps10 with FY=04. This morning, some folks cannot access their pages, and I think it's because they are restricted to FY05 in FRS. How do we run fbps10 to accounts for both years?

    When you change the accounts that an operator has access to from one fiscal year to another, this requires a new repository in ePrint. The security load program (FBPS10) is looking at VBS based on the fiscal year in FRS. That is why the users cannot see their "old" accounts on the reports, and this will be true for all instances of the report.

    You will need to run FBPS10 for FY04 and reload security in your repository. Next, create a FY05 repository and load your FY05 security. Then copy the report definitions from your "old" FY04 repository to your new FY05 repository. To copy the report definitions, log on to the FY05 repository and go to the report definition wizard. Use the "Copy multiple report definition files as templates " function and select the report definitions that you want to copy.

    You are now ready to start loading the reports into your FY05 repository. Users will need to be in the correct fiscal year to see the right accounts.

  2. Our users requested that we create separate repositories for different fiscal years. The reports will be much the same except the next fiscal year reports will have an extension of the new year attached. I would like to copy all report definition templates from one repository to another that will be using the same reports, then modify the report definition for the new year.

    When you create your new fiscal year repository using the report definition wizard, on the first page, you will find a "radio" button next to "Copy multiple report definitions as templates." Select the original repository from the drop-down list and then highlight the report definitions that you want to copy. You may use the Shift key to select a range or the CTRL key to select different individual definitions. Click the CREATE button and this will copy all of the selected report definitions to your new repository. Make individual adjustments to each report definition and you are all set.