: This tech note is
applicable only to users of CAFAM for WINDOWS ONLY
are frequently asked as to “how do I Export CAFAM data to
Excel”. This Tech Note sets
out the steps to do this.
Ensure your default home Folder has been defined.
Nearly everyone here uses “My
Documents” as their
Check within Win Explorer or My Computer that such a Folder
is visible and is at the root level.
In CAFAM, go to UTILITIES > AMEND USER PASSWORD > AMEND
PREVIOUS ONE and type in the above folder path e.g.
would indicate C: drive and
MY DOCUMENTS folder at the root level.
create a folder called CAFAMDBF in the Root directory and use this
as your folder to store CAFAM generated files.
Whenever you generate a Report, you are prompted for
“DBF” file as one of the options.
Use this output and CAFAM will create the prompted file name
in the above folder.
From Excel, open the file created by changing the “File of
Type” prompt to read “dbase files” (Type III).
usual problem encountered in step 4 is that the file does not appear
to be visible.
This is probably because the default Folder set for your
version of Excel is not the same as that where CAFAM has written the
file It is not unusual where some Users have been known to have more
than one “My Documents” folder located in a different tree off
C: (or even D: drive).
Check in the “Look in” prompt in Excel when opening the
file that the folder is the same as the one you established in step
1 & 2.