I’m importing prices —— I smell carrots a-cooking and where there’s carrots, there’s a rabbit. — Yosemite Sam
> On Aug 21, 2022, at 9:34 AM, Jon Schewe <jpsch...@mtu.net> wrote: > > > Jack, > > I have tried using this configuration multiple times to get the import to > work. I have a list of column assignments, none of which have worked > correctly. Thus the python script that does in fact work. In your screenshot > I see column options that don't exist for me. Are you importing transactions > or prices? I'm trying to import transactions. > > Jon > > >> On Sat, 2022-08-20 at 11:54 -0400, Jack Frillman via gnucash-user wrote: >> I use CSV import almost every day and it works just fine. >> You do have to setup a configuration file that tells the importer how to >> interpret your CSV data. I suspect you did not do that. >> Here is an example of my CSV data: >> >> ARSIX,14.82,Ray Jay,2022/08/20,USD >> BAFGX,26.47,Ray Jay,2022/08/20,USD >> BAGIX,10.07,Ray Jay,2022/08/20,USD >> CISMX,16.75,Ray Jay,2022/08/20,USD >> GSFTX,29.98,Ray Jay,2022/08/20,USD >> >> Each column of the separated values above are defined when you set the >> importer up. >> I saved this in a file called "ira quotes" and it's selected in the >> attached screen shot. The bottom window is the result of mapping of the >> "irs quotes" file to the CSV data above. >> >> As for your Python script I have no idea what it's supposed to do. >> I have a much smaller Python script that scrapes the closing day prices >> off a web page and creates the CSV file I import. >> >> Jack >> >>> On 8/19/22 10:33 PM, Jon Schewe wrote: >>> So I didn't get the CSV import tool to work. However I was able to >>> write a python script to do the import. I would think that this would >>> be possible with the CSV import, but I can't seem to figure out how to >>> do the right column assignments to make it work. I have attached the >>> python script and a sample input CSV file. >>> >>> If someone that knows how the CSV import code works and can compare >>> with my script and tell me how to use the CSV import tool for this, >>> that would be great. >>> >>> Thanks, >>> >>> Jon >>> >>> >>>> On Tue, 2022-07-12 at 08:45 -0500, Jon Schewe wrote: >>>> That looks similar to what I'm doing, except all of my data is on a >>>> single line in the CSV file. The biggest problem seems to be how to >>>> convince GnuCash to use 2 different commodities for the transaction >>>> when importing from CSV. >>>> >>>> >>>>> On Tue, 2022-07-12 at 13:04 +1000, Geoff wrote: >>>>> Hi Jon >>>>> >>>>> This isn't exactly what you are asking for, but it may give you >>>>> some >>>>> clues. Importing Dividends from CSV:- >>>>> >>>>> https://lists.gnucash.org/pipermail/gnucash-user/2020-August/092768.html >>>>> >>>>> >>>>> Good luck! >>>>> >>>>> Geoff >>>>> ===== >>>>> >>>>>> On 12/07/2022 12:35 pm, Jon Schewe wrote: >>>>>> Does anyone have an example of importing stock transactions from >>>>>> CSV? >>>>>> >>>>>> I have matched columns to Date, Description, Account, Price, >>>>>> Deposit, >>>>>> Transfer Account. >>>>>> The "Account" column is the mutual fund account. >>>>>> The "Transfer Account" column is the currency account. >>>>>> >>>>>> When I start the import process all of my transactions need an >>>>>> account >>>>>> to transfer from, despite specifying the Transfer Account. When I >>>>>> try >>>>>> and select my currency account I'm told that it has the wrong >>>>>> commodity. >>>>>> >>>>>> I have another column for the currency amount, but I don't know >>>>>> what to >>>>>> map that to in the importer. >>>>>> >>>>>> I tried checkout out >>>>>> https://www.gnucash.org/docs/v4/C/gnucash-help/trans-import.html#trans-import-csv >>>>>> >>>>>> but it doesn't seem to address this. >>>>>> Suggestions on where I'm going wrong. >>>>>> >>>>>> Jon >>>>>> >>>>>> >>>>>> _______________________________________________ >>>>>> gnucash-user mailing list >>>>>> gnucash-user@gnucash.org >>>>>> >>>>>> To update your subscription preferences or to unsubscribe: >>>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>>>>> >>>>>> If you are using Nabble or Gmane, please see >>>>>> https://wiki.gnucash.org/wiki/Mailing_Lists >>>>>> for more information. >>>>>> ----- >>>>>> Please remember to CC this list on all your replies. >>>>>> You can do this by using Reply-To-List or Reply-All. >>>> _______________________________________________ >>>> gnucash-user mailing list >>>> gnucash-user@gnucash.org >>>> To update your subscription preferences or to unsubscribe: >>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>>> If you are using Nabble or Gmane, please see >>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >>>> ----- >>>> Please remember to CC this list on all your replies. >>>> You can do this by using Reply-To-List or Reply-All. >>> >>> _______________________________________________ >>> gnucash-user mailing list >>> gnucash-user@gnucash.org >>> To update your subscription preferences or to unsubscribe: >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>> ----- >>> Please remember to CC this list on all your replies. >>> You can do this by using Reply-To-List or Reply-All. >> >> _______________________________________________ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> ----- >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.