Re: Anybody tried to import data to Quicken for Mac?

[Marty Knapp via use-livecode]

I have a crude little LC utility stack that converts a CSV file to QIF - that 
would give you a start. Just contact me off list and I can send that to you if 
you want.

Marty Knapp

> On May 6, 2022, at 3:45 PM, William Prothero via use-livecode 
>  wrote:
> 
> Mike:
> We, I notice that many folks are asking questions about merging and 
> sorting lots of data using DataGrid, and databases, and I have a possible 
> need for getting csv data into Quicken, on a Mac. I’m trying to see if a 
> livecode solution fits my problem.  It’s kinda like folks talking about using 
> Livecode to format data for export to Excell. I had wondered if anybody on 
> this list had faced this problem, and trying to format for Quicken, which is 
> a very popular financial app. I’m not hopeful, but thought I’d check.
> 
> I’m also considering just doing this completely in Livecode. There seem to be 
> many pathways to financial management. Bank statement downloads don’t list 
> the name of the person who made the transaction (at least some don’t), online 
> payment systems (Converge, for example) allow csv downloads and it’s possible 
> to get a csv formatted file of transactions that include payee name, address, 
> phone, etc that I would like to keep. Merging these csv downloads with bank 
> statements that list “Batches”, which often contain numerous credit card 
> purchases, could be an onerous hand editing job..the kind I hate. I’m trying 
> to streamline this task.
> 
> Then there are the other online payment sites ……. WooCommerce, etc, which 
> would presumably not involve Livecode programming. I’m not ready to go that 
> way yet, hoping for something I know a bit more about.
> 
> An approach connecting some of these various formats of financial data to 
> Quicken (using Livecode) would require a livecode output to a quicken 
> interchange format (QIF).
> 
> In short (or was it “long”), if nobody has tried this, no worries, please 
> ignore this post. I’m just doing “Do Diligence”.
> 
> Best,
> Bill Prothero

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Anybody tried to import data to Quicken for Mac?

[William Prothero via use-livecode]

Mike:
We, I notice that many folks are asking questions about merging and sorting 
lots of data using DataGrid, and databases, and I have a possible need for 
getting csv data into Quicken, on a Mac. I’m trying to see if a livecode 
solution fits my problem.  It’s kinda like folks talking about using Livecode 
to format data for export to Excell. I had wondered if anybody on this list had 
faced this problem, and trying to format for Quicken, which is a very popular 
financial app. I’m not hopeful, but thought I’d check.

I’m also considering just doing this completely in Livecode. There seem to be 
many pathways to financial management. Bank statement downloads don’t list the 
name of the person who made the transaction (at least some don’t), online 
payment systems (Converge, for example) allow csv downloads and it’s possible 
to get a csv formatted file of transactions that include payee name, address, 
phone, etc that I would like to keep. Merging these csv downloads with bank 
statements that list “Batches”, which often contain numerous credit card 
purchases, could be an onerous hand editing job..the kind I hate. I’m trying to 
streamline this task.

Then there are the other online payment sites ……. WooCommerce, etc, which would 
presumably not involve Livecode programming. I’m not ready to go that way yet, 
hoping for something I know a bit more about.

An approach connecting some of these various formats of financial data to 
Quicken (using Livecode) would require a livecode output to a quicken 
interchange format (QIF).

In short (or was it “long”), if nobody has tried this, no worries, please 
ignore this post. I’m just doing “Do Diligence”.

Best,
Bill Prothero

> On May 6, 2022, at 2:16 PM, Mike Kerner via use-livecode 
>  wrote:
> 
> why did you ask about another management program? what up?
> 
> On Fri, May 6, 2022 at 4:41 PM William Prothero via use-livecode <
> use-livecode@lists.runrev.com> wrote:
> 
>> Folks:
>> I have a nasty accounting problem and need to somehow get data into
>> Quicken (or perhaps find another management program). My question is
>> whether it’s possible (or known) how to take csv data (easy) and convert to
>> acceptable QIF form, which quicken requires.
>> 
>> Best,
>> Bill Prothero
>> 
>> William Prothero
>> waproth...@gmail.com
>> 
>> 
>> 
>> 
>> ___
>> use-livecode mailing list
>> use-livecode@lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your
>> subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
>> 
> 
> 
> -- 
> On the first day, God created the heavens and the Earth
> On the second day, God created the oceans.
> On the third day, God put the animals on hold for a few hours,
>   and did a little diving.
> And God said, "This is good."
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode

William Prothero
waproth...@gmail.com




___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Anybody tried to import data to Quicken for Mac?

[Mike Kerner via use-livecode]

