Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 8 of 8

Thread: Excel Import

  1. 10-20-2009, 10:01 PM #1
    LawnMowerPros is offline Junior Member
    Join Date
    Oct 2009
    Posts
    2

    Default Excel Import

    When trying to import an excel file of products I get the following error:

    File Uploaded Error:
    Exception=Reading error: file is not a valid OLE2 Compound File.

    Could some one point me in the right direction?
  2. 10-21-2009, 12:16 AM #2
    ASPAlfred is offline Senior Member
    Join Date
    Nov 2007
    Posts
    2,244

    Default

    Are you saving the excel import file as .xls or .xlsx?
  3. 10-21-2009, 06:52 PM #3
    LawnMowerPros is offline Junior Member
    Join Date
    Oct 2009
    Posts
    2

    Default

    Saving it as an .xls instead of .xlsx fixed that problem but now I get a "Required Field (Price) Is Missing" error even though the prices are in the excel file.
  4. 10-22-2009, 12:51 PM #4
    factorite is offline Junior Member
    Join Date
    Oct 2009
    Posts
    22

    Question Unrelated, but seems a good place to post this...

    I'm evaluating ASPDNSF ( I like what i see so far! ) but when trying to import our products... I'm getting:

    Access to the path 'E:\Demos\AspDotNetStorefront\images\import.htm' is denied.
    I have the system running as localhost and it's probably an access permission that I missed in the setup. Any help I can get?
  5. 10-22-2009, 01:15 PM #5
    John Reasons is offline Senior Member
    Join Date
    Oct 2009
    Posts
    119

    Default

    Did you give the Network Service and ASPNET read write access to the image folder?
  6. 10-22-2009, 01:33 PM #6
    factorite is offline Junior Member
    Join Date
    Oct 2009
    Posts
    22

    Default

    Ah, I remember that step. Oh yeah, for users not familiar with ASP.Net, probably a good idea to tell them that the ASPNET user is a local user and not a Network user.

    Thanks! Worked like a charm!
  7. 10-22-2009, 01:39 PM #7
    factorite is offline Junior Member
    Join Date
    Oct 2009
    Posts
    22

    Default

    So, how does the import determine which products are "master" products and which ones are variants? Does it just base it on "IF all fields are identical" principle?

    I'm assuming you have it set up in the database as a parent child relationship
  8. 10-22-2009, 01:57 PM #8
    factorite is offline Junior Member
    Join Date
    Oct 2009
    Posts
    22

    Default

    Quote Originally Posted by LawnMowerPros View Post
    Saving it as an .xls instead of .xlsx fixed that problem but now I get a "Required Field (Price) Is Missing" error even though the prices are in the excel file.
    You might want to double check all your prices are numbers (without $ signs ) and not text.