DwZone Forum Welcome to the DwZone-it Forum     FAQ   Search   Memberlist   Usergroups       Register -->   Login   Import/Export Tools   DwZone Forum Index -> Import/Export Tools Moderators: Administrators, Moderators  Mark all topics read Hint: For improved responsiveness, use Internet Explorer 4 (or above) with Javascript enabled, choose 'Dynamic' from the View dropdown and hit 'Set Options' to save your changes. Search for  View  Normal Expanded Dynamic Dynamic Memory Threaded Threaded Expanded Threaded Dynamic    Per page  102550    Messages Since  Last Visit Last Day Last Week Last Month Last 6 Months Last Year All Messages 81 to 90 of 382 (Total: 233) First |  Prev |  Next |  Last    Subject Author Date      Date issues with excel    MiguelQuintero   14:10 1 Dec 2011      Re: Date issues with excel    Gianluigi   14:33 1 Dec 2011      Re: Date issues with excel    MiguelQuintero   14:40 1 Dec 2011      Re: Date issues with excel    Gianluigi   14:52 1 Dec 2011      Re: Date issues with excel    MiguelQuintero   15:08 1 Dec 2011      Re: Date issues with excel    Gianluigi   6:57 4 Dec 2011      Re: Date issues with excel    Gianluigi   5:42 8 Dec 2011      Error 424 - Object Required...    A.Natale   3:24 22 Sep 2011      Re: Error 424 - Object Required...    Gianluigi   10:10 22 Sep 2011       Re: Error 424 - Object Required...    Antonio Natale   3:04 5 Oct 2011     Gent.mo Sig. Revello, sono risalito almeno al motivo del problema: in pratica c'è qualche carattere in uno standard diverso (il feed è UTF-8) che impedisce la corretta interpretazione del file xml... Il feed lo trova su http://revo1.revoagent.com/portali/lineacerignola.xml Ho il grossissimo problema, però, di non avere la libertà di formattare il feed a mio piacimento, percui lo devo inserire nel database così com'è. L'errore nella fattispecie è Microsoft OLE DB Provider for SQL Server error '80040e14' Sintassi non corretta in prossimità di 'AMATI'. Le righe di codice che inseriscono i nodi nel database sono: Dim dwzXml_XmlImport_1 Set dwzXml_XmlImport_1 = new dwzXmlImport dwzXml_XmlImport_1.Init dwzXml_XmlImport_1.SetStartOn "ONLOAD", "" dwzXml_XmlImport_1.SetProgressBar "0@_@200" dwzXml_XmlImport_1.SetRedirectPage "revo_4.asp" dwzXml_XmlImport_1.SetDisplayErrors "true" dwzXml_XmlImport_1.SetImportFrom "File" dwzXml_XmlImport_1.SetFilePath "/webadmin/revo_alt/xml/lineacerignola.xml" 'dwzXml_XmlImport_1.SetImportFrom "Url" 'dwzXml_XmlImport_1.SetFileUrl "http://revo1.revoagent.com/portali/lineacerignola.xml" dwzXml_XmlImport_1.SetConnection MM_MSSQL_db_STRING dwzXml_XmlImport_1.SetTable "MSSql42220.tb_imm_revo" dwzXml_XmlImport_1.SetTableUniqueKey "IDimmrevo" dwzXml_XmlImport_1.SetColIsNum "true" dwzXml_XmlImport_1.SetOnDuplicateEntry "NoVerify" dwzXml_XmlImport_1.SetXmlRepeatItem "Annuncio|_|Annunci/Annuncio" dwzXml_XmlImport_1.SetXmlUniqueKey "Codice|_|Annunci/Annuncio/Codice" dwzXml_XmlImport_1.SetExtraData "DD/MM/YYYY@_@1/0@_@''@_@'@_@0@_@'@_@Null@_@/" dwzXml_XmlImport_1.addItem "codice", "Xml", "S", "Codice|_|Annunci/Annuncio/Codice" dwzXml_XmlImport_1.addItem "regione", "Xml", "S", "Regione|_|Annunci/Annuncio/Regione" dwzXml_XmlImport_1.addItem "provincia", "Xml", "S", "Provincia|_|Annunci/Annuncio/Provincia" dwzXml_XmlImport_1.addItem "comune", "Xml", "S", "Comune|_|Annunci/Annuncio/Comune" dwzXml_XmlImport_1.addItem "zona", "Xml", "S", "Zona|_|Annunci/Annuncio/Zona" dwzXml_XmlImport_1.addItem "indirizzo", "Xml", "S", "Indirizzo|_|Annunci/Annuncio/Indirizzo" dwzXml_XmlImport_1.addItem "civico", "Xml", "S", "Civico|_|Annunci/Annuncio/Civico" dwzXml_XmlImport_1.addItem "tipologia", "Xml", "S", "Tipologia|_|Annunci/Annuncio/Tipologia" dwzXml_XmlImport_1.addItem "tipologia2", "Xml", "S", "Tipologia2|_|Annunci/Annuncio/Tipologia2" dwzXml_XmlImport_1.addItem "prezzo", "Xml", "N,", "Prezzo|_|Annunci/Annuncio/Prezzo" dwzXml_XmlImport_1.addItem "prezzo_riservato", "Xml", "B,1,0", "Prezzo_Riservato|_|Annunci/Annuncio/Prezzo_Riservato" dwzXml_XmlImport_1.addItem "anno", "Xml", "S", "Anno|_|Annunci/Annuncio/Anno" dwzXml_XmlImport_1.addItem "mq", "Xml", "Ni", "Mq|_|Annunci/Annuncio/Mq" dwzXml_XmlImport_1.addItem "mqbox", "Xml", "Ni", "MqBox|_|Annunci/Annuncio/MqBox" dwzXml_XmlImport_1.addItem "mqgiardino", "Xml", "Ni", "MqGiardino|_|Annunci/Annuncio/MqGiardino" dwzXml_XmlImport_1.addItem "mqbalconi", "Xml", "Ni", "MqBalconi|_|Annunci/Annuncio/MqBalconi" dwzXml_XmlImport_1.addItem "vani", "Xml", "Ni", "Vani|_|Annunci/Annuncio/Vani" dwzXml_XmlImport_1.addItem "camere", "Xml", "Ni", "Camere|_|Annunci/Annuncio/Camere" dwzXml_XmlImport_1.addItem "bagni", "Xml", "Ni", "Bagni|_|Annunci/Annuncio/Bagni" dwzXml_XmlImport_1.addItem "box", "Xml", "Ni", "Box|_|Annunci/Annuncio/Box" dwzXml_XmlImport_1.addItem "postiauto", "Xml", "Ni", "PostiAuto|_|Annunci/Annuncio/PostiAuto" dwzXml_XmlImport_1.addItem "scheda_statoimmobile", "Xml", "S", "Scheda_StatoImmobile|_|Annunci/Annuncio/Scheda_StatoImmobile" dwzXml_XmlImport_1.addItem "scheda_piano", "Xml", "S", "Scheda_Piano|_|Annunci/Annuncio/Scheda_Piano" dwzXml_XmlImport_1.addItem "scheda_totalepiani", "Xml", "S", "Scheda_TotalePiani|_|Annunci/Annuncio/Scheda_TotalePiani" dwzXml_XmlImport_1.addItem "scheda_tipocucina", "Xml", "S", "Scheda_TipoCucina|_|Annunci/Annuncio/Scheda_TipoCucina" dwzXml_XmlImport_1.addItem "scheda_balconi", "Xml", "S", "Scheda_Balconi|_|Annunci/Annuncio/Scheda_Balconi" dwzXml_XmlImport_1.addItem "scheda_taverna", "Xml", "S", "Scheda_Taverna|_|Annunci/Annuncio/Scheda_Taverna" dwzXml_XmlImport_1.addItem "scheda_terrazzi", "Xml", "S", "Scheda_Terrazzi|_|Annunci/Annuncio/Scheda_Terrazzi" dwzXml_XmlImport_1.addItem "scheda_giardino", "Xml", "S", "Scheda_Giardino|_|Annunci/Annuncio/Scheda_Giardino" dwzXml_XmlImport_1.addItem "scheda_cantinasolaio", "Xml", "S", "Scheda_CantinaSolaio|_|Annunci/Annuncio/Scheda_CantinaSolaio" dwzXml_XmlImport_1.addItem "scheda_riscaldamento", "Xml", "S", "Scheda_Riscaldamento|_|Annunci/Annuncio/Scheda_Riscaldamento" dwzXml_XmlImport_1.addItem "scheda_arredi", "Xml", "S", "Scheda_Arredi|_|Annunci/Annuncio/Scheda_Arredi" dwzXml_XmlImport_1.addItem "descrizione", "Xml", "S", "Descrizione|_|Annunci/Annuncio/Descrizione" dwzXml_XmlImport_1.addItem "foto", "Xml", "S", "Foto|_|Annunci/Annuncio/Foto" dwzXml_XmlImport_1.Execute()       Last Visit: Monday 9 Jun, 2025 10:44 am First |  Prev |  Next |  Last    Login Username:  Password:   Log me on automatically each visit:   Read Message   Unread message Read message [popular]   Unread message [popular] Read message [locked]   Unread message [locked] All times are GMT-2 Jump to:  Select a forum    Php Extensions --------------------  » Advanced Form Controls  » Advanced Image Gallery  » Advanced Mail  » Advanced Search  » Ajax DataGrid  » Ajax loader  » Boolean Update  » Dynamic Captcha Image  » Dynamic Chart  » Dynamic Image  » Form Validator  » Google Maps  » HTML to PDF  » Import/Export Tools  » Multi Column Combo  » Multiple file upload  » Multiple Record  » Other extensions  » PayPal IPN  » Query Manager and Recordset Wizard  » Recordset Paging  » Server Side Validation  » Shopping Cart  » Site Search Engine  » TreeView  » Two tables manager  » Upload and resize  » WYSIWYG Html Editor  Asp Extensions --------------------  » Advanced Form Controls  » Advanced Image Gallery  » Advanced Search  » Advanced Mail  » Ajax DataGrid  » Ajax loader  » Asp TreeView  » Asp Upload and Resize  » Boolean Update  » Dynamic Captcha Image  » Dynamic Chart  » Dynamic Image  » Form Validator  » Google Maps  » HTML to PDF  » Import/Export Tools  » Multi Column Combo  » Multiple file upload  » Multiple Record  » Other extensions  » PayPal IPN  » Query Manager and Recordset Wizard  » Recordset Paging  » Routing Map24  » Server Side Validation  » Shopping Cart  » Site Search Engine  » Two tables manager  » WYSIWYG Html Editor