Visit SmartWin Technology Web Site Welcome to CyberOffice Warehouse Builder
-- a SmartWin CyberOffice eCommerce component
For Microsoft IIS platform (Windows 9x/NT/2000/XP/2003)
References:-
Full Development Guide | CyberBuild Product Page
Navigate to:-
Getting Started | What's Next | Sample Store | CyberClub | Shop Manager
Steps for non-English Web sites
Go Back
Getting started with the program

(If you haven't done so, please also Install CyberOffice Shopping Cart on your computer).

CyberOffice Warehouse Builder (CyberBuild) is a core component of SmartWin CyberOffice eCommerce. It is a premier Web-based business tool which lets you publish and manage a database driven catalog online to many Web sites from a single point of control. The program is designed to work in conjunction with Microsoft Internet Information Services (IIS). It consists a set of HTML and ASP pages, an ActiveX component (CyberBuild.Dll) and an ODBC-compliant database.

Microsoft IIS or a cut-down version of it, Microsoft Personal Web Server (PWS), is free from Microsoft. It can be installed/enabled on most Windows operating systems. The setup program assumes that IIS has been installed and is running on your computer. If this is not the case,  Check here on PWS/IIS installation. Run the setup program again after installing IIS or PWS. 

CyberBuild supports a variety of databases via the standard ODBC interface , including MS Access (97 and above), MS SQL (6.5 and above), Sybase Adaptive, and MySQL. The default is MS Access. For any other database, a working knowledge of it will be required.

Troubleshooting

Check your PWS or IIS settings on the site (from its Properties -> Home Directory) that Execute Permissions is set to either "Scripts Only" (recommended) or "Scripts and Executables".

If you have registered the DLLs onto Component Services, you need to enter a valid account on the computer (due to improved Microsoft security measures):

Start -> Settings -> Control Panel -> Administrative Tools -> Component Services -> Computers -> My Computer -> COM+ Applications -> CyberOffice -> (Right-mouse Click) Properties -> Identify -> Click on "This user" -> Enter typically your account with the computer -> OK.

The setup program automatically places the appropriate files on to the appropriate locations and properly registers them. However, file permissions might still need to be set for a special user account named IUSR_xxx (where "xxx" is the name of the computer). Use "Windows Explorer -> File -> Properties" to change the settings. Make sure you

  1. Disable the "Script Blocking" feature of Norton Anti-Virus (if installed on the computer). Or download ftp://ftp.smartwin.net/cyberdll.msi to install the DLLs as Component Services, see above.
  2. Set execute permission on CyberOffice DLLs (CyberShop.Dll, CyberClub.Dll, and CyberBuild.Dll). By default, they are either under c:\winnt\system32, c:\Windows\system32 or c:\inetpub\wwwroot\cgi-bin.
  3. Set Modify permission on the entire folder that contains the database(s). By default, the folder will be c:\inetpub\wwwroot\_private. Windows XP: Change the "Sharing" property of the folder to "Share this folder on the network".
     
  4. Download the latest DLLs and run the "Update-DLLs.bat " included in the file (on the server computer).

You need to view the Web pages through a Web server for any of the above mentioned links to function correctly. If you are having troubles, try this link http://localhost/warehouse/include or http://localhost/cybermall. You will be seeing the same page, but going through a Web server.

Quick Tour

CyberBuild works in conjunction with CyberOffice Shopping Cart (CyberShop, required) and CyberOffice Club (CyberClub, optional). The program adopts an open architecture with scalability on its database design, making it possible to run virtually any application within the framework. One of the distinct features is its franchising capability. You can create any number of storefronts, under any domains. Each store controls its own pricing and is able to upload its own products. It is Web-farm readiness and equipped with a state-of-the-art search engine feeding algorithm. The entire system is geared toward high-end, enterprise level applications.

CyberBuild comes with a sample store, which is fairly complete itself and can be simply adopted with minimal efforts. Here are a number of useful pages to control the shop:

Catalog Manager, Catalog Settings, Storefront Settings, Feature Page Manager, and  Supplier Upload

CyberBuild shares an integrated Shop Manager with other CyberOffice eCommerce programs. The default username is Administrator and password is Password. This gives you the control of nearly every aspect of the program within the browser. In particular you will set Shipping Methods, Payment Methods, Shipping Fees, Emails, Payment Gateway etc, and manage the daily orders from there. There is also a page to mark up the prices based on categories, down to individual product.

Back to Top
What to do next

CyberBuild comes with a free 30 days trial period, enough for you to evaluate the program. Before going live, you must purchase the license from SmartWin Technology or one of its authorized resellers. The Shop Manager has a license page for this purpose.

Because CyberBuild is a development tool, You will need to convert the sample store and modify properly other parts of the program to make it work for you. By default, you will find all the necessary files under the c:\inetpub\wwwroot\ folder. Following is an outline of some important steps you need to take.

To quickly replace the sample data with your own products, follow the steps: Shop Manager -> Add / Remove Products -> More Batch Options. Here you can simply delete the existing data, download a template (via download catalog database), then use the template to prepare your data and upload back to the system (via upload catalog database). You can edit the mapping of your input fields to the internal fields used by the program on Edit Field Mappings page.

CyberBuild's storefront pages are pure HTML pages. You can either edit them directly via any HTML editor of your choice (e.g. FrontPage or Dreamweaver.) or simply use the WYSIWYG Online Storefront Wizard facility.

Your own Product Database

If you already got a database of your products, send a sample set to us (info@smartwin.net). Or do it yourself with the following simple steps (assuming you have a MS Access 2000 or newer program):

  1. Download and Open the underlying warehouse.mdb or mall_warehouse.mdb database.
  2. Link your data (in Excel, Text, or another database) by "File --> Get External Data --> Link Tables ...".
  3. Edit "Global_Table --> InputTable" to point to the linked table.
  4. Edit "Field_Table" to map the fields in the input data to those internally used in "Catalog_Table" (the main product table). Try to re-use the existing definitions and fields. Try to configure Category, Brand, Model into "ProductType", "Field1", "Field2", etc. These fields will be the Indexes to the products.
  5. Alternative to steps 2-4, use the companion "Input.xls" to format your data and refresh the linked table "Input_Table" via "Tools --> Database Utilities --> Linked Table Manager".
  6. Run the "Delete Catalog Tables" and "Delete Field Index Tables" macros to delete existing products and indexes.
  7. Run the "Batch Process" macro, and then the "Update Field Index Tables" macro.
  8. Finally upload all the files to your live or production Web server.

Adding New Storefront

The following are typical steps to get it going. When you get used to the system you can move the storefront to any domain or folder.  Ignore Steps 3 and 4 if the new sites share the same shopping cart with the original site.

  1. Duplicate the folders warehouse (or Site1), shopping_cart (or Site1_Cart), membership (or Site1_Club) to Site2, Site2_Cart, Site2_Club.
  2. Modify the header info on header.js under Site2,  and Site2_Cart to,
             var my_track = "site2";
    And adjust my_initial variable to be a valid URL (relative to the new folders).
  3. Duplicate the database Shopping_Cart.mdb (or Site1_Shopping_Cart.mdb), Membership.mdb (or Site1_Membership.mdb) to Site2_Shopping_Cart.mdb, Site2_Membership.mdb.
  4. Modify Site2_Cart/config.asp, Site2_Club/config.asp to point to the new databases.
  5. Modify the global Admin Settings of the new membership and shopping cart to correctly link to each other. 
  6. Use the  Membership Sign Up  page to create a new premier account for the site owner, use the Membership Manager to approve it (change the Cancel Status to 0) and set the account information (Email and Shopping Cart).
  7. Use the Storefront Settings to register the new storefront into the system. You can start by editing the settings on the site from which you copied the files and then update.

CyberBuild is very function rich and fully customizable. Visit the Product Home Page for a updated summary of functions. More technical information can be found in the Full Development Guide. Contact info@smartwin.net if you have any questions.

Back to Top
Configure the software for non-English applications

CyberOffice eCommerce Software is fully equipped with universal language adaptability. Although at the moment you get a standard English version, this does not stop you from converting the programs into your own language. Following is an outline of the steps necessary to make the system work for you.

  1. Modify the visual parts of each Web page (*.htm; *.asp)  to your own language. Do NOT delete any JavaScripts on any HTML pages, or any VB Scripts on ASP pages. Make sure the appropriate "charset" value is set on the Content-Type meta tag. For example, for Simplified Chinese, you would set,

             <meta http-equiv="Content-Type" content="text/html; charset=gb2312">

  2. Edit as appropriately the visual interfaces of the program under any HTML editor that can handle your language. The storefront pages can be modified within the built-in online storefront wizard. The system also generates messages at run time. They can be translated using the custom50.asp Page Message Editor utility program.

  3. Additional system messages and mapping of field names to your own language can be defined on Shop Manager -> Custom Messages page and also on the Add /  Remove Catalog Items -> Edit Field Mappings page. There are some other configurations inside the shop manager that you can modify into your language as appropriate.

  4. Multiple-Byte characters: You might need to modify the warehouse database to index keywords by the alphabets of your language. To do so, please define your alphabetic order in the Intl_Alphabet table (shipped with sample data for Chinese GB characters). CyberBuild parses keywords and stores them into various keyword tables. The TableName field tells which table is to be used for which alphabetic segment. Run the Intl_Set_Alphabet macro to update the Search_Table table. The latter is the one that is actually used by the program. Run Build Search Index to re-build the keyword indexes.

  5. If you are running the software on a server that uses another language as the default language (such as English, United States), you must install the language pack on the server to include your language. The pack comes with Windows installation CD and can be added via Control Panel -> Regional Settings. Then edit each config.asp file on our software to call the appropriate language. For example, the settings for Chinese GB are

               Session.CodePage = 936
               Response.CharSet = "gb2312"          

Contact info@smartwin.net if you have any questions.

Back to Top

  Any comments, suggestions, or questions? Write Us!
  SmartWin Technology, 1997 - 2005