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 5 of 5

Thread: MSSQL Import

  1. 04-22-2013, 02:23 PM #1
    edewsnap is offline Junior Member
    Join Date
    Jun 2009
    Posts
    16

    Default MSSQL Import

    I would like to insert products directly into the product table and manage the Category and Subcategory relationship through SQL instead of the user doing this through the UI. I have figured this out as far as mapping the values and foreign keys etc. however I have no idea what the GUID field is for. I know it is required as it is set for non null. I inserted a new category directly into the table and used an existing CategoryGUID value and it appeared to work. Can someone explain this value what it means and let me know if what I am trying to do is possible?

    Thanks
  2. 04-23-2013, 04:36 AM #2
    cjbarth is offline Senior Member
    Join Date
    Oct 2008
    Posts
    392

    Default

    The GUID field is a Globally Unique IDentifier. It should be different for each row and can be made up. I honestly don't think it is used and it is the #1 reason I can't port ASPDNSF to Azure SQL (Azure SQL doesn't support GUID fields).
    Last edited by cjbarth; 04-25-2013 at 04:34 AM.
    ML9.3.1.1
    SQL 2012 Express
    VS 2010
    Azure VM
  3. 04-23-2013, 12:51 PM #3
    jsimacek is offline Senior Member
    Join Date
    Dec 2008
    Location
    Phoenix, AZ
    Posts
    373

    Default

    Correct, it's a guaranteed unique identifier...you can generate it on the fly in T-SQL by using the newid() command. The cart uses it for identification/retrieval during record creation, but it isn't used much after.
    Jan Simacek - Compunix, LLC
    AspDotNetStorefront trusted Devnet Partner and Reseller since 2005

    AspDotNetStorefront Mods and Add-Ons at http://www.ecommercecartmods.com/
    - Searching, Filtering and Sorting (like cSearch, Dealer Locator, Price Ranges, Blog)
    - Reports (like Cart Abandonment and Net Sales)
    - Customer Experience (like Question/Answers)
    - Site and Data Management (like Entity Product Mapper, Bulk Updaters, Make/Model/Year filters)
  4. 04-23-2013, 01:04 PM #4
    cjbarth is offline Senior Member
    Join Date
    Oct 2008
    Posts
    392

    Default

    Globally Unique IDentifier

    http://en.wikipedia.org/wiki/Globally_unique_identifier
    http://msdn.microsoft.com/en-us/libr...stem.guid.aspx
    http://betterexplained.com/articles/...uide-to-guids/
    ML9.3.1.1
    SQL 2012 Express
    VS 2010
    Azure VM
  5. 04-24-2013, 10:37 AM #5
    edewsnap is offline Junior Member
    Join Date
    Jun 2009
    Posts
    16

    Default

    Thanks for the response folks, I am on to greatness with this news!!!