Author Topic: Importing .CSV files  (Read 2714 times)

0 Members and 1 Guest are viewing this topic.

pamarn

  • Guest
Importing .CSV files
« on: March 24, 2013, 11:59:23 AM »
I downloaded my statement but found that the debits were downloaded as credits and visa versa.
Also the credit amounts were not transferred.
There appears to be no way to edit the credit/debit entries so I have had to delete the entry and insert the correct entry as a new transaction.
Please can anyone help?

Online ideasguy

  • Administrator
  • Hero Member
  • *****
  • Posts: 6081
  • Just me
    • Ideas for Gardens
Re: Importing .CSV files
« Reply #1 on: March 24, 2013, 04:01:54 PM »
Welcome to the forum Arnold!

I have had only one report of this previously, and in response, I provided a permanent solution.
You've obviously done everything correctly so far.
Try again, and when you get to the staging screen BS412S02, use the Reverse button as explained here in the User Guide.
http://www.bankgenie.net/UserGuide/412/412S02/412s02.html#Reverse

Check what happens, and if all looks OK, click the Process button.

Does that solve the problem for you?

PS When this is resolved, I will move this topic from Ideas Genie to the Bank Genie section. It may help others :)

pamarn

  • Guest
Re: Importing .CSV files
« Reply #2 on: March 30, 2013, 11:28:03 AM »
The reverse button worked to change the credit to debit and visa versa but my credit amounts are still not being transferred. Although this is not a problem as on average I only get 9 credit entries a month I wondered if there was a solution?

Online ideasguy

  • Administrator
  • Hero Member
  • *****
  • Posts: 6081
  • Just me
    • Ideas for Gardens
Re: Importing .CSV files
« Reply #3 on: March 30, 2013, 11:42:42 AM »
Half way there ::)

Ive never has reports of Credits not coming through Arnold.
What format of file did you download (e.g. csv, QIF OFX)?

Are they appearing in the Staging screen?
If no, I'd need to look at the file you've downloaded to see what's going on.
Use a normal text editor (Notepad is fine) to edit your downloaded file.
Edit out any personal details and edit amounts if necessary.
I'm looking for some Credits and some Debits in the file.
You can edit and delete most of the file, leaving at least one Credit record and one Debit.
Then please email to me as an attachment.
« Last Edit: March 30, 2013, 11:44:33 AM by ideasguy »

pamarn

  • Guest
Re: Importing .CSV files
« Reply #4 on: March 30, 2013, 12:32:49 PM »
My .CSV file attached as requested.
« Last Edit: March 30, 2013, 01:12:35 PM by ideasguy »

Online ideasguy

  • Administrator
  • Hero Member
  • *****
  • Posts: 6081
  • Just me
    • Ideas for Gardens
Re: Importing .CSV files
« Reply #5 on: March 30, 2013, 01:13:42 PM »
Gottit Arnold

Ive deleted your attachment. I meant you to send it by email :o
I'll look at it this afternoon.

Online ideasguy

  • Administrator
  • Hero Member
  • *****
  • Posts: 6081
  • Just me
    • Ideas for Gardens
Re: Importing .CSV files
« Reply #6 on: March 30, 2013, 02:05:11 PM »
I haven't seen that type of file before Arnold.

I can see your Credits, so will be able to make it work.
Another button required in the screen BS412S01 for that Bank.

Which Bank is it?
Reply by email if you wish or if not sensitive (I'm sure it isn't) please answer here as it may make others aware that a solution will be provided.

pamarn

  • Guest
Re: Importing .CSV files
« Reply #7 on: March 30, 2013, 07:26:22 PM »
The bank is the Nationwide Building Society FlexAccount.

Thanks for your help.

Online ideasguy

  • Administrator
  • Hero Member
  • *****
  • Posts: 6081
  • Just me
    • Ideas for Gardens
Re: Importing .CSV files
« Reply #8 on: March 31, 2013, 09:32:24 AM »
Thanks for the additional info Arnold.

I'll work on this and have something for you early next week (after the holidays :)).
Have a nice Easter weekend :)
« Last Edit: March 31, 2013, 09:33:56 AM by ideasguy »

Online ideasguy

  • Administrator
  • Hero Member
  • *****
  • Posts: 6081
  • Just me
    • Ideas for Gardens
Re: Importing .CSV files
« Reply #9 on: April 04, 2013, 12:07:37 PM »
Hi Arnold

Download your file into a folder called Nationwide.
Use the program Online Banking Transactions-BS412
When you click the Get Downloaded file button and select the file in the Nationwide folder, two Nationwide buttons will be enabled.
Try the one on the right.
That works on the file you sent me. Let me know how it works for you.

pamarn

  • Guest
Re: Importing .CSV files
« Reply #10 on: April 11, 2013, 04:04:39 PM »
I have just downloaded a statement with credits on it and I used the right
hand Nationwide button and it worked perfectly. I didn,t have to use the
reverse button for the credits and debits.

Thanks once again for your help and prompt action.


Online ideasguy

  • Administrator
  • Hero Member
  • *****
  • Posts: 6081
  • Just me
    • Ideas for Gardens
Re: Importing .CSV files
« Reply #11 on: April 11, 2013, 05:29:35 PM »
Thanks for posting this Arnold.
I'm pleased I didn't have to make any changes ;D