Trying to understand CatalogNodes

[dooleymort]

I am using the Demo version right now, and am trying to import categories, sub categories, and products from an existing SQL database. I understand what I need to do in the Categories and CategoryParents tables. But, I think I only understand a little of the relationships in the CatalogNodes table.

It seems to me that Main Categories have a record for each SubCategory with a CatalogNodeTypeId of 0. And that Sub Categories have a record for each product that they have with a CatalogNodeTypeId of 1. What value is the CatalogNodeId supposed to have?

Any insight will be appreciated.

Thank you,
Lila

[mazhar]

CatalogNodes table is used to keep parent child relation for categories and other catalog objects like products, web pages and links. Also for data import please read following topic
http://wiki.ablecommerce.com/index.php/ ... rt_Utility

[dooleymort]

Is that only for an existing AbleCommerce store? I have data from a wharehouse, that we get updates daily, so once I get all of the data in, I will also need to update categories, subcategories, and products each time we get new data.

[mazhar]

You can use dataport to import an existing AbleCommerce store, can take backup of your online store data and can make modifications in exported XML and then can use dataport utility to import those changes. Dataport also supports CSV import/export for products,users,orders and categories. So you can create a CSV file of data you get from warehouse and then adjust that CSV for dataport to import your data. Please read the topic I mentioned above to under stand dataport import/export features.

[dooleymort]

I installed the DataPort Utility and replaced the dll file in the /bin folderan dnow get a runtime error:

Server Error in '/' Application.
--------------------------------------------------------------------------------

Runtime Error
Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.

Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".


<!-- Web.Config Configuration File -->

<configuration>
<system.web>
<customErrors mode="Off"/>
</system.web>
</configuration>


Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL.


<!-- Web.Config Configuration File -->

<configuration>
<system.web>
<customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/>
</system.web>
</configuration>

When I put the old dll back, it's fine, but I'm guessing I've missed a step.

Thanks,
Lila

[mazhar]

What is your application version and version of dataport install you tried?

[Naveed]

I installed the DataPort Utility and replaced the dll file in the /bin folderan dnow get a runtime error:

Server Error in '/' Application.

It will be helpful if you can provide the detailed error log to identify the error. Please check the error log from ~/App_Data/Logs/app.log file for details about the error.

Or alternately if the application is working now, you can get it from Admin -> Help -> Error Log page.

Please copy paste the detailed error log from any or both of the above locations...

[dooleymort]

Here's the log file from App_data\Logs.
But, I don't see anything in the Admin/Help/ErrorLog.aspx
I am using the demo version of AC7. and installed the latest version of dataport (AbleCommerceDataPort_1.0.0.31.zip)

Thanks,
Lila

[dooleymort]

I've got the dataport installed now.
For anyone installing this, just make sure you have the current version.
The http://wiki.ablecommerce.com/index.php/ ... rt_Utility has a link to the old version of dataport.

The current one is at viewtopic.php?f=61&t=10053

Thanks for all your help everyone!