Ciao a Tutti, problema: Se provo a exportare da "prodotti" in formato excel tutto funziona, mentre quando importo ricevo il seguente errore: Not a legal OleAut date.
Il sito è impostato: Current time zone: (GMT+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna
Qualcuno sa aiutarmi? Grazie Kele
Hello All, Problem: If I try to export from "products" excel everything works, but when I import I get the following error: Not a legal OleAut dates.
The site is set to: Current Time Zone: (GMT +01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna
(Translated by Microsoft Translator): mediakele wrote:
When exporto from products to Excel I generates a file with name:
products_2010-08-26-2-23-25_6619 .xls
If I edit and reloading (always by importing it from products: import from excel) from the following error: Not a legal OleAut dates.
I update the time in which I edit file progressive: >? Type: products_2010-08-26-2-23-25_6620 .xls {?}
I don't think it is the solution.
I do not know. Thanks to those who resolves to heart. Mediakele
Are you changing the values in the CreatedOn column in the Excel file before importing it? There should be an entry in the Log (Administration > System > Log) with more information about the error.
The error "Not a legal OleAut date." is caused by an argument exception when converting the OLE automation date to a DateTime via the DateTime.FromOADate method.
---
The error condition can be reproduced by setting a value for CreatedOn that is outside the valid ranges for an OLE Automation Date, before importing the file.