Difference between revisions of "Database - AC7"

From AbleCommerce Wiki
Jump to: navigation, search
 
(3 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
The AbleCommerce 7.0 database was completely rebuilt from the last major releases of version 5.5.  If you worked with the prior version, many tables will be familar and changed only in minor ways, such as names or field sizes.
 
The AbleCommerce 7.0 database was completely rebuilt from the last major releases of version 5.5.  If you worked with the prior version, many tables will be familar and changed only in minor ways, such as names or field sizes.
  
[[Media:AbleCommerce_70_Database_Schema.pdf‎|Database Schema (pdf)]]
+
[[Media:AbleCommerce_7.0.7_Database.chm‎|7.0.7 Database Schema (chm)]]
 +
 
 +
If you download the above file on Windows Vista or higher, you may need to unblock the file before you can browse the contents.  Right click on the downloaded file, choose properties, then click the button to unblock.
  
 
== Importing Data ==
 
== Importing Data ==
Line 10: Line 12:
 
* [[Data Port Utility]]
 
* [[Data Port Utility]]
  
 +
== Full Text Searching ==
 +
 +
Full text search is fully supported in AbleCommerce versions 7.0.5 forward for your product catalog.  This feature is only supported for SQL Server 2005 and above, and your database server must have the FTS service installed and available.  If you are using SQL Server Express versions, this feature is available when you install SQL Server Express with Advanced Services.
 +
 +
When using FTS, be aware that certain words are ignored in searches.  These are known as "stop words".  The [[stop words list]] can be customized if the default list is not appropriate for your situation.
  
 
== See Also ==
 
== See Also ==
Line 16: Line 23:
  
 
[[Data Access Layer]] (DAL)
 
[[Data Access Layer]] (DAL)
 +
 +
[[Category:AbleCommerce 7]]

Latest revision as of 10:31, 15 August 2013

The AbleCommerce 7.0 database was completely rebuilt from the last major releases of version 5.5. If you worked with the prior version, many tables will be familar and changed only in minor ways, such as names or field sizes.

7.0.7 Database Schema (chm)

If you download the above file on Windows Vista or higher, you may need to unblock the file before you can browse the contents. Right click on the downloaded file, choose properties, then click the button to unblock.

Importing Data

Many people want to import data directly to support custom integrations with other platforms. Some common tables may have special requirements when inserting data in them.

Full Text Searching

Full text search is fully supported in AbleCommerce versions 7.0.5 forward for your product catalog. This feature is only supported for SQL Server 2005 and above, and your database server must have the FTS service installed and available. If you are using SQL Server Express versions, this feature is available when you install SQL Server Express with Advanced Services.

When using FTS, be aware that certain words are ignored in searches. These are known as "stop words". The stop words list can be customized if the default list is not appropriate for your situation.

See Also

Custom Queries (Adding custom SQL to AbleCommerce .aspx pages)

Data Access Layer (DAL)