every hour produced by a txt file

Hi,
I need to update every hour produced by a txt file, can anyone help?
the file looks like this:

CodProdotto|EAN/UPC|CodProduttore|Brand|Thumbnail|FotoProdotto|FotoZoom|NomeProdotto|DescrizioneBreve|Scheda Prodotto|Listino|PromoListino|ScadenzaPromo|ListinoRiservato|ListinoRiservatoPromo|ScadenzaListinoRiservatoPromo|MacroCategoria|Categoria|Disponibilità|Peso
TR007704|||Acer|http://.../products/{AFF00F37-4B8A-4973-BF8F-C51ED48E497E}|http://.../products/{8042A028-0F5D-4422-828A-7239A78B9D1C}|http://.../products/{099F5883-47EA-42E3-8AAD-FF4DFEFD2100}|Monitor V203HB 20" LCD |DISPLAY 20" - WIDE - 1600 x 900 - 5ms - 10000:1 - 300cd/m² - NERO |http://www.sitoweb.net/pages/addon/basedati/export.asp?id={CEFEDB24-ACEB-432C-B389-14B956D7DE8B}&uid={7EBB446D-6C27-4FD7-8A08-9BA2A5E02992}|111,62|0|||||Monitor e TV|Monitor LCD|2|11
ACLO0413||980-000413|Acer|http://.../products/{B29C26F7-8624-485F-A6EC-E865D6DA8FD2}|http://.../products/{C8AD4667-233C-45AF-81CB-7A1FFDC1B2F7}|http://.../products/{F0B32192-563C-44C9-A76D-F0D185E0C896}|Speaker System Z313|Sistema Audio 2.1 - Compatibile Windows Xp/Vista/7 e Mac|http://www.sitoweb.net/pages/addon/basedati/export.asp?id={A9E1ED7C-F30F-41FC-BF43-58C7F3E452DB}&uid={7EBB446D-6C27-4FD7-8A08-9BA2A5E02992}|40|0|||||Audio e Video|Speakers|0|2
TR010042|||Acer|http://.../products/{09947F0C-840B-49D3-8D94-D4F2E949C6F6}|http://.../products/{EEAC067F-24AD-469A-AE77-910AEA1F51AF}|http://.../products/{72186082-5AB7-4993-A737-7FED24BDEAD4}|Aspire AS5732Z|Notebook Acer Aspire 5732Z - 443G50MNN (LX.PMZ02.049) - Cpu Intel T4400 - Display Lcd 15.6 CrystalBrite - Memoria Ram 3 Gb - HD 500 Gb - Wireless Wifi 802.11BGN - Batteria 6 Celle - Webcam - Windows 7 Home - Articolo soggetto a contributo SIAE di euro 2.40|http://www.sitoweb.net/pages/addon/basedati/export.asp?id={8EDB4241-F047-48B2-9BF3-273C13539A0C}&uid={7EBB446D-6C27-4FD7-8A08-9BA2A5E02992}|455,4345|0|||||NoteBook e NetBook|Notebook|0|4
TR010587|||Acer|http://.../products/{2CA54566-33EA-4772-BC81-77551D2E7141}|http://.../products/{CE72BACA-BE5F-4869-8917-C1967AE34584}|http://.../products/{CB9C421E-0B82-4946-88F5-5D5C4450FEB8}|Aspire 5738PG TouchScreen |Notebook Acer 5738PG-664G50MN (LX.PK802.059) - Cpu Intel Core 2 Duo P6600 - Display Lcd 15,6" Wide TOUCHSCREEN - Memoria Ram 4Gb - HD 500Gb - Vga Ati Radeon HD 4570 512MB dedicata - Webcam - Windows 7 Home 64Bit - Articolo soggetto a contributo SIAE di euro 2.40|http://www.sitoweb.net/pages/addon/basedati/export.asp?id={E0B5DEAA-4AB4-4F07-AF18-E2D51DD5F508}&uid={7EBB446D-6C27-4FD7-8A08-9BA2A5E02992}|619,974|0|||||NoteBook e NetBook|Notebook|0|8
TR010417|||Acer|http://.../products/{3D8275D4-6D81-4DA5-81E2-D30107277283}|http://.../products/{91C3D93B-E1EC-4CB5-9259-0A3237DBC3E6}|http://.../products/{35FB29F7-B169-449E-9162-15113EB6425B}|5541-304G32MN |Notebook Acer 5541-304G32MN (LX.PQN02.008) - Cpu Amd Athlon64 X2 M300 - Display Lcd 15.6 LED CB - Memoria Ram 4Gb - HD 320Gb - Wireless Wifi 802.11BGN - Batteria 6 celle - Webcam - Windows 7 Home Premium - Nero - Articolo soggetto a contributo SIAE di euro 2.40|http://www.sitoweb.net/pages/addon/basedati/export.asp?id={7E69C071-8B29-406D-97A8-806231C7FDD4}&uid={7EBB446D-6C27-4FD7-8A08-9BA2A5E02992}|464,1291|0|||||NoteBook e NetBook|Notebook|0|4,9
HWTEL799|8033779006296|715799|Alcatel|http://.../products/{9610D86A-D83C-40BF-AE16-6541676E152B}|http://.../products/{64E55752-32A4-4BD3-B369-0FCC4D3997A9}|http://.../products/{013CAA13-C135-402D-B906-D9AA2AB2A4C8}|X215s Chiavetta internet|TIM 715799 CHIAVETTA Alcatel X215s ROSSO|http://www.sitoweb.net/pages/addon/basedati/export.asp?id={B28CAAEB-AE98-4A42-B886-13D8452C1CA9}&uid={7EBB446D-6C27-4FD7-8A08-9BA2A5E02992}|40,83|0|||||Chiavette internet|HSUPA 7,2|0|0,5
HWTEL797|8033779006272|715797|Alcatel|http://.../products/{28F4BC1A-4CE1-4FEF-AE58-682270D390D1}|http://.../products/{C2EBB25F-6189-42BD-8EE7-98CF551B7557}|http://.../products/{5073EE1F-E3B9-4F45-AFEA-6A8E4CD2327C}|X215S Chiavetta internet |TIM 715797 CHIAVETTA X215S Blu|http://www.sitoweb.net/pages/addon/basedati/export.asp?id={CDA5ED64-85CF-4F7C-BCEF-3D108428FEE4}&uid={7EBB446D-6C27-4FD7-8A08-9BA2A5E02992}|40,83|0|||||Chiavette internet|HSUPA 7,2|0|0,3
HWTEL798|8033779006289|715798|Alcatel|http://.../products/{654F0870-6E47-45D9-91C8-606CDFB9E001}|http://.../products/{DAF1CD98-7A61-4067-BC22-EFA8DAA51EB6}|http://.../products/{606E8757-68CD-4599-B08B-3036E5AC8FCA}|X215s Chiavetta internet |TIM 715798 CHIAVETTA X215s Azzurro|http://www.sitoweb.net/pages/addon/basedati/export.asp?id={7E142253-C097-4002-9685-9635954FC0F2}&uid={7EBB446D-6C27-4FD7-8A08-9BA2A5E02992}|40,83|0|||||Chiavette internet|HSUPA 7,2|0|0,5
TR008239|||AMD|http://.../products/{F3E917A9-74C9-416D-B6F2-2922DC9D457B}|http://.../products/{A75F8BDD-EB67-40F6-8CB2-9FB6C3216531}|http://.../products/{868B6BDB-A7E1-47FA-B043-07923D49D653}|CPU SEMPRON 140 AM3 BOX|CPU Sempron 140, Single Core, Core Sargas, 45nm, 64bit, 2.7GHz, FSB 2000MHz, Cache L2 1MB, Socket AM3, Box, 45W, attivo|http://www.sitoweb.net/pages/addon/basedati/export.asp?id={9C618E67-7E0D-4D8D-B4EB-A0EAC279B4D7}&uid={7EBB446D-6C27-4FD7-8A08-9BA2A5E02992}|34,3052|0|||||CPU processori|SK AM3|0|0,6

