https://bugs.documentfoundation.org/show_bug.cgi?id=147974
--- Comment #14 from Dieter <[email protected]> --- David, sorry for my late replay. Some remarks to your very detailed description in attachment 191579: I couldn't find the attachment with "memberlistfull.csv"; attachment 179145 is "memberlist.csv". Therefore settings for User1 ("organization") and User2 (Address2) are not possible It's not possible to "open the database maintenance page found at https://chippewacountyshootingassociation.com/db/index.php and click on 'Download membership report'. When the download page loads, click on 'Download Membership File'." So I failed to follow your instructions, but pershaps it's only, because I'm not very familiar with databases. Perhaps somebody else can help. 11. Click OK. 12. Make sure the Address book data source is “Addresses”. If the data source is named anything else, you’ll need to remove the data source (see the section called “Remove a data source”) Click on Finish. If asked, choose Yes to overwrite the existing file. To print cards, letters, and envelopes: 1. Open your downloads folder and delete the “memberlistfull.csv” file if it exists. 2. Open the database maintenance page found at https://chippewacountyshootingassociation.com/db/index.php and click on “Download membership report”. When the download page loads, click on “Download Membership File”. You should download each time before printing to allow for updates to the database. 3. Open “memberlistfull.csv. Turn on ‘Autofilter’. Filter out records with ‘Date Paid’ =”0000-00-00”. Filter out records where ‘Date Printed’ does not equal “0000-00-00”. Copy all remaining records including column names. Open “memberlist.csv”. Clear out any records including the column headers. Paste into “memberlist.csv” the filtered records from “memberlistfull.csv”. Save as a csv format file. 4. Verify the database has been updated to reflect all printed records by reviewing the “Active Members” list on the website and comparing it to the “memberlist.csv” file. If the spreadsheet has records that show as unprinted on the “Active Members” list, update the database and return to step 1 in this section. 5. Open “memberlist.csv” and delete all existing records including the column heading row. 6. Paste the filtered records (including the column heading row) into “memberlist.csv”. 7. Close “memberlistfull.csv”. 8. Save “memberlist.csv” and overwrite the existing file if asked. 9. Open the file for the material you want to print: “card front.odt” will print data from the membership.csv file. Prints 10 at a time. “card back.odt” to print the backs of all cards. Also prints 10 at a time. “member letter.odt” to print membership letters. “envelope.odt” to print envelopes. 10. If needed, update any text on the card or letter you opened in Writer. When updating the card, make the changes on the upper left card only. When complete, click on “Synchronize labels” in the small window. The changes will be pushed to the remaining cards. Avoid making changes that affect the layout of the card format since that may cause the cards to print improperly. 11. If you don’t have 10 records in the “membership.csv” file, there will be cards printed without member information listed. These can be saved and used when one or two memberships are being prepared. The following steps are the same regardless of the materials being printed: 1. Click on File, Print. Click on Yes when asked about printing a form letter. 2. In the Mail Merge dialog, make sure the recordset displayed is the correct one. If there are no records shown, try clicking on the memberlist table in the left pane. Click OK. 3. On occasion, the data source may not be found. In this situation, close and reopen Writer and start from step 7. In rare cases you will need to reestablish the data connection. Section 1 has instructions. 4. The Print dialog will open. 5. Choose the printer, click on Print and away you go. If you need to remove a data source: 1. In Writer, click on Tools, Options. 2. Expand LibreOffice Base and select Databases. 3. Select the data source you want to remove and click on Delete. -- You are receiving this mail because: You are the assignee for the bug.
