Thanks for that Jacob, They'll (Mosso) let me set up a cron job but unfortunately just a PHP script. Now, I maybe able to use exec() to run unzip. Not sure how that will effect memory issues.
I don't remember what the type it is, but they write a bunch of files to our ftp account that we can download then unzip and import. I've downloaded once batch manually and I'm just working on queryng and processing the data locally. Then I'll try to get the import going -- yikes! I'll let you know how it goes. Tom Jacob Coby wrote: > I've worked with data from MLSs in NC, MI, FL, CA, NY. Never CT. > > I assume you're doing an IDX project? I don't have much experience > with IDX (I mostly used RETS pulls and threewide FTP pushes). > > As for importing the data using PHP, PHP's support for zip files is > annoying. Maybe there is something in PEAR or SPL to make it easier. > I issued shell commands. fgetcsv() is your friend for parsing the > data (assuming it's coming in as a CSV file). You'll probably run > into memory limit problems due to PHP's leaky garbage collector. Be > sure to stream the data (using fgetcsv()) and unset all loop variables > when you're done with them. If that fails, you'll have to raise the > memory_limit. > > Without shell access it's somewhat difficult to setup a cron job to > update the data. Maybe the web admin panel has a way to set one up? > > Barring that, you could have an external process (perhaps on your > server?) hit a page once a day on the client's server to load the IDX > zip file and import it. Or you could have the data delivered to your > server (assuming you have another server that you have shell access > to) and process it there. > > If that's a no-go, the office admin could make hitting the "update IDX > data" button part of his/her morning routine :) > > On Jun 10, 2008, at 4:04 PM, Tom Haskins-Vaughan wrote: > >> Hi Jacoby, >> >> Did you work on the CT MLS? My client's web host won't let me use a >> shell script. Do you think it's possible to import the data using PHP? >> I'll have access to a few commands through exec(). >> >> Tom >> >> Jacob Coby wrote: >>> Well, you got some of the cases handled. It doesn't handle the Mac >>> or >>> Mc prefix. It also won't work for any address that has abbreviations >>> (NC Hwy 12). >>> >>> I worked with MLS data sets for 8 years. There is no easy solution >>> for capitalization. There are always edge cases, exceptions, and >>> just >>> plain bad data. >>> >>> On Jun 10, 2008, at 1:38 PM, Tom Haskins-Vaughan wrote: >>> >>>> Excellent! Looks good. Thanks. >>>> >>>> Have you or has anyone else come across any shortcomings in this >>>> function? >>>> >>>> Guillermo Rauch wrote: >>>>> Look at this: >>>>> http://php.net/manual/en/function.ucfirst.php#81258 >>>>> >>>>> On Jun 10, 2008, at 2:08 PM, Tom Haskins-Vaughan wrote: >>>>> >>>>>> Hi, >>>>>> >>>>>> I have a data source (CT MLS property database) and the addresses >>>>>> are >>>>>> all give in uppercase letters: >>>>>> >>>>>> 23 WATER STREET >>>>>> >>>>>> I'd like it to appear 23 Water Street. >>>>>> >>>>>> I could use ucfirst(), which is fine, but I was wondering if there >>>>>> was >>>>>> any existing work on how to get around things like >>>>>> >>>>>> 49 O'Brien Avenue >>>>>> >>>>>> I could easily do this with regex on a list of known situations, >>>>>> but I >>>>>> was wondering if anyone had done the ground work before, so that I >>>>>> don't >>>>>> have to think of all different possible scenarios. >>>>>> >>>>>> TIA >>>>>> >>>>>> Tom >>>>>> -- >>>>>> Tom Haskins-Vaughan >>>>>> Temple Street Media: Design and Development for the Web >>>>>> [EMAIL PROTECTED] | www.templestreetmedia.com >>>>>> >>>>> Guillermo Rauch >>>>> http://devthought.com >>>>> >>>>> >>>> -- >>>> Tom Haskins-Vaughan >>>> Temple Street Media: Design and Development for the Web >>>> [EMAIL PROTECTED] | www.templestreetmedia.com >>>> >>> -- >>> Jacob Coby >>> [EMAIL PROTECTED] >>> >>> >>> >>> >> -- >> Tom Haskins-Vaughan >> Temple Street Media: Design and Development for the Web >> [EMAIL PROTECTED] | www.templestreetmedia.com >> > > -- > Jacob Coby > [EMAIL PROTECTED] > > > > > > > -- Tom Haskins-Vaughan Temple Street Media: Design and Development for the Web [EMAIL PROTECTED] | www.templestreetmedia.com --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~----------~----~----~----~------~----~------~--~---
