useful to accomplish automating MLS direct feed into MySQL
DB?
I was sent with the property information and I didn't see any
column names in the info.
It might be a problem, unless there is a possibility to set the ODBC
connection not to use the first row, I don't know.
But since you get
Hi, all.
I assume some of you work on Real Estate sites where
you have to deal with a direct feed of data from MLS's.
The direct feed for one of my Real Estate sites currently
in development will be in the form of an FTP site, from which
I can download a zip file with all files, including a tab
, 2008 10:27 AM
To: CF-Talk
Subject: Tags useful to accomplish automating MLS direct feed into MySQL
DB?
Hi, all.
I assume some of you work on Real Estate sites where
you have to deal with a direct feed of data from MLS's.
The direct feed for one of my Real Estate sites currently
in development
.
-Original Message-
From: Jerry Guido [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 17, 2008 12:26 PM
To: CF-Talk
Subject: RE: Tags useful to accomplish automating MLS direct feed into
MySQL DB?
I did this a number of years ago. The MLS listing were in a 20-50(?) meg
XML file. I was using CF 5
-Original Message-
From: Jerry Guido [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 17, 2008 12:26 PM
To: CF-Talk
Subject: RE: Tags useful to accomplish automating MLS direct feed into MySQL
DB?
I did this a number of years ago. The MLS listing were in a 20-50(?) meg
XML file. I
That's great to hear... I'll have to check on that feature in MySQL.
Thanks!
Rick
-Original Message-
From: Jerry Guido [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 17, 2008 12:38 PM
To: CF-Talk
Subject: RE: Tags useful to accomplish automating MLS direct feed into MySQL
DB
I will then import the tab delimited info and property filenames into
an MySQL database, and place the property photos into the appropriate
local server directory.
Are you under Windows?
The easiest (although not trivial) way to do it is to define an ODBC DSN
using the Microsoft Text Driver
Thanks for the info, Adrian.
Especially on the use of CFLOOP!
Rick
-Original Message-
From: Adrian Moreno [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 17, 2008 4:24 PM
To: CF-Talk
Subject: Re: Tags useful to accomplish automating MLS direct feed into MySQL
DB?
Regarding
Regarding CF taking forever to read/parse large files:
CF used to load the entire file into memory when trying to read it. It was
still doing this as of CF 6 7, but since it was then easier to directly
invoke Java, large files could be better handled using java.io.FileReader.
to accomplish automating MLS direct feed into MySQL
DB?
Regarding CF taking forever to read/parse large files:
CF used to load the entire file into memory when trying to read it. It was
still doing this as of CF 6 7, but since it was then easier to directly
invoke Java, large files could be better handled
automating MLS direct feed into MySQL
DB?
I will then import the tab delimited info and property filenames into
an MySQL database, and place the property photos into the appropriate
local server directory.
Are you under Windows?
The easiest (although not trivial) way to do
Interesting approach. Is there someplace I can read up on this approach?
Dunno, I managed to set it horsing around with the ODBC manager in Windows.
See Administrative tools -- ODBC manager.
You must have a special directory dedicated to your .csv files, then you
set your txt csv ODBC driver
production tables. From there I should be good to go.
Thoughts on that process outline?
Rick
-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 17, 2008 10:17 PM
To: CF-Talk
Subject: Re: Tags useful to accomplish automating MLS direct feed
I was sent with the property information and I didn't see any
column names in the info.
It might be a problem, unless there is a possibility to set the ODBC
connection not to use the first row, I don't know.
But since you get the file by FTP, you can still append it to a one line
file
14 matches
Mail list logo