How do I add a new field to all documents in my database?
Many thanks,
Mark
in Business Channel,
Written by: Mark Anthony on Oct 23 2009, 4:09pm
How do I add a new field to all documents in my database?
Many thanks,
Mark
Copyright © 2010-2012 SoftCity technologies. SoftCity, a groundbreaking social commerce initiative sponsored by Avanquest Software
3 Citizens Answers
Support SoftCity says:
If you add new fields to your documents, we have added a new command in askSam 5 (also in version 6 and 7) that will allow you to insert fields into existing documents.
If you want to drastically change the layout of your entry form, you will have to export your data to a Comma Delimited Text file (CSV) and then re-import it into a modified entry form. The steps to do this are listed below. (You might want to make a backup of your file before trying any of this)
NOTE: If you are working with documents with advanced formatting (such as resumes, Word Docs, RTF files), your formatting may be changed when the data is re-imported.
Resolution
1) First you must export the entire database to a comma separated text file (.CSV). Go to FILE > EXPORT > ENTIRE FILE. Set your 'Export Type:' as 'Text Delimited'. Give your CSV file a name and choose SAVE. Next select the fields you want to export. (Make sure that you specify whether they are single line or multi-line fields.)
2) After the export is complete, you can add the field(s) or make the changes to your entry form.
3) Next, go to DOCUMENT > DELETE OTHER > DELETE SELECTION to clear out any records that are still in your file, or else you will have duplicates when you bring your data back in. (You can search for all occurrences where a particular field that is present in all documents is 'Not Empty', that should do the trick.) This step is to clear out all old documents in the file, and to keep any Entry Forms/Reports/Mail Merges you might have stored in the file.
4) After you have deleted all documents in the file, choose FILE > PACK.
5) Finally, you should import your CSV file back into your database. Make sure that when you import, you have the appropriate entry form selected in the "Import into Entry Form" option.
After the data is imported back into the entry form, you should notice that any changes you made to the entry form prior to the import should be reflected in all documents in the file, whether it's a change in the formatting or the addition/deletion of fields.
NOTE: Inserting fields has been simplified in askSam 5, 6 and 7 using the DOCUMENT > INSERT ENTRY FORM on ALL DOCUMENTS command. Simply create a new Entry Form with only the field(s) you want to add to your existing documents, and you can add it to All or Selected Documents in any location in the documents.
Votes
Phil Schnyder says:
Hi Mark - create a new entry form with the field you want included in all documents and then choose DOCUMENT - INSERT / ADD USING ENTRY FORM.
Votes
askSam Systems says:
At the bottom of the "INSERT / ADD USING ENTRY FORM" dialog there is drop-down box ("Document Selection") where you can select "All Documents". The entry form can then be inserted into all documents in the file.
You can also use "Selected Documents" which will allow you to add the new fields only to documents matching a specified search request.
Votes
Post your comment
You might be interested in these related contributions
Adding fields to a database
I am taking over support of a mail list from another person. He gave me a CSV file and the master install disk for the program. I installed it (version 8.0.1.0) and find that the csv file contains 12 ...
in Business, by Hugh n Ross
May 17 2012, 1:21pm
MyDatabase - calulate date fields
I am a new user. i use custom data input forms. the app was quick to learn. i need to calculate dates such as <<hire date>> field is used to calculate the field <<r...
in Business, by bob braun
Jan 27 2011, 8:53pm
In Label Factory Deluxe. Database no longer exists when it does!
I create an address database in Label Factory Deluxe and the program works fine and prints out labels but when I come to use it again is says that the database linked to the document no longer exists ...
in Home & Hobbies, by james mclauchlan
Nov 4 2011, 6:21am
Adding an existing excel or word document to Web Easy site
I have a web site that requires me to add Excel and Word documents from my users. I'm having difficulty adding them. I can get Excel documents to appear on the program (Web ...
in Home & Hobbies, by Scott Eggen
Apr 10 2011, 9:57am