PNC Bank connecting

Discussions about iCompta on macOS
Post Reply
fromage
Posts: 3
Joined: 30 August 2016, 00:31

PNC Bank connecting

Post by fromage » 30 August 2016, 00:45

I have a PNC Bank checking account that I would like to be able to download from automatically using OFX direct connect. After talking with PNC on the phone, they mailed me a PIN for use with Quicken or QuickBooks Direct Connect, and they said it should work with other software also, however I have not been able to get it to work and do not know what to enter into all of the boxes. Someone on the forum wrote about connecting to PNC back in 2012, but the iCompta screen has changed since then. Please help me as to what I need to enter to establish the connection. Thanks!
Attachments
Screen Shot 2016-08-29 at 6.25.51 PM.png
Screen Shot 2016-08-29 at 6.25.51 PM.png (79.5 KiB) Viewed 2110 times

User avatar
Angeman
Administrateur
Posts: 1924
Joined: 28 December 2008, 21:28
Location: Toulouse, France
Contact:

Re: PNC Bank connecting

Post by Angeman » 30 August 2016, 09:00

Enter PNC in the "Financial institution" search field and it will autocomplete several fields below. Then you'll have to enter your login and your PIN (= password) and click on "Connect and select accounts".

fromage
Posts: 3
Joined: 30 August 2016, 00:31

Re: PNC Bank connecting

Post by fromage » 31 August 2016, 02:36

Thanks for your quick response!

I tried following your instructions, and it says "Error. Login failed" with the details I have pasted below. I called PNC Bank and they told me they only troubleshoot for Quicken and Quickbooks. When I start typing in PNC, it automatically brings up "PNC Investments, LLC" which is the investment sector of the company for stocks, etc. Since I just have a checking account is there maybe something different for that regarding the "financial institution"?

I tried the URL you mentioned in your 2012 reply (https://www.oasis.cfree.com/test.ofxgp) along with Organization: ISC and Institution: 4501, but that didn't work either.


https://ofx.netxclient.com/cgi/OFXNetx

OFXHEADER:100
DATA:OFXSGML
VERSION:103
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE

<OFX>
<SIGNONMSGSRQV1>
<SONRQ>
<DTCLIENT>20160830202247.015[-04:EDT]
<USERID>***
<USERPASS>***
<GENUSERKEY>N
<LANGUAGE>ENG
<FI>
<ORG>PNC Investments, LLC
<FID>011
</FI>
<APPID>QWIN
<APPVER>2200
<CLIENTUID>CE96ED1A-0AFE-41E5-8A2A-23CD961932D7
</SONRQ>
</SIGNONMSGSRQV1>
<SIGNUPMSGSRQV1>
<ACCTINFOTRNRQ>
<TRNUID>45DDCA93-51B6-4545-8967-E7D2B9AF18C8
<ACCTINFORQ>
<DTACCTUP>19900101000000
</ACCTINFORQ>
</ACCTINFOTRNRQ>
</SIGNUPMSGSRQV1>
</OFX>

<html><body><h1>400: Bad Request</h1><p></p></html>

User avatar
Angeman
Administrateur
Posts: 1924
Joined: 28 December 2008, 21:28
Location: Toulouse, France
Contact:

Re: PNC Bank connecting

Post by Angeman » 31 August 2016, 09:51

Can you try with https://www.oasis.cfree.com/4501.ofxgp in "Server URL", nothing in "Organization" and 4501 in "Institution ID" ?

fromage
Posts: 3
Joined: 30 August 2016, 00:31

Re: PNC Bank connecting

Post by fromage » 01 September 2016, 02:13

Hmm. It still does not work. An internet search revealed that others have also had trouble with PNC Bank. I am using the login and password PNC mailed me, but one website said that the PIN (password) has to be changed using Quicken before it will work. Can you tell from the error details whether the problem is with the login/password or something else?

https://www.oasis.cfree.com/4501.ofxgp

OFXHEADER:100
DATA:OFXSGML
VERSION:103
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE

<OFX>
<SIGNONMSGSRQV1>
<SONRQ>
<DTCLIENT>20160831200856.505[-04:EDT]
<USERID>***
<USERPASS>***
<GENUSERKEY>N
<LANGUAGE>ENG
<FI>
<ORG>
<FID>4501
</FI>
<APPID>QWIN
<APPVER>2200
<CLIENTUID>D4584229-A499-484C-9993-711A22183A9A
</SONRQ>
</SIGNONMSGSRQV1>
<SIGNUPMSGSRQV1>
<ACCTINFOTRNRQ>
<TRNUID>1368AFFB-8997-43A3-9117-5B5BFA3AF5E6
<ACCTINFORQ>
<DTACCTUP>19900101000000
</ACCTINFORQ>
</ACCTINFOTRNRQ>
</SIGNUPMSGSRQV1>
</OFX>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Draft//EN">
<HTML>
<HEAD>
<TITLE>Error 400--Bad Request</TITLE>
<META NAME="GENERATOR" CONTENT="WebLogic Server">
</HEAD>
<BODY bgcolor="white">
<FONT FACE=Helvetica><BR CLEAR=all>
<TABLE border=0 cellspacing=5><TR><TD><BR CLEAR=all>
<FONT FACE="Helvetica" COLOR="black" SIZE="3"><H2>Error 400--Bad Request</H2>
</FONT></TD></TR>
</TABLE>
<TABLE border=0 width=100% cellpadding=10><TR><TD VALIGN=top WIDTH=100% BGCOLOR=white><FONT FACE="Courier New"><FONT FACE="Helvetica" SIZE="3"><H3>From RFC 2068 <i>Hypertext Transfer Protocol -- HTTP/1.1</i>:</H3>
</FONT><FONT FACE="Helvetica" SIZE="3"><H4>10.4.1 400 Bad Request</H4>
</FONT><P><FONT FACE="Courier New">The request could not be understood by the server due to malformed syntax. The client SHOULD NOT repeat the request without modifications.</FONT></P>
</FONT></TD></TR>
</TABLE>

</BODY>
</HTML>

User avatar
Angeman
Administrateur
Posts: 1924
Joined: 28 December 2008, 21:28
Location: Toulouse, France
Contact:

Re: PNC Bank connecting

Post by Angeman » 01 September 2016, 10:03

It tells that the request sent by iCompta has a "bad syntax" however I've tried every change possible to the request and it always returns that. So I'm sorry but I've no idea what else can be done to connect with PNC bank. If you know someone who managed to connect to PNC with OFX Direct Connect you can ask him to send his log then I should be able to figure out what needs to be changed in the request otherwise I don't know what to do more sorry.

Post Reply