FTP Text to DB

[Steph]

Hi and thanks in advance.

I'm looking for some help for the following;

A text file needs to be FTP'd to a site and then the contents of that
txt file needs to be inserted into a db, either on the fly or at a set
time.

The part I'm having probs with is the inserting the txt contents into
the db. The txt file will always be the same format and data within will
change. Old data can be wiped out as the new txt will have all the
current info.

eg of txt file: (this is not the real data but for arguemant sacks, lets
say it is.)

ProdName
ProdDescription
Price
SalePrice

DB will either be MS Access or MySQL. I've not yet decided until I see
the data and know the size.

The question is, can someone point me in the right direction? I seem to
be going round in circles with no answer to show for it.

Cheers
Steph.

[Larry Rekow]

On Wed, 11 Aug 2004 12:44:18 +1000, Steph <steph@scartdesign.com.au>
wrote:

>Hi and thanks in advance.
>
>I'm looking for some help for the following;
>
>A text file needs to be FTP'd to a site and then the contents of that
>txt file needs to be inserted into a db, either on the fly or at a set
>time.
>
>The part I'm having probs with is the inserting the txt contents into
>the db. The txt file will always be the same format and data within will
>change. Old data can be wiped out as the new txt will have all the
>current info.
>
>eg of txt file: (this is not the real data but for arguemant sacks, lets
>say it is.)
>
>ProdName
>ProdDescription
>Price
>SalePrice
>
>DB will either be MS Access or MySQL. I've not yet decided until I see
>the data and know the size.
>
>The question is, can someone point me in the right direction? I seem to
>be going round in circles with no answer to show for it.
>
>Cheers
>Steph.

++++++++++++++++++++++++++++++++++++++++++++++++++ +++++++
I do this a lot. i set up a script that automatically ftp's a text
file to a location on a web server. I link the text file as a table
in an access d/b. Every time the file is ftp'd, it over writes the
previous file, and the data is therefore automatically updated.

The key to it all is to link the file and not import it.

Larry Rekow
- - - - - - - - - - - - - - - - - -
"Forget it, Jake. It's Chinatown."

[Steph]

God dam!!!!

Here I was looking at all these wiz bang ways and it's that simple.

I need to simplify my thinking, but when searching the net, it's easy to
lose site of the true goal.

Thanks heaps for that too.

Cheers
Steph.

Larry Rekow wrote:

> On Wed, 11 Aug 2004 12:44:18 +1000, Steph <steph@scartdesign.com.au>
> wrote:
>
>

>>Hi and thanks in advance.
>>
>>I'm looking for some help for the following;
>>
>>A text file needs to be FTP'd to a site and then the contents of that
>>txt file needs to be inserted into a db, either on the fly or at a set
>>time.
>>
>>The part I'm having probs with is the inserting the txt contents into
>>the db. The txt file will always be the same format and data within will
>>change. Old data can be wiped out as the new txt will have all the
>>current info.
>>
>>eg of txt file: (this is not the real data but for arguemant sacks, lets
>>say it is.)
>>
>>ProdName
>>ProdDescription
>>Price
>>SalePrice
>>
>>DB will either be MS Access or MySQL. I've not yet decided until I see
>>the data and know the size.
>>
>>The question is, can someone point me in the right direction? I seem to
>>be going round in circles with no answer to show for it.
>>
>>Cheers
>>Steph.

>
> ++++++++++++++++++++++++++++++++++++++++++++++++++ +++++++
> I do this a lot. i set up a script that automatically ftp's a text
> file to a location on a web server. I link the text file as a table
> in an access d/b. Every time the file is ftp'd, it over writes the
> previous file, and the data is therefore automatically updated.
>
> The key to it all is to link the file and not import it.
>
> Larry Rekow
> - - - - - - - - - - - - - - - - - -
> "Forget it, Jake. It's Chinatown."

[John]

If you link the TXT as a table, then you must upload the whole table with
all the products??
And if you do so, and the txt have always the same format, why not opening
the TXT in ado directly?

I upload only the updated products (in xml format), run every 15 mnutes a
script in Cron, update the db.
You can use 1 txt for 1 product or all the updated product in 1 file

My txt looks like:

<product>
<action>A</action> (can be D for Delete, A for add, U for update)
<productId>109</productId>
<productName>Cheese<productName>
.....
</product>

John