AbleCommerce Shopping Cart Software

Seems I need an MSSQL DBA to do this.. Heres an example of the code. Learn your SQL Query Language. Start here as a tweak. It will show you In SQL Server Management Studio Express (New Query) what it will do if you change the code a bit. Google your SQL language examples and reverse engineer your co...

I have successfully upgraded my 5.5 CFMX cart to 7.0 ASP. I notice that to get my HTML listed in the WEBPAGES table I will have to find ever "content" in that table and manually change the .cfm extension to a .aspx extention. Im sure I can do a find and replace where ".cfm" is changed to ".aspx" Fur...

I was using native mode in SQL2005 full version. Able walked me thru a Mixed mode config. That was the problem. I saw no documentation about using a Mixed/Native config.

Thanks to all..

See what the server name is in management studio under database engine.

I am new to management studio. I am not finding "database engine" in management studio. even in the help file im not seeing it. Can some one guide me?

In hooking to the Database "/Install/Configure1.aspx" Using SQL 2005 full version, I can not get the DB to resolve. It asks for connection string Variables: Database Connection Specify the database that will be used by AbleCommerce: Specify database To use this option, the database you specify must ...

That did not do it. However in following the Installation Readme doc . Prerequeisites #2 is misleading. 2: Give the ASPNET process (user account) write permissions to the folder where the AbleCommerce files are to be placed. If you use shared hosting , you may need to contact your service provider t...

Following the Installation Readme for .x Asp.Net. Installation * If you are installing AbleCommerce 7.0.3 and your system is running with ".NET Framework Version 3.5", continue to step 3. 3. Browse to http://<domain>/<folder_optional>/install/default.aspx I am, I did, and after a reboot reset some I...

Thanks.. Got it....

In following the 7.0 setup on Installation Readme it says: Create a Database These steps are not required if you have installed and are using the included SQL 2005 Express database file. 1. Create a new blank database. (only for Microsoft SQL Server 2000 or 2005) 2. Create a new user login, or use a...

My server has died a horrible death however I have a full backup of CFMX 5.5 Build 1361, MySQL4.1 DB. However.. I now sit here with a CFMX5.5 Backup and i have restored it to MySQL4.1 And it is intact on a new server. My goal is to be on 7.0 and i have the license. Can someone guide me through the p...

Public, Hidden or Private, are the equivalent in CFMX. Green is Public, Red is Hidden, and Yellow is Private or Locked. Its the same. The 3 settings are as ASP version settable in the catalog, and in the product/webpage/link/category details page as well. However I have only seen in those pages that...

I am actually using CFMX but im migrating to 7.0, and im sure the data table structure is the same. In a category in the site admin you can change the status of a product/webpage/link/category by clicking the Green/Red/Yellow Lock option. I have learned that when I create a new product or edit a pro...

Regarding your 2nd query: The url re-writing pattern is similar in AC55 and AC7. I hope a simple replace of ".cfm" with ".aspx" will work. I just went to one of ables store showcases (DBATinc.com) and tried it. Seems Ill have to change the _P, _C, _W links to -C, -P, -W. AND change .cfm to .aspx. A...

From what I am thinking I can just go to each webpage and do a find an replace ".cfm" to ".aspx" Any imput? I'm not sure why a find/replace would not work. The URL semantics look similar if not the same. Someone who is familiar with both 5.5 and 7.0 URLs will need to chime in. Assuming they will wo...

The standard store export feature in AC55 CFMX stores does not offer the facility to export data for extra fields and extra tables. Also using DataPort you can only import data in standard AC55 fields and standard tables. To migrate your data in extra fields and extra tables you have to write some ...

As stated in http://forums.ablecommerce.com/viewtopic.php?f=61&t=9973 I have a Able5.5CFMX cart with MySQL 4.1 DB with some custom fields put in the Products table. When migrating from 5.5 to 7.x how will I get all of that data migrated into 7.x. I have extra tables too but they are static and I can...

I am on 5.5 CFMX Build 1361 and am migrating from MySQL4.1 to MSSQL and trying to wrap my head around the migration procedure. Some Data Issues: 1) The Products table has a few fields added to it that are populated with important info that are not default fields. 2) The Webpages tables Content field...

I have been playing with a vendors ASP 7.0 sandbox development load.

I am trying to see if I can put a kit within a kit. It could not be done in CFMX 5.5, But was hoping it could be done in ASP7, heck it does every darn thing else!

Mary:

You never did give me a migration quote.
Contact off list plz.

I have CF5.5 version and based on the fact that Able will no longer be upgrading CFMX versions of their code and I need to utilize custom code I wish to migrate from 5.5CF to 7.0ASP. I have custom database fields being used in MySQL 4.1. I also want to have this hosted outside our site, and have the...

On the 13th I replied as to the help file: I don’t accept zips. Rename it to something harmless like pdf or something and then let me know I need to change it. Again. Rename the extension to something harmless and let me know what to rename it. It will get through that way. We have pretty stiff re...

Hi George. First of all I LOVE the Meta Tag Manger. Just its ability to dynamically manage product meta tags makes it well worth the price. I figured I would post here for my problem so others could see the solution if they encountered it. I am working heavily with the Cateogories, & webpages these ...