Re: Import from Quicken 2004 Mac?
might want to look at QIF Master. Generally designed to convert lists of data into QIF formats but Mr. Wooward may have some other tools to go the other way also. c On Aug 11, 2011, at 5:02 PM, David Brian Chait wrote: I don't think I have ever heard of anyone directly importing a QIF into any relational database, you would have to translate the resulting data into a delimited txt file and then import. You may want to check to see if Quickbooks has an API that you can use to access the data natively rather than trying to move it around from platform to platform. -Original Message- From: Jan Steinman [mailto:j...@bytesmiths.com] Sent: Thursday, August 11, 2011 2:37 PM To: David Brian Chait Cc: mysql@lists.mysql.com Subject: Re: Import from Quicken 2004 Mac? On 11 Aug 11, at 14:17, David Brian Chait wrote: The QIF file includes a lot of data aside from basic transactions, what exactly are you trying to end up with at the end of the day? Simply a copy of your QB data in Mysql? That would be a good start. We don't need a complete duplicate, but in my experience, it's easier to get it all and winnow out the bits you don't want than to selectively import. That said, we really only need the basic transaction info: date, payee, amount, memo, category, account from, account to. This is to reconcile the chart of accounts (in Quick Books) with project management (in MySQL). From: Jan Steinman [mailto:j...@bytesmiths.com] Sent: Thursday, August 11, 2011 2:15 PM To: mysql@lists.mysql.com Subject: Import from Quicken 2004 Mac? I'm looking for ways to import QuickBooks 2010 Mac. I've only just started researching this, so feel free to "RTFM" me -- with a proper reference, of course! I'll be wanting to set up a process to do this periodically (and hopefully, automagically) for new transactions. QB 2010 Mac appears to only export ".IIF" format, which appears to be a variant of the older ".QIF" format, and Google didn't turn up really anything for getting IIF/QIF files into MySQL. The best I could find would be importing them into Excel first, then CSV out of Excel into MySQL, which sounds like a lot of bother and not readily scriptable for routine use. I find it hard to believe I'm the first one to ever attempt this! IIF/QIF seems to be a rather unusual format. Lacking a one-step MySQL import tool, does anyone know of good parsers and translators for IIF/QIF that may be useful? Thanks in advance for any advice offered! Science uses mathematics to predict the future; economics uses statistics to predict the past. -- Jeff Barton Jan Steinman, EcoReality Co-op -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=dch...@invenda.com Always do right. This will surprise some people and astonish the rest. -- Mark Twain Jan Steinman, EcoReality Co-op -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=celha...@mac.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
using a count function
This is probably pretty obvious to everyone except me. I have a couple of columns, DateOfInterview and DateOfBirth in a table named Demographics For a monthly report I have a script where the operator enters the start and end dates of the reporting period. I need a query result with single line of three columns, each with a count of the number of interviews for that reporting period: || Under 18 ||19-65 || over 65 || ||5|| 19|| 23 || I've made three queries to select the counts for each age range, then used them to form another query I thought would give me an acceptable output. This gives me multiple lines, all with the same numbers: SELECT Count([Under 18 count].[Under 18]) AS [CountOfUnder 18], Count ([19 to 65 count].[19 to 65]) AS [CountOf19 to 65], Count([Over 65 count].Over65) AS CountOfOver65 FROM [Under 18 count], [19 to 65 count], [Over 65 count], Demographics WHERE (((Demographics.[Date of Interview]) Between [Report Start Date] And [Report End Date])); || Under 18 ||19-65 || over 65 || ||5|| 19|| 23 || ||5|| 19|| 23 || ||5|| 19|| 23 || Like I said, this should be pretty obvious to everyone but me. chris. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
probably a permissions problem that I cannot figure out.
mySQL-5.1.34-osx10.4-powerpc-64bit Not sure how this happened, but mySql will not start anymore, either from the command line or the system pref control panel. here's a startup sample: [I have blocked out the password] Power-Mac-G5:/usr/local/mysql chriselhardt$ sudo /usr/local/mysql/bin/ mysqld_safe --user=root --password= /usr/local/mysql/bin/mysqld_safe: line 209: /usr/bin/grep: cannot execute binary file 100113 16:21:07 mysqld_safe Logging to '/usr/local/mysql/data/Power- Mac-G5.local.err'. 100113 16:21:07 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 100113 16:21:08 mysqld_safe mysqld from pid file /usr/local/mysql/ data/Power-Mac-G5.local.pid ended Power-Mac-G5:/usr/local/mysql chriselhardt$ pwd /usr/local/mysql and another one: Power-Mac-G5:/usr/local/mysql chriselhardt$ sudo /usr/local/mysql/ support-files/mysql.server start Starting MySQL.. ERROR! Manager of pid-file quit without updating file. where are the config files supposed to be? ~Users/ chriselhardt/.my.cnf has only a single line, [mySQL] and I'm pretty sure there used to be more in there than that. Thanks for any assistance. "In the space of one hundred and seventy-six years the Mississippi has shortened itself two hundred and forty-two miles. Therefore ... in the Old Silurian Period the Mississippi River was upward of one million three hundred thousand miles long ... seven hundred and forty-two years from now the Mississippi will be only a mile and three-quarters long. ... There is something fascinating about science. One gets such wholesale returns of conjecture out of such a trifling investment of fact." M. Twain -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
startup in OS-X
apologize for the newbie question. installed mySQL 4 some time ago, and just played around with it in terminal. Now that I really need to learn some database, I can't get it to start in terminal. it autostarts; I can see it in the activity monitor as a background process. but when I try to invoke it from Term I get a 'cmd not found' message. trying to figure out what I'm doing wrong: chris. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]