V103_110C_E Update Procedures
(Estimated time 3-4 hours)
Files needed: Files Found on CD in:
C:\res\3500\update: 3500\sql – copy and rename hotel.db
Newhotel.db
C:\res\3500\bin: 3500\bin
3500D.exe
BinUpdate.exe
CCconvert.exe
Commif.exe
dbMaintenance.exe
LoadV10x_110C_E.sql
PCWSAPIHandler.dll
PMS3500.cnt
PMS3500.exe
PMS3500.hlp
PMSBegin.exe
Pserver.exe
Pserver.reg
PwSecurity.dll
Qaddress.ini
Qarapea.dll
Qastrt.all
Quip.exe
RLog3500.exe
RMonitor.dll
RMonitor.exe
Rmtshare.exe
runBackup.exe
rundbms.exe
RunSql.dll
RunTranBackup.exe
Security.sql
UnloadV10x_110C_E.sql
Update10x_110C_E.bat
Version10x_110C_E.sql
C:\res\3500\notes: 3500\notes
3500icon.gif
additauth.gif
auth1.gif
auth2.gif
auth3.gif
auth4.gif
auth5.gif
auth6.gif
cctypesetup.gif
devicecfg.gif
global.gif
Locationinfo.gif
Pserver.gif
Readme_1.css
Readme_1.html
Readme_1-1.gif
Readme_1-10.gif
Readme_1-11.gif
Readme_1-12.gif
Readme_1-13.gif
Readme_1-14.gif
Readme_1-16.gif
Readme_1-17.gif
Readme_1-19.gif
Readme_1-2.gif
Readme_1-20.gif
Readme_1-21.gif
Readme_1-22.gif
Readme_1-23.gif
Readme_1-24.gif
Readme_1-25.gif
Readme_1-26.gif
Readme_1-3.gif
Readme_1-31.gif
Readme_1-33.gif
Readme_1-34.gif
Readme_1-36.gif
Readme_1-37.gif
Readme_1-38.gif
Readme_1-39.gif
Readme_1-4.gif
Readme_1-40.gif
Readme_1-41.gif
Readme_1-42.gif
Readme_1-5.gif
Readme_1-6.gif
Readme_1-8.gif
Readme_1-9.gif
Staffmsg.gif
Staffmsgguest,gif
C:\res\3500\Reports: Reports
ARInvoice.Doc
Folio1.Doc
Folio1Intl.Doc
LTRFolio1.Doc
LTRFolio1Intl.Doc
ARInvoiceDate.txt
FolioHdr.txt
FolioData1.txt
C:\res\3500\Default Docs: Reports
ARInvoiceHdr.txt
ARInvoiceData.txt
ARStatementHdr.txt
ARStatementData.txt
ConfirmationHdr.txt
ConfirmationData.txt
FolioHdr.txt
FolioData1.txt
GroupConfirmationHdr.txt
GroupConfirmationData.txt
HouseFolioHdr.txt
HouseFolioData.txt
PackageFolio.Doc
PackageHdr.txt
PackageData.txt
RegistrationHdr.txt
RegistrationData.txt
RegistrationBatchData.txt
TestHdr.txt
TestData.txt
TestLines.txt
C:\res\3500\DataSource:
Copy all files from C:\res\3500\Default Docs
Performing the update:
1. Write down the software key entries.
2. Make a backup copy of the C:\res\3500\bin folder.
3. Make a backup copy of the C:\res\3500\DefaultDocs folder.
4. Shut down Commif and Pserver.
5. Disconnect the database.
6. Close the resource monitor.
7. Stop 3500d.
8. Copy the files into the directories as indicated above.
9. Run the Update10x_110C_E.bat file. Follow the instructions on the screen.
10. Restart the application (Remember to reboot after the update batch file has completed)
11. Copy the site’s header on Folio1.Doc or Folio1Intl.Doc to the header of all of the folio files copied into
C:\res\3500\reports above. If the site has done a lot of customizing to the folio, it may be easier to copy
the macro from the new document to the old document. If copying the macro, make sure that the entire
macro is copied. The cursor does not default to the first line of the macro when it is opened for editing.
12. Copy the site’s header on ARInvoice.Doc to the header of all of the ARInvoice.Doc copied into
C:\res\3500\reports above.
13. Copy all of the files from C:\res\3500\DefaultDocs to C:\res\3500\DataSource.
14. Copy *.Doc files from C:\res\3500\Reports to C:\res\3500\DataSource.
15. Redefine the data and header sources for each Word document in C:\res\3500\DataSource. Remember
to remove the read only status of the documents. (Note: For the LTRFolio1.Doc and
LTRFolio1Intl.Doc, use the FolioData1.txt and FolioHdr.txt files while doing the steps below.)
a. Open C:\res\3500\data source\ARInvoice.Doc.
b. Select Enable Macros
c. Select Tools
d. Select Mail Merge
e. Select Get Data
f. Select Open Data Source
g. Change the ‘Look In’ folder to C\res\3500\DataSource
h. Change ‘Files of Type’ option to ‘Text Files’.
i. Select (highlight) the ARInvoiceData.txt file.
j. Select the ‘Select Method’ check box.
k. Select the Open button.
l. Change the Field Delimiter from Tab to a ‘,’. Not all documents will ask to have the delimiter
defined. If the system does not ask to have the delimiter redefined, go to step ‘n’.
m. Select OK
n. Select Get Data.
o. Select Header Options
Select Open
p.
Change the ‘Look In’ folder to C\res\3500\DataSource
q.
Change ‘Files of Type’ option to ‘Text Files’.
r.
Select (highlight) the ARInvoiceHdr.txt file.
s.
Select the ‘Select Method’ check box.
t.
Select the Open button
u.
Change the Field Delimiter from Tab to a ‘,’.
v.
Select OK
w.
Repeat this for each of the word documents. Note: This does not need to be done for Folio2 or
x.
Folio3.
16. Change the merge fields on each of the documents that refer to Zip or ZipCode to PostalCode.
a. Change the *hdr.txt files
1) Open the hdr.txt file.
2) Find the ‘Zip’ or ‘Zip Code’ field.
3) Change the ‘Zip’ or Zip Code field to ‘Postal Code’. Note: The if there is any description
preceding the zipcode – ie. Groupzipcode – postal code must have the same preceding
description. Make sure the new format matches the old format – ie. One word.
4) Save the change to the document.
5) Close the document.
6) Repeat for all hdr.txt files. Note: There is no zip code field on the packagehdr.txt
b. Change the *.doc files that are printing the zip or postal code.
1) Open the doc file.
2) Select the ‘Enable Macro’ option.
3) Select the > icon on the toolbar so that the merge fields are displayed. Note: Each
merge field is denoted by the > around the name of the merge field. For example, the
merge field for ‘name’ would be >.
4) Highlight the ‘>’ or ‘>’ merge field.
5) Press the ‘Delete’ key. This will delete the merge field and leave the cursor at the beginning
of the cell in the table.
6) Select the ‘Insert Merge Field’ option on the toolbar.
7) Select the ‘PostalCode’ option.
8) Save the document.
9) Close the document.
10) Repeat for each document that is printing the postal code.
17. Remove the hard coded ‘\#0.00’ from the rate merge field each of the folio.doc files.
a. Open folio the folio.doc files
b. Press Alt-F9.
c. Delete the ‘\#0.00’ from the field.
d. Save the changes to the document
e. Close the document
f. Repeat for each word doc that includes the rate in the header (folio1-3, confirmation, etc).
Note: Remember that there are two reg cards on the BatchRegCard.Doc that need to be changed in
steps 16 and 17.
18. Copy all of the files to from C:\res\3500\DataSource to C:\res\3500\DefaultDocs.
19. Delete the C:\res\3500\DataSource folder.
20. Delete all of the files and subfolders in C:\res\3500\Reports. Do not delete the Reports folder.
21. Restart the application.
22. Log in as the installer.
23. Re-enter the software key codes if necessary.
24. Redefine the network
a. Select the Setups module from the Main Menu.
b. Select the Installer Only button.
c. Select the Network button.
d. Select the server from the grid.
e. Select OK
f. Select the Configure System button.
g. Select OK
h. Select Close
i. Select OK
25. Reconfigure the Print Server
a. Select the Printer Setup button.
b. Select Yes
c. Create the printer text files
1) Select the workstation
2) Select the printer
3) Select the appropriate document options
4) Repeat for each of the workstations
d. Select the Load Documents button.
e. Select the Copy Documents button.
f. Select Yes to reload the documents
g. Select No to ‘Were there any errors’ prompt (if appropriate).
h. Select Yes to save documents.
26. Restart the PC. The print server should start Word and print a sample folio automatically.
27. Restart the application.
28. Log in to the system as installer.
29. Verify that the payment codes in the Payment/Currencies option match those in the Credit Card Type
option. If the two sets of codes do not match, new codes must be created for each of the existing ranges
of the mismatched credit card codes in Setup\Installer\Credit Card Setup.
30. Test printing each of the different documents from each workstation.
31. Configure the room types for negotiated group rates:
a. Restart the application.
b. Go to the Groups module.
c. Retrieve one of the groups that have a negotiated rate.
d. Select the Address/Rates tab.
e. Select the Rates button on the bottom of the screen. The system will prompt ‘Creating negotiated
rates for groups. This will take some time. Please be patient'.
Once this prompt is acknowledged, the system will process for several minutes. The process may take up to
25 minutes. The users can be in the system doing checkins, posting, etc while this is processing. This
process will define all of the room types as eligible for the negotiated rate for groups. It will not effect the
room blocs on groups. Also, the date ranges will default to being valid for two years from the system date
rather than only the group stay dates.