an ASP.NET Open Source CMS & eCommerce platform
Search:
Skip Navigation LinksHome > DotShoppingCart Forums > Development > General Programming > Bulk Import and Order Pipeline
Bulk Import and Order Pipeline
Last Post 2/13/2009 10:33:46 AM By lukezy. 8 replies.
2/10/2009 11:29:33 PM
Redcorp
Posts: 11
Joined: 1/13/2009
Bulk Import and Order Pipeline
Hi Luke,
 
I am having trouble with the orderpipeline service.
 
I have done everything according to the documentation
 
<a target="_blank" href="../../View/Article/Documentation/Getting%20Started%20Guide/11.aspx">http://www.dotshoppingcart.com/View/Article/Documentation/Getting%20Started%20Guide/11.aspx. (Step 5)
 
http://www.dotshoppingcart.com/View/Article/Documentation/Online%20Help/Installation/101.aspx
 
but the Orderpipeline service does not start. Even When i manually start it, the product info and category totals do not update when i add a new product. I have to manually do it by
 
EXEC DSC_Category_Populate_Manufacture_Count 0, 0

EXEC DSC_Category_Populate_PriceRange_Count 0, 0
 
As a result, i cant run Bulk Import of the products from the text file.(I have mailed you a textfile containing all the products).
 
Please do advice.
 
Thanks
 
 

 
 
2/10/2009 11:43:03 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Bulk Import and Order Pipeline
There was the bug which we fixed in the V3.02.
change
            <add name="SiteConfigurationController" value="DotShoppingCart.Commercial.Core.DSCSiteConfigurationController"/>
to
            <add name="SiteConfigurationController" value="DotShoppingCart.Commercial.Base.DSCSiteConfigurationController"/>
in DotShoppingCart.Commercial.OrderPipelineService.exe.config.
 
If that doesn't fix your issue, please post back the full exception stack.
DotShoppingCart Staff
2/11/2009 3:23:17 AM
Redcorp
Posts: 11
Joined: 1/13/2009
Re: Bulk Import and Order Pipeline
Hi Luke,
 
I have done that too. Its still not working.
 
Where do I retrieve the exception stack?
 
Regards,
 
 
2/11/2009 7:46:50 AM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Bulk Import and Order Pipeline
Check here.
DotShoppingCart Staff
2/11/2009 9:54:45 PM
Redcorp
Posts: 11
Joined: 1/13/2009
Re: Bulk Import and Order Pipeline
Hi Luke,
 
 
I checked the event viewer for errors and there were none. The OrderPipeline is now working however my product list is not getting imported. I even tried creating one category and subcatergory and tried the import but it still does not import.
 
Please advice.
 
 
 
2/12/2009 10:19:18 AM
Bahram
Posts: 878
Joined: 12/8/2008
Location:Vancouver, BC Canada
Re: Bulk Import and Order Pipeline
Redcorp,
 
The first release of V3 had bugs in bulk import of Categeories and Products, Make sure you have the fix :
 
Here is the fix. Check with Luke and run the following sql script against your database.
 
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER FUNCTION [dbo].[DSC_Category_GetParentFullPath]
(
      @CategoryId INT
)
RETURNS NVARCHAR(256)
AS
BEGIN
      DECLARE @ParentFullPath NVARCHAR(256)
      SET @ParentFullPath = N''
 
      SELECT      @ParentFullPath = @ParentFullPath + c.name + N':'
      FROM  DSC_Category_GetParents(@CategoryId) p
      JOIN  DSC_Category c
                  ON c.categoryId = p.categoryId
      ORDER BY p.internalId DESC
     
      -- remove tailing /
      IF (LEN(@ParentFullPath) > 0)
            SET @ParentFullPath = LEFT(@ParentFullPath, LEN(@ParentFullPath) - 1)
      RETURN @ParentFullPath
END
 
 
Bahram
2/12/2009 10:07:53 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Bulk Import and Order Pipeline
You might want to download the latest version 3.02. There were several bug fixes for bulk import. Here is another quick check. Check you have the yellow background line in DotShoppingCart.Commercial.OrderPipelineService.exe.config. If not, add that and restart orderpipeline.
 
    <taskConfigurationdefaultProvider="">
        <providers>
            <addname="DataRefresh"type="DotShoppingCart.Commercial.OrderPipeline.DataRefreshTaskProvider, DotShoppingCart.Commercial.OrderPipeline" />
            <addname="EmailCampaign"type="DotShoppingCart.Commercial.OrderPipeline.EmailCampaignTaskProvider, DotShoppingCart.Commercial.OrderPipeline"dailyMaxCount="5000" />
            <addname="DailyCleanup"type="DotShoppingCart.Commercial.OrderPipeline.DailyCleanupTaskProvider, DotShoppingCart.Commercial.OrderPipeline"taskRunInterval="1440"startat="160" />
            <addname="TopSellerReset"type="DotShoppingCart.Commercial.OrderPipeline.TopSellerResetTaskProvider, DotShoppingCart.Commercial.OrderPipeline"taskRunInterval="43200"startat="200" />
            <addname="BulkImport"type="DotShoppingCart.Commercial.OrderPipeline.BulkImportTaskProvider, DotShoppingCart.Commercial.OrderPipeline"taskRunInterval="5" />
        </providers>
    </taskConfiguration>
 
 
 
 
DotShoppingCart Staff
2/13/2009 1:21:37 AM
Redcorp
Posts: 11
Joined: 1/13/2009
Re: Bulk Import and Order Pipeline
Thank you Bahram and Luke for your input.
 
I have done a full migration from the 3.00 to 3.02 to eliminate all config problems. I even went into debug mode to see if the file is being read and it reads the full content of the file without any issues. It just doesnt create the product list or the categories.
 
I am not sure what i am missing out on because its not even generating any errors. Is there anything else i need to do?
 
thanks
 
 
2/13/2009 10:33:46 AM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Bulk Import and Order Pipeline
The code doing the import is actually in the OrderPipeline service. Did you check DotShoppingCart.Commercial.OrderPipelineService.exe.config for the task that I mentioned above? Also make sure OrderPipeline server is running. If everything is good, then check store Admin > Catalog > Bulk Imports to see if you can find any bulk import log.
DotShoppingCart Staff
Project hosted at CodePlex.com
Copyright © 2013 DotShoppingCart. All rights reserved.