why did you ask about another management program? what up?

On Fri, May 6, 2022 at 4:41 PM William Prothero via use-livecode <
use-livecode@lists.runrev.com> wrote:

> Folks:
> I have a nasty accounting problem and need to somehow get data into
> Quicken (or perhaps find another management program). My question is
> whether it’s possible (or known) how to take csv data (easy) and convert to
> acceptable QIF form, which quicken requires.
>
> Best,
> Bill Prothero
>
> William Prothero
> waproth...@gmail.com
>
>
>
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>


-- 
On the first day, God created the heavens and the Earth
On the second day, God created the oceans.
On the third day, God put the animals on hold for a few hours,
   and did a little diving.
And God said, "This is good."
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Anybody tried to import data to Quicken for Mac?

[Richmond via use-livecode]

Awkward:

Whackypedia says:

"Different (and incompatible) versions of Quicken run on Windows and 
Macintosh systems."


and

"the absence of a common cross-platform file format"

so getting data "into Quicken" could mean several things.

"newer versions of Quicken for Mac use an SQLite database"

So, my first question is going to be, 'which version of Quicken are you 
talking about?'


and my second one is going to be, 'Windows or Mac?'

and my third one is, 'Doesn't the person with this problem still have 
access to the version

of quicken they previously used?'

On 6.05.22 23:48, Bob Sneidar via use-livecode wrote:

Is QIF a text based format, or is it encrypted? If the latter (and it probably 
is), it is doubtful that there is a way to do this without software (of which 
there are some options if you google it).

Bob S



On May 6, 2022, at 13:40 , William Prothero via use-livecode 
 wrote:

Folks:
I have a nasty accounting problem and need to somehow get data into Quicken (or 
perhaps find another management program). My question is whether it’s possible 
(or known) how to take csv data (easy) and convert to acceptable QIF form, 
which quicken requires.

Best,
Bill Prothero

William Prothero
waproth...@gmail.com




___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Zip file problem on Mac

[Brian Milby via use-livecode]

It is a bug somewhere.  See this big report:
https://quality.livecode.com/show_bug.cgi?id=21447

I actually think it is related.  The zip should be created as a Unix variant 
and not Fat and file attributes should be stored.  One thing that could be 
tried is to manually set the executable bit when creating the archive.  I was 
able to store a link in a zip using this method, but there is no way to read 
the file attributes in LC.

Thanks,
Brian

Sent from my iPhone

> On May 6, 2022, at 3:10 AM, matthias rebbe via use-livecode 
>  wrote:
> 
> Hm,
> is it really a bug  or does revZip just stick to the zip specs?
> 
> 
> 
>> Am 06.05.2022 um 01:59 schrieb Neville Smythe via use-livecode 
>> :
>> 
>> I have submitting a report to QC (Bug 23698 
>> )
>> 
>> Thanks Matthias for clarifying that permissions are not correct in the 
>> archive. I can now add that the Linux archive has the same problem. The 
>> Windows archive created by revZip executes correctly.
>> 
>> So the problem is nothing to do with Apple. TheUnarchiver and Keka changing 
>> the permissions to what they think they ought to be sounds well-intentioned 
>> but highly problematic (what’s the meme for the opposite of an 
>> overprotective nanny? Busybody big sister?)
>> 
>> Your last comment caused me to realise that I have only changed very 
>> recently to automating the process of creating the zip files as a 
>> post-standalone build-process using revZip. Previously I created the zip 
>> files by hand, and my beta-tester uses Windows. Thought I was being clever. 
>> So the bug in the LC implementation may have been present for a long time.
>> 
>> Neville
>> 
>>> 
>>> Neville, i can confirm that behavior even under BigSur.
>>> 
>>> I've created a small standalone with LC 10DP3 on BigSur and created  2  zip 
>>> files  from the output folder using LC's zip library and using shell 
>>> command zip.
>>> 
>>> Running the shell command 'zipinfo' to analyse both zip files showed, that 
>>> the zip created with LC's zip library did not contain any executable 
>>> permissions while the zip created with macOS zip shell command did contain 
>>> the permissions.
>>> So it seems the LC's zip library does not store the permissions in the zip.
>>> 
>>> According to your comment about The Unarchiver. Yes, i can also confirm 
>>> that The Unarchiver and also Keka can extract the zip file created with LC 
>>> and the standalone in the extracted folder is executable again.
>>> But...
>>> As zipinfo did list all the files wihtout any executable permissions, i 
>>> unzipped the zip with the shell command 'unzip' and that standalone was not 
>>> executable again. All files showed exact those permissions that zipinfo 
>>> showed before.
>>> 
>>> So i assume the following: Keka and The Unarchive seem to correct file 
>>> permissions when they detect a folder structure that seems to be an app 
>>> bundle. But that's just an assumption.
>>> At least Keka seems to have such feature according to its change log 
>>> Changes in version 1.0.11 
>>> 
>>> 
>>> But anyway. The LC zip library ignores the permission when creating an 
>>> archive.  If this worked before with older versions of LC  i cannot say, as 
>>> i always used the zip shell command or tools like Keka.
>>> 
>>> 
>>> Matthias
>>> 
>>> 
>> 
>> ___
>> use-livecode mailing list
>> use-livecode@lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your subscription 
>> preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
> 
> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Anybody tried to import data to Quicken for Mac?

