Category : Lotus and other Spreadsheets
Archive   : 123RFLX.ZIP
Filename : LOTUS.EXP

 
Output of file : LOTUS.EXP contained in archive : 123RFLX.ZIP

EXPORTING REFLEX DATA INTO LOTUS 1-2-3 OR SYMPHONY


1. Run REFLEX2.

2. Choose REPORT.

3. Retrieve the REFLEX file that you want to export.

4. Create a Report Design with the following characteristics:

A. Every Reflex field that you want exported to Lotus must
be placed side-by-side on the first row of the Report
Design.

B. Leave a blank space between each Reflex field in the
Report Design.

5. If you have a Reflex field that has a DATE type and you want
the date field to be a LOTUS Date field then enter the
following formula in your Report Design where you would
normally enter the Reflex Date field.

[email protected](@DNULL, DATE) + 1

Where 'DATE' is the name of your date field in your REFLEX
database. This converts your Reflex date into a Julian
number which is subsequently used by Lotus.

6. Choose VARIABLE WIDTH from the ATTRIBUTE Menu.

7. Select each item on your single row Report Design, press F10
and choose WIDE AS NEEDED.

8. Choose FORMAT from the ATTRIBUTE Menu.

9. Select each Numeric or Integer field on your single row
Report Design, press F10 and choose General as the Display
Format.

10. Choose EXPORT from the ATTRIBUTE Menu.

11. Select each TEXT or REPEATING TEXT item on your Report
Design, press F10 and choose QUOTES.

12. Choose Change Printer Settings from the Print/File Menu and
set the following parameters:

Output: To Disk File
Left Margin: 0
Right Margin: 254
Top/Bottom Margin: 0
Print With Page Breaks: No



13. Select the cell next to the 'To Disk File' check box and
enter a file name. This will be the file that you import
into Lotus.

14. Select the PRINT box.

15. Exit the Report View.

16. Exit REFLEX2 back to DOS.

17. Make sure the file you created in steps 1 through 14 above
is located in your default Lotus directory.

18. Run Lotus 1-2-3 or Symphony.

19. Choose the File Command. (If using Symphony, open the
Services Menu).

20. Choose the Import Command.

21. Choose the Numbers Command. (If using Symphony, choose the
Structured Command). Lotus will display a list of
all files in the default directory that have a .PRN file
name extension. The file you created using the Reflex
Report View should be listed. If the file is not listed you
will have to change the Lotus directory and try again.

22. Choose the file. Lotus will read the file into the
worksheet.

23. Format any Julian number columns into Lotus dates using the
Lotus Format command.

TRICKS/TRAPS

If you are exporting records that contain NULL (Blank) values in
a Numeric, Integer, or Date field you need to add the following
steps:

Do these steps BEFORE completing Steps 1 - 23 above:

1. Run Reflex. Retrieve the database that is going to be
exported.

2. Choose FIELD & SORT SETTINGS from the RECORDS Menu.

3. Select the Formula Cell for each Integer or Numeric field
and enter the following:

-32767

this will cause the number -32767 to display in all Reflex
records only where a null value had previously displayed.
Actually any number can be used. If you don't care about
the difference between the number 0 and a Null or non-
existent number, you can use 0 instead of -32767. This
number will serve as a place holder in your export file.


4. Select the Formula Cell for each Date field and enter the
following:

1/1/00

This will cause the date 1/1/00 (or January 1, 1900) to
display where a null date value displayed before.

5. Save your database to a temporary file name. You will use
this file in the Reflex Report View to create your export
file.

6. Follow steps 1- 23 above.

Do these steps after completing steps 1 - 23 above:

7. For each column of numbers that has one or more place holder
values you should delete the values.

8. For each column of dates that has one or more place holder
values you should delete the values.