Ron Ronquillo posted Message 71 in Message Board 
 
Dated  : February 23, 1999 at 10:47:14 EST
Subject: Edify: Evaluations and/or recommendations?
 
Can anyone share their experiences with using Edify at their company?
What is your evaluation of Edify?
Would you recommend Edify and why? or Why wouldn't you recommend Edify and why?
My company is planning to install PeopleSoft version 7.5 on a DB2 platform.

Thank you in advance for your responses!

 Ron Ronquillo
 System Design Analyst
 Information Services Division - United Airlines
 Phone: 847/700-7532
 Fax: 847/700-5466
 Email: ron.ronquillo@ual.com
 
***************** End Of Article ****************** 
 
Ron Ronquillo posted Message 72 in Message Board 
 
Dated  : February 23, 1999 at 10:48:32 EST
Subject: TALX: Evaluations and/or recommendations?
 
Can anyone share their experiences with using TALX at their company?
What is your evaluation of TALX?
Would you recommend TALX and why? or Why wouldn't you recommend TALX and why?
My company is planning to install PeopleSoft version 7.5 on a DB2 platform.

Thank you in advance for your responses!

 Ron Ronquillo
 System Design Analyst
 Information Services Division - United Airlines
 Phone: 847/700-7532
 Fax: 847/700-5466
 Email: ron.ronquillo@ual.com
 
***************** End Of Article ****************** 
 
Ron Ronquillo posted Message 73 in Message Board 
 
Dated  : February 23, 1999 at 10:49:47 EST
Subject: Seeker Software: Evaluations and/or recommendations?
 
Can anyone share their experiences with using Seeker Software at their company?
What is your evaluation of Seeker Software?
Would you recommend Seeker Software and why? or Why wouldn't you recommend Seeker Software and why?
My company is planning to install PeopleSoft version 7.5 on a DB2 platform.

Thank you in advance for your responses!

 Ron Ronquillo
 System Design Analyst
 Information Services Division - United Airlines
 Phone: 847/700-7532
 Fax: 847/700-5466
 Email: ron.ronquillo@ual.com
 
***************** End Of Article ****************** 
 
Gary Hlapcic posted Message 74 in Message Board 
 
Dated  : February 25, 1999 at 09:02:51 EST
Subject: AMDPCALC - performance problems
 
We are having preformance problems running AMDPCALC.sqr, it currently processess about 30 assets/hour. I think that the problem resides in the SQL that goes against both open_trans and book tables because when we run a business unit with only 1 book we get results of 500 assets/hour. Has anyone run across performance problems with AMDPCALC in the past. Any feedback on your solutions would be very helpfull.

Thanks Gary
 
***************** End Of Article ****************** 
 
brettf@dpapplications.com posted Message 75 in Message Board 
 
Dated  : February 25, 1999 at 10:30:37 EST
Subject: Re: datamart
 
Go to www.dpapplications.com and look into DecisionPoint for Financials.  This is a packaged financial data warehouse solution that is preintegrated with PeopleSoft and facilitates loading the other data that you need to analyze as well.




 
***************** End Of Article ****************** 
 
Milind Vasani posted Message 76 in Message Board 
 
Dated  : March 03, 1999 at 04:53:52 EST
Subject: Re: Import Manager Script.
 
Hi, 
I am also facing similar problem - do let me know when you get solution for the same. 

Milind 

: Hi,
:     Does anyone know if its possible to write a script for
: Import Manager to upload all the flat files automatically instead of need human intervention to upload from each file(wich is each table).The file definitions are already defined for each table.
: Any ideas, suggestions, comments will be greatly appreciate.
: Thanks in advance.

:                                   Van.


 
***************** End Of Article ****************** 
 
Milind Vasani posted Message 77 in Message Board 
 
Dated  : March 03, 1999 at 05:00:53 EST
Subject: Data Migration from Legacy systems 
 
Hi, 

I am working on Peoplesoft HRMS - Recruit workforce and admin workforce module. I am asked to prepare material on how to migrate data from legacy systems to Peoplesoft. 

I know that it can be done using import manager - but transferring one table at a time is very tidious - can somebody tell me better way. 

Also manual input will be better or tool should be used ? 

Thanks in advance 

Milind
 
***************** End Of Article ****************** 
 
Dave Gordon posted Message 78 in Message Board 
 
Dated  : March 03, 1999 at 10:21:38 EST
Subject: Re: Data Migration from Legacy systems 
 
Hi Milind,

You have a number of options for getting data into the system, but all of them are tedious.  But that's in keeping with the iterative, detail-oriented, painful nature of mapping old records to new representations.

Import Manager is probably the slowest, but provides the most comprehensive edits.  If you have significant data hygiene problems and a low volume of data, it's sometimes the best choice.  More often, you're better off exporting the data from the legacy system, performing whatever translations and substitutions are required (either in a staging table using SQR, or right in the ASCII files using Perl), and then import using the RDBMS tools.  Oracle has a facility called SQL Loader which is quite fast, but your data needs to be prepared as ASCII files.  Other platforms have other tools.  

Regards,

Dave

: Hi, 

: I am working on Peoplesoft HRMS - Recruit workforce and admin workforce module. I am asked to prepare material on how to migrate data from legacy systems to Peoplesoft. 

: I know that it can be done using import manager - but transferring one table at a time is very tidious - can somebody tell me better way. 

: Also manual input will be better or tool should be used ? 

: Thanks in advance 

: Milind


 
***************** End Of Article ****************** 
 
David Thornton posted Message 79 in Message Board 
 
Dated  : March 04, 1999 at 12:12:39 EST
Subject: Tools for Data Migration from Legacy systems 
 
There are also a few tools out on the market now which are specializing in data migration which we looked at recently.  A new one called the Reliant Bridge for PeopleSoft runs very quickly and automatically runs through basic PeopleSoft edits such as required fields and prompt table lookups.  I think we will end up using this one if they get it GA in time for our deadlines(the new release is Beta right now).

There are also other programs which generate SQR code or similar.  Prices can vary wildly, so it really depends on how much data you will be trying to move.

: Hi Milind,

: You have a number of options for getting data into the system, but all of them are tedious.  But that's in keeping with the iterative, detail-oriented, painful nature of mapping old records to new representations.

: Import Manager is probably the slowest, but provides the most comprehensive edits.  If you have significant data hygiene problems and a low volume of data, it's sometimes the best choice.  More often, you're better off exporting the data from the legacy system, performing whatever translations and substitutions are required (either in a staging table using SQR, or right in the ASCII files using Perl), and then import using the RDBMS tools.  Oracle has a facility called SQL Loader which is quite fast, but your data needs to be prepared as ASCII files.  Other platforms have other tools.  

: Regards,

: Dave

: : Hi, 

: : I am working on Peoplesoft HRMS - Recruit workforce and admin workforce module. I am asked to prepare material on how to migrate data from legacy systems to Peoplesoft. 

: : I know that it can be done using import manager - but transferring one table at a time is very tidious - can somebody tell me better way. 

: : Also manual input will be better or tool should be used ? 

: : Thanks in advance 

: : Milind


 
***************** End Of Article ****************** 
 
Dan Dudley posted Message 80 in Message Board 
 
Dated  : March 10, 1999 at 12:50:45 EST
Subject: Speeding up the upgrade process. 
 
The batch components of a PeopleSoft applications consists of SQR’s, COBOL, PS/Query, Mass Change, and Application Engine. PeopleSoft identifies these as ‘Non Comparable Objects’, subsequently these components are not included in the PeopleSoft upgrade process. 

The process of upgrading the batch components of the application consists of the following steps:

Identification of customized and added objects in the current production application 
Identification of changes to data structures (PeopleSoft Records and Fields) in the new release 
Identification of data structure changes in the new release that are referenced within the customized and added objects 
Determining the correct action to be performed to upgrade the batch module to the new release 
Upgrade batch modules and test 
The above process is fairly tedious and time-consuming which can affect the overall timeline of the upgrade project.

We have developed a solution for this process called "UBAS" (upgrad batch analysis solution) it automates the process.
Find out more about this solution at www.pyramidworldwide.com
 
***************** End Of Article ****************** 
 
Gary Hlapcic posted Message 81 in Message Board 
 
Dated  : March 12, 1999 at 11:41:53 EST
Subject: Re: PeopleSoft Financials on Citrix
 
Hi There,

Peoplesoft prints out to LTP1 and as such does not allow you to print to the printer of your choice, we are just in the process of coming up with a solution at the client site where I am now. Email me at garyhlapcic@winn-dixie.com and I will keep you up to date on our solution.

Thanks Gary

: Help, we can't get Crystal reports to print to the user's printer choice when in Citrix.  Anyone have any thots.


 
***************** End Of Article ****************** 
 
Dennis Gross posted Message 82 in Message Board 
 
Dated  : March 24, 1999 at 17:04:35 EST
Subject: SQL Server
 
I have had a very strange problem on my PC.  We basically use 2 databases, a production database (lets call it PROD), and a development database (DEV).  I am able to log in to PROD via PeopleTools; when I try to log in to DEV i get the following error message: "SQL Error. Stmt #2 Error Position: 0 Return: 8200 - Cannot connect to requested database".  I am able to access both databases in SQL Server 6.5, our backend.  I am also able to access both databases from another PC.  its only my PC that has this problem.  I've checked all the configuration files against our standard config and everything seems to match. Can someone help?
 
***************** End Of Article ****************** 
 
Clarice Rinard posted Message 83 in Message Board 
 
Dated  : March 30, 1999 at 11:59:19 EST
Subject: Re: Report Distribution
 
: Vista Plus by Quest Software might satisfy your requirements.  I saw a demo of their product at the March,99 PeopleSoft Golden Gate RUG and plan to have them come to our site for my users to review the product.  Look good and integrates with PeopleSoft.
-Clarice Rinard 


: I work for Information Builders we are a PeopleSoft Alliance Partner. We have a product called Power Reporter for PeopleSoft that does exactly what you are asking for. I can have the product ,manager contact you directly if you send me an email address. What you are describing is what is called a managed reporting environment where you can have the same report distributed via email but customized so that only the appropriate people can see or change certain type of data. The reports can be distributed through either a push or pull technology.


: 
:  : Does anyone have any experience using a report distribution tool and integrating it with PeopleSoft ?

: : We would like to be able to schedule reports to run and then be viewed using this tool.  
: : Also, we need to be able to provide different security levels within each of the reports.  For example, the CEO may be able to see the entire report, but a manager may only be able to see data that applies to a specific business unit/dept/region...

: : Any recommendations and/or things to avoid would be appreciated.


 
***************** End Of Article ****************** 
 
Satyen Bose posted Message 84 in Message Board 
 
Dated  : April 07, 1999 at 15:52:52 EST
Subject: Re: SQL Server
 
I Think i can help u. Follow the analysis
1. This problem could be with PS or with ur SQL Server client.
2. Is ur PS installation a 3 tire or a 2 tire one.
3. If it is a 2 tire one check up the ODBC Setup. Then check up the isqlw connectivity. Check up the logon domain and the previlages.
4. If it is a 3 tire setup, check ur application server's configuration and ur PCs tuxido configuration.
5. Even then if the problem persists, check the network.
6. If the network is Ok, try browsing ur database server and app server. If ur able to do this, the problem is in the sql client side. u can safely reinstall the sql server client side with out effecting the files. If u do this u can be confident of regaining the connectivity.
7. If nothing works, go the microsoft way. backup ur files in PC. Reinstall the OS. Reinstall Applications. restore ur files.
 
***************** End Of Article ****************** 
 
Satyen Bose posted Message 85 in Message Board 
 
Dated  : April 07, 1999 at 16:04:41 EST
Subject: Re: Data Migration from Legacy systems 
 
Try using Microsoft Access as a data migration tool. It will ease the job if the data volume is not beyond say 20000 rows in a table. only problem exceeding this is that u may have to do the migration in 2 steps
bose
 
***************** End Of Article ****************** 
 
Satyen Bose posted Message 86 in Message Board 
 
Dated  : April 07, 1999 at 16:25:49 EST
Subject: Re: PLSQL vs SQR
 
No. the rtrim function in PLSQL is different from the rtrim in SQR. I will make it clear with this example.
rtrim('george@usa.net',4) in PLSQL returns 'george@usa'
rtrim('george@usa.net','@') in SQR returns 'george'
Observe the 2nd parameter.
Thank You.
 
***************** End Of Article ****************** 
 
Dennis Adams posted Message 87 in Message Board 
 
Dated  : April 07, 1999 at 20:03:08 EST
Subject: Change Management Control
 
Has anyone successfully implemented a Change Control software for version control of PeopleSoft objects as well as SQRs, SQCs, etc?
Please provide comments on successes or failures.
I'm seeking any ideas, thoughts, real experience. Thanks
 
***************** End Of Article ****************** 
 
Bob Star posted Message 88 in Message Board 
 
Dated  : April 20, 1999 at 00:02:47 EST
Subject: Re: Speeding up the upgrade process. 
 
Hi:

I value your ideas and thought on speeding up the upgrade process. I have done over 6 PeoplesSoft upgrades myself and your right it's a long and painful process!! With all my experience (3 years) I do not believe this is achievable!! I have tried in the past and it just does not work. If anyone is readig this email please follow peoplesoft upgrade kit instructions on their web site. DO NOT TAKE SHORT CUTS; this would be a career limiting move!!

Concerned PS buddy 

 
***************** End Of Article ****************** 
 
Andrew Gross posted Message 89 in Message Board 
 
Dated  : April 21, 1999 at 11:59:22 EST
Subject: Maestro
 
Anyone using Maestro as a job scheduler?  My company tried AutoSys but that was not successful --- problems with implementing in a DEC Unix environment.  So, the real question....anyone used Maestro in a DEC Unix environment and is loving life?

Thanks,
Andrew Gross

 
***************** End Of Article ****************** 
 
Sanjay Todi posted Message 90 in Message Board 
 
Dated  : April 30, 1999 at 14:34:24 EST
Subject: Re: Change Management Control
 
: Has anyone successfully implemented a Change Control software for version control of PeopleSoft objects as well as SQRs, SQCs, etc?
: Please provide comments on successes or failures.
: I'm seeking any ideas, thoughts, real experience. Thanks

Hi,
PeopleSoft change control can be split into 2 areas : Change Control for objects within Peopletools e.g PeopleCode. PeopleSoft provides change control for that.

For objects like SQRs , SQCs etc - u can use any software that u are currently using for your change control on the network


 
***************** End Of Article ****************** 
 
Ray Hopkins posted Message 91 in Message Board 
 
Dated  : May 05, 1999 at 09:11:37 EST
Subject: Data Conversion and Integration Products
 
Good Morning

We're starting to develop plans for converting data from our legacy COBOL/VSAM applications to PeopleSoft Financials 7.5.
The big issues are determining the best way to map and move our current data into the new systems, and integrating some of this data back to the mainframe to be used by other applications.

My research so far has highlighted 3 products: Convoy, SmartDB, and Reliant.  The other option of course is to develop the needed processing in house.

Any experiences you've had with any of these, or other products would be appreciated. I'm also interested in any war stories you can share about efforts to do this yourself.

Thanks for your time.
Ray Hopkins
 
***************** End Of Article ****************** 
 
Brian Hirsch posted Message 92 in Message Board 
 
Dated  : May 11, 1999 at 10:38:44 EST
Subject: Change Management/Version Control
 
We’re just getting underway with our PeopleSoft Financials project and would welcome any suggestions regarding change management/version control solutions.  We’ve begun to look at Platinum, STAT! and MKS.  Anyone have an opinion on these or others?  Any comments would be most appreciated.  Thanks!  
 
***************** End Of Article ****************** 
 
John Sayre posted Message 93 in Message Board 
 
Dated  : May 12, 1999 at 12:24:24 EST
Subject: Relocation Tracking SW
 
We need to find a PeopleSoft compliant/approved SW package
which can track moving expenses & reimbursements for employees
we move.  We move ~ 3000 a year, growing faster than we like or anticipate.

Currently, this is excruciatingly labor intensive.  We use a package to track this, keying all year long, thean at the end of the year, we produce reports which are keyed into General Ledger, then into payroll. This is ugly.

Does anything exist?
 
***************** End Of Article ****************** 
 
Vikram M. Jairath posted Message 94 in Message Board 
 
Dated  : May 18, 1999 at 18:35:17 EST
Subject: Re: Debugging SQR Programs
 
I agree, PFE is the best tool to use.  I use it for all my SQR programs.  You can find a free Windows 3.x (for what its worth) version for FREE at www.download.com.



 
***************** End Of Article ****************** 
 
Doug Schorr posted Message 95 in Message Board 
 
Dated  : May 25, 1999 at 11:49:50 EST
Subject: Re: Data Conversion and Integration Products
 
Ray,

The firm that I work with has experience with both Convoy and a firm called OnDisplay.  Both have excellent migration tools that are designed to simplify, and hopefully, expedite the conversion process from a Legacy Systems to PeopleSoft (or others).  Obviously, they are contingent on how "clean" your existing data is, however, they do take most of the guess work out of the conversion and offer a more drag and drop approach to conversion and interface work.  Good luck with your conversion and overall project.  Feel free to email me if you need any assistance in contacting either vendor or wish to discuss either in more detail.
Thanks..
Doug Schorr
 
***************** End Of Article ****************** 
 
Paul Reid  posted Message 96 in Message Board 
 
Dated  : May 27, 1999 at 22:21:07 EST
Subject: Re: Installation problem 
 
CD-ROM

I would like to instal toshiba CD-ROM drive to a Toshiba laptop 
but i can not, what is it i'm doing wrong please email me suggestion.Thank you very much for just that.


 
***************** End Of Article ****************** 
 
Paul Reid  posted Message 97 in Message Board 
 
Dated  : May 27, 1999 at 22:22:54 EST
Subject: Re: Installation problem 
 
CD-ROM

I would like to instal toshiba CD-ROM drive to a Toshiba laptop 
but i can not, what is it i'm doing wrong please email your suggestion.Thank you very much.


 
***************** End Of Article ****************** 
 
m.venkanna posted Message 98 in Message Board 
 
Dated  : June 04, 1999 at 10:43:24 EST
Subject: Re: SQA Robot
 
: I need information regarding using SQA Robot to test PeopleSoft Version 7.5.  Anyone with experience utilizing this product?


 
***************** End Of Article ****************** 
 
Tim posted Message 99 in Message Board 
 
Dated  : June 04, 1999 at 16:39:06 EST
Subject: Re: PeopleSoft Financials on Citrix
 
There is possible fix to your Crystal/Citrix problem out on PS Cust Connection.  Look for the user name MBraxton. He has a document that describes a number of fixes for this and includes the location of many .dll files

: Hi There,

: Peoplesoft prints out to LTP1 and as such does not allow you to print to the printer of your choice, we are just in the process of coming up with a solution at the client site where I am now. Email me at garyhlapcic@winn-dixie.com and I will keep you up to date on our solution.

: Thanks Gary

: : Help, we can't get Crystal reports to print to the user's printer choice when in Citrix.  Anyone have any thots.


 
***************** End Of Article ****************** 
 
tony posted Message 100 in Message Board 
 
Dated  : June 09, 1999 at 02:32:05 EST
Subject: msjter32.dll problem
 
hi,i have this problem when startibg up my pc with win98, a window displaying "error launching msjter32.dll" due to not enoth
memory?
could anyone help pls?
thanks
 
***************** End Of Article ****************** 
 
Dennis Hejna posted Message 101 in Message Board 
 
Dated  : June 10, 1999 at 19:01:37 EST
Subject: Systems and Application Mgmt of PeopleSoft 7 and 7.5
 
I'm a product manager of a systems/application mgmt company which produces a PeopleSoft-specific systems management tool which helps administrators monitor application servers, tuxedo, web servers, database servers, process schedulers, etc.  I'm currently gathering requirements from current customers to refine our product, but I would also be interested in talking with others who have strong feelings about needed tools/features to monitor PeopleSoft.

Thanks

 
***************** End Of Article ****************** 
 
Naml  posted Message 102 in Message Board 
 
Dated  : June 11, 1999 at 12:20:51 EST
Subject: PS-COBOL
 
IS anyone famaliar with Peoplesoft COBOL (PS-COBOL)
 
***************** End Of Article ****************** 
 
Mike Dybis posted Message 103 in Message Board 
 
Dated  : June 14, 1999 at 07:58:15 EST
Subject: Re: PS-COBOL
 
Found this answer to an earlier posting on PS-COBOL.  Thought it might help.

PeopleSoft wrote many (most?) of their batch routines in MicroFocus COBOL. They have a single body of source code for all platforms, due to a combination of "vanilla" coding and a generic SQL interface module. If you've ever done any COBOL coding on any platform any time since Grace Hopper was a LtCdr, you'll be able to deal with it. If you're working with the HRMS product, check the PeopleBook "Designing Your Payroll System," in the chapter titled "Customizing PeopleSoft Payroll Batch Processes" for more information.



: IS anyone famaliar with Peoplesoft COBOL (PS-COBOL)


 
***************** End Of Article ****************** 
 
Dan Ozment posted Message 104 in Message Board 
 
Dated  : June 14, 1999 at 18:45:10 EST
Subject: PeopleSoft on Metaframe 1.8 with NT SP4
 
We are attempting to run PeopleSoft version 7 (PeopleTools 7.04) on Metaframe 1.8 with NT SP4.  We are receiving random MDMGETFailed messages.  PeopleSoft says we are sharing cache.  We're pretty sure we are not sharing cache at this point.  Has anyone seen this kind of error caused by something other than shared cache?   
 
***************** End Of Article ****************** 
 
Rajavel posted Message 105 in Message Board 
 
Dated  : June 15, 1999 at 03:33:41 EST
Subject: Restrac Resume reader..
 
Can someone share with any of your success stories in implementing Restrac products? It would also be helpful if you could let me know the contacts in the sales dept in Restrac(their tel no,email id, address).
Thanks in advance.

Rajavel
Cambridge Technology Partners
India
Tel no: 91-80-5583025 Ext:8514
srajav@ctp.com
 
***************** End Of Article ****************** 
 
Aaron De Los Reyes posted Message 106 in Message Board 
 
Dated  : June 15, 1999 at 14:40:52 EST
Subject: Re: Systems and Application Mgmt of PeopleSoft 7 and 7.5
 
Dennis, I would like to talk to you about working with you.
Call me at 212-338-6431
email: erperd@hotmail.com
 
***************** End Of Article ****************** 
 
JOHN BILANIN posted Message 107 in Message Board 
 
Dated  : June 17, 1999 at 15:48:04 EST
Subject: CASHIERING SYSTEM
 
We are live on AR 6.0 for Public Sector.  We are searching for a cashiering system for over the counter payments that can interface with PeopleSoft and handle both receivable items and direct payments (no receviable).

Any suggestions?

 
***************** End Of Article ****************** 
 
Wendy Cheung posted Message 108 in Message Board 
 
Dated  : June 17, 1999 at 18:24:03 EST
Subject: Report Archiving with Peoplesoft
 
My client is implementing HRMS 7.5.  Payroll users have identified the need to archive bulk report electronically for future reference.  Has anyone come across this requirement and what is your experience and recommendation?  Thanks in advance.
 
***************** End Of Article ****************** 
 
Zuke posted Message 109 in Message Board 
 
Dated  : June 22, 1999 at 16:26:38 EST
Subject: Re: Restrac Resume reader..
 
Our company has been successfully using Restrac w/PS 6 but conversion to 7 has resulted in Restrac failure.  Restrac support in this matter has been , at best, less than desirable.

: Can someone share with any of your success stories in implementing Restrac products? It would also be helpful if you could let me know the contacts in the sales dept in Restrac(their tel no,email id, address).
: Thanks in advance.

: Rajavel
: Cambridge Technology Partners
: India
: Tel no: 91-80-5583025 Ext:8514
: srajav@ctp.com



 
***************** End Of Article ****************** 
 
Bob Star posted Message 110 in Message Board 
 
Dated  : June 24, 1999 at 11:38:48 EST
Subject: Re: PeopleSoft on Metaframe 1.8 with NT SP4
 
I have heard of this too!  We are currenlty setuping up the same metaFrame Client.  Make sure the cache files reside on the actual desktop logging in and not on the MetaFrame Client!!

Do you have a configuration manual for setuping up PeopleSoft on a MetaFrame Client.  

Please contact me via email: bstar25@hotmail.com


: We are attempting to run PeopleSoft version 7 (PeopleTools 7.04) on Metaframe 1.8 with NT SP4.  We are receiving random MDMGETFailed messages.  PeopleSoft says we are sharing cache.  We're pretty sure we are not sharing cache at this point.  Has anyone seen this kind of error caused by something other than shared cache?   


 
***************** End Of Article ****************** 
 
Rob Christensen posted Message 111 in Message Board 
 
Dated  : June 28, 1999 at 08:34:07 EST
Subject: NEW DIMENSION/CONTROL SA
 
We are looking for other PeopleSoft users that also use the CONTROL SA Security package.  If you are using both or contemplating using both, please send me an e-mail.   
 
***************** End Of Article ****************** 
 
Zuke posted Message 112 in Message Board 
 
Dated  : June 29, 1999 at 17:52:05 EST
Subject: dept tree
 
Has anyone using SAP finacials w/PS HR, developed a scheme to synch SAP's dynamic dept structure w/PS dept tree to maintain accurate security ?  (the difficulty arises due to SAP storing "sub-branches" between the parent and child branch that would equate to many undesired dummy levels in PS dept tree to accommodate the exceptions) 
 
***************** End Of Article ****************** 
 
Mike Murray posted Message 113 in Message Board 
 
Dated  : June 30, 1999 at 11:44:24 EST
Subject: Printing Bind Variables in Crystal Report Heading
 
I have a Crystal/Query report that is run from the Process Scheduler. The user is prompted for ‘From Date’  & ‘Thru Date’ which are written to the RC_PAY run control record. The report runs fine and all is well.
The question is how do I include the BIND Variables RC_PAY.FROMDATE & RC_PAY.THRUDATE in the heading of the Crystal report? The only database fields I can get at are the fields actually used in the query.
Any help would be greatly appreciated!

Thanks,
Mike Murray
murray@rell.com

 
***************** End Of Article ****************** 
 
me posted Message 114 in Message Board 
 
Dated  : July 01, 1999 at 14:13:07 EST
Subject: Re: Printing Bind Variables in Crystal Report Heading
 
:Just go into the query and select the from/to date fields. This will allow the fields to be added to the report.

: I have a Crystal/Query report that is run from the Process Scheduler. The user is prompted for ‘From Date’  & ‘Thru Date’ which are written to the RC_PAY run control record. The report runs fine and all is well.
: The question is how do I include the BIND Variables RC_PAY.FROMDATE & RC_PAY.THRUDATE in the heading of the Crystal report? The only database fields I can get at are the fields actually used in the query.
: Any help would be greatly appreciated!

: Thanks,
: Mike Murray
: murray@rell.com


 
***************** End Of Article ****************** 
 
Jeffrey Fuller posted Message 115 in Message Board 
 
Dated  : July 02, 1999 at 10:53:08 EST
Subject: Bus-Tech's ESCON channel adapter (API)?
 
I am considering the purchase of a Bus-Tech (EnterpriseExpress Adapter/ESCON) adapter, to channel-attach my DB2 database to my NT platform server. I want to know if any one knows what their application-programming interface (API) can do for my data center. Their sale person stated that it's a non-intrusive processor, in turn lowering my CPU usage on the server... Does anyone have any experience with this?

Thanks for any input

 
***************** End Of Article ****************** 
 
Mike Murray posted Message 116 in Message Board 
 
Dated  : July 02, 1999 at 13:15:47 EST
Subject: Re: Printing Bind Variables in Crystal Report Heading
 
The 'From' & 'To' dates are a range. The data selected is any row with any date in that range. I need to display the Bind Variable values entered by the user. I need to display the limits of the selection not the data selected.

: :Just go into the query and select the from/to date fields. This will allow the fields to be added to the report.

: : I have a Crystal/Query report that is run from the Process Scheduler. The user is prompted for ‘From Date’  & ‘Thru Date’ which are written to the RC_PAY run control record. The report runs fine and all is well.
: : The question is how do I include the BIND Variables RC_PAY.FROMDATE & RC_PAY.THRUDATE in the heading of the Crystal report? The only database fields I can get at are the fields actually used in the query.
: : Any help would be greatly appreciated!

: : Thanks,
: : Mike Murray
: : murray@rell.com


 
***************** End Of Article ****************** 
 
G.Reddy posted Message 117 in Message Board 
 
Dated  : July 02, 1999 at 22:08:51 EST
Subject: Saving crystal Reports
 
Hey Guys,

Can anybody please suggest me how to restrict the end user 
to save the crystal report in a single directory rather than allowing them to save whereever they want, after running it through the Process Scheduler. I will really appreciate any
useful suggestion.
G.Reddy


 
***************** End Of Article ****************** 
 
DBA posted Message 118 in Message Board 
 
Dated  : July 06, 1999 at 16:30:29 EST
Subject: Re: Saving crystal Reports
 
If your Crystal Report setup in Process Scheduler, you can edit the process definition, under PeopleTools - Process Scheduler - Use - Process Definition - Process Definition Options.  There you will find the "Output Destination Parms".  Make your Output Des Type be "Printer", your Output Dest Source be "none" and your Output Destination be your name of your printer.  In the case of your user saving to a file, you can do the same setup for file and directory location.

Hope this helps
DBA
dba@ddandc.com

: Hey Guys,

: Can anybody please suggest me how to restrict the end user 
: to save the crystal report in a single directory rather than allowing them to save whereever they want, after running it through the Process Scheduler. I will really appreciate any
: useful suggestion.
: G.Reddy


 
***************** End Of Article ****************** 
 
me again posted Message 119 in Message Board 
 
Dated  : July 07, 1999 at 11:00:52 EST
Subject: Re: Printing Bind Variables in Crystal Report Heading
 
Ahhh... That makes things a little more difficult. Have you thought about creating a run control record with a from date and two date field? You could pass the OPRID/RC ID/DATE FIELDS by creating a panel and process definition. This would also require adding the record to the query. In the criteria add the following bind variables. OPRID, RUN_CNTL_ID, DATE_FROM DATE_TO. You can then pass these from the panel to the query in a process definition by appending the parameters. Let me know if you need more detail.

: The 'From' & 'To' dates are a range. The data selected is any row with any date in that range. I need to display the Bind Variable values entered by the user. I need to display the limits of the selection not the data selected.

: : :Just go into the query and select the from/to date fields. This will allow the fields to be added to the report.

: : : I have a Crystal/Query report that is run from the Process Scheduler. The user is prompted for ‘From Date’  & ‘Thru Date’ which are written to the RC_PAY run control record. The report runs fine and all is well.
: : : The question is how do I include the BIND Variables RC_PAY.FROMDATE & RC_PAY.THRUDATE in the heading of the Crystal report? The only database fields I can get at are the fields actually used in the query.
: : : Any help would be greatly appreciated!

: : : Thanks,
: : : Mike Murray
: : : murray@rell.com


 
***************** End Of Article ****************** 
 
Robin G.J.F. Hood posted Message 120 in Message Board 
 
Dated  : July 08, 1999 at 08:07:46 EST
Subject: Re: Printing Bind Variables in Crystal Report Heading
 
One way is to alter the record/view that your Crystal/Query uses to include (ie join) the required fields from the runcontrol.  You'll also need to parameterize the WHERE clause to accept the RUNCNTLID (from Proc Sched) so that you dont end up with a huge Cartesian Product.

Then the View that your crystal uses will 'see' the required fields.

Not pretty; but it works.



: I have a Crystal/Query report that is run from the Process Scheduler. The user is prompted for ‘From Date’  & ‘Thru Date’ which are written to the RC_PAY run control record. The report runs fine and all is well.
: The question is how do I include the BIND Variables RC_PAY.FROMDATE & RC_PAY.THRUDATE in the heading of the Crystal report? The only database fields I can get at are the fields actually used in the query.
: Any help would be greatly appreciated!

: Thanks,
: Mike Murray
: murray@rell.com


 
***************** End Of Article ****************** 
 
Bahar Yildiz posted Message 121 in Message Board 
 
Dated  : July 09, 1999 at 14:04:28 EST
Subject: 6.0 Crystal Installation
 

Hello,

I have a question about installing Crsytal 6.0 from Network.  

--> What kind of installation is needed to run Crystal Reports for users? (Runtime, Workstation, Full).  How do I set this up on Network, so users can install Crystal from Network?

Thanks a lot in advance

Bahar Yildiz
 
***************** End Of Article ****************** 
 
Eric D posted Message 122 in Message Board 
 
Dated  : July 09, 1999 at 18:50:35 EST
Subject: COGNOS
 
I am using COGNOS PowerPlay (windows and Web)as a front end reporting tool to our Peoplesoft module. I am using the Peoplesoft cube manager to build the output. I would like to display dates values with the COGNOS powerplay output. 

The date values are associated attibutes but I want to display them in the column along with the measures. My desired result is a spreadsheet like display with the associated date values (I am displaying begin dates and end dates) in columns next to the measures columns. Any suggestions? 
 
***************** End Of Article ****************** 
 
Tom Harvey posted Message 123 in Message Board 
 
Dated  : July 12, 1999 at 12:40:22 EST
Subject: Any recommendations on tools to help understand application performance?
 
I am looking for recommendations for tools that have helped predict the preformance of Peoplesoft Applications.

Also anything that could help troubleshoot performance problems would be great.

Tom.
 
***************** End Of Article ****************** 
 
Harry Zimmerman posted Message 124 in Message Board 
 
Dated  : July 12, 1999 at 13:15:35 EST
Subject: Re: Any recommendations on tools to help understand application performance?
 
We have been using a product called Optimal Application Expert from Optimal Networks. It has been extemely useful in allowing us both to predict the applications performance and troubleshoot. Has some great visualizations of how the application is behaving and where to drill down to resolve the problems - client, server, network.

Check out the technical white paper on PeopleSoft's Customer area. Called Network Traffic Analysis

Their web site is www.optimal.com

Great product, worth looking at. 

Harry

: I am looking for recommendations for tools that have helped predict the preformance of Peoplesoft Applications.

: Also anything that could help troubleshoot performance problems would be great.

: Tom.


 
***************** End Of Article ****************** 
 
Cindy Noteboom posted Message 125 in Message Board 
 
Dated  : July 12, 1999 at 16:48:36 EST
Subject: Terminal Server Configuration
 
Does anybody have configuration information for PeopleSoft 7.51 and Terminal Server using MS SQL Server 6.5 as the db?  I am having specific problems with location of the cache files and access the db from the terminal server.  Any help or hints on this would be greatly appreciated!
 
***************** End Of Article ****************** 
 
G.Reddy posted Message 126 in Message Board 
 
Dated  : July 12, 1999 at 21:13:14 EST
Subject: Re: Saving crystal Reports
 
I have tried doing that, but it doesn't seem to work.
May be I am missing something.But thanks anyway for your
input.
: If your Crystal Report setup in Process Scheduler, you can edit the process definition, under PeopleTools - Process Scheduler - Use - Process Definition - Process Definition Options.  There you will find the "Output Destination Parms".  Make your Output Des Type be "Printer", your Output Dest Source be "none" and your Output Destination be your name of your printer.  In the case of your user saving to a file, you can do the same setup for file and directory location.

: Hope this helps
: DBA
: dba@ddandc.com

: : Hey Guys,

: : Can anybody please suggest me how to restrict the end user 
: : to save the crystal report in a single directory rather than allowing them to save whereever they want, after running it through the Process Scheduler. I will really appreciate any
: : useful suggestion.
: : G.Reddy


 
***************** End Of Article ****************** 
 
Mark Tuente posted Message 127 in Message Board 
 
Dated  : July 13, 1999 at 09:02:04 EST
Subject: Re: Data Migration from Legacy systems 
 
SmartDB Corporation has a GUI tool to do data migration, including transformation and validation features of source data. They also have pre defined solutions for PeopleSoft. Have a look at www.smartdb.com.


regards,

Mark
 
***************** End Of Article ****************** 
 
Bob Bessin posted Message 128 in Message Board 
 
Dated  : July 16, 1999 at 23:12:35 EST
Subject: Re: Data Conversion and Integration Products
 
Ray,
I am with Convoy and would be happy to share experiences with over 150 customers who have coverted their PeopleSoft application data using our tool.  You can talk to them directly, we have very satisfied customers in just about every kind of business and size.  Contact me and we can discuss.
Regards,
Bob Bessin
Convoy Corp.


: Good Morning

: We're starting to develop plans for converting data from our legacy COBOL/VSAM applications to PeopleSoft Financials 7.5.
: The big issues are determining the best way to map and move our current data into the new systems, and integrating some of this data back to the mainframe to be used by other applications.

: My research so far has highlighted 3 products: Convoy, SmartDB, and Reliant.  The other option of course is to develop the needed processing in house.

: Any experiences you've had with any of these, or other products would be appreciated. I'm also interested in any war stories you can share about efforts to do this yourself.

: Thanks for your time.
: Ray Hopkins


 
***************** End Of Article ****************** 
 
Mike Orr posted Message 129 in Message Board 
 
Dated  : July 21, 1999 at 11:40:51 EST
Subject: Tuition Reimbursement
 
How are you handling the $5250 education reimbursement.  Is it automatically rolling anything over the $5250 into taxable income?
 
***************** End Of Article ****************** 
 
Lynn posted Message 130 in Message Board 
 
Dated  : July 21, 1999 at 12:54:02 EST
Subject: Running Query to Crystal
 
Can open a query up no problem in Crystal, but cannot run a query to Crystal in PeopleSoft. One user us getting an Access Denied Error (not a security issue), and Crystal still opens, and another user keeps getting an illegal operation and it shuts down.
Using PeopleTools 7.53 and Crystal 5. 
Any suggestions? 
 
***************** End Of Article ****************** 
 
cindy posted Message 131 in Message Board 
 
Dated  : July 26, 1999 at 18:53:26 EST
Subject: Re: Running Query to Crystal
 
: Can open a query up no problem in Crystal, but cannot run a query to Crystal in PeopleSoft. One user us getting an Access Denied Error (not a security issue), and Crystal still opens, and another user keeps getting an illegal operation and it shuts down.
: Using PeopleTools 7.53 and Crystal 5. 
: Any suggestions? 

Make sure you have the proper configuration in ODBC 32.  You must have the databases defined under User DSN for Crystal to work in PeopleSoft otherwise you will get the access denied error.
 
***************** End Of Article ****************** 
 
Alan Blevins posted Message 132 in Message Board 
 
Dated  : July 27, 1999 at 15:25:33 EST
Subject: PeopleTools and SQR
 
I have a permanent opening in Tampa, FL for a PeopleSoft Developer with experience in PeopleTools and SQR. If you can refer someone we will pay you $1200.00 if they are hired.
Thank You
 
***************** End Of Article ****************** 
 
Karl Swain posted Message 133 in Message Board 
 
Dated  : July 28, 1999 at 08:52:48 EST
Subject: Laser Check Printing & Barcodes
 
Capella Technologies offers a variety of hardware and software products that integrate industry standard Hewlett Packard® LaserJet® printers into PeopleSoft® environments. Some of these solutions complement PeopleSoft's manufacturing applications by providing users with cost-effective, LaserJet based barcoding solutions. Some extend PeopleSoft's payroll and accounts payable functions with MICR capabilities. And others enhance printer accountability and output security.

Check out www.capellatech.com


 
***************** End Of Article ****************** 
 
Sean posted Message 134 in Message Board 
 
Dated  : July 30, 1999 at 14:08:59 EST
Subject: Cursor versues Set processing in SQR
 
Can anyone explain how set-processing is done in database enviorments and how to implement this functionality over cursor-processing in SQR.

We are trying to speed up a large table read that inserts new values within the same table based on transactions from within the SQR.

Thanks,
Sean King
614-223-266
 
***************** End Of Article ****************** 
 
Jagadish posted Message 135 in Message Board 
 
Dated  : August 03, 1999 at 12:39:32 EST
Subject: NetObjects Fusion 3.0
 
Hi,

We have built few pages in the Net Objects Fusion 3.0.
We are able to connect and fetch data from the Access database( which is default)
When we try to connect these pages with Peoplesoft through ODBC, it opens the PS SignOn screen.  When we enter, it  says 'ODBC failed'.  

Any suggestions......
 
***************** End Of Article ****************** 
 
DBA posted Message 136 in Message Board 
 
Dated  : August 04, 1999 at 14:47:18 EST
Subject: Re: NetObjects Fusion 3.0
 
In your config manager, under Client Install, did you do setup for ODBC and reinstall your workstation???


: Hi,

: We have built few pages in the Net Objects Fusion 3.0.
: We are able to connect and fetch data from the Access database( which is default)
: When we try to connect these pages with Peoplesoft through ODBC, it opens the PS SignOn screen.  When we enter, it  says 'ODBC failed'.  

: Any suggestions......



 
***************** End Of Article ****************** 
 
Tim posted Message 137 in Message Board 
 
Dated  : August 05, 1999 at 13:33:42 EST
Subject: Citrix/Notes/WorkFlow
 
Anyone currently developing or using WorkFlow in PS from a Citrix server and using Lotus Notes to process WorkFlow?
Would Notes need to be on the Citrix server?
Is there a way to see the client's Notes and use the client's local Notes to execute these types of WorkFlow requests??

Thanks,

Tim J
tojones@gate.net
 
***************** End Of Article ****************** 
 
skoob posted Message 138 in Message Board 
 
Dated  : August 09, 1999 at 22:56:28 EST
Subject: Re: Running Query to Crystal
 
:I've had a similar problem. In Config manager there is a path in the crystal folder that declares path where new reports are created. It turns out I got an error because the path actually didn't exist on my local/fileserver. Just something to check...

Sk


: Can open a query up no problem in Crystal, but cannot run a query to Crystal in PeopleSoft. One user us getting an Access Denied Error (not a security issue), and Crystal still opens, and another user keeps getting an illegal operation and it shuts down.
: Using PeopleTools 7.53 and Crystal 5. 
: Any suggestions? 


 
***************** End Of Article ****************** 
 
Ranjan posted Message 139 in Message Board 
 
Dated  : August 11, 1999 at 11:29:58 EST
Subject: Performance Management
 
Are there any tools available for monitoring app server, tuxedo logs, db, network performance? Anything better than manual examination of log files to pursue more "proactive" support.

Thanks,
 
***************** End Of Article ****************** 
 
Sean posted Message 140 in Message Board 
 
Dated  : August 11, 1999 at 12:58:44 EST
Subject: Crystal Reports QDM error
 
There is a problem with crystal reports in our production when certain users want to run a crystal report they get an ODBC error with a description of it being related to the QDM agent.

Does anyone know how this setting is initialized? We have about 20 users that have the same configuration as the other 50, but have this problem. They are running the same report templates.

The sort term fix so far has been to set the location manually in Crystal reports and then to rerun the report.

Anyone that might have suggestion your input will be appreciated.

 
***************** End Of Article ****************** 
 
Sean posted Message 141 in Message Board 
 
Dated  : August 11, 1999 at 13:15:07 EST
Subject: Re: Cursor versues Set processing in SQR
 

This has been answered!

 
***************** End Of Article ****************** 
 
D. Monnerat posted Message 142 in Message Board 
 
Dated  : August 12, 1999 at 16:43:32 EST
Subject: PSNOTES.EXE
 
Am curious if anyone has experienced the following:

We are trying to use Workflow Administrator to import Lotus Notes information through message agent.  We have it set up as indicated in PeopleBooks, however we keep running into an error in PSNOTES, which states "access violation in PSNETAPI.DLL".  Unfortunately, there is no real help availiable. 

We are running PeopleTools 7.5 on a WinNT box.

Any help would be appreciated.  Please reply to the e-mail address listed [e.david.monnerat@us.arthurandersen.com]

Thanks
 
***************** End Of Article ****************** 
 
Tim posted Message 143 in Message Board 
 
Dated  : August 14, 1999 at 19:50:54 EST
Subject: Re: Citrix/Notes/WorkFlow
 
If you have PeopleSoft installed on a Citrix Server WTS, You don't have to install Notes on this server.  Just be sure to add the C:\windows directory to your PATH for the user id logging into the Citrix server.  By doing this, you are able to find the notes.ini file when sending outbound forms in PS using Notes.  I have completed testing this on both 2 and 3 Tier using the Citrix server to run PS and the user workstation running Lotus Notes.

Answered my own question this time.
If you need help with Notes/WorkFlow/Outbound-Inbound Forms for 2 or 3 Tier, please contact me.

Tim J.   tojones@gate.net


: Anyone currently developing or using WorkFlow in PS from a Citrix server and using Lotus Notes to process WorkFlow?
: Would Notes need to be on the Citrix server?
: Is there a way to see the client's Notes and use the client's local Notes to execute these types of WorkFlow requests??

: Thanks,

: Tim J
: tojones@gate.net


 
***************** End Of Article ****************** 
 
waja posted Message 144 in Message Board 
 
Dated  : August 15, 1999 at 13:01:32 EST
Subject: Cube Manager
 
I am unable to generate (.MDC) file in Cube Manager.Appreciate if anyone can help me  on this.

 Best Regards

 Waja
 
***************** End Of Article ****************** 
 
Ju-Lien Lim posted Message 145 in Message Board 
 
Dated  : August 16, 1999 at 15:21:51 EST
Subject: Re: Performance Management
 
: Are there any tools available for monitoring app server, tuxedo logs, db, network performance? Anything better than manual examination of log files to pursue more "proactive" support.

Yes...  Look into BMC Software's Patrol, Patrol Knowlege Module for PeopleSoft, and BEST/1.

Good luck!


 
***************** End Of Article ****************** 
 
Paul Phillips posted Message 146 in Message Board 
 
Dated  : August 17, 1999 at 18:09:02 EST
Subject: Financial Training Classes
 
Do any third party companies offer PeopleSoft Financial courses? If so, please let me know.

Thanks,
Paul
 
***************** End Of Article ****************** 
 
Sheila posted Message 147 in Message Board 
 
Dated  : August 22, 1999 at 18:09:28 EST
Subject: Check printing stock
 
We will soon be using Peoplesoft Financials and strangeley enough I am not able to find a print shop that would print us checks.

Any suggestions?  We are in So. CA.

Thanks
Sheila
 
***************** End Of Article ****************** 
 
ramadas_srinivas posted Message 148 in Message Board 
 
Dated  : August 25, 1999 at 17:26:12 EST
Subject: Re: Crystal Reports QDM error
 
tools->utilities->query security  
define access groups for trees for a class.


: There is a problem with crystal reports in our production when certain users want to run a crystal report they get an ODBC error with a description of it being related to the QDM agent.

: Does anyone know how this setting is initialized? We have about 20 users that have the same configuration as the other 50, but have this problem. They are running the same report templates.

: The sort term fix so far has been to set the location manually in Crystal reports and then to rerun the report.

: Anyone that might have suggestion your input will be appreciated.


 
***************** End Of Article ****************** 
 
Devi posted Message 149 in Message Board 
 
Dated  : September 02, 1999 at 10:10:31 EST
Subject: CSSHRizon - technical info. URGENT!!!!
 
Where can I find CSSHRizon product information?
 
***************** End Of Article ****************** 
 
John posted Message 150 in Message Board 
 
Dated  : September 02, 1999 at 11:21:46 EST
Subject: Imaging Products
 
Does anyone have any recommendations concerning imaging software vendors and their software packageswith PeopleSoft AP / PO module? 
 
***************** End Of Article ****************** 
 
Betsy posted Message 151 in Message Board 
 
Dated  : September 02, 1999 at 14:25:45 EST
Subject: SQR: can "on-break" be used with dynamic search criteria?
 
Hi-
I want to use on-break with a dynamic order by clause.  The user can choose one of three sort criteria and I need to print a sbutotal (using after) depending on which they choose.  Is this possible in SQR 4?

Betsy
 
***************** End Of Article ****************** 
 
Dave Gordon posted Message 152 in Message Board 
 
Dated  : September 03, 1999 at 12:25:14 EST
Subject: Re: SQR: can "on-break" be used with dynamic search criteria?
 
: I want to use on-break with a dynamic order by clause.  

Hi Betsy,

No problem.  For each user-specified option, set the value of a variable to be used with the "level" option in each of your on-break commands.

Regards,

Dave

 
***************** End Of Article ****************** 
 
George Y. Ragheb posted Message 153 in Message Board 
 
Dated  : September 09, 1999 at 02:08:54 EST
Subject: Laser Check Printing With PeopleSoft
 
Print checks directly from PeopleSoft tables, A/P and Payroll.  Here are some of the capabilities:
* Brio interface to query the check file
* Datawarehousing interface to upload files
* Print remotely and split the file to several printers

Please evaluate our site http://www.NationSoftinc.com or call us 949-724-0360

We look forward to partnering with you.



 
***************** End Of Article ****************** 
 
Satyen Bose posted Message 154 in Message Board 
 
Dated  : September 16, 1999 at 12:42:47 EST
Subject: Re: Cube Manager
 
Waja,
I think I can help you out with this. At the highest level, the check is to look for a MDL file. 
If MDL is available then you are close to getting your MDC.

->Open the MDL in Cognos Transformer. Check for the query. Is your query right there? Check the dimension map. check for the tree or the rollup query structure you defined in cube manager. does it get reflected here? Check the measures you have defined. Do they all appear here? If these check are all positive, try building a cube in transformer. You get a mdc file. If any check fails, go back to the analysis model and check your model. You can diagonize this by ommiting the dimensions in the build template panel.

If you can't get the MDL file also, then check for the asc file. If the ac file is generated, check for the data in the asc file. If the data is present and is correct, then check for the file locations in the powerplay panel of build template. check for the write access on these locations. check for the model cube file in the working directory. 

if you cant find the asc file, then there is something wrong with  the build program. check up the log file with process instance as name. search for *PI*.*

This file is descriptive enough to direct you to solve your problem on the peoplesoft side.

Hopefully, this is of some help

bose


 
***************** End Of Article ****************** 
 
Satyen Bose posted Message 155 in Message Board 
 
Dated  : September 16, 1999 at 12:42:56 EST
Subject: Re: Cube Manager
 
Waja,
I think I can help you out with this. At the highest level, the check is to look for a MDL file. 
If MDL is available then you are close to getting your MDC.

->Open the MDL in Cognos Transformer. Check for the query. Is your query right there? Check the dimension map. check for the tree or the rollup query structure you defined in cube manager. does it get reflected here? Check the measures you have defined. Do they all appear here? If these check are all positive, try building a cube in transformer. You get a mdc file. If any check fails, go back to the analysis model and check your model. You can diagonize this by ommiting the dimensions in the build template panel.

If you can't get the MDL file also, then check for the asc file. If the ac file is generated, check for the data in the asc file. If the data is present and is correct, then check for the file locations in the powerplay panel of build template. check for the write access on these locations. check for the model cube file in the working directory. 

if you cant find the asc file, then there is something wrong with  the build program. check up the log file with process instance as name. search for *PI*.*

This file is descriptive enough to direct you to solve your problem on the peoplesoft side.

Hopefully, this is of some help

bose


 
***************** End Of Article ****************** 
 
Guillaume MORTIER posted Message 156 in Message Board 
 
Dated  : September 17, 1999 at 07:05:54 EST
Subject: Crystal: is there a way to pass prompts to subreports ?
 

I've got the following problem:

Consider a main report printing data from a "main" query that has some prompts. These prompts are passed from Process Scheduler.

Now, I want to add a subreport that is based on a "sub-query". No problem if the sub-query doesn't have prompts.
But if I want to use prompts in my subquery, I'm asked to enter them at runtime.

My question is: is there a way to pass these parameters from the main report to the subquery ? 

Thanks for help.
 
***************** End Of Article ****************** 
 
John Coffin posted Message 157 in Message Board 
 
Dated  : September 29, 1999 at 00:09:12 EST
Subject: Re: Maestro
 
: Anyone using Maestro as a job scheduler?  My company tried AutoSys but that was not successful --- problems with implementing in a DEC Unix environment.  So, the real question....anyone used Maestro in a DEC Unix environment and is loving life?

: Thanks,
: Andrew Gross

I am evaluating Tivoli Maestro as a job scheduler.
Have you had any responses to this problem?

Cheers,
John Coffin
 
***************** End Of Article ****************** 
 
Mark Halverson posted Message 158 in Message Board 
 
Dated  : September 29, 1999 at 15:20:44 EST
Subject: running an sqr report directly to a printer
 
I'm trying to run an sqr report from the process scheduler.  I input data into my run control and then attempt to direct the report to my network printer by selecting server as the run location and printer as the output destination.  I set file/printer value to \\printserver\printname.  All of this results in an error from sqr that is saying that the .spf file can not be found.  I'm only creating a .lis file and I don't want to create a .spf file.  Does anyone know how I can simply direct this sqr to print the .lis to the designated network printer?

Thanks in advance,
Mark H.
 
***************** End Of Article ****************** 
 
Manoj posted Message 159 in Message Board 
 
Dated  : September 29, 1999 at 16:15:13 EST
Subject: Re: running an sqr report directly to a printer
 
Mark,

I think in your process defination SQR flag -KEEP is on.
Take that out, because it create both .lis n .spf files.
Printer doesn't get .spf file, so got the error.

-Manoj.

: I'm trying to run an sqr report from the process scheduler.  I input data into my run control and then attempt to direct the report to my network printer by selecting server as the run location and printer as the output destination.  I set file/printer value to \\printserver\printname.  All of this results in an error from sqr that is saying that the .spf file can not be found.  I'm only creating a .lis file and I don't want to create a .spf file.  Does anyone know how I can simply direct this sqr to print the .lis to the designated network printer?

: Thanks in advance,
: Mark H.


 
***************** End Of Article ****************** 
 
E. Monnerat posted Message 160 in Message Board 
 
Dated  : October 01, 1999 at 11:23:34 EST
Subject: Re: PSNOTES.EXE
 
I'm not sure if you are receiving the error message for the same reason we did, but we got that error message every time we tried to run the MessageAgentAPI in 2-tier mode.  When we ran it in three-tier mode, we had no issues (other than the lack of standard functionality and lack of decent error handling).



: Am curious if anyone has experienced the following:

: We are trying to use Workflow Administrator to import Lotus Notes information through message agent.  We have it set up as indicated in PeopleBooks, however we keep running into an error in PSNOTES, which states "access violation in PSNETAPI.DLL".  Unfortunately, there is no real help availiable. 

: We are running PeopleTools 7.5 on a WinNT box.

: Any help would be appreciated.  Please reply to the e-mail address listed [e.david.monnerat@us.arthurandersen.com]

: Thanks


 
***************** End Of Article ****************** 
 
Lori Shemka posted Message 161 in Message Board 
 
Dated  : October 01, 1999 at 22:16:00 EST
Subject: Re: Imaging Products
 
If you're looking for a solution to archive your PeopleSoft reports, take a look at Cypress.  Among many other things, Cypress seamlessly integrates with PeopleSoft and allows you to archive, search and retrieve those reports -- via a traditional client or web browser.

: Does anyone have any recommendations concerning imaging software vendors and their software packageswith PeopleSoft AP / PO module? 


 
***************** End Of Article ****************** 
 
Jon Beck posted Message 162 in Message Board 
 
Dated  : October 14, 1999 at 09:54:10 EST
Subject: PS Time & Labor is no good, HELP!
 
PS time and labor looks too complicated and I was told that it does not work well.  Does anyone know of another way to get this information into PS (e.g., an add-on software package)?  Thanks. 


 
***************** End Of Article ****************** 
 
Anil Singh posted Message 163 in Message Board 
 
Dated  : October 14, 1999 at 09:58:28 EST
Subject: Version Control
 
Hi,
I am apart of the asessment group working on FAST project involving implementation of Peoplesoft HR,FINANCIALS & Student Administration packages on the University of Houston,Texas.
Currently we are evaluating the use of VSS(Visual Source Safe)for version control but I doubt its validity when it comes to working on tables since it works on file structures.I would like to know about any third party software available which is compatible with Peoplesoft.Any suggestions are welcome.

ANIL SINGH
(Assessment Group-FAST project,UH)    
 
***************** End Of Article ****************** 
 
TJ posted Message 164 in Message Board 
 
Dated  : October 14, 1999 at 10:31:43 EST
Subject: Re: Version Control
 
PVCS (Windows version) works for us.
www.pvcs.com
Hope this helps
TJ

: Hi,
: I am apart of the asessment group working on FAST project involving implementation of Peoplesoft HR,FINANCIALS & Student Administration packages on the University of Houston,Texas.
: Currently we are evaluating the use of VSS(Visual Source Safe)for version control but I doubt its validity when it comes to working on tables since it works on file structures.I would like to know about any third party software available which is compatible with Peoplesoft.Any suggestions are welcome.

: ANIL SINGH
: (Assessment Group-FAST project,UH)    


 
***************** End Of Article ****************** 
 
Dave Gordon posted Message 165 in Message Board 
 
Dated  : October 14, 1999 at 11:41:42 EST
Subject: Re: Version Control
 
Hi Anil,

Visual Source Safe and PVCS are both file-oriented version control packages.  PVCS is more popular with "large iron" people because it's supported on multiple platforms, VSS is more popular with the Wintel crowd.  I've also used TLib, which is real popular with vertical market product developers who need to maintain multiple versions of their product, simultaneously.  The project I'm currently on is about to install ClearCase, which is their corporate standard (I haven't used it yet).  Any of the four will work just fine for maintaining the SQR, COBOL, DMS and SQL files you'll accumulate in a PeopleSoft implementation.

But, you mentioned tables - there's no way to store a table in a VCS, unless you dump it to a text file and store it that way.  There's also no way to store an on-line object, and then revert back to it.  It's just one of the limitations of the system.  

Regards,

Dave

 
***************** End Of Article ****************** 
 
Mark Halverson posted Message 166 in Message Board 
 
Dated  : October 14, 1999 at 12:35:34 EST
Subject: Crystal reports - Selecting a network printer
 
Through the process scheduler, I'm trying to print a Crystal report to a specific network printer.  My problem is that the report is printed to a different network printer, not the one I specified.  Shouldn't I be able to specify any printer when I run the report from the server and specify printer as the output.  Is there some sort of security problem that says I can't specify a printer so print the report to the default printer (where would the default printer have been set up?)?  Any ideas?

Thanks,
Mark
 
***************** End Of Article ****************** 
 
Aloysius  posted Message 167 in Message Board 
 
Dated  : October 18, 1999 at 08:02:52 EST
Subject: Fusion  NFX Components
 
Has anyone made use of NetObjects Fusion 4.0 to deploy PS panels
to the web?
If you have, read on....

How do you activate the "nfx" button from the Tools Palette?
I have copied the PeopleSoft components into the NetObjects directory (i.e. c:\Netobj4. And what appears in the PeopleSoft Components toolbar are 4 look-alike "wheels".

When trying to do a drag & drop by clicking on the "PanelAppletComp", I get this error message:
"NFXComponentManager.CreateBrick Failed :PanelObj"

Kindly advise on how do I get around this problem...
Thanks in advance.

 
***************** End Of Article ****************** 
 
Anil Singh posted Message 168 in Message Board 
 
Dated  : October 21, 1999 at 09:26:22 EST
Subject: Re: Change Management/Version Control
 
: We’re just getting underway with our PeopleSoft Financials project and would welcome any suggestions regarding change management/version control solutions.  We’ve begun to look at Platinum, STAT! and MKS.  Anyone have an opinion on these or others?  Any comments would be most appreciated.  Thanks!  

_Hi Brian!
I am working on a project similar to yours .I have checked out PVCS and VSS but thye don't serve our purpose of storing objects and not files for version control .I am ver ycurious about STAT! but could not get any informaiton on the web .It would be very helpful if you could pass on information as to where to obtain data for the above softwares from.

Thanks,
Anil 
 
***************** End Of Article ****************** 
 
cindy noteboom posted Message 169 in Message Board 
 
Dated  : October 21, 1999 at 14:39:41 EST
Subject: Metaframe Configuration
 
Does anybody have good documentation for installing PeopleSoft on Terminal Server with Metaframe?  My installation is about 95% complete, but I am having troubles with the ODBC drivers in multi-user mode. I have run the ODBC install script and still cannot access this control panel from any user other than administrator.  This means I cannot connect in two-tier mode AND I cannot run Crystal Reports. (I'm on tools version 7.56, but do not think this is important) Any advice would be greatly appreciated!
 
***************** End Of Article ****************** 
 
Alok Agrawal posted Message 170 in Message Board 
 
Dated  : October 28, 1999 at 08:54:13 EST
Subject: Re: SQA Robot
 
: : I need information regarding using SQA Robot to test PeopleSoft Version 7.5.  Anyone with experience utilizing this product?

: I terry,

: I use SQA team suite for testing peoplesoft financials and HR from the team developpment. What information do you need ?

Hi, 
I am Alok(Alok.Aggarwal@db.com) here :

I just wanted to know wheather any Pre-recorded test cases are available for PeopleSoft HRMS 7.0 (PeopleTools 7.05). For yours information, I enquired from PeopleSoft Global Support division,Germany.According to them it (pre-recorded) is available for PeopleSoft 6.0 but NOT for version 7.0. 

Would be appreciable if U can directly reply to mail-id.

Thanks and Regards
Alok
Alok.Aggarwal@db.com
 
***************** End Of Article ****************** 
 
Srinivas posted Message 171 in Message Board 
 
Dated  : October 30, 1999 at 05:05:14 EST
Subject: Re: SQA Robot
 
 I need information regarding using SQA Robot to test delphi project.  Anyone with experience utilizing this product?
send the details.

with regards
srinivas

 
***************** End Of Article ****************** 
 
klaas posted Message 172 in Message Board 
 
Dated  : October 31, 1999 at 11:45:27 EST
Subject: Re: PSNOTES.EXE
 
thank you for using me psnotes
 
***************** End Of Article ****************** 
 
Dan S posted Message 173 in Message Board 
 
Dated  : November 01, 1999 at 19:02:15 EST
Subject: Vertex
 
Is anyone use Vertex with Peoplesoft?
 
***************** End Of Article ****************** 
 
SARAH posted Message 174 in Message Board 
 
Dated  : November 02, 1999 at 11:31:19 EST
Subject: URGENT. LEGAL PAPER.
 
HOW DO U SEND A COMMAND TO THE PRINTER FROM A SQR TO PRINT LEGAL I.E. (8.5,14) WITHOUT USING DECLARE-LAYOUT ?
DOES ANYONE KNOW THE ESCAPE STRINGS FOR HPLASERJET?
I TRIED USING


#ifdef PAPER_SIZE LETTER
#define PAPER_SIZE LEGAL
#else
#define PAPER_SIZE LEGAL
#endif

IN MY BEGIN-SETUP BUT LOOKS LIKE NOT WORKING, WHY?

THANKS IN ADVANCE


 
***************** End Of Article ****************** 
 
sarah posted Message 175 in Message Board 
 
Dated  : November 02, 1999 at 12:07:33 EST
Subject: urgent
 
HOW DO U SEND A COMMAND TO THE PRINTER FROM A SQR TO PRINT LEGAL I.E. (8.5,14) WITHOUT USING DECLARE-LAYOUT ?
DOES ANYONE KNOW THE ESCAPE STRINGS FOR HPLASERJET?
I TRIED USING


#ifdef PAPER_SIZE LETTER
#define PAPER_SIZE LEGAL
#else
#define PAPER_SIZE LEGAL
#endif

IN MY BEGIN-SETUP BUT LOOKS LIKE NOT WORKING, WHY?

THANKS IN ADVANCE


 
***************** End Of Article ****************** 
 
AJ posted Message 176 in Message Board 
 
Dated  : November 02, 1999 at 12:52:31 EST
Subject: BrainTree
 
We want to implement better password management
and are exploring BrainTree. There are several
issues with it.

Anyone know any other product?

Thanks 
 
***************** End Of Article ****************** 
 
Henry E.P. Sutjipto posted Message 177 in Message Board 
 
Dated  : November 03, 1999 at 03:58:54 EST
Subject: Crystal Report Error
 
I'm creating a new crystal report that combines several queries in sub reports. The report works well in the Crystal Report application, but I got this error when running it from PeopleSoft (Process Scheduler):

Error in formula <Section_Visibility>.'{@fetch_j}<>False'
There is an error in this formula

Is there any Crystal Report's built-in function that can not be run from PeopleSoft?
I'm using PeopleTools 7.5 with HRMS 7.0.

Thks for any help!


 
***************** End Of Article ****************** 
 
Laxmipathi posted Message 178 in Message Board 
 
Dated  : November 04, 1999 at 14:38:11 EST
Subject: Missing invoices
 
WHen Populate Billing is run in the Billing Module certain invoice numbers are missing.  Any clue as to why it is happening.  Records for these missing number are not even available in the back-end tables.

Lax


 
***************** End Of Article ****************** 
 
William Woods posted Message 179 in Message Board 
 
Dated  : November 10, 1999 at 14:50:29 EST
Subject: Application Server Window NT
 

Has anyone had any problem with the Application Server
We have been running for 11 months and the App Server has been
running fine, however this week we have been receiving the
error LIBTUX_CAT 334 NO BBL. we have not made any changes to 
our WIndows NT server. If anyone has any hints i'd appreciate
them.
 Thanks Bill Woods
 
***************** End Of Article ****************** 
 
Dan posted Message 180 in Message Board 
 
Dated  : November 15, 1999 at 08:02:16 EST
Subject: Re: Missing invoices
 
What type of third party tax software are you using?

 
***************** End Of Article ****************** 
 
srinivas posted Message 181 in Message Board 
 
Dated  : November 16, 1999 at 09:55:41 EST
Subject: SQR
 
I have data in flat files - I need a method to transfer data from flat files to Excel sheet in a SQR program.
Plz suggest me a method to do that!

Thanks in advance.

 


 
***************** End Of Article ****************** 
 
Dave Gordon posted Message 182 in Message Board 
 
Dated  : November 16, 1999 at 10:28:44 EST
Subject: Alternative To SQR
 
: I need a method to transfer data from flat files to Excel sheet 

Hi Srinivas,

If that's all you want to do, I'd suggest you either import it directly into Excel, or use Perl.  Naba Barkakati wrote a really good Perl book (although I can't recall the exact title) which includes an example that does exactly that.  Go up to Amazon and look around under Naba's name, it won't be hard to find.  

Regards,

Dave

 
***************** End Of Article ****************** 
 
Mei Hee posted Message 183 in Message Board 
 
Dated  : November 19, 1999 at 12:47:59 EST
Subject: Re: Vertex
 
Yes, we are.  I started using it when we were in PS 7.0, we then upgraded it and now we are running 7.52 along with Vertex.

- mei
----


: Is anyone use Vertex with Peoplesoft?


 
***************** End Of Article ****************** 
 
Mei Hee posted Message 184 in Message Board 
 
Dated  : November 19, 1999 at 12:56:13 EST
Subject: Re: running an sqr report directly to a printer
 
When you are running the sqr on the server, you need to set you file/printer value to 
   "/tmp/ +P-d<youprintername>"  when you choose your output destination as printer. 

If you run the sqr on the client, then you would simply put 'lpt1' or 'lpt2' depending on your setup.

Hope this help.

- mei

---------------------

: I'm trying to run an sqr report from the process scheduler.  I input data into my run control and then attempt to direct the report to my network printer by selecting server as the run location and printer as the output destination.  I set file/printer value to \\printserver\printname.  All of this results in an error from sqr that is saying that the .spf file can not be found.  I'm only creating a .lis file and I don't want to create a .spf file.  Does anyone know how I can simply direct this sqr to print the .lis to the designated network printer?

: Thanks in advance,
: Mark H.


 
***************** End Of Article ****************** 
 
Douglas.Fraser@gems3.gov.bc.ca posted Message 185 in Message Board 
 
Dated  : November 23, 1999 at 04:09:46 EST
Subject: Novell, 3 Tier/Tuxedo 6.5, Mutexes and disappearing panels
 
Novell client using Tuxedo 6.5

Anyone running 3 Tier from a Novell client to Tuxedo 6.5?

If so, 
- are you using a DNS vs. IP Address entry for the Application Server
- are you experiencing any Mutexes or disappearing panels particularly with users running multiple panels (eg. Payroll users)

_____________________________________________
Thank you,

Douglas.Fraser@gems3.gov.bc.ca 
Husband of Michelle, Father of Pamela and Emma
(Updated 19991018) Photos: http://members.home.net/douglas.fraser/
CHIPS Workstation Support, POIM Division @ PSERC
http://www.qp.gov.bc.ca/pserc/chips/download.htm
PeopleSoft implementation: HRMS 7.02, Tools 7.05.10
548 Michigan, Victoria, BC, Canada
Phone 250-812-4359
_____________________________________________

 
***************** End Of Article ****************** 
 
Jay posted Message 186 in Message Board 
 
Dated  : November 23, 1999 at 07:52:01 EST
Subject: Re: datamart
 
: I need to know which are the datamarts used
: to generate p/l reports. our need is such that the information to
: create the PL report comes from various sources peoplesoft
: excel and other legacy system. we want an automated solution


 
***************** End Of Article ****************** 
 
Aloysius posted Message 187 in Message Board 
 
Dated  : November 24, 1999 at 01:41:54 EST
Subject: Printing of Images in SQR
 
Printer = HPLaserJet
SQR = 4.3.2

I have this issue when printing an image in SQR report.
Instead of printing the image, a shaded box appears!

The following are my settings in sqr.
begin-heading 1
  print-image (1,20)
	type=bmp-file
	image-size=(20,5)
  	source='c:\temp\logo.bmp'
end-heading

I have also tried the following settings but it does not
work either.
- type=hpgl-file 
- source='c:\temp\logo.hpgl'

Any help will be welcome.
 
***************** End Of Article ****************** 
 
Aloysius  posted Message 188 in Message Board 
 
Dated  : November 24, 1999 at 01:51:28 EST
Subject: Printing of Images in SQR
 
Printer = HPLaserJet
SQR = 4.3.2

I have this issue when printing an image in SQR report.
Instead of printing the image, a shaded box appears!

The following are my settings in sqr.
begin-heading 1
print-image (1,20)
type=bmp-file
image-size=(20,5)
source='c:\temp\logo.bmp'
end-heading

I have also tried the following settings but it does not
work either.
- type=hpgl-file 
- source='c:\temp\logo.hpgl'

Any help will be welcome. 


 
***************** End Of Article ****************** 
 
Daniel Dudley posted Message 189 in Message Board 
 
Dated  : November 29, 1999 at 11:00:04 EST
Subject: Re: Change Management/Version Control
 
You can obtain all of the information about Stat!, a Version Control/Change Management and workflow solution developed by MBR Technologies at www.mbrtechnologies.com or call 562-495-0077 ext. 1812

 
***************** End Of Article ****************** 
 
Dan Dudley posted Message 190 in Message Board 
 
Dated  : November 29, 1999 at 12:17:24 EST
Subject: Re: Change Management Control
 
Please visit www.mbrtechnologies.com for information about true Version Control for PeopleSoft.
 
***************** End Of Article ****************** 
 
Dan Dudley posted Message 191 in Message Board 
 
Dated  : November 29, 1999 at 13:08:47 EST
Subject: Re: Version Control
 
True Version Control and Change Management for PeopleSoft is available.
www.mbrtechnologies.com
 
***************** End Of Article ****************** 
 
Dan Dudley posted Message 192 in Message Board 
 
Dated  : November 29, 1999 at 13:10:58 EST
Subject: Re: Change Management/Version Control
 
True Version Control and Change Management is available for PeopleSoft.
www.mbrtechnologies.com
 
***************** End Of Article ****************** 
 
Dan Dudley posted Message 193 in Message Board 
 
Dated  : November 30, 1999 at 10:31:22 EST
Subject: Re: Change Management/Version Control
 
Stat! assists and eliminates PeopleSoft challenges such as database restores, documentation, migrations, project workflow and  speeds up full version Upgrades and allows risk free updates and fixes (Bundles,Tax Upgrades). Stat! is the "Undo" for PeopleSoft. Visit the links below for more info.

**MBR's PeopleSoft Version Control:**
  http://www.mbrtechnologies.com/html/version_control.html  

PeopleSoft Change Management:
  http://www.mbrtechnologies.com/html/change_mgt.html  

Migrations: (See Migrations Wizards and Migration History Wizard)
  http://www.mbrtechnologies.com/html/wizards1.html  

Upgrades:
  http://www.mbrtechnologies.com/html/upgrades.html  

Project and Workflow Management:
  http://www.mbrtechnologies.com/html/project_mgt.html  

MBR Technologies Homepage
  http://www.mbrtechnologies.com  



If any questions please call 562/495/0077 ext.1812



: We’re just getting underway with our PeopleSoft Financials project and would welcome any suggestions regarding change management/version control solutions.  We’ve begun to look at Platinum, STAT! and MKS.  Anyone have an opinion on these or others?  Any comments would be most appreciated.  Thanks!  


 
***************** End Of Article ****************** 
 
Dan Dudley posted Message 194 in Message Board 
 
Dated  : November 30, 1999 at 10:34:53 EST
Subject: Re: Version Control
 
Yes there is true version control for PeopleSoft. Stat! assists and eliminates PeopleSoft challenges such as database restores, documentation, migrations, project workflow and  speeds up full version Upgrades and allows risk free updates and fixes (Bundles,Tax Upgrades). Stat!is the "Undo" for PeopleSoft. Visit the links below for more info.

**MBR's PeopleSoft Version Control:**
  http://www.mbrtechnologies.com/html/version_control.html  

PeopleSoft Change Management:
  http://www.mbrtechnologies.com/html/change_mgt.html  

Migrations: (See Migrations Wizards and Migration History Wizard)
  http://www.mbrtechnologies.com/html/wizards1.html  

Upgrades:
  http://www.mbrtechnologies.com/html/upgrades.html  

Project and Workflow Management:
  http://www.mbrtechnologies.com/html/project_mgt.html  

MBR Technologies Homepage
  http://www.mbrtechnologies.com  



If any questions please call 562/495/0077 ext.1812




: Hi,
: I am apart of the asessment group working on FAST project involving implementation of Peoplesoft HR,FINANCIALS & Student Administration packages on the University of Houston,Texas.
: Currently we are evaluating the use of VSS(Visual Source Safe)for version control but I doubt its validity when it comes to working on tables since it works on file structures.I would like to know about any third party software available which is compatible with Peoplesoft.Any suggestions are welcome.

: ANIL SINGH
: (Assessment Group-FAST project,UH)    


 
***************** End Of Article ****************** 
 
Dan Dudley posted Message 195 in Message Board 
 
Dated  : November 30, 1999 at 10:45:16 EST
Subject: Re: Change Management/Version Control
 
Take a look at the following website for information on Stat! Version Control for PeopleSoft.

**MBR's PeopleSoft Version Control:**
  http://www.mbrtechnologies.com/html/version_control.html  

PeopleSoft Change Management:
  http://www.mbrtechnologies.com/html/change_mgt.html  

Migrations: (See Migrations Wizards and Migration History Wizard)
  http://www.mbrtechnologies.com/html/wizards1.html  

Upgrades:
  http://www.mbrtechnologies.com/html/upgrades.html  

Project and Workflow Management:
  http://www.mbrtechnologies.com/html/project_mgt.html  

MBR Technologies Homepage
  http://www.mbrtechnologies.com  



If any questions please call 562/495/0077 ext.1812

 
***************** End Of Article ****************** 
 
SANFACE Software posted Message 196 in Message Board 
 
Dated  : December 03, 1999 at 08:32:14 EST
Subject: Converting textual reports to PDFs
 
Would you like to solve the problem to convert on the fly the generation of textual reports to PDFs?
I ask you to evaluate txt2pdf
http://www.sanface.com/txt2pdf.html

See a few projects at
http://www.sanface.com/projects.shtml

We've also just finished to developed the new txt2pdf 3.x PRO.
The important new feature is layer support.
With 2.x family you can put your text on white PDF pages.
With 3.x you can create layers (background and foreground) using JPEG images, designing with PDF syntax, writing with PDF syntax (you can use all the 14 default fonts), using links.

Don't hesitate to contact us.
 
***************** End Of Article ****************** 
 
Sunil S posted Message 197 in Message Board 
 
Dated  : December 06, 1999 at 00:30:51 EST
Subject: Re: Tools for Data Migration from Legacy systems 
 
hi all, 
I was told to look in for some of the best tools available which can migrate data from legacy systems to oracle and also how the transfer takes plase viz., is it done through some data extract drivers , if so what is format through which it is migrated or  does it  use any ascii formats etc to input into the tool.

If anyone of you have the answers , please do reply at the earliest.


thanx 
sunil s

 
 
***************** End Of Article ****************** 
 
csa posted Message 198 in Message Board 
 
Dated  : December 06, 1999 at 11:02:03 EST
Subject: SQA Robot
 
Hi all.

A question, ¿how I can create a process on the Process Scheduler for process's type SQA?

Thanks in advanced.

CSA.
 
***************** End Of Article ****************** 
 
Dan posted Message 199 in Message Board 
 
Dated  : December 10, 1999 at 15:48:03 EST
Subject: Version Control/Change Management for PeopleSoft Objects
 
Because Stat! is your PeopleSoft object repository, it is able to eliminate the need for database restores, speeds up full version Upgrades (retain security and tree changes. shortened compare report analysis.) and allows risk free updates and fixes (Bundles, Tax Upgrades). Stat!, simply put is the "Undo" for PeopleSoft. Stat! also allows you to define multiple migration paths, i,e. One for emergencies another for standard migrations and possibly one for updates and fixes. Documentation is linked to the object/s throughout its entire history of development (through a work ticket "CSR") so that you can roll-back to any previous version of that object helping to avoid re-work. Lock objects on your own defined migration path so developers cannot step on each others toes! Everything is time, date and user stamped. Automated communication through email will notify developers when an object/s will be available. See more on our website, www.mbrtechnologies.com
 
***************** End Of Article ****************** 
 
Marci McLaughlin posted Message 200 in Message Board 
 
Dated  : December 14, 1999 at 09:58:40 EST
Subject: Printing self service panels
 
Has anyone found a good 3rd party vendor to use to print self service panels.  Currently, you cannot print the java applet.

I heard a new version of E.I. (5.0 I think) possibly works... 
 
***************** End Of Article ****************** 
 
Marci McLaughlin posted Message 201 in Message Board 
 
Dated  : December 14, 1999 at 10:21:40 EST
Subject: Self Service sign-on box
 
Does anyone know how to modify the Self Service Signon box?
We want to get rid of all the tabs on the signon box accept "User Information" .  I believe this is a generated JAVA Applet. 

We are implementing self service and currently use ACF2 for password validation.  We turned the security option on PS_LOCK to bypass validating the password on PSOPRDEFN, so the only validation is in our AFC2 system.
The problem now is the signon applet that gets generated has a tab to change your password.  Since we don't use the PSOPRDEFN password for validation, this function will not change the user password.



 
***************** End Of Article ****************** 
 
dixon posted Message 202 in Message Board 
 
Dated  : December 14, 1999 at 11:39:11 EST
Subject: Re: SQR
 
: I have data in flat files - I need a method to transfer data from flat files to Excel sheet in a SQR program.
: Plz suggest me a method to do that!

: Thanks in advance.

:  
Use CSV or better yet, use SLK files.

 
***************** End Of Article ****************** 
 
Bill Kane posted Message 203 in Message Board 
 
Dated  : December 22, 1999 at 14:11:30 EST
Subject: Re: Report Distribution
 
: : Vista Plus by Quest Software might satisfy your requirements.  I saw a demo of their product at the March,99 PeopleSoft Golden Gate RUG and plan to have them come to our site for my users to review the product.  Look good and integrates with PeopleSoft.
: -Clarice Rinard 

: 
: : I work for Information Builders we are a PeopleSoft Alliance Partner. We have a product called Power Reporter for PeopleSoft that does exactly what you are asking for. I can have the product ,manager contact you directly if you send me an email address. What you are describing is what is called a managed reporting environment where you can have the same report distributed via email but customized so that only the appropriate people can see or change certain type of data. The reports can be distributed through either a push or pull technology.

: 
: : 
: :  : Does anyone have any experience using a report distribution tool and integrating it with PeopleSoft ?

: : : We would like to be able to schedule reports to run and then be viewed using this tool.  
: : : Also, we need to be able to provide different security levels within each of the reports.  For example, the CEO may be able to see the entire report, but a manager may only be able to see data that applies to a specific business unit/dept/region...

: : : Any recommendations and/or things to avoid would be appreciated.



 
***************** End Of Article ****************** 
 
Gary Hlapcic posted Message 204 in Message Board 
 
Dated  : January 05, 2000 at 15:42:17 EST
Subject: Re: Metaframe Configuration
 
: Does anybody have good documentation for installing PeopleSoft on Terminal Server with Metaframe?  My installation is about 95% complete, but I am having troubles with the ODBC drivers in multi-user mode. I have run the ODBC install script and still cannot access this control panel from any user other than administrator.  This means I cannot connect in two-tier mode AND I cannot run Crystal Reports. (I'm on tools version 7.56, but do not think this is important) Any advice would be greatly appreciated!

Cindy if you are still having problems email me at my email address with the specifics and I will help you out.

Thanks Gary.
 
***************** End Of Article ****************** 
 
Jim sweeny posted Message 205 in Message Board 
 
Dated  : January 07, 2000 at 10:32:55 EST
Subject: Re: Restrac Resume reader..
 
I can tell you that restrac/webhire customer support is non existant. they are not concerned with present customers. They are a marketing company not a technology company.  

 : Our company has been successfully using Restrac w/PS 6 but conversion to 7 has resulted in Restrac failure.  Restrac support in this matter has been , at best, less than desirable.

: : Can someone share with any of your success stories in implementing Restrac products? It would also be helpful if you could let me know the contacts in the sales dept in Restrac(their tel no,email id, address).
: : Thanks in advance.

: : Rajavel
: : Cambridge Technology Partners
: : India
: : Tel no: 91-80-5583025 Ext:8514
: : srajav@ctp.com



 
***************** End Of Article ****************** 
 
Lokesh posted Message 206 in Message Board 
 
Dated  : January 07, 2000 at 17:53:42 EST
Subject: Re: CSSHRizon - technical info. URGENT!!!!
 
: Where can I find CSSHRizon product information?

You can visit www.hrizon.com, it is just like peoplesoft v6.0, latest version of hrizon is 8.0.



 
***************** End Of Article ****************** 
 
Joe posted Message 207 in Message Board 
 
Dated  : January 13, 2000 at 09:00:03 EST
Subject: Re: Imaging Products
 
: Does anyone have any recommendations concerning imaging software vendors and their software packageswith PeopleSoft AP / PO module? 

We are using BlueBird for our imaging.  We scan all vouchers this way, and the product integrates seamlessly with PSoft. We are a 7.04 Public Sector/E&G shop.
 
***************** End Of Article ****************** 
 
Joe posted Message 208 in Message Board 
 
Dated  : January 13, 2000 at 09:14:46 EST
Subject: Replacing Crystal??
 
Has anyone heard one way or the other whether or not Crystal Reports is going to remain PSoft's reporting tool of choice?  In future releases of PSoft, do they plan to use a different reporting tool, or to stick with Crystal?

Thanx in advance
 
***************** End Of Article ****************** 
 
Thomas Gladden posted Message 209 in Message Board 
 
Dated  : January 13, 2000 at 12:32:41 EST
Subject: peoplesoft Kernel32.dll
 
Anyone else have problems with Windows Explorer? We are having a problem where Win95 PS clients frequently get the following error: 


EXPLORER caused an invalid page fault inmodule KERNEL32.DLL at 016f:bff79fa4.
Registers:EAX=00000000 CS=016f EIP=bff79fa4 EFLGS=00000246
EBX=00000001 SS=0177 ESP=0078fbcc EBP=0078fbdc
ECX=00000000 DS=0177 ESI=78040e70 FS=244f
EDX=bffc1470 ES=0177 EDI=00000009 GS=0000Bytes at CS:EIP:
ff 76 04 e8 3d a2 ff ff 5e c2 04 00 56 8b 74 24 Stack dump:
01000850 78009463 78040e70 00000000 00000000 7800ac51 00000009 0100084c 00000000 2300d085 01000850 23000000 2300d136 23000000 00000000 00000000 


We worked with our IS Department, and found that these errors only seem to be occurring on PCs in our HRIS, HR, and Benefits area, and the common denominator seems to be PS.
We are on HRMS 7.0 and PeopleTools 7.01Thanks! 
 
***************** End Of Article ****************** 
 
mvr100 posted Message 210 in Message Board 
 
Dated  : January 13, 2000 at 15:53:38 EST
Subject: Urgent!!!
 
How does one do subtotals at the end of page in Crystal? No other totalling is reqd in the page either by Dept, or Paygroup or by Company-Only the totals at the end of each page. The Grand Total at the end of the report is coming out fine, but am stuck with the subtotals. 

Would appreciate any help in this.

Thanks! 
 
***************** End Of Article ****************** 
 
Stuart Weinstein posted Message 211 in Message Board 
 
Dated  : January 14, 2000 at 16:31:03 EST
Subject: Re: Metaframe Configuration
 
: : Does anybody have good documentation for installing PeopleSoft on Terminal Server with Metaframe?  My installation is about 95% complete, but I am having troubles with the ODBC drivers in multi-user mode. I have run the ODBC install script and still cannot access this control panel from any user other than administrator.  This means I cannot connect in two-tier mode AND I cannot run Crystal Reports. (I'm on tools version 7.56, but do not think this is important) Any advice would be greatly appreciated!

: Cindy if you are still having problems email me at my email address with the specifics and I will help you out.

: Thanks Gary.


You need to change the ODBC entry from a USER DSN to a SYSTEM DSN

 
***************** End Of Article ****************** 
 
Lokesh posted Message 212 in Message Board 
 
Dated  : January 19, 2000 at 18:55:02 EST
Subject: Re: PeopleTools and SQR
 
pl. send me your email ID i will forward my C.V.
here also  i am sending C.V.


CURRICULUM VITAE
S.L.S.N.V.V.S.SUDHAKAR
FLAT# 103
SREE APARTMNTS
Srinivasa Colony(West)
Hyderabad
A.P.,
INDIA.
Phone : +91(40) 3319358,3540739 (Off)
               +91(40)3738007®

E-mail : lokeshsanku@hotmail.com

Professional Summary	:Seeking for a good opportunuty by having  three years  Of experience in Software development and , Functional Experience including hiring ativity for a MNC. Well versed client-server environment and ERP Systems.

Education	: Bachelors Degree in Engineering From Andhra University, 
                  Vishakapatnam (1996)
Skills Inventory:
               	GUI			:  Developer2000(Developed Systems)
              	Operating Systems  	:  M S-DOS , Windows ( 3.x, 95,NT 								      4.0) 
 		Languages 		: C , Visual Basic 5.0 
		OOPS          		:  C++, JAVA	
               	RDBMS                  	: Oracle 7.x,MS-Access
               	Hardware      		: Pentium
		ERP                     : People Soft  7.5 (HRMS  Module)
                WEB Technologies        : HTML,VBSCRIPT,ASP
		
Professional Experience:
Working as Programmer Analyst with CODELINKS DATA SERVICES PVT. LTD from Oct'99.
Worked as Programmer Analyst in CODELINKS DATA SERVICES PVT. LTD  As a 
Peoplesoft Consultant on behalf of CAREER PROFILES from June'99.
Worked as a HR Executive in CAREER PROFILES from Feb'99 to May'99.
Worked as Software Engineer in Pragma Technical Solutions  Ltd from Sep'96 to Feb'99.

Projects Summary : 

#1 Project:
   Project Name        :   SQR Reports Development
  Client               :   Conseco Inc , USA
  Role                 :   Leading the team,Analysis,
                           Testing and Documentation

Project Description :

	This project is basically to generate SQR reports as per 
 the requirement of the Client in the HR module.This project has
 started on 20th of June '99 and the target date of completion is
 December 31st '99.  
 The reports generated in this project are categorized into three 
 types as below, 

A. HR day to day data related reports, some of them are as follows,
        PERTERNA.SQR   - Terminations processed name wise
 	PERECLIS .SQR  - Emergency Contact List
 	PER401KH .SQR  - 401k New Hire Listing etc.	
        B1068.SQR      - Overtime report.
    
B. Database comparison reports, which compares the data present in
   two similar databases. These reports are generalised reports,
   which should work for any table. some of them are as follows,

        GENCOMP1&2.SQR  - Data present in first database and not present
                          in another database.
        GENCOMP3,4,5.SQR - These are to compare Key,Xlat,Non xlat fields 
                           data present in both the databases.
C. Interface reports. The purpose of these reports is to generate flat 
   files by fetching data from HRsystem database, and the flat files
   generated are used to import data into third party tools.Another type
   of reports are to insert data into Hr database by reading from flat 
   files generated by the third party tools.Some of them are as below,

        CIGNA.SQR   -  Outgoing from HRsystem & in coming to CIGNA system
        TPA.SQR     -  Outgoing from HRsystem & in coming to TPA system
        BVUPDATE.SQR-  Outgoing from BVsystem & in coming to HRsystem

#2 Project: Hiring Activity

Client  : CODELINKS DATA SERVICES PVT LTD
Team Size : 3
Duration  : Feb'99  to May'99

Description:  We Recruited Employees belonging to various areas for a multi
national company.
It contains three phases
1)Resume Collection and Screening: We Collected Resumes from the principal
  company and screened those on the basis of Skill set and experience.

2) Conducting Interveiws: We arrranged the interviews for all qualified 
   candidates in each area depends on requirment of the principal company.

3) Taking reference checks and feed back from company: After conducting 
   the interview in our company we send to principal company after all
   completing all necessary checks and we will take the feed back from
   the pricipal company about each and every candidate.


#3) Project 

Project title 		:       Marketing Plan Automation
Client 			:  	KayJay Industries Ltd , Hyderabad
Duration 		:   	From Jan'98 to Apr'98
Team size               :   	Eight
Software environment    :   	Visual Basic 5.0, MS-SQL Server 6.5 ,Windows 				NT 4.0

Role                    :   	complete project Front -end design,coding , 
				interactionWith team members and 
				contributing ideas .

This is to automate the Marketing functions of a Pharmaceutical company
 operating its business in South India. This Projects mainly categorized 
into several modules namely maintenance of code tables, Customer data, 
Stockiest ,Super-stockiest ,Customer Order, Activity of business development
 Manager and Business development Executive,Product information, Market 
intelligence Sales, Advertising and Promotion, Market plan,Writing Context 
sensitive and Content Help, Generating Various types of reports based on 
information provided by various levels of its employees and all types of 
customers.

The Project captures and updates customer, product, fields sales person's 
data, customer order, sales-region & state wise, Advertising and promotion
using SQL -Server as backend and Visual Basic 5.0 as front -end 
Features employed: Remote Data Objects (RDO), DDE, OLE, developed Active X
 control, Farpoint Spread sheet control , SS Tab, Crystal Reports, Help 
Compiler Workshop.

#4) Project:
Project title 		: Automation of Departmental  Stores
Client 			: Lakshmi supermarket, Hyderabad     
Duration 		: From Jun'97 to Nov'97
Team size		: Three 
Software environment	: Visual Basic 5.0, MS-Access2.0, and Windows NT 4.0
Role 			: As Programmer Complete project Front -end design,
			  coding,Interaction with team members and 
                          contributing ideas.
This is a Generalized package of Complete  Sales and Inventory can keep 
track of  various day to day sales activity like checking inventory ,billing
 and generating various reports meeting order requirements ,order placements,
 checking financial status of the company at any time or for a given time 
range etc., The  Project Mainly  Consists of the following five modules 
namely  Customer Information, Billing, Check Order, Inventory, Generation of
 Various Reports- Customer Information,,item code, item description the
 above information is added to the database ,the Billing deals with  price 
billing that is given to the customer who purchase the commodities from the
  stores.  The information is automatically gets in transaction with the
 database to query on to get the inventory status. The Inventory module 
keeps account of input and output of the stores commodities. The report 
module consists of daily, weekly, monthly, yearly information of sales and 
stock particulars.

#5) Project: 
Project title 		: Automation of Electrical Power Reading
Client 			: ECE Industries ,Hyderabad     
Duration 		: From  Jan'97 to May'97
Team size		: Three
Software environment	: Tubo C,Windows 95
Role 			: As Programmer  in design,  coding , andinteraction
                          with team members and contributing ideas.
This is a Generalized package consisting of coplete automation to read 
Electrical Meter Reading From any Electric meter. There are Two steps 
invoved in this process.  First Read meter reading from meter to H.H.U. ,
then From H.H.U. to Base Computer.  While Accessing data from meter to H.H.U.
 or H.H.U. to Computer some protocals are there. So in this project we design
 to access the data from H.H.U. to Computer Depends on Existing Protocals.


CASE STUDIES IN ERP:
CASE  STUDY - 1
Feasibility Study of Implementing ERP  In Banking Industry
A Leading Co-Operative Bank having branches all over state of Andhra Pradesh is in the process of large-scale computerization of its operations.  This bank has got about 9 branches which are reporting to its head office at Hyderabad.  Presently all the operations of the bank are being carried out manually.  The team consists of 5 members, who are highly experienced in the software field, has undertaken a detailed case study based on the client's requirement with regard to information, Data security and integrity.  The conclusion that emerges out of the above case study that ERP especially People Soft is highly suitable and feasible for this particular Business concern, though extensive customization and design is required.  A sample application comprising of panels like Bank master, Transaction master, Recurring Deposit master, F.D. master and reports like transaction entry, customer wise and Fixed deposit and R.D. reports. Extensive validations are carried out using people code.

CASE STUDY - 2
Student Administration
A Case study was conducted for one of the most popular Junior College in the twin cities with a team comprising of 5 members.
This Junior College has got student strength of about 5,000 students.  Presently they are maintaining their records in FoxPro. It is found that the reports & maintenance of student Data is highly unorganized, unstructured and inadequate with this system.  Based on the extensive case study and with many rounds of discussions with the management of the college, it has been found that an ERP like People Soft though a little bit expensive can go a long way in the proper management, reporting and maintenance of student Data.  The management is convinced with the Case Study and is on the lookout for a suitable software package.  A sample student administration was built comprising of panels like student master, student details, course details, enrollment details, etc.  Extensive validations were performed using people code for this application.  The Client is satisfied with the sample application in all respects.

CASE STUDY - 3
Student Data
The Project mainly aims at maintaining records for course sessions available, course details, available instructors lists, no. of students enrolled, students joined and their evaluation details. This also maintains customer details. It consists of 8 Record Definitions and 6 Panels incorporating Sub-panels and Secondary panels at the required stages. Writing People code for generation of student Ids, Course codes and Instructor Ids.  Assigning particular Instructors for student Ids etc., changing any particular data through Mass Change and generating final passed out student records.

CASE STUDY - 4
Demographic Analysis For India
The study is developed using People Soft 6.0 to produce complete information about State wise population, area of land, area of cultivated land, area of forests and the basic needs like drinking water availability, sanitation, hospitals etc. The case study utilizes Data Designer, scroll level settings to retrieve master details and effective dated functions, Panel Designer, Menu Designer, Operator Security and People Code. Finally Business process map is developed using activity map, step map and message agent.
   

Personal Details		:		
Date of Birth			: 21st Oct 1975
Marital Status		        : Unmarried
Passport Details		:
Passport No.                    : A543943 
Place of issue			: Vishakapatnam
Date of issue			: 1 June 1998
Date of Expiry		        : 31 May 2008

: I have a permanent opening in Tampa, FL for a PeopleSoft Developer with experience in PeopleTools and SQR. If you can refer someone we will pay you $1200.00 if they are hired.
: Thank You


 
***************** End Of Article ****************** 
 
Lokesh posted Message 213 in Message Board 
 
Dated  : January 21, 2000 at 17:13:23 EST
Subject: Re: SQR: can &quot;on-break&quot; be used with dynamic search criteria?
 
Hi
you can do that by tranfering your sort value into a variable 
you can resolve dynamically by enclosing that in [] brackets,
other wise explain your problem by sending a mail to me then i will give correct solution
: Hi-
: I want to use on-break with a dynamic order by clause.  The user can choose one of three sort criteria and I need to print a sbutotal (using after) depending on which they choose.  Is this possible in SQR 4?

: Betsy


 
***************** End Of Article ****************** 
 
Nancy posted Message 214 in Message Board 
 
Dated  : January 24, 2000 at 19:46:40 EST
Subject: PeopleSoft printing remote through Citrix
 
Does anyone have information or know how to set up printing for remote use using PeopleSoft & Citrix? email me nancy.turner@tais.toshiba.com
 
***************** End Of Article ****************** 
 
PSORA posted Message 215 in Message Board 
 
Dated  : January 24, 2000 at 20:17:29 EST
Subject: Free PeopleSoft/Oracle Scripts, Code, Tips, News 
 

Check it out!  

http://www.skybusiness.com/psora
 
***************** End Of Article ****************** 
 
Rich M posted Message 216 in Message Board 
 
Dated  : January 25, 2000 at 18:26:00 EST
Subject: Problems with Crystal 7.0 and PS Crystal
 
Has anyone had a problem running Crystal 7.0 (not embedded within PS) and PS Crystal (5.0 PS 7.02)?  We purchased the 7.0 version to enable us to run reports from other systems but ran into problems when it was loaded on clients with PS 7.02.  There were changes to the basic crystal odbc connectivity that caused PS&#8217;s Crystal to stop working.  Has anyone been able to use both on one client system?  Has anyone had any problems with Crystal 6.0 and the PS version. 

Thanks
 
***************** End Of Article ****************** 
 
Mark Livingstone posted Message 217 in Message Board 
 
Dated  : January 26, 2000 at 16:48:22 EST
Subject: Re: Printing self service panels
 
Marci,

I.E. 5.0 doesn't seem to work either.  Currently we use a product  
called Snag-It to capture our web panels.

Hope this helps.

Mark Livingstone
DTI
Mark_Livingstone@dtius.com
(510) 580-3562

: Has anyone found a good 3rd party vendor to use to print self service panels.  Currently, you cannot print the java applet.

: I heard a new version of E.I. (5.0 I think) possibly works... 


 
***************** End Of Article ****************** 
 
Sam posted Message 218 in Message Board 
 
Dated  : February 01, 2000 at 16:35:09 EST
Subject: Re: Printing Bind Variables in Crystal Report Heading
 
: I have a Crystal/Query report that is run from the Process Scheduler. The user is prompted for ‘From Date’  & ‘Thru Date’ which are written to the RC_PAY run control record. The report runs fine and all is well.
: The question is how do I include the BIND Variables RC_PAY.FROMDATE & RC_PAY.THRUDATE in the heading of the Crystal report? The only database fields I can get at are the fields actually used in the query.
: Any help would be greatly appreciated!

XXX----Try This -----XXX
In the original query that you are using for the main report,  create a new expression, declare the type of the expression to be 'date' and select the prompt by clicking the 'Add Prompt' button. Select the desired prompt so that the text field of the expression box displays ":1" (for prompt #1, which may be the date prompt which you desire to carry to crystal). After the expression is created drag it and drop it in the fields of the query so that it also appears as one of the field. Now use this field value in crystal whereever you want.

Good luck 


: Thanks,
: Mike Murray
: murray@rell.com


 
***************** End Of Article ****************** 
 
Sam posted Message 219 in Message Board 
 
Dated  : February 01, 2000 at 16:48:37 EST
Subject: Double prompts with crystal
 
Has anyone so far encountered double prompt issue in crystal??
I have a report with a couple of prompts with OR condition. When this is run from PS (Process Scheduler),leaving one of the prompts blank on the panel, it prompts me again at runtime. 
If anyone had any similar encounters please let me know.
Thanks for the help.
Sam
 
***************** End Of Article ****************** 
 
Mary Borra posted Message 220 in Message Board 
 
Dated  : February 02, 2000 at 09:12:20 EST
Subject: Web/IVR Open Enrollment and Benefits statements
 
We are looking for PS partners or other vendors to provide a web or IVR product to automate our Benefits Open Enrollment and Benefits Statement.  We are currently using 7.02, will be upgrading to 7.6 this July and may go to Ben admin next year.  Any feedback or guidence PS customers can provide will be helpful.

Thank you!

 
***************** End Of Article ****************** 
 
Gary posted Message 221 in Message Board 
 
Dated  : February 03, 2000 at 16:30:53 EST
Subject: Citrix and PeopleSoft
 
Anyone have experience installing PeopleSoft on Citrix MetaFrame 1.8?

Please e-mail me @ garagon@ThinKnowledge.net

Thanks.
 
***************** End Of Article ****************** 
 
tj posted Message 222 in Message Board 
 
Dated  : February 07, 2000 at 11:15:18 EST
Subject: Re: Citrix and PeopleSoft
 
You can find very good documentation on installing PeopleSoft on Citrix on PS Customer Connection.   One of PS technical staff is Paul Romero, he does alot of the Citrix support for PS.

TJ


: Anyone have experience installing PeopleSoft on Citrix MetaFrame 1.8?

: Please e-mail me @ garagon@ThinKnowledge.net

: Thanks.


 
***************** End Of Article ****************** 
 
Melinda posted Message 223 in Message Board 
 
Dated  : February 17, 2000 at 15:03:35 EST
Subject: Crystal Reports 7.0 and Windows 2000
 
Does anyone know about any problems with these two products working together?
 
***************** End Of Article ****************** 
 
Ed Morris posted Message 224 in Message Board 
 
Dated  : February 18, 2000 at 08:56:00 EST
Subject: Re: Crystal Reports 7.0 and Windows 2000
 
Not that I am aware of, I looked at Seagate's site and looked to see if there was anything about Win 2K conflicts with Crystal 7 but didn't find anything.



: Does anyone know about any problems with these two products working together?


 
***************** End Of Article ****************** 
 
Dennis Sze posted Message 225 in Message Board 
 
Dated  : February 23, 2000 at 19:26:51 EST
Subject: SQA Robot
 
Hi,
I am currently using PeopleSoft HRMS 7.5 Global. To carry out data conversion, I am thinking of using SQA Robot in loading my data captured in Excel Format. I have the following questions which I hope I can get some answers:
1) I am finding difficulties locating the User Guide for SQA Robot 6.1 despite installing the SQA Robot that comes with PeopleSoft. Does anybody know how I can get hold of the User Guide ?  
2) Any kind of feedback with regards to using SQA Robot for uploading data.
Thanks for any of your kind response!
cheers,
dennis
 
***************** End Of Article ****************** 
 
Melinda posted Message 226 in Message Board 
 
Dated  : February 24, 2000 at 10:22:52 EST
Subject: Re: Crystal Reports 7.0 and Windows 2000
 
I'd seen reports on Crystal's site of people having problems installing the CR7 application, but nothing as far as distributing reports or Print Engine DLL files.

Thanks.  I guess the best bet will be to simply try it as soon as we get our hands on a copy of Win2K.
 
***************** End Of Article ****************** 
 
Phil posted Message 227 in Message Board 
 
Dated  : February 25, 2000 at 12:02:47 EST
Subject: ObjectFax
 
Has anybody had any experience using PeopleSoft with ObjectFax?  How does the integration work?  How easy was it to implement?  

Thanks in advance.
-Phil
 
***************** End Of Article ****************** 
 
Steve Hudgin posted Message 228 in Message Board 
 
Dated  : February 28, 2000 at 16:29:42 EST
Subject: Visio &amp; Org Charts
 
It seems that the delivered Org Chart process that PS has interfaced with Visio relies on Position data to establish a reporting heirarchy.  We do not use Position Management, so I'm creating my own department-level file to import into Visio's Org Chart Wizard.  All seems well until the last step when I get an error stating "Invalid Data.  Make each value in the 'reports to' field refer to a valid entry in another field."

The only row in the file that doesn't have a valid entry in the 'reports to' field is the department supervisor, who reports to a manager in another department.

Any suggestions on how to deal with this issue?
 
***************** End Of Article ****************** 
 
Philippa Bailey posted Message 229 in Message Board 
 
Dated  : February 29, 2000 at 06:43:33 EST
Subject: Software that Scans data into PeopleSoft
 
Does anyone know of any 3rd party software package that scans data into PeopleSoft.  The main requirement is to scan in cvs.  I am sure that there is some software called RaceTrack or something similar but have had problems finding any information about it.
 
***************** End Of Article ****************** 
 
Mark Livingstone posted Message 230 in Message Board 
 
Dated  : February 29, 2000 at 11:10:59 EST
Subject: Re: Software that Scans data into PeopleSoft
 
Philippa,

I just finished a project where we were implementing Time & Labor and had a similar requirement to be able to scan timesheets and get them into PeopleSoft.  We used a product called Teleforms for our solution.  The product is made by Cadiff Software.  It works fairly well.  Please let me know if you have any specific questions regarding the software.

Mark Livingstone
DTI
Mark_Livingstone@dtius.com
(510) 580-3562

: Does anyone know of any 3rd party software package that scans data into PeopleSoft.  The main requirement is to scan in cvs.  I am sure that there is some software called RaceTrack or something similar but have had problems finding any information about it.


 
***************** End Of Article ****************** 
 
csa posted Message 231 in Message Board 
 
Dated  : February 29, 2000 at 12:18:08 EST
Subject: Re: SQA Robot
 
: Hi all.

: A question, ¿how I can create a process on the Process Scheduler for process's type SQA?

: Thanks in advanced.

: CSA.


 
***************** End Of Article ****************** 
 
Dennis Sze posted Message 232 in Message Board 
 
Dated  : February 29, 2000 at 12:21:23 EST
Subject: Re: SQA Robot
 
Hi,

For to get the User guide, you should contact Rational Software,
and for the uploading from Excel, I wil send a email.

Bye

Philippe
 
***************** End Of Article ****************** 
 
philippe posted Message 233 in Message Board 
 
Dated  : February 29, 2000 at 12:26:28 EST
Subject: Re: SQA Robot
 
Hi, 

you should to call the API window, because the most problem
is calling the windows title between process monitor and the windows calling.

Y will send a email with this procedure

Bye

 
***************** End Of Article ****************** 
 
Philippe posted Message 234 in Message Board 
 
Dated  : February 29, 2000 at 12:48:32 EST
Subject: Call the process scheduler with SQA Robot 6.1
 
Hi all,

For the robot tester users, you can using this procedure for manage the process scheduler status.

This SQA procedure do : 

 - call the process scheduler from the window caller
 - refresh the scheduler until the process status is success
 - Recall the window caller 

THE SQA PROCEDURE :

'$include "PS75.sbh"

Sub Main
    
    Dim Result As Integer
    Dim Status As Variant
    Dim JobStatus As Variant
    
    'Initially Recorded: 01/05/00  14:51:41
    'Run Process Monitor until SUCCESS STATUS
    
    Window SetContext, "Class=Afx:", ""
    PreviousWindowTitle = GetCurrentWindowTitle ()
    PreviousWindow = "Caption=" &PreviousWindowTitle
    
    'MsgBox PreviousWindow
    
    MenuSelect "Go->PeopleTools->Process Monitor"
    
    Window SetContext, "Caption=Process Monitor - (Untitled)", ""
    Do Until JobStatus="Success" 
        MenuSelect "Action->Refresh List"
        Result = SQAGetPropertyAsString("Type=PSGrid;ObjectIndex=1", "SelectedText(7)", Status)
        JobStatus = Status
    loop   
    
    Window SetContext, "Caption=Process Monitor - (Untitled)", ""
    MenuSelect "File->Exit"
   
    Window SetContext, PreviousWindow, ""
    Window OpenIcon, PreviousWindow, ""
    
End Sub

THE 2 INCLUDE FILES MUST BE INSTALL IN COMMON DIRECTORY

THE PS75.SBL :

Declare Function GetPrivateProfileString Lib "kernel32" Alias "GetPrivateProfileStringA" (ByVal lpApplicationName As String, ByVal lpKeyName As String, ByVal lpDefault As String, ByVal lpReturnedString As String, ByVal nSize As Long, ByVal lpFileName As String) As Long
Declare Function GetWindowText Lib "user32" Alias "GetWindowTextA" (ByVal hwnd As Long, ByVal lpString As String, ByVal cch As Long) As Long
Declare Function GetForegroundWindow Lib "user32" () As Long
Declare Function GetWindow Lib "user32" (ByVal hwnd As Long, ByVal wCmd As Long) As Long
Declare Function SetForegroundWindow Lib "user32" (ByVal hwnd As Long) As Long

Function GetCurrentWindowTitle () as String

Dim WindowHandle as Long
Dim WindowTitle as String
Dim X as Long

    WindowHandle = GetForegroundWindow()
    WindowTitle = Space$(256)
    X = GetWindowText(WindowHandle, WindowTitle, 255)
    WindowTitle = Trim$(WindowTitle)
    GetCurrentWindowTitle = WindowTitle

End Function

Function GetCurrentWindow () as String

Dim PreviousWindowTitle as String

    Window SetContext, "Class=Afx:", ""
    PreviousWindowTitle = GetCurrentWindowTitle ()
    PreviousWindow = "Caption=" & PreviousWindowTitle
     
End Function

THE PS75.SBH :

Declare Function GetCurrentWindowTitle BasicLib "PS75" () As String
Declare Function GetCurrentWindow BasicLib "PS75" (TimeOut as Long) as Integer
Declare Function GetWindow Lib "user32" (ByVal hwnd As Long, ByVal wCmd As Long) As Long
Declare Function SetForegroundWindow Lib "user32" (ByVal hwnd As Long) As Long
Global PreviousWindowTitle As String
Global PreviousWindow As String

IF YOU CAN'T USING IT, SO EMAIL ME

BYE
 
***************** End Of Article ****************** 
 
Philippa Bailey posted Message 235 in Message Board 
 
Dated  : March 01, 2000 at 10:24:24 EST
Subject: Re: Software that Scans data into PeopleSoft
 
Mark

I would be very interested in more details on the software such as price, any contact numbers you may have with regards to the company etc.  Is there a web site you know of?

Thanks, it looks as though it may meet our requirements if it isn't too costly.
Philippa

: Philippa,

: I just finished a project where we were implementing Time & Labor and had a similar requirement to be able to scan timesheets and get them into PeopleSoft.  We used a product called Teleforms for our solution.  The product is made by Cadiff Software.  It works fairly well.  Please let me know if you have any specific questions regarding the software.

: Mark Livingstone
: DTI
: Mark_Livingstone@dtius.com
: (510) 580-3562

: : Does anyone know of any 3rd party software package that scans data into PeopleSoft.  The main requirement is to scan in cvs.  I am sure that there is some software called RaceTrack or something similar but have had problems finding any information about it.


 
***************** End Of Article ****************** 
 
Dave Gordon posted Message 236 in Message Board 
 
Dated  : March 01, 2000 at 20:42:16 EST
Subject: Resume Scanning Packages
 
:I am sure that there is some software called RaceTrack or something similar but have had problems finding any information about it.

Hi Phillippa,

Maybe you're thinking of RezLogic.  See:  http://www.rezlogic.com/

Also check:  http://www.greentreesystems.com/Index.htm

And:  http://www.resumix.com/

Regards,

Dave
 
***************** End Of Article ****************** 
 
Amy Christenson posted Message 237 in Message Board 
 
Dated  : March 02, 2000 at 11:46:11 EST
Subject: Exporting Outlook data to PeopleSoft
 
We want to be able to create a form in Outlook and export the data to PS T&L.  Anyone know if this is possible and how we would go about it? I know Notes can do this using message agent.
 
***************** End Of Article ****************** 
 
Amy Christenson posted Message 238 in Message Board 
 
Dated  : March 02, 2000 at 16:37:24 EST
Subject: MS Projects to PS Projects
 
Can the two be interfaced using Message Agent?

Anyone every done this before?

Thanks!
 
***************** End Of Article ****************** 
 
Swapan Mahato posted Message 239 in Message Board 
 
Dated  : March 06, 2000 at 19:04:34 EST
Subject: Selection between Citrix/Terminal Server/Web Client
 
What is a perfect choice for remote access for a large company with sites all over the place?

1. Citrix
2. NT Terminal Server
3. Web Client

Which one is best and why?

Thanks.
 
***************** End Of Article ****************** 
 
Amy Christensonf posted Message 240 in Message Board 
 
Dated  : March 08, 2000 at 15:02:09 EST
Subject: Re: Selection between Citrix/Terminal Server/Web Client
 
We currently use the Web Client for remote access for T&L however have had poor performance. We go live on Citrix tomorrow. Citrix will act as a "go between" of sorts between the remote user and the web client. I can tell you that it is at least 10X the speed it was before implementing Citrix.  Hope this helps.

: What is a perfect choice for remote access for a large company with sites all over the place?

: 1. Citrix
: 2. NT Terminal Server
: 3. Web Client

: Which one is best and why?

: Thanks.


 
***************** End Of Article ****************** 
 
Amy Christenson posted Message 241 in Message Board 
 
Dated  : March 08, 2000 at 15:06:13 EST
Subject: Crystal on the Web
 
Looking for some advice on enabling reports on self-service web panels.

Thanks!
 
***************** End Of Article ****************** 
 
Scott B posted Message 242 in Message Board 
 
Dated  : March 09, 2000 at 18:19:35 EST
Subject: Re: urgent
 
Better late than never!!!

Escape sequences can be found on this page http://www.hp.com/cgi-bin/cposupport/cspt/ljxxxx/dyndocwrap.pl?lid=general&fid=bpl02705&pid=

You need to find the .sqc where the escape sequences are located.  I can't recall the name but if you follow the path of .sqc's you'll eventually get there - it is pretty well documented so you will know it when you see it.  Add or replace  the sequence here save and run.  I remember having problems getting the last page to eject so I think I added a forced eject to the last line in the print routine.


: HOW DO U SEND A COMMAND TO THE PRINTER FROM A SQR TO PRINT LEGAL I.E. (8.5,14) WITHOUT USING DECLARE-LAYOUT ?
: DOES ANYONE KNOW THE ESCAPE STRINGS FOR HPLASERJET?
: I TRIED USING

: 
: #ifdef PAPER_SIZE LETTER
: #define PAPER_SIZE LEGAL
: #else
: #define PAPER_SIZE LEGAL
: #endif

: IN MY BEGIN-SETUP BUT LOOKS LIKE NOT WORKING, WHY?

: THANKS IN ADVANCE


 
***************** End Of Article ****************** 
 
Gary Hlapcic posted Message 243 in Message Board 
 
Dated  : March 10, 2000 at 15:06:33 EST
Subject: Re: Citrix and PeopleSoft
 
Hi Gary,

There is also a very good book on installing citrix on metaframe 1.8 for peoplesoft at amazon.com, I forget the name, but you can find it searching on citrix.

thanks Gary.
: Anyone have experience installing PeopleSoft on Citrix MetaFrame 1.8?

: Please e-mail me @ garagon@ThinKnowledge.net

: Thanks.


 
***************** End Of Article ****************** 
 
gita posted Message 244 in Message Board 
 
Dated  : March 12, 2000 at 15:32:16 EST
Subject: Re: Printing of Images in SQR
 
Here's a suggestion if the client is running on Windows, try printing the report using SQR flag -PRINTER:WP. The report directly goes to the Windows default printer. Hope it works.

: Printer = HPLaserJet
: SQR = 4.3.2

: I have this issue when printing an image in SQR report.
: Instead of printing the image, a shaded box appears!

: The following are my settings in sqr.
: begin-heading 1
: print-image (1,20)
: type=bmp-file
: image-size=(20,5)
: source='c:\temp\logo.bmp'
: end-heading

: I have also tried the following settings but it does not
: work either.
: - type=hpgl-file 
: - source='c:\temp\logo.hpgl'

: Any help will be welcome. 



 
***************** End Of Article ****************** 
 
s.Geethanjali posted Message 245 in Message Board 
 
Dated  : March 18, 2000 at 02:21:52 EST
Subject: please send details about  SQA Robot
 
  I need information regarding using SQA Robot to test delphi project.  Anyone with experience utilizing this product?
 send the details.

 with regards
 geethanjali


 
***************** End Of Article ****************** 
 
Gautam posted Message 246 in Message Board 
 
Dated  : March 21, 2000 at 11:57:21 EST
Subject: Problem in SQR Printing
 
Hi,
I have been trying to print my SQR reports. But the reports dont go to the printer. My printer is not a network one. So i cant use lpt1 or lpt2 ports. Its an IP printer. Do i need to do some special settings or something? Please give me some suggestions.
Thanks,
Gautam
 
***************** End Of Article ****************** 
 
Randy Miller posted Message 247 in Message Board 
 
Dated  : March 23, 2000 at 16:10:44 EST
Subject: Re: Double prompts with crystal
 
Our shop had the same problem.  We also had a problem with some
users being able to run a report from one workstation and not another.  We finally traced it down to some mismatched dll files
I think and re-installed crystal on the problem workstations.  It
solved the problem.

Randy



: Has anyone so far encountered double prompt issue in crystal??
: I have a report with a couple of prompts with OR condition. When this is run from PS (Process Scheduler),leaving one of the prompts blank on the panel, it prompts me again at runtime. 
: If anyone had any similar encounters please let me know.
: Thanks for the help.
: Sam


 
***************** End Of Article ****************** 
 
RJ. Manuel posted Message 248 in Message Board 
 
Dated  : March 23, 2000 at 17:06:46 EST
Subject: Re: SQA Robot
 
I have noticed that this web page contained information going from 3 years ago.  Is this an active site.  I am very interested to learn the latest on SQA Robot and would like to use it on my next assignment.  Will you please help me if I can get a demo and self study guide on-line?

Thanks,

RJM
 
***************** End Of Article ****************** 
 
Dave posted Message 249 in Message Board 
 
Dated  : March 27, 2000 at 13:53:47 EST
Subject: Downloading Zipsales Jr. Tax Data to PeopleSoft
 
We currently use Zipsales Database Jr. to download tax data to one of our systems, and would like to use the same ASCII file to download to PeopleSoft. Anybody else implement this? Any advice is greatly appreciated.

MS SqlServer
Tools 756
App 753 


 
***************** End Of Article ****************** 
 
Kelly Fairbanks posted Message 250 in Message Board 
 
Dated  : April 06, 2000 at 13:24:49 EST
Subject: Oracle Hints (Query)
 
An architecture change has caused a significant drop in our SQL/RPT response time.  PeopleSoft has suggested that some queries might benefit from the addition of an Oracle hint (rule-based).

Does anyone know what criteria we should use for applying these hints?  What makes one query a better candidate than another?  Is there documentation providing this information on the web?

Thanks,

Kelly
 
***************** End Of Article ****************** 
 
K.  Romy posted Message 251 in Message Board 
 
Dated  : April 07, 2000 at 11:14:59 EST
Subject: Re: Tools for Data Migration from Legacy systems 
 
: hi all, 
: I was told to look in for some of the best tools available which can migrate data from legacy systems to besopke database F&E (facilities & equipment)and , if so what is format through which it is migrated or  does it use any ascii formats etc to input into the tool.

: If anyone of you have the answers , please do reply at the earliest.

: 
Regards
romy
 
***************** End Of Article ****************** 
 
Margot Brown posted Message 252 in Message Board 
 
Dated  : April 11, 2000 at 09:33:00 EST
Subject: RE: Resumix and Webhire (Resume Scanning Software)
 
Can anyone share your stories regarding the implementation and successful use of Resumix or Webhire?  Webhire is the new name for Restrac.  I would also be interested to learn of any other comparable resume scanning software.
Thanks in advance.
Margot Brown
Bloomberg
212-318-2795

 
***************** End Of Article ****************** 
 
John Ivey posted Message 253 in Message Board 
 
Dated  : April 13, 2000 at 10:47:08 EST
Subject: Re: Restrac 
 
You might want to also check out RezPrise by MagnaWare.  They have customers putting 10,000+ resumes in a week.   Also have a slick interface with Peoplesoft

John

: 
: Hi Brian.

: We were interested in implementing the restract software to interface with our HRMS module, since we are in the recruitment business, our requirements are the same as mentioned in your mails, can you please forward the telephone number of Jon Wilcox, HRIS Manager from Bell Helicopters Textron, so that I can just take some information ergarding the sucess of the package and the drawbacks.

: Thanks in advance Brian.

: Regards
: Gladdy
: : : Looking for opinions (good and bad) from companies who have installed Restrac and the interface to PeopleSoft.  Any comments or details (performance issues, gotchas, etc.) would be appreciated.  Thanks.

: : You may want to try getting a hold of Jon Wilcox, HRIS Manager, at Bell Helicopter Textron.  They have Restrac succesfully implemented and they receive close to 30,000 resumes per year.  Good luck.


 
***************** End Of Article ****************** 
 
John  posted Message 254 in Message Board 
 
Dated  : April 13, 2000 at 10:50:03 EST
Subject: Re: Software that Scans data into PeopleSoft
 
You might want to also check out RezPrise by MagnaWare.  They have customers putting 10,000+ CVs in a week.   Also have a slick interface with Peoplesoft.  www.magnaware.com

John


: Mark

: I would be very interested in more details on the software such as price, any contact numbers you may have with regards to the company etc.  Is there a web site you know of?

: Thanks, it looks as though it may meet our requirements if it isn't too costly.
: Philippa

: : Philippa,

: : I just finished a project where we were implementing Time & Labor and had a similar requirement to be able to scan timesheets and get them into PeopleSoft.  We used a product called Teleforms for our solution.  The product is made by Cadiff Software.  It works fairly well.  Please let me know if you have any specific questions regarding the software.

: : Mark Livingstone
: : DTI
: : Mark_Livingstone@dtius.com
: : (510) 580-3562

: : : Does anyone know of any 3rd party software package that scans data into PeopleSoft.  The main requirement is to scan in cvs.  I am sure that there is some software called RaceTrack or something similar but have had problems finding any information about it.


 
***************** End Of Article ****************** 
 
Mikael Paul posted Message 255 in Message Board 
 
Dated  : April 14, 2000 at 11:01:02 EST
Subject: Crystal report and citrix
 
someone use crystal report with citrix ?

On my server :
The subreport crystal report don't work with the citrix server

Someone have the same problem or the solution ?

Thanks
 Mikael
 
***************** End Of Article ****************** 
 
Tienni Su posted Message 256 in Message Board 
 
Dated  : April 14, 2000 at 12:18:20 EST
Subject: re: error
 
When we tried to install the SQA Robot I got the following application error message: 'REGSVR caused Segment Load Failure in module OC25.DLL
 
***************** End Of Article ****************** 
 
roussel posted Message 257 in Message Board 
 
Dated  : April 17, 2000 at 10:14:11 EST
Subject: metaframe and wtse
 
When I launch mfadmin or appcfg, the message is "acces violation (0xC0000005) Adress 0X777deb35. The config is WTSE SP5 and METAFRAME 1.8 SP1 in french.
Thanks to help me !


 
***************** End Of Article ****************** 
 
Karen Schneider posted Message 258 in Message Board 
 
Dated  : April 18, 2000 at 11:05:58 EST
Subject: integration of Peoplesoft GL &amp; Indus Passport 
 
Any information re:modules from each (esp purchasing & AP) and information about the best way to edit input would be appreciated.  Thanks, Karen 
 
***************** End Of Article ****************** 
 
Dennis Neuner posted Message 259 in Message Board 
 
Dated  : April 25, 2000 at 16:18:58 EST
Subject: Re: Problem in SQR Printing
 
: Hi,
: I have been trying to print my SQR reports. But the reports dont go to the printer. My printer is not a network one. So i cant use lpt1 or lpt2 ports. Its an IP printer. Do i need to do some special settings or something? Please give me some suggestions.
: Thanks,
: Gautam
Gautam:  Try using SnagIT our screen capture product. It is easy to use and allows you to send reports to a printer or email.

 
***************** End Of Article ****************** 
 
Kenbedi posted Message 260 in Message Board 
 
Dated  : May 01, 2000 at 14:41:33 EST
Subject: Crystal
 
Hi folks
Can any one help me with the crystal printing?
My question is, I am able to select output destination to file 
on server side but when I am trying to output directly to printer ,its erroring out.

Kindly help me

thanks in advance


Ken 
 
***************** End Of Article ****************** 
 
Len Bourdette posted Message 261 in Message Board 
 
Dated  : May 02, 2000 at 07:05:50 EST
Subject: Peoplesoft Cube Manager
 
I am looking for a consultant for a Peoplesoft HR, Payroll Datawarehousing project on the east coast that has good knowledge of Cube Manager Architecture. Can anyone help?

Len Bourdette
Sr. Project Manager
Nemeth/MArtin Consulting
 
***************** End Of Article ****************** 
 
Steve Dudenhoeffer posted Message 262 in Message Board 
 
Dated  : May 02, 2000 at 14:55:07 EST
Subject: Re: Problems with Crystal 7.0 and PS Crystal
 
We are having the same problems.  Any info on a resolution would be appreciated.
Thanks!


: Has anyone had a problem running Crystal 7.0 (not embedded within PS) and PS Crystal (5.0 PS 7.02)?  We purchased the 7.0 version to enable us to run reports from other systems but ran into problems when it was loaded on clients with PS 7.02.  There were changes to the basic crystal odbc connectivity that caused PS’s Crystal to stop working.  Has anyone been able to use both on one client system?  Has anyone had any problems with Crystal 6.0 and the PS version. 

: Thanks


 
***************** End Of Article ****************** 
 
Darryl Martin posted Message 263 in Message Board 
 
Dated  : May 04, 2000 at 16:00:32 EST
Subject: Re: Report Archiving with Peoplesoft
 
: My client is implementing HRMS 7.5.  Payroll users have identified the need to archive bulk report electronically for future reference.  Has anyone come across this requirement and what is your experience and recommendation?  Thanks in advance.


 
***************** End Of Article ****************** 
 
Jin Lambert posted Message 264 in Message Board 
 
Dated  : May 08, 2000 at 16:55:32 EST
Subject: print multiple sqr reports on Unix printer outq
 
I wrote a sqr program and need to run it inside Psoft process scheduler on unix server, which prints out all multiple reports generated to the unix printer outq.

I have tried to put it on the run control-output destination by piping the reports to the printer outq.  my job runs succesfully and reports generated on the correct unix folder - but nothing printed.

any suggestion or ideas of how to make this to work???
 
***************** End Of Article ****************** 
 
cesar barros posted Message 265 in Message Board 
 
Dated  : May 10, 2000 at 06:14:23 EST
Subject: Re: PSNOTES.EXE
 
: Am curious if anyone has experienced the following:

: We are trying to use Workflow Administrator to import Lotus Notes information through message agent.  We have it set up as indicated in PeopleBooks, however we keep running into an error in PSNOTES, which states "access violation in PSNETAPI.DLL".  Unfortunately, there is no real help availiable. 

: We are running PeopleTools 7.5 on a WinNT box.

: Any help would be appreciated.  Please reply to the e-mail address listed [e.david.monnerat@us.arthurandersen.com]

: Thanks


 
***************** End Of Article ****************** 
 
Ed Judge posted Message 266 in Message Board 
 
Dated  : May 12, 2000 at 09:00:10 EST
Subject: SQR Viewer
 
I am trying to save a .spf file from the viewer as csv or html. 
Neither option produces a file. Also, does anyone know the difference between SQRVW and SQRVWJ? As always, any help is appreciated.
 
***************** End Of Article ****************** 
 
Khone Rathsachack posted Message 267 in Message Board 
 
Dated  : May 22, 2000 at 15:49:56 EST
Subject: Crystal 8 webreporting
 
Greetings,


 
***************** End Of Article ****************** 
 
Khone Rathsachack posted Message 268 in Message Board 
 
Dated  : May 22, 2000 at 15:57:56 EST
Subject: Crystal 8 webreporting
 
Greetings,
  I am new to this forum,  My current situation is that I generate a sequence of username and passwords via the crystal engine api calls within my cgi application.  I use oracle 8i for my database and develop with borland C++ Builder 4.0...Once this dynamically  generated sequence is done..I post this syntax via a url link...once the user clicks on the link...the sequences of username, password and subreport are passed to the crystal web engine.  The engine can interpert up to the 5th subreport...after that the sequence does not get interpreted by the web engine...I have confirmed the sequence via the crystal web component viewer and it is in sequence with the crystal report...I can also open the report in the crystal designer just fine and view the information...please help!!!!


 
***************** End Of Article ****************** 
 
Paul Ciszewski posted Message 269 in Message Board 
 
Dated  : May 23, 2000 at 07:29:59 EST
Subject: CloseIdle - A License Management Utility
 
Dynamic Software has developed a utility to shutdown a Windows application if the application is idle (no user activity) after a certain amount of time.  We call the utility CloseIdle.  We originally developed it for BAAN but we feel it should work with other Windows-based applications that have a limited-user license implementation.  Even if the application is not a Windows-based application but is running under a Windows emulator, we feel we should be able to shutdown the emulator's session which in turn should free a license (a seat).

In many businesses, users get into an application but forget to shut it down after they are finished - tying up an expensive license.  CloseIdle solves that problem.  

Also note - CloseIdle monitors an application - not the workstation.  For example, if a user is in MICROSOFT WORD typing a document but running BAAN in the background - CloseIdle will monitor activity in BAAN AND CloseIdle will shutdown BAAN if BAAN is idle for a certain amount of time.
 
A demonstration version is available at our Web Site at www.dsigb.com with documentation on setup.  The demo version is a fully functional version except it will close an idle session after 30 seconds.  

I am not familiar with PeopleSoft - so we are not sure if this utility is useful to PeopleSoft users.  Your comments are welcomed.

 
***************** End Of Article ****************** 
 
Johnnie Alexis Portillo  posted Message 270 in Message Board 
 
Dated  : May 23, 2000 at 13:18:36 EST
Subject: Re: SQA Robot
 
: I need information regarding using SQA Robot to test PeopleSoft Version 7.5.  Anyone with experience utilizing this product?


 
***************** End Of Article ****************** 
 
Carey Kraus posted Message 271 in Message Board 
 
Dated  : June 09, 2000 at 10:32:35 EST
Subject: HP 8000 &amp; SQR
 
I have an SQR that printed just fine to other HP printers, but now jumbles the fonts when I send it to an HP 8000 printer.  Does anyone have any ideas what needs to be changed to accomodate this printer?  Thanks.
 
***************** End Of Article ****************** 
 
Carey Kraus posted Message 272 in Message Board 
 
Dated  : June 09, 2000 at 10:33:22 EST
Subject: HP 8000 &amp; SQR
 
I have an SQR that printed just fine to other HP printers, but now jumbles the fonts when I send it to an HP 8000 printer.  Does anyone have any ideas what needs to be changed to accomodate this printer?  Thanks.
 
***************** End Of Article ****************** 
 
EDM posted Message 273 in Message Board 
 
Dated  : June 14, 2000 at 09:50:15 EST
Subject: Re: HP 8000 &amp; SQR
 
I believe HP 8000 has different PCL commands. SQR uses PCL codes
for HP laserjet 5 series and lower. You may have to see the
HP 8000PCL language reference manual to see what changes needs
to be done.


 
***************** End Of Article ****************** 
 
madhu posted Message 274 in Message Board 
 
Dated  : June 14, 2000 at 18:53:49 EST
Subject: Crystal on Web
 
Can someone give me an idea, how to post crystal reports on web.
I am using HTML access and want crystal reports to hit the oracle database directly. I know that there is a  need to modify the active server pages to hit the database directly. I Would appreciate anykind of information leading towards this issue.
 
***************** End Of Article ****************** 
 
Ed Benitez posted Message 275 in Message Board 
 
Dated  : June 15, 2000 at 22:27:39 EST
Subject: Printing bar code labels in Crystal
 
I have a requirement to print a bar code label as part of a Crystal Report. I could not find any documentation as to how to do this and was hoping that someone out there could provide me with some sugestions as to how to print a bar code label within a report.

Thanks in advance

Ed 

 
***************** End Of Article ****************** 
 
amitb posted Message 276 in Message Board 
 
Dated  : June 15, 2000 at 23:59:38 EST
Subject: Re: SQA Robot
 
I have used SQA for peoplesoft testing. Takes times. tried to load in 20,000 vouchers, similar no of bills,PO . took a long time. would reccomend using a SQR


 
***************** End Of Article ****************** 
 
Swapan Mahato posted Message 277 in Message Board 
 
Dated  : June 20, 2000 at 00:03:28 EST
Subject: Can't run some Crystal Reports thru Citrix
 
Can't run a few Crystal Reports when run through Citrix. It runs in normal two tier mode. Any help would be appreciated.
Has it something to do with DLLs?
PeopleSoft release: HRMS 7.51, PeopleTools 7.55
 
***************** End Of Article ****************** 
 
Mark Myhre posted Message 278 in Message Board 
 
Dated  : June 21, 2000 at 17:36:26 EST
Subject: Re: SQA Robot Scripts
 
Actually, Crestone Offers any script for any version of PS you are running in any module.  

: : : I need information regarding using SQA Robot to test PeopleSoft Version 7.5.  Anyone with experience utilizing this product?

: : I terry,

: : I use SQA team suite for testing peoplesoft financials and HR from the team developpment. What information do you need ?

: Hi, 
: I am Alok(Alok.Aggarwal@db.com) here :

: I just wanted to know wheather any Pre-recorded test cases are available for PeopleSoft HRMS 7.0 (PeopleTools 7.05). For yours information, I enquired from PeopleSoft Global Support division,Germany.According to them it (pre-recorded) is available for PeopleSoft 6.0 but NOT for version 7.0. 

: Would be appreciable if U can directly reply to mail-id.

: Thanks and Regards
: Alok
: Alok.Aggarwal@db.com


 
***************** End Of Article ****************** 
 
Roger posted Message 279 in Message Board 
 
Dated  : June 26, 2000 at 12:05:55 EST
Subject: dB Spaces
 
Help! 

I am a Oracle DBA and have been given the task of tuning a informix dB (the dba left in a 'rush')  I have installed and managed PS on both Oracle and MSSQL for many years but I am confused by this configuration.  As best as I can tell all the PeopleSoft records (tables) are located within 2 dBspaces.  I am used to seeing multible tablespaces (PSAPP,PSPO,etc) is this correct. Any informaiton would be a help.

  - Roger
 
***************** End Of Article ****************** 
 
rgk posted Message 280 in Message Board 
 
Dated  : June 28, 2000 at 11:30:25 EST
Subject: Re: Problem in SQR Printing
 
: Hi,
: I have been trying to print my SQR reports. But the reports dont go to the printer. My printer is not a network one. So i cant use lpt1 or lpt2 ports. Its an IP printer. Do i need to do some special settings or something? Please give me some suggestions.
: Thanks,
: Gautam


If PeopleSoft is running on UNIX, you will need to set up an LPR/LPD device on your UNIX server in order to have network printing capabilities on your printer.  Product such as FacetWin, TUN, etc.  provide these features for about $195


 
***************** End Of Article ****************** 
 
rgk posted Message 281 in Message Board 
 
Dated  : June 28, 2000 at 11:32:48 EST
Subject: fax from crystal reports
 
SCH Technologies has just released an interface that allows you to fax any report from the Crystal Report Writer as simply as printing to a printer.  If you would like more information, please stop by our web site at http://www.merkur.com.
 
***************** End Of Article ****************** 
 
Ken Smith posted Message 282 in Message Board 
 
Dated  : June 29, 2000 at 15:30:33 EST
Subject: notes connector
 
Does anyone have experience with the Lotus Notes connector to PeopleSoft?  I have questions about setting up the message definitions to work properly.  I have been successful with a very simple application but have not been able to expand on the original app.  If anyone has experience designing the business processes for this type of application, please contact me.  I'd love to discuss the issues.  If you mail your phone number, I will call.  Thank You,    Ken Smith.
 
***************** End Of Article ****************** 
 
Cesar Bustamante posted Message 283 in Message Board 
 
Dated  : July 04, 2000 at 11:17:24 EST
Subject: Notes vs. Exchange on Peoplesoft
 
I was wondering:

We're some steps close into implementing the Workflow administrator on our PeopleSoft installation and since we're new on working with this ERP we know we should have a mail server capable to work at the max for PeopleSoft.

We're leaning toward Lotus Domino and Notes to be our mail server(which is recommended), but what about MS Exchange?

Is it worth it? How compatible they should be? Is the architecture from Exchange not similar or not recommended for PeopleSoft?

I'm a big Exchange fan and moving to Domino will be like playing for a new team.... I know for sure that I have to implement Lotus, but I'm eager for some mixed reviews.
Can somebody lend me a hand here and post your reviews ASAP.

Best Regards...

 
***************** End Of Article ****************** 
 
Dheeraj Mishra posted Message 284 in Message Board 
 
Dated  : July 06, 2000 at 15:01:19 EST
Subject: Process Scheduler- Dead or Alive?
 
I had a problem with Process Scheduler, very often it use to go down or hang.  I have written a unix shell scripts to keep polling the status of Process Scheduler and will email you if it goes down. 

So you can bring it back before the users yell at you.

Let me know if anybody is interested in doing that!!

thanks..Dheeraj

 
***************** End Of Article ****************** 
 
Sher Clark posted Message 285 in Message Board 
 
Dated  : July 07, 2000 at 00:53:47 EST
Subject: ***ORACLE PASSWORD COMPLEXITY FUNCTION***
 
I am using the password complexity function in Oracle. If I use the sample script provided by Oracle (see Oracle8 Administrator's Guide - end of chpt 19), there are references to LENGTH(old_password) and SUBSTR(old_password...). However, upon analysing the contents of old_password it is empty - it seems the old password is not passed into the old_password parameter when the function is called. Can anyone help? As per corporate requirements, I need to set strict password policies and need to reference the value in old_password... Thanks. 
 
***************** End Of Article ****************** 
 
Angie posted Message 286 in Message Board 
 
Dated  : July 11, 2000 at 14:59:46 EST
Subject: Publish PS Financials using Citrix MetaFrame 1.8
 
I would like to use MetaFrame 1.8 to provide remote access to PS.  Does anyone have a "How to" document that outlines the steps required?  Or has anyone heard of a book that provides this information.  I heard there is good literature in PS Customer Connection.  Is there a "Guest" account for this site?

Thanks
 
***************** End Of Article ****************** 
 
Kevin Choksi posted Message 287 in Message Board 
 
Dated  : July 12, 2000 at 16:20:48 EST
Subject: Re: PS Time &amp; Labor is no good, HELP!
 
Jon, you may want to investigate other time and attendance solutions.  Take a look at "<a href="http://www.time-and-attendance.com/time-and-attendance-white-papers/choosing/choosing_main.html">Choosing a time and attendance system</a>" to help you select a system that meets your needs.

: PS time and labor looks too complicated and I was told that it does not work well.  Does anyone know of another way to get this information into PS (e.g., an add-on software package)?  Thanks. 


 
***************** End Of Article ****************** 
 
nency  posted Message 288 in Message Board 
 
Dated  : July 12, 2000 at 20:41:51 EST
Subject: Freeware, Bookmark Mate 3.0
 
I want to recommand a freeware: bookmark mate 3.0. But I don't know whether I can post it here.
It's a freeware!

If want to try, click at:

http://www.bookmarkonline.com/download/bmm.exe


It can help you:

o Upload to and manage your bookmark portfolios at Bookmark Everywhere
o Edit and organize bookmark portfolios of IE and Netscape
o Auto-probe multiple web sites for new update
o Launch browsers with a single click on bookmarks
o Receive messages from webmasters of your favorite sites ...

Maybe it's useful!

 
***************** End Of Article ****************** 
 
Tony DeLia posted Message 289 in Message Board 
 
Dated  : July 15, 2000 at 19:27:45 EST
Subject: FREE Book Preview - Essential Guide to PeopleSoft Development and Customization
 
Hello PeopleSoftFans,
I posted some sample PDF files for the "Essential Guide to PeopleSoft Development and Customization" (Manning Publications - Delia, Landres, Rivera, Sankaran) on my website - http://www.sqrtools.com - The book is being printed and will be distributed in a couple weeks... The PDF samples include Chapter 9 (PeopleSoft Application Processor), Chapter 16 (Working with Scrolls), Chapter 35 (What is Application Engine), plus the Table of Contents, Index, Preface, etc... any feedback is, as always, greatly appreciated! Thanks!
Tony DeLia
http://www.sqrtools.com
 
***************** End Of Article ****************** 
 
Joanna Liu posted Message 290 in Message Board 
 
Dated  : July 18, 2000 at 04:13:33 EST
Subject: Re: Problems with Crystal 7.0 and PS Crystal
 
We have install Crystal 7.0 as the web report server and have the same problem happened. What I done is to recreate the crystal design and doesn't login PeopleSoft but login the backend database. It seems the version is not certified by PeopleSoft 7.x

: We are having the same problems.  Any info on a resolution would be appreciated.
: Thanks!

: 
: : Has anyone had a problem running Crystal 7.0 (not embedded within PS) and PS Crystal (5.0 PS 7.02)?  We purchased the 7.0 version to enable us to run reports from other systems but ran into problems when it was loaded on clients with PS 7.02.  There were changes to the basic crystal odbc connectivity that caused PS’s Crystal to stop working.  Has anyone been able to use both on one client system?  Has anyone had any problems with Crystal 6.0 and the PS version. 

: : Thanks


 
***************** End Of Article ****************** 
 
Joanna Liu posted Message 291 in Message Board 
 
Dated  : July 24, 2000 at 02:30:27 EST
Subject: Re: Crystal on Web
 
You should install the Crystal Report server in the web server machine and launch the process "Crystal web image server" and "Crystal web page server". Hope this is useful.

Joanna


: Can someone give me an idea, how to post crystal reports on web.
: I am using HTML access and want crystal reports to hit the oracle database directly. I know that there is a  need to modify the active server pages to hit the database directly. I Would appreciate anykind of information leading towards this issue.




 
***************** End Of Article ****************** 
 
Pamela Jordan posted Message 292 in Message Board 
 
Dated  : July 24, 2000 at 09:13:52 EST
Subject: Re: Problem in SQR Printing
 
: : Hi,
: : I have been trying to print my SQR reports. But the reports dont go to the printer. My printer is not a network one. So i cant use lpt1 or lpt2 ports. Its an IP printer. Do i need to do some special settings or something? Please give me some suggestions.
: : Thanks,
: : Gautam

: Hello,

I have the same problem.  The platforms I'm running PeopleSoft on is a NT Workstation.  I need help with printing PeopleSoft reports to the HP8100 printer.  The printer is setup as a LPR printer with IP address.  When I try to send a SQR report,
from within PeopleSoft, to this printer, they are not getting there. I have no problems printing other reports from other applications to this printer, but PeopleSoft.  Can anyone give me some suggestions?

: If PeopleSoft is running on UNIX, you will need to set up an LPR/LPD device on your UNIX server in order to have network printing capabilities on your printer.  Product such as FacetWin, TUN, etc.  provide these features for about $195


 
***************** End Of Article ****************** 
 
Julien posted Message 293 in Message Board 
 
Dated  : July 24, 2000 at 09:35:12 EST
Subject: Links to SQL Server
 
I have a problem : I got a SQL Server base (SQL1) with a table (T1). This table (T1) got a foreign key (FKT2) wich refers an external table (T2) made in a MS-Access base (Access1). Can I describe ,in the SQL Server base, a link refering the MS-Access table ? If it's possible, how can i do this ?

Thanks for your help ...
 
***************** End Of Article ****************** 
 
Pamela Jordan posted Message 294 in Message Board 
 
Dated  : July 24, 2000 at 09:58:03 EST
Subject: Problems printing SQR Reports within PeopleSoft
 
Hello,

The platforms I'm running PeopleSoft on is a NT Workstation. I need help with printing PeopleSoft reports to the HP8100 printer. The printer is setup as a LPR printer with IP address. When I try to send a SQR report, from within PeopleSoft, to this printer, they are not getting there. I have no problems printing documents from other applications to this printer, so I know the problem is not with the printer. Can anyone give me some suggestions?


 
***************** End Of Article ****************** 
 
Jason Hunt posted Message 295 in Message Board 
 
Dated  : July 27, 2000 at 15:42:35 EST
Subject: Re: Laser Check Printing With PeopleSoft
 
: Print checks directly from PeopleSoft tables, A/P and Payroll.  Here are some of the capabilities:
: * Brio interface to query the check file
: * Datawarehousing interface to upload files
: * Print remotely and split the file to several printers

: Please evaluate our site http://www.NationSoftinc.com or call us 949-724-0360

: We look forward to partnering with you.



 
***************** End Of Article ****************** 
 
EDM posted Message 296 in Message Board 
 
Dated  : July 28, 2000 at 09:53:56 EST
Subject: Re: Problems printing SQR Reports within PeopleSoft
 
Pamela,

Before I could help you in your problem, I would need some more
information from you. I am a programmer,PC tech, Network support
kind of a person and I believe your problem might be related to
your settings.

1. What is your platform?
2. Does the SQR has PCL escape sequences? If so, then your
   HP8100 and the PCL commands is not compatible.
3. Did you check your local printer settings for lpt, defaults,
   etc.

3. What is your network? Novell, OS2, etc

4. When you say LPR or LPD type of printer, is this sort of
   a line printer? . I used to set this type of printer but I
   believe they are used for certain applications local to 
   a server type of systems like AS400.
4. Where do you run the SQR? Client or Server?

5. As much as possible, please try give your system environments
   such as servers, database, 2 or tier.

 
***************** End Of Article ****************** 
 
Swapan Mahato posted Message 297 in Message Board 
 
Dated  : July 28, 2000 at 14:19:17 EST
Subject: Re: Publish PS Financials using Citrix MetaFrame 1.8
 
Angie,

Here's the path:
Community -> Discussion Groups-> (Sort Documents by) Category -> Citrix Winframe

These documents are comprehensive. The Citrix website has lots of documents too.

Good Luck.

Swapan




: I would like to use MetaFrame 1.8 to provide remote access to PS.  Does anyone have a "How to" document that outlines the steps required?  Or has anyone heard of a book that provides this information.  I heard there is good literature in PS Customer Connection.  Is there a "Guest" account for this site?

: Thanks


 
***************** End Of Article ****************** 
 
sanam posted Message 298 in Message Board 
 
Dated  : July 31, 2000 at 09:43:59 EST
Subject: Web Client
 
Urgent

Can anyone tell me how to implement PS web client?
 
***************** End Of Article ****************** 
 
Luis E. Perez posted Message 299 in Message Board 
 
Dated  : August 07, 2000 at 11:33:29 EST
Subject: Crystal Report Design Question
 
I have a report using three tables.
2 tables are linked and the third one is not because there is no field that
relates this third table to any of the other two.
this third table only has one record and basically contains some flags.
I have to display data from the two linked tables depending on certain flags
that I am supposed to check for in the third table.
I have been trying to achieve in Crystal to no avail.
Does anybody has any experience with anything like this ?

thanks


 
***************** End Of Article ****************** 
 
Matthias Adis posted Message 300 in Message Board 
 
Dated  : August 08, 2000 at 03:43:50 EST
Subject: Re: Data Conversion and Integration Products
 
hope, you received this message! My name is Matthias Adis and I'm also investigating in data migration tools. I'm very interested in the smartDB workbench and Convoy/DM, but it's impossible to get some actual information 
respectively to reach the web site of SmartDB. 

I guess the company doesn't exist anymore or the company name/product name has changed. 

I would appreciate it if you could give me some further information. 

Thanks in advance, 

Matthias Adis 
(Germany) 

 
***************** End Of Article ****************** 
 
Sid posted Message 301 in Message Board 
 
Dated  : August 08, 2000 at 12:08:16 EST
Subject: Re: Crystal Report Design Question
 
I've never done this myself, but I would see if this can be done with a "If-Then-Else" formula field.

: I have a report using three tables.
: 2 tables are linked and the third one is not because there is no field that
: relates this third table to any of the other two.
: this third table only has one record and basically contains some flags.
: I have to display data from the two linked tables depending on certain flags
: that I am supposed to check for in the third table.
: I have been trying to achieve in Crystal to no avail.
: Does anybody has any experience with anything like this ?

: thanks


 
***************** End Of Article ****************** 
 
Dan Stroup posted Message 302 in Message Board 
 
Dated  : August 08, 2000 at 18:56:45 EST
Subject: Re: Web Client
 
Write me a detailed explaination of what you want and I'll help you out. Or give me your phone number.


: Urgent

: Can anyone tell me how to implement PS web client?


 
***************** End Of Article ****************** 
 
Matthias Adis posted Message 303 in Message Board 
 
Dated  : August 09, 2000 at 02:00:19 EST
Subject: Data migration tools for PeopleSoft
 
Hi folks,

I'm investigating in several data migrating tools like Convoy/DM and SmartDB, but it's really difficult to get some detailed information about these products.

Has anyone some experiences with these tools regarding data migration from legacy systems to PS?

The most recommended software is Convoy/DM and I read that SmartDB is customzied to Oracle Apps? 

The other thing is that I need some figures about license costs...

Thank you ver much in advance,

so long 
Matthias Adis
 
***************** End Of Article ****************** 
 
ddement posted Message 304 in Message Board 
 
Dated  : August 09, 2000 at 12:54:35 EST
Subject: Web Interface and Increased Functionality!
 
Would you like to schedule jobs from a remote location? Would you like to receive notification if a specific job fails? Would you like to select jobs from a pull down menu reducing the need for double keying and re-scripting every job? Or even run cross platform, cross applications from a single point of control?

If you would like information on how we can help with these issues and Increase productivity in your production/operations environment, Better allocate data center resources, Maintain Service Levels/Increase UPTIME, Avoid disasters, application failures, and outages then Please check out our web site http://www.tidalsoft.com for a free download.

 
***************** End Of Article ****************** 
 
Alan posted Message 305 in Message Board 
 
Dated  : August 09, 2000 at 20:08:20 EST
Subject: Running PS jobs on the 2-tier setup
 
We are installing the Peopletools and I was wondering if anyone can help me figure out how to kick off various jobs in a 2-tier setup from a windows environemt? Can we use the dos command line or the configuration manager?

Thanks,
-Alan
 
***************** End Of Article ****************** 
 
Kevin Sanford posted Message 306 in Message Board 
 
Dated  : August 09, 2000 at 22:45:03 EST
Subject: Crystal 7.0 enabling ASP wen reports(Active X viewer)
 
I loaded Crystal Reports 7.0 w/ the ASP Reports component on an Windows NT IIS4.0 server. If I type in the web address to the asp page using the browser on the server, the report loads with an active x interface (pERFECT:) But when I go to a client machine and type in the address it loads a gray page with a missing image where the active x reports should be.. For some reason the viewer is not making it to the client machine. The client machine is running IE 5.0. Any help would be greatly appreciated.. Thanks..
 
***************** End Of Article ****************** 
 
Shakeel Syed Mustafa posted Message 307 in Message Board 
 
Dated  : August 23, 2000 at 01:15:24 EST
Subject: Re: SQA Robot
 
Hello,

I am Shakeel working in OCTON TECHNOLOGIES LTD. as QSE, we need to automise the Web site testing, we are in the business of B2B,B2C sites and have clients in US ,Germany , Australia.

You are requested to send me the detail about the testing tool , SQA Robot , also please furnish the pre requetee required to operate this tools, as I am from non software background.  


 
***************** End Of Article ****************** 
 
Gautam G posted Message 308 in Message Board 
 
Dated  : August 23, 2000 at 05:12:02 EST
Subject: Knowledge Management
 
Please let me know whether there are any 3rd Party Tools available for interfacing with PeopleSoft HR 7.0

Thanks 

Gautam
 
***************** End Of Article ****************** 
 
Gautam Gangoli posted Message 309 in Message Board 
 
Dated  : August 23, 2000 at 05:22:48 EST
Subject: Re: Debugging SQR Programs
 
Hi Sangamitra,

To Debug SQRs, you have to use the 'display' command in the sqr program file, and this can be used as a debugging tool. The log file 'sqr.log' can then be checked to debug the problem.
Similarly you can use the 'debug' command also. 

Gautam Gangoli

: Hi Everybody,

: Is there any free debugger tool available for debugging sqr
: programs? If yes, please let me know about the site or 
: mail me directly?

: How do find the exact line numbers in error messages given while
: running SQR reports?

: Regards
: Thanks in advance


 
***************** End Of Article ****************** 
 
Mahendra posted Message 310 in Message Board 
 
Dated  : August 23, 2000 at 10:53:23 EST
Subject: ESSBASE
 
I'm new for ESSBASE server, Would you mind to share where can find more info for ESSBASE specially backup and recovery?

 
***************** End Of Article ****************** 
 
Patrick Whittingham posted Message 311 in Message Board 
 
Dated  : August 24, 2000 at 09:50:39 EST
Subject: Crystal Reports 7 &amp; Peoplesoft 7.5
 
Question :
  
  I am trying to run PSTools 7.58 delivered Crystal reports via Crystal Info Server 7. I want schedule the Cystal Reports via CI Server, but when I schedule the report, the prompts are not being passed to the PS Query. I am being prompted at execution time of the report. Any help would be appreciated.

TIA,
Patrick Whittingham
whittip@usafoo.unitedspacealliance.com


 
***************** End Of Article ****************** 
 
Anup Nair posted Message 312 in Message Board 
 
Dated  : August 28, 2000 at 04:15:51 EST
Subject: Re: SQA Robot
 
: Hi all.

Can you tell me where i can get a free download of SQA Robo or Visual Yest.

Anup.

 
***************** End Of Article ****************** 
 
DS posted Message 313 in Message Board 
 
Dated  : August 28, 2000 at 09:10:27 EST
Subject: Re: Crystal Report Design Question
 
It can also be done through the 'select expert' in the 'report' menu.


: I've never done this myself, but I would see if this can be done with a "If-Then-Else" formula field.

: : I have a report using three tables.
: : 2 tables are linked and the third one is not because there is no field that
: : relates this third table to any of the other two.
: : this third table only has one record and basically contains some flags.
: : I have to display data from the two linked tables depending on certain flags
: : that I am supposed to check for in the third table.
: : I have been trying to achieve in Crystal to no avail.
: : Does anybody has any experience with anything like this ?

: : thanks


 
***************** End Of Article ****************** 
 
dennis  posted Message 314 in Message Board 
 
Dated  : August 29, 2000 at 11:02:02 EST
Subject: Re: Process Scheduler- Dead or Alive?
 
: I had a problem with Process Scheduler, very often it use to go down or hang.  I have written a unix shell scripts to keep polling the status of Process Scheduler and will email you if it goes down. 

: So you can bring it back before the users yell at you.

: Let me know if anybody is interested in doing that!!

: thanks..Dheeraj

Could I have the solution that you have written up because I am having the same problem and I am looking for similar resolution. Thanks for your help, Dheeraj!
cheers,
dennis
 
***************** End Of Article ****************** 
 
dennis  posted Message 315 in Message Board 
 
Dated  : August 29, 2000 at 11:02:10 EST
Subject: Re: Process Scheduler- Dead or Alive?
 
: I had a problem with Process Scheduler, very often it use to go down or hang.  I have written a unix shell scripts to keep polling the status of Process Scheduler and will email you if it goes down. 

: So you can bring it back before the users yell at you.

: Let me know if anybody is interested in doing that!!

: thanks..Dheeraj

Could I have the solution that you have written up because I am having the same problem and I am looking for similar resolution. Thanks for your help, Dheeraj!
cheers,
dennis
 
***************** End Of Article ****************** 
 
Cindy Burns posted Message 316 in Message Board 
 
Dated  : September 06, 2000 at 14:14:01 EST
Subject: JetForms or other forms creation products
 
Has anyone used Jetforms or other products to create output forms.  I would like to others that use these technologies.  Thanks. 
 
***************** End Of Article ****************** 
 
Sid posted Message 317 in Message Board 
 
Dated  : September 08, 2000 at 18:50:09 EST
Subject: Re: Crystal Reports 7 &amp; Peoplesoft 7.5
 
Hi,

I'm not sure what a CI server is.  If you want to pass a parameter for a crystal report run through the process scheduler, then you'll need to specify the parameter on the process definition(Peopletools>Process Scheduler>Use Process Definition)

: Question :
:   
:   I am trying to run PSTools 7.58 delivered Crystal reports via Crystal Info Server 7. I want schedule the Cystal Reports via CI Server, but when I schedule the report, the prompts are not being passed to the PS Query. I am being prompted at execution time of the report. Any help would be appreciated.

: TIA,
: Patrick Whittingham
: whittip@usafoo.unitedspacealliance.com


 
***************** End Of Article ****************** 
 
Kevin Chelius posted Message 318 in Message Board 
 
Dated  : September 19, 2000 at 17:10:03 EST
Subject: Integrating PS HR  or Payroll
 
I work for an employee portal company and many of our clients use PeopleSoft HR and/or PeopleSoft Payroll. I'm investigating methods to automate our access to these systesm. Currently, we employ a datafile method, whereby the company outputs from PS to a datafile. We then input the datafile. I'd like to build a bridge from PS to our portal.

I would appreciate guidance on the right direction to persue. Where can I get information on the PS API's and archetecture?
Are there middleware companies which already have figured out how to do this?

Thanks
Kevin
 
***************** End Of Article ****************** 
 
Satyendu Patnaik posted Message 319 in Message Board 
 
Dated  : September 20, 2000 at 07:23:52 EST
Subject: Re: Tools for Data Migration from Legacy systems 
 
We would like to have information on the import of legacy data in ASCII format.We want to import data with lots of dependant factors into oracle
 
***************** End Of Article ****************** 
 
Hari posted Message 320 in Message Board 
 
Dated  : September 21, 2000 at 16:07:09 EST
Subject: Re: Integrating PS HR  or Payroll
 
: I work for an employee portal company and many of our clients use PeopleSoft HR and/or PeopleSoft Payroll. I'm investigating methods to automate our access to these systesm. Currently, we employ a datafile method, whereby the company outputs from PS to a datafile. We then input the datafile. I'd like to build a bridge from PS to our portal.

: I would appreciate guidance on the right direction to persue. Where can I get information on the PS API's and archetecture?
: Are there middleware companies which already have figured out how to do this?

: Thanks
: Kevin

Kevin:

There is a Java interface to Peoplesoft it is called as JMAC.
PeopleSoft Query API
Overview
The Query API enables your client-server and Web-based applications to access data in PeopleSoft supported databases through a PeopleSoft application server. The primary benefits of the Query API are as follows:

easy to use 
thread-safe 
fast 
highly scalable 
requires no installation of third party middleware 
leverages built-in PeopleSoft user administration and security 
packaged as a Bean/COM object; can be directly used by Windows and Java developers. 
Currently, only query operations are supported. It is recommended that updates be performed using PeopleSoft's Message Agent API.

The Query API and Java Message Agent Client (JMAC) can be used together. If they are used together, these two modules will share the same connection and session. The sharing is transparent to users. Users need to login only once. In this case, Connection.Open() should be used for the login since the Query API has a different security model from that of the Message Agent API.

 

Installation
The Query API is automatically installed by the HTML Access setup program. 

 

Object model
The Query API has a similar object model to Microsoft's ActiveX Data Objects (ADO). There are three major objects: Connection, Command and RecordSet: 

The Connection object allows a user to connect to a database through an application server using a PeopleSoft Operator ID. This object will share the same session as JMAC.

The Command object is a helper object. It allows an user to build persistent SQL query commands for execution and re-execution. It is required for execution if the query uses parameters.

RecordSet is used to retrieve query results.

 

Major features
The Query API supports key features for building client-server and Web-based applications: 

Dynamic query: 
Users should be able to construct a query statement dynamically to query database.

Query parameters: 
Users can use parameters in their query statements.

Use Operator ID for connection: 
Users must have a PeopleSoft account, but not necessarily a database account.

Support most of datatypes: 
See Types.

Meta sql support: 
Supports PeopleSoft meta sql.

 

Security Model
The current PeopleSoft security model for objects can be simply described as the following: each user is associated with an Operator ID. Each Operator ID belongs to certain classes. Each class has privileges for application objects. PeopleSoft's Security Administrator is used to manage user security; any operator who has access to Security Administrator should be regarded as trusted. 

Since there is no one-to-one relationship between a PeopleSoft application object and a database object, database object level security is not be used. Instead, the Query API adds extra security at the application level.

Two sets of Operator IDs and their corresponding passwords need to be provided to use the Query API. The first operator is the end user who will request the subsequent queries. This operator is logged by the system as the regular PeopleSoft user. The second operator is an artificial one, but must be a valid PeopleSoft user and have access to Security Administrator. If the credentials for the second operator are missing, the requests from the first operator will be denied.

The second operator plays the role of accepting or denying the use of the Query API, which prevents the abuse of the API. Since the second operator is handled by the Query service, it is not traceable by the PeopleSoft application server. 

There are two issues worth mentioning here. Normally, the second operator's password is provided by the application, not the end user. If this is the case, it is the application’s responsibility to keep the second operator's password safe. The other issue is that if the application can query sensitive information from a PeopleSoft database, the application has to add additional security to safeguard the query from being executed by unauthorized users.

 

Limitations
No scrollable cursor: scrollable cursors are not supported. 
No isolation setting: cannot set isolation level. 
No update: update operations are not supported. 
No table or row level security support: see Security Model section. 
No database object meta data browsing: no support for describing table, column, etc. 
 

Usage Examples
' Global objects
' Connection object
Dim conn As Object
' RecordSet object
Dim rs As Object

' Routine to load api objects
Sub onLoad()
        Set conn = CreateObject("PeopleSoft.jmacConnection.1")
End Sub

' Routine to connect to database using operator id
' Here PTADMIN is the second operator hard-coded here.
Sub onLogin(app As String, id As String, ps As String)
        conn.Open app, id, ps, "PTADMIN", "PTADMIN"
End Sub

' Routine to prepare and execute query
Sub onSearch(search As String)
        ' Sql statement
        Dim sql As String
        ' Command object
        Dim comm As Object
        ' Parameter
        Dim param As Object

        ' set up error handler
        On Error GoTo ErrorHandler

        ' Create command object with parameters
        sql = "select jcharacter, jdate, jtime, jdatetime, jinteger, jdouble, jlongtext, jimage from PS_jrecord where jcharacter = :1"
        Set comm = CreateObject("PeopleSoft.jmacCommand.1")
        comm.ActiveConnection = conn
        comm.CommandText = sql

        ' Prepare parameters
        Set param = comm.setString("jcharacter", 1, search)

        ' Execute the statement
        Set rs = comm.Execute()

        onNext
        Exit Sub

        ' Handle error here
        ErrorHandler:
        onError
End Sub

' Routine to fetch query data
Sub onNext()
        ' Field Collection
        Dim fields As Object
        ' Field object
        Dim fd As Object
        ' Image
        Dim img As Object

        ' set up error handler
        On Error GoTo ErrorHandler

        ' Get all fields
        Set fields = rs.fields
        Size = fields.Size

        ' Fetch the results
        If rs.BOF Then
                rs.moveFirst
        End If
        If Not rs.EOF Then
                PanelFrm.character_tb.Text = fields.Item("jcharacter").Value
                PanelFrm.date_tb.Text = fields.Item("jdate").Value
                PanelFrm.time_tb.Text = fields.Item("jtime").Value
                PanelFrm.datetime_tb.Text = fields.Item("jdatetime").Value
                PanelFrm.integer_tb.Text = fields.Item("jinteger").Value
                PanelFrm.double_tb.Text = fields.Item("jdouble").Value
                PanelFrm.longtext_tb.Text = fields.Item("jlongtext").Value
                PanelFrm.longtext_tb.Text = fields.Item("jlongtext").Value
                'PanelFrm.image.Picture = fields.Item("jimage").Value
                rs.moveNext
        End If
        Exit Sub

        ErrorHandler:
        onError
End Sub

' Error handler
Sub onError()
        ' Error
        Dim errs As Object
        Dim jerr As Object
        Set errs = conn.Errors
        nerr = errs.Size
        For j = 0 To nerr - 1 Step 1
                Set jerr = conn.Errors.getItem(j)
                Debug.Print jerr.Number & ": " & jerr.Description & jerr.NativeError
        Next j
        If Err <> 0 Then ' another error
                Debug.Print "Unexpected Error: " & Err.Description
        End If
End Sub

Sub onLogout()
        conn.Close
End Sub


 
***************** End Of Article ****************** 
 
Kedar Kaval posted Message 321 in Message Board 
 
Dated  : September 22, 2000 at 12:39:26 EST
Subject: APIs in PS8.0
 
I wanted to know how different are the APIs from ver 7.0x to  ver 8.0
Thanks,
Kedar
 
***************** End Of Article ****************** 
 
Kenneth Yankee posted Message 322 in Message Board 
 
Dated  : September 22, 2000 at 17:46:30 EST
Subject: Re: Links to SQL Server
 
Are you using SQLServer or SQLBase?? You say "SQL Server base" and there is no such animal.

: I have a problem : I got a SQL Server base (SQL1) with a table (T1). This table (T1) got a foreign key (FKT2) wich refers an external table (T2) made in a MS-Access base (Access1). Can I describe ,in the SQL Server base, a link refering the MS-Access table ? If it's possible, how can i do this ?

: Thanks for your help ...


 
***************** End Of Article ****************** 
 
Kenneth Yankee posted Message 323 in Message Board 
 
Dated  : September 22, 2000 at 17:56:18 EST
Subject: Re: Problems printing SQR Reports within PeopleSoft
 
SQR is a DOS based system. Try doing a "capture" of LPT1 on your client machine that is mapped to the networked printer..
Example -
"net use lpt1: \\financial\HPCheckWriter"
This is entered at a DOS prompt. The printer "HPCheckWriter" is the share name of a printer logically assigned to, or connected to, a computer with a logical name of "financial".. Once this command is issued, it should continue to capture LPT1 until
"net use lpt1: /delete" is issued.

: Hello,

: The platforms I'm running PeopleSoft on is a NT Workstation. I need help with printing PeopleSoft reports to the HP8100 printer. The printer is setup as a LPR printer with IP address. When I try to send a SQR report, from within PeopleSoft, to this printer, they are not getting there. I have no problems printing documents from other applications to this printer, so I know the problem is not with the printer. Can anyone give me some suggestions?


 
***************** End Of Article ****************** 
 
Kenneth Yankee posted Message 324 in Message Board 
 
Dated  : September 22, 2000 at 18:01:40 EST
Subject: Re: Running PS jobs on the 2-tier setup
 
Are you wanting to know how to install Peopletools out on workstations automatically, or how to run Peoplesoft jobs automatically?? If it's the later, you can use the process scheduler to run jobs at a certain time for how ever many times. (bring up the job/process in peoplesoft then click the traffic lights to run it. On that panel there is options to do this)

: We are installing the Peopletools and I was wondering if anyone can help me figure out how to kick off various jobs in a 2-tier setup from a windows environemt? Can we use the dos command line or the configuration manager?

: Thanks,
: -Alan


 
***************** End Of Article ****************** 
 
Roy Altman posted Message 325 in Message Board 
 
Dated  : September 28, 2000 at 20:53:19 EST
Subject: Web-based Manager/Employee Self-service
 
HR21 is offering a Web-based Manager/Employee Self-service system for PeopleSoft. For more information, please contact me at: 
roy.altman@jginfo.com
Voice mail: 800-551-0311 x. 5693
or 
Kenny Ridell at (516) 753-4106
 
***************** End Of Article ****************** 
 
Roy Altman/HR21 posted Message 326 in Message Board 
 
Dated  : September 28, 2000 at 20:59:01 EST
Subject: Re: Web/IVR Open Enrollment and Benefits statements
 
We (HR21) have a web-based product that automates Benefits open-enrollment, as well as other Manager/Employee self-service functions. It is currently in use at Panasonic. We can provide IVR services, as well.
For more information, please contact me at:
roy.altman@jginfo.com
voice mail: (800) 551-0311 x. 5693
or 
Kenny Ridell: (516) 753-4106
 
***************** End Of Article ****************** 
 
hector ceballos posted Message 327 in Message Board 
 
Dated  : October 01, 2000 at 09:51:26 EST
Subject: Re: PSNOTES.EXE
 
: I'm not sure if you are receiving the error message for the same reason we did, but we got that error message every time we tried to run the MessageAgentAPI in 2-tier mode.  When we ran it in three-tier mode, we had no issues (other than the lack of standard functionality and lack of decent error handling).


: : Am curious if anyone has experienced the following:

: : We are trying to use Workflow Administrator to import Lotus Notes information through message agent.  We have it set up as indicated in PeopleBooks, however we keep running into an error in PSNOTES, which states "access violation in PSNETAPI.DLL".  Unfortunately, there is no real help availiable. 

: : We are running PeopleTools 7.5 on a WinNT box.

: : Any help would be appreciated.  Please reply to the e-mail address listed [e.david.monnerat@us.arthurandersen.com]

: : Thanks


 
***************** End Of Article ****************** 
 
Erwin Dania posted Message 328 in Message Board 
 
Dated  : October 04, 2000 at 11:01:06 EST
Subject: Re: Problems printing SQR Reports within PeopleSoft
 
Hi!
We also had this SQR printing problem.
The solution for us was renaming the printer name to LPT1.
Hope this help!
Bye!



: Hello,

: The platforms I'm running PeopleSoft on is a NT Workstation. I need help with printing PeopleSoft reports to the HP8100 printer. The printer is setup as a LPR printer with IP address. When I try to send a SQR report, from within PeopleSoft, to this printer, they are not getting there. I have no problems printing documents from other applications to this printer, so I know the problem is not with the printer. Can anyone give me some suggestions?


 
***************** End Of Article ****************** 
 
Reddy posted Message 329 in Message Board 
 
Dated  : October 10, 2000 at 15:26:44 EST
Subject: Where can i find sqa robot scripts examples
 
Hi friends,
if possible send me some scripts, and i want to create functions and keep all the functions in a DLL so that i can call that DLL once.
Bye
 
***************** End Of Article ****************** 
 
bernardo posted Message 330 in Message Board 
 
Dated  : October 13, 2000 at 21:34:30 EST
Subject: Re: msjter32.dll problem
 
: hi,i have this problem when startibg up my pc with win98, a window displaying "error launching msjter32.dll" due to not enoth
: memory?
: could anyone help pls?
: thanks


 
***************** End Of Article ****************** 
 
John Bemman posted Message 331 in Message Board 
 
Dated  : October 16, 2000 at 09:08:25 EST
Subject: Webview Report - Browser Based Report Viewing and Archive
 
Pricing Information: visit our online demo at
www.jbsoftconsulting.com/webview

Webview Report          $5,000.00.......this also includes the following other JBSoft products that Webview Report uses.

"overlay and overprnt" - this allows you to create graphical forms in MS Word and generate form overlays that overprnt will merge with report data to compete a form such as A/P checks, invoices, statements, etc. Eliminates the need to purchase pre-printed forms.

"reformat and rcreate" - provides the data mining capability of Webview Report. Extracts data directly from report files and creates any type of file you would like such excel spreadsheets, xml documents etc. Since reformat reads any file and creates any other type of file based upon specifications, you can use it for other purposes. We at JBSoft Consulting personally use it to create Oracle loader files from reports or other data sources that require data scrubbing and reformatting, create application interfaces such as GL interfaces using table lookup features in reformat, etc. Rcreate simply walks you through question and answers to build reformat specifications. 


 
***************** End Of Article ****************** 
 
John Bemman posted Message 332 in Message Board 
 
Dated  : October 16, 2000 at 09:14:46 EST
Subject: Re: Report Distribution
 
JBSoft Consulting has developed and markets Webview Report and Webview Notify. Webview Report is priced at $5000.00 and provides Browser based report viewing and archive via CD. It integrates with any ERP system. Webview Notify delivers production reports via email directly from ERP applications. Webview Notify is priced at $1500.00 or $1000.00 if purchased with Webview report. Visit our online demo at www.jbsoftconsulting.com/webview.



: Does anyone have any experience using a report distribution tool and integrating it with PeopleSoft ?

: We would like to be able to schedule reports to run and then be viewed using this tool.  
: Also, we need to be able to provide different security levels within each of the reports.  For example, the CEO may be able to see the entire report, but a manager may only be able to see data that applies to a specific business unit/dept/region...

: Any recommendations and/or things to avoid would be appreciated.


 
***************** End Of Article ****************** 
 
Dave Nettekoven posted Message 333 in Message Board 
 
Dated  : October 20, 2000 at 08:38:09 EST
Subject: Electronic Signature on a Crystal Report Check
 
Can an electronic signature be put on a Crystal Report Check?  In sqr, through a sequence of characters like this "encode '<27>&l0O<27>(1Q<27>(s1p36.00h72.0v0s0b0T' into $SigFont" plus this "print $SigFont (,1)" and a special cartridge put into the printer allows the printing of an electronic signature on a check.  Does any capability like this exist with a Crystal check?  Can anyone tell me how to do it?

Thank you.
 
***************** End Of Article ****************** 
 
EDM posted Message 334 in Message Board 
 
Dated  : October 20, 2000 at 10:53:52 EST
Subject: Re: Electronic Signature on a Crystal Report Check
 
We are using PAY003/DDP003 to print checks/advices with 
electronic signature, micr, logos etc in a cartridge(simm)
we bought from HP. I know you can do this in Crystal although
I am not sure if Crystal will recognize all HP escape
sequences. You may also consider using downloaded soft fonts.

EDM.
 
***************** End Of Article ****************** 
 
Michael Brewington II posted Message 335 in Message Board 
 
Dated  : October 23, 2000 at 18:33:04 EST
Subject: Workflow dbagent / Maestro
 
1.  Does the workflow have major impact on the Process Scheduler server in a high use environment?  

2. Can the database agent be installed on a third part scheduler (ex Meastro) or must it be installed on the PS PrcSchd?

3. Can the database or message agent be installed on a Unix Process Schedule? 

Thanks in advance,

Michael

 
***************** End Of Article ****************** 
 
Lindsey Kordisch posted Message 336 in Message Board 
 
Dated  : October 24, 2000 at 13:48:42 EST
Subject: BCM in E &amp; G 7.0
 
My client would like to only budget check against the Approp budget, and forego budget checking for the Org budget type.

The only way to accomidate this request that I am aware of is to modify the Organization Budget Keys to 'No' for all chartfields. However, know 7.0 will not allow modification of these parameters without BCM modifications. 7.5 release notes suggest changing budget keys may work in 7.5 without BCM mods.

Please email if you have any comments or suggestions.
 
***************** End Of Article ****************** 
 
deepa posted Message 337 in Message Board 
 
Dated  : October 28, 2000 at 05:11:21 EST
Subject: Re: SQA Robot
 
: I need information regarding using SQA Robot to test PeopleSoft Version 7.5.  Anyone with experience utilizing this product?


 
***************** End Of Article ****************** 
 
John Bemman posted Message 338 in Message Board 
 
Dated  : October 31, 2000 at 18:06:32 EST
Subject: Re: JetForms or other forms creation products
 
Visit our website for a demo of Webview Report url: www.jbsoftconsulting.com/webview. Webview report includes our product "overlay" which allows creation of graphic froms in word and then merged with your data (i.e ap checks, statements, invoices, etc). It comes free with Webview Report or $400.00 when purchased separately

: Has anyone used Jetforms or other products to create output forms.  I would like to others that use these technologies.  Thanks. 



 
***************** End Of Article ****************** 
 
Dave Nettekoven posted Message 339 in Message Board 
 
Dated  : November 01, 2000 at 09:20:05 EST
Subject: Crystal Report print needed in protrait mode
 
A cyrstal report is being executed from PeopleCode and is printing in landscape mode.  The report needs to be printed in portrait mode.  I have updated the Printer Setup for the Crystal Report on the source tree to indicate portrait, but to no avail. The printer is setup for portrait also.
 
***************** End Of Article ****************** 
 
Marie posted Message 340 in Message Board 
 
Dated  : November 07, 2000 at 22:05:10 EST
Subject: PS MESSAGE AGENT
 
I am having problems using the PS Message Agent functionality in order to "add" a record into a PS panel. I am using a C++ program to call the psmsgapi call functions in order to set data into PS panels and then "process" the panels. Right now, we are getting an application error everytime that the C++ program is executed. Does anyone have any suggestions about the above?

Thanks!
 
***************** End Of Article ****************** 
 
Dave Nettekoven posted Message 341 in Message Board 
 
Dated  : November 08, 2000 at 14:05:42 EST
Subject: Duplex Printing of SQR Report SFBILLIV
 
An sqr being run from the Process Scheduler, SFBILLIV, is printing a report in duplex mode which I want to turn off.  My HP Laserjet printer setup is not set to duplex mode and nothing else I print comes out in duplex.  I have checked the process definition for the process and no special parameters are set.  I have searched the folder that stores all the sqrs for the word 
'duplex' and have found no sqrs or sqcs containing the word.
 
***************** End Of Article ****************** 
 
VP posted Message 342 in Message Board 
 
Dated  : November 08, 2000 at 18:19:53 EST
Subject: Re: Duplex Printing of SQR Report SFBILLIV
 
: An sqr being run from the Process Scheduler, SFBILLIV, is printing a report in duplex mode which I want to turn off.  My HP Laserjet printer setup is not set to duplex mode and nothing else I print comes out in duplex.  I have checked the process definition for the process and no special parameters are set.  I have searched the folder that stores all the sqrs for the word 
: 'duplex' and have found no sqrs or sqcs containing the word.

What is the platform for your Process Scheduler ?

It seems that you have checked the Printer itself.  Next check your Printer Setup off your Workstation.  That might be the culprit.  Also, try to print the report from a

If Process scheduler is PSUNX, have sysadm verify the Unix printer setup.

Good luck.
 
***************** End Of Article ****************** 
 
john hatch posted Message 343 in Message Board 
 
Dated  : November 15, 2000 at 12:26:51 EST
Subject: Re: Printing Chinese 
 
I work at a high school where Chinese is offered. Is a laser printer required to print Chinese documents?
 
***************** End Of Article ****************** 
 
chandrashekhar posted Message 344 in Message Board 
 
Dated  : November 20, 2000 at 04:28:01 EST
Subject: in sqr any list box or drop down items are there?
 
in sqr any list box or drop down items are there ?
if it is there please mail me info about that ASAP
 
***************** End Of Article ****************** 
 
Pieter Jaeken posted Message 345 in Message Board 
 
Dated  : November 21, 2000 at 05:33:25 EST
Subject: Re: Crystal Report print needed in protrait mode
 
You have to add a parameter in your process definition ""-ORIENTL". This should override your printer settings.
 
***************** End Of Article ****************** 
 
Michelle  HELP!!! URGENT! posted Message 346 in Message Board 
 
Dated  : November 21, 2000 at 23:14:34 EST
Subject: can you pass VB dao recordset to Crystal Reports?????
 
I don't want my Crystal report to access my database field directly.  Nor do I want to create a temp database.  Can you pass a dao recordset to Crystal Reports?  I am using version 5 for both.  Alternatively, can you pass a global variable from my VB program (which is not a field) to Crystal Reports?
 
***************** End Of Article ****************** 
 
Michelle posted Message 347 in Message Board 
 
Dated  : November 21, 2000 at 23:19:10 EST
Subject: OR, can you bind a Crystal Report to a form control i.e. a text box?
 
will this work?
 
***************** End Of Article ****************** 
 
Zack Hu posted Message 348 in Message Board 
 
Dated  : November 22, 2000 at 08:51:28 EST
Subject: Re: PS MESSAGE AGENT
 
Set the message agent tracing in the appserv config file.
that should help you debug.



: I am having problems using the PS Message Agent functionality in order to "add" a record into a PS panel. I am using a C++ program to call the psmsgapi call functions in order to set data into PS panels and then "process" the panels. Right now, we are getting an application error everytime that the C++ program is executed. Does anyone have any suggestions about the above?

: Thanks!


 
***************** End Of Article ****************** 
 
Zack Hu posted Message 349 in Message Board 
 
Dated  : November 22, 2000 at 08:54:17 EST
Subject: Re: APIs in PS8.0
 
Message agent is not going away.
So to answer you question, the api is the same.
However, in addition to message agent, there is 
a method of integration called component interface.



: I wanted to know how different are the APIs from ver 7.0x to  ver 8.0
: Thanks,
: Kedar


 
***************** End Of Article ****************** 
 
Testas posted Message 350 in Message Board 
 
Dated  : November 27, 2000 at 07:47:30 EST
Subject: Re: datamart
 
: : I need to know which are the datamarts used
: : to generate p/l reports. our need is such that the information to
: : create the PL report comes from various sources peoplesoft
: : excel and other legacy system. we want an automated solution



 
***************** End Of Article ****************** 
 
mwhalen posted Message 351 in Message Board 
 
Dated  : November 28, 2000 at 10:18:54 EST
Subject: Crystal Reports reading more than one record from VB
 
I have it so that in my VB program, my recordset is returning data to my list box.  It could be 4 items in my list box or it could be 6 or 10 or whatever.  I never know.  It's dependent on what options the user selects.  I have it so that my report is reading the first recordset record.  But how do I get it to reference subsequent records in my recordset and thus have subsequent pages showing in my Crystal Report.
 
***************** End Of Article ****************** 
 
rune andersson posted Message 352 in Message Board 
 
Dated  : November 28, 2000 at 12:33:30 EST
Subject: Re: msjter32.dll problem
 
: : hi,i have this problem when startibg up my pc with win98, a window displaying "error launching msjter32.dll" due to not enoth
: : memory?
: : could anyone help pls?
: : thanks


 
***************** End Of Article ****************** 
 
Phillip Bue posted Message 353 in Message Board 
 
Dated  : November 28, 2000 at 13:08:26 EST
Subject: Greetings E-Business Guru's
 
Greetings E-Business Guru,

My name is Phillip Bue and I am a Sr. Account Mgr/Recruiter for Staff-Tech Inc. (www.staff-tech.net) representing a corporate client who's first commitment is to deliver high quality service to our clients by providing a level of service distinguished by our responsiveness, understanding of business needs, technical competence, productivity, and professionalism. Secondly, our people are the basis of our success; therefore we strive to help them realize their fullest potential. 

Background

Founded:
1984 
What distinguish us are the people on our team. We recruit talented software consultants and technical professionals at the top of their fields, and we offer them the kinds of training and challenges that enable us to provide our clients with a team tailor-made for each project.

Most importantly, a set of time-proven methodologies and tools drives our "smart solutions" approach. We begin with a detailed analysis of the client's goals and requirements in order to be sure the solution we propose will meet our client's expectations. From there, we assemble a team with the right skill set for the project, design and build a solution, test it thoroughly, and deliver the results -- on time and within budget.

Finally, knowledge transfer is a critical component of our work. We are committed to working closely with our client's staff until they can confidently step in and assume full ownership of the new system. At the same time, we value the long-term relationships we've established with our clients, and we're always prepared to provide any post-production services a client may require.

We're pleased to say that our commitment to our clients' goals has earned us superior client satisfaction; indeed, we can think of no better testimony to the strength of our approach.

There's no doubt about it &#8211; e-Business is changing the way we do business in truly fundamental ways. As companies in every industry race to leverage the power of the Internet, the challenge they all face is to successfully integrate their back office systems with new Web-based strategies and applications. 
We're experts in building the technical architecture that large and growing companies must have in order to remain agile and competitive in today's markets. And we've partnered with the leading suppliers of enterprise software and e-Business solutions -- giving us the tools and the experience to implement the systems that will give our clients the competitive edge they seek. 



Why I have Contacted You

I have been hired to identify potential candidates whose background and experience would be exemplary for this position. If you are open to researching this excellent career opportunity, then please contact me phillip@staff-tech.net or916-728-6504 for the initial and subsequent interviews.

Location - 
Corporate headquarters: Fremont, CA, Regional offices in New Jersey and Atlanta 
100% travel commitment required working from your home base near any major airport. Temporary relocation (6 mo - 1 yr) to the San Francisco Bay Area may be required depending on skill set and/or seniority.

If you're looking for an exciting and challenging opportunity working with the industries best and brightest - look no further! 
As they continued to work alongside our consultants, our founders created and shared a generous group of policies and benefits to achieve the highest motivation and the lowest turnover rate:  
Medical Plan Options 
Dental Plan Options 
Flexible Spending Accounts 
Paid Time Off 
Paid Company Holidays 
Discretionary Profit Sharing 
Contributions to 401(k) 
Extra Effort Bonuses 
Performance Rewards 
Travel Bonuses 
Key Contributor Program 
Enhanced Career Tracks 
 Tuition Assistance 
Membership and Subscription Allowances 
In-House and Partner Trainings 
Quarterly Staff Get-togethers 
Company-Wide Exotic Getaways 
Pre-IPO Stock Equity 
Credit Union Membership 
Direct Deposit 
Nationwide Voicemail and E-Mail 
Employee Referral Bonuses 
 






Open Positions &#8211;

Java Developer
Join our team of e-Business and business application developers if you're one of the BEST and you have the desire to represent the leader in e-Business and enterprise solution integration services.

Skill set: Working knowledge of Java; Pluses are XML, SQL, VB, HTML, and C++. Working knowledge of one or more of the following middleware: Corba, DCOM, MTS, RMI, and client-server database systems like Oracle or Sybase; working knowledge of server side technologies like ASP, JSP, IIS, Application Server; working knowledge of Windows operating system and TCP/IP networking protocol.
Education:   4 year degree in computer science, business, or related experience + 4 year degree in other related major.

E-Business Project Manager
If you have grown your career by caring about quality and have the desire to represent the leader in e-Business and enterprise solution integration services, join our team! You will manage project teams and participate in development and implementations of e-Business solutions for our stellar clients. 
100% travel commitment required. Temporary relocation (6 mo - 1 yr) to the San Francisco Bay Area may be required depending on skill set. 

Skill set: Technical expertise of one or more of the following languages: Java, XML, VB, HTML, C++, SQL; Technical expertise of one or more of the following middleware: Corba, DCOM, MTS, RMI, and client-server database systems like Oracle or Sybase; Technical expertise of one or more of server side technologies like ASP, JSP, IIS, Application Server; working knowledge of Windows operating system and TCPIP networking protocol. 
Education:  4 year degree in computer science, business, or related experience + 4 year degree in other related major. 

J.D. Edwards OneWorld Developer
Bring your senior-level J.D. Edwards development skills and become part of our winning team, assisting clients throughout the U.S. by customizing and implementing OneWorld. We are looking for senior-level developers and Project Managers.
100% travel commitment required. Relocation is not required if located near a major airport.

Skill set: Senior-level knowledge of OneWorld development tools or CNC functions also some functional knowledge of financials, distribution or manufacturing modules.

Education: 4 year degree in computer science, business, or related experience + 4 year degree in other related major

J.D. Edwards World Developer
If you have senior-level World development skills, great communication skills, and experience in client-server front-end tools like Visual Basic or PowerBuilder - come join our highly talented JDE team implementing client solutions throughout the U.S. You will be trained on OneWorld in order to continue to grow your skills and value in our organization. 
100% travel commitment required. Relocation is not required if located near a major airport. 

Skill set: Senior-level knowledge of JDE's World product (RPG on AS/400); some functional knowledge of financials, distribution or manufacturing modules; SQL; Visual Basic or PowerBuilder. 

Education: 4 year degree in Computer Science, Business, or related experience + 4 year degree in other related major

J.D. Edwards Implementer
Provide your functional consulting talent on OneWorld implementation projects. We are looking for senior candidates and Project Managers only. 
100% travel commitment required. Relocation is not required if located near a major airport.

Skill set: Two or more full life-cycle implementations of Financials, Distribution, and/or Manufacturing. This experience must be hands-on, not managing, the set-up of the software including AAIs, etc. 

Education: 4-year degree (related field preferred) or equivalent work experience. 

JDE Project Manager
If you have grown your career by caring about quality and have the desire to represent the leader in e-Business and enterprise solution integration services, join our team! You will manage project teams and participate in development and implementations of enterprise solutions for our Fortune 1000 clients. 
100% travel commitment required. Relocation is not required if located near a major airport. 

Skill set: Knowledge of programming logic, knowledge of JDE technical tool set and its capabilities and limitations, knowledge of operating system and database capabilities and limitations, functional knowledge of at least one full vertical 

Education: 4 year degree in related field or 10 years of relevant experience in lieu of degree. 

PeopleSoft Developer
Bring your senior-level PeopleSoft technical skills and become a part of our winning team, assisting clients throughout the U.S. by customizing and implementing the PeopleSoft suite. We are looking for senior-level developers and Project Managers.
100% travel commitment required. Relocation is not required if located near a major airport.

Skill set: Senior-level knowledge of PeopleSoft development tools. 2+ full life-cycle implementations, functional knowledge and ability to present self at client in pre-sales opportunities is also required.

Education: 4 year degree in computer science, business, or related experience + 4 year degree in other related major

PeopleSoft Applications Consultant
Want to be a true Project Manager but don't have the technical development skills? If you've got the functional application side of HRMS or Financials down cold and would like to grow your technical development skills, we've got a place for you! We're looking for senior-level applications candidates that want to broaden their skills and grow their career with the leader in e-Business and enterprise solution integration services. 
100% travel commitment required. Relocation is not required if located near a major airport.

Skill set: Senior to Manager level on PeopleSoft HRMS modules or Manager level on PeopleSoft Financials. Must have strong interest and aptitude in cross training on technical development tools and 3+ years of PeopleSoft experience required. 

Education: 4 year degree in related field or 10 years of relevant experience in lieu of degree. 

PeopleSoft Project Manager
If you have grown your career by caring about quality and have the desire to represent the leader in e-Business and enterprise solution integration services, join our team! You will manage project teams and participate in development and implementations of enterprise solutions for our Fortune 1000 clients. 
100% travel commitment required. Relocation is not required if located near a major airport. 

Skill set: Knowledge of PeopleSoft technical tool set capabilities and limitations, knowledge of programming logic, knowledge of system and application integration methodologies, knowledge of file transfer methodologies, PeopleTools, PeopleCode, SQR, PS Query, Tree Manager, SQL, knowledge of OS, knowledge of specific database, functional knowledge of PeopleSoft application suite. 

Education: 4 year degree in related field or 10 years of relevant experience in lieu of degree. 



E-Business Technologist
We're looking for a leader, strategist and technologist who can help steer growth, make presentations, write white papers, and light a fire for our clients. You'll help guide and direct the technological development of Client's e-Business tools and applications by researching and evaluating current trends in e-Business and answering the question: What's hot and hype vs. what's hot and real? Relocation to San Francisco Bay Area required. 
Skill set: Deep knowledge of systems development and delivery methodologies as it relates to internet applications; background in business application development using client/server tools, RDBMS and object-oriented programming; excellent communication, interpersonal and team-building skills.

Education: BA/BS in CS, IS or Business is required; Master's degree is a plus.



 
***************** End Of Article ****************** 
 
M Stephanson posted Message 354 in Message Board 
 
Dated  : December 01, 2000 at 16:18:25 EST
Subject: Re: Software that Scans data into PeopleSoft
 
: Does anyone know of any 3rd party software package that scans data into PeopleSoft.  The main requirement is to scan in cvs.  I am sure that there is some software called RaceTrack or something similar but have had problems finding any information about it.


There are a number of ways to integrate document imaging with PeopleSoft. You can use the software and services of a large document imaging firms, such as FileNet and Xerox.  Using a large national firm will be expensive because of large overhead and the license charge for each PC the imaging sofware is loaded on.

The other alternative is to hire a consulting firm sepecializing in imaging applications to design and program the interface for your application.  This will be much less expensive.

An excellent application is with PeopleSoft's Accounts Payable module.  Significant productivity gains can be realized. Staff reductions of 50% are possible.  At $30,000 per year for an Accounts Payable clerk as well as fewer supervisors will net large dollar savings. Processing 2,500 invoices with PeopleSoft a day with a staff of around 40 people (including supervision) is attainable. 

Imaging technology has advanced to where this can be done successfully with off the shelf software.  For example, an image viewer, to display scanned invoices, can be custom built using Visual Basic and an ActiveX imaging software control. Features and functions can be programmed that are equal to viewers from large imaging companies.  For example rotating or magnifying the image.  Take a look at the functions and featrues of the Wang Viewer provided with Micorsoft Windows.

The PeopleSoft programming language, PeopleCode, "talks" to the VB image display program using the "object" related PeopleCode instructions. It's very technical, but easily accomplished.

It is fairly easy to build a dedicated imaging server.  The server is built to optimize the through-put of the images from the scanner to the disk drive and back to the work station for processing.

Additionally, a Optical Disk unit is connected to the imaging server for long term storage of images. The response time is 10 to 15 seconds for images on the Optical Disk. They are commonly referred to as a "Juke Box".  The platters can hold up to 5.2 G of images. In the not too distant future, 10G juke boxes will be available. Juke boxes are available to hold 10 to 500 platters.

Scanners are easily hooked up to a PC.  Images are transferred from the scanner to the PC via the TWAIN interface.  Specialzed PCI cards designed for high speed scanners (70+ pages per minute) can also be used.  These cards will perform imaging functions, such as de-speckeling, rotating the image so it not skewed to the left/right,  removing the black border around the image, etc.  Check out the Kofax web site.

Write me at MarvinS611@AOL.com if you would like more information.


 
***************** End Of Article ****************** 
 
Bryan Hall posted Message 355 in Message Board 
 
Dated  : December 04, 2000 at 18:12:08 EST
Subject: re:RightFAX 6.0 with PeopleSoft
 
I am working for a client that has RightFAX 6.0 and they want to use the RightFAX instead of the ObjectFax. Is there anyone who has previously implemented RightFAX 6.0 with PeopleSoft Purchasing 7.5. I need step by step process on how to implement RightFAX with PeopleSoft.

I would really appreciate the help ASAP.

Thanks

Bryan 

 
***************** End Of Article ****************** 
 
michelle - help! posted Message 356 in Message Board 
 
Dated  : December 06, 2000 at 22:43:18 EST
Subject: if then else statement in Crystal Report, making it test all fields...
 
this is what I want to do using Crystal Version 5 and VB Enterprise 5

If variable 1 (field) from table A is found anywhere in table B then print variable 1 otherwise print variable 1(field) in table B 
Then go on to variable 2 from table A.  If it is found in table B then print variable 2 from table A otherwise table B-variable 2 and so on going through all the fields.  Is there a way to loop through the fields in this version of Crystal?

It's not enough to use the if then else statement - it just seems to examine the first record.  Thanks!

 
***************** End Of Article ****************** 
 
Harry Anthony posted Message 357 in Message Board 
 
Dated  : December 13, 2000 at 23:56:46 EST
Subject: Re: PeopleTools and SQR
 
: pl. send me your email ID i will forward my C.V.
: here also  i am sending C.V.

: 
: CURRICULUM VITAE
: S.L.S.N.V.V.S.SUDHAKAR
: FLAT# 103
: SREE APARTMNTS
: Srinivasa Colony(West)
: Hyderabad
: A.P.,
: INDIA.
: Phone : +91(40) 3319358,3540739 (Off)
:                +91(40)3738007®

: E-mail : lokeshsanku@hotmail.com

: Professional Summary	:Seeking for a good opportunuty by having  three years  Of experience in Software development and , Functional Experience including hiring ativity for a MNC. Well versed client-server environment and ERP Systems.

: Education	: Bachelors Degree in Engineering From Andhra University, 
:                   Vishakapatnam (1996)
: Skills Inventory:
:                	GUI			:  Developer2000(Developed Systems)
:               	Operating Systems  	:  M S-DOS , Windows ( 3.x, 95,NT 								      4.0) 
:  		Languages 		: C , Visual Basic 5.0 
: 		OOPS          		:  C++, JAVA	
:                	RDBMS                  	: Oracle 7.x,MS-Access
:                	Hardware      		: Pentium
: 		ERP                     : People Soft  7.5 (HRMS  Module)
:                 WEB Technologies        : HTML,VBSCRIPT,ASP
: 		
: Professional Experience:
: Working as Programmer Analyst with CODELINKS DATA SERVICES PVT. LTD from Oct'99.
: Worked as Programmer Analyst in CODELINKS DATA SERVICES PVT. LTD  As a 
: Peoplesoft Consultant on behalf of CAREER PROFILES from June'99.
: Worked as a HR Executive in CAREER PROFILES from Feb'99 to May'99.
: Worked as Software Engineer in Pragma Technical Solutions  Ltd from Sep'96 to Feb'99.

: Projects Summary : 

: #1 Project:
:    Project Name        :   SQR Reports Development
:   Client               :   Conseco Inc , USA
:   Role                 :   Leading the team,Analysis,
:                            Testing and Documentation

: Project Description :

: 	This project is basically to generate SQR reports as per 
:  the requirement of the Client in the HR module.This project has
:  started on 20th of June '99 and the target date of completion is
:  December 31st '99.  
:  The reports generated in this project are categorized into three 
:  types as below, 

: A. HR day to day data related reports, some of them are as follows,
:         PERTERNA.SQR   - Terminations processed name wise
:  	PERECLIS .SQR  - Emergency Contact List
:  	PER401KH .SQR  - 401k New Hire Listing etc.	
:         B1068.SQR      - Overtime report.
:     
: B. Database comparison reports, which compares the data present in
:    two similar databases. These reports are generalised reports,
:    which should work for any table. some of them are as follows,

:         GENCOMP1&2.SQR  - Data present in first database and not present
:                           in another database.
:         GENCOMP3,4,5.SQR - These are to compare Key,Xlat,Non xlat fields 
:                            data present in both the databases.
: C. Interface reports. The purpose of these reports is to generate flat 
:    files by fetching data from HRsystem database, and the flat files
:    generated are used to import data into third party tools.Another type
:    of reports are to insert data into Hr database by reading from flat 
:    files generated by the third party tools.Some of them are as below,

:         CIGNA.SQR   -  Outgoing from HRsystem & in coming to CIGNA system
:         TPA.SQR     -  Outgoing from HRsystem & in coming to TPA system
:         BVUPDATE.SQR-  Outgoing from BVsystem & in coming to HRsystem

: #2 Project: Hiring Activity

: Client  : CODELINKS DATA SERVICES PVT LTD
: Team Size : 3
: Duration  : Feb'99  to May'99

: Description:  We Recruited Employees belonging to various areas for a multi
: national company.
: It contains three phases
: 1)Resume Collection and Screening: We Collected Resumes from the principal
:   company and screened those on the basis of Skill set and experience.

: 2) Conducting Interveiws: We arrranged the interviews for all qualified 
:    candidates in each area depends on requirment of the principal company.

: 3) Taking reference checks and feed back from company: After conducting 
:    the interview in our company we send to principal company after all
:    completing all necessary checks and we will take the feed back from
:    the pricipal company about each and every candidate.

: 
: #3) Project 

: Project title 		:       Marketing Plan Automation
: Client 			:  	KayJay Industries Ltd , Hyderabad
: Duration 		:   	From Jan'98 to Apr'98
: Team size               :   	Eight
: Software environment    :   	Visual Basic 5.0, MS-SQL Server 6.5 ,Windows 				NT 4.0

: Role                    :   	complete project Front -end design,coding , 
: 				interactionWith team members and 
: 				contributing ideas .

: This is to automate the Marketing functions of a Pharmaceutical company
:  operating its business in South India. This Projects mainly categorized 
: into several modules namely maintenance of code tables, Customer data, 
: Stockiest ,Super-stockiest ,Customer Order, Activity of business development
:  Manager and Business development Executive,Product information, Market 
: intelligence Sales, Advertising and Promotion, Market plan,Writing Context 
: sensitive and Content Help, Generating Various types of reports based on 
: information provided by various levels of its employees and all types of 
: customers.

: The Project captures and updates customer, product, fields sales person's 
: data, customer order, sales-region & state wise, Advertising and promotion
: using SQL -Server as backend and Visual Basic 5.0 as front -end 
: Features employed: Remote Data Objects (RDO), DDE, OLE, developed Active X
:  control, Farpoint Spread sheet control , SS Tab, Crystal Reports, Help 
: Compiler Workshop.

: #4) Project:
: Project title 		: Automation of Departmental  Stores
: Client 			: Lakshmi supermarket, Hyderabad     
: Duration 		: From Jun'97 to Nov'97
: Team size		: Three 
: Software environment	: Visual Basic 5.0, MS-Access2.0, and Windows NT 4.0
: Role 			: As Programmer Complete project Front -end design,
: 			  coding,Interaction with team members and 
:                           contributing ideas.
: This is a Generalized package of Complete  Sales and Inventory can keep 
: track of  various day to day sales activity like checking inventory ,billing
:  and generating various reports meeting order requirements ,order placements,
:  checking financial status of the company at any time or for a given time 
: range etc., The  Project Mainly  Consists of the following five modules 
: namely  Customer Information, Billing, Check Order, Inventory, Generation of
:  Various Reports- Customer Information,,item code, item description the
:  above information is added to the database ,the Billing deals with  price 
: billing that is given to the customer who purchase the commodities from the
:   stores.  The information is automatically gets in transaction with the
:  database to query on to get the inventory status. The Inventory module 
: keeps account of input and output of the stores commodities. The report 
: module consists of daily, weekly, monthly, yearly information of sales and 
: stock particulars.

: #5) Project: 
: Project title 		: Automation of Electrical Power Reading
: Client 			: ECE Industries ,Hyderabad     
: Duration 		: From  Jan'97 to May'97
: Team size		: Three
: Software environment	: Tubo C,Windows 95
: Role 			: As Programmer  in design,  coding , andinteraction
:                           with team members and contributing ideas.
: This is a Generalized package consisting of coplete automation to read 
: Electrical Meter Reading From any Electric meter. There are Two steps 
: invoved in this process.  First Read meter reading from meter to H.H.U. ,
: then From H.H.U. to Base Computer.  While Accessing data from meter to H.H.U.
:  or H.H.U. to Computer some protocals are there. So in this project we design
:  to access the data from H.H.U. to Computer Depends on Existing Protocals.

: 
: CASE STUDIES IN ERP:
: CASE  STUDY - 1
: Feasibility Study of Implementing ERP  In Banking Industry
: A Leading Co-Operative Bank having branches all over state of Andhra Pradesh is in the process of large-scale computerization of its operations.  This bank has got about 9 branches which are reporting to its head office at Hyderabad.  Presently all the operations of the bank are being carried out manually.  The team consists of 5 members, who are highly experienced in the software field, has undertaken a detailed case study based on the client's requirement with regard to information, Data security and integrity.  The conclusion that emerges out of the above case study that ERP especially People Soft is highly suitable and feasible for this particular Business concern, though extensive customization and design is required.  A sample application comprising of panels like Bank master, Transaction master, Recurring Deposit master, F.D. master and reports like transaction entry, customer wise and Fixed deposit and R.D. reports. Extensive validations are carried out using people code.

: CASE STUDY - 2
: Student Administration
: A Case study was conducted for one of the most popular Junior College in the twin cities with a team comprising of 5 members.
: This Junior College has got student strength of about 5,000 students.  Presently they are maintaining their records in FoxPro. It is found that the reports & maintenance of student Data is highly unorganized, unstructured and inadequate with this system.  Based on the extensive case study and with many rounds of discussions with the management of the college, it has been found that an ERP like People Soft though a little bit expensive can go a long way in the proper management, reporting and maintenance of student Data.  The management is convinced with the Case Study and is on the lookout for a suitable software package.  A sample student administration was built comprising of panels like student master, student details, course details, enrollment details, etc.  Extensive validations were performed using people code for this application.  The Client is satisfied with the sample application in all respects.

: CASE STUDY - 3
: Student Data
: The Project mainly aims at maintaining records for course sessions available, course details, available instructors lists, no. of students enrolled, students joined and their evaluation details. This also maintains customer details. It consists of 8 Record Definitions and 6 Panels incorporating Sub-panels and Secondary panels at the required stages. Writing People code for generation of student Ids, Course codes and Instructor Ids.  Assigning particular Instructors for student Ids etc., changing any particular data through Mass Change and generating final passed out student records.

: CASE STUDY - 4
: Demographic Analysis For India
: The study is developed using People Soft 6.0 to produce complete information about State wise population, area of land, area of cultivated land, area of forests and the basic needs like drinking water availability, sanitation, hospitals etc. The case study utilizes Data Designer, scroll level settings to retrieve master details and effective dated functions, Panel Designer, Menu Designer, Operator Security and People Code. Finally Business process map is developed using activity map, step map and message agent.
:    

: Personal Details		:		
: Date of Birth			: 21st Oct 1975
: Marital Status		        : Unmarried
: Passport Details		:
: Passport No.                    : A543943 
: Place of issue			: Vishakapatnam
: Date of issue			: 1 June 1998
: Date of Expiry		        : 31 May 2008

: : I have a permanent opening in Tampa, FL for a PeopleSoft Developer with experience in PeopleTools and SQR. If you can refer someone we will pay you $1200.00 if they are hired.
: : Thank You


 
***************** End Of Article ****************** 
 
ranbir kalra posted Message 358 in Message Board 
 
Dated  : December 20, 2000 at 15:43:16 EST
Subject: Re: SQA Robot
 
: I need information as to how to use SQA please do advice me the name of the book ASAp


 
***************** End Of Article ****************** 
 
Yuri  posted Message 359 in Message Board 
 
Dated  : December 21, 2000 at 16:13:29 EST
Subject: URGENT:  Crystal and effective-dated tables
 
How do I do the following in Seagate Crystal Reports (note: SQL query not created in PS/Query, but in Seagate Designer product outside of PeopleSoft):

1) Code EFFDT subselect for effective-dated tables to get MAX(EFFDT) <= SYSDATE
2) Code UNION for outer join on effective-dated tables

Is there something similar to PS/Query Expressions???

Very urgent!!!  We're on Oracle RDBMS.

Thanks in advance!
 
***************** End Of Article ****************** 
 
Hans Ostermann posted Message 360 in Message Board 
 
Dated  : December 26, 2000 at 03:20:09 EST
Subject: Printing SQR and NT print queues
 
When LPT1 is mapped to a NT print queue server, and printing 2 simultaneous SQR reports. The resulting output is messed up.
The first page will be from the first report, then subsequent pages are from the second, then the first one in the wrong alignment (printed in portrait instead of landscape)

This did not happen when we mapped LPT1 to a Netware print queue.

We're in the process of phasing out Netware in favor of NT, and we're stuck here.

any ideas?

 
***************** End Of Article ****************** 
 
Prasad posted Message 361 in Message Board 
 
Dated  : December 26, 2000 at 06:49:38 EST
Subject: Please solve the problem !
 


 Hi,

    I have inserted one formula field in the report.
That field is getting the value at run time. If the string assigned to formula field contains apostrophy "'" ( eg " D'souza ") then it is giving error as ERROR IN FORMULA.

    Please help me in this regard.

Prasad

 
***************** End Of Article ****************** 
 
Joe Brunetti posted Message 362 in Message Board 
 
Dated  : December 28, 2000 at 13:41:44 EST
Subject: Third Party Check Printing Solution?
 
Subject: Third Party Check Printing Solution?

We are implementing PS 7.5 A/P, HRMS, and Payroll. We are looking for a third party hardware/software solution for printing our vendor and payroll checks, 1099&#8217;s and W-2&#8217;s. Platform is NT4, with Sequel server DB, NT workstations.

What vendors can you recommend?



 
***************** End Of Article ****************** 
 
Mohan posted Message 363 in Message Board 
 
Dated  : January 09, 2001 at 13:00:44 EST
Subject: SQR Errors
 
Hi ,

Could you please tell me why these arrors accur while running a sqr?
1)    'Max Extents Error............'
2)    'Snapshot too old......'

Thanks,
Mohan
 
***************** End Of Article ****************** 
 
Tom Rosencranz posted Message 364 in Message Board 
 
Dated  : January 09, 2001 at 17:34:15 EST
Subject: Re: Configuration Management
 
: Has anyone got a recommendation for a Configuration Management solution specific to the Peoplesoft development environment?

: Any suggestions would be a appreciated. 

I am in the same boat!!  It doesn't appear that you have had any responses to your question.  Shucks.
We have attempted using Continuus without satisfaction.  Files are so large that it takes forever to migrate.

What have you tried?



 
***************** End Of Article ****************** 
 
elvis posted Message 365 in Message Board 
 
Dated  : January 10, 2001 at 13:56:22 EST
Subject: Re: SQR Errors
 
Mohan,

You should ask your DBA this question. This looks like an Oracle
question. This can happen if a transaction is used by a user and
another user is updating the same transaction where the rollback
segment of the first user has been changed by the next user.

If the transaction is serialized, this error should not happen.

elv


 
***************** End Of Article ****************** 
 
Tom posted Message 366 in Message Board 
 
Dated  : January 10, 2001 at 18:12:26 EST
Subject: Spell Check in peoplesoft?
 
Users want to spell check the text they enter on the panel. Is there any spell check product available on the market to integrate with peoplesoft v7.x? Users don't want to copy text to word and spell check it.

Any help is greatly appreciated.
 
***************** End Of Article ****************** 
 
Kiran posted Message 367 in Message Board 
 
Dated  : January 12, 2001 at 01:29:07 EST
Subject: Re: Oracle Hints (Query)
 
: An architecture change has caused a significant drop in our SQL/RPT response time.  PeopleSoft has suggested that some queries might benefit from the addition of an Oracle hint (rule-based).these hints?  What makes one query a better candidate than another?  Is there documentation providing this information on the web?

: Does anyone know what criteria we should use for applying 

: Thanks,

: Kelly


 
***************** End Of Article ****************** 
 
Par posted Message 368 in Message Board 
 
Dated  : January 18, 2001 at 17:39:50 EST
Subject: Help!! - Mailing statements - through email
 
Hi,
we want to mail our billing statement through email. I have few clarifications.

1.What is the standard format for sending invoice through email.
.pdf or word document or something else?

2. our Invoice has company logo/with statement details inside multiple column frames. Is there anyway to use pre-formated 
word document (preformated logo/frames) and our data to merge together?. What is the procedure?.

Any help in this regard greatly appreciated.

Thanks.
 
***************** End Of Article ****************** 
 
findpawan@yahoo.com posted Message 369 in Message Board 
 
Dated  : January 20, 2001 at 01:22:32 EST
Subject: Re: Crystal 7.0 enabling ASP wen reports(Active X viewer)
 
: I loaded Crystal Reports 7.0 w/ the ASP Reports component on an Windows NT IIS4.0 server. If I type in the web address to the asp page using the browser on the server, the report loads with an active x interface (pERFECT:) But when I go to a client machine and type in the address it loads a gray page with a missing image where the active x reports should be.. For some reason the viewer is not making it to the client machine. The client machine is running IE 5.0. Any help would be greatly appreciated.. Thanks..


 
***************** End Of Article ****************** 
 
Sudhir posted Message 370 in Message Board 
 
Dated  : January 20, 2001 at 09:07:24 EST
Subject: Adapters based on HRMS Demo
 
Hi All
The following query is in regard to the Peoplesoft HRMS Demo 7.5 - Single User Version. Please Help.

1.We are building Messaging Agents in Java to transport data from Peoplesoft (PS) database to some other ERP. PS has some pre-defined plug-ins given in the People Tools Integration part. Two of them are:
  MsgConnect(Version, IP,...)
  MsgStartMessage(MessageDefn, ActivityNAme,...)
  Now the problem we are facing here is 
    1. What IP should be given as we are using the HRMS Demo Version 7.5 as the base. The Demo is SIngle-User, so physically  everything i.e. the Database Server, Application Seriver n the client are on the same machine.
    2. In the second Plug-in, what is the MessageDefn? Is it the name of the Java Adapters developed or someting else?

2) What are the ODBC drivers that should be mentioned for this database connectivity? Is it same as the machine on which the Demo is installed, or any port number or something else?

3)When we are extracting data from the PS database, is it to be extracted from the Panels  or Background tables?

4)How can data be extracted / fed  from / to PS version 7 n below. Apparently there seems to no backward compatibility.

Please reply ASAP.

Thnx n Rgds
Sudhir Nilekar

 
***************** End Of Article ****************** 
 
Ramya Sundaresan posted Message 371 in Message Board 
 
Dated  : January 22, 2001 at 00:18:11 EST
Subject: Regarding message agent  &amp; Open ODBC
 
hi all,

While writing a message agent or open odbc query, should any servers run at the background. If so, what are the servers.

 
***************** End Of Article ****************** 
 
Ramya Sundaresan posted Message 372 in Message Board 
 
Dated  : January 22, 2001 at 02:25:54 EST
Subject: Any server for Open ODBC
 
hi all,

Can anyone tell if any server is required for running open ODBC driver or Open Query API.

ramya
 
***************** End Of Article ****************** 
 
amjad ali chaudhry posted Message 373 in Message Board 
 
Dated  : January 23, 2001 at 00:37:53 EST
Subject: Re: SQA Robot
 
: : I need information regarding using SQA Robot to test PeopleSoft Version 7.5.  Anyone with experience utilizing this product?


 
***************** End Of Article ****************** 
 
amjad ali chaudhry posted Message 374 in Message Board 
 
Dated  : January 23, 2001 at 00:39:02 EST
Subject: Re: SQA Robot
 
: : I need information as to how to use SQA please do advice me the name of the book ASAp


 
***************** End Of Article ****************** 
 
amjad ali chaudhry posted Message 375 in Message Board 
 
Dated  : January 23, 2001 at 00:39:55 EST
Subject: Re: SQA Robot
 
: Hello,

: I am Shakeel working in OCTON TECHNOLOGIES LTD. as QSE, we need to automise the Web site testing, we are in the business of B2B,B2C sites and have clients in US ,Germany , Australia.

: You are requested to send me the detail about the testing tool , SQA Robot , also please furnish the pre requetee required to operate this tools, as I am from non software background.  


 
***************** End Of Article ****************** 
 
Shailendra posted Message 376 in Message Board 
 
Dated  : January 24, 2001 at 05:07:49 EST
Subject: Re: SQA Robot
 
: I need information regarding using SQA Robot to test PeopleSoft Version 7.5.  Anyone with experience utilizing this product?


 
***************** End Of Article ****************** 
 
Julie posted Message 377 in Message Board 
 
Dated  : January 24, 2001 at 11:53:02 EST
Subject: OTG Application Xtender - Imaging
 
Is anyone out there developed a way for PeopleSoft to access OTG's Application Xtender (AZ) ? I know of another software that communicates with AX thru DDE. Can PeopleSoft use DDE or is there another communication method I can use ?
 
***************** End Of Article ****************** 
 
David posted Message 378 in Message Board 
 
Dated  : January 24, 2001 at 21:07:46 EST
Subject: Which web server
 
I'm preparing for an HRMS 8 install. Any thoughts on which web server to use. We use NT4 and Sql Server 7. We have a web administrator to support IIS. Should we use IIS with PeopleSoft and Web Logic for servlets or just use Web Logic or just use Apache. Any thoughts? Thanks.
 
***************** End Of Article ****************** 
 
Alison Atterbury posted Message 379 in Message Board 
 
Dated  : January 25, 2001 at 09:41:44 EST
Subject: SQL Packages other than RAPID SQL
 
What other products are there out there to run SQL, other than RAPID SQL?

What does anyone recommend?
 
***************** End Of Article ****************** 
 
padmaja posted Message 380 in Message Board 
 
Dated  : January 25, 2001 at 14:18:58 EST
Subject: Re: SQA Robot
 
: I need information regarding using SQA Robot to test PeopleSoft Version 7.5.  Anyone with experience utilizing this product?


 
***************** End Of Article ****************** 
 
Karen posted Message 381 in Message Board 
 
Dated  : January 29, 2001 at 11:43:47 EST
Subject: SQR Viewer
 
Where can I find a good SQR viewer?  
 
***************** End Of Article ****************** 
 
Steve Campbell posted Message 382 in Message Board 
 
Dated  : January 30, 2001 at 11:11:23 EST
Subject: Re: COGNOS Impromptu
 
: Does anyone have any experience of using the web based COGNOS tool Impromptu for reporting on HRMS 7.50 under AIX and Oracle.
: I am particularly interested in how the product interfaces with the application database.

: regards

: Nick


 
***************** End Of Article ****************** 
 
Steve Campbell posted Message 383 in Message Board 
 
Dated  : January 30, 2001 at 11:24:20 EST
Subject: Re: COGNOS Impromptu
 
You'll need:
A PC with 32bit oracle client installed with the tnsnames.ora file configured to access the database instances.
An administrator copy of impromptu to create a catalog.
A nework drive mapped to the area that the website data is held.
Now:
create the reports (you must design them without prompts).
start Impromptu scheduler and schedule reports to run overnight or whenever.
instruct the scheduler to save as html in the network drive.
create a link to the report in your intranet/website.

 
***************** End Of Article ****************** 
 
Sajid posted Message 384 in Message Board 
 
Dated  : February 03, 2001 at 13:11:16 EST
Subject: problem running SQR's from the SQR dialog box
 
I am getting the following error when trying to run any SQR from the SQR dialog box.


sql.ini file error

Win32Client:
Win32Client: Error.sql not found looking up error 03701

Does anybody know what the error is and how to fix it?? Please lemme know. Thanks.
 
***************** End Of Article ****************** 
 
Ranjit posted Message 385 in Message Board 
 
Dated  : February 05, 2001 at 09:04:20 EST
Subject: Re: SQA Robot
 
SQA Robot is a tool developed by Rational Software Corporation for automating the testing of MicroSoft Windows client/server applications. It runs under Windows 3.1x, 95, and NT. With SQA Robot you can record keystrokes and mouse movements while running applications and later play them back. 

Although SQA Robot is part of a related package developed by Rational Software Corporation named SQA Suite consisting of both SQA Robot and SQA Manager, the package sold by DoIT discussed below consists of SQA Robot only. 

SQA Robot lets you create test procedures to establish baseline tests for running a variety of applications, either locally or remotely through telnet or TN3270 sessions. You can later replay these test procedures to check for differences. 



 
***************** End Of Article ****************** 
 
edm posted Message 386 in Message Board 
 
Dated  : February 06, 2001 at 10:48:25 EST
Subject: Re: problem running SQR's from the SQR dialog box
 
Sajid,

What are the arguments in your sqr.ini?

If you could post it here, maybe I can help.

edm



: I am getting the following error when trying to run any SQR 
from the SQR dialog box.

: 
: sql.ini file error

: Win32Client:
: Win32Client: Error.sql not found looking up error 03701

: Does anybody know what the error is and how to fix it?? Please lemme know. Thanks.


 
***************** End Of Article ****************** 
 
Stefanie A. Newton posted Message 387 in Message Board 
 
Dated  : February 06, 2001 at 11:34:20 EST
Subject: Re: SQL Packages other than RAPID SQL
 
I have used WinSQL.  It's not as robust as RapidSQL, but it's free.  It uses ODBC.  There is also a JDBC one called DBVisualizer.  You can find them at:

http://www.indus-soft.com/winsql/

http://www.pureit.se/products/dbvis/

Hope this helps.

Stefanie A. Newton


: What other products are there out there to run SQL, other than RAPID SQL?

: What does anyone recommend?


 
***************** End Of Article ****************** 
 
Fay posted Message 388 in Message Board 
 
Dated  : February 06, 2001 at 15:29:26 EST
Subject: Crystal Reports and Run Time Parameters from PS Panel
 
I originally posted this in one of the other areas of the User Forum  but not getting any new responses.  Anyone out there having the same problem?  Thanks..
*************************************************************
: : We have a few Crystal Reports that are run from a PS panel. The run control panel comes up and the parameters are put in. We then execute the 'run' and within a minute are prompted for the parameters again. Does anyone know why this happens and how to get around the double input? Thanks..

: Check out your Process Definition of the Crystal report. Under Option panel, Parameter box. You need to append your parameters 
: Checked this out and the process defination is set to append. This appears to happen where Crystal has been installed at the workstation. Another user runs the same report from the PS panel and doesn't get prompted twice for the values. So it appears it may be something set up different in a config file...but what? Any help appreciated...Fay 

there.


 
***************** End Of Article ****************** 
 
James posted Message 389 in Message Board 
 
Dated  : February 06, 2001 at 16:10:00 EST
Subject: SQR  question ?
 
Does anybody knows if you can use unix commands from a SQR. I am creating a file on unix server and writing data to it. I want to make a copy of that file and place it somewhere on a shared directory.

thanks
James
 
***************** End Of Article ****************** 
 
VP posted Message 390 in Message Board 
 
Dated  : February 07, 2001 at 10:59:39 EST
Subject: Re: SQR  question ?
 
: Does anybody knows if you can use unix commands from a SQR. I am creating a file on unix server and writing data to it. I want to make a copy of that file and place it somewhere on a shared directory.

: thanks
: James

Sample below:

  string 'cp' '/tmp/data.dat' '/tmp/newdata.dat' by ' ' into $cmdline  ! This builds your Unix command
  call system using $cmdline #status  ! This will execute the command.

Don't forget to close your file prior to executing your unix copy.....

Good luck.



 
***************** End Of Article ****************** 
 
James posted Message 391 in Message Board 
 
Dated  : February 07, 2001 at 15:36:49 EST
Subject: Re: SQR  question ?
 
Thanks VP , it worked.




: Does anybody knows if you can use unix commands from a SQR. I am creating a file on unix server and writing data to it. I want to make a copy of that file and place it somewhere on a shared directory.

: thanks
: James


 
***************** End Of Article ****************** 
 
J posted Message 392 in Message Board 
 
Dated  : February 13, 2001 at 14:43:18 EST
Subject: CRAXDRT
 
Hi there have you figured out a way to get around your problem ,if yes pls do let me know.I am struck on this one too.
Thanks.
J


 
***************** End Of Article ****************** 
 
Mike Sherick posted Message 393 in Message Board 
 
Dated  : February 14, 2001 at 11:30:41 EST
Subject: Re: NetObjects Fusion 3.0
 
I am trying to get the "Message" function to work.

When running under Netscape 4.5, the message window comes up, but I am unable to type in any message.

Looking at the directories at my ISP's server, I have correctly placed the subdirectory name under the cgi-bin directory.

Do you have any suggestions to help get this working?  Your quick response would be greatly appreciated.

The ISP uses Unix and they indicate their side is set up correctly.

Regards,
Mike Sherick

 
***************** End Of Article ****************** 
 
Khayyam Shahzad posted Message 394 in Message Board 
 
Dated  : February 14, 2001 at 14:09:23 EST
Subject: Re: SQR Interactive Debugger
 
Please give me a call at (240)694-4143
 
***************** End Of Article ****************** 
 
rob posted Message 395 in Message Board 
 
Dated  : February 19, 2001 at 16:52:07 EST
Subject: Excel mouse through Peoplesoft on Citrix, HELP!?!
 
When users use excel via Peoplesoft, the mouse goes crazy... but only through Citrix.  From their desktops, it responds properly.  Also, running JUST Excel (not through Peoplesoft) works fine through Citrix.  This has to be a problem either with Citrix or with the registry during Peoplesoft's launching of Excel.  Anyone know what the problem could be?
 
***************** End Of Article ****************** 
 
Kott kk posted Message 396 in Message Board 
 
Dated  : February 20, 2001 at 07:05:27 EST
Subject: Re: SQA Robot
 
: I need information regarding using SQA Robot to test PeopleSoft Version 7.5.  Anyone with experience utilizing this product?


 
***************** End Of Article ****************** 
 
Shupei Wang posted Message 397 in Message Board 
 
Dated  : February 22, 2001 at 14:19:58 EST
Subject: Save .spf file as .csv from SQR Viewer
 
I open a .spf file from SQR Viewer, and I select "Save As CSV". No file is generated. Any one knows why? Any help is appreciated.

Thanks in advance. Shupei

 
***************** End Of Article ****************** 
 
Ed Mullen posted Message 398 in Message Board 
 
Dated  : February 22, 2001 at 14:25:04 EST
Subject: Re: Vertex
 
Here at HSB we have been using Vertex with Peoplesoft Billing for about a year.  We are on all currently releases and it has been working well once we got over the implementation, growing pains.....     If I can be of any help, call  860-722-5206
                                 Ed M.
: 
: : Is anyone use Vertex with Peoplesoft?


 
***************** End Of Article ****************** 
 
utkarsh posted Message 399 in Message Board 
 
Dated  : February 22, 2001 at 14:29:12 EST
Subject: Re: Crystal Reports and Run Time Parameters from PS Panel
 
You mean, It prompts for two times?
If it is, then it is problem of crystal related dll's. 
Uninstall your peoplesoft client and reinstall it. or 
another way is .. check q*32.dll in your regedit, it points to two different versions of dlls.

Good Luck.
Utkarsh
: I originally posted this in one of the other areas of the User Forum  but not getting any new responses.  Anyone out there having the same problem?  Thanks..
: *************************************************************
: : : We have a few Crystal Reports that are run from a PS panel. The run control panel comes up and the parameters are put in. We then execute the 'run' and within a minute are prompted for the parameters again. Does anyone know why this happens and how to get around the double input? Thanks..

: : Check out your Process Definition of the Crystal report. Under Option panel, Parameter box. You need to append your parameters 
: : Checked this out and the process defination is set to append. This appears to happen where Crystal has been installed at the workstation. Another user runs the same report from the PS panel and doesn't get prompted twice for the values. So it appears it may be something set up different in a config file...but what? Any help appreciated...Fay 

: there.


 
***************** End Of Article ****************** 
 
B Holmes posted Message 400 in Message Board 
 
Dated  : February 22, 2001 at 15:38:26 EST
Subject: SQR 4.3.4 w/Oracle 8.0.4 on Solaris 2.6
 
I have tried to upgrade SQR to 4.3.4 on Solaris 2.6.  I get occasional errors such as this:

Sql-status: -1461.000000
Sql-Error: ORA-01461: can bind a LONG value only for insert into a LONG column

Anyone else encountered this?  How did you fix it?  Any help greatly appreciated.
 
***************** End Of Article ****************** 
 
tzvika foyer posted Message 401 in Message Board 
 
Dated  : February 25, 2001 at 08:42:04 EST
Subject: subquery  &amp; inner join (crystal report 7) 
 
is there a way to work with subquery and iner join on crystal report 7
 
***************** End Of Article ****************** 
 
priti posted Message 402 in Message Board 
 
Dated  : February 26, 2001 at 00:38:58 EST
Subject: Re: datamart
 
I need to know what are datawarehouses and datamarts actually
Thanx..
 
***************** End Of Article ****************** 
 
Dean C. Henkel posted Message 403 in Message Board 
 
Dated  : February 27, 2001 at 14:26:34 EST
Subject: OrgPublisher successes?
 
Is anyone currently using the OrgPublisher software from TimeVision in conjunction PeopleSoft HRMS? I orginally looked at PeopleSoft's Org Chart Interface/Visio and both did not work well together if you do not use department/manager "reports to" hierarchy. 

I am evaluating the software and its potential with our company and our use of position management ("reports to position" vs. "reports to emplid"). It looks promising with the exception of the escalated cost of the software (it includes so much more than just printing an org chart). With some customization, an open position would be included in the chart generation.

Any shortcomings or hidden problems? 


 
***************** End Of Article ****************** 
 
Dimple Seth posted Message 404 in Message Board 
 
Dated  : February 27, 2001 at 19:56:31 EST
Subject: ERROR NEEDED HELP
 
Hai,

I had copied files to my hard drive from a cd (not original)demo HRMSAP7,to configure i had to lick on the config icon under bin folder to configure.
As soon as i click this icon i get an error Below is the error

PLease correct before insatlling workstation
Workstation configuration error
Error Loading ODBC Insatller DLL
D:\PT75su\PT75210\setup\psodbc\odbccp32.DLL
One of the library files needed to run the application cannot be found

Please can any body help me.Iam pure functional person.i need to demostrate to my clients

HELP and thaks in advance

Regards
Dimple



 
***************** End Of Article ****************** 
 
Akshay Sood posted Message 405 in Message Board 
 
Dated  : March 01, 2001 at 04:37:25 EST
Subject: ERP Software modification research study
 
Hi,

I am writing a thesis on the effects of software modification on the ERP project implementation. The target population comprises of poeple who have an ERP implementation experience. The survey is posted online:
 http://www.zoomerang.com/survey.zgi?29VJP2D27W8HTQPQY7JRWL0S 

The survey would not take more than 3 mins to complete, it would be great help if would take the survey by the 10th March.
Thanking you,
Akshay Sood 
 
***************** End Of Article ****************** 
 
Steve Hudgin posted Message 406 in Message Board 
 
Dated  : March 01, 2001 at 10:28:40 EST
Subject: NT 2000
 
Does PS support NT 2000 yet?  If not, does anyone have any idea when they plan to?

Also, is anyone running PS on NT 2000 yet?
 
***************** End Of Article ****************** 
 
hasan posted Message 407 in Message Board 
 
Dated  : March 03, 2001 at 21:51:53 EST
Subject: Re: ERROR NEEDED HELP
 
dont worry about this problem, it should not affect you
i got the same problem but didnt affect me in any way



: Hai,

: I had copied files to my hard drive from a cd (not original)demo HRMSAP7,to configure i had to lick on the config icon under bin folder to configure.
: As soon as i click this icon i get an error Below is the error

: PLease correct before insatlling workstation
: Workstation configuration error
: Error Loading ODBC Insatller DLL
: D:\PT75su\PT75210\setup\psodbc\odbccp32.DLL
: One of the library files needed to run the application cannot be found

: Please can any body help me.Iam pure functional person.i need to demostrate to my clients

: HELP and thaks in advance

: Regards
: Dimple



 
***************** End Of Article ****************** 
 
Dragonboy posted Message 408 in Message Board 
 
Dated  : March 04, 2001 at 04:02:42 EST
Subject: Re: NT 2000
 
: Does PS support NT 2000 yet?  If not, does anyone have any idea when they plan to?

: Also, is anyone running PS on NT 2000 yet?

Yes, I am accessing PS using 2000 prof and so far no problem encountered.

 
***************** End Of Article ****************** 
 
Davy Engels posted Message 409 in Message Board 
 
Dated  : March 04, 2001 at 13:59:03 EST
Subject: Re: Crystal 7.0 enabling ASP wen reports(Active X viewer)
 
: I loaded Crystal Reports 7.0 w/ the ASP Reports component on an Windows NT IIS4.0 server. If I type in the web address to the asp page using the browser on the server, the report loads with an active x interface (pERFECT:) But when I go to a client machine and type in the address it loads a gray page with a missing image where the active x reports should be.. For some reason the viewer is not making it to the client machine. The client machine is running IE 5.0. Any help would be greatly appreciated.. Thanks..



 
***************** End Of Article ****************** 
 
Dimple Seth posted Message 410 in Message Board 
 
Dated  : March 04, 2001 at 23:21:47 EST
Subject: Error when logging on HRMSAP7 Single User
 
Hai there

I get an error while logging on to Single User HRMSAP7

Missing or Invalid Version of SQL library PSSBS

Could you please help me out iam pure functional Person got no idea what this error is about.The screen disappears after the error diaplay and i cannot get in to the system at all


Thanks in advance

Dimple 



 
***************** End Of Article ****************** 
 
Dimple Seth posted Message 411 in Message Board 
 
Dated  : March 04, 2001 at 23:26:31 EST
Subject: Error while logging on HRMSAP7 Single User
 
Hai there

I get an error while logging on to Single User HRMSAP7

Missing or Invalid Version of SQL library PSSBS

Could you please help me out iam pure functional Person got no idea what this error is about,the screen disappears after this error and cannot get into the system.


Thanks in advance

Dimple 



 
***************** End Of Article ****************** 
 
Sheena posted Message 412 in Message Board 
 
Dated  : March 05, 2001 at 20:26:31 EST
Subject: ANSI C support
 
Hi! 
I need to call a C program , which is a part of a DLL. Now i know that the only way to do is to call an external function is to declare it as a part of a DLL . But I am told that not "any" C program is recognised by peoplesoft, but it has to be in a standard format deifned by peoplesoft. Please let me know where I can find information regarding this. 

Thanks, 
Sheena. 
Hi! 
I need to call a C program , which is a part of a DLL. Now i know that the only way to do is to call an ecternal function is to declare it as a part of a DLL . But I am told not any C program is recognised by peoplesoft, but it has to be in a standard format. Please let me know where I can find information regarding this. 

Thanks, 
Sheena. 

 
***************** End Of Article ****************** 
 
Yves van Hemelryck posted Message 413 in Message Board 
 
Dated  : March 08, 2001 at 12:32:39 EST
Subject: Re: Point of Sale software integration
 
: I would like any feedback on implementation experience with any Point of Sale software and the integration with PeopleSoft. What software?  Ease of implementation...


 
***************** End Of Article ****************** 
 
Venka posted Message 414 in Message Board 
 
Dated  : March 14, 2001 at 15:06:35 EST
Subject: Re: SQA Robot
 
: : I need information regarding using SQA Robot to test PeopleSoft Version 7.5.  Anyone with experience utilizing this product?

If you know about this Could you please let me know.

Thanks,

Venka
 
***************** End Of Article ****************** 
 
Alex posted Message 415 in Message Board 
 
Dated  : March 15, 2001 at 07:31:47 EST
Subject: QAS Quick address (UK)
 
Anyone got this sorted for V7.5?
 
***************** End Of Article ****************** 
 
Adrian Dickinson posted Message 416 in Message Board 
 
Dated  : March 15, 2001 at 11:11:14 EST
Subject: Sending faxes through ZetaFax
 
We use Zetafax in-house for faxing out Word documents etc.  Can anyone give me any pointers as to how this can be achieved in PeopleSoft?
 
***************** End Of Article ****************** 
 
AMCole posted Message 417 in Message Board 
 
Dated  : March 19, 2001 at 12:48:49 EST
Subject: PeopleSoft Crystal vs Seagate Crystal
 
Our corporation uses Seagate Crystal Reports with quite a few or our corporate applications.  We alo have PeopleSoft as one of our corporate applications, and it uses Crystal for PeopleSoft.  We have not been able to run Crystal for PeopleSoft on any of our client machines that have Seagate Crystal on them.  

I understand the PeopleSoft has customized the Crystal .dll's in order to make Crystal work with PeopleSoft.

Has ANYONE been able to run both Seagate Crystal and PeopleSoft Crystal on the same client machine?  If so, how...?
 
***************** End Of Article ****************** 
 
AMCole posted Message 418 in Message Board 
 
Dated  : March 19, 2001 at 13:58:59 EST
Subject: PeopleSoft Crystal vs Seagate Crystal
 
Our corporation uses Seagate Crystal Reports with quite a few or our corporate applications.  We alo have PeopleSoft as one of our corporate applications, and it uses Crystal for PeopleSoft.  We have not been able to run Crystal for PeopleSoft on any of our client machines that have Seagate Crystal on them.  

I understand the PeopleSoft has customized the Crystal .dll's in order to make Crystal work with PeopleSoft.

Has ANYONE been able to run both Seagate Crystal and PeopleSoft Crystal on the same client machine?  If so, how...?
 
***************** End Of Article ****************** 
 
SPerkins posted Message 419 in Message Board 
 
Dated  : March 21, 2001 at 14:42:10 EST
Subject: Running multiple versions of MF Cobol on the same Unix server
 
We support PeopleSoft Financials (7.02) and Human Resources system (7.02). We run both systems across mulitple data base instances on both our development and production Unix servers.
We are in the process of upgrading from MicroFocus (MF) 4.1 to MF Cobol Server Express 1.1 as part of upgrading our 
PeopleSoft Humand Resources system to Rel 8. The Financials system will not be upgraded for quite some time to come.
We are wondering; Is it possible to install MF Cobol Server Express 1.1 on the same server as MF 4.1? Can they
run without interfering with each other? Have anyone encountered this issue before?
Any help, information or references you can provide would be greatly appreciated!
I thank you in advance.
 
***************** End Of Article ****************** 
 
Deanna posted Message 420 in Message Board 
 
Dated  : March 21, 2001 at 15:46:11 EST
Subject: Re: PeopleSoft Crystal vs Seagate Crystal
 
We found that as long as the version of Crystal was the same (including the minor release) that we did not have any problems between PS Crystal and other applications but as soon as either was different we could no longer run PS Crystal.  We have been using Citrix for our remote sites and decided to have any clients that had crystal conflicts run PS through Citrix.  I'm not sure if Citrix is an option for you or not but it is one possibility.  

: Our corporation uses Seagate Crystal Reports with quite a few or our corporate applications.  We alo have PeopleSoft as one of our corporate applications, and it uses Crystal for PeopleSoft.  We have not been able to run Crystal for PeopleSoft on any of our client machines that have Seagate Crystal on them.  

: I understand the PeopleSoft has customized the Crystal .dll's in order to make Crystal work with PeopleSoft.

: Has ANYONE been able to run both Seagate Crystal and PeopleSoft Crystal on the same client machine?  If so, how...?


 
***************** End Of Article ****************** 
 
James posted Message 421 in Message Board 
 
Dated  : April 02, 2001 at 11:05:31 EST
Subject: Security templates !
 
Does anybody knows what peoplesoft tables are used for class security. I am trying to write a query to show  what menu/item/actions are available, or have access to for each classes.

any suggesion would be greatly appreciated.

Thanks

 
***************** End Of Article ****************** 
 
Harriet McMichen posted Message 422 in Message Board 
 
Dated  : April 02, 2001 at 15:08:03 EST
Subject: Comparison: PeopleSoft 8.0 and Oracle 11.0
 
I am looking for a white paper, or other written materials, available regarding comparison of PeopleSoft 8.0 and Oracle 11.0.  Know where I can find?
 
***************** End Of Article ****************** 
 
Mahidhar posted Message 423 in Message Board 
 
Dated  : April 05, 2001 at 12:46:26 EST
Subject: SQR/MVS does not page break properly
 
We are experiencing difficulties while trying to print a Pension SQR report to an IBM mainframe (line printer) on MVS. We tried almost everything that is there to try:

1 )Used setup31.sqc (with #define PRINTER_TYPE LINEPRINTER)
2) Changed RECFM from VB to VBA / FB ro FBA for JCL
3) Changed -GPRINT=NO to -GPRINT=YES

None of the above seem to help. The output displays '1' at the top of every page.
(We are aware of incident T-EJP-22, T-SXK019LC, but cannot find a resolution on the peoplesoft website)

Any help in this regard would be appreciated to a great extent. I could be reached at 678-657-5279(work) or 678-410-0006(Cell)
or via e-mail at 
Mahidar_Gundepudi.CSCOE@ notesmta.cscoe.accenture.com

Mahidhar 
 
***************** End Of Article ****************** 
 
Navin Narang posted Message 424 in Message Board 
 
Dated  : April 06, 2001 at 06:01:57 EST
Subject: Re: Peoplesoft Cube Manager
 
: I am looking for a consultant for a Peoplesoft HR, Payroll Datawarehousing project on the east coast that has good knowledge of Cube Manager Architecture. Can anyone help?

: Len Bourdette
: Sr. Project Manager
: Nemeth/MArtin Consulting


 
***************** End Of Article ****************** 
 
sachinpathe posted Message 425 in Message Board 
 
Dated  : April 06, 2001 at 15:48:45 EST
Subject: SQA Robot
 
 I need information regarding SQA Robot 


 
***************** End Of Article ****************** 
 
AL posted Message 426 in Message Board 
 
Dated  : April 09, 2001 at 19:03:09 EST
Subject: Re: Security templates !
 
Would PSAUTHITEM be the one you are after ?

: Does anybody knows what peoplesoft tables are used for class security. I am trying to write a query to show  what menu/item/actions are available, or have access to for each classes.

: any suggesion would be greatly appreciated.

: Thanks


 
***************** End Of Article ****************** 
 
Donbosco posted Message 427 in Message Board 
 
Dated  : April 10, 2001 at 06:17:45 EST
Subject: Re: SQA Robot
 
Please let me know.. which book is good to learn and find example test cases in SQA ROBOT.
 
***************** End Of Article ****************** 
 
Victor Loghin posted Message 428 in Message Board 
 
Dated  : April 10, 2001 at 13:26:40 EST
Subject: Re: SQR/MVS does not page break properly
 
Mahidhar,

Try the -P flag.

HTH,
Victor Loghin
VGL Consulting Inc.
vgl_ca@hotmail.com

: We are experiencing difficulties while trying to print a Pension SQR report to an IBM mainframe (line printer) on MVS. We tried almost everything that is there to try:

: 1 )Used setup31.sqc (with #define PRINTER_TYPE LINEPRINTER)
: 2) Changed RECFM from VB to VBA / FB ro FBA for JCL
: 3) Changed -GPRINT=NO to -GPRINT=YES

: None of the above seem to help. The output displays '1' at the top of every page.
: (We are aware of incident T-EJP-22, T-SXK019LC, but cannot find a resolution on the peoplesoft website)

: Any help in this regard would be appreciated to a great extent. I could be reached at 678-657-5279(work) or 678-410-0006(Cell)
: or via e-mail at 
: Mahidar_Gundepudi.CSCOE@ notesmta.cscoe.accenture.com

: Mahidhar 


 
***************** End Of Article ****************** 
 
Sush posted Message 429 in Message Board 
 
Dated  : April 12, 2001 at 10:24:34 EST
Subject: Updating using JMAC *Urgent*
 
I am currently using Peopletools v7.54 and Oracle 8i and JMAC to connect to the message agent for retrieval and updating data within the Database.

I have successfully achieved the retrieval part, but miserably failed on the updating side. However, the trace seems to think that the Update has succeeded as is clearly states - Applying value = "xxxx" and "Update Ok", although the update is not reflected in the panel and the database. When creating the message definition, all keys have been mapped, and correction mode has been specified.

There is no problem when I update using the Peoplesoft client, it only occurs when using the message agent via JMAC.

Has anyone else experienced similar problem ? I would greaty appreciate any advice.

Many thanks

SD

 
***************** End Of Article ****************** 
 
Imtiaz AHmed posted Message 430 in Message Board 
 
Dated  : April 12, 2001 at 13:55:03 EST
Subject: SQA Robot
 
I need Tutorial and basic command how to use SQA robot. If you provied me information regarding using SQA Robot on Unix or windows based or GUI 

 
***************** End Of Article ****************** 
 
Nic posted Message 431 in Message Board 
 
Dated  : April 25, 2001 at 09:35:00 EST
Subject: Print management
 
Does anynoe know how PS handles print output.
I know that in SAP it is handed off to the temse database and then sent to the prionter from there.  Is there a similar holding area in PS?  Can PS lose printed reports?  Does it rely on LP to print?
What are the limitations of printing in PS?

Best regards.
 
***************** End Of Article ****************** 
 
Nic Scanlan posted Message 432 in Message Board 
 
Dated  : April 25, 2001 at 09:37:21 EST
Subject: Re: Report Distribution
 
: I work for Quest Software and we can do exactly what you want.  We even have an interface to PS to enable you to have no administrative over head with another application.
Installed and demonstratable in less than a day with live data.

: : : Vista Plus by Quest Software might satisfy your requirements.  I saw a demo of their product at the March,99 PeopleSoft Golden Gate RUG and plan to have them come to our site for my users to review the product.  Look good and integrates with PeopleSoft.
: : -Clarice Rinard 

: : 
: : : I work for Information Builders we are a PeopleSoft Alliance Partner. We have a product called Power Reporter for PeopleSoft that does exactly what you are asking for. I can have the product ,manager contact you directly if you send me an email address. What you are describing is what is called a managed reporting environment where you can have the same report distributed via email but customized so that only the appropriate people can see or change certain type of data. The reports can be distributed through either a push or pull technology.

: : 
: : : 
: : :  : Does anyone have any experience using a report distribution tool and integrating it with PeopleSoft ?

: : : : We would like to be able to schedule reports to run and then be viewed using this tool.  
: : : : Also, we need to be able to provide different security levels within each of the reports.  For example, the CEO may be able to see the entire report, but a manager may only be able to see data that applies to a specific business unit/dept/region...

: : : : Any recommendations and/or things to avoid would be appreciated.



 
***************** End Of Article ****************** 
 
Nic posted Message 433 in Message Board 
 
Dated  : April 25, 2001 at 09:44:32 EST
Subject: Print management
 
Does anynoe know how PS handles print output.
I know that in SAP it is handed off to the temse database and then sent to the prionter from there.  Is there a similar holding area in PS?  Can PS lose printed reports?  Does it rely on LP to print?
What are the limitations of printing in PS?

Best regards.
 
***************** End Of Article ****************** 
 
michael posted Message 434 in Message Board 
 
Dated  : April 25, 2001 at 13:33:29 EST
Subject: Crystal Report
 
I have created a crystal report with boxes and lines on it.  When the report is run all the boxes and lines that I have on the first page appear again on the second page.  Does any one know how to prevent this from happening.

thanks
 
***************** End Of Article ****************** 
 
Sivaram posted Message 435 in Message Board 
 
Dated  : April 27, 2001 at 19:19:53 EST
Subject: 2 phase commit
 
Hai I am currently looking at possibilities of 2 phase commit in Peoplesoft. 

The scenario is that you have 2 peoplesoft system running at two different servers and there is this external application calls a transaction which need to be commited on both the Peoplesoft system . The external application resource manager first announces that it is going to commit and ask whether all the other services are ready to commit.If everybody is ready it commits the transaction.

Is this kind of a transaction commit is supported in Peoplesoft . I doubt in 7.5 and how about in PS 8.

Thanks in Advance.

Rgds
 
***************** End Of Article ****************** 
 
Rebecca Porath posted Message 436 in Message Board 
 
Dated  : May 01, 2001 at 11:29:43 EST
Subject: Margin Problems with PDF files using SQR v4.3.2.2
 
We are having a problem with some of our PDF reports generated by SQR v4.3.2.2 using PeopleSoft's setup01.sqc and stdhdg01.sqc.  When viewing these PDF reports with acrobat, the first row on the report is chopped off or missing and the left margin is really small.  

Anyone know how to fix this problem other than by creating new setup sqcs or adding a blank row to the top of the PeopleSoft provided header sqcs?

Any help is appreciated.

Thanks,
R. Porath

 
***************** End Of Article ****************** 
 
Alejandro Calderón posted Message 437 in Message Board 
 
Dated  : May 02, 2001 at 13:23:05 EST
Subject: Re: problem running SQR's from the SQR dialog box
 
I have the same problem.   If someone can help. I'm developing in Sql Windows and trying to connect to an Access Database. My Sql.ini is :

[dbnt1sv]
dbdir=C:\WINDOWS\SYSTEM
dbdir=C:\WINDOWS\SYSTEM
servername=Server1,sqlapipe
dbname=PARAISO,sqlapipe

[dbnt1sv.dll]
comdll=sqlapipe

[dbnt1sv.apipe]
;debug=15,dbntsrv.dbg

[win32client]
clientname=Win32Client

[win32client.dll]
;comdll=sqlora32
comdll=sqlodb32
;comdll=sqlapipe
;comdll=sqlapipe

[win32client.apipe]
;debug=15,client.dbg

[oragtwy]
remotedbname=oracle7,@x:orasrv
longbuffer=32767
fetchrow=20

[odbcrtr]
odbctrace=off
odbctracefile=sql.log

[win32client.ws32]
serverpath=server1,localhost/island


All Help will be great..
: I am getting the following error when trying to run any SQR from the SQR dialog box.

: 
: sql.ini file error

: Win32Client:
: Win32Client: Error.sql not found looking up error 03701

: Does anybody know what the error is and how to fix it?? Please lemme know. Thanks.


 
***************** End Of Article ****************** 
 
Vamp posted Message 438 in Message Board 
 
Dated  : May 02, 2001 at 13:31:43 EST
Subject: Error on Sql.ini (3701)
 
I have this problem. I'm developing in Sql Windows and trying to connect to an Access Database, but it shows an error with WinClient. My Sql.ini is :

[dbnt1sv]
dbdir=C:\WINDOWS\SYSTEM
dbdir=C:\WINDOWS\SYSTEM
servername=Server1,sqlapipe
dbname=PARAISO,sqlapipe

[dbnt1sv.dll]
comdll=sqlapipe

[dbnt1sv.apipe]
;debug=15,dbntsrv.dbg

[win32client]
clientname=Win32Client

[win32client.dll]
;comdll=sqlora32
comdll=sqlodb32
;comdll=sqlapipe
;comdll=sqlapipe

[win32client.apipe]
;debug=15,client.dbg

[oragtwy]
remotedbname=oracle7,@x:orasrv
longbuffer=32767
fetchrow=20

[odbcrtr]
odbctrace=off
odbctracefile=sql.log

[win32client.ws32]
serverpath=server1,localhost/island


Any help will be great..
 
***************** End Of Article ****************** 
 
Ritesh Gupta posted Message 439 in Message Board 
 
Dated  : May 03, 2001 at 05:27:50 EST
Subject: Re: Crystal Report Design Question
 
how to i can use a parameter in crystal report ?

what is sub report?

 
***************** End Of Article ****************** 
 
Ritesh Gupta posted Message 440 in Message Board 
 
Dated  : May 03, 2001 at 05:38:54 EST
Subject: How to i Can pass parameter in crystal report using visual basic 
 

How to i Can pass parameter in crystal report using visual basic ?

please tell me there is any way to supress a column on run time ?

 
***************** End Of Article ****************** 
 
Rodrigo posted Message 441 in Message Board 
 
Dated  : May 07, 2001 at 17:20:39 EST
Subject: Re: re:RightFAX 7.2 with PeopleSoft
 
: I am working for a client that has RightFAX 7.2and they want to use the RightFAX instead of the ObjectFax. Is there anyone who has previously implemented RightFAX 6.0 with PeopleSoft Purchasing 7.5. I need step by step process on how to implement RightFAX with PeopleSoft.

: I would really appreciate the help ASAP.

: Thanks

: Bryan 


 
***************** End Of Article ****************** 
 
Monir Hossain posted Message 442 in Message Board 
 
Dated  : May 10, 2001 at 15:50:20 EST
Subject: Re: SQA Robot
 
: I need Tutorial and basic command how to use SQA robot. If you provied me information regarding using SQA Robot on Unix or windows based or GUI 


 
***************** End Of Article ****************** 
 
vanitha posted Message 443 in Message Board 
 
Dated  : May 11, 2001 at 07:29:08 EST
Subject: Re: Crystal 8 webreporting
 
: Greetings,


 
***************** End Of Article ****************** 
 
Dhiraj Gupta posted Message 444 in Message Board 
 
Dated  : May 14, 2001 at 23:44:05 EST
Subject: Re: SQA Robot
 
: I need Tutorial and basic command how to use SQA robot. If you provied me information regarding using SQA Robot on Unix or windows based or GUI 


 
***************** End Of Article ****************** 
 
abc posted Message 445 in Message Board 
 
Dated  : May 15, 2001 at 23:57:46 EST
Subject: Re: Crystal 8 webreporting
 
: Greetings,


 
***************** End Of Article ****************** 
 
dave posted Message 446 in Message Board 
 
Dated  : May 17, 2001 at 10:09:23 EST
Subject: Re: QAS Quick address (UK)
 
: Anyone got this sorted for V7.5?

: Why not use Capscan which has simpler interfaces and api integration www.capscan.com
 
***************** End Of Article ****************** 
 
jenny posted Message 447 in Message Board 
 
Dated  : May 17, 2001 at 17:37:23 EST
Subject: Re: SQA Robot
 
Hi, there:
 I need Tutorial and basic command how to use SQA robot. I womder if you could provide me information regarding using SQA Robot on Unix or windows based or GUI. Thank you very much.
Have a nice day!
Jenny


 
***************** End Of Article ****************** 
 
Vishwa Bandhu Arora posted Message 448 in Message Board 
 
Dated  : May 21, 2001 at 08:54:08 EST
Subject: Re: SQA Robot
 
: I need information regarding using SQA Robot to test PeopleSoft Version 7.5.  Anyone with experience utilizing this product?


 
***************** End Of Article ****************** 
 
Patrick Markert posted Message 449 in Message Board 
 
Dated  : May 23, 2001 at 13:50:01 EST
Subject: Want to purchase PeopleSoft Client Contact List
 
Our company provides consulting and staffing services to companies using PeopleSoft.  If you have a list of contacts who buy these types of services in the Peoplesoft arena, I would be very interested in purchasing this information.  Please contact me at 404-233-1717 x100
 
***************** End Of Article ****************** 
 
Hana posted Message 450 in Message Board 
 
Dated  : May 26, 2001 at 02:32:43 EST
Subject: Re: How to i Can pass parameter in crystal report using visual basic 
 
: 
: How to i Can pass parameter in crystal report using visual basic ?

: please tell me there is any way to supress a column on run time ?


 
***************** End Of Article ****************** 
 
Sarwat posted Message 451 in Message Board 
 
Dated  : May 26, 2001 at 07:47:40 EST
Subject: Re: SQA Robot
 
: I need Tutorial and basic command how to use SQA robot. If you provied me information regarding using SQA Robot on Unix or windows based or GUI 


 
***************** End Of Article ****************** 
 
Sarwat posted Message 452 in Message Board 
 
Dated  : May 26, 2001 at 07:47:51 EST
Subject: Re: SQA Robot
 
: I need Tutorial and basic command how to use SQA robot. If you provied me information regarding using SQA Robot on Unix or windows based or GUI 


 
***************** End Of Article ****************** 
 
Justin posted Message 453 in Message Board 
 
Dated  : May 29, 2001 at 17:31:27 EST
Subject: Emergency!
 
I'm a new developer having trouble getting an SQR to run, the SQL runs perfectly, however, when looking running the SQR, I get no rows inserted into the table instead I get an error

201
201

Please advise.
 
***************** End Of Article ****************** 
 
EDM posted Message 454 in Message Board 
 
Dated  : May 30, 2001 at 10:20:34 EST
Subject: Re: Emergency!
 
I don't do magic nor do see things behind the walls. 201 is just a number to me. If you could send the complete error messages
and your sqr program, then maybe somebody or I could help you
in your problem



: I'm a new developer having trouble getting an SQR to run, the SQL runs perfectly, however, when looking running the SQR, I get no rows inserted into the table instead I get an error

: 201
: 201

: Please advise.


 
***************** End Of Article ****************** 
 
Bernadette Maurer posted Message 455 in Message Board 
 
Dated  : May 30, 2001 at 13:51:31 EST
Subject: PeopleSoft and Oracle
 
I have been tasked to investigate PeopleSoft 8 and its use with Oracle.  I know nothing about PeopleSoft.  What is it?  I was told by my team leader that we are particularly interested in version 8 upgrade to the property module.  Is PeopleSoft an integrated software? 

I went to the PeopleSoft web site but could not find anything that was close to property.  I even did a search on property but the search found nothing.

Hopefully someone out there in PeopleSoft land can help me.  
 
***************** End Of Article ****************** 
 
Steve Altman posted Message 456 in Message Board 
 
Dated  : May 31, 2001 at 12:39:23 EST
Subject: Multiple data source reporting
 
How could I merge PeopleSoft Finance data with Siebel or any other SFA tool in a Crystal Report without bringing the data in through the other application?
 
***************** End Of Article ****************** 
 
mac compton posted Message 457 in Message Board 
 
Dated  : June 01, 2001 at 16:19:16 EST
Subject: Looking for PeopleSoft adapter leads
 
In general, I'm looking for an 'ODBC' style adapter to peopleSoft. I don't know if one exists, or what type of development is going on in this area. Any leads and/or insights would be 'greatly' appreciated.

thanks in advance
mac
 
***************** End Of Article ****************** 
 
Kishore posted Message 458 in Message Board 
 
Dated  : June 02, 2001 at 00:26:14 EST
Subject: Re: datamart
 
hi

Dataware housing

It is the co-ordinated, architectured and periodic copying of data from various sources both inside and outside the enterprise into an environment optimized for analytical and information processing.The purpose of data ware house is to help people to make better business decisions.

Datamart

Datamart is the place where selected data from back end systems is stored for access by clients.The data is actually cleaned up and manipulated in a variety of ways before it is stored on the staging systems.

 
***************** End Of Article ****************** 
 
Lotec posted Message 459 in Message Board 
 
Dated  : June 04, 2001 at 15:04:12 EST
Subject: Re: Imaging Products
 
There is a case study for Autozone using IBM's ContentManager software at http://www-4.ibm.com/software/data/cm/casestudy.html.  It is for HR, but it sounds like what you are looking for.


 
***************** End Of Article ****************** 
 
jagadish posted Message 460 in Message Board 
 
Dated  : June 04, 2001 at 20:48:59 EST
Subject: Re: Crystal Reports 7 &amp; Peoplesoft 7.5
 
Change the process definition options in the process definition panel with "Append" in parameters list  and enter the run time prompts setup againest the box provided there. That should work
 
***************** End Of Article ****************** 
 
Steve Altman posted Message 461 in Message Board 
 
Dated  : June 05, 2001 at 11:54:00 EST
Subject: Re: Report Distribution
 
Actuate is capable of creating the reports directly in DHTML and granting user security to their access.  With one report you can have as many different security access rites as your ldap server maintains. Take a look.

: : I work for Quest Software and we can do exactly what you want.  We even have an interface to PS to enable you to have no administrative over head with another application.
: Installed and demonstratable in less than a day with live data.

: : : : Vista Plus by Quest Software might satisfy your requirements.  I saw a demo of their product at the March,99 PeopleSoft Golden Gate RUG and plan to have them come to our site for my users to review the product.  Look good and integrates with PeopleSoft.
: : : -Clarice Rinard 

: : : 
: : : : I work for Information Builders we are a PeopleSoft Alliance Partner. We have a product called Power Reporter for PeopleSoft that does exactly what you are asking for. I can have the product ,manager contact you directly if you send me an email address. What you are describing is what is called a managed reporting environment where you can have the same report distributed via email but customized so that only the appropriate people can see or change certain type of data. The reports can be distributed through either a push or pull technology.

: : : 
: : : : 
: : : :  : Does anyone have any experience using a report distribution tool and integrating it with PeopleSoft ?

: : : : : We would like to be able to schedule reports to run and then be viewed using this tool.  
: : : : : Also, we need to be able to provide different security levels within each of the reports.  For example, the CEO may be able to see the entire report, but a manager may only be able to see data that applies to a specific business unit/dept/region...

: : : : : Any recommendations and/or things to avoid would be appreciated.



 
***************** End Of Article ****************** 
 
MelBMax posted Message 462 in Message Board 
 
Dated  : June 05, 2001 at 13:21:01 EST
Subject: Re: Multiple data source reporting
 
I've seen other data brought into PSft via a Psft SQL view that actually queries the other system. This view is then used in PeopleTools query. The crystal report is tied to this query. I'll see if I can find more doc and post it for you.
 
***************** End Of Article ****************** 
 
Jagadish posted Message 463 in Message Board 
 
Dated  : June 11, 2001 at 16:24:19 EST
Subject: Re: Crystal reports - Selecting a network printer
 
Hi,
You need to change the printer that is set up for ur run control id. Go to eidt/preferences/run control panel.check what printer is assigned as ur default printer. if u want to change that delete the run control id and add new run control id and specify the printer. If it doesnot allow and takes default as LPT or whatever then say ok . Then go to printers in the control panel and check the properties of the printer to which u want to give the report. go to sharing and specify the name that is specified in the run control. Then run the report. It should work.
 
***************** End Of Article ****************** 
 
roddie mclure posted Message 464 in Message Board 
 
Dated  : June 12, 2001 at 14:24:17 EST
Subject: cognos
 
I'm trying to save a powerplay report as an excel file when using   save as from the File menu, I get an error PowerPlay member not found. Any help would be appreciated
 
***************** End Of Article ****************** 
 
kris  posted Message 465 in Message Board 
 
Dated  : June 13, 2001 at 13:40:43 EST
Subject: Bets Computer Training Center In Nj
 





In article <3a6e53a8.0@news1.mweb.co.za>,
 
I am writing to you about the best computer training center in New Jersey. I am attaching some information that I found from one of the best IT consulting companies out there. They did a good job for  my friends

In article <3a6e53a8.0@news1.mweb.co.za>,
 "Jan & Theo" <mwjan02@mweb.co.za> wrote:
> You asked me about hot IT fields

> In article <92qg6d$83n$1@nnrp1.deja.com>,
  >>In your artcile you had asked me which was the best job for Indians and Asians in the information >>technology field> 

>>>We strongly believe that the best job for Computer consultants is in the functional areas of Siebel. If >>>you missed the boat in SAP...this is the next boat that takes you to the isle of wealth.

>>>Infotech Research International, Inc. in New Jersey offer one of the best Siebel Consultant Generation >>>Programs anywhere.

>>>To contact them, call them at 973-463-1260

>>>Crestech University
>>>Enterprise Technology Education for the Global Village
>>>188 Route 10 West,Suite 202, East Hanover, NJ 07936
>>>Phone : 973-463-1260,  Fax : 973-463-1265 
>>>www.crestech.org, Email : info@infotechri.com,
>>>IBM, Cisco & Siebel Partners.



We very  strongly see and believe as per the market demand ,the best job for computer consultants is in the functional areas of Siebel .If you have missed the SAP program ,this is the next boat that takes you to the isle of wealth .
Infotech Research International, Inc. in New Jersey offer one of the best Siebel Consultant Generation Programs anywhere.

To contact them, call them at 973-463-1260

Crestech.org
Enterprise Technology Education for the Global Village
188 Route 10 West,Suite 202, East Hanover, NJ 07936
Phone : 973-463-1260,  Fax : 973-463-1265 
www.crestech.org, Email : info@infotechri.com,
IBM, Cisco & Siebel Partners.

Presently , as per the market requirements and demand the best job for computer consultants is in the functional areas of Siebel in IT field.If you are really looking for the wealthiest future do not miss this boat.

Infotech Research International, Inc. in New Jersey offer one of the best Siebel Consultant Generation Programs anywhere.

To contact them, call them at 973-463-1260





CRESTECH.ORG.
Enterprise Technology Solutions for the Global Village
188 Route 10 West,Suite 202, East Hanover, NJ 07936
Phone : 973-463-1260,  Fax : 973-463-1265 
www.infotechRI.com, Email : info@infotechri.com,
IBM, Cisco & Siebel Partners.



In IT field we believe that the best job for the computer consultants is in the functional areas of Siebel .
If you have missed the SAP flight ,this is the next flight which takes you to the right destination.
Infotech Research International, Inc. in New Jersey offer one of the best Siebel Consultant Generation Programs anywhere.

To contact them, call them at 973-463-1260

CRESTECH.ORG.
Enterprise Technology Solutions for the Global Village
188 Route 10 West,Suite 202, East Hanover, NJ 07936
Phone : 973-463-1260,  Fax : 973-463-1265 
www.infotechRI.com, Email : info@infotechri.com,
IBM, Cisco & Siebel Partners.



 
***************** End Of Article ****************** 
 
kris  posted Message 466 in Message Board 
 
Dated  : June 13, 2001 at 13:40:47 EST
Subject: Bets Computer Training Center In Nj
 





In article <3a6e53a8.0@news1.mweb.co.za>,
 
I am writing to you about the best computer training center in New Jersey. I am attaching some information that I found from one of the best IT consulting companies out there. They did a good job for  my friends

In article <3a6e53a8.0@news1.mweb.co.za>,
 "Jan & Theo" <mwjan02@mweb.co.za> wrote:
> You asked me about hot IT fields

> In article <92qg6d$83n$1@nnrp1.deja.com>,
  >>In your artcile you had asked me which was the best job for Indians and Asians in the information >>technology field> 

>>>We strongly believe that the best job for Computer consultants is in the functional areas of Siebel. If >>>you missed the boat in SAP...this is the next boat that takes you to the isle of wealth.

>>>Infotech Research International, Inc. in New Jersey offer one of the best Siebel Consultant Generation >>>Programs anywhere.

>>>To contact them, call them at 973-463-1260

>>>Crestech University
>>>Enterprise Technology Education for the Global Village
>>>188 Route 10 West,Suite 202, East Hanover, NJ 07936
>>>Phone : 973-463-1260,  Fax : 973-463-1265 
>>>www.crestech.org, Email : info@infotechri.com,
>>>IBM, Cisco & Siebel Partners.



We very  strongly see and believe as per the market demand ,the best job for computer consultants is in the functional areas of Siebel .If you have missed the SAP program ,this is the next boat that takes you to the isle of wealth .
Infotech Research International, Inc. in New Jersey offer one of the best Siebel Consultant Generation Programs anywhere.

To contact them, call them at 973-463-1260

Crestech.org
Enterprise Technology Education for the Global Village
188 Route 10 West,Suite 202, East Hanover, NJ 07936
Phone : 973-463-1260,  Fax : 973-463-1265 
www.crestech.org, Email : info@infotechri.com,
IBM, Cisco & Siebel Partners.

Presently , as per the market requirements and demand the best job for computer consultants is in the functional areas of Siebel in IT field.If you are really looking for the wealthiest future do not miss this boat.

Infotech Research International, Inc. in New Jersey offer one of the best Siebel Consultant Generation Programs anywhere.

To contact them, call them at 973-463-1260





CRESTECH.ORG.
Enterprise Technology Solutions for the Global Village
188 Route 10 West,Suite 202, East Hanover, NJ 07936
Phone : 973-463-1260,  Fax : 973-463-1265 
www.infotechRI.com, Email : info@infotechri.com,
IBM, Cisco & Siebel Partners.



In IT field we believe that the best job for the computer consultants is in the functional areas of Siebel .
If you have missed the SAP flight ,this is the next flight which takes you to the right destination.
Infotech Research International, Inc. in New Jersey offer one of the best Siebel Consultant Generation Programs anywhere.

To contact them, call them at 973-463-1260

CRESTECH.ORG.
Enterprise Technology Solutions for the Global Village
188 Route 10 West,Suite 202, East Hanover, NJ 07936
Phone : 973-463-1260,  Fax : 973-463-1265 
www.infotechRI.com, Email : info@infotechri.com,
IBM, Cisco & Siebel Partners.



 
***************** End Of Article ****************** 
 
Patrick Markert posted Message 467 in Message Board 
 
Dated  : June 14, 2001 at 10:44:44 EST
Subject: Want to purchase Vantive Client Contact List 
 
Our company provides consulting and staffing services to companies using Vantive. If you have a list of contacts who buy these types of services in the Vantive arena, I would be very interested in purchasing this information. Please contact me at 404-233-1717 x100 
 
***************** End Of Article ****************** 
 
Baldur posted Message 468 in Message Board 
 
Dated  : June 16, 2001 at 23:10:32 EST
Subject: Re: Crystal 7.0 enabling ASP wen reports(Active X viewer)
 
: I loaded Crystal Reports 7.0 w/ the ASP Reports component on an Windows NT IIS4.0 server. If I type in the web address to the asp page using the browser on the server, the report loads with an active x interface (pERFECT:) But when I go to a client machine and type in the address it loads a gray page with a missing image where the active x reports should be.. For some reason the viewer is not making it to the client machine. The client machine is running IE 5.0. Any help would be greatly appreciated.. Thanks..


 
***************** End Of Article ****************** 
 
Patrick posted Message 469 in Message Board 
 
Dated  : June 18, 2001 at 19:34:03 EST
Subject: Re: PeopleSoft on Metaframe 1.8 with NT SP4
 
where can I get a copy of a manual dealing with "setting up PeopleSoft on a Citrix/Metaframe client" ?



 
***************** End Of Article ****************** 
 
Bill Joeckel  posted Message 470 in Message Board 
 
Dated  : June 19, 2001 at 14:17:10 EST
Subject: Peoplesoft Version 8.0 with financials Technical with Analyst Skills Contract for hire Overland Park Ks
 
Hello! My name is Bill Joeckel, I'm with Tri-Com Technical Services in suburban Kansas City. "Tri-Com" is an I.T. consulting firm specializing in providing top E-Commerce professionals to over 80 Corporate Clients both locally and nationally. We have placed an emphasis in recruiting for DNA architecture professionals, Java Developers, and EJB folks. 
 
As you may be aware, I.T. professionals have MANY choices when it comes to picking a consulting firm. That is why I wanted to send this e-mail, because I firmly believe Tri-Com is the best I.T. consulting firm in the Midwest. Consider that all of the following accolades have been bestowed upon our firm just since early March of this year (2000).
The Kansas City Business Journal named Tri-Com the 148th largest privately-held company in Kansas City in just our sixth full year of business (there were only 7 companies newer than Tri-Com on this list). 
Ingram's magazine listed Tri-Com the 14th fastest growing company in the Kansas City metro area (public or private). 
Our co-founder and current CEO, Matt Sharples, was named a Ernst & Young - Entrepreneur of The Year Finalist for the entire state of Kansas and half of Missouri (one of 20 Finalists from over 500 nominees). 
In October, Inc magazine will feature Tri-Com as one of it's Inc 500 which recognizes the 500 fastest growing privately-held companies within the entire United States.
If you're serious about your career within Information Technology, Tri-Com is the best you could ever find in helping you reach your objectives. If interested, give me a call at work (between 8am and 5pm central) at (913) 652-0600 or (800) 280-6919. You can also reach me at home between 7pm and 11pm weekdays or on the weekend at (913) 256-6937.
 
Thanks,
 
Bill Joeckel
Tri-Com Technical Services
9240 Glenwood
Overland Park, KS 66212
billj@tricomts.com
url. www.tricomts.com
 
***************** End Of Article ****************** 
 
Swapan Mahato posted Message 471 in Message Board 
 
Dated  : June 24, 2001 at 12:46:53 EST
Subject: Fast Security on Business Objects
 
Has anyone implemented Fast Security on Business Objects?
How do you do that? 
 
***************** End Of Article ****************** 
 
Faisal Siddiqui posted Message 472 in Message Board 
 
Dated  : June 26, 2001 at 05:52:49 EST
Subject: Re: PeopleSoft and Oracle
 
: I have been tasked to investigate PeopleSoft 8 and its use with Oracle.  I know nothing about PeopleSoft.  What is it?  I was told by my team leader that we are particularly interested in version 8 upgrade to the property module.  Is PeopleSoft an integrated software? 

: I went to the PeopleSoft web site but could not find anything that was close to property.  I even did a search on property but the search found nothing.

: Hopefully someone out there in PeopleSoft land can help me.  

PeopleSoft is  an ERP package. ERP stands for Enterprise Resource Planning. U can think of it as an advanced MIS system which is enterprise wide. there is nothing like a property module to my knowledge in peoplesoft.
try www.vijaymukhi.com. it has a tutorial on peoplesoft though only the financial module.

hope u feel better!!!!

PeopleSoft 8 is the latest version and is web enabled. 

 
***************** End Of Article ****************** 
 
amaiti posted Message 473 in Message Board 
 
Dated  : June 26, 2001 at 09:13:55 EST
Subject:  can you pass VB recordset to Crystal Reports?????
 
I want to use recordset from a VB client to dynamically generate a crystal report from a template. Please tell us how we will do it???

 
***************** End Of Article ****************** 
 
Vertexera posted Message 474 in Message Board 
 
Dated  : July 03, 2001 at 15:01:36 EST
Subject: Selling Peoplesoft Contact lists
 
For anyone interested to increase sales,
Vertexera, a California based corporation, has developed the ultimate list of Peoplesoft customers and managers within these companies that can make purchasing decisions for further products and services. We have gathered over 200,000 contacts in the USA alone! Our contacts are spanning across all major Fortune 1000 companies, major Government and Educational institutions and Healthcare organizations.
If interested please contact us at 310-318-8934. If ordered you can have the list available today -- we can either FTP or email it to you! 

Happy Selling!
Joe L.


 
***************** End Of Article ****************** 
 
Guillermo posted Message 475 in Message Board 
 
Dated  : July 05, 2001 at 01:44:10 EST
Subject: Crystal Reports 8 and VB
 
Hi:

I`m trying to send a dynamic SQL to Crystal Reports 8, and some parameters too. This stuff was easy in Crystal Reports 6,
via SqlQuery and ParameterFields, but the version 8 lack
of that. 

Is it possible?

Regards for all. 




 
***************** End Of Article ****************** 
 
arvind posted Message 476 in Message Board 
 
Dated  : July 05, 2001 at 03:47:56 EST
Subject: printing
 
hi,  

           I am doing project in ASP. It's a Intranet Based Project. I have to take some reports thru web.  In VB for taking reports we will use crystal report. But in ASP I don't know. Please help me.  

                 
 
***************** End Of Article ****************** 
 
EDM posted Message 477 in Message Board 
 
Dated  : July 05, 2001 at 09:53:07 EST
Subject: Re: printing
 
You are in the wrong forum. This is Peoplesoft not ASP.

: hi,  

:            I am doing project in ASP. It's a Intranet Based Project. I have to take some reports thru web.  In VB for taking reports we will use crystal report. But in ASP I don't know. Please help me.  

:                  


 
***************** End Of Article ****************** 
 
Steve Altman posted Message 478 in Message Board 
 
Dated  : July 05, 2001 at 14:00:55 EST
Subject: Re: printing
 
Do you mean that you are using PeopleSoft in an ASP model?

: hi,  

:            I am doing project in ASP. It's a Intranet Based Project. I have to take some reports thru web.  In VB for taking reports we will use crystal report. But in ASP I don't know. Please help me.  

:                  



 
***************** End Of Article ****************** 
 
Anton de Weger posted Message 479 in Message Board 
 
Dated  : July 06, 2001 at 09:53:25 EST
Subject: Re: NT 2000
 
We are running MS SQL Server 2000, Personal Oracle, Application Servers, Process Schedulers, Web Servers, and Report Distribution all on Other than a small fix with the Grant and Connect sql scripts for MS SQL Server 2000.  It is all running ok.

Regards, 
Anton.
 
***************** End Of Article ****************** 
 
RadhaKrishna . Deevi posted Message 480 in Message Board 
 
Dated  : July 06, 2001 at 10:49:44 EST
Subject: Re: SQA Robot
 
: I need Tutorial and basic command how to use SQA robot. If you provied me information regarding using SQA Robot on Unix or windows based or GUI 

Thank you


 
***************** End Of Article ****************** 
 
Venkat posted Message 481 in Message Board 
 
Dated  : July 07, 2001 at 22:27:28 EST
Subject: PS 8.0 Integration using Component Interface with Java
 
Have anyone successfully implemented PS 8.0 With any other java based third party tool. I would like to know and the issues faced and the resolutions for the same. I would like to share some knowledge.


Thanks in advance

Venkat
 
***************** End Of Article ****************** 
 
ashutosh sandhal posted Message 482 in Message Board 
 
Dated  : July 09, 2001 at 02:20:48 EST
Subject: Crystal Report 8i with JSP
 
My need is that i need the working and feasiablity of Crystal Report 8i with JSP (Java Server Pages).
So kindly forward me the required information....


 
***************** End Of Article ****************** 
 
Mark  posted Message 483 in Message Board 
 
Dated  : July 09, 2001 at 17:18:40 EST
Subject: Crystal Reports for PeopleSoft
 
I have a modified crystal report that produces checks.   We had
a sample with PeopleSoft that produces checks correctly.  We had to modify it for our own type of checks.   But when this was modified, it always produce two extra checks.   If you are familiar with the fields @BeginCheckFlag and @EndCheckFlag, could you give us a tip on how to use this.   We had put the @EndCheckFlag field at the end of the check.   The sample has @EndCheckFlag field at the middle of the stub.  What does the InCheck variable mean? 
 
***************** End Of Article ****************** 
 
Thomas Danaher posted Message 484 in Message Board 
 
Dated  : July 10, 2001 at 09:18:59 EST
Subject: Application Xtender 4.1
 
I am installing AEX on Windows 2000 and am getting an error message:
" Data Link Error- Error enumerating data servers."
Any ideas?
 
***************** End Of Article ****************** 
 
AK posted Message 485 in Message Board 
 
Dated  : July 16, 2001 at 14:10:58 EST
Subject: Lotus Notes
 
We are planning to use Lotus Notes Forms for our voucher approval for users who doesn't have PS access.  Is it true that connection to Lotus Notes, user need to be on 2 tier mode?  Any help on this is appreciated.
 
***************** End Of Article ****************** 
 
Gerry Yon posted Message 486 in Message Board 
 
Dated  : July 17, 2001 at 16:13:22 EST
Subject: Crystal AP checks
 
I have a user who's PC cannot run AP checks.  It will run any other Crystal reports, and she can run AP checks at another workstation. I deleted all references to Oracle, Crystal, and Psoft in her registry and deleted the software on the PC.  It still doesn't work.  Has anyone seen this?
 
***************** End Of Article ****************** 
 
Aklima Begum posted Message 487 in Message Board 
 
Dated  : July 18, 2001 at 10:24:09 EST
Subject: Re: SQA Robot
 
: : I need Tutorial and basic command how to use SQA robot. If you provied me information regarding using SQA Robot on Unix or windows based or GUI 


 
***************** End Of Article ****************** 
 
Jennifer Frazer posted Message 488 in Message Board 
 
Dated  : July 18, 2001 at 17:38:14 EST
Subject: Re: Visio &amp; Org Charts
 
We have the same problem here. We use PeopleSoft and Visio. I have received that error you are talking about as well. It usually happens when  there is an employee that is reporting to someone that is not an employee in the Excel list.Sounds like that is what's happening with you. That can't happen or Visio wont understand.We do Org Charts for the entire organization at one time. It sounds like you are doing dept by dept. What you should do is get rid of the Head of the Depts Supervisor. In other words it will be blank. The reason is so Visio will not go looking for that Head of the Depts Supervisor for the Org Chart. This should work. Hope this makes sense.
 
***************** End Of Article ****************** 
 
Mario Rossi posted Message 489 in Message Board 
 
Dated  : July 19, 2001 at 11:16:30 EST
Subject: Re: if then else statement in Crystal Report, making it test all fields...
 
: this is what I want to do using Crystal Version 5 and VB Enterprise 5

: If variable 1 (field) from table A is found anywhere in table B then print variable 1 otherwise print variable 1(field) in table B 
: Then go on to variable 2 from table A.  If it is found in table B then print variable 2 from table A otherwise table B-variable 2 and so on going through all the fields.  Is there a way to loop through the fields in this version of Crystal?

: It's not enough to use the if then else statement - it just seems to examine the first record.  Thanks!



 
***************** End Of Article ****************** 
 
fariza posted Message 490 in Message Board 
 
Dated  : July 20, 2001 at 04:22:49 EST
Subject: printing problem
 
hi 

i keep getting this message when i print sqr reports
"(SQR 4717) Cannot open the report output file: 'lpt1' (13): permission denied."

the printer in connected directly to my lpt port. and if i reboot, i do get to print the sqr reports .. just for a while. then i'll get the message above.

please help.
thank you
 
***************** End Of Article ****************** 
 
Rustenberg posted Message 491 in Message Board 
 
Dated  : July 21, 2001 at 17:46:31 EST
Subject: Re: Debugging SQR Programs
 
: try using Professional File Editor - it has a line number facility on it.

: 
: : I'm not aware of any free debugger for SQR.  You might want to check the site www.sqrug.com.  To find the exact line numbers simply use an editor that can show you line numbers and that way you can go directly to the line that has the error.  NotePad is a bad choice for a programmer's editor.

: : Regards,

: : Peter


 
***************** End Of Article ****************** 
 
Krish posted Message 492 in Message Board 
 
Dated  : July 25, 2001 at 04:24:30 EST
Subject: Re: Crystal on Web
 
From where can I download Crystal Reports Server
 
***************** End Of Article ****************** 
 
Hugo Rivera posted Message 493 in Message Board 
 
Dated  : July 25, 2001 at 18:48:53 EST
Subject: SQR 4.3.2 running in NT workstation 4
 
Hello, has any body had a compare problem in SQR v 4.3.2 when running in Windows NT workstation 4, SQR&#8217;s that run perfectly in Windows 95 or in Unix, seems that NT is using all dates as character. We enforced the WHERE clauses with a TO_DATE( var ) function and worked, but like to know if there is a FIX.

Any help will be appreciated,
Thanks in advance 

 
***************** End Of Article ****************** 
 
ramya posted Message 494 in Message Board 
 
Dated  : July 27, 2001 at 15:18:51 EST
Subject:  what are steps for testing
 
i'm doing in a sample application with insert action commands basically what are tests to be done given a new application.
some one please help me
 
***************** End Of Article ****************** 
 
Asha posted Message 495 in Message Board 
 
Dated  : July 28, 2001 at 17:07:18 EST
Subject: Transfering data from access database to flatfiles using sqr
 
Hi All,

Please advice me how to  transfer data from access database to flat files using SQRv6.0. and I should be able to run this from PeopleSoft .Is it possible. ?


Thanks in advance
 
***************** End Of Article ****************** 
 
Asha posted Message 496 in Message Board 
 
Dated  : July 28, 2001 at 17:07:38 EST
Subject: Transfering data from access database to flatfiles using sqr
 
Hi All,

Please advice me how to  transfer data from access database to flat files using SQRv6.0. and I should be able to run this from PeopleSoft .Is it possible. ?


Thanks in advance
 
***************** End Of Article ****************** 
 
Gerry Yon posted Message 497 in Message Board 
 
Dated  : August 01, 2001 at 08:51:11 EST
Subject: Re: SQR Viewer
 
: Where can I find a good SQR viewer?  

There is one from scribe delivered with Peoplesoft.  Look for sqrwv.exe. Or don't you consider this to be a good viewer?
 
***************** End Of Article ****************** 
 
Ravi posted Message 498 in Message Board 
 
Dated  : August 01, 2001 at 14:43:39 EST
Subject: Invoking a Template through SQR
 
Hi,
I need to know If Is there any chance of invoking the Excel template through the SQR running through WEB.

Thanks

 
***************** End Of Article ****************** 
 
Sivaram posted Message 499 in Message Board 
 
Dated  : August 03, 2001 at 10:07:51 EST
Subject: Re: Invoking a Template through SQR
 
Hi, Could you tell me what exactly are you looking at. Do you want to populate some data to the Excel template ? 

: Hi,
: I need to know If Is there any chance of invoking the Excel template through the SQR running through WEB.

: Thanks


 
***************** End Of Article ****************** 
 
Sivaram posted Message 500 in Message Board 
 
Dated  : August 03, 2001 at 10:12:51 EST
Subject: Re: Transfering data from access database to flatfiles using sqr
 
Hi, There are 2 ways.

1. You can access the MS acces database directly through sqr and write into a flat file.


2. Use MS Access import /export tools built in.

Hope it help.


: Hi All,

: Please advice me how to  transfer data from access database to flat files using SQRv6.0. and I should be able to run this from PeopleSoft .Is it possible. ?

: 
: Thanks in advance


 
***************** End Of Article ****************** 
 
Sivaram posted Message 501 in Message Board 
 
Dated  : August 03, 2001 at 10:18:53 EST
Subject: Re: printing problem
 
Did you specify the -o option  ?

: hi 

: i keep getting this message when i print sqr reports
: "(SQR 4717) Cannot open the report output file: 'lpt1' (13): permission denied."

: the printer in connected directly to my lpt port. and if i reboot, i do get to print the sqr reports .. just for a while. then i'll get the message above.

: please help.
: thank you


 
***************** End Of Article ****************** 
 
theo sanders posted Message 502 in Message Board 
 
Dated  : August 03, 2001 at 11:03:29 EST
Subject: Re: Crystal 7.0 enabling ASP wen reports(Active X viewer)
 
: : I loaded Crystal Reports 7.0 w/ the ASP Reports component on an Windows NT IIS4.0 server. If I type in the web address to the asp page using the browser on the server, the report loads with an active x interface (pERFECT:) But when I go to a client machine and type in the address it loads a gray page with a missing image where the active x reports should be.. For some reason the viewer is not making it to the client machine. The client machine is running IE 5.0. Any help would be greatly appreciated.. Thanks..


 
***************** End Of Article ****************** 
 
Chanchal Jayant posted Message 503 in Message Board 
 
Dated  : August 06, 2001 at 01:38:47 EST
Subject: Re: Crystal Report Error
 
: I'm creating a new crystal report that combines several queries in sub reports. The report works well in the Crystal Report application, but i want to change the numeric field into the Alpabetic like 23 = twenty three
same as date format alse
pl help me 
bye

Thks for any help!


 
***************** End Of Article ****************** 
 
sujtih posted Message 504 in Message Board 
 
Dated  : August 06, 2001 at 15:33:08 EST
Subject: Re: PeopleTools and SQR
 
: : pl. send me your email ID i will forward my C.V.
: : here also  i am sending C.V.

: : 
: : CURRICULUM VITAE
: : S.L.S.N.V.V.S.SUDHAKAR
: : FLAT# 103
: : SREE APARTMNTS
: : Srinivasa Colony(West)
: : Hyderabad
: : A.P.,
: : INDIA.
: : Phone : +91(40) 3319358,3540739 (Off)
: :                +91(40)3738007®

: : E-mail : lokeshsanku@hotmail.com

: : Professional Summary	:Seeking for a good opportunuty by having  three years  Of experience in Software development and , Functional Experience including hiring ativity for a MNC. Well versed client-server environment and ERP Systems.

: : Education	: Bachelors Degree in Engineering From Andhra University, 
: :                   Vishakapatnam (1996)
: : Skills Inventory:
: :                	GUI			:  Developer2000(Developed Systems)
: :               	Operating Systems  	:  M S-DOS , Windows ( 3.x, 95,NT 								      4.0) 
: :  		Languages 		: C , Visual Basic 5.0 
: : 		OOPS          		:  C++, JAVA	
: :                	RDBMS                  	: Oracle 7.x,MS-Access
: :                	Hardware      		: Pentium
: : 		ERP                     : People Soft  7.5 (HRMS  Module)
: :                 WEB Technologies        : HTML,VBSCRIPT,ASP
: : 		
: : Professional Experience:
: : Working as Programmer Analyst with CODELINKS DATA SERVICES PVT. LTD from Oct'99.
: : Worked as Programmer Analyst in CODELINKS DATA SERVICES PVT. LTD  As a 
: : Peoplesoft Consultant on behalf of CAREER PROFILES from June'99.
: : Worked as a HR Executive in CAREER PROFILES from Feb'99 to May'99.
: : Worked as Software Engineer in Pragma Technical Solutions  Ltd from Sep'96 to Feb'99.

: : Projects Summary : 

: : #1 Project:
: :    Project Name        :   SQR Reports Development
: :   Client               :   Conseco Inc , USA
: :   Role                 :   Leading the team,Analysis,
: :                            Testing and Documentation

: : Project Description :

: : 	This project is basically to generate SQR reports as per 
: :  the requirement of the Client in the HR module.This project has
: :  started on 20th of June '99 and the target date of completion is
: :  December 31st '99.  
: :  The reports generated in this project are categorized into three 
: :  types as below, 

: : A. HR day to day data related reports, some of them are as follows,
: :         PERTERNA.SQR   - Terminations processed name wise
: :  	PERECLIS .SQR  - Emergency Contact List
: :  	PER401KH .SQR  - 401k New Hire Listing etc.	
: :         B1068.SQR      - Overtime report.
: :     
: : B. Database comparison reports, which compares the data present in
: :    two similar databases. These reports are generalised reports,
: :    which should work for any table. some of them are as follows,

: :         GENCOMP1&2.SQR  - Data present in first database and not present
: :                           in another database.
: :         GENCOMP3,4,5.SQR - These are to compare Key,Xlat,Non xlat fields 
: :                            data present in both the databases.
: : C. Interface reports. The purpose of these reports is to generate flat 
: :    files by fetching data from HRsystem database, and the flat files
: :    generated are used to import data into third party tools.Another type
: :    of reports are to insert data into Hr database by reading from flat 
: :    files generated by the third party tools.Some of them are as below,

: :         CIGNA.SQR   -  Outgoing from HRsystem & in coming to CIGNA system
: :         TPA.SQR     -  Outgoing from HRsystem & in coming to TPA system
: :         BVUPDATE.SQR-  Outgoing from BVsystem & in coming to HRsystem

: : #2 Project: Hiring Activity

: : Client  : CODELINKS DATA SERVICES PVT LTD
: : Team Size : 3
: : Duration  : Feb'99  to May'99

: : Description:  We Recruited Employees belonging to various areas for a multi
: : national company.
: : It contains three phases
: : 1)Resume Collection and Screening: We Collected Resumes from the principal
: :   company and screened those on the basis of Skill set and experience.

: : 2) Conducting Interveiws: We arrranged the interviews for all qualified 
: :    candidates in each area depends on requirment of the principal company.

: : 3) Taking reference checks and feed back from company: After conducting 
: :    the interview in our company we send to principal company after all
: :    completing all necessary checks and we will take the feed back from
: :    the pricipal company about each and every candidate.

: : 
: : #3) Project 

: : Project title 		:       Marketing Plan Automation
: : Client 			:  	KayJay Industries Ltd , Hyderabad
: : Duration 		:   	From Jan'98 to Apr'98
: : Team size               :   	Eight
: : Software environment    :   	Visual Basic 5.0, MS-SQL Server 6.5 ,Windows 				NT 4.0

: : Role                    :   	complete project Front -end design,coding , 
: : 				interactionWith team members and 
: : 				contributing ideas .

: : This is to automate the Marketing functions of a Pharmaceutical company
: :  operating its business in South India. This Projects mainly categorized 
: : into several modules namely maintenance of code tables, Customer data, 
: : Stockiest ,Super-stockiest ,Customer Order, Activity of business development
: :  Manager and Business development Executive,Product information, Market 
: : intelligence Sales, Advertising and Promotion, Market plan,Writing Context 
: : sensitive and Content Help, Generating Various types of reports based on 
: : information provided by various levels of its employees and all types of 
: : customers.

: : The Project captures and updates customer, product, fields sales person's 
: : data, customer order, sales-region & state wise, Advertising and promotion
: : using SQL -Server as backend and Visual Basic 5.0 as front -end 
: : Features employed: Remote Data Objects (RDO), DDE, OLE, developed Active X
: :  control, Farpoint Spread sheet control , SS Tab, Crystal Reports, Help 
: : Compiler Workshop.

: : #4) Project:
: : Project title 		: Automation of Departmental  Stores
: : Client 			: Lakshmi supermarket, Hyderabad     
: : Duration 		: From Jun'97 to Nov'97
: : Team size		: Three 
: : Software environment	: Visual Basic 5.0, MS-Access2.0, and Windows NT 4.0
: : Role 			: As Programmer Complete project Front -end design,
: : 			  coding,Interaction with team members and 
: :                           contributing ideas.
: : This is a Generalized package of Complete  Sales and Inventory can keep 
: : track of  various day to day sales activity like checking inventory ,billing
: :  and generating various reports meeting order requirements ,order placements,
: :  checking financial status of the company at any time or for a given time 
: : range etc., The  Project Mainly  Consists of the following five modules 
: : namely  Customer Information, Billing, Check Order, Inventory, Generation of
: :  Various Reports- Customer Information,,item code, item description the
: :  above information is added to the database ,the Billing deals with  price 
: : billing that is given to the customer who purchase the commodities from the
: :   stores.  The information is automatically gets in transaction with the
: :  database to query on to get the inventory status. The Inventory module 
: : keeps account of input and output of the stores commodities. The report 
: : module consists of daily, weekly, monthly, yearly information of sales and 
: : stock particulars.

: : #5) Project: 
: : Project title 		: Automation of Electrical Power Reading
: : Client 			: ECE Industries ,Hyderabad     
: : Duration 		: From  Jan'97 to May'97
: : Team size		: Three
: : Software environment	: Tubo C,Windows 95
: : Role 			: As Programmer  in design,  coding , andinteraction
: :                           with team members and contributing ideas.
: : This is a Generalized package consisting of coplete automation to read 
: : Electrical Meter Reading From any Electric meter. There are Two steps 
: : invoved in this process.  First Read meter reading from meter to H.H.U. ,
: : then From H.H.U. to Base Computer.  While Accessing data from meter to H.H.U.
: :  or H.H.U. to Computer some protocals are there. So in this project we design
: :  to access the data from H.H.U. to Computer Depends on Existing Protocals.

: : 
: : CASE STUDIES IN ERP:
: : CASE  STUDY - 1
: : Feasibility Study of Implementing ERP  In Banking Industry
: : A Leading Co-Operative Bank having branches all over state of Andhra Pradesh is in the process of large-scale computerization of its operations.  This bank has got about 9 branches which are reporting to its head office at Hyderabad.  Presently all the operations of the bank are being carried out manually.  The team consists of 5 members, who are highly experienced in the software field, has undertaken a detailed case study based on the client's requirement with regard to information, Data security and integrity.  The conclusion that emerges out of the above case study that ERP especially People Soft is highly suitable and feasible for this particular Business concern, though extensive customization and design is required.  A sample application comprising of panels like Bank master, Transaction master, Recurring Deposit master, F.D. master and reports like transaction entry, customer wise and Fixed deposit and R.D. reports. Extensive validations are carried out using people code.

: : CASE STUDY - 2
: : Student Administration
: : A Case study was conducted for one of the most popular Junior College in the twin cities with a team comprising of 5 members.
: : This Junior College has got student strength of about 5,000 students.  Presently they are maintaining their records in FoxPro. It is found that the reports & maintenance of student Data is highly unorganized, unstructured and inadequate with this system.  Based on the extensive case study and with many rounds of discussions with the management of the college, it has been found that an ERP like People Soft though a little bit expensive can go a long way in the proper management, reporting and maintenance of student Data.  The management is convinced with the Case Study and is on the lookout for a suitable software package.  A sample student administration was built comprising of panels like student master, student details, course details, enrollment details, etc.  Extensive validations were performed using people code for this application.  The Client is satisfied with the sample application in all respects.

: : CASE STUDY - 3
: : Student Data
: : The Project mainly aims at maintaining records for course sessions available, course details, available instructors lists, no. of students enrolled, students joined and their evaluation details. This also maintains customer details. It consists of 8 Record Definitions and 6 Panels incorporating Sub-panels and Secondary panels at the required stages. Writing People code for generation of student Ids, Course codes and Instructor Ids.  Assigning particular Instructors for student Ids etc., changing any particular data through Mass Change and generating final passed out student records.

: : CASE STUDY - 4
: : Demographic Analysis For India
: : The study is developed using People Soft 6.0 to produce complete information about State wise population, area of land, area of cultivated land, area of forests and the basic needs like drinking water availability, sanitation, hospitals etc. The case study utilizes Data Designer, scroll level settings to retrieve master details and effective dated functions, Panel Designer, Menu Designer, Operator Security and People Code. Finally Business process map is developed using activity map, step map and message agent.
: :    

: : Personal Details		:		
: : Date of Birth			: 21st Oct 1975
: : Marital Status		        : Unmarried
: : Passport Details		:
: : Passport No.                    : A543943 
: : Place of issue			: Vishakapatnam
: : Date of issue			: 1 June 1998
: : Date of Expiry		        : 31 May 2008

: : : I have a permanent opening in Tampa, FL for a PeopleSoft Developer with experience in PeopleTools and SQR. If you can refer someone we will pay you $1200.00 if they are hired.
: : : Thank You


 
***************** End Of Article ****************** 
 
Jagadish posted Message 505 in Message Board 
 
Dated  : August 07, 2001 at 16:49:26 EST
Subject: Re: Crystal AP checks
 
It is not problem with registry setting when she could run other crsytal reports. Check the run control which is being used for check printing and ensure that the output destination is file/printer. If it is file then check it will be usually in C;\temp. If it is printer, then u need to make default printer as LPT1 and specify LPT1 as output destination.
 
***************** End Of Article ****************** 
 
Eugenia Lara posted Message 506 in Message Board 
 
Dated  : August 13, 2001 at 10:00:41 EST
Subject: Vision
 
How can Visio open a Template when it create a chart from a text file?.
 
***************** End Of Article ****************** 
 
Don posted Message 507 in Message Board 
 
Dated  : August 14, 2001 at 15:00:12 EST
Subject: Crystal Reports shuts down Psoft application
 
We have a workstation specific problem where, no matter who is signed on to the network, if a crystal report is run to a window through the process scheduler, the crystal runtime window and the peoplesoft application shut down. Again, this is specific to the workstation, not the user. We are running NT clients against a DB2 database. This problem occurs on both 2- and 3-tier connections. Any input would be gratefully accepted.

Thanks in Advance...
 
***************** End Of Article ****************** 
 
James posted Message 508 in Message Board 
 
Dated  : August 15, 2001 at 14:11:00 EST
Subject: Re: Crystal Reports shuts down Psoft application
 
What version tools?  How much memory on the workstation?


 
***************** End Of Article ****************** 
 
Priya posted Message 509 in Message Board 
 
Dated  : August 18, 2001 at 06:17:46 EST
Subject: Change of column header dynamically in COGNOS REPORT
 
Hi,

I want to change column header programmatically in VB. I am using COGNOS product Impromptu 6.0 .Is there any method to change column header?

Please help.
Thanks,
Priya
 
***************** End Of Article ****************** 
 
ric posted Message 510 in Message Board 
 
Dated  : August 19, 2001 at 21:28:41 EST
Subject: Re:  can you pass VB recordset to Crystal Reports?????
 
: I want to use recordset from a VB client to dynamically generate a crystal report from a template. Please tell us how we will do it???


Dim Report As New CrystalReport1
Dim rs As New ADOR.Recordset

Private Sub Form_Load()
Screen.MousePointer = vbHourglass

rs.Open "Select * from customer where (country = 'USA') and ([last year's sales] > 25000)", _
        "xtreme sample database"


Report.Database.SetDataSource rs, 3, 1
With CRViewer1
    .ReportSource = Report
    .Zoom 100
    .EnableExportButton = True
    .DisplayGroupTree = False
    .ViewReport
End With

Screen.MousePointer = vbDefault

End Sub

 
***************** End Of Article ****************** 
 
Kunjal  posted Message 511 in Message Board 
 
Dated  : August 20, 2001 at 00:03:37 EST
Subject: Cognos Impromptu: is there a way to pass prompts to subreports ?
 
:I've got the following problem:

: Consider a main report printing data from a "main" query that has some prompts. 

: Now, I want to add a subreport that is based on a "sub-query". No problem if the sub-query doesn't have prompts.

: But if I want to use prompts in my subquery, I'm asked to enter them at runtime.

: My question is: is there a way to pass these parameters from the main report to the subquery ? 

: Thanks for help.

 
***************** End Of Article ****************** 
 
Rishu chopra posted Message 512 in Message Board 
 
Dated  : August 20, 2001 at 03:52:59 EST
Subject: Re: can you pass VB dao recordset to Crystal Reports?????
 
I have a data grid attached to an access database. I created a combo box
and filled it. I attached the combo box to the current field in the grid
so that when you click on a field in column one the combo box list opens
up and allows you to select from a list. I am using ADO and Microsoft Jet
4.0. My question is, how do I get the selected data from the list to
update the field in the data grid?

 
***************** End Of Article ****************** 
 
Don posted Message 513 in Message Board 
 
Dated  : August 20, 2001 at 16:00:51 EST
Subject: Re: Crystal Reports shuts down Psoft application
 
: What version tools?  How much memory on the workstation?

We are running Tools v7.60. The workstation has 64MB RAM
 
***************** End Of Article ****************** 
 
J. Neil posted Message 514 in Message Board 
 
Dated  : August 21, 2001 at 16:22:47 EST
Subject: Re: running an sqr report directly to a printer
 
I fixed this problem in PeopleSoft. Look in the Process Scheduler definition, under the Process Definition Options, SQR Flags... should be none. If it is append... it is wrong.


: I'm trying to run an sqr report from the process scheduler.  I input data into my run control and then attempt to direct the report to my network printer by selecting server as the run location and printer as the output destination.  I set file/printer value to \\printserver\printname.  All of this results in an error from sqr that is saying that the .spf file can not be found.  I'm only creating a .lis file and I don't want to create a .spf file.  Does anyone know how I can simply direct this sqr to print the .lis to the designated network printer?

: Thanks in advance,
: Mark H.


 
***************** End Of Article ****************** 
 
CIBRES.COM posted Message 515 in Message Board 
 
Dated  : August 21, 2001 at 23:02:18 EST
Subject: Business Ethics for the ERP Industry 
 
Business Ethics for the ERP Industry 

Is the feature article this month on CIBRES.COM

Learn how consultants and ERP service providers bend the rules and break ethics in this unique ground breaking article. 

It may be viewed online at www.cibres.com

 
***************** End Of Article ****************** 
 
dr.sarma posted Message 516 in Message Board 
 
Dated  : August 23, 2001 at 04:18:33 EST
Subject: Re: PeopleTools and SQR
 
: : : pl. send me your email ID i will forward my C.V.
: : : here also  i am sending C.V.

: : : 
: : : CURRICULUM VITAE
: : : S.L.S.N.V.V.S.SUDHAKAR
: : : FLAT# 103
: : : SREE APARTMNTS
: : : Srinivasa Colony(West)
: : : Hyderabad
: : : A.P.,
: : : INDIA.
: : : Phone : +91(40) 3319358,3540739 (Off)
: : :                +91(40)3738007®

: : : E-mail : lokeshsanku@hotmail.com

: : : Professional Summary	:Seeking for a good opportunuty by having  three years  Of experience in Software development and , Functional Experience including hiring ativity for a MNC. Well versed client-server environment and ERP Systems.

: : : Education	: Bachelors Degree in Engineering From Andhra University, 
: : :                   Vishakapatnam (1996)
: : : Skills Inventory:
: : :                	GUI			:  Developer2000(Developed Systems)
: : :               	Operating Systems  	:  M S-DOS , Windows ( 3.x, 95,NT 								      4.0) 
: : :  		Languages 		: C , Visual Basic 5.0 
: : : 		OOPS          		:  C++, JAVA	
: : :                	RDBMS                  	: Oracle 7.x,MS-Access
: : :                	Hardware      		: Pentium
: : : 		ERP                     : People Soft  7.5 (HRMS  Module)
: : :                 WEB Technologies        : HTML,VBSCRIPT,ASP
: : : 		
: : : Professional Experience:
: : : Working as Programmer Analyst with CODELINKS DATA SERVICES PVT. LTD from Oct'99.
: : : Worked as Programmer Analyst in CODELINKS DATA SERVICES PVT. LTD  As a 
: : : Peoplesoft Consultant on behalf of CAREER PROFILES from June'99.
: : : Worked as a HR Executive in CAREER PROFILES from Feb'99 to May'99.
: : : Worked as Software Engineer in Pragma Technical Solutions  Ltd from Sep'96 to Feb'99.

: : : Projects Summary : 

: : : #1 Project:
: : :    Project Name        :   SQR Reports Development
: : :   Client               :   Conseco Inc , USA
: : :   Role                 :   Leading the team,Analysis,
: : :                            Testing and Documentation

: : : Project Description :

: : : 	This project is basically to generate SQR reports as per 
: : :  the requirement of the Client in the HR module.This project has
: : :  started on 20th of June '99 and the target date of completion is
: : :  December 31st '99.  
: : :  The reports generated in this project are categorized into three 
: : :  types as below, 

: : : A. HR day to day data related reports, some of them are as follows,
: : :         PERTERNA.SQR   - Terminations processed name wise
: : :  	PERECLIS .SQR  - Emergency Contact List
: : :  	PER401KH .SQR  - 401k New Hire Listing etc.	
: : :         B1068.SQR      - Overtime report.
: : :     
: : : B. Database comparison reports, which compares the data present in
: : :    two similar databases. These reports are generalised reports,
: : :    which should work for any table. some of them are as follows,

: : :         GENCOMP1&2.SQR  - Data present in first database and not present
: : :                           in another database.
: : :         GENCOMP3,4,5.SQR - These are to compare Key,Xlat,Non xlat fields 
: : :                            data present in both the databases.
: : : C. Interface reports. The purpose of these reports is to generate flat 
: : :    files by fetching data from HRsystem database, and the flat files
: : :    generated are used to import data into third party tools.Another type
: : :    of reports are to insert data into Hr database by reading from flat 
: : :    files generated by the third party tools.Some of them are as below,

: : :         CIGNA.SQR   -  Outgoing from HRsystem & in coming to CIGNA system
: : :         TPA.SQR     -  Outgoing from HRsystem & in coming to TPA system
: : :         BVUPDATE.SQR-  Outgoing from BVsystem & in coming to HRsystem

: : : #2 Project: Hiring Activity

: : : Client  : CODELINKS DATA SERVICES PVT LTD
: : : Team Size : 3
: : : Duration  : Feb'99  to May'99

: : : Description:  We Recruited Employees belonging to various areas for a multi
: : : national company.
: : : It contains three phases
: : : 1)Resume Collection and Screening: We Collected Resumes from the principal
: : :   company and screened those on the basis of Skill set and experience.

: : : 2) Conducting Interveiws: We arrranged the interviews for all qualified 
: : :    candidates in each area depends on requirment of the principal company.

: : : 3) Taking reference checks and feed back from company: After conducting 
: : :    the interview in our company we send to principal company after all
: : :    completing all necessary checks and we will take the feed back from
: : :    the pricipal company about each and every candidate.

: : : 
: : : #3) Project 

: : : Project title 		:       Marketing Plan Automation
: : : Client 			:  	KayJay Industries Ltd , Hyderabad
: : : Duration 		:   	From Jan'98 to Apr'98
: : : Team size               :   	Eight
: : : Software environment    :   	Visual Basic 5.0, MS-SQL Server 6.5 ,Windows 				NT 4.0

: : : Role                    :   	complete project Front -end design,coding , 
: : : 				interactionWith team members and 
: : : 				contributing ideas .

: : : This is to automate the Marketing functions of a Pharmaceutical company
: : :  operating its business in South India. This Projects mainly categorized 
: : : into several modules namely maintenance of code tables, Customer data, 
: : : Stockiest ,Super-stockiest ,Customer Order, Activity of business development
: : :  Manager and Business development Executive,Product information, Market 
: : : intelligence Sales, Advertising and Promotion, Market plan,Writing Context 
: : : sensitive and Content Help, Generating Various types of reports based on 
: : : information provided by various levels of its employees and all types of 
: : : customers.

: : : The Project captures and updates customer, product, fields sales person's 
: : : data, customer order, sales-region & state wise, Advertising and promotion
: : : using SQL -Server as backend and Visual Basic 5.0 as front -end 
: : : Features employed: Remote Data Objects (RDO), DDE, OLE, developed Active X
: : :  control, Farpoint Spread sheet control , SS Tab, Crystal Reports, Help 
: : : Compiler Workshop.

: : : #4) Project:
: : : Project title 		: Automation of Departmental  Stores
: : : Client 			: Lakshmi supermarket, Hyderabad     
: : : Duration 		: From Jun'97 to Nov'97
: : : Team size		: Three 
: : : Software environment	: Visual Basic 5.0, MS-Access2.0, and Windows NT 4.0
: : : Role 			: As Programmer Complete project Front -end design,
: : : 			  coding,Interaction with team members and 
: : :                           contributing ideas.
: : : This is a Generalized package of Complete  Sales and Inventory can keep 
: : : track of  various day to day sales activity like checking inventory ,billing
: : :  and generating various reports meeting order requirements ,order placements,
: : :  checking financial status of the company at any time or for a given time 
: : : range etc., The  Project Mainly  Consists of the following five modules 
: : : namely  Customer Information, Billing, Check Order, Inventory, Generation of
: : :  Various Reports- Customer Information,,item code, item description the
: : :  above information is added to the database ,the Billing deals with  price 
: : : billing that is given to the customer who purchase the commodities from the
: : :   stores.  The information is automatically gets in transaction with the
: : :  database to query on to get the inventory status. The Inventory module 
: : : keeps account of input and output of the stores commodities. The report 
: : : module consists of daily, weekly, monthly, yearly information of sales and 
: : : stock particulars.

: : : #5) Project: 
: : : Project title 		: Automation of Electrical Power Reading
: : : Client 			: ECE Industries ,Hyderabad     
: : : Duration 		: From  Jan'97 to May'97
: : : Team size		: Three
: : : Software environment	: Tubo C,Windows 95
: : : Role 			: As Programmer  in design,  coding , andinteraction
: : :                           with team members and contributing ideas.
: : : This is a Generalized package consisting of coplete automation to read 
: : : Electrical Meter Reading From any Electric meter. There are Two steps 
: : : invoved in this process.  First Read meter reading from meter to H.H.U. ,
: : : then From H.H.U. to Base Computer.  While Accessing data from meter to H.H.U.
: : :  or H.H.U. to Computer some protocals are there. So in this project we design
: : :  to access the data from H.H.U. to Computer Depends on Existing Protocals.

: : : 
: : : CASE STUDIES IN ERP:
: : : CASE  STUDY - 1
: : : Feasibility Study of Implementing ERP  In Banking Industry
: : : A Leading Co-Operative Bank having branches all over state of Andhra Pradesh is in the process of large-scale computerization of its operations.  This bank has got about 9 branches which are reporting to its head office at Hyderabad.  Presently all the operations of the bank are being carried out manually.  The team consists of 5 members, who are highly experienced in the software field, has undertaken a detailed case study based on the client's requirement with regard to information, Data security and integrity.  The conclusion that emerges out of the above case study that ERP especially People Soft is highly suitable and feasible for this particular Business concern, though extensive customization and design is required.  A sample application comprising of panels like Bank master, Transaction master, Recurring Deposit master, F.D. master and reports like transaction entry, customer wise and Fixed deposit and R.D. reports. Extensive validations are carried out using people code.

: : : CASE STUDY - 2
: : : Student Administration
: : : A Case study was conducted for one of the most popular Junior College in the twin cities with a team comprising of 5 members.
: : : This Junior College has got student strength of about 5,000 students.  Presently they are maintaining their records in FoxPro. It is found that the reports & maintenance of student Data is highly unorganized, unstructured and inadequate with this system.  Based on the extensive case study and with many rounds of discussions with the management of the college, it has been found that an ERP like People Soft though a little bit expensive can go a long way in the proper management, reporting and maintenance of student Data.  The management is convinced with the Case Study and is on the lookout for a suitable software package.  A sample student administration was built comprising of panels like student master, student details, course details, enrollment details, etc.  Extensive validations were performed using people code for this application.  The Client is satisfied with the sample application in all respects.

: : : CASE STUDY - 3
: : : Student Data
: : : The Project mainly aims at maintaining records for course sessions available, course details, available instructors lists, no. of students enrolled, students joined and their evaluation details. This also maintains customer details. It consists of 8 Record Definitions and 6 Panels incorporating Sub-panels and Secondary panels at the required stages. Writing People code for generation of student Ids, Course codes and Instructor Ids.  Assigning particular Instructors for student Ids etc., changing any particular data through Mass Change and generating final passed out student records.

: : : CASE STUDY - 4
: : : Demographic Analysis For India
: : : The study is developed using People Soft 6.0 to produce complete information about State wise population, area of land, area of cultivated land, area of forests and the basic needs like drinking water availability, sanitation, hospitals etc. The case study utilizes Data Designer, scroll level settings to retrieve master details and effective dated functions, Panel Designer, Menu Designer, Operator Security and People Code. Finally Business process map is developed using activity map, step map and message agent.
: : :    

: : : Personal Details		:		
: : : Date of Birth			: 21st Oct 1975
: : : Marital Status		        : Unmarried
: : : Passport Details		:
: : : Passport No.                    : A543943 
: : : Place of issue			: Vishakapatnam
: : : Date of issue			: 1 June 1998
: : : Date of Expiry		        : 31 May 2008

: : : : I have a permanent opening in Tampa, FL for a PeopleSoft Developer with experience in PeopleTools and SQR. If you can refer someone we will pay you $1200.00 if they are hired.
: : : : Thank You


 
***************** End Of Article ****************** 
 
MM posted Message 517 in Message Board 
 
Dated  : August 23, 2001 at 04:31:24 EST
Subject: Integrating PeopleSoft at the application layer/business logic level with ERP ...
 
Greetings,

I have an integration server that can send and receive XML documents and can use SOAP. Does PeopleSoft have any connector (like ERP SAP's XML business connector) to integrate at the application layer/business logic level?

Thanks,
MM.
 
***************** End Of Article ****************** 
 
Jessica posted Message 518 in Message Board 
 
Dated  : August 23, 2001 at 09:26:54 EST
Subject: Re: Crystal AP checks
 
What kind of configuration must be set up so that we can specify LPT1 as output destination instead of the printer name?

: It is not problem with registry setting when she could run other crsytal reports. Check the run control which is being used for check printing and ensure that the output destination is file/printer. If it is file then check it will be usually in C;\temp. If it is printer, then u need to make default printer as LPT1 and specify LPT1 as output destination.


 
***************** End Of Article ****************** 
 
Alice Dewijn posted Message 519 in Message Board 
 
Dated  : August 23, 2001 at 17:31:35 EST
Subject: Crystal Reports with Date Parameters
 
When I try to run a Crystal with date parameters from a peoplesoft panel, the PS Crystal Run-time task diplays on the Windows task bar and the Crystal viewer window appears briefly, then disappears.  The following message appears in the message log in Process Monitor:
Crystal Reports Print Engine error text: Error detected by database DLL.  
Note:  I only seem to get this problem when running a report with date parameters.  If the report does not contain date parameters, the process works fine.

 
***************** End Of Article ****************** 
 
srini posted Message 520 in Message Board 
 
Dated  : August 24, 2001 at 16:14:17 EST
Subject: Re: SQA Robot
 
I am working on an integration project which has the data coming and going out from the mainframe to the sqlserver db.
Mainframe-Mq Series-Mercator-SqLserver. I would like to know
how to test using automated testing tool SQA Robot. I would 
also like to know is SQAR compatible to the above software.
If it is not supported how do we test it? I am planning for 
manual testing but I think it is very difficult down the road 
as we are getting more and more coming sooner. I would like
to get your help ASAP.
Best regards,
Srini






 
***************** End Of Article ****************** 
 
David Collins posted Message 521 in Message Board 
 
Dated  : August 27, 2001 at 10:25:44 EST
Subject: I am making a list of companies using Peoplesoft
 
I am making a list of companies using Peoplesoft
 
I am going to develop a marketing list of all companies using Peoplesoft. The purpose is to allow PS Consultants to deal directly with companies as opposed to agencies/recruiters. Please email me names of companies that use PS along with any other details you know like:

Industry, sales size, location, address, contact details, etc. 

Try to submit complete details on company. Anyone that submits at least 1-5 complete company details can have access to the info I gather.

All I want to do is collect and share the data. I will do all the work and as the database grows and I collect more details, contact me and I will run free queries for you (i.e. if you ask me what companies in California or Ireland use PS I will email you a list). 

Please contribute. I expect to have initial listing in a month as I am right now receiving about 50 names per month so I can expect to have a good size list by a another month or two. 

David Collins
Peoplesoft Consultant
Dublin, Ireland
wdavid_collins@email.com 



 
***************** End Of Article ****************** 
 
David Collins posted Message 522 in Message Board 
 
Dated  : August 27, 2001 at 10:35:48 EST
Subject: I am making a list of companies using Peoplesoft
 
I am making a list of companies using Peoplesoft
 
I am going to develop a marketing list of all companies using Peoplesoft. The purpose is to allow PS Consultants to deal directly with companies as opposed to agencies/recruiters. Please email me names of companies that use PS along with any other details you know like:

Industry, sales size, location, address, contact details, etc. 

Try to submit complete details on company. Anyone that submits at least 1-5 complete company details can have access to the info I gather.

All I want to do is collect and share the data. I will do all the work and as the database grows and I collect more details, contact me and I will run free queries for you (i.e. if you ask me what companies in California or Ireland use PS I will email you a list). 

Please contribute. I expect to have initial listing in a month as I am right now receiving about 50 names per month so I can expect to have a good size list by a another month or two. 

David Collins
Peoplesoft Consultant
Dublin, Ireland
wdavid_collins@email.com 



 
***************** End Of Article ****************** 
 
mallik posted Message 523 in Message Board 
 
Dated  : August 31, 2001 at 01:17:49 EST
Subject: Re: Running multiple versions of MF Cobol on the same Unix server
 
: We support PeopleSoft Financials (7.02) and Human Resources system (7.02). We run both systems across mulitple data base instances on both our development and production Unix servers.
: We are in the process of upgrading from MicroFocus (MF) 4.1 to MF Cobol Server Express 1.1 as part of upgrading our 
: PeopleSoft Humand Resources system to Rel 8. The Financials system will not be upgraded for quite some time to come.
: We are wondering; Is it possible to install MF Cobol Server Express 1.1 on the same server as MF 4.1? Can they
: run without interfering with each other? Have anyone encountered this issue before?
: Any help, information or references you can provide would be greatly appreciated!
: I thank you in advance.


 
***************** End Of Article ****************** 
 
Gerry Yon posted Message 524 in Message Board 
 
Dated  : September 04, 2001 at 16:20:04 EST
Subject: Version 8 COBOL compiler.
 
We (Kent County) have just begun upgrading our HP-UX version and Oracle version as a part of upgrading to Peoplesoft 8. When I look up supported platforms for our Financials 7.07 tools or our HR 7.59 tools, they list the COBOL compiler as HP COBOL B.13.25(Micro Focus 4.1). But in any of the Tools 8 platforms, the compiler is ServerExpress 2.0, does this mean I can no longer use the HP COBOL compiler on the Unix Box? If so, do I contact Merant or Peoplesoft to get the ServerExpress 2.0 compiler?

 
***************** End Of Article ****************** 
 
Rohit posted Message 525 in Message Board 
 
Dated  : September 05, 2001 at 18:50:22 EST
Subject: Crystal Engine
 
I have Crystal reports 8.5 installed on the application server which we recently upgraded to Win2000 advanced server from NT. The problem is that when I configure the report generation component (internally developed in ATL C++) on COM+, the print engine fails to open. Interestingly enough when this component is kept out of COM+, then it works just fine.
Any pointers would be helpful.
 
***************** End Of Article ****************** 
 
Dennis posted Message 526 in Message Board 
 
Dated  : September 06, 2001 at 16:33:49 EST
Subject: STAT!
 
We are looking at STAT! from Quest Software, for Change Management and Version Control.
I would like to talk to anyone is using / has used STAT!

How is it to work with?
Is it really useful?  
Is it worth the effort?
ROI?

Our Environment:
Peoplesoft Financial E&G 7.51
Peoplesoft HRMS E&G 7.51
Peoplesoft Budget module 8.x
Windows NT
MS-SQL Server 7.0

doleary@pps.k12.or.us




 
***************** End Of Article ****************** 
 
jaggu_1999@hotmail.com posted Message 527 in Message Board 
 
Dated  : September 12, 2001 at 10:43:22 EST
Subject: Re: Crystal Reports shuts down Psoft application
 
Hi There,
Check ur registry settings for current user and ensure that odbc.ini and crystal path pointing to the correct path that is specified in Configuration manger. 
 
***************** End Of Article ****************** 
 
suresh babu posted Message 528 in Message Board 
 
Dated  : September 13, 2001 at 07:39:56 EST
Subject: Re: msjter32.dll problem
 
: hi,i have this problem when startibg up my pc with win98, a window displaying "error launching msjter32.dll" due to not enoth
: memory?
: could anyone help pls?
: thanks


 
***************** End Of Article ****************** 
 
VENKATESH posted Message 529 in Message Board 
 
Dated  : September 13, 2001 at 08:27:17 EST
Subject:  How to i Can pass parameter in crystal report using visual basic 
 
: : 
: : How to i Can pass parameter in crystal report using visual basic ?

: : please tell me there is any way to supress a column on run time ?


 
***************** End Of Article ****************** 
 
test posted Message 530 in Message Board 
 
Dated  : September 14, 2001 at 17:56:06 EST
Subject: Re: Report Writers
 
s
 
***************** End Of Article ******************