I create a php script, but I do not know MySQL commands and tables on which to operate.
Zencart version is 1.3.8
Thank you.

You're asking for custom development, and would get better reception over in the Commercial Help Wanted forum channel.

serve just some ideas to start

thanks

[QUOTE = Blindside ; 908.339 ] Mi stai chiedendo di sviluppo personalizzato , e si fà una migliore ricezione anni nel [URL = " http://www.zen-cart.com/forum/forumdisplay.php?f=138 "] Help Wanted commerciale [/ URL canale forum] . [/ QUOTE]

I tried to Buut down a little script but does not work, I will have done something wrong? : Cry: : Oops :

<?php require 'config.php'; require 'connect.php'; $file = "/var/www/vhosts/sitoweb.it/httpdocs/new-store/script/THENET_SCHEDE_ESEMPIO.txt"; $fp = fopen($file, "r"); $data = fread($fp, filesize($file)); fclose($fp); $output = str_replace("\t|\t", "|", $data); $output = explode("\n", $output); foreach($output as $var) { $tmp = explode("|", $var); $products_model = $tmp[0]; $products_price = $tmp[10]; $products_weight = $tmp[19]; $products_quantity = $tmp[18]; $products_name = $tmp[7]; $products_description = $tmp[8]; echo $products . "<br>"; $sql = "INSERT INTO $table SET categories_name='$products'"; mysql_query($sql); $sql = "INSERT INTO table SET CodProdotto='$products_model', NomeProdotto='$products_name', DescrizioneBreve='$products_description', Listino='$products_price', Disponibilità='$products_quantity', Peso='$products_weight',"; mysql_query($sql); } echo "Done!"; ?>