Hi.

Im currenttly trying to read in some data from a spreadsheet into our umbraco solution.

It is 213 nodes I need to create, but I keep getting a ServerTimeout Exception every 2. time I try to read in the data.

Anybody experienced this when trying to create a large amount of documents?

Heres my code:

protected void Commit_Spreadsheet(object sender, EventArgs e)
    {
        string excelpath = httpcontext.Server.MapPath("/media/" + Spreadsheet.FileName);
        Base.Print(excelpath);
        Spreadsheet.SaveAs(excelpath);
        DataSet ds = FonqiCode.NET.Change.ExcelToDataSet(excelpath, "Total");
        Base.Print(ds.Tables[0].Rows.Count);
        int counter = 1;
        DocumentType dt = DocumentType.GetByAlias("Contact");
        User u = new User(0);
        foreach (DataRow dr in ds.Tables[0].Rows)
        {
            if (!String.IsNullOrEmpty(dr[0].ToString()))
            {
                Document kontact = Document.MakeNew(dr[0].ToString(), dt, u, contactsFolderNodeId);
                kontact.getProperty("Name").Value = dr[0];
                kontact.getProperty("Title").Value = dr[1];
                kontact.getProperty("Email").Value = dr[2];
                kontact.Save();
                //contact.Publish(u);
                //umbraco.library.UpdateDocumentCache(contact.Id);
                //Base.Print((counter++) + " " + dr[0] + ", " + dr[1] + ", " + dr[2]);
            }
        }
        //umbraco.library.UpdateDocumentCache(contactsFolderNodeId);
        Base.Print("Done");
    }

Best regards 

Sune Fengel