Community
Showing results for 
Search instead for 
Do you mean 
Reply

Layout issue

New Member
Posts: 5
Country: United States

Layout issue

Converted a layout from ACT 6 to work with converted ACT 6 data.

Modified it considerably to display correctly

Saved  it. ... works fine.

 

But when I use this layout in a newly converted ACT 6 database (same database, only more current -

with identical fieldnames), the layout does not display half the fields? ...

 

Any suggestions?

 

Karl 

Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: Layout issue

It may be that the fields that are not displaying did not convert correctly.  Make sure the fields that are missing have the correct name by comparing the field names on the layout (displayed in the white field box) to field names under Tools/Define Fields in ACT!.  If the they do not match are there is no field name in the white field box on the layout, then will have have to re-add those fields to the layout.

 

The other possibility is that the layout did not convert correctly or is damaged, in which case you will need to create a new layout.

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.

New Member
Posts: 5
Country: United States

Re: Layout issue

The field boxes show, without data or fieldnames (in edit view) in about half the items.  However, the same layout works perfectly in the same database converted earlier.  The fieldnames seem to be the identical in each database.  The layout works in one, but not the other.

 

Order of operations:

Converted ACT 6 data to New data

Converted layout from ACT 6 and modified it to fit

Saved layout

Converted updated ACT 6 data again to New data

Copied and used saved layout above.

Layout doesn't work as described - empty boxes (no field names blank boxes in edit view)

Platinum Elite Contributor
Posts: 6,651
Country: USA

Re: Layout issue

Sounds like you made two different conversions of the ACT! 6 database. It also sounds like you had added a large number of fields to the ACT! 6 database. When the database is converted, when the number of fields and total field size exceeds the capacity of the base contact table, SQL creates a spill over table with a unique ID connected to the base table. That ID is used by the layout editor to connect the fields in the layout to the fields in the spill over table. The spillover tables for the two different conversion that you made have different IDs so the layout modified on one conversion can't be used on the second conversion database without reconnecting the field to the database. That can be done in the layout editor.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129