As for your import-export crashes, there must be something different between your setup and mine... perhaps something as simple as available disk space or memory or handles setting for the file sizes you are working with.
NealSubj: LaRue/Dex>File...
Date: 93-08-28 13:58:01 EDT
From: GWRep Neal
Here's the basic workaround I know of, reposted from 8/19:
Maybe there's an easier way, but this is the easiest way I've found so far:
1. Make GeoDex a Desk Accessory by moving the GeoDex application icon into the Desk Accessory folder in GeoManager. Doing this will keep GeoDex "on top" of GeoFile, which you launch next.
2. Create one field in a new GeoFile database and close the Create Fields box. Open your GeoDex file.
3. Assuming the Address Field in your GeoDex file looks something like this and doesn't include any other information...
John Smith
123 Any Street
Hometown, US 12345
... select all the text in the Address Field box and then select COPY.
4. Select Data Entry mode in GeoFile, then choose PASTE from the Edit menu. Resize the field box so you can see the entire pasted address. Make the field box "label size." In other words, don't make it bigger than it needs to be.
5. Select "new" record, go to the next record in your GeoDex file and repeat the process... until all your GeoDex records have a corresponding record in GeoDex.
6.Finally, go back to Design mode in GeoFile and go to FILE>Page Setup. Make the Single Record Size the size of the labels you want to print. Also, turn off Field Edges under the Attributes menu. Then, switch to Multi-Record mode and adjust the record template, if necessary, using the Pointer tool.
Switch to Data Entry mode (while still in Multi-Record mode) and you should see your records arranged label-style.
Do a test print.
The only part of this that's a little kludgy is manually copy/pasting GeoDex's Address Field into GeoFile fields. QuickCopy won't do it, and a test export of GeoDex Address Fields to .CSV and dBIV files proved to require far more editing in GeoWrite than it was worth. Copy/Paste was easier.
Hope this helps...
Subj: re-calc
Date: 93-08-30 16:28:54 EDT
From: SMOFBBS
A new feature is needed then, to "touch" marked records in order to recalculate calculated fields, and "touch all" to re-calc those fields for the entire database. There is no way in hoo-hah I'm going to be able to edit every single name in my address database just to recalc fields; it's just impractical.
Date: 93-05-29 17:13:29 EDT
From: SilntObsvr
...I recently imported my own Album/CD/tape database, formerly in Multimate OnFile (a handy little 3x5 card emulator). I found (after using Paradox to change the Comma-Delimited format that OnFile exported to a DBF, since GeoFile couldn't recognize it...I guess it had a non-standard delimiting system, or something) that it imported, created fields named FIELD_X (where X if the field number), and was all done in seconds. Then, I went through the form, moving, renaming, and resizing the fields, copied information split into multiple fields into the new, larger ones (this was tedious with 336 records...), and deleted the now-unneeded secondary fields. Voila! Instant GeoFile database (after only about 3 hours work!).
...but, you may find, as I did, that the software you're using doesn't export a "standard" Comma Separated Value file, or that GeoFile will have problems with it. In my case, it appears that the file was getting saved with line breaks at column 80, instead of one line per record; GeoFile can't seem to work around this. If you have the choice, DBF (dBase format) is the better way...Subj: WK1
Date: 93-05-30 10:17:35 EDT
From: Boggy
Tried to import a file from a lotus format and got a message stating there were some non-standard data formats?. I'll try it again and try to get the exact error code when it pops up.
Subj: RE WK1
Date: 93-05-30 10:43:19 EDT
From: DRJ2
I had the same problem, I think the code was FF-54. I then converted the file to both DBaseIV and comma delimited; after doing so the import worked fine.
DanSubj: Reports with a header
Date: 93-05-30 15:07:41 EDT
From: StieglBier
I'd like to produce a multi-record report using GeoFile. On this report I need more than just the records. I also need a header describing what the report is. How do I do this in GeoFile?
SBSubj: Extra blank pages
Date: 93-05-30 15:08:30 EDT
From: StieglBier
In GeoFile after I print a multi-record report, why do I get additional blank pages?
SBSubj: Report Header
Date: 93-05-30 18:13:11 EDT
From: GWRepRoseS
Stiegl, you can build your header or footer or lines or graphics or anything else right into your multi-record page layout.
RoseSubj: GeoFile Reports...
Date: 93-05-30 18:31:33 EDT
From: GWRep Neal
<<I'd like to produce a multi-record report using GeoFile. On this report I need more than just the records. I also need a header describing what the report is. How do I do this in GeoFile?>>
Work from Level 4. After you've set up your multi-record page and while still in Design mode, select the multi-record outline. Click on one of the handles across the top of the outline, and drag the cursor down to make room for a header. Likewise, you can scroll to the bottom of the page and move the outline up to make room for a footer.
If you've made your single record size smaller in width than your page width, you can also click on the center right handle and move the outline in... don't worry, GeoFile won't let you make the outline smaller than your single-record size. If you make your overall multi-record outline smaller than your page size, you can click on the outline's center handle, and freely position the entire outline anywhere on the page.
You can now use any space around the outline for headers, footers, instructions, graphics, etc.
he key is to treat the multi-record outline like any other GEOS object in terms of moving and resizing. And don't worry -- no matter how small you make your multi-record outline, you won't lose any data... GeoFile will take care of arranging data internally, and print only as many records as will fit on a page, determined by the size you make the multi-record outline.
Here's a tip: When setting up a report layout, consider deleting the field labels from the actual record, and adding text labels outside the report region. This will allow you to produce a columnar report. GeoFile does not need field labels to keep track of things... they're a human convenience only! :-)
If you have any other questions on how to set this up, or how to use page layouts for report purposes, just ask.
As for the blank pages on printing, please tell us exactly what's happening... how many, when, etc.
NealSubj: Query function?
Date: 93-05-30 23:37:14 EDT
From: DeniseD4
Hi, I just got 2.0. I used to work with Paradox and they had a query funtion. Does Geofile have this? I didn't see it in the manual. I want to be able to get lists of records with "XYZ" in "@@" field or blank in "**" field.
ThanksSubj: Question
Date: 93-06-01 01:04:50 EDT
From: SeattleBoy
I've tried to find the answer in the mannual, to no avail. I'm wondering if there is any way to link fields in GeoFile and GeoCalc.
Also, is there any way to protect previous pages of a database from being
Date: 93-05-25 09:27:30 EDT
From: GWRep MK
GeoFile is part of the 2.0 upgrade now available. For information on what that upgrade contains and its price check the News & Information section when you enter this area. You should do so soon because the price will increase in a very few days.Subj: Geofile reports?
Date: 93-05-26 00:47:02 EDT
From: GWRepDave
reposted here from another area....
Subj: Geofile
Date: 93-05-25 22:52:56 EDT
From: ChrisM7204
Posted on: America Online
I have been using Alpha 4 for my database needs at home. Its a nonprogrammable database. I imported my records into Geofile with no problem. My question is does Geofile allow you to make a report? I've got 143 records right now and would like it to print them all together on just three pages not 143. Subj: importing databases
Date: 93-05-26 00:52:25 EDT
From: MarkE5674
............i recieved my uograde version of Geoworks today [5-25-93 pdt] and enjoy it very much except for one little problem [or not]. I tried to import my CD Catalog database that i have in Deskmate [sorry , i have a TL/2 computer it came packaged with]. Well, when i went to import the database, it won't do it, bummer. i got an error "TR-06", what ever that means. i guess i have to create a new database within Geoworks or get my shareware version of MLMS [ which is a very good database] registered. Does anyone have any suggestions on how the best way to create a music database in Geofile?. maybe i can figure one out, but it looks like i'll have to keep Deskamte on my Harddrive for a while til i figure this one out. Oh well, :)Subj: imports?
Date: 93-05-26 05:20:16 EDT
From: VALEX
thanks for the reply, i just ordered the upgrade yesterday. i now use a simple data base which is professional file, from the makers of professional write, i wonder if i'll be able to import into geofile?Subj: professional file..
Date: 93-05-26 10:42:10 EDT
From: IMJerry
All you need to do is export from PF into one of the formats that GeoFile can utilize. 'm not aware of what format PF uses or what exports it has. Haven't seen PF in years.
Subj: Reports...
Date: 93-05-26 10:47:47 EDT
From: IMJerry
To do more than one record from GeoFile you need to set the record size to be smaller than the page size. You also need to change Geofile from Single Record to MultiRecord.
I will upload a file in a day or two with this kind of multirecord setup.
Subj: Mark, maybe you could...
Date: 93-05-26 21:28:42 EDT
From: Cami Lee
...specify how you tried to "import" your database, and someone can see what you tried to do, and possibly, help you out of your predicament.
Since I don't have 2.0 yet, this is a shot in the dark like everything else. Typically, when importing data, you need to
a.) Convert the data to a "delimited" ASCII file in your database program. (particularly, if the file format is not compatible with the one you're trying to import into)
b.) You usually need to set up a file structure, to import the data into. In other words, build it like the one you have, EXACTLY, and then import the data into it.
If this doesn't help, maybe your explanation of how you tried to import the information will help the people that have 2.0 help you troubleshoot your problem.
Cami Lee
Subj: Importing
Date: 93-05-26 23:47:10 EDT
From: GWRep MK
If your file is in a format importable into GeoFile you need do nothing but select import. If it is not, and you can save in another format or delimited ASCII you can also import in that format without doing anything in GeoFile first. The file should simply appear as a GeoFile document.Subj: Professional File
Date: 93-05-27 00:25:13 EDT
From: NC LAW
Well, believe it or not, I still use Professional File
(:-D) But am starting to convert to Alpha Four and/or GeoFile. Anyway, to answer the question about PF import. Absolutely. There is an EXPORT routine in PF to export to DBASE III format. Set up PF to export all your records to DBASE III. It's a little complicated, because you have to put in DBASE compatiblefield names everyone and order the fields, but after the setup, its very quick. GeoFile will then IMPORT the DBIII file created by PF with no problems. I have done it several times, and everything comes over fine.
ChipSubj: Delete Marked...
Date: 93-05-29 16:39:05 EDT
From: StieglBier
How does the delete all marked option work in GeoFile. The option falls under the edit menu. I tried "selecting all" that didn't work either. I'd like to use this function because I hate to go through and delete the records I want to get rid of one by one. It would be much easier to get rid of them by marking them first then doing a batch delete. Please help and BIG THANKS IN ADVANCE.
SBSubj: Importing to GeoFile
Subj: Steve..
Date: 93-04-30 10:25:08 EDT
From: ZenGEOS
GeoFile does NOT have relational capabilities to my knowledge. It is quite easy to layout a database & can be fun too.
Zen...Subj: Flat file
Date: 93-04-30 13:36:25 EDT
From: GWRep MK
GeoFile is most definitely a flat file database, with no relational capabilities.Subj: Graphics?
Date: 93-04-30 19:18:05 EDT
From: DEC29111
Can you use GeoFile to 'FILE' graphics??
Can you use 'Different' graphics for each FILE Page?
I sort of remember that the C=GEOSFile would allow you to add a single graphic in a data base.. but it was the same graphic through out the whole file?!?
--DavidSubj: Can't file graphics
Date: 93-04-30 20:21:18 EDT
From: GWRep MK
You can use graphics throughout the database, but you can't store them in any way.Subj: GeoDex/GeoFile Question
Date: 93-04-30 21:02:53 EDT
From: Ardi
Will 2.0 retain GeoDex? If so, will we be able to use GeoDex data with GeoFile? Subj: database files..
Date: 93-04-30 21:44:45 EDT
From: MarkE5674
..... i'm hoping i'll be able to create a file database for my music collection, it is somewhat large [ over 1,000 entries]. cuz then i'll be able to delete my Deskmate folder. if so, would i be able to import my Deskmate database into Geofile, or will i have to create it all over and do all the input again. if so i am not looking forward to entering everything again, but oh well , if it has to be, i guess i know what i'll be doing when my copy of 2.0 arrives.Subj: Mark's database wishes
Date: 93-04-30 22:30:19 EDT
From: GW Rep Tim
I maintain a database of my LPs and CDs, which now total 3825 records. I imported the DBase IV file into GeoFile and found that everything worked very well.
GeoFile will fill a great many needs of current and new users of GEOS 2.0.
Subj: Importing over
Date: 93-04-30 23:39:39 EDT
From: GWRep MK
You can import over if in no other way if you can export from DeskMate as delimited ASCII. This, as well as other formats, such as dBase will import fine.Subj: GeoDex and GeoFle
Date: 93-04-30 23:40:56 EDT
From: GWRep MK
GeoDex is more powerful in 2.0. But you could quick copy the same data into GeoFile without difficulty and then use it that way, also, if you really wanted to. And don't forget you GeoDex file in 1.xx will simply be converted so you don't have to reenter that data.Subj: GeoDex...
Date: 93-04-30 23:50:10 EDT
From: IMJerry
You might be interested to know that you can mail merge with GeoDex >>>GeoWrite now. Can also use Calc and File to do that.
Subj: Dex to File
Date: 93-05-01 03:38:45 EDT
From: GW Steve
You can export your data from GeoDex and import it to GeoFile... no problem.
Steve Subj: 16k max
Date: 93-05-04 12:47:00 EDT
From: SMOFBBS
I just read the press release that describes GeoFile and I'm a bit disappointed that it can only handle 16k records. I work on direct mail projects that top 300k records and I won't be able to do them inside of GeoWorks.
It was said that GeoFile has no relational features; can you at least sort the data by multiple keys?Subj: 16k records.
Date: 93-05-04 16:38:25 EDT
From: IMJerry
Refers to the number of records that a database can hold. I'm not sure how much a particular record can hold offhand. But I can check on that.
Yes, you can sort on multiple fields.
Subj: 300k direct mail database
Date: 93-05-05 00:05:58 EDT
From: CardDoc
Maybe you could seperate them by region or zipcode, etc. until a third-party database comes out?Subj: Marking
Date: 93-05-05 11:01:45 EDT
From: IMJerry
You can mark certain records for view and printing by criteria, like STATE-'AZ' or whatever.
You could sort the db before that to get the order you want and then select a portion of the db to print.
Subj: GeoFile
Date: 93-05-07 20:42:06 EDT
From: Sandy42
I notice on the fact sheet for GeoFile that the expression editor or a dialog box can be used to conduct a search for files meeting criteria. Can more than 1 field be queried for the search? It seemed like the dialog box approach specified only 1 field to search on. Does the expression editor allow for more than 1 field to be queried?Subj: Sandy, yes
Date: 93-05-07 22:54:11 EDT
From: GW Steve
The expression editor allows you to include more than one field.
Steve Subj: Sandy, double yes...
Date: 93-05-11 01:14:12 EDT
From: GW Dashe
You can query all 255 fields in an expression, if you like. More than once in an expression, even.
Jeremy -
gw engineeringSubj: Q&A
Date: 93-05-15 00:35:27 EDT
From: Mike W4767
Does anyone have any thoughts on how to import database files from Q&A to Geofile (or any other for that matter?
ThanksSubj: Mike -- Q & A files....
Date: 93-05-15 01:58:50 EDT
From: GWRepDave
Mike--
The Impex utility will allow GeoFile to access DBase 3 and 4 file types. Just make sure they're in one or the other, then you'll be able to import 'em to GeoFile. Works fine.
DaveSubj: Q&A
Date: 93-05-16 08:58:21 EDT
From: HollandS
I've used Q&A a lot, and Q&A exports to numerous database formats, including Dbase, which shoud import to GeoFile OK. My tips for exporting are, (in Q&A):
1. Make sure the date fields format in Q&A is changed to a standard dbase format (Q&A supports many more date formats than dbase, and some of them will not convert properly).
2. Change field names (if any) that have puntuation marks to ones without puntuation marks. Q&A supports lots of flexibility in field names that dbase doesn't. Spaces are no problem, they will be converted to underscores.
I'm looking forward to seeing geofile too, but I understand it doesn't support macros, etc, I suppose any "application-type" uses are pretty much out. . . . ah well, maybe Ensemble 3Subj: Or maybe...
Date: 93-05-19 16:18:26 EDT
From: SilntObsvr
...just maybe...we could talk Borland into making Paradox for GEOS? B) ...I know >I'll< be writing them a letter! B)Subj: when did this happen?
Date: 93-05-25 06:31:33 EDT
From: VALEX
i'm an avid fan of geoworks, even when i had my apple computer, and i've been dying for geos to create a file program. where can i get on?Subj: GeoFile
well asT
Date: 93-06-08 20:49:54 EDT
From: JohnDoc1
My problem is that when I try to create a default term in text I get an error message.What am I doing wrong?
I had the same problem and I found that delimiting the default text with double quotes gave the desired effect.
Enter...
"text"
instead of
text
Maybe single quotes work too. I didn't try.
JohnSubj: JWN% - Works DB import
Date: 93-06-09 01:06:41 EDT
From: RogerH9661
I hve exported my WORKS 3.0 files to DBase III format and it worked without a hitch. If you have Works 2.0, probably the CSV format is the only option. Try building the file in Geo File exactly as it appears in Works and then import. It will probably work.Subj: Re: dBase imports
Date: 93-06-09 04:34:39 EDT
From: SilntObsvr
I ran into a completely different problem. When I imported a database tracking my album and tape collection, I found the CSV import wouldn't work (even when I renamed the file to *.CSV)...but GeoCalc would import it fine! Well, I dropped to DOS, imported the CSV file into Paradox, and then exported it as dBase IV; when I came back to GEOS, GeoFile imported the dBase IV file without a hitch! Go figure...Subj: calc to file imports?
Date: 93-06-09 16:27:57 EDT
From: Taperwood2
I have a book collection that I kept in QP SE that imported into Calc nicely. I then decided that it would be nice to have it in Geofile, but I never could find a way to directly import it into File. I finally had to go to the original file in Quattro, convert to Dbase, and then import into Geofile.
Am I missing something here? Note: Until Geofile, I had never seen a data base on screen.
Any ideas,
Taperwood
Subj: DEFAULT
Date: 93-06-09 21:24:37 EDT
From: Steven2099
TO:Johndoc1
I tried your suggestion to add double quotes to the expression I was trying to use as the default and it worked.
Thanks much
Steve2099Subj: Importing from GeoCalc
Date: 93-06-10 00:52:50 EDT
From: RobertB428
I also could not find a way to import directly from a GeoCalc spreadsheet. I also cannot find a way to merge two GeoFile files.
I created a nice layout and now want to import the data from a GeoCalc spreadsheet. So far I haven't been able to find a way to import the data without manually retyping 600+ records.
Any suggestions?
BobSubj: Delimited ASCII
Date: 93-06-10 00:57:43 EDT
From: GWRep MK
It would appear that you could export from one as delimited ASCII and then bring it back in that way to he other.Subj: Works to Geofile
Date: 93-06-10 01:26:02 EDT
From: JWN5
Thanks Rog. Went via DBIII from M/S Works for (you'll forgive the expression) Windows and it went smooth as silk. I had forgotten about that option. As an aside I created a List View that is a multirecord view by doing a similar thing and going into Geocalc instead. It worked just fine.
I'm having a little trouble defining a label page size because of the required minimum 1/4" top & bottom page size.
JWN5Subj: Merging Databases
Date: 93-06-10 01:29:52 EDT
From: GW Steve
Yep, this is a rather disheartening limitation of the first version of GeoFile.
The best workaround I've been able to come up with is to import the two databases into Calc. Then copy/paste one into the other spreadsheet. Then export and import to File--then recreate your layout.
The decision you have to make is whether redoing the layout (you can copy/paste from your old layout to some degree) is more work than keying in the data.
Steve Subj: dBase Import Problem
Date: 93-06-10 02:01:24 EDT
From: Rick35452
Well everybody, it looks like the problem is something more fundamental with my setup, not GeoFile. Right now we're working it out via e-mail. If anything comes up that has to do with GeoFile I'll be sure to post it here. Otherwise, there won't be anything else about it here, and I won't be coming here to look specifically for replies.
Thanks to all,
Subj: help with an expression
Date: 93-06-10 02:26:00 EDT
From: SEQUOIA3
program.
Subj: Changing Content
Date: 93-06-07 02:33:05 EDT
From: JWN5
Steve I dont blame you for not understanding my message. I went back and read it and I had trouble understanding it myself.
I'll give it another try.
It happened with 2 records which had the same last name. As I was scrolling thru the data base backward and forward, the first name of one was transfered to the first name of the other. This resulted with 2 records having the same first and last names but different other info such as addresses, phone numbers, etc. as far as I could tell. At least I didnt notice any other changes that had come about.
Does that clarify it a bit?
I'm going to go back and see if I can recreate it and solidify the failure.
Thanks for the response.
What do you think about the "popup help tags" for the menu icons???
JWN5Subj: JWN5.. thanks!
Date: 93-06-07 02:48:03 EDT
From: GW Steve
I understand now, thanks!
If you can dupicate the problem and give us the exact steps so we can duplicate it, too, it would be a tremendous help in tracking down the bug, if there is one.
Context sensitive help about the buttons as you describe is a great idea. It's been requested by others, too, and is on our list of "most requested features" for a future version.
Steve Subj: Content
Date: 93-06-07 03:06:17 EDT
From: JWN5
Just tried it again of no avail.
At the time that it was happening I was trying to change layout, file names, etc. I dont remember the exact sequence but I will continue to try to repeat it again. Thanks Steve
JWN5Subj: default
Date: 93-06-07 21:58:42 EDT
From: Steven2099
I have been creating(as the dialog boxes would have it) my first database on Geofile,which is also my first attempt at a database period.My problem is that when I try to create a default term in text I get an error message.What am I doing wrong?
Also,if I understand the manual correctly,text is limited to 1024 characters in Geofile.Is there anyway to put in more text in a record.
Thanks,
Steve2099Subj: I have to ask...
Date: 93-06-07 22:33:56 EDT
From: CarpetBagr
Why did GeoWorks chose to use spreadsheet-type formulas instead of some form of database query language in GeoFile? As an old R:Base, FOCUS, and d:Base user this is really throwing me for a loop; I have to relearn everything.Subj: Importing DBase Files
Date: 93-06-07 23:46:55 EDT
From: Rick35452
Has anyone had success importing Alpha4 ver. 1.1's dBase III+ files? I've got several databases there and I've tried the dBase III and the dBase IV GeoFile importers. The dBase IV importer gave a "Critical Error - General Failure: R to Retry, A to Abort" message. The dBase III importer appeared to work.
However, once I leave the imported file, do something else, and come back to GeoFile, I get the same message again. If I drop to DOS, press the reset button, then come back to GeoFile, everything works until I open an imported file. Once I leave it again, the error messages start allover.
BTW, it happens with GeoFiles imported from a dBase format, but not with files imported with the Lotus 123 ver. 1A format. As an experiment, I imported the Alpha4 dBase file into GeoCalc and then exported it as a dBase III file for GeoFile. Any file that used the dBase importers or exporters would cause the "Critical... " message again.
The file I exported from Alpha4 as a Lotus 123 ver. 1A spreadsheet into GeoCalc works fine and so far hasn't caused any problems. However, all 1,666 records need to be "cleaned up."
Is there something wrong with the dBase importer and exporter, or am I doing something wrong?
Subj: Rick, dbase errors
Date: 93-06-08 00:43:03 EDT
From: GW Steve
I'm not aware of any documented problems with importing dbase files.
Try running Preferences, GEOS and raise the Max File Size and the Page Size to 4096 each. and raise the number of handles to 3000. That should clear up the error messages.
Steve Subj: Steven2099
Date: 93-06-08 13:23:57 EDT
From: IMJerry
>>My problem is that when I try to create a default term in text I get an error message.What am I doing wrong?
Not sure what you are doing, therefore the solution is not apparent. You might try the templates and examine them for the way things are done.
>>text is limited to 1024 characters in Geofile.Is there anyway to put in more text in a record.
Actually, the manual is in error here. The limit per field is 512 chars. You can have more than one field (with different fieldnames) per database.
Subj: Steven2099 - default
07 23:46
inserting the appropriate parentheses and hypens, to get the same effect (though I don't remember if GeoFile will automatically tab to the next field if you fill a short text field). Of course, there would be no check to find if you have, in fact, entered a number, much less a valid one...Subj: multi-record
Date: 93-06-06 16:03:05 EDT
From: CHRISG3513
I set up my record to .5 in and my page set up to 8.5 x 11 and I still can only display and print five records in multi mode any suggestions?Subj: Importing M/S Works DB
Date: 93-06-06 16:31:21 EDT
From: JWN5
I have been having some trouble importing from the Works format. Does anyone have any experience with it??
Subj: exporting/importing pf
Date: 93-06-06 16:52:29 EDT
From: VALEX
thanks chip...: )Subj: Marking Help
Date: 93-06-06 17:11:15 EDT
From: DeniseD4
Thanks, I'll try AND and OR! (Knew there had to be an answer!)Subj: Merge Problems - Details
Date: 93-06-06 18:23:24 EDT
From: Prn1
In an attempt to isolate my problem I've gone to floppy booting and the /nomem command line option. Aside from slowing my machine to a crawl, the infamous KR-09 failures when attempting to print even 1 record remain. Curiously, when I print on may Panasonic KX-P1124 in high reolution mode things seem to work OK. The failures consistantly occur in low resolution modes. Should we suspect the fault somehow lies in the printer driver. I've always used my printer in "epson" mode. I'm going to try a retest of the same scenerio in "ibm" mode using the approproate driver. I'll post the results once I've completed the test. Help on fixing and/or confirming this problem from any and all sources would be appreciated.
Paul NewellSubj: How to deete mark files
Date: 93-06-06 19:30:34 EDT
From: StieglBier
I asked this question a while back and didn't get a response so I'll ask again just in case it was looked over the first time.
How does the delete all marked option work in GeoFile. The option falls under the edit menu. I tried "selecting all" that didn't work either. I'd like to use this function because I hate to go through and delete the records I want to get rid of one by one. It would be much easier to get rid of them by marking them first then doing a batch delete.
Please help and BIG THANKS IN ADVANCE.
Subj: Importing M/S Works DB
Date: 93-06-06 22:20:45 EDT
From: JWN5
I guess I have to answer my own question. I have since discovered thatWorks can convert a DB from a WDB format to a Coma delineated file and you can give it a CSV suffix which Geofile will convert right off. Then you have to change the file names. The process is not intuitive. I'm not sure of exactly what I did but I did get it to function. Now I have to learn how to use Geofile properly. I think I may have come across a bug in the file program. Occasionally it will change file content Two to the file content Two of the previous record when file content Three is the same as file content Three of the previous record.
It is not my imagination. It happened a number of times and even with different pairs of records.
In any event I sure could use some help. The manual is difficult to understand and the teminology is unfamiliar to me. It would be very useful to have a form of popup help menu, very concise, operated by the right hand button to explain the different little icon buttons that one finds around the periphery of the menus.
I hope that this message is noticed by some Geofolks who are more familiar with the problems that I have encountered that are willing to respond.----------Help-------
JWN5Subj: Stiegl, delete marked
Date: 93-06-06 22:44:27 EDT
From: GW Steve
Delete Marked Records doesn't work at all. It's a known problem.
Steve Subj: JWN5, file cotent?
Date: 93-06-06 22:49:10 EDT
From: GW Steve
I'm a little confused by your message.
Are you saying that changing the data in a field in one record causes the data in another record to change automatically? If so, I haven't experienced that. I'm not doubting you, I just haven't seen it happen. If it is happening, then it's certainly a problem.
If that's not what you mean, please try to say it again and maybe it'll get through this thick skull of mine.
::grin::
Steve Subj: Printing problem
Date: 93-06-06 23:36:20 EDT
From: GWRep MK
I'd suggest you post details of your printing problem on the Printers Board (the button is on the same level as this area in the middle on the bottom). I'm sure GWRep Doug can give you expert advice there.Subj: LaRue...
Date: 93-06-07 00:35:24 EDT
From: IMJerry
Picture fields: I definitely know what you are talking about. I use Enable, which also has picture fields. And it will squauk at you if your phone number field doesn't pair up properly with your zip code field.
But alas, GeoFile has nothing like this. Maybe a future or 3rd party y
to a Com
Subj: Seattle... linking
Date: 93-06-03 04:35:18 EDT
From: GW Steve
<<<I've tried to find the answer in the mannual, to no avail. I'm wondering if there is any way to link fields in GeoFile and GeoCalc.>>>
Nope. No way to do that yet.
Steve Subj: Geofile & mail merge
Date: 93-06-04 19:03:50 EDT
From: Patrick956
Importing from the clipboard to a geowrite doc created a problem. Error message KR-15 was followed by system shut down or freeze. Was the file too large for the clipboard 104 single page letters. My system is a 386 dx with 4 meg ram.Subj: Patrick....
Date: 93-06-04 20:36:56 EDT
From: GWRep Neal
Could you explain a little more what you were doing? It sounds like you copied 104 pages to the clipboard? Somehow I'm sure I've got that wrong. :-)
Two general things you can try is to go into PREFERENCES>GEOS and raise your handles to 3000; you can also raise your swap file size (do not touch page size) to 4096. One or both of these things usually clears these errant error messages.
NealSubj: Help on marking!
Date: 93-06-05 16:02:35 EDT
From: DeniseD4
Hi, I can't seem to get mark by formula to work for me. I want to select all records with "N" in 4 different fields (these are 1 character fields, with either a "N" or a "Y"). I tried to do like your Sacramento example in the book (own="N", read="N"), but it hangs up at the comma, saying "Mismatched parenthesis". I tried changing the comma to "and", same result. I used single mark by text to get a default formula, ISNUMBER(FIND("N",own,0)), and editing that. I can't leave off the ISNUMBER(same error as above), and when I try more than 1 FIND, I get "Expression not defaulting to TRUE or FALSE as expected", also NO records are marked. HELP!!!!!!!Subj: Marking by Formula
Date: 93-06-05 16:16:14 EDT
From: Sandy42
I'm having similar error code problems when marking the DB. Geofile complains that the parser wasn't expecting an expresion when I try to write an AND expression for 2 marking queries. Also, this error also causes my mouse pointer to change to the hourglass! The only way to get rid of it is to do a warm reboot!!!!!!Subj: Mailmerge problems
Date: 93-06-05 17:18:09 EDT
From: Prn1
When attempting to print a group of records in GeoWrite using the mail merge feature I consistantly get a KR-09 system error. There are 6 records I'm trying to print and each one contains 9 fields in the merge to document. Booting /nomem has no effect on the problem. As far as I'm concerned, GeoFile holds a lot of promise but currently is very buggy. Any suggestions on anything else I could try. Geowrite by itself has been largely error free for me thus far.
Paul NewellSubj: Denise
Date: 93-06-05 22:26:29 EDT
From: GW Steve
Are you using the AND or OR function?
AND(OWN="N", READ="N")
would find all the records where both fields are N
OR(OWN="N",READ="N")
would find them if either field is N
Steve Subj: Prn... merge
Date: 93-06-05 22:29:03 EDT
From: GW Steve
Raise the number of handles in Preferences, GEOS to 3000 if you haven't done so.
Just out of curiosity, what is the height of the page in your GeoWrite "merge to" file?
Steve Subj: Failing Merge
Date: 93-06-06 00:23:18 EDT
From: Prn1
GW Steve
Document height is 1 inch. However in the mean time I have tried several taller sizes upto 5.5 inches with identical unsatisfactory results. BTW I had already raised my handles to 3000. Has anyone been succesful in printing a large group of documents containing merged records?
Paul NewellSubj: Picture Field
Date: 93-06-06 11:42:41 EDT
From: LaRueW
In my Ability + for database creation it has the capability of creating a picture field that has a phone # such as phone#=(NNN) NNN-NNNN therefore when you enter the phone no. you just type in the numbers 5555555555 and it gets divided thus (555) 555-5555 is there a way this can happen in 2.0?Subj: La Rue
Date: 93-06-06 12:14:24 EDT
From: GW Steve
GeoFile doesn't yet have that fature, far as I can tell.
Steve Subj: One way...
Date: 93-06-06 15:10:42 EDT
From: SilntObsvr
...to do what you want, LaRue, would be to define the phone number as THREE TEXT fields, each with the right number of characters. You could then manipulate the fields by Unfill-ing the boxes, dragging them together, and
Date: 93-06-16 14:09:25 EDT
From: GWRep Neal
<<You can view multiple records and, I believe, edit them as well. sounds kind of "Kookie" I know. But there is no other sensible alternative offered.>>
The sensible alternative is to use multi-record mode. In that mode, you can view and edit or enter records in succession, as many records as will fit on the page... determined by your layout.
I'll try to carve out some time for a helpfile, which seems needed here.
NealSubj: Zen....
Date: 93-06-16 14:32:18 EDT
From: GWRep Neal
<< I'm trying to set up a mailing label layout... However, even tho I change the page size in single record mode to under 1" high & make sure it is narrower than the TRUE paper size/page size in multi record, it still only shows 1 little record in multirecord mode. What's wrong>>
It's not good enough to simply "make sure it is narrower than the TRUE paper size...". You need to do the same math on the width that you do on the height. (If you did and it still didn't work out, then methinks you changed single-record page size, not record size.)
For instance, if your labels are going to be 3-1/2" wide, you need to make the single record size 3-1/2" wide. This means you need to shorten the field boxes manually. Probably the best way to do this is to go into GeoDraw and make yourselfa temporary template to size... let's say 3/4" x 3-1/2" if that's the size... and paste it into GeoFile to help you size the fields lengthwise.
Some tips for labels:
1. Set up at least two layouts. The first layout is your primary database layout, complete with field labels. It doesn't matter what size the field boxes are here; you can leave them defaulted.
2. On the second layout, just port over your fields. Then, delete the field labels, unless you need them for some reason (if you do, you have to take them into account when figuring if you can have a double row of labels on the page.... may not work).
Next, resize the field boxes to your label "template," set single record size and switch to multi-record layout. Now, you should see a double column of labels.
Note that there's two parts to the multi-record "template." The thicker lines outline the actual "single records," the thinner lines outside this area are the multi-record template boundaries. These boundaries can be moved inward to make room for text or art graphics.
Here's yet another tip for spacing lines on a label: after you've got the field boxes the correct size, select them all and use Align/Distribute to close up the space between them.
I have tried all this... it does work.
NealSubj: GeoFile/Calc
Date: 93-06-16 23:38:12 EDT
From: OLEGGIO
Thanks JWN5, I've been doing that. Problem is that GeoCalc somehow hates my machine and crashes when mail merging or inserting a row or column in a large file. I've been working with the hardware guys GWRepDoug, et al, otherwise, I'd totally fan GeoFile and use GeoCalc to store data which, when it doesn't crash, is mighty nifty.
Ciao!
Subj: field notes not displayed
Date: 93-06-17 01:45:39 EDT
From: PhCkS Soft
The other major problem I'm having is with Geofile. Only 3 characters of the field notes are displayed for some reason. This is in the field organizer window.
Godfrey.
Subj: Multirecord mode sensible
Date: 93-06-17 02:15:07 EDT
From: JWN5
Do you realize the work that is involved as cmpared to the ease with which you can do it with other Data Base Managers?
The object is not just to figure out a complex way to do something with Geofile, the object is to do it in a User Friendly Manner with all the WYSIWYG qualities that we all have become accustomed to with Geoworks Pro.
In the method you describe the field size alterations require manually changing all the field sizes and even when you do all this work the page will only accomodate a relatively small number of "Multi-Record" displays in contrast to the tight and compact "Calc" spreadsheet display of multiple records.
Obviously I must be missing some important points, but I am willing to listen.
Thank you for your efforts.
JWN5Subj: Geofile Export to Dbase
Date: 93-06-17 20:24:24 EDT
From: Darrin2636
I am having trouble exporting a file to Dbase III+ format. All other exports work fine but when I Use Dbase III+ I get KR Errors and sometimes the system crashes and I have to reset! I tried re-installing several times.
Everything else seems to work great!
2.0 is GREAT!!!!
Got any suggestions
Subj: Another glitch?
Date: 93-06-17 22:26:19 EDT
From: Boggy
Today I had another odd thing happen to me. I was trying to use GeoFile to 09X
le t0
labels with different fonts, sizes, styles, etc, very easily.
I have had a very difficult time with it & when I finally solved some of the label page definitions, and Geoworks tried to print the labels it started creating all 176 labels and part way thru gave me a message that there were not enough "handles". I dutifuly changed the number of handles from 2500 to 3000 and I still got a message telling me that thee was an inadequacy of some kind. I mentioned this problem in this section before & I assumed at the time that I must have been at fault. Susan told me that "GEOPHITE" was working on the "problem of labels" but I havent heard anything new since.
Again, this is a very fundemental procedure, a small (176) mailing list, that is necessary in many different simple applications. If Geos20 is going to be so difficult to use in Geofile applications it becomes a serious drawback to many people who are used to using other packages very effortlessly.
I would strongly suggest that all concerned do their homework in correcting the shortcomings ASAP. Whether it be in clarifying the manual, (I looked in the index for a reference to mailing labels and found nothing and yet when I read every page carefully I did indeed find a number of references that should have been covered in the index) or in improving the design so that it functions properly. In this particular instance WYSIWYG has become WYUTSYNC, What You Used To See You Now Cant. As for getting the Works equivalent of a list view, the only way to do it is to export to Geocalc as far as I have figured out.
Sorry for the negative comments but I have spent a lot of time & money on this board to resolve some of these anomalies and all I have to show for it is this frustration.
Thank you for listening
"Crankshaft" Jim
JWN5Subj: What? no Browse?
Date: 93-06-15 21:06:09 EDT
From: OLEGGIO
I'm an OK dBASE programmer and there are 2 things about GeoFile that convince me that I must be doing SOMETHING wrong.
1. Is there a template or something out there that can be sort of a "Browse" like in dBASE II (yes, that is two!)? Even in CP/M you could view and edit multiple records on the screen all at once and scroll horizontally and vertically to view the entire database kind of like on a spreadsheet without much monkey motion. Am I missing something or doing something wrong?
2. When one imports a dBASE file, there are these gigantic page-wide fields even for a field that was oe character wide in the original file. Am I doing something wrong? Is there some switch, toggle, or radio button that I'm not hitting so field lengths aren't preserved? Is there an automatic width tool like the "best fit" column width item in GeoCalc? Where is it in the manual? What am I doing wrong?
Oleggio
Subj: Oleggio....
Date: 93-06-15 21:48:09 EDT
From: GWRep Neal
<<Is there a [way to] view and edit multiple records on the screen all at once?>>
Build a layout in multi-record mode.
<<When one imports a dBASE file, there are these gigantic page-wide fields even for a field that was one character wide in the original file. Am I doing something wrong?>>
Nope.
<<Is there some switch, toggle, or radio button that I'm not hitting so field lengths aren't preserved?>>
Nope, but I believe the field lengths are preserved. You could check by looking at the Create/Edit Fields dialog box.
<<Is there an automatic width tool like the "best fit" column width item in GeoCalc?>>
Not in this version. Default field box size (unrelated to field length) is controlled by the page size. You need to shorten field boxes manually.
Subj: Oleggio
Date: 93-06-16 02:12:25 EDT
From: JWN5
One way that I have found on my own is to export the Data base in question to Geocalc. You can view multiple records and, I believe, edit them as well. sounds kind of "Kookie" I know. But there is no other sensible alternative offered.
JWN5Subj: Data Attributes for Text
Date: 93-06-16 04:24:50 EDT
From: Al C21
I am unable to increase the default value for General/Text Field entries above 511 characters. In fact, when creating a field, the "default" number is 511. This is true at any level. Any ideas on where to look to fix this?Subj: Characters
Date: 93-06-16 09:42:54 EDT
From: GWRep MK
512 is the limit of characters accepted by GeoFile. I believe the manual may speak about more, but this is an error. It was discovered very late in the process that the parser couldn't handle that many, and the manual may have aleady gone to press by that time.Subj: Confused...
Date: 93-06-16 12:42:52 EDT
From: ZenGEOS
OK..YES I was a tester of 2.0! But that doesn't mean I know everything! :)
Help me create multiple record layout in File, PLEASE? I was able to do it in beta versions, but am unable to do it for the 4650 record database I am currently working with. I'm trying to set up a mailing label layout...12 high I think..Will look into true record sizes for it soon. However, even tho I change the page size in single record mode to under 1" high & make sure it is narrower than the TRUE paper size/page size in multi record, it still only shows 1 little record in multirecord mode. What's wrong?
Zen...Subj: JWN/Just not true...
e...<
RonSubj: Sequoia....
Date: 93-06-11 22:59:10 EDT
From: GWRep Neal
Why isn't your QTY field a real number, too?
NralSubj: Real Numbers
Date: 93-06-12 01:17:21 EDT
From: SEQUOIA3
>>>Why isn't your QTY field a real number, too?<<<
QTY will always be just a simple number that will never have the need to display fractional portions.
Real number would also work here I guess, I'll give it a shot. Could that cause a problem - havin an integer & a real number make up the expression for a computed field?
RonSubj: Nope, that's not it...
Date: 93-06-12 04:17:00 EDT
From: GWRep Neal
I tried it, Sequoia... integers and real numbers mix very smoothly. I tried addition and multiplication:
Field_1 + Field_2
Field_1 * Field_2
Didn't matter if both were integers, both were real numbers, or there was one of each in either order.
NealSubj: I have 'STARTED' reading.
Date: 93-06-13 21:12:20 EDT
From: DEC29111
I have started reading the manule.. but I can no find any way to COPY a record??
I am trying to make a data base of my books and have many books by the same auther / publishing house and so would like to be able to COPY a record, and then edit the copy as needed.
To date all I have been able to do is to copy single fields in a record to a new record.. but no the whole record??
Can some one point me to the correct page in the manule??
--DavidSubj: Printing labels
Date: 93-06-14 20:15:23 EDT
From: DeeBeeEff
I spent the afternoon very carefully laying out my fields for a mailing lable, 4" wide and 1.5" high.
I set the page size and record size at these figures, then went to the print options and set the paper size to this. Of course, as you already know, it told me that what I wanted to print would not fit on the paper.
So I set my record size and page sizes smaller; same message. I did everything else you can imagine except make the paper height larger. That had to stay at 1.5 for form feeds being right. Needless to say, the only way this would agree to print my info was to scale it down, which is not what I wanted. If I tell it not to scale it down, it first does a few uncalled for linefeeds (it also does this in the scaled down) and then prints (which doesn't fit on the lable because of the linefeeds) and then does an extra form feed before going to the next label.
What's up?
DeeBeeEff
GeoHostDBF on Q-Link where the C64/128 version of GEOS still lives.
AKA Data Base Ferguson (but not for long at this rate) LOL
Subj: Truncated Notes Field
Date: 93-06-14 20:34:32 EDT
From: CraigDB
Dave,
I've tried having from a few to no other aplications open, but whenever I put a note in the note field, I only ever get the last three characters. It doesn't matter if it is a new data base or adding fields to an existing data base.
That's about as specific as I can get. I've even tried it on different computers, but still the same probem.
So far I really like the data base (some short falls, but its only the first release), but this is rather annoying.
I need a "fix"!
Thanks.Subj: Limitations..
Date: 93-06-14 22:05:22 EDT
From: Boggy
I have tried to import Lotus files, and found that it won't accept the data if there are column headings. Without the headings, the data becomes worthless to me, and requires more work than they are worth. It wouldn't be quite so bad, if I could set up a form and then import the raw data w/o having the headings. It would be even better if GeoFile could link to these files w/o actually having to import the data. Hopefully someone is creating a real full-featured database for GeoWorks.
I think GeoWorks missed the mark on GeoFile/Calc if they truly intended it for someone who brings work home with them. The constant importing is ridiculous, especially in GeoFile where you can't set up a nice format on data that is constantly updated from other programs. I also find I need more relational power, but I accept this package for what it is and don't expect that here. Enhancement in importing/accessing is my greatest need. I would use it if it didn't require so much extra work.
Subj: Relational power
Date: 93-06-14 23:45:01 EDT
From: GWRep MK
GeoFile is intended to be only a flat file database, not relational.Subj: Flat file vs Relational
Date: 93-06-15 01:31:08 EDT
From: JWN5
M/S Works for Windows & M/S Works for DOS are definitely "Flat File" database managers and do not pose the kind of problems described in the recent messages. It is even possible to view the appearance of specific @
Help!
In calc, the formula =SUM(A1:A10) works even if cell A1 is the ONLY one in that range that contains a value.
In GeoFile, I removed the =, and tried it, as well as SUM(amount, amount_2, amount_3, and so on).
The expression works if ALL of the fields have a value but not if just ONE or SOME of the fields contain a value.
This is for a SUBTOTAL field in an invoice, and I do not want to enter 0.00 in the amount fields that aren't used, I want them to remain completely blank!
I give up!!!??? Anyone with an answer to this"seemingly" simple operation?? Thanx! (:-{D)
Ron <Database Wizard's Apprentice>Subj: Notes field "bug"
Date: 93-06-10 21:32:50 EDT
From: CraigDB
Just wanted to say up front that I've been using the system for about a week and so far, I'm extreamly satisfied. Still the tightest code around!
...but, 1 small complaint, and 1 little request.
Where: In GeoFile, the "Notes:" line, above the Create New Fields button on the Field Organizer dialog box.
Problem: What should be printing here? The book shows whole lines of text. I'm only getting the last 3 characters showing here.
This is a great feature for documenting fields, just wish it worked better.
The request. Why can't the clipboard be used when writting notes to document a field? ???
Thanks.
CraigdbSubj: CraigDB0--truncated notes
Date: 93-06-11 01:14:48 EDT
From: GWRepDave
Craig, I've only had this happen once, when just the last three characters of a note appeared in the DB. I've not been able to duplicate it. And, I don't know how I made the notes reappear, but they did. If you can provide more detail about how you can get it to reliably reoccur, we'll be sure to send along the info.
Don't have an answer yet for why the Clipboard doesn't work with notes to document a field.
DaveSubj: CraigDB--sorry....
Date: 93-06-11 01:15:31 EDT
From: GWRepDave
to have misspelled your name. I saw my typo right after I hit the post button.
DaveSubj: Merging...
Date: 93-06-11 01:39:11 EDT
From: RobertB428
I was afraid you were going to say something like that. Oh well, back to the layout drawing board! ;)
BobSubj: Sequoia
Date: 93-06-11 12:15:17 EDT
From: GW Steve
I just opened a new GeoFile, created four fields, three were set to number types and the fourth was set to caculated using the expression
field_1+field_2+field_3
My database caculates field_4 even when some of the first three fields are left blank.
Not sure why you are having that problem. Of course there is the limitation, discussed in the manual, that you must edit atleast one of the fields to force recalculation in each record.
When it doesn't work, what shows up in the calculated field? Nothing? If you get a #TYPE# error, then one of the fields is not a number field.
Steve Subj: Steve
Date: 93-06-11 22:07:15 EDT
From: SEQUOIA3
Thanks for the input.
Actually, the computed field is a sum of computed fields in currency format. As follows:
QTY field: Integer/General # format
EACH field: Real Number/Currency # format
(the product of these two equals the next fiield)
AMOUNT field: Computed/Currency # format
I have five (or more to be added) of the above.
The SUB field will be the SUM of all of the AMOUNT fields (amount+amount_1+amount_3....)
I do get #TYPE# in the sub field, although I have doublechecked that EVERY amount field is a number field. BUT!!!!!!
What I think I missed is that the blank (unused) AMOUNT fields have the error message "Can't display as a number" in them. So I think I need to redo the expression in the AMOUNT fields. It is currently:
PRODUCT(QTY,EACH)
Apparantly I need to create a CHAR(223) in the unused amount fields to make them remain blank without a "Can't display..." error message. I'll try an IF statement.
Thanx!
IF (aaa=1,(bbb+ccc)*0.06,0)
Works fine--thanks much--never would have gotten to the correct formula format without your help.
KateriSubj: GeoFile Merge Questions
Date: 93-06-25 22:01:03 EDT
From: JohnOler
Subj: GeoFile to GeoWrite Merge Questions
From: JohnOler
Need some help from you Merge whizzes. Have date fields in GeoFile that convert from 1-1-93 into January 1, 1993 when I tab or return out of the field. That is the way I want it. However, when I merge into a GeoWrite document, it prints serial dates instead of the long date. The GeoFile fields have no special formatting--just a Date field.
Also having problems with numbers and currency. Created a number format which forces six places behind the decimal (80 becomes 80.000000) for fields in GeoFile. When the numbers are merged all trailing zeros are gone. 80.000000 becomes 80. Likewise, 80.010000 becomes 80.01. Similar problem with currency. $250.00 in currency field in GeoFile becomes 250 in the merge.
Probably something simple that I haven't found, but it's driving me nuts!! Any ideas??
Thanks,
JohnOler
Subj: Kateri...
Date: 93-06-26 03:33:17 EDT
From: GW Steve
If what you're doing now works okay, then no sense "fixing" it...
But I see the problem immediately now in the formula I gave you before:
You want the sales tax to be computed at .06 for all the zips that are both above 20000 AND below 20599 (all the zips in the world are either above 20000 OR below 25999). My mistake. ::blush::
Steve Subj: JohnOler.. format probs
Date: 93-06-26 03:37:15 EDT
From: GW Steve
I haven't tried the specific situations you describe, but I ran into a similar problem when I tried to merge from computed cells in GeoCalc which contained concatenated text from other cells. I'll study the situation further and post my findings here.
Just out of curiosity, what do you get if you paste your clipboard into the Text File Editor? Do you get the correct formats there?
Steve Subj: Calculating a Field
Date: 93-06-26 11:18:11 EDT
From: ChrisM7204
How do you sum the values in a single field? I have almost 200 values that I want to sum for a total. Also, how do you get it to print the value at the end of the column? My db looks like this:
ITEM COST BUYER
Apple 2.95 cg
Box 3.15 df
Cat 2.13 ed
<------- would like total here upon
printing.
Thanks.
ChrisSubj: A different Merge query
Date: 93-06-26 13:48:43 EDT
From: SilntObsvr
I'm trying to merge a database (of bank branches) into a GeoWrite document, in such a way that a arge number of records (like about 150) print on a single page. Each record contains three fields, and I have the page set up, headers and footers (I'm doing it this way in order to be able to use the "Date Last Revised" and "Page Number" Insert Special tags...trying to automate what has been a very manual task). Problem is, I get two pages full of the first record, then two pages full of the second...instead of a single page with the first, second, third, etc records. HELP!!!! B)Subj: No blush, please
Date: 93-06-26 15:22:33 EDT
From: Kateri
I didn't have a *CLUE* before you pointed me in the right direction <g>.
The taxable/non-taxable cut is more accurate for me, because it really doesn't matter where the client lives, it's how the sale is transacted that determines taxability--whether it's in-person or by-mail. I have clients who live in MD and VA, but who come to DC to my studio--they also are charged sales tax.
Have put your dBASE language lesson in my Tutorial folder--thanks again.
KateriSubj: Error Codes/Problems
Date: 93-07-01 09:38:15 EDT
From: Legertz
Help! In GeoFile I was adding information to a current data base when I saved it, or something, and I got the system error code KR-09. I exited cleanly, supposedly, by pressing "E", rebooted, told GEOS to reset, and when I brought the file up it was wiped of all info. I had made a backup, copied the backup, started working with it, and the same thing happened when I wanted to either save or close the data base. I kept trying to get it back, and one time I got the message Error in File Read. I exited again ran a chkdsk but there were no errors. I brought up a few other data bases I created and even the templates and they all seem to function fine. Also, ]Z
otal`
That's very interesting. Mine does not have that beta info, it simply says Version 2.0. I got out an old set of beta disks at random and looked at that ini and it has yet another message on it. What I would suggest you do is send E-mail to GW Service and copy that info into it with your name, address, etc. and see if they know if you did receive an improper set of disks. And keep us posted since I'm curious as to what you find out and there may be others in the same boat.Subj: PhCkS Soft
Date: 93-06-24 22:20:19 EDT
From: SteveShell
[welcome]
versiontext = Version 2.0 Upgrade Beta 1
Sounds like you received an upgrade from GeoWorks 2.0 beta 1 to GeoWorks 2.0 official.
---SteveShell
Subj: Version type
Date: 93-06-24 23:58:55 EDT
From: GWRep MK
his is being checked out by GeoWorks. It would appear the build only came about from a beta and that this is not actually a beta version. More on this later.Subj: Conditional Expression
Date: 93-06-25 00:00:22 EDT
From: Kateri
I'm having a heck of a time creating a formula for a calculated field in GeoFile--I dunno, maybe it can't be done.
I have "Fee" (Fieldname: aaa)
"Expenses" (Fieldname: bbb)
"Sales Tax" (Fieldname: ccc)
"Deposit" (Fieldname: ddd)
"Total" (Fieldname: eee)
"Add'l Payments" (Fieldname: fff)
"Balance Due" (Fieldname: ggg)
Basically, aaa+bbb+ccc=ddd AND ddd-eee-fff=ggg
No problem with the basic formulae etc. My problem is with sales tax (ccc). Initially, the formula for sales tax was "(aaa+bbb)*.06"--no problem...6% sales tax. However, with out of state sales, I don't charge sales tax and I wanted to reflect that. This is the formula I'm having trouble creating: IF ZIP_CODE IS EQUAL TO OR GREATER THAN 20000 OR IS EQUAL TO OR LESS THAN 20599, CCC=(AAA+BBB) TIMES .06; IF ZIP_CODE IS LESS THAN 20000 OR GREATER THAN 20599, CCC=0.
Is there any way that I can do that. The way that I had it set up, Geofile had a problem with the *2* conditionals. Help! Thanks much.
I haven't literally tried this. The only glitch I can think of is that you might need to rename your fields, so that zip_code comes before aaa alphabetically.
Steve Subj: Beta
Date: 93-06-25 02:10:50 EDT
From: PhCkS Soft
This is being checked out by GeoWorks. It would appear the build only came about from a beta and that this is not actually a beta version. More on this later.
============================================
Ok, I'll wait until you get a reply before I whine.
Thanks MK :)
Godfrey.Subj: Thanks, Steve
Date: 93-06-25 09:58:28 EDT
From: Kateri
I'll try it and let you know--will rename fields to make zip cod aaa and the others bbb thru hhh.
Forgot that it also needed to be in alphabetical sequence. Based on how you've written the formula, I was REALLY "far afield" <G>.
KateriSubj: Expression
Date: 93-06-25 11:25:09 EDT
From: Kateri
Nope--didn't work.
At first I got the familiar "The parser couldn't make sense of this expression. Error Code FF-27" which is the message I was getting before. Then I changed your ">=" and "<=" to > and <
- -
(Can't key them correctly here) and the expression was accepted; however, it adds 6% to all regardless of zip code value--???; and my overall totals are off (the next calculated field). For example $80 +$20 + $6 (sales tax) equals $104.80.
Since the overall total field expression hasn't been changed, the problem must be with the sales tax field.
Should there be a "non-equivalence" somewhere in the expression, maybe?
(This is like going back to school <g>).
Kateri
Subj: Another way (Sales tax)
Date: 93-06-25 17:46:01 EDT
From: Kateri
I tried something else which worked. I created another field (1 character, integer) 1=taxable and 0=non-taxable. Don't have to deal with zip code at all.
New field /aaa; fee/bbb; and expenses/ccc.
s/ccc.
coprocessor = none
If you don't have such a section stick it in someplace.Subj: GeoFile (date field)
Date: 93-06-20 16:04:07 EDT
From: Lleep
Thanks Steve, I'll try it. It sounds pretty complicated, but I'm sure I'll get accustomed to it. Thanks again, LleepSubj: Calculating Days
Date: 93-06-20 17:57:47 EDT
From: Denmeister
I have been trying to figure out how to calculate the number of days between two dates w/G-File. Did I mention I wanted to use the results in a logical statement on a billing form. In English it would be something like. "If days between check-in and check-out are less than 5 use the daily rate , if greater than 5 use the weekly rate." So far, no luck> Has anyone ried this and been successful? Thanks for the help . . .
PS Folks in the Office seem to like the improvements in Ver 2 - we appreciate the changes and look forward to the exploration.
. . . DenmeisterSubj: Deleting All
Date: 93-06-20 22:10:28 EDT
From: Nuvo
Is there anyone out there who can tell me how to delete all the records in a dbf file in GeoFile. I have tried to do it many ways.... Marking all (not sure whether they are getting marked). The Del All never becomes active. If someone knows, I could sure use some help. Thanks!Subj: Denmeister... days
Date: 93-06-21 01:28:55 EDT
From: GW Steve
I'm going to assume you have two date fields--in date format--and they are named CHECK_IN and CHECK_OUT.
CHECK_OUT<minus>CHECK_IN yeilds the number of days.
The IF statement compares the number of days to the value 5. If it's equal to or greater than 5, then the number of days is multiplied by the daily rate.
If the number is anything else, then it's multiplied by the weekly rate.
Does that help?
If your dates include the time of day, then you may need to use the ROUND or TRUNC function to convert the result of subtracting the dates into a whole number.
Steve Subj: Days . . .
Date: 93-06-22 21:55:15 EDT
From: Denmeister
Steve,
Thanks for the message. I'll try that in the morning.
DenmeisterSubj: Upset
Date: 93-06-23 02:41:28 EDT
From: PhCkS Soft
Ok, the Georeps have been quite nice to me so far but I'm a little upset I haven't seen any acknowledgements for the problem I've posted about only 3 chars of the field notes showing up. A little research in this message area shows somebody named Craig had the same problem so it's not my imagination. Also, why does my geos.ini have under the version text the words beta? Did I get jipped on my ship?
Godfrey.Subj: Godfrey
Date: 93-06-23 09:46:08 EDT
From: GWRep MK
I believe GW Steve said he was checking into that problem. Also, could yo copy out for me those beta words you found so I can compare them to my ini and verify if perhaps you do have a wrong version. You can e-mail it to me or post it here.Subj: Godfrey... field notes
Date: 93-06-23 11:57:36 EDT
From: GW Steve
The same thing happens to my field notes in GeoFile. I haven't found any way to work around it. Only a couple characters are visible in the Field Organizer dialog box.
We've noted the problem and put it in our queue of things to work on.
Steve Subj: Beta or not Beta?
Date: 93-06-24 02:24:01 EDT
From: PhCkS Soft
Also, could you copy out for me those beta words you found so I can compare them to my ini and verify if perhaps you do have a wrong version. You can e-mail it to me or post it here.
============================================
Here it is:
[welcome]
versiontext = Version 2.0 Upgrade Beta 1
I hope I DO only have the beta. That might explain the goofy little system errors I get.
Godfrey.Subj: Thanks Steve!
Date: 93-06-24 02:25:33 EDT
From: PhCkS Soft
That's all I was asking for. Are we the only ones with this problem? If not I'm curious as to how GW got that screen shot with complete field notes being displayed. Hmmm.
Godfrey.Subj: Version text
Date: 93-06-24 09:32:54 EDT
From: GWRep MK
p MKx
locate some parts. I was marking and only showing the marked records. The problem came when I entered data that didn't work for the search, and a message was returned that had something to do with needing a true response. After this my cursor turned into an hour glass, and no matter what I did in GeoFile it stayed that way. Everything functioned okay, and if I switched to something else it returned to the arrow. The only way to correct it was to close GeoFile and reopen it. I tried it three or four times, and still the same result.
Thought you'd like to know,
TimSubj: Printing Labels?
Date: 93-06-18 01:16:44 EDT
From: JoeGizmos
I was a bit confused as to how to set up GEOFILE to print labels. I am interested in printing single wide standard labels and three wide in the future. Can anyon clarify how this is set up in the program? Thanks, JoeSubj: Darrin.. dBase3
Date: 93-06-18 02:54:31 EDT
From: GW Steve
I haven't been able to reproduce your problem importing and exporting dBase3 formats with GeoFile--nor with using the exported files in other software.
Can you give us any more specific information? Does it happen with all files? Every time? Do you have a specific type of data in the files? Have you raised the number of handles in Preferences, GEOS to 3000? Anything else you can think of to tell us about your system?
Steve Subj: Boggy.. thanks!
Date: 93-06-18 02:55:44 EDT
From: GW Steve
I noticed the other day that my mouse pointer became "reversed" in GeoFile. I've been trying to reproduce it. Thanks for the specific instructions, they might help us to figure out why and when this happens!
Steve Subj: Joe, labels...
Date: 93-06-18 03:05:49 EDT
From: GW Steve
The method for creating a multi-record layout for printing labels is covered pretty comprehensively on pages 19.48 through 19.54 in Book Two of the documentation.
It's a lot to try to re-key here in the message boards, so I'm not sure where to start. I'd like to help. Are there some specific stopping places that you run into in the instructions? Some specific questions we can try to answer for you about the process?
The "formulas" are missing on page 19.50 (a flaw in the manual, egads!), but it's not too hard to estimate the needed sizes and fine tune them by trial and error.
Steve Subj: Export to Dbase Fixed!
Date: 93-06-18 21:56:05 EDT
From: Darrin2636
Steve, I think I had some corrupted files on one of my original disks. I installed a different set of originals and it worked! I am going to call the number in the documentation tomorrow to see if I can get a new set of disks.
Thanks for your quick responce.
DarrinSubj: Creating fields
Date: 93-06-20 00:42:42 EDT
From: Lleep
I want to create a field that will allow me to call up all files in geofile (of customers) that are due to pay dues on a certain day ech month. For instance, all customers who started paying on the 3rd are due again on the 3rd. Does anyone out there understand and know how to help? LleepSubj: Lleep.. mark records
Date: 93-06-20 03:37:11 EDT
From: GW Steve
I assume you have a field that contains the date of their first payment.
All you should need to do is to Mark Records based on that field.
If the field is named DateFirstPaid and contains a date in a string format like "Jan 20, 1993" or "1/20/93", and you want all the records for just the 3rd of any month, then you could use Mark by Formula with a formula something like this:
DAY(DATEVALUE(DateFirstPaid))=3
If the field is already a date field, then your formula would be:
DAY(DateFirstPaid)=3
The records where the first payment was on the third of any month will be marked. Then choose Show Only Marked to display or print only those records.
Is that what you're after?
Steve Subj: FM-31 Error Missing File
Date: 93-06-20 12:31:34 EDT
From: Eric Karl
Greetings!
When i try to run GeoFile, I receive an FM-31 Error, Missing System File. I've re-installed the software, with the same result. So, what's missing?
EricSubj: Missing GeoFile
Date: 93-06-20 15:41:34 EDT
From: GWRep MK
If you have a math coprocessor add the following line to the section of your ini entitled [math]
they let me see what I'm doing. Also, I'd like to request an auto-sort feature, based on some sort of user-defined index field...or, the abilty to INSERT records, instead of APPENDING them. That way, if I need to (say) add a branch to the list of bank branches I keep up for my department, I can just type it at the right place in the list, instead of willy-nilly being forced to the end, and having to sort manually to get it in the right place, and THEN have to wait for a complete page redraw (pretty slow with 150 records on a page) to get the right page!Subj: Sort problems
Date: 93-07-11 07:20:38 EDT
From: MichaelDG
I've been trying to sort a large 4.5meg file with 11,500 records and having trouble. I have been using an advanced sort on 3 fields and after about 7 hours of work I get a "low on resource handles" error message. I have my geos preferences set at page size 4096, max file size 4608 and # handle 3400. I have a gateway 16mhz 386sx with 4 megs of ram. I have 629k of lower memory available and 2.9 megs of available EMS memory. Any suggestions on how to get things going, when I try to increase the number of handles, it won't go higher than 3500.
Thanks-MikeSubj: display as currency
Date: 93-07-11 10:40:05 EDT
From: AntBee
I have a "real number" field that I want to display in dollars and cents. No matter how many times I follw the instructions in the manual...no dollars!! Can anyone help? Thanks.Subj: Currency
Date: 93-07-11 11:27:39 EDT
From: SEQUOIA3
<<<I have a "real number" field that I want to display in dollars and cents. No matter how many times I follw the instructions in the manual...no dollars!! Can anyone help? Thanks.>>>
In addition to setting the FIELD TYPE as a real number, you need to use the FIELD NUMBER FORMAT option, and set it to CURRENCY. You can also create your own custom formats in this menu, if desired. It is located under the PROPERTIES menu.
Also, whenever changing FIELD TYPE (or anything) in the EDIT A FIELD organizer, be sure to hit APPLY to save the changes.
RonSubj: NUL computed fields
Date: 93-07-11 13:12:42 EDT
From: SEQUOIA3
I am having trouble with the use of computed fields that contain no values.
Here's the scenario:
The file is an invoice which consists of the following fields:
QTY (integer)
EACH (real number, fixed format)
AMOUNT (computed, fixed format) the expression is PRODUCT(QTY,EACH)
The invoice contains the above three fields 12 times, ie: line 2 is (QTY_2, EACH_2, AMOUNT_2) line 3 is (QTY_3, EACH_3, AMOUNT_3) and so on.
If ALL of these fields contain values, then all is well and they are totaled up in SUBTOTAL [SUM(AMOUNT:AMOUNT_12)] just fine.
If ANY of these fields contain NO input, then I get the error #COUNT# in the computed AMOUNT_xx field, as well as in the SUBTOTAL field.
What I need to know is if there is a formula (some type of IF statement?) to enter into the computed AMOUNT_xx fields, so that they will remain blank if there s no input to the computed fields. (I don't want to enter zeros). As much as I would LIKE all of my invoices to be full pages, it just isn't always so.
Thanks! Any enlightenment is appreciated!
Incentive: I'll upload these invoice templates to the libraries as soon as I get the formulas figured out. Both in full page & half page formats. :) hehehe
RonSubj: CHAR(223)
Date: 93-07-11 13:16:08 EDT
From: SEQUOIA3
What's the CHAR for a blank? I tried CHAR(223), as it was shown a blank in the manual, but I get an upper case CHAR(222) instead.
Y with a ' above it.
RonSubj: Ron, blank character
Date: 93-07-11 16:01:36 EDT
From: GW Steve
That's a misprint in the manual about character 223.
I don't think there's any such thing as a "blank" character. There is the space character (32) and the non-breaking space (202).. but a true "blank" is the absence of any character.
With strings, you can signify a null string with "" (two double quotes).
Steve Subj: GW Steve
Date: 93-07-11 17:40:45 EDT
From: Jeffrey Tz
re: the messy screen: hehe, well actually I just wondered if it was my video card or something, since I hadn't seen anyone else mention it. I've never had a Geos app do that.
I've gotten around the record control panel by just reducing my 'view' to 90%.Subj: null strings & things
Date: 93-07-11 18:02:21 EDT
From: SEQUOIA3
<<<With strings, you can signify a null string with "" (two double quotes).>>>
Thanks Steve! That helps immensely! I don't need to screw arpound with the CHAR's after all.
Date: 93-07-05 22:18:32 EDT
From: Tsquared 1
Try the Timesheet GeoCalc file here on AOL. You may be able to use the same formulas in your database.
TIMEVALU.ZIP and TIMESHT1.COM are the files you should take a look at (in the GeoCalc folder here).
TSubj: TimC27
Date: 93-07-06 18:42:09 EDT
From: GWRepBruce
I will see what I can come up with... do you want to allow for a project that takes 33 hours?? Meaning over a day?Subj: Time Calc
Date: 93-07-06 19:00:53 EDT
From: TimC27
I attempted to use the Timesheet formula, and have been doing "very poorly" with it. I'm not familiar with this stuff, formulas and the like. I mean, I am having trouble getting the thing to display simple times. Dates I seem to have gotten correctly. I am apparently confused on the number of "TIME" commands(Time, TimeValue, Now, Day, Hour, Minute, ETC...).
As for the amounts of time I want to calculate, I don't see any need for 33 hours or anything close to it, although I do work past midnight sometimes, and the day-change may be a problem.
Thanks for looking into this.
TimC27Subj: TimC
Date: 93-07-06 20:25:43 EDT
From: GWRepBruce
I have sent you a file in mail, and also uploaded it. It is called timefile.zip and demonstrates a couple methods to do what you want, I think!Subj: Congressonal Fax numbers
Date: 93-07-07 13:13:37 EDT
From: RJ 33186
I downloaded this file and when expanded looks like it is a format instead of a database with the numbers i wanted. It's in the customer file area under GeoFile. Am I doing something wrong or is that all it is?Subj: It's more
Date: 93-07-07 15:36:59 EDT
From: GWRep MK
I forget what you need to do, but several people have said that to find out they're wrong. I'm just posting this in case I forget to play with it or someone else doesn't come here to answer. Send me e-mail to remind me if you don't get an answer and I'll tell you how to get it to work.Subj: The 103rd Congress File..
Date: 93-07-07 16:53:39 EDT
From: GWRep Neal
This file (CONGFAX.EXE, Congressional Phone and Fax) consists of three layouts: Introduction, Report 1 and Casual. You'll find the records in both Report 1, which is in a traditional column layout and in Casual, which is in a larger graphics layout.
To view the 536 records it contains, choose LAYOUT>Switch Layout while in Data Entry mode and choose Report 1 or Casual.
If you're using Levels 1-3, you will see records one at a time. If you're using Level 4, you can switch to multi-record mode and view a page of records at a time.
Designing Tip: It's a good idea to always include some kind of road map to your database... even if it's just a tip to "Switch Layouts" in the database's Introduction.
But 103rd Congress is an excellent showcase for GeoFile, superbly designed and making good use of GeoFile's Layout feature. Should give the rest of us ideas for other databases.
I, for one, was impressed with this file. Good show, JamesPelt!
NealSubj: tsquared 1
Date: 93-07-07 19:22:36 EDT
From: AntBee
Only thing in the files is names & dates of comic books (collection). no graphics, approx. 55 records. chdsk found nothing. no special options used,same problem with another file that I have created with Geofile. Please help???Subj: Messy screen, dBase MEMOs
Date: 93-07-08 01:20:47 EDT
From: Jeffrey Tz
How come when I dvance through my database I get garbage at the bottom of each field (after rolling through about 3 or 4 records)? It looks like the bottom edges of the letters from the previous record remain in each field. Blech.
Also, I noticed that one must convert dBase III/IV MEMO fields to standard charecter fields (big enough to hold your biggest entry in that field) before importing the dBase file into geoFile or you will only get the first 10 charecters.
And how come I gotta use that HUGE record control panel instead of a nice tool bar I could stick at the top?!
Jeffrey TschiltschSubj: Thanks Jeffrey
Date: 93-07-08 11:30:33 EDT
From: GW Steve
Thanks for the tip about importing dBase files.
I assume your other two questions are just rhetorical. I'll add your "votes" to our future changes and suggestions list.
Steve Subj: Add my vote, too...
Date: 93-07-10 05:18:47 EDT
From: SilntObsvr
I REALLY hate the "Tape Recorder" controls, at least as the only way to get around in GeoFile. I'd MUCH rather have the ability to PAGE forward and back, at least in a multi-record layout...which I use a lot of, because
GeoWrite documents are also fine. What happened? What do I do? And where the hell is the documentation on all these error codes? They all have numbers but I looked through both manuals, and Troubleshooting, and couldn't find one. Not even a mention of the word error in the index.
I love GEO but it has a lot of troubles with 2.0. Will all us loyal customers receive the DEBUGGED release when you fix all the errors we are reporting? I expect so.
LegertzSubj: Corrupted file
Date: 93-07-01 13:19:07 EDT
From: GWRep MK
It sounds to me like the file was corrupted before it was backed up. It could have taken a hit from just about everything. I would use Salvage or the text reader to try to extract the data and put it back in another file.
The listing of error codes is available in the library. It was not finished in time for the Troubleshooting Guide.
The particular problem you are reporting is not a bug type of problem but one of the hazards of computing.Subj: Formula Help Please!
Date: 93-07-01 21:03:47 EDT
From: StevenB752
I require a little help with GEOFILE. I have a database which I use to keep track of my software. My field titles are "NAME", "CATEGORY", "TYPE", "DESCRIPTION". All fields are just text fields. What formula would I give to get the following answers:
(1) I want to see all the records which are equal to the word Business under the field title "CATEGORY" and equal to the word Educational under the field title "TYPE"?
(2) I want to see all the records that begin with the letter "M" under the field title "NAME"?
(3) I want to see all the records which are equal to the word Business under the field title "CATEGORY" OR equal to the word Educational under the field title "TYPE"?
Any help on this mind puzzling problem would be greatly appreciated.
Thanks in advance.
StevenSubj: Formula Help
Date: 93-07-01 22:02:30 EDT
From: IMJerry
>(1) I want to see all the records which are equal to the word Business under the field title "CATEGORY" and equal to the word Educational under the field title "TYPE"?
>(2) I want to see all the records that begin with the letter "M" under the field title "NAME"?
The formula here is (I think):
left(name,1="M"
>(3) I want to see all the records which are equal to the word Business under the field title "CATEGORY" OR equal to the word Educational under the field title "TYPE"?
<<<(1) I want to see all the records which are equal to the word Business under the field title "CATEGORY" and equal to the word Educational under the field title "TYPE"?>>>
Try this formula
AND(CATEGORY="Business",TYPE="Educational")
<<<(2) I want to see all the records that begin with the letter "M" under the field title "NAME"?>>>
LEFT(NAME,1)="M"
<<<(3) I want to see all the records which are equal to the word Business under the field title "CATEGORY" OR equal to the word Educational under the field title "TYPE"?>>>
OR(CATEGORY="Business",TYPE="Educational")
Steve Subj: Clearing contents
Date: 93-07-02 16:37:37 EDT
From: RobertT300
I've used an imported .CSV (comma separated values) file to create a GEOFile database definition.
Now, I have prepared a nice layout of the database and would like to use an "Empty" version as a template document.
How can I get rid of the current contents (there are 240 some records) so I can have an empty database to save as a template?
Hope there's another way than deleting records one by one?
Also, when defining a database, should'nt the boxed fields length adjust to the length specified in the definition (Edit Field)? In my opinion, that would be an improvement...
Also, I find that the field headers are "Groupable" while I cannot "Group" the field boxes. What is the reason?
Thanks. Appreciate the time you'll spend answering my questions.
Robert T300
Mississauga, Canada
END OF JUNE DOWNLOAD
As usual, a few suggestions/question:
1. Please make mark records a pinnable menu. I find it to be the easiest way to access the data (purchasing) that I need, but I move rather rapidly from group to group, checking histories. Pinning the mark menu helps, but it still leaves unnessary steps.
2 In Calc and File it would help to be able to limit Find to one Column/Row or one record element.
3. Allow variables in Mark records like * or ?. Also give us the abiliy to enter the first letter and let just records that begin with that letter be marked.
4. Allow us to map imports into existing templates. Where the dialog box says Field1, Field2, etc.., let the template titles show, allowing us to map our dbase fields to the longer GeoWorks extensions. This would really help those of us who have to work outside of GeoWorks most of the time.
As I said, I am beginning to make do and enjoying not having to leave GeoWorks as much. Even with some of the extra hassle (PeachTree[.wk1]>QuattroPro[dBase]>Ensemble2.0)it beats working native in PeachTree. I don't know if I would want that company programming for GEOS or not. Since my boss seems inclined to stick with it, I guess a GEOS version should be an improvement.
TimSubj: AntBee, sum over records
Date: 93-07-19 23:32:33 EDT
From: GW Steve
I'm afraid there's no way to perform calculations across records in this incarnation of GeoFile.
To accomplish what you're after, you could export the data and import it into GeoCalc, where each record would be a row and you could add up the values in a column.
Steve Subj: Tim, ideas...
Date: 93-07-19 23:57:22 EDT
From: GW Steve
<<<1. Please make mark records a pinnable menu. I find it to be the easiest way to access the data (purchasing) that I need, but I move rather rapidly from group to group, checking histories. Pinning the mark menu helps, but it still leaves unnessary steps.>>>
Good idea.. thanks!
<<<2 In Calc and File it would help to be able to limit Find to one Column/Row or one record element.>>>
You can do this to some degree by using Mark by Formula in File. In Calc, if you select a range of cells before using the Find feature, the Find will be limited to the selected range.
<<<3. Allow variables in Mark records like * or ?. Also give us the ability to enter the first letter and let just records that begin with that letter be marked.>>>
You can accomplish some of these things using Mark by formula, also. For example, if you want just the records in which he data in a field named SHOES begins with the letter "w", then use the formula
LEFT(SHOES,1)="w"
if you want it to be case insensitive, then
UPPER(LEFT(SHOES,1))="W"
<<<4. Allow us to map imports into existing templates. Where the dialog box says Field1, Field2, etc.., let the template titles show, allowing us to map our dbase fields to the longer GeoWorks extensions. This would really help those of us who have to work outside of GeoWorks most of the time.>>>
I agree this is probably THE most needed additional feature.
Steve Subj: GWRepBruce
Date: 93-07-20 00:25:20 EDT
From: RobertB428
Actually, what I said was that the database was not in any order that GeoFile could sort to. (i.e., Class types: BB, DN, BCH, CA, CW, CL, DW, DD, FF, PC)
I do, however, think I may have come up with an easier solution. What I did was add an Alpha-numeric sort field. Kind of like Basic line numbering. When I want to add a record I just number it appropriately, then sort the database on the sort field.
Another needed feature in GeoFile is the abilty to have more than one database within a file, and also to be able to link multiple databases with specified fields. I need to add some unique information to the database that only requires a few records. If I create new unique fields in the database for these records then I will have 600+ records with these fields empty (an awful big waste of space). What I want is for the new information to be displayed in a separate layout similar to the first, but without displaying any of the original fields (or records). I think what I will have to do is add the new information into the original database (the fields are similar), then filter the records by marking and displaying the ones I want. It's not quite what I wanted, but for the moment it's all I can think of.
Bob
Subj: Geofile Uploads
Date: 93-07-20 17:50:18 EDT
From: Philip1117
It would be helpful if anyone who has completed geofilde databases to upload them. I get alot of ideas from the way others pu toghether databases. So don't be shy, there are people who want to see your work.
ThanksSubj: Mark by formula..
Date: 93-07-20 19:34:48 EDT
From: Boggy
I would like to learn to use this, but almost every time I try to use this
h some o
in the Customer files / geofile area there are some recent files that demonstrate a couple methods for setting up fields to determine the amount of time that elapses between a start and stop, or to compute the number of days between a start and stop date.
It can get real complex if you want to NOT count the weekend hours and days, and NOT count the hours between 5PM one day and 8 am the next morning, although it could be done. The weekend thing would be tough to have a logical statement that would somehow check if the date was a weekend day. Maybe it could be done, but not sure.
in future posts of questions, please try to limit the number of questions, so people will not be put off by the sheer complexity of your situation. If you can break it down into smaller, easier to answer questions, the asy questions will get quicker responses, I bet!
I am leaving home for a couple weeks, and may not have access to phone... otherwise, I'd try to get more details from you in e-mail and see if I could offer some suggestions.
I am working with very simple small GEOFile projects initially, as I try to learn this .... you are quite ambitious in your project!! But others have done similar things.
Maybe you could download some of the GEOFile things in the customer files, and get some exposure to what others have successfully done, and maybe borrow some ideas from their work.
Sorry, I cannot give any real solutions right now, but if I have access to phone between now and end of july, will check on your posts in this area!
Subj: More Error Messages!
Date: 93-07-17 11:50:11 EDT
From: MichaelDG
I've been having trouble with KR-16 low on conventional (low)memory messages and KR-9 low on resource handle messages when trying to do an advanced sort on a 11,500 record file. When I run the sort, my computer does about 6 hours of reading from the hard drive, then I get the error message. I have been having repeated low on system resource handles messages, but then added the share.exe line with f:12288 to my autoexe.bat file. When I ran the sort again I got the low on conventional memory error message. I've loaded all my device drivers other than himem.sys and EMM386.exe in high memory and have 629,904 bytes of available lower memory.
I have a Gateway 2000 16mhrz 386sx with 4 meg of RAM.
My config.sys is as follows:
DEVICE=c:\dos\himem.sys
DOS=HIGH,UMB
DEVICE=c:\DOS\EMM386.EXE 3145 RAM AUTO M9
DEVICE=C:\DOS\SETVER.EXE
devicehigh=c:\dos\ansi.sys
devicehigh=c:\mouse.sys
STACKS=0,0
BREAK=ON
BUFFERS = 30
FILES=30
SHELL=C:\DOS\COMMAND.COM C:\DOS\ /E:256 /p
drivparm=/d:1 /f:7
My Autoexec. bat is as follows:
@ECHO OFF
REM SET COMSPEC=C:\DOS\COMMAND.COM
VERIFY OFF
PATH D:\GEOS20;C:\;C:\GEOWORKS;C:\DOS;
PROMPT $P$G
loadhigh c:\share.exe /f:12288
MIRROR C: D:
set SOUND=C:\SB
cd\geos20
geos20
Any suggestions on what todo?
P.S., I just ran the sort again with the swap file size increased to 10 megs from the Geos preferences menu.
Guess what happened, this time I got the low on resource handles error message!!!!!!! I've been trying to sort this file now all night, every night for 10 days and am getting REAL frustrated.
I could really use some help on this.
Thanks, -MikeSubj: Mike, sort
Date: 93-07-17 17:08:05 EDT
From: GW Steve
I assume you've raised handles to 3500 in Preferences and obviously you've tried increasing your Max swap file size.
Sounds like you've been doing most of the same things I would try to do to fine tune the system.
In theory, GeoFile is designed to handle over 16,000 records. In practice, an advanced sort on 11,000 records is obviously going to test the limits of the system. Your startup files look good.
Have you tried increasing FILES= or BUFFERS= ? Just a shot in the dark...
Steve Subj: Formula help please
Date: 93-07-19 19:38:10 EDT
From: AntBee
I have a "comic book collection" database, and each record has a value in it for a comic book. In addition, I have a field named "total value"- and I'd like it to add all the "value" fields to give me a value for my whole collection. Can't figure out the formula... Have used SUM (value) but that just gives me the value for that record, not all records. ChrisM7204 asked the same question on 6/26/93- but I cant find where anyone answered. Please help...Subj: I like it better every..
Date: 93-07-19 19:57:50 EDT
From: Boggy
I am learning how to get some of what I want out of it.
entries on the same customer- various calls?
Also while entering formulas fo the time fields I am not able to get the results I would like. For ex. the field type is "time" for time in, time out etc... If I deduct one from another I would like the sum to appear like this 2:37. for ex. call dispatched's entry is 10:32am, time in is 1:05pm, now the formula i've used is sum=(time in - call dispatched) but I dont get the answer i want. My field number format is:time:Hour min. trying various combination has resulted in a vary frustranting 3 hrs. I am obviously doing something wrong. Since the work day is only form 8:30 to 4:30 how do I design a formula to substract only *working hours* time, taking into account the weekend as well? can anyone help. While I got your attention, there is something else i need to figure out. I have to take reading of various meters. So I have set up some fields for those as well. Ascending, Descending, Total. When entering the fields I would like the number to automatically enter the decimal place. for ex when I enter 123456=1234.56 I tried various combination and designing my own number without success.
Something strange happende on the way to create a field. While all the field where there for editing, when it came time to go to tab layout I noticed that there were a few missing. I double checked to make sure that my field (phone) was there but for some reason wasnt in the tab for promote/demote. Anyway, I went to do some data entering and the database would not tab to the phone field, in any combination. So I though I would force it by clicking the field and as soon as I pressed enter the program gave me a KR09. I tried it three times and it did the same all three. If anyone would like to give it a go I'll upload the file. It may be a bug. I fixed it by deleting the "bad" fields and creating them again.
I know this is a lot of question but as you can tell I/m a novice at Databse. No doubt I'll have even more questions in the future. This is a great product by the way.
Subj: RonV...
Date: 93-07-15 03:00:06 EDT
From: GW Steve
I think you can get wha you want by keying in the field names in the graphics layer at the top of the multirecord page, and by having a record number field at the left edge of your layout.
Steve Subj: Thanks GW STeve
Date: 93-07-15 12:04:16 EDT
From: RonV158489
Thanks for the info on record layout. I'm having a hard time getting used to the fact that GeoFile is more versitile, hence, more difficult to learn than MSWorks. I'll be in touch with more adjustment questions soon!Subj: Argh!!!
Date: 93-07-15 14:03:29 EDT
From: RobertB428
What I want to do is insert a record in a GeoFile document, at a specific point. Apparently, this cannot be done. Sorting is not an option, because the records are not in any order that GeoFile will sort to. I can export the data to a .CSV file (DBase III exporting always ends with a KR-07 error -- yes, I have read the GeoFax on such errors, but none of the solutions helped), manually edit the .CSV file to include the record where I want it, but I cannot import the data onto a predesigned template. I have already redesigned the template once, because I originally designed it before importing the data (nearly 600 records).
Sorry if I sound a little miffed here, but I am getting extremely frustrated. It appears that now I'm going to have to create another new database, importing the .CSV file to it, and then redesign the template to put the fields where I need them, AGAIN!
Can anybody suggest a better way?
Bob
P.S. - Also, the delete marked records option in the edit menu is shaded out and is unselectable no matter how many records are marked (or unmarked).
Subj: GW Steve
Date: 93-07-15 17:24:35 EDT
From: AntBee
It worked!!! I have dollar $ign$ in a field. No idea what I was doing wrong-seems like I repeated the exact same steps over & over. But it doesn't matter now-it works. Thanks a bunch.Subj: Ch, Ch, Ch, Ch, Changes
Date: 93-07-15 17:54:48 EDT
From: SEQUOIA3
<<<It worked!!! I have dollar $ign$ in a field. No idea what I was doing wrong-seems like I repeated the exact ame steps over & over. But it doesn't matter now-it works. Thanks a bunch.>>>
Do I EVER know this feeling!!!!!!! Every time a change is made you must go to the Data Entry mode, and make changes to the values to see them implement. And some changes will not implement until you actually create a new record, such as creating a default expression.
RonSubj: RobertB428
Date: 93-07-16 21:03:17 EDT
From: GWRepBruce
Why do you want a database that has no filed that can be sorted on??
If you just have a list of data and don't want to be able to sort it, why not just have a GEOWrite document?? then you could just use the Search function there. Continually exporting the entire database everytime you update it in order to get the new records in some specific order seems like a real frustrating task that will continue to get worse and the data grows. With GEOWrite, just type the new data in whereever you want it!
Does this make sense?? Am I interpreting your problem correctly?
I guess if you are using the report features of GEOFile, maybe GEOWrite will not suffice.
what are the fields?? I cannot imagine a Database that has no order to it.Subj: Shamu, times, dates etc
Date: 93-07-16 21:14:06 EDT
From: GWRepBruce
Regarding my previous post on the INVOICE......I'm on my way to a solution......my problem seems to be narrowing down a bit.
The following expression in the AMOUNT field(s)
IF(QTY = VALUE(""), VALUE(""), PRODUCT(QTY,EACH))
gives me a 0.00 in each AMOUNT field if there are no values entered. They total out correctly in the SUBTOTAL field. ( SUM(AMOUNT:AMOUNT_12) )
What I want to do is eliminate the 0.00 in the amount fields, and deal with only blanks. (Aesthetics, ya know!) The following expression:
IF(QTY= VALUE(""), (""), PRODUCT(QTY,EACH))
gives me the blank AMOUNT fields just fine, but then the SUBTOTAL field returns a #TYPE# error.
It seems that SUM(AMOUNT:AMOUNT_12) doesn't recognize the blanks created with the ("") part of the AMOUNT fields expression. I've tried using STRING in place of VALUE - no workie.
Hmmmm.... if this makes sense to ANYONE - I'd appreciate any help, and congratulate you, since typing this just blew MY mind!!!
ACK!!!!!! (Ain't this FuN!!!!!???)
RonSubj: SEQUOIA3/CURRENCY
Date: 93-07-11 18:10:33 EDT
From: AntBee
I had already tried to set it to currency, exactly as you suggested. I followed the manual (about 20 times!!). Nothing happens! Any other suggestions? your help is much appreciated.Subj: AntBee -Select Field
Date: 93-07-11 18:31:33 EDT
From: SEQUOIA3
<<<I had already tried to set it to currency, exactly as you suggested. I followed the manual (about 20 times!!). Nothing happens! Any other suggestions? your help is much appreciated.>>>
Yes. I may have left out an important step. :)
First, select the field on the document page with the arrow pointer, instead of selecting it in the Field Organizer box. Then select the FIELD NUMBER FORMAT option. And be sure to hit APPLY.
Initially, I tried to do this by just highlighting the field in the Field Organizer box, but that didn't do the trick.
RonSubj: CURRENCY Display
Date: 93-07-13 06:32:06 EDT
From: AntBee
I tried selecting the field both ways.(arrow tool & field organizer box) In fact , I"ve tried to do this 20 or 30 times. Still no currency! Subj: Ant Bee, currency
Date: 93-07-13 07:10:25 EDT
From: GW Steve
I can't imagine why this isn't working for you. Here's step-by-step what I do...
1. Go to Design Mode
2. Select the field by clicking on its border or dragging around it. You can choose more than one field at a time. The fields must, of course, be Integer or Real Number fields
3. Click the Properties menu
4. Click Field Number Format
5. In the Field Number Format dialog box, click Currency, Currencywith commas, or Currency Integer, whichever one you want.
6. Click Apply.
That's all. Go back to Data Entry mode. While you are entering data in Data Entry mode, the field which contains the insertion point will not show the dollar sign, but it will appear as soon as you move the insertion point to another field.
Steve Subj: Importing from MSWorks
Date: 93-07-14 15:58:55 EDT
From: RonV158489
One of the reasons I so anxiously awaited my upgrade was that an unnamed sales person told me that I could import MSWorks files into GeoFile and GeoCalc. So far that has been impossible. Anguish slowly becoming anger!Subj: Multi-Record Help Needed
Date: 93-07-14 16:03:05 EDT
From: RonV158489
I was hoping that in multi-record that I could get GeoFile to post field titles along the top with record numbers on the left side. Is this possible? I guess that was a feature that I really enjoyed from MSWorks database.Subj: MSWorks imports
Date: 93-07-14 17:15:16 EDT
From: GWRep MK
You could do this only if there is a way to save files in MSWorks in one of the formats supported by GEOS for import.Subj: Questions
Date: 93-07-14 18:42:02 EDT
From: Shamu
Hi there, I just started using Geofile and while Im liking it so far, I find myself stuck and wnat to know if any of you folks could give me a hand. I am designing a customer database to keep track of all my customers. but also to keep track of all the equipment that they have. I also would like it to be a work order. that is I might go and service one customer say five times a year. From my customer list database I would like to enter this info: time call dispatched, time call answered, response(answered-dispatched) time in, time out, response time (time in - dispatched). Now Ive pretty well have done all the fields for the above but my question is. If I have all the info on the cutomer, and just wnat to enter the work order info, how can I design my database in such a way as to do multiple
If I could take a year off, I could probably write a comprehensive book about how to write expressions in GeoFile. And it would probably not be much more useful than the manuals are now, to be honest. Everything you need to know about using the functions is in the docs.
As it is, I don't know what to offer except that I do seem to have a knack for writing good expressions if I can understand exactly what fields someone has and what they want to accomplish. Whether that's a talent or the result of being a math major, I don't know. I also don't know how to quickly hand over the ability to someone who says they don't have it. Everyone has different needs and the possibilities of how to use expressions are endless.
Steve Subj: GeoFile
Date: 93-07-22 19:35:52 EDT
From: Sandy42
Steve--Thanks for soothing the savage beast that comes out when I log on after 11PM! I KNEW you had to have been a math major--I barely qualified on the SAT's in math, and I think most of my points came from figuring out how to fill in my name and address in all the correct little #2 pencil rectangles ;-)
OK, so I'm a writing fool who uses the left side (or is it the right?) of my brain, OK? That's my dilemma. I do have a strong desire to use the DB, but can't seem to get my brain's right side to match the left side's view of what information I want to pull up with ANY function in the manual. I'm not so different from other people, am I?? Huh, Huh ?
I figured that all the functions were listed in the manual, but what's issing is real LIVE applications that incorporate them. When I tried to used the one or two examples that WERE listed, they failed, just like your example predicted they would.
Also, I know how unconstructive it is to complain and not offer alternatives. So try this one on for size:
How about getting someone to teach a class in the Interactive Education program all about just GeoFile ALONE. No gimmicks, no DTP templates and such, just classroom instruction and homework assignments on plowing thru a simple DB file that all the students would download and that had known specific information in it, and learning how to do this stuff. That way, we'd all be enriched and I'd be eternally grateful that both sides of my brain could figure out that
LEFT(SHOES,1)="w
actually MEANS something useful, and is not meant to confound and frustrate me.
Sandy
Subj: GeoFile Learnedness
Date: 93-07-22 21:03:35 EDT
From: SEQUOIA3
<<<How about getting someone to teach a class in the Interactive Education program all about just GeoFile ALONE.>>>
But....all of those "someones" are in the process of learning GeoFile now, from a higher authority! :)
RWSubj: GeoFile/GeoWrite Merge
Date: 93-07-22 22:43:43 EDT
From: PeterC3611
When I try to use data from GeoFile in a GeoWrite document, the merge fields are all right except for the date format. GeoFile allows the date field to show in several formats, but when the data is exported to a GeoWrite merge (via Clipboard), the date on the printed document will be a five digit Julian Date. Any suggestions as to how I can get the date formatted properly on the printed document. Also, when a document has been printed, is there any way to save the file to disk for later retrieval? What I want is a document that will stand alone and not rely on the merge operation any longer - a document that contains the merged fields in place of the merge indicators.Subj: Sandy... get's my vote!
Date: 93-07-23 02:53:18 EDT
From: GW Steve
I'm all for that idea, Sandy. I wish I had the badwidth to lead such a class myself, but there just aren't enough hours in my day.
But if there's anything I can do to contribute to the effort, I'll be more than happy to.
I'll suggest the idea to some folks I know.. for starters..
Steve Subj: Peter.. merge
Date: 93-07-23 02:54:22 EDT
From: GW Steve
I've not found a work around for the date merge problem yet... and the only way I know to save a merge file is to print to file. Unfortunately, that doesn't give you an editable file as a result.
Steve Subj: Redesigning template...
Date: 93-07-23 20:10:46 EDT
From: SilntObsvr
...can be avoided. Open the old file and the new (import) file together, tile the windows, and put both in Design mode. In the new document (import), select Layout, Create New Layout, and you'll get a blank screen. In the one containing the layout you want to preserve, click Edit, Select All (or drag to get everything. Then just right click anywhere in the selected area and DRAG the whole thing into the new document. You'll have to reinsert the fields, but the graphics, titles, etc. will transfer and save redrawing.Subj: Exporting to plain text
Date: 93-07-24 10:24:57 EDT
From: StieglBier
Is it possible to export the information to from GeoFile to a plain ascii text file?Subj: Exporting..
Date: 93-07-25 12:40:21 EDT
From: IMJerry
>Is it possible to export the information to from GeoFile to a plain ascii text file?
Sure. In the higher user levels (level 4 anyway), under the menus
feature, I get one of those "the expression does not evaluate to true or false" statement, and my cursor locks. Not a crash, but a definite annoyance. Also, the ability to save the formulas that we create would be handy for repetitive tasks. I guess it could be achieved through the notepad.
I would of course like to have the ability to link to multiple database files, but I understand the current incarnation of File as part of a works package. I am hoping GeoWorks has plans for a stand-alone (sold by itself to run under 2.0 like Escape) full featured version.
Thanks for the hints,
TimSubj: GeoFile Expressions
Date: 93-07-20 20:36:14 EDT
From: Sandy42
Good grief, I'm sure glad to know that I'm not the only one who hasn't figured out what language the expression writer speaks!
I'd like to know what is the significance of the LEFT notation, or the "0" after a field name, as in :
LEFT(SHOES,1)="w"
I just don't get it--what ever happened to asking it as SHOES=W
That's MY idea of English, but when I do that I get the parser's equivalent of "it does not compute".
Still scratching my head...
SandySubj: Left shoes...
Date: 93-07-20 23:28:31 EDT
From: GW Steve
LEFT(SHOES,1)="w"
In English: If the leftmost "one" character of the SHOES field is equal to the letter "w"...
It's TRUE if SHOES contains the word "wide"
and FALSE if SHOES contains the word "medium"
The "1" after the comma is how many characters to look at...
LEFT(SHOES,3)="wid"
would be true if SHOES contains the word "wide"
and false if SHOES contains the word "narrow"
and true if SHOES contains the word "widow"
Does that help?
Steve Subj: GeoFile Expressions
Date: 93-07-21 23:47:38 EDT
From: Sandy42
YES! It certainly does help, but I stll don't get it! Why can't I just ask it for SHOES = w? Seems like I shouldn't have to tell it to look for the leftmost character, and the default search should be on the first letter of the data that matches.
Also, why do some expressions need a 0 in them? What is the 0 doing there, and how do I know when it should be a 0?
And why does the expression writer use the ISNUMBER fnx for text string searches???
I hate to be a pill, but that is just not at all in keeping with any sort of intuitive language that I know of. This stuff is beginning to make writing custom prompts with ANSI escape codes look EASY. OK OK, I know I haven't had math since my junior year in high school, and that was in 1970, and I admit that logic was never a strong suit of mine, but this logical linguistic hoop jumping is just frustrating me now, and I STILL haven't gotten the db to mark only those records that DO have a phone number. But my cursor has become a permanent hourglass every time I try to write another expression that the parser won't accept. I'm really ready to give it all up, but I'm too stubborn to say "UNCLE".
SandySubj: LOL! Sandy....
Date: 93-07-22 00:21:32 EDT
From: Suzi
I second that commotion!!! ;)
Subj: For what it's worth..
Date: 93-07-22 01:28:37 EDT
From: GW Steve
... you get my vote, too.
It would be nice to have a simple "search form" that looks like a blank record and in which you could just fill in the data you want to look for.
I don't know any way to make this easy. The language of GeoFile makes intuitive sense to me, but I often have to study the manual to find the right function or figure out its syntax.
"SHOES = w" probably works. It just finds no records, because it doesn't evaluate to true for any record. SHOES = "w" would find any record in which the field SHOES contains only the letter w. If you want all the records in which the contents of SHOES begins with a w, then you have to say so--LEFT(SHOES,1)="w"
If there's a zero used in a function, then it's usually a required paameter. Exactly why it's there depends on the function, so I'd have to look up the function in the manual just like the next user, unless I happen to already be familiar with that function.
ISNUMBER is a way to test to see if a field is numeric or a text string. I don't understand some of the expressions that are built automatically, since sometimes I can think of much simpler ones to accomplish the same thing, but whoever designed those must be trying to cover data that might contain more variations than my data.
al lingu
4. Select Data Entry mode in GeoFile, then choose PASTE from the Edit menu. Resize the field box so you can see the entire pasted address. Make the field box "label size." In other words, don't make it bigger than it needs to be.
5. Select "new" record, go to the next record in your GeoDex file and repeat the proces... until all your GeoDex records have a corresponding record in GeoDex.
6. Finally, go back to Design mode in GeoFile and go to FILE>Page Setup. Make the Single Record Size the size of the labels you want to print. Also, turn off Field Edges under the Attributes menu. Then, switch to Multi-Record mode and adjust the record template, if necessary, using the Pointer tool.
Switch to Data Entry mode (while still in Multi-Record mode) and you should see your records arranged label-style.
Do a test print.
The only part of this that's a little kludgy is manually copy/pasting GeoDex's Address Field into GeoFile fields. QuickCopy won't do it, and a test export of GeoDex Address Fields to .CSV and dbIV files proved to require far more editing in GeoWrite than it was worth. Copy/Paste was easier.
Hope this helps...
NealSubj: Geodex to Geofile
Date: 93-08-20 04:11:35 EDT
From: JoeS17
Thanks Neal, I will give it a shot. I'll be back if I have any more questions. JoeSubj: Import to existing template
Date: 93-08-23 13:23:49 EDT
From: SMOFBBS
I'd like to be able to import an .DBF or .CSV file to an existing template (specifically, the Mail Merge template provided with 2.0). I want to be able to re-map field names from the .dbf file, and create that durned Address field by using a calculated field make up of my .dbf file's ADR, CTY, STA and ZIP fields.
How do I do this? I don't want to have to rekey the entire database.Subj: SMOFBBS/Importing...
Date: 93-08-25 18:52:29 EDT
From: Illini1970
Bad news and good news ;) You can't import a file into an existing template in geoFile - bt you don't have to rekey the entire database either. You can import your data (from .DBF or .WKS/1 or .CSV) into a new geoFile document and then format it however you like - in as many layouts as you like. You can't merge imported data into an existing gF database either :(
Something to look forward to in an update of geoFile, like we're looking forward to a row and column feature in geoCalc!!!
John
Subj: calculated fields
Date: 93-08-26 14:11:36 EDT
From: SMOFBBS
One thing I'd like to do, but am not sure how, is this: I'd like to import a dBase database to GeoFile, and then add calculated fields to it. I did this, but it doesn't automatically calculate the field (it was an Address, City, State, Zip combined field for Mail Merge purposes). What am I doing wrong?Subj: SMO, calculated fields
Date: 93-08-26 23:24:47 EDT
From: GW Steve
Calculated fields in GeoFile are only re-calculated when you actually edit one of the fields involved in the calculation--record by record.
SteveSubj: labels
Date: 93-08-28 09:13:44 EDT
From: LaRueW
please give me a detailed sequence of how you develop mailing labels of a geodex file through geocalc to geofile and a mailmerge. I have downloaded the spool and drivers etc., but I have had a lot of crashes in the import-export area.
laruewSubj: LaRueW/Dex>Calc>File...
Date: 93-08-28 13:54:32 EDT
From: GWRep Neal
<<please give me a detailed sequence of how you develop mailing labels of a geodex file through geocalc to geofile and a mailmerge...>>
LaRueW... I do not believe there is any such animal as a Dex>Calc>File workaround. The stumbling block is the Address field in Dex, which cannot be broken out by Street, City, State, Zip.
All exporting routes, including via Clipboard, yields an Address field text string which is formatted as:
<<Name Address City State Zip>> and cannot be differentiated without a good deal of manual massaging. It also seems to me that making a pitstop in Calc only increases the amount of massaging required.
It doesn' matter whether you export to a file format or via the Clipboard.
But, this is just one person's experience. If someone has indeed perfected a Dex>Calc>File or even Dex>File workaround, I'll be all ears, too.
In the meantime, I've reposted my response to a similar query in this thread just a few days ago, in the next post.
It speaks to just bringing the Address field into File for the purpose of outputting labels.
If you wanted to bring the entire Dex file into GeoFile, you could do that through normal file exporting, then deleting the resulting "text string" Address field, creating a new Address field, and proceeding with the workaround as described, record by record.
them. Is there anyway to do this? These databases have the same number of fields and the fields are the same sizes. Any ideas?
Thanks
Mel Moore
---------------------------------------------
Unfortunately, GeoFile does not support merging two or more files on import, or bringing an imported file into an existing GeoFile database.
If possible, it would be best to merge those databases in the exporting application and importing the already-merged result into GeoFile.
NealSubj: MelMore/More on Import...
Date: 93-08-15 19:19:33 EDT
From: GWRep Neal
GW Steve posted a workaround for merging imported files on the Other GEOS Applications board involving GeoCalc. It's well worth looking at. I've copied it over to here for continuity:
Subj: Mel... merge databases
Date: 93-08-15 15:03:37 EDT
From: GW Steve
Posted on: America Online
Mel,
Here's how I would do it (there may be other methods):
Import the databases into two GeoCalc files. Then copy/paste all the data from one of the GeoCalc files into the other one (you might need to delete or ignore the top row of one of the files, if it contains the field names).
Now, export the combined spreadsheet as a DBF file and then import it to GeoFile.
Steve Subj: Saving Changes in Layouts
Date: 93-08-16 03:25:14 EDT
From: Naturist
For me this has been a very consistant problem. I was working on a document today where I began creating a new layout. After spending some time on it I had to exit and saved everything. When I came back EVERYTHING was gone. Even the name of the new layout. Nothing was there. I have been using computers and GEOS for some time so I know that I am not simply forgetting to save. In fact I am saving more often than usual. Like I said before, saving as a template works, but it is a lot of extra steps.
Subj: GeoFile Formula-HELP!!!
Date: 93-08-16 19:35:50 EDT
From: RussLe
Hey there,
I have, what I hope is going to be, a simple problem.
Using GoFile, I have the need to perform a simple math function.
The Database consists of the Following:
Field_1 = "Merchandise"
Field_2 = "Quantity"
Field_3 = "Cost/Per"
Field_4 = "Sub Cost" (Quantity*Cost)
My objective is to find out "Total Cost" By adding up all the "Sub Costs" in different Records. i.e.
Mrchnds Quantity Cost/Per Sub Cost
------- -------- -------- --------
Thingies 4 $25 $100
Pizza 2 $8 $16
Mushrooms 3 $6 $18
Round2Its 1 $200 $200
Square2Its 3 $.06 $.18
Whatsits 69 $1 $69
--------
Answer-- $403.18
"Merchandise" Can be any of three hundred different items.
Help!!!!
I am sure that this is some simple function that I have missed in the manual. Please E-Mail me back with the appropriate answer. I will be sure to feel real stupid when you show me how obvious it is. Thanks. Russ Lewis
Please Send Mail to: russle@aol.com
Subj: Russle, GeoFile
Date: 93-08-16 23:03:00 EDT
From: GW Steve
Unfortunately, there is no way to perform totals across records in GeoFile.
Fortunately, you can export the data to DBF or WK1 format and then import it to GeoCalc, where you can easily perform such calculations.
Steve Subj: Geodex to Geofile
Date: 93-08-19 05:59:23 EDT
From: JoeS17
Is there an easy way to convert Geodex files that were used to print labels for mailings to a Geofile database and then print labels? I have about 500 persons on several Geodex files that I need to mail to and now there is no label option in 2.0! I need some help! Thanks.....JoeSubj: JoeS17...
Date: 93-08-19 10:31:37 EDT
From: GWRep Neal
Maybe there's an easier way, but this is the easiest way I've found so far:
1. Make GeoDex a Desk Accessory by moving the GeoDex application icon into the Desk Accessory folder in GeoManager. Doing this will keep GeoDex "on top" of GeoFile, which you launch next.
2. Create one field in a new GeoFile database and close the Create Fields box. Open your GeoDex file.
3. Assuming the Address Field in your GeoDex file looks something like this and doesn't include any other information...
ohn Smith
123 Any Street
Hometown, US 12345
... select all the text in the Address Field box and then select COPY.
) B [ t
Subj: Robert.. file stuff...
Date: 93-07-03 03:01:53 EDT
From: GW Steve
There's no way to import data "into" a GeoFile database in the current version.
To some degree, you could copy/paste elements of one database into another, but a lot of the design might have to be done over again from scratch.
Delete Mark Records doesn't work. That's a known problem and there's no work around that I know of other than deleting each record one by one.
I agree that automatic adjustment of the length of fields would be nice. It's on our list of feature requests already, and I'll add your "vote." Do keep in mind, though, that it's quite a challenge to implement such a feature in an environment that supports variable point sizes and styles using proportional fonts.
I haven't tried grouping field names and fields themselves. That's something new for me to look into.
Steve Subj: kr-09 error code
Date: 93-07-03 11:46:05 EDT
From: AntBee
Twice I have created geofile databases only to be unable to open them a second time. Instead, I get code kr-09. Technical support has been unable to help me. Just like Legertz, I'm ready to give up. Any suggestions?Subj: Group fields/fieldnamesDate: 93-07-04 00:25:03 EDT
From: Tsquared 1
That doesn't work.......you can group fields together but I havemn't found a way to group field names together. The only workaround for that is to select each fieldname and move them that way.....also, you can move a fieldname and a field in the same way.....select the fieldname and the corresponding field and move them that way......see pages 2.8 thru 2.24 in manual #2 for information on selecting objects.
TSubj: Ant Bee
Date: 93-07-04 00:30:16 EDT
From: Tsquared 1
what is in these files? how many records? do they contain any Graphics?
This may have a bearing on why you are getting the error message. Have you tried running CHDSK on your HDD? are you using any *special* options to save these files? are you having problems with other GeoFile files?
Answers to these questions *may* show you where the problem lies. Hope this helps!
T :-{)Subj: Multi-record merge page
Date: 93-07-04 15:55:31 EDT
From: SilntObsvr
I found a sort-of solution to the question I posted here earlier, concerning merging into GeoWrite with multiple records on a page: You Can't.
However!!!
I also found a pretty reasonable work-around. I exported the database as CSV, imported that into GeoWrite as ASCII, with appropriate field mapping to get the right field order...and then used find/replace to turn all those commas into tabs! I then copied this into my formatted merge template, and there it was! 170 or so records per page, and only about 2 minutes extra work compared to a standard mail-merge print.Subj: Another workaround
Date: 93-07-04 17:40:58 EDT
From: GW Steve
You might be able to use a small page height to force several records onto one page. Would only work on dot matrix printers, of course.
Steve Subj: Unfortunately...
Date: 93-07-05 14:30:13 EDT
From: SilntObsvr
...the "small page height" would, first, run afoul of the lable-printing bug (complete system lockup if you attempt to print a lable-sized page, reported by many users), and second would also gt me MANY headers and footers per page. Since I needed the page number and last revision date in the footer, and a header that titles the whole thing, my method was the only one that would work. Good thing it's not TOO complicated! B)Subj: Time Totals
Date: 93-07-05 16:50:54 EDT
From: TimC27
I have been attempting to figure out the formula for getting a total amount of time spent on a project. My database is a worklog that has fields for "Time Started" and "Time Finished", then a "Total". I want the total to give me the amount of time I spent on the project by subtracting Time Started from Time Finished. I want the Total to read in decimal form, (I.E 2.00 hours, 2.50 hours, etc.). Any suggestions?
TimC27 Subj: TimC27....
e systemD
Subj: Text (fonted) fields
Date: 93-08-10 17:08:20 EDT
From: TimRomano
I'd like to know whether GeoFile supports a TEXT field type, in which fonts could be mixed, or where fonts could change from record to record as the situation required. (This cannot be done under Windows, but is a common feature with NextStep databases because of Display Postscript.)Subj: TimRomano/Text Attributes
Date: 93-08-10 18:10:20 EDT
From: GWRep Neal
<<I'd like to know whether GeoFile supports a TEXT field type, in which fonts could be mixed, or where fonts could change from record to record as the situation required.>>
Each field in a GeoFile Database Layout can have its own text attributes. One field can be 10 pt URW Roman Dark Blue, the next 14 pt Sans Black, the next 36 pt Superb Bold Italic Dark Cyan, etc.
Field Label attributes can be changed independently of fields.
Between GeoFile Database Layouts, you can change Field text attributes. For instance, Field_1 in Layout 1 might be 12 pt URW Sans Black. You could bring this field into a new Layout and assign it completely different text attributes, perhaps 42 pt Cranbrook Italic Dark Purple. When viewed from Layout 1, data in Field_1 would be 12 pt URW Sans Black; when viewed from Layout 2, the sae data would appear as 42 pt Cranbrook Italic Dark Purple.
It is not possible to mix font attributes within a given field, however.
NealSubj: Tom/Printing AGD file
Date: 93-08-10 22:18:15 EDT
From: Illini1970
I just tried printing the AGD bug report - same results :-(
Then I went to the options/annotations menu and clicked the print annotations button...voila! Everything printed :-)
It looks like our friends at the AGD were really fancy when they made up that GeoFile document. The more I see of these geos apps the more I like them - even if it does take some experimenting!!!
John
Subj: Printing AGD file
Date: 93-08-10 23:07:35 EDT
From: TomVicenza
Right Illini! Actually, I got an immediate response from AGD saying the file was purposely designed not to print, but rather to be emailed, so that's the reason.
Thanks,
TomSubj: Saving Design changes
Date: 93-08-11 00:00:58 EDT
From: Naturist
Has anyone else had trouble saving design changes? I have made changes in either a screen form or report design only to find that they were not saved when I exited. Yes, I did select save before I exited. The only way that I have been able to save some of these changes is to save the file as a template... reload the template and "save as" the original file name. A lot of extra steps.
Like I said... has anyone else run into this?
Subj: Naturist/Design changes
Date: 93-08-15 13:22:53 EDT
From: Illini1970
Greg,
I've been really working geofile pretty hard with lots of fields, records and layouts. All the times I have changed the design of a layout and saved the file before leaving geofile things have come back as expected. Can you give us any more details?
John
Subj: MelMore/GeoFile...
Date: 93-08-15 15:03:44 EDT
From: GWRep Neal
(from the Other GEOS Applications topic:)
Subj: Importing more than one..
Date: 93-08-15 10:48:02 EDT
From: MelMoore
Posted on: America Online
I would like to import 2 databases from PC_File 7.0 into GeFile and merge n,
sign cha
Other
Export
There are several options for exporting.
Importing is done under the higher levels also. You import the file, then add your embellishments after the import.
Subj: To elaborate...
Date: 93-08-05 16:53:22 EDT
From: SilntObsvr
...export the GeoFile data as CSV (Comma Separated Value). This will be importable into practically any software as ASCII data. In fact, you can then reimport that file into GeoWrite or TFE and use find/replace to change all ocurrences of comma or quote, comma, quote (as approriate) to Tab, and have a file that will work nicely in, say WordStar, DOS Edit, etc.Subj: for importers...
Date: 93-08-07 12:40:03 EDT
From: Boggy
I have found that your layouts can be copied to the scrapbook and saved. These layouts can then be bought back into a database and all the fields will be intact. If those fields are not in your new database, the will be deleted when imported. Now, I finally feel free to use some creative effort on the files I use the most. They are all imported from .dbf files on a daily,weekly or monthly basis, and I thought it was just a waste of effort to keep redesigning my layouts.
Now, I just import my database and copy in my layouts from the scrapbook. I tried to copy the layout to GeoDraw, but you field definitions bet lost. I was hoping to be able to use snap-to-grid to create a precise layout. It's strange, because you can copy the fields in but they loose text and borders. I did a whole layout, snapped every thing together and when I placed it in the GeoFile no data showed up like it does when I import from the Scrapbook. I guess my next request is for snap-to-grid in GeoFile.
TimSubj: Why didn't I think of tha
Date: 93-08-07 12:51:41 EDT
From: Tsquared 1
Now I have to go try it!!!!! Hopefully I can upload the reader I developed for the GEOS database that I do fo rthe software library here.........
Thanx for the idea, Tim!!!!!!
T :-{)Subj: Record Control Panel
Date: 93-08-09 19:00:09 EDT
From: D Kolmer
I'd like to suggest converting the Record Control Panel into a tool bar near the top of the screen. When I use GeoFile (which I really like, by the way), it seems like I'm always having to move the Control Panel out of the way to input data.Subj: can't print
Date: 93-08-10 00:34:50 EDT
From: TomVicenza
I'm trying to print out a Geofile "bug report form" supplied by AGD. It displays fine, but all that prints is a little box outlining where the date should be, no text, no graphics, nothing else. I haven't used Geofile much, but it does print database I imported from Clarion Personal Developer ok. I read the manual and the help file, but no go. 486sx25, 4 meg ram, Canon BJ200. Any suggestions?
Thanks,
TomSubj: Tom/Printing AGD file...
Date: 93-08-10 00:39:34 EDT
From: GWRep Neal
It might be a good idea to contact the AGD directly, as who knows who out here has this file, and whether it's even appropriate to discuss such things publicly.
Just my thoughts...
END OF JULY DOWNLOAD
/ H a z
/ H a z
) B [ t
) B [ t
/ H a z
) B [ t
3 L e ~
) B [ t
/ H a z
) B [ t
) B [ t
6 O h
/ H a z
* C \ u
Main SectionA
Main Article;
n Articl
Normal
Header
Footer
tuAAvw
B r
rint on may Panason.
GeoFile Thread AOL May - August 93 page
changed while allowing the current page to be changed?
I'm trying to write a dbase for my employees to balance our registers at the end of the night, I want them do do all their caculations in GeoFile, but NOT be able to change any previous day's results?
Can anyone help?
SeattleBoy
END OF MAY DOWNLOAD
Subj: Unchained melody(uh, rec)
Date: 93-06-01 18:17:04 EDT
From: IMJerry
>>I'm trying to write a dbase for my employees to balance our registers at the end of the night, I want them do do all their caculations in GeoFile, but NOT be able to change any previous day's results?
There is no good way to do this. The only work around I know of (show only marked) wouldn't work well for what you propose.
Subj: Couple of q's...
Date: 93-06-02 11:11:28 EDT
From: NightFlier
1) I'm creating a database form that has an "on/off" type field. If they're done with a particular record, they are supposed to put an "X" in a field, the idea being that the second page -the report- will ignore any record where that field is marked with an "X".
How would I have to construct the field if I wanted only "x" or "X" to be entered into the field?
1a) More importantly, how would I go about getting a small "x" turned into a capital "X"? I'm assuming this requires more than one field. Where would I put the computational field? How do I get my form to compute the value, and then skip to the next field -or is that automatically done?
2) I'm creating a client File form, suitable for using with mail merge. I've created a text field for "first name", and then a computed field for "salutation", which defaults to the value (name) entered in "first name". Right now, it's not letting me go back and change the salutation. That is, "Howard" cannot become a salutation of "Howi".
If I change this to a TEXT-type field, how do I get the first name field to echo in salutation, but still be independantly editable?
Here's hoping we *all* get an answer to these. <grin>
-=NF=-
Subj: NF...
Date: 93-06-02 13:09:40 EDT
From: IMJerry
>> 1) I'm creating a database form that has an "on/off" type field. If they're done with a particular record, they are supposed to put an "X" in a field, the idea being that the second page -the report- will ignore any record where that field is marked with an "X".
I don't think you can do this.
>> How would I have to construct the field if I wanted only "x" or "X" to be entered into the field?
You cannoth cause this kind of action. With a derived field, you can limit what will show but you cannot limit entry.
>> 1a) More importantly, how would I go about getting a small "x" turned into a capital "X"?
Create a calculated field that takes your X field and has a formula "ucase fieldname". I'm not sure of the exact syntax as I use to many different packages.
>>> 2) I'm creating a client File form, suitable for using with mail merge. I've created a text field for "first name", and then a computed field for "salutation", which defaults to the value (name) entered in "first name". Right now, it's not letting me go back and change the salutation. That is, "Howard" cannot become a salutation of "Howie".
Calculated fields can ONLY be calculated from other fields and other data. Don't expect to type in the field space if it is calculated.
Subj: NightFlier--on/off field
Date: 93-06-03 01:35:16 EDT
From: GWRepDave
Hi NF!--I'm a relative newcomer to creating databases, so I may be way off the mark. In the case you mentioned, however, with placing an X in the field when they were done with a record, couldn't the same purpose be served almost as easily by marking the record? Course, it wouldn't be as easy to see as the X would....
Thinking "out loud"...
DaveSubj: Denise.. query
Date: 93-06-03 04:34:21 EDT
From: GW Steve
It's not called "Qury" in GeoFile. It's called "Mark Records". Check it out. I think it will do exactly what you want.
(.txt)