You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

ExcelUploadforVoucher in 9.0 FSCM version

8 replies [Last post]
Venkataramani's picture
User offline. Last seen 1 year 47 weeks ago. Offline
Joined: 08/29/2008
Posts: 10

Hi ,

Have anyone tried the delivered feature of ExcelUploadforVoucher in 9.0 FSCM version?
When we tried to post the XML, its asking for the userid and password and we could nt able to trace which userid / password that is. We tried the node external userid / password and node default userid and password - none of them are working. Can anyone please throw light on this?

SJois's picture
SJois (not verified)
Re: ExcelUploadforVoucher in 9.0 FSCM version

For FSCM 9.0, VP1/VP1 will work.

Venkataramani's picture
User offline. Last seen 1 year 47 weeks ago. Offline
Joined: 08/29/2008
Posts: 10
Re: ExcelUploadforVoucher in 9.0 FSCM version

We tried with VP1/VP1 also, its not working. Could you please share the excel?

ashpick's picture
User offline. Last seen 5 years 2 weeks ago. Offline
Joined: 07/13/2009
Posts: 1
Re: ExcelUploadforVoucher in 9.0 FSCM version

if you still have this issue...

Please can you confirm what error you see.

Guest's picture
Guest (not verified)
Re: ExcelUploadforVoucher in 9.0 FSCM version

I tried VP1/VP1 too and got error 'Login was not successful. Please check your user id or password.'

raj_peoplesoft211's picture
Joined: 08/10/2011
Posts: 2
Re: ExcelUploadforVoucher in 9.0 FSCM version

Hi,

I don't know you find solution for this or not...anyway my suggestion..

Use User id/ Password which you are using for PIA login, In my excelspreadsheet it's not asking for userid and password, if you properly update for 'machine name, Integration Gatway, From node, To node and Generate URL' rows in the 'template' sheet for exceluploadforvoucher.

Click on this link once before try for upload, to check whether successfully connecting or not...

you can see the error message and reason for failed in navigation for this exceluploadforvoucher in : Integration broker -> Monitor Integration -> Message Details...

if your previous upload failed and in 'error' status...just calcel that in monitor message-> subcontracts page and try again..

Thanks
Rajendran Mariappan

Guest's picture
Guest (not verified)
Re: ExcelUploadforVoucher in 9.0 FSCM version

did you ever find out what the problem was with the login error you were receiving? i am having the same issue.

Amankalsi's picture
User offline. Last seen 2 years 40 weeks ago. Offline
Joined: 10/27/2011
Posts: 1
Re: ExcelUploadforVoucher in 9.0 FSCM version

Try this.

1. Make sure that Configuration Properties in IB Properties configuration file @ admin level are all setup correctly.

2. Go to Main Menu>>PeopleTools>>IB>>Configuration>>Gateways and open Local Gateway. Go to HTTPTARGET Connector ID's Properties link and see the PRIMARYURL value. This PRIMARYURL value must be same as that of PS Instance as "http://ServerURL:PortNumber/PSIGW/HttpListeningConnector"

3. Run ExceltoCi utility, if it shows error the open " http://ServerURL:PORT_number/PSIGW/errorLog.html "
in IE where ServerURl and Port Number should be for your Peoplesoft Instance for which you trying to upload Vouchers. See what the error is?

Guest's picture
Guest (not verified)
Re: ExcelUploadforVoucher in 9.0 FSCM version

Thanks for the response. I was able to get past the error. There were issues with the generated URL and the other link that's on the spreadsheet.

thank you.

Post new comment

The content of this field is kept private and will not be shown publicly.
CAPTCHA
The question below is to prevent automated spam submissions.
7 + 7 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.