(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

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).
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 Write 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.

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 ability. 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 Settings, Storefront & Franchise Control Panel, Feature Page Manager, Catalog 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.

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.

1. Modify each storefront page's meta tags and copyright information. Add necessary information to complete pages. This can be done using any HTML editor. But do not delete or alter any JavaScript codes.

2. Prepare your Product Table using the companion Input.xls (can add new fields to it); Open either warehouse.mdb or Mall_warehouse.mdb database; Link your data by "File --> Get External Data --> Link Tables ...".

3. Edit "Field_Table" to map any new fields in the input data to those internally used in "Catalog_Table" (add the field to to table as necessary). Keep or re-use the existing definitions and fields.

4. Run the "Delete Catalog Tables" and "Delete Field Index Tables" macros to delete existing products and indexes; Run the "Batch Process" macro, and then the "Update Field Index Tables" macro.

5. Finally upload all the files to your live or production Web server. You can find more on uploading instructions from the shop manager's online references.

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.

CyberOffice eCommerce Software is fully equipped with universal language capability. Although at the moment you get an 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 storefront page (*.htm) and each Active Server Pages page (*.asp) to your own language. Do NOT delete any JavaScripts on any HTML pages. Care must be taken when editing ASP pages. If you are not used to ASP, Notepad is recommended to edit an ASP page. Make sure the appropriate "charset" value is set on the Content-Type meta tag,
   
            <meta http-equiv="Content-Type" content="text/html; charset=">

2. The system also generates messages at run time. On top of some ASP pages, there are defined messages used by the page. For example, on shopping_cart/order.asp page, there is
   
              Session(DSN+"order"+"M3") = "Free Delivery; "
   
   If your language is configured as the native language on the server, you can simply change them into your own language. Otherwise, you need to use VB Script function ChrW(char_code) to define wide characters, one by one, then concatenate them, e.g. ChrW(1234) + ChrW(5678) + ....

3. Find and modify each config.asp page to use your own Date, Time, and Time Zone settings. The default looks like (Time zone is related to the server, if hosted outside your region).
   
              Session(DSN+"DateTimeFormat") = "mm-dd-yyyy hh:mm:ss"
              Session(DSN+"TimeZone") = 0

4. 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 many other configurations on the shop manager that you can modify into your language as appropriate.

5. You need to modify the warehouse database (either Warehouse.mdb or Mall_warehouse.mdb) to index keywords by the alphabetic order of your language. To do so, please define your alphabetic order in the Intl_Alphabet table (shipped with sample data prepared 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 segment. Run the "Intl_Set_Alphabet" macro to update the Search_Table table. The latter is the one actually used by the program. Then run "Build Search Index" to re-build the keyword indexes.

6. 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.