Read Stephen’s post.

One thing to watch out for when moving data between database servers is sort order. Generally the data will be re-sorted in the new sort order (if they are different) when you Database Load. However if the original sort order is binary based and the new sort order is case-insensitive then you run the risk of any keys that allow upper and lower case being rejected as duplicate records and the Database Load failing. The main case of this is the Unit Of Measure table where people often have EA, Ea and ea. To avoid problems you have to delete the records whose keys only differ by case before dumping.

Thanks to Stephen Smith for the great info!

You begin by using the project wizard integrated into Eclipse. You use this to create a starting Accpac screen project. From the File menu in Eclipse you choose File – New – Project… Then select under “Sage Web Toolkit,” “New SWT UI.” When you are done and click Finish, and the wizard will create a new project in Eclipse.

This is a completely ready to run minimal UI that is all set for you to add your own logic to. If you don’t do anything and just choose run, then your project will be run in GWT hosted mode which means it is run as a Java program in a container that simulate browser behavior. This is how you debug your programs. In this mode you can set breakpoints, single step through code, examine variables and do anything else supported by the full Java debugger.

Then when you sign-on, you get the screen with the single table control connected to the A/R customers SData feed on the form. Normally you would delete this control and then add the controls you really want on your form. Behind the scenes is the development shell that show useful messages on what is going on, especially if something goes wrong. Plus status messages are sent to the Java Console inside the Eclipse IDE. Once you have debugged the program and have it working then you run the project through the GWT compiler to produce a Web HTML/JavaScript version of the program that you can run directly in the Browser, or which you can add to the Accpac Portal.

When you are writing code for your UI, it can go into one of two places. If can reside on the Browser side of things running as JavaScript or it can run on the server side as an SData service. In VB all the UI code was within the VB OCX control and this talked directly to the Accpac Views (Business Logic Objects). In the Web world we have JavaScript running in the Browser (created by compiling Java programs with GWT), that talk to SData services running on the Server. These SData services then talk to the Accpac Views.

Thanks Stephen Smith for this great information!

Contact us to reserve your seat now!

About the Moderator:
Jack Reaves, CLU, agency founder, has 30+ years of successful insurance experience. Some clients have been with him since the agency opened for business. Jack’s specialty is group insurance for private and public employers. His clients range from companies with two employees to those with thousands on their payroll. Jack prides himself on learning a client’s needs, then designing solutions to fit that client’s business goals. Prior to founding The Reaves Agency, Jack held management positions for Safeway stores. His success in that venture inspired him to open his own business.

• j or n : next story
• k or p : previous story

Application

• / : search
• ? : open help

I don’t know about you, but I can always use good shortcuts…here are a few helpful ones for Google News:

Actions

• s : star story
• . or f : open story options
• <Enter> : open the headline for the current story.

HOME – Move to the first entry in the form
END – Move to the last entry in the form
↑ or ↓ – Move up or down a single row
ENTER or TAB – Move the cursor to the next field
SHIFT + TAB – Move the cursor to the previous field
INS – Add a new entry on the next line
DEL – Delete the selected entry
F9 – Maximize or Minimize the display area
Spacebar – Checks or unchecks a checkbox
F7 – Refreshes the record

- Meredith Gooch, Marketing Manager

Wherever the Finder icon displays, Sage Accpac provides a search engine to assist you in finding information. The Finder’s search capabilities are dynamic and customizable.