I am not able to import transaction data from a CSV file even though all the fields appear to be properly mapped. Can any one help. I am running an iMac with MacOS High Sierra Version 10.13.16. As you can see on the attached file, the fields are green, I have tired chosing different options in the Type of Data but still I am not able to import (I do not get the Finish button to turn green).
CSV.pdf (56.5 KB)
Top of screen:
Unmapped required field(s): Value
Add transaction value.
Edit: Try Date, Type, Value where Type is “Fee”.
In addition to the comment from @flywire I suggest to export a demo transaction you want to import first. Then you have a template for the import.
That worked!!! 
Thank you so much for your help.
1 Like
Is it possible to do this with some sort of Select All > Set provider to Yahoo > Update all?
I have imported 3 years of transactions, but the list is long. Lot of work to do it manually.
2 Likes
Firstly, if you think that would be a useful feature I’d encourage you to add a supporting emoji on the issue in GitHub.
When the data file is updated it will look like the following:
<client>
<version>51</version>
<baseCurrency>AUD</baseCurrency>
<securities>
<security>
<uuid>831d8a3e-7025-4b0f-b6ca-3ef5bf727eb4</uuid>
<name>REA Group Ltd</name>
<currencyCode>AUD</currencyCode>
<tickerSymbol>REA.AX</tickerSymbol>
<feed>YAHOO</feed>
<prices>
Try this and let us know how it goes.
This is totally not supported so backup your data file. Then open the data file with a text editor (eg np++ in Windows) before you add the providers.
It might be a search and replace of :
</tickerSymbol>
<prices>
with
</tickerSymbol>
<feed>YAHOO</feed>
<prices>
The image below shows the np++ Extended interface which uses a \n as new-line and the groups of 4 spaces are important:
2 Likes
Thanks. Solved. 
noone else than me interested in this?
Thank you for the extensive tut.
Question: If I already have my PF data all setup and running the way I want and import again data from PDF, Does it overrides what I already have or does it add to it?
This topic is csv but it recognises the pdf record and will not import it again. You can delete the record(s) and reimport to say update references.
Can anyone here maybe help me with this issue here? CSV-Import Buchung internationales Wertpapier in ein Depot in Euro. I think here might be some people who have had similar issues.
Hello
I thought I had the problem fixed with the latest update, but apparently doesn’t look like it to me.
Please provide an example in .csv (.txt) format, then I can look at it again.
Greetings
Alex
Hi, commented in the actual topic. I only see in the “new release info” this: “Verbesserung: Neue Einstellung: Währung immer anzeigen (= nicht weglassen für die Berichtswährung).”
thanks that you are having a look.
Thank you for the explanation flywire.
Could you explain what each of the data types represent. I don’t understand which one i’m supposed to use when importing different stuff (transactions, taxonomies, stocks)
Five types of data are supported: Account Transactions, Portfolio Transactions, Securities, Historical Quotes and Securities Account and each type has a different set of minimum fields.
For example, what’s the difference between Account Transactions and Portfolio Transactions? in the PP UI I don’t see any reference to portfolio transactions. All I see is transactions in Accounts, be it Deposit or Securities Accounts
In the absence of a manual, I use the SIAS (Suck It And See) approach. The name is a hint, then try exporting something and importing it back in. Portfolio and Account transactions are used in the thread. I normally just remove fields until I find the minimum.
If you find something useful then contributing it would be welcome.
Hello all,
Hopefully someone can help.
I just want to import securities (no transactions whatsoever) to build a watchlist with all S&P components.
I am able to import the securities from a csv file I build with “security name” and “ticker” however I am not able to link all these to a quote provider, I normally use yahoo finance.
Is there any build in function?
HELP !!
we need this function built in
Yes I agree
