ContactReview :: View topic - GoldBox 7 Org Chart Builder does not build

Shnibnib · GoldMine Apprentice

Help. I know I must be doing something wrong here.

I've installed GoldBox 7 to work with GoldMine 7. I have created a Virtual Org Chart and then selected to post to GoldMine. However, the Org Charts are not displaying in GoldMine.

I've tried selecting 'Build Org Chart, Exit' etc. in Post/Run. My SQL Statement reads:

Select Company, City, Contact from Contact1 where Company > ''

I want to break the org chart on:
Company, then City, then Contact. I have entered the slots as suggested in HELP.

Does anyone have any ideas? Apologies in advance if I have failed to include all the info you may require. Please ask if there's more info needed.

Many thanks,

Shnib

BobTaylor · GoldBox Guru

You do need that Post/Run setting. You also need the POST Charts to GoldMine box checked. You also need the Accountno in your query (but not in any of the field slots shown on screen). That's all I can think of at the moment.

However, you don't mention using the field slots shown on screen for Company, City and Contact; you do need to do that.

Shnibnib · GoldMine Apprentice

BobTaylor · GoldBox Guru

There is no way to run this particular thing from within GoldBox. The most popular way to run this Setup is to use the clipboard button on the Setup screen to generate a launch string (copy the first one shown to the clipboard).

Then create a Taskbar button to run it, using that launch string as the Command Line value. The rest of the setup for that button would be whatever caption you want; and selecting the V4GX7.EXE as the Application (that will auto-fill the Start Directory). Once you have that set up, press it and you should be on your way.

Shnibnib · GoldMine Apprentice

It still doesn't seem to build the org charts. It goes through the motions, telling me it's removing and appending but I just don't see anything at all.

Any more ideas?

BobTaylor · GoldBox Guru

Not from me. Let me ask you to post two pieces of info: what is your version of SQL, and also please produce, copy to clipboard and paste the LifeRing for your Setup. I'm going to try to get Dave Petonic to take a look....

Shnibnib · GoldMine Apprentice

SQL Server 2000

WINDOWS System: Windows NT version 5.00
FREE DiskSpace: 13,065.769 Megabytes
B D E Version: 5.1.1.1
Folder: c:\gmsystem\goldmine\setup\bdeshare\idapi32.cfg
GOLDMINE Exe: q:\goldmine
GMbase: GOLDMINE
User: CCX
Sync: ON
GX7 Version: 2007-B
Folder: c:\gx7
Serial #: G7701126
Licensee: CONCENTRIX LIMITED

OPERATION: GOLDBOX VIEW
Category: ORG-CHART
Description: Linx Org Chart
Launch ID: VULINX

COLOR: PURPLE (Level-4)
Q B E: NO
EDIT MODE: NO
TYPE-A VIEW: NO
LINK:
ROLL TO B: NO

MAIN TITLE: TEST ORG CHART
SUB-TITLE:
VIEW FILTER:

BDE ALIAS: GOLDMINE
TABLE NAME: CONTACT1
SQL QUERY: SELECT ACCOUNTNO COMPANY, CITY, CONTACT FROM CONTACT1 where
COMPANY > ''

POST / RUN: BUILD ORG CHART, EXIT (No Display)
VIEWFORM: GOLDMINE
GRAPHIC:

DEFAULT NOTE:
NOTE READ ONLY: NO
LINK-TO FIELD:
HIDE GRID: NO
GRID ONLY: NO
GRID EDIT: NO

ADD RECORD: NO
AUTO-ADD: YES
# TO ADD:
NO AUTO-DFLT: NO
HIDE OPEN VIEW: NO

FORCED POST: NO
AUTO-POST: YES
REFRESH POST: NO
CLOSE W/ POST: NO

COLUMNS: 1
2 COLS of 20: NO
PREV VIEW:
NEXT VIEW:

AUTOSTRIP HTML: YES
GM TAB COPY: NO

DSPLAY Slot 1: Gview4th->Company

DSPLAY Slot 2: Gview4th->City

DSPLAY Slot 3: Gview4th->Contact

EXTENDED OPTIONS:

GRAPHIC ICON: Position # 999 Field: Length: 0
Option Setting: FRS.BMP

POST/RUN MSG: Position # 999 Field: Length: 0

VIEW COLOR: Position # 999 Field: GVUMNCOLOR Length: 0
Option Setting: WINDOW - BACKGROUND Color
Color Setting: Black/0xE5E5E5

VIEW COLOR: Position # 999 Field: GVUSBCOLOR Length: 0
Option Setting: WINDOW - SUB-TITLE Color
Color Setting: Gray/0xE5E5E5

VIEW COLOR: Position # 999 Field: GVULBCOLOR Length: 0
Option Setting: WINDOW - Slot LABEL Color
Color Setting: Navy/0xE5E5E5

VIEW COLOR: Position # 999 Field: GVUFDCOLOR Length: 0
Option Setting: WINDOW - Slot ENTRY / FIELD Color
Color Setting: Black/White

VIEW COLOR: Position # 999 Field: GVUBRCOLOR Length: 0
Option Setting: G R I D ----- DEFAULT Color
Color Setting: Black/White

SUPPRESS Codes: Position # 999 Field: Length: 0
Option Setting: TEXT-VIEW SORT-RESULT {REFRESH} {DELONE} {DELALL}

(END OF LISTING) Created 10/24/2007 16:43:52

--

Many thanks for all your help!

BobTaylor · GoldBox Guru

In your query, you are missing a comma after Accountno

Shnibnib · GoldMine Apprentice

BobTaylor · GoldBox Guru

Cool! Thanks for the feedback!