[Bob Sneidar via use-livecode]

Is QIF a text based format, or is it encrypted? If the latter (and it probably 
is), it is doubtful that there is a way to do this without software (of which 
there are some options if you google it). 

Bob S


> On May 6, 2022, at 13:40 , William Prothero via use-livecode 
>  wrote:
> 
> Folks:
> I have a nasty accounting problem and need to somehow get data into Quicken 
> (or perhaps find another management program). My question is whether it’s 
> possible (or known) how to take csv data (easy) and convert to acceptable QIF 
> form, which quicken requires.
> 
> Best,
> Bill Prothero
> 
> William Prothero
> waproth...@gmail.com
> 
> 
> 
> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Anybody tried to import data to Quicken for Mac?

[William Prothero via use-livecode]

Folks:
I have a nasty accounting problem and need to somehow get data into Quicken (or 
perhaps find another management program). My question is whether it’s possible 
(or known) how to take csv data (easy) and convert to acceptable QIF form, 
which quicken requires.

Best,
Bill Prothero

William Prothero
waproth...@gmail.com




___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Zip file problem on Mac

[Bob Sneidar via use-livecode]

Should be an enhancement request. 

Bob S


> On May 6, 2022, at 24:09 , matthias rebbe via use-livecode 
>  wrote:
> 
> Hm,
> is it really a bug  or does revZip just stick to the zip specs?


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Zip file problem on Mac

[matthias rebbe via use-livecode]

Hm,
is it really a bug  or does revZip just stick to the zip specs?



> Am 06.05.2022 um 01:59 schrieb Neville Smythe via use-livecode 
> :
> 
> I have submitting a report to QC (Bug 23698 
> )
> 
> Thanks Matthias for clarifying that permissions are not correct in the 
> archive. I can now add that the Linux archive has the same problem. The 
> Windows archive created by revZip executes correctly.
> 
> So the problem is nothing to do with Apple. TheUnarchiver and Keka changing 
> the permissions to what they think they ought to be sounds well-intentioned 
> but highly problematic (what’s the meme for the opposite of an overprotective 
> nanny? Busybody big sister?)
> 
> Your last comment caused me to realise that I have only changed very recently 
> to automating the process of creating the zip files as a post-standalone 
> build-process using revZip. Previously I created the zip files by hand, and 
> my beta-tester uses Windows. Thought I was being clever. So the bug in the LC 
> implementation may have been present for a long time.
> 
> Neville
> 
>> 
>> Neville, i can confirm that behavior even under BigSur.
>> 
>> I've created a small standalone with LC 10DP3 on BigSur and created  2  zip 
>> files  from the output folder using LC's zip library and using shell command 
>> zip.
>> 
>> Running the shell command 'zipinfo' to analyse both zip files showed, that 
>> the zip created with LC's zip library did not contain any executable 
>> permissions while the zip created with macOS zip shell command did contain 
>> the permissions.
>> So it seems the LC's zip library does not store the permissions in the zip.
>> 
>> According to your comment about The Unarchiver. Yes, i can also confirm that 
>> The Unarchiver and also Keka can extract the zip file created with LC and 
>> the standalone in the extracted folder is executable again.
>> But...
>> As zipinfo did list all the files wihtout any executable permissions, i 
>> unzipped the zip with the shell command 'unzip' and that standalone was not 
>> executable again. All files showed exact those permissions that zipinfo 
>> showed before.
>> 
>> So i assume the following: Keka and The Unarchive seem to correct file 
>> permissions when they detect a folder structure that seems to be an app 
>> bundle. But that's just an assumption.
>> At least Keka seems to have such feature according to its change log Changes 
>> in version 1.0.11 
>> 
>> 
>> But anyway. The LC zip library ignores the permission when creating an 
>> archive.  If this worked before with older versions of LC  i cannot say, as 
>> i always used the zip shell command or tools like Keka.
>> 
>> 
>> Matthias
>> 
>> 
> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode