SynFile+

Medium
Disk
Year
1983
Publisher
Synapse Software (later Broderbund)
Type
Application
Category
Database / filing system
Developer
Daniel L. Moore and Steve Ahlstrom
Language
Forth with machine-language routines
Requirements
48K Atari 8-bit, one to four disk drives; printer optional; uses Axlon RAMpower 128K, Mosaic 64K boards, and (in the later version) the 130XE's extra memory
Dark grey SynFile+ box, 'The Ultimate Filing System', with a sticker reading 'NOW!! Uses all 128K in the 130XE!!' over a photo of index cards and printed records

Overview

SynFile+ was the database in Synapse Software's line of Atari business programs. The line was SynCalc, SynFile+, SynTrend, SynStock, SynChron and SynComm, plus AtariWriter for words, and each needed 48K and a disk drive. Daniel L. Moore and Steve Ahlstrom, who also wrote the word processor PaperClip, created it in 1983. The title screen of version 1.02 reads "© 1983 Synapse Software Corporation". The series was first meant to be sold by Atari, which is why Synapse dropped its own word processor and made everything work with AtariWriter instead. Synapse later became part of Broderbund, which sold SynFile+ for $49.95 (ATDSK-2118) and supported it into the late 1980s.

Antic's February 1985 survey of the series called SynFile+ a database "with excellent utilization of the Atari's hardware". It praised the documentation and tutorial disk as "good as they come". The magazine also revealed that the program is written in Forth with machine-language subroutines, which was unusual for a commercial Atari application.

Features

Everything is driven from pop-up menus on the OPTION and SELECT keys, and a status line tells you where you are. The main menu has three columns:

  • Files: Open (create and edit a form), Close, Copy, Subfile, Merge, Rename, Delete, DIF→SynFile and SynFile→DIF, Density and Format.
  • Records: Enter, Update All, Delete All, Re-index and Retrieve. You can print, delete or recalculate from both Enter and Retrieve.
  • Reports: Lists and Labels.

You design a form freely, up to 80 characters by 21 lines including field names. Field types include text, numbers, dollars, dates and running totals. There are also computed fields, conditional fields that check entries or fill them in, and look-up tables. The manual gives these limits:

Item Limit
Fields per record 1–66
Field names 1–31 characters
Disks per file 1–16
Sort/index up to 16 fields
Search up to 16 fields, 255 characters, with wildcards (A*, *A, *A*) and >, <, # range tests
Records per file limited by RAM and index length

It handles single, "dual" (enhanced) and double density, and up to four drives. It also reads files from Synapse's earlier FileManager 800+.

Working with the other programs

The links between the Synapse programs go through DIF (Data Interchange Format) files. You can send a column of SynFile+ data to SynCalc or SynTrend this way, or print a report to a disk file and merge it into AtariWriter or PaperClip for form letters. Antic criticised how laborious this was: you have to name and move each column separately, so the suite was "not truly integrated" in the Lotus 1-2-3 or AppleWorks sense.

Reports were the weak spot. SynFile+ could not print page headers or footers, and data could not be edited for a report. Synapse said there was no memory left to do more, and Antic wished for a "SynReport". Users found workarounds. One reader told Antic how to change printer fonts mid-report by storing printer escape codes as records in a look-up file. Another passed on a Broderbund tip about a known bug: if a DATE field is the only index field, define it as text instead, or the file's .TBL, .DOI or .IDX files throw errors when you load it.

More memory

Even the first version could use an Axlon RAMpower 128K board or up to three Mosaic 64K boards, which made larger files possible and searches faster. In early 1986 Synapse/Broderbund released an enhanced version that uses the 130XE's extra 64K, and existing owners could upgrade for $20. Later memory boards, such as Magna's RAMcharger, advertised "288K available with SynFile+ and SynCalc". An Atari 800 with Axlon-compatible RAM gave SynFile+ more working space than any XL or XE could.

Using it today

SynFile+ runs well in Altirra or atari800. Choose a 130XE (or an 800 with Axlon RAM if you want the most space), give it the program disk and one or more blank data disks, and go through the tutorial disk first. Searches and sorts on big files can be slow; Antic warned they could take up to an hour on real hardware. Updating records is also slow, so emulator warp mode helps. To move data to modern software, use SynFile→DIF or print a list to a disk file, then convert the Atari line endings (ATASCII 155) on the PC side.

Credits