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
- Tags
- database, productivity, synapse, broderbund, forth, 130xe, dif, mail-merge, disk
- Related
- SynCalc, PaperClip, Altirra, Atari800, AtariWriter, FileManager 800
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
- Picture: The later Synapse box, advertising 130XE support. — Synapse Software box scan from AtariMania (Synapse_SynFile_Plus_d7.jpg) (Box art © Synapse Software — used for identification/commentary)
- AtariMania — SynFile+ — Synapse Software box scan from AtariMania (Synapse_SynFile_Plus_d7.jpg) (Box art © Synapse Software — used for identification/commentary)
- Antic Vol. 3 No. 10 (Feb 1985) — Syntegrated Software (Michael Ciraolo) — AtariMagazines.com (Kevin Savetz), 1985
- Antic Vol. 4 No. 10 (Feb 1986) — New Products: Enhanced SynCalc, SynFile+ — AtariMagazines.com (Kevin Savetz), 1986
- Antic Vol. 4 No. 5 (Sept 1985) — I/O Board: SynFile+ print style — AtariMagazines.com (Kevin Savetz), 1985
- Antic Vol. 6 No. 1 (May 1987) — I/O Board: SynFile+ bug — AtariMagazines.com (Kevin Savetz), 1987
- Antic Vol. 5 No. 8 (Dec 1986) — Shopper's Guide (RAMcharger: 288K with SynCalc and SynFile+) — AtariMagazines.com (Kevin Savetz), 1986
- Antic Vol. 7 No. 7 (Nov 1988) — Dr. Brilliant's Atari Brain Transplants (SynFile+ with 288K on an upgraded 800) — AtariMagazines.com (Kevin Savetz), 1988
