Re: [GNC] Flathub does not install Gnucash ver. 4.10 flatpak, but only installs lower ver. 3.7
Thanks John and Frank for your valuable research on the topic.I am so much thankful to the members who devote immense time and energy in replying to and helping the newbies. Sent from Yahoo Mail on Android On Wed, 27 Apr 2022 at 4:23 AM, Frank H. Ellenberger wrote: Hi, Am 26.04.22 um 14:13 schrieb parag puranik: > There is no output of both the commands, The screen of terminal looks like > ::~$ flatpak remotes -d >fp-state > :~$ flatpak search gnucash >>fp-state > :~$ Right, it is in the file fp-state in your working directory. I had expected you would attach that file to your email. As John found the reason of your problem, you can now remove that file. Regards Frank ___ 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.
Re: [GNC] Flathub does not install Gnucash ver. 4.10 flatpak, but only installs lower ver. 3.7
There is no output of both the commands, The screen of terminal looks like ::~$ flatpak remotes -d >fp-state :~$ flatpak search gnucash >>fp-state :~$ I am getting increasingly sure that i386 versions of flatpaks, which I have- i.e. "1.0.9-0ubuntu0.4" is limited to pulling Gnucash ver 3.7 at the maximum from Flathub, not beyond that. Like last supported vercion of Gnucash on Win 7 is 3.11, last 32 bit version supported on Linux 32 bit is Ver. 3.7 Flatpak itself cannot be be upgaded to a newer version. Hence for Flatpak ver. 1.0.9 the last supported version of Gnucash could be ver. 3.7. On Tuesday, 26 April, 2022, 05:11:30 pm IST, Frank H. Ellenberger wrote: Hi, Flatpak tries to be smart. So the interesting parts of 2 and 3 were shortened away. Can you redo them in a full screen window or by redirecting into a file like: flatpak remotes -d >fp-state flatpak search gnucash >>fp-state Regards Frank Am 26.04.22 um 13:27 schrieb parag puranik: > Outputs of commands: > > (1) $ flatpak --supported-arches > i386 > > (2) $ flatpak remotes -d > Name Title URL Collection ID Priority Options > flathub Flathub https://dl.flathub.org/repo/ - 1 system > > (3) $ flatpak search gnucash > Application ID Version Branch Remotes Description > > org.gnucash.GnuCash 3.7+ stable flathub Manage your finances, accounts, > and investments > org.kde.skrooge stable flathub Personal Finances ___ 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.
Re: [GNC] Flathub does not install Gnucash ver. 4.10 flatpak, but only installs lower ver. 3.7
Outputs of commands: (1) $ flatpak --supported-arches i386 (2) $ flatpak remotes -d Name Title URL Collection ID Priority Options flathub Flathub https://dl.flathub.org/repo/ - 1 system (3) $ flatpak search gnucash Application ID Version Branch Remotes Description org.gnucash.GnuCash 3.7+ stable flathub Manage your finances, accounts, and investments org.kde.skrooge stable flathub Personal Finances On Tuesday, 26 April, 2022, 06:38:31 am IST, Frank H. Ellenberger wrote: Hi, please send the output of the following commands: flatpak --supported-arches flatpak remotes -d flatpak search gnucash Perhaps we can so get a clue of your problem. Regards Frank Am 25.04.22 um 15:23 schrieb parag puranik via gnucash-user: > The first Flathub release (for 32 bit OS) was not ver 3.11 ( it could be > earlier version), since I have installed ver. 3.7 on my 32 bit OS. > That said, my conclusion is : Flathub installs ver. 3.7 on 32 bit systems > (that could be last ver. offerred by Flathub for i386). > To get higher versions than 3.7, you have to look out providers other than > Flathub. > Can someone help me identify providers other than Flathub for a higher > version flatpak for i386 systems ? > > Sent from Yahoo Mail on Android ___ 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.
Re: [GNC] Flathub does not install Gnucash ver. 4.10 flatpak, but only installs lower ver. 3.7
The first Flathub release (for 32 bit OS) was not ver 3.11 ( it could be earlier version), since I have installed ver. 3.7 on my 32 bit OS. That said, my conclusion is : Flathub installs ver. 3.7 on 32 bit systems (that could be last ver. offerred by Flathub for i386). To get higher versions than 3.7, you have to look out providers other than Flathub. Can someone help me identify providers other than Flathub for a higher version flatpak for i386 systems ? Sent from Yahoo Mail on Android On Sun, 24 Apr 2022 at 10:27 PM, parag puranik wrote:What I did was as follows:sudo apt install flatpak sudo add-apt-repository ppa:flatpak/stable sudo apt update sudo apt install flatpak sudo apt install gnome-software-plugin-flatpakflatpak remote-add --if-not-exists flathub https://flathub.org/repo/flathub.flatpakrepoRebooted the machine Then went to Flathub.org , then searched for Gnucash, then clicked Install button to install GNUcash Flatpak. The website showed version 4.10, but version 3.7 got installed. On Sunday, 24 April, 2022, 08:58:33 pm IST, john wrote: 1: I have no way of knowing what you did. 2: Command line expertise is pretty central to using Linux. Consider either spending some time learning how to use it or going back to Windows. 3: Yes, but you've already established that you're not able to install them, see answer 2. Regards,John Ralls On Apr 23, 2022, at 11:14 PM, parag puranik wrote: Thanks for yourfeedback John. (1) If the firstever version is 3.11 by Flathub, how the random version 3.7 gotinstalled ? (2) Gone through thetwo links. However, being new to Linux (1 year) pulling older releasefrom Flathub via CLI is beyond my capacity/skill level. Neither can Ibuild the flatpak myself. (3) Just like allhistorical versions of Gnucash (.exe) for Windows are available onSourceforge, are there any archived Gnucash flatpaks for Linux ? On Saturday, 23 April, 2022, 11:14:16 pm IST, john wrote: On Apr 23, 2022, at 12:16 AM, parag puranik via gnucash-user wrote: My OS: Linux Mint Tricia 19.3 Cinnamon (32 bit) - (I do not have compatible hardware to upgrade it.) I tried to install the latest Flatpak version of Gnucash 4.10 from Flathub.org through clicking 'Install' button on its site. However it installs the lower version 3.7, without even giving me warning that - 'instead of ver 4.10, it is installing lower ver. 3.7'. Please help me know the reason where I am going wrong ? Actually I wanted to install Flatpak of version 3.11 first- (not going straight to ver. 4.10 from my default repository ver. 2.6.19). But unfortunately Flathub.org does not have version 3.11 listed. Alternatively, what is the 'way to go' to install latest Flatpak ver. 3.11 ? Is there any (.deb) installation file ? or is there any available archived Flatpak of ver, 3.11 ? That doesn't seem likely since the first flatub release was 3.11. https://discourse.flathub.org/t/install-an-older-version-of-an-app/320/3 explains how to get an older release from flathub and the commit history can be found at https://github.com/gnucash/gnucash-on-flatpak. The hash for 3.11 is c354cee.There are nightly builds going back to 3.4 at https://code.gnucash.org/builds/flatpak/maint/. Regards,John Ralls ___ 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.
Re: [GNC] Flathub does not install Gnucash ver. 4.10 flatpak, but only installs lower ver. 3.7
What I did was as follows:sudo apt install flatpak sudo add-apt-repository ppa:flatpak/stable sudo apt update sudo apt install flatpak sudo apt install gnome-software-plugin-flatpakflatpak remote-add --if-not-exists flathub https://flathub.org/repo/flathub.flatpakrepoRebooted the machine Then went to Flathub.org , then searched for Gnucash, then clicked Install button to install GNUcash Flatpak. The website showed version 4.10, but version 3.7 got installed. On Sunday, 24 April, 2022, 08:58:33 pm IST, john wrote: 1: I have no way of knowing what you did. 2: Command line expertise is pretty central to using Linux. Consider either spending some time learning how to use it or going back to Windows. 3: Yes, but you've already established that you're not able to install them, see answer 2. Regards,John Ralls On Apr 23, 2022, at 11:14 PM, parag puranik wrote: Thanks for yourfeedback John. (1) If the firstever version is 3.11 by Flathub, how the random version 3.7 gotinstalled ? (2) Gone through thetwo links. However, being new to Linux (1 year) pulling older releasefrom Flathub via CLI is beyond my capacity/skill level. Neither can Ibuild the flatpak myself. (3) Just like allhistorical versions of Gnucash (.exe) for Windows are available onSourceforge, are there any archived Gnucash flatpaks for Linux ? On Saturday, 23 April, 2022, 11:14:16 pm IST, john wrote: On Apr 23, 2022, at 12:16 AM, parag puranik via gnucash-user wrote: My OS: Linux Mint Tricia 19.3 Cinnamon (32 bit) - (I do not have compatible hardware to upgrade it.) I tried to install the latest Flatpak version of Gnucash 4.10 from Flathub.org through clicking 'Install' button on its site. However it installs the lower version 3.7, without even giving me warning that - 'instead of ver 4.10, it is installing lower ver. 3.7'. Please help me know the reason where I am going wrong ? Actually I wanted to install Flatpak of version 3.11 first- (not going straight to ver. 4.10 from my default repository ver. 2.6.19). But unfortunately Flathub.org does not have version 3.11 listed. Alternatively, what is the 'way to go' to install latest Flatpak ver. 3.11 ? Is there any (.deb) installation file ? or is there any available archived Flatpak of ver, 3.11 ? That doesn't seem likely since the first flatub release was 3.11. https://discourse.flathub.org/t/install-an-older-version-of-an-app/320/3 explains how to get an older release from flathub and the commit history can be found at https://github.com/gnucash/gnucash-on-flatpak. The hash for 3.11 is c354cee.There are nightly builds going back to 3.4 at https://code.gnucash.org/builds/flatpak/maint/. Regards,John Ralls ___ 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.
Re: [GNC] Gnucash 3.7 - flatpak cannot recognize second internal HDD & USB Flashdrive
Thanks David H , Frank for your valuable assistance. Ultimately, I understood your instructions and solved the issue. David H - regarding the CSV file split issue, I successfully split the (.gnca) file after repeated iterations and spotted and then rectified the error. Thanks also for guiding me on that issue. On Monday, 8 November, 2021, 12:09:02 pm IST, David H wrote: Hi Parag, You should read the wiki re flatpak - https://wiki.gnucash.org/wiki/Flatpak, specifically the following :- How did you go with your csv file ? Cheers David H. Configuration Granting Access to Other Resources As each Flatpak app runs in a sandbox, you have to unlock additionally required resources like - USB Drive -sudo flatpak override org.gnucash.GnuCash --filesystem=$PATH_TO_USB_DRIVE - Smartcard Reader - To use smart cards in AqBanking - on the host—your Linux PC—the demon pcscd must be running, - the related socket must become unlocked for your GnuCash-Flatpak once: sudo flatpak override org.gnucash.GnuCash --socket=pcsc sudo may be required depending on the rest of your installation. - See also - https://docs.flatpak.org/en/latest/sandbox-permissions.html On Mon, 8 Nov 2021 at 16:28, parag puranik via gnucash-user wrote: My existing system : Mint 19.3 Cinnamon -32 bit with latest updates - (installed on internal SSD) and Gnucash default version 2.6.19. I upgraded Gnucash through Software manager to Build : 3.7+(2019-09-07) -Flatpak. It was successfully installed while keeping my existing default version 2.6.19 intact. My Gnucash working files are stored on attached USB flash drive which I want to open and work upon through Menu>File>open . . . However on doing so my attached (i) second internal HDD and (ii) USB flash drive are not visible at all (even in "+other locations"). Only files in Home folder are visible. On the other hand, on opening through the earlier ver 2.6.19 these devices are still very well visible. Why this anomaly ? and what is the solution ? ___ 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.
Re: [GNC] Flathub does not install Gnucash ver. 4.10 flatpak, but only installs lower ver. 3.7
Thanks for yourfeedback John. (1) If the firstever version is 3.11 by Flathub, how the random version 3.7 gotinstalled ? (2) Gone through thetwo links. However, being new to Linux (1 year) pulling older releasefrom Flathub via CLI is beyond my capacity/skill level. Neither can Ibuild the flatpak myself. (3) Just like allhistorical versions of Gnucash (.exe) for Windows are available onSourceforge, are there any archived Gnucash flatpaks for Linux ? On Saturday, 23 April, 2022, 11:14:16 pm IST, john wrote: On Apr 23, 2022, at 12:16 AM, parag puranik via gnucash-user wrote: My OS: Linux Mint Tricia 19.3 Cinnamon (32 bit) - (I do not have compatible hardware to upgrade it.) I tried to install the latest Flatpak version of Gnucash 4.10 from Flathub.org through clicking 'Install' button on its site. However it installs the lower version 3.7, without even giving me warning that - 'instead of ver 4.10, it is installing lower ver. 3.7'. Please help me know the reason where I am going wrong ? Actually I wanted to install Flatpak of version 3.11 first- (not going straight to ver. 4.10 from my default repository ver. 2.6.19). But unfortunately Flathub.org does not have version 3.11 listed. Alternatively, what is the 'way to go' to install latest Flatpak ver. 3.11 ? Is there any (.deb) installation file ? or is there any available archived Flatpak of ver, 3.11 ? That doesn't seem likely since the first flatub release was 3.11. https://discourse.flathub.org/t/install-an-older-version-of-an-app/320/3 explains how to get an older release from flathub and the commit history can be found at https://github.com/gnucash/gnucash-on-flatpak. The hash for 3.11 is c354cee.There are nightly builds going back to 3.4 at https://code.gnucash.org/builds/flatpak/maint/. Regards,John Ralls ___ 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.
[GNC] Flathub does not install Gnucash ver. 4.10 flatpak, but only installs lower ver. 3.7
My OS: Linux Mint Tricia 19.3 Cinnamon (32 bit) - (I do not have compatible hardware to upgrade it.) I tried to install the latest Flatpak version of Gnucash 4.10 from Flathub.org through clicking 'Install' button on its site. However it installs the lower version 3.7, without even giving me warning that - 'instead of ver 4.10, it is installing lower ver. 3.7'. Please help me know the reason where I am going wrong ? Actually I wanted to install Flatpak of version 3.11 first- (not going straight to ver. 4.10 from my default repository ver. 2.6.19). But unfortunately Flathub.org does not have version 3.11 listed. Alternatively, what is the 'way to go' to install latest Flatpak ver. 3.11 ? Is there any (.deb) installation file ? or is there any available archived Flatpak of ver, 3.11 ? ___ 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.
Re: [GNC] Error importing QIF file
Hi ALL EXPERTS Ultimately I split the QIF file in Text editor and isolated the corrupted record. In that record out of the text in Notes (Memo) field, the letter capital "I" somehow came to occupy the first position in the row, Now, as per the QIF file protocol, "I" indicates Price. Hence the importing desktop program interpreted it as "share price" and since there was some other text after "I" , the error message got generated. I simply removed the "I" from the first position of the row and imported the file successfully. (Big)-Thanks to YOU ALL for your valuable guidance and persistent follow-up on the issue. On Monday, 25 October, 2021, 08:22:48 pm IST, Kalpesh Patel wrote: Parag – are you able to send me the QIF file privately either as is or anonymized? I will flag down the offending entry. It won’t be any easier than this. Just a FYI - my past experience in a massive import of over 10K+ transaction via QIF has been that the wild west of date format used by other apps, specifically multiple formats in the same file, trips up GNC as it tries to import only single formatted date. There is no clear cut authority on this so both are right as there was not strict adherence to one way of specifying this, especially when accounting for variation between American style of date (month / date / year) and English style of date ( date / month / year). One of the hard ones that I found was for likes of Quicken used apostrophes (‘) as delimiter instead of forward slash (/) for year after 1999 for two digits year format, something like “2/ 1’20” to identify Feb 1nd of 2020 for example, in a file that crossed the millennium. This was undertaken in 3.x of GNC and since then there has been great improvements made towards this import process. -- Message: 1 Date: Sun, 24 Oct 2021 17:19:21 + (UTC) From: parag puranik To: "gnucash-user@gnucash.org" Subject: Re: [GNC] Error importing QIF file Message-ID: <384139489.1092075.1635095961...@mail.yahoo.com> Content-Type: text/plain; charset=UTF-8 Okay, I'll try to find out the fault by myself. Thanks a lot for your continued support David. Sent from Yahoo Mail on Android ___ 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.
Re: [GNC] Gnucash 3.7 - flatpak cannot recognize second internal HDD & USB Flashdrive
I am new to Linux shell commands. Please advise on how to use the filesystem command :--filesystem=$PATH_TO_USB_DRIVEAssuming my device name is /media/John/JETFLASH --filesystem=$PATH_TO_USB_DRIVE On Monday, 8 November, 2021, 12:09:02 pm IST, David H wrote: Hi Parag, You should read the wiki re flatpak - https://wiki.gnucash.org/wiki/Flatpak, specifically the following :- How did you go with your csv file ? Cheers David H. Configuration Granting Access to Other Resources As each Flatpak app runs in a sandbox, you have to unlock additionally required resources like - USB Drive -sudo flatpak override org.gnucash.GnuCash --filesystem=$PATH_TO_USB_DRIVE - Smartcard Reader - To use smart cards in AqBanking - on the host—your Linux PC—the demon pcscd must be running, - the related socket must become unlocked for your GnuCash-Flatpak once: sudo flatpak override org.gnucash.GnuCash --socket=pcsc sudo may be required depending on the rest of your installation. - See also - https://docs.flatpak.org/en/latest/sandbox-permissions.html On Mon, 8 Nov 2021 at 16:28, parag puranik via gnucash-user wrote: My existing system : Mint 19.3 Cinnamon -32 bit with latest updates - (installed on internal SSD) and Gnucash default version 2.6.19. I upgraded Gnucash through Software manager to Build : 3.7+(2019-09-07) -Flatpak. It was successfully installed while keeping my existing default version 2.6.19 intact. My Gnucash working files are stored on attached USB flash drive which I want to open and work upon through Menu>File>open . . . However on doing so my attached (i) second internal HDD and (ii) USB flash drive are not visible at all (even in "+other locations"). Only files in Home folder are visible. On the other hand, on opening through the earlier ver 2.6.19 these devices are still very well visible. Why this anomaly ? and what is the solution ? ___ 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.
[GNC] Gnucash 3.7 - flatpak cannot recognize second internal HDD & USB Flashdrive
My existing system : Mint 19.3 Cinnamon -32 bit with latest updates - (installed on internal SSD) and Gnucash default version 2.6.19. I upgraded Gnucash through Software manager to Build : 3.7+(2019-09-07) -Flatpak. It was successfully installed while keeping my existing default version 2.6.19 intact. My Gnucash working files are stored on attached USB flash drive which I want to open and work upon through Menu>File>open . . . However on doing so my attached (i) second internal HDD and (ii) USB flash drive are not visible at all (even in "+other locations"). Only files in Home folder are visible. On the other hand, on opening through the earlier ver 2.6.19 these devices are still very well visible. Why this anomaly ? and what is the solution ? ___ 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.
Re: [GNC] Error importing QIF file
an turn on the display of special characters in these editors – in Textpad click the icon to the left of the globe – looks like a reverse “P” and in Notepad++ it’s the same icon. I could not locate any trace file in Win10. > I don't think the App compresses the file before exporting because when I > open the QIF file in Text Editor-Windows Notepad, it opens successfully. > The text editor surely doesn't decompress file before opening. > No it won’t usually uncompress a file automatically – I was just going by the bug report I read on the android app website so obviously irrelevant to your issue. > I just want the members / Gnucash Team to focus on the generated error > message I posted in my first post and let me know in what circumstances > this message gets generated and how to repair the QIF file so that I can > import it into Desktop Gnucash. > If you don't want to split your file and import partial files I would suggest you do the following for starters:- Read the file-format.txt text file mentioned above if you are unfamiliar with the qif file format. Check that each record begins on a new line and that each record has a CR LF (easier to see in Notepad++) at the end of the record and not somewhere in the middle thus splitting it mid-record. Check Date fields for valid date format (d-m-y, y-m-d, etc) and valid date, check amount fields for valid format amounts. If you can identify the problem record, maybe there's more than one, and you can't see why it would cause a problem then paste it into a message and post it here so the experts can eyeball it and suggest a solution. Cheers David H. > On Sunday, 24 October, 2021, 04:18:44 pm IST, David H > wrote: > > > Hi parag puranik, > > I was actually referring to the Gnucash trace file on your Win10 desktop > as that is where you had the error and not on your Android device :-) Also > I did see an error report on Ngewi Fet's codinguser website to the effect > that when you export qif from the android app it actually creates a > compressed .zip file even though it has a .qif suffix - > https://github.com/codinguser/gnucash-android/issues/889. You are > probably aware of this if you've used this process previously however. > > Cheers David H. > > On Sun, 24 Oct 2021 at 18:43, parag puranik via gnucash-user < > gnucash-user@gnucash.org> wrote: > > Thanks David H for your kind support. I'll upgrade to version 4.8 or so > and try. OS:\ is Win10 for importing PC. Regarding log file/trace file :- > After exporting from Android phone in QIF format, I carried out Factory > reset operation on Android. So no trace file remaining on Android. That > original Android app's file has been irretrievably lost for ever. > > ___ > 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 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.
Re: [GNC] Error importing QIF file
to repair the QIF file so that I can import it into Desktop Gnucash. If you don't want to split your file and import partial files Iwould suggest you do the following for starters:- Readthe file-format.txt text file mentioned above if you are unfamiliarwith the qif file format. Checkthat each record begins on a new line and that each record has a CRLF (easier to see in Notepad++) at the end of the record and notsomewhere in the middle thus splitting it mid-record. CheckDate fields for valid date format (d-m-y, y-m-d, etc) and valid date, check amount fieldsfor valid format amounts. If you can identify the problem record, maybe there's more than one, and you can't see why it would cause a problem then paste it into a message and post it here so the experts can eyeball it and suggest a solution. Cheers David H. On Sunday, 24 October, 2021, 04:18:44 pm IST, David H wrote: Hi parag puranik, I was actually referring to the Gnucash trace file on your Win10 desktop as that is where you had the error and not on your Android device :-) Also I did see an error report on Ngewi Fet's codinguser website to the effect that when you export qif from the android app it actually creates a compressed .zip file even though it has a .qif suffix - https://github.com/codinguser/gnucash-android/issues/889. You are probably aware of this if you've used this process previously however. Cheers David H. On Sun, 24 Oct 2021 at 18:43, parag puranik via gnucash-user wrote: Thanks David H for your kind support. I'll upgrade to version 4.8 or so and try. OS:\ is Win10 for importing PC. Regarding log file/trace file :- After exporting from Android phone in QIF format, I carried out Factory reset operation on Android. So no trace file remaining on Android. That original Android app's file has been irretrievably lost for ever. ___ 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.
Re: [GNC] Error importing QIF file
I am not familiar with file splitting process. Let me study and try. On Monday, 25 October, 2021, 01:15:27 am IST, Fred Bone wrote: On 24 October 2021 at 13:39, parag puranik said: > Fred,Repeatedly halving the file is cumbersome process. Indeed. If it takes as much as five minutes per trial, and you have 1000 entries in your file, you could expect to take rather less than an hour. So by now you could easily have identified the problem entry and shown it to us for further diagnosis. ___ 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.
Re: [GNC] Error importing QIF file
to split your file and import partial files Iwould suggest you do the following for starters:- Readthe file-format.txt text file mentioned above if you are unfamiliarwith the qif file format. Checkthat each record begins on a new line and that each record has a CRLF (easier to see in Notepad++) at the end of the record and notsomewhere in the middle thus splitting it mid-record. CheckDate fields for valid date format (d-m-y, y-m-d, etc) and valid date, check amount fieldsfor valid format amounts. If you can identify the problem record, maybe there's more than one, and you can't see why it would cause a problem then paste it into a message and post it here so the experts can eyeball it and suggest a solution. Cheers David H. On Sunday, 24 October, 2021, 04:18:44 pm IST, David H wrote: Hi parag puranik, I was actually referring to the Gnucash trace file on your Win10 desktop as that is where you had the error and not on your Android device :-) Also I did see an error report on Ngewi Fet's codinguser website to the effect that when you export qif from the android app it actually creates a compressed .zip file even though it has a .qif suffix - https://github.com/codinguser/gnucash-android/issues/889. You are probably aware of this if you've used this process previously however. Cheers David H. On Sun, 24 Oct 2021 at 18:43, parag puranik via gnucash-user wrote: Thanks David H for your kind support. I'll upgrade to version 4.8 or so and try. OS:\ is Win10 for importing PC. Regarding log file/trace file :- After exporting from Android phone in QIF format, I carried out Factory reset operation on Android. So no trace file remaining on Android. That original Android app's file has been irretrievably lost for ever. ___ 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.
Re: [GNC] Error importing QIF file
Okay, I'll try to find out the fault by myself. Thanks a lot for your continued support David. Sent from Yahoo Mail on Android ___ 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.
[GNC] Error importing QIF file
Fred,Repeatedly halving the file is cumbersome process. I would, instead, first like to interpret and focus on the error message generated by Gnucash desktop. What kind of fault leads to that message ? (When I exported from Android app, the phone was working fine and stable, no abrupt shutdown.)Alternatively, can that QIF file be converted to XML file ? Gnucash desktop then can directly open the xml file without going through the Import process/procedure. ___ 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.
Re: [GNC] Error importing QIF file
Thanks David H for your kind support. I'll upgrade to version 4.8 or so and try. OS:\ is Win10 for importing PC. Regarding log file/trace file :- After exporting from Android phone in QIF format, I carried out Factory reset operation on Android. So no trace file remaining on Android. That original Android app's file has been irretrievably lost for ever. ___ 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.
Re: [GNC] Error importing QIF file
David thanks for the hint to compare the file with standard QIF format. The app has no provision for entering any share transaction. It is only a robust double-entry book-keeping app -(plain and simple) - running on Sqlite3 at the backend, ensuring excellent data integrity. Hence I do not quit understand as to how the desktop version interprets it wrongly and generates error message at all ! Can u please refer this problem to 'appropriate' experts on sqlite DBMS ? (since I am new to Gnucash mailing lists, having subscribed less than 24 hours back). Sent from Yahoo Mail on Android ___ 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.
Re: [GNC] Error importing QIF file
Kalpesh, Gnucash (android version) is a companion app to its desktop version with limited functionality as to data entry on-the-go. Its an excellent and stable app. Its first time I faced this kind of error. GNUCASH Developers team should be in a position to explain it since the error message is a pre-defined phrase.Secondly, how to identify faulty transaction in text ? Further, can this faulty QIF file be read in SQLITE3 database through any conversion ? Sent from Yahoo Mail on Android ___ 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.
Re: [GNC] Error importing QIF file
David, in that case how do I identify which transactions are at fault ? Secondly, how to fix them ? Thirdly, how to create new repaired QIF file from it ? Instead, it would be better if someone from Gnucash team/users explain why the Error message arises in the first place. Sent from Yahoo Mail on Android ___ 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.
Re: [GNC] Error importing QIF file
I want to know why the error message arises and further how to import such a file in desktop.The data in the file can very well be read in Excel file. But I want to get that data into Desktop Gnucash directly (not by manually entering each transaction again in Desktop version). Sent from Yahoo Mail on Android ___ 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.
Re: [GNC] Error importing QIF file
Hi GregThe issue in certainly not about compatibility between android and desktop versions, but about a particular error in one particular file. I have successfully imported other QIF files.My question is regarding the significance of that particular error message and how to get around or work through to import that particular file in desktop. Sent from Yahoo Mail on Android ___ 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.
[GNC] Error importing QIF file
I exported a data file from Gnucash Android App version 2.4.0 in QIF format. While importing this QIF file into Gnucash desktop version 2.6.19 or even in version 3.10, I get error saying "Share price: Unrecognized or inconsistent format.", The import process has to be aborted. The QIF data file is plain and simple accounts-file and does not contain any Share-Transaction whatsoever. What is the solution ? ___ 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.
