| |
| Utility Pull-Down Basic Options |
| |
| Contents |
|
|
|
| Reindex Files Section |
| |
| Access Menu: (start form
Main Menu Screen) |
|
|
| Purpose: Most all database files
used in this system have index files associated with them. These index
files maintains all the sort keys for each data file. Ex: the
customer file has three sort keys, Account Number, Company Name and Phone
Number. Under normal system operations, these files are maintained without
user intervention. But sometimes it may be useful to execute this
procedure. |
| When: |
-
When you Delete customers,
inventory items or vendors. This system will only mark these records as
deleted so they may be recalled. (they are physically still within the
database) They cannot be accessed during order entry because they are
deleted, but can be recalled using the file maintenance procedure of
that particular record.
-
Warning:
When you run this procedure; all deleted records are
physically removed from the database files and cannot be
recalled.
-
If you're getting "out-of-range" errors,
running this procedure will most likely clear the problem.
|
 |
| |
| Options: |
| Rebuild Current
Files only |
-
ON - default, to rebuild current
files only, current period files.
-
OFF - skip the current files.
- Note:
the customer, inventory and vendor files are within this option.
(current files)
|
| Rebuild History
Files only |
-
ON - default, to rebuild history
files only, non-current period files.
-
OFF - skip the history files.
- Note:
the history files are only updated during the Close Period
process.
|
|
| Command Buttons |
| Go
select this to start the re-index procedure. |
- Note:
For Network users it's necessary for all other users to log off
before continuing.
|
|
 |
-
Continue make sure all other users are logged off
and select this to continue.
- Note:
the system will verify that no other users are still working in
ProFrame. If so; it will not allow you to continue.
learn more on how to
clear flags....
- Cancel
select this to cancel this operation.
|
|
Cancel select this to
cancel this process and return to main menu. |
| |
| After starting this
process, the system will indicate the progress as shown below.
|
 |
| Press ESC key
when completed. |
|
Note:
after 5 to 10 seconds the system will automatically return to main
menu. |
|
|
 |
|
| Command Line Section |
| |
| Access Menu: (start form
Main Menu Screen) |
|
|
| Purpose: ProFrame is developed in
Visual FoxPro and uses FoxPro Database file structures as the main data
source. Each database can be opened in a raw mode using FoxPro commands.
This utility is designed for support purposes and is not recommended for
non-experienced FoxPro users. We usually walk our clients through this
utility for troubleshooting account issues and any other data related
issue. This utility also allows us to perform special things that could
save you and your company lots of time. Ex: we could open the
customer file and replace all salesman with 'ABC' for zip code = '35146'.
We do have clients that are well versed in FoxPro who could perform the
same thing. But most of our clients are not up-to-speed on FoxPro and
choose to leave that to us. It can be a dangerous place for
non-experienced FoxPro users. |
| When: |
-
When instructed to by EasyBee Software
support staff.
-
Warning:
When you open a database; it's opened in raw mode and requires
exclusive access of the system, all others should log off.
-
Warning:
Raw Mode.. No verification, It's live, No Undo, etc... etc... etc...
|
 |
| |
| Sample: |
| To open the
Customer File |
-
Type use pfcust01
enter
- Note:
assuming your company number is 01
- Type browse
enter
|
 |
| |
|
Notes: |
- Again this utility is designed
for support issues and troubleshooting. As you can see it's a very
powerful utility that has served us well over the years.
- We will not try to document
Visual FoxPro commands here, to learn more about FoxPro please see
http://msdn.microsoft.com/vfoxpro
- This product is developed in
Visual FoxPro 8.
|
|
| Navigation |
| To
Exit press the ESC
key |
|
|
|
|
| Item Catalog Change
Section |
| |
| Access Menu: (start form
Main Menu Screen) |
-
Utility
-
Item Catalog Change
|
| Purpose: This utility allows user
to change any catalog assignment from one to another globally. |
| |
| When: |
|
|
 |
| |
| Options: |
| Target Section |
-
Select the Catalog to be replaced.
-
Note:
this selection will be overwritten by Source selection.
|
| Source Section |
-
Select the Catalog replacement. (Source)
-
Note:
the target is replaced by this selection.
|
| What's updated? |
-
Any and all items in which the Target
Catalog matches.
-
Is replaced with the Source Catalog
selection.
|
-
Warning: This cannot be undone...
|
|
| Commands |
|
Update
select this to start the catalog replacement. |
- Note:
you will be given another opportunity to continue or cancel.
|
|
Quit select this to
cancel this process and return to main menu. |
|
|
|
|
