Free Essay

How to Convert a File

In:

Submitted By cawright20
Words 414
Pages 2
OPERA HOTEL EDITION
“How To” Guides

HOW TO Convert a Report to Excel
A VISUAL REFERENCE GUIDE
Copyright © 2003 MICROS Systems, Inc. All Rights Reserved.

How to Convert a Report to Excel V2.45.33.01

1

OPERA HOTEL EDITION
“How To” Guides
HOW TO…

The “How To” Objective Is: This “How To” Demonstrates:
Step 1 – From the Reports menu, locate the report to convert and check the “Print to File” box at the bottom of the screen. A File Format selection will open. Select “Delimited Data”.

To provide the Opera PMS user with a reference tool that includes quick tips and visual instructions for performing various functions within the software. How to print a report to a tab delimited file, then import that file into an Excel spread sheet.

How to Convert a Report to Excel V2.45.33.01

2

OPERA HOTEL EDITION
“How To” Guides
Step 2 –. Leave the default delimiter set to “Tab” and press OK.

How to Convert a Report to Excel V2.45.33.01

3

OPERA HOTEL EDITION
“How To” Guides
Step 3 – Select “File” on the filter screen to create the file.

How to Convert a Report to Excel V2.45.33.01

4

OPERA HOTEL EDITION
“How To” Guides
Step 4 –. Save the file to your workstation.

Step 5 –.. Name the file appropriately and select “Save”.

How to Convert a Report to Excel V2.45.33.01

5

OPERA HOTEL EDITION
“How To” Guides
Step 6 –. Open Excel to a new worksheet. From the top of the menu, select “Data”, then “Get External Data” then “Import Text File”.

Step 7 –. Locate the file created in Opera and select “Import”.

How to Convert a Report to Excel V2.45.33.01

6

OPERA HOTEL EDITION
“How To” Guides
Step 8 –. The File Import Wizard will appear. Be sure Delimited is selected at the top of the screen. Click “Next” to continue.

Step 9 –. Be sure that “Tab” is selected at the top and select “Next”.

How to Convert a Report to Excel V2.45.33.01

7

OPERA HOTEL EDITION
“How To” Guides
Step 10 – Each column can have a different data format if necessary. Once the data formats are entered select “Finish”.

Step11 –. Select to have the data imported to the current worksheet. This will be the default. Select OK.

Step 12 –. The data has been transferred to an Excel Spread Sheet.

How to Convert a Report to Excel V2.45.33.01

8

Similar Documents

Premium Essay

Model

...Create an ETD Using Adobe Acrobat Lesson 2: Create a PDF File Create a PDF File Now that you’ve seen what an ETD looks like and how to browse the contents, it’s time to learn how to convert your own thesis or dissertation into a PDF file. There are several different options for doing this, and all require that you have a copy of Adobe® Acrobat® Standard or Professional installed on your computer. Adobe Reader, which is freely available for downloading from many Internet sites, can only be used to read a PDF file. You cannot use it to create a PDF file. In this lesson, you will learn how to: 1. Create a PDF using PDFMaker from within Microsoft® Word 2. Create a PDF using the Print command 3. Combine multiple files Tip Exercise 1 and Exercise 2 produce the same result. Choose the one that works best for you. 1 Create an ETD Using Adobe Acrobat Lesson 2: Create a PDF File Exercise 1 – Create a PDF Using PDFMaker In this exercise, you will learn how to use PDFMaker to convert a Microsoft Word document to a PDF file. 1. Start Microsoft Word and open your thesis or dissertation. 2. Look at the toolbars at the top of the window. Notice there are two areas related to Acrobat PDFMaker: • The Adobe PDF and Acrobat Comment menus • The Acrobat icons Tip The Acrobat 7 installer scans your system for a copy of Microsoft Office 98 or later, and if found, automatically loads PDFMaker. This is the macro that allows you to create PDFs from Word as well as Excel and PowerPoint. If you...

Words: 967 - Pages: 4

Premium Essay

Nt1310 Unit 1 Use Case Diagram

...are use cases(upload files, attribute based key generation, secret key, master key, access data). How it works means, when the data owner wants to upload a file based on attributes in the form of encrypted data. Then only the file will be uploaded in the outsourced . and data consumer wants to access an outsourced file. The data consumer access some access policies then only he downloads the cipher text and it converts into a plaintext. Class diagram In the class diagram first the data owner wants to upload the file into the outsource decryption. The attributes of data owner are filename, file size, public key, secret key, master key the only the file will be uploaded in the cloud server. And the data owner consists of methods file upload(), file size(), key gen(),...

Words: 613 - Pages: 3

Free Essay

Bussiness

...com/tools/calculate/downloadcalculator.phphttp://luckylarry.co.uk/programming-tutorials/how-to-calculate-data-transfer-speeds/Formula: Transfer Time = File Size / Transfer Rate 1.For file size - > Convert all KBytes to bytes (x 1024) and then to bits (x 8) 1.e.g. 2GB = 2 * 1024 * 1024 * 1024 * 8 bits = 17,179,869,184 bits2.For transfer rate -> convert to bits ( x 1000) 1.E.g. 56 Kbps = 56 * 1000 bps = 56,000 bpsProblem: Calculate Transfer timeFile SizeTransfer RateTransfer Time2 GB56 Kbps?Solution:Formula: Transfer Time = File Size / Transfer Rate Step 1: Convert file size to bytes. (Multiply by 1024 to get to GB -> MB -> KB -> bytes). 2 GB x 1024 = 2048 MB= 2048 * 1024 = 2097152 KB= 2097152 * 1024 = 2147483648 bytesStep 2: Covert file size from bytes to bits. (Multiply by 8).2147483648 * 8 = 17,179,869,184 bitsYou can combine Steps 1 and 2 by doing it in one step: 2 * 1024 * 1024 * 1024 * 8 (will give file size in bits)Step 3: Covert transfer rate to bits per sec. (Multiply by 1000).56 Kbps * 1000 = 56,000 bpsStep 4: Divide Step 2 result by Step 3 result to get transfer time in seconds.17,179,869,184 / 56,000 = 306,783.3783 secondsStep 5: Convert Step 4 answer in seconds to minutes, hours, days etc.306,783.3783 seconds / 60 = 5113 minutes (Divide by 60 to convert secs to mins)= 5113 minutes / 60 = 85.22 hours (Divide by 60 to convert mins to hours)= 85.22 hours / 24 = 3.55 days (Divide by 24 to convert hours to days)Answer: Transfer time = 3.55 days...

Words: 282 - Pages: 2

Free Essay

Nt1430

...are unsure how to use linux commands, see our Linux Commands Tutorial. Click on the command name or the  to see a description of the command. Click on the  to see the man page for that command. Command | Description |   |   | adduser | Add a new user |   | | arch | Print machine architecture | | | awk | Find and Replace text within file(s) |   | | bc | An arbitrary precision calculator language |   | | cal | Display a calendar | | | cat | Concatenate files and print on the standard output | | | chdir | Change working directory | | | chgrp | Change the group ownership of files | | | chkconfig | Tool for maintaining the /etc/rc[0-6].d directory hierarchy |   | | chmod | Change the access permissions of files and directories |   | | chown | Change the user and group ownership of files | | | chroot | Change root directory |   | | cksum | Print CRC checksum and byte counts |   | | clear | Clear terminal screen |   | | cmp | Compare two files |   | | comm | Compare two sorted files line by line |   | | cp | Copy one or more files to another location |   | | cron | Daemon to execute scheduled commands |   | | crontab | Schedule a command to run at a later time |   | | csplit | Split a file into context-determined pieces |   | | cut | Divide a file into several parts |   | | date | Display or change the date & time |   | | dc | Desk Calculator |   | | dd | Data Dump - Convert and copy a file |   | | ...

Words: 924 - Pages: 4

Premium Essay

Eljerizen

...Analysis & Design Chapter 9: Data Design 1. Explain the main difference between a file processing system and a database system. Answer: File processing is the method by which a file-oriented system stores and managesdata.Today, file processing is less common than database systems, although in somecases, file processing is more efficient and cost-effective. Database systems provide aframework for storing data within a real-time, dynamic environment, without the risk ofdata redundancy. A database management system (DBMS) is a collection of tools,features, and interfaces that allows users to manage the contents of a database. Link: https://www.coursehero.com/file/7367193/CH9doc/?justUnlocked=1 2. What is a DBMS? Briefly describe the components of a DBMS. Answer: DBMS stands for Database Management System. A DBMS is a collection of tools,features, and interfaces that enable users to add, update, manage, access, and analyze thecontents of a database. A DBMS provides an interface between a database and the users,database administrators (DBAs), and the other information systems with which theDBMS interacts. In addition to interfaces, other DBMS components include a datamanipulation language, a schema, and a physical data repository. A data manipulationlanguage, or DML, controls the operations of the database. Link: https://www.coursehero.com/file/7367193/CH9doc/?justUnlocked=1 3. Describe a primary key, candidate key, secondary key, foreign key, and...

Words: 988 - Pages: 4

Free Essay

Aomei Partition

...AOMEI® Partition Assistant 5.1 AOMEI® Partition Assistant 5.1 User Manual Copyright © 2009-2012 AomeiTech. All rights reserved. 1 AOMEI® Partition Assistant 5.1 Welcome........................................................................................................................................3 About AOMEI Partition Assistant.....................................................................................3 Working Computer Configuration.....................................................................................4 Product Main Window ......................................................................................................5 Partition Operation Properties...........................................................................................5 Partition Operations ......................................................................................................................6 Resize and Move Partition ................................................................................................6 Merge Partitions ................................................................................................................7 Split Partition ....................................................................................................................7 Allocate Free Space...........................................................................................................8 Copy Partition .............................

Words: 8834 - Pages: 36

Premium Essay

Ggfyutiop Huu

...Nitro Pro 9 User Guide Nitro Pro 9 - User Guide In this User Guide Welcome to Nitro Pro 9 How to use this guide Quickly find the right information To Search For Keywords: Participate and Contribute Online Getting started with Nitro Pro 9 Explore the Nitro Pro 9 user interface A Tour of Nitro Pro 9 1 File Menu 2 Quick Access Toolbar 3 Ribbon Tabs 4 Information Bar 5 Document Pane 6 Zoom Controls and Page View 7 Paging Controls 8 Find Bar 9 Lower Navigation Panes 10 Sidebar Navigation Panes Ribbon shortcuts To view and use shortcut keys: Software Activation Common terms To purchase a Nitro Pro 9 license: To activate Nitro Pro 9: Automatic, or online, activation: Manual, or offline, activation: Compatibility with other applications Tasks and tools View and navigate a PDF file Open a PDF file Open a PDF file The File Menu Drag-and-drop Double-click or right-click Change the page view To change the page display options: To resize the page view: To rotate the page view: Adjust the zoom level To use the Zoom tool: To adjust the zoom level with Page Controls: Page through the document Step through the pages To scroll smoothly between pages: Navigation Panes The Pages Pane 1 1 1 1 1 2 3 3 3 3 4 4 4 4 4 4 4 4 6 6 7 7 7 7 7 7 9 10 11 12 12 12 12 12 13 13 13 14 15 15 15 16 16 16 17 17 i ©Nitro Nitro Pro 9 - User Guide The Bookmarks Pane The Signatures Pane The Layers Pane The Layers Pane To view the Layers pane: To show or hide an OCG layer: To reset a layer to its default...

Words: 39212 - Pages: 157

Premium Essay

Grandma House

...ADOBE® READER® XI Help and tutorials Reader Help Print PDFs Print button missing? Common printing tasks Why can’t I print my document? Simulate overprinting of inks Print button missing? To the top If you can't see the Print and Cancel buttons, your monitor is set to a low screen resolution. Reader wasn't designed for low-resolution displays (the minimum recommended is 1024 x 576). However, you can work around this limitation. Do any of the following to print your document: Press Enter or Return. If a scroll bar appears on the right of the dialog box, drag the slider down to access the buttons. (Windows) On some monitors, the Windows taskbar covers the Print button. You can hide the taskbar so it appears only when you mouse to the very bottom of the screen. Right-click the taskbar and choose Properties. In the Properties dialog box, select Auto-hide the Taskbar, then click OK. Set the Taskbar properties to hide the taskbar so you can select the Print button Common printing tasks Print on both sides To the top You can print double-sided if your printer supports that feature. The printer driver controls the options, not Adobe Acrobat or Adobe Reader. Check your printer documentation to see what features your printer supports. (Double-sided printing is also called duplex, back to back, front and back, or two-sided printing.) In the Print dialog box, enable Print on both sides of paper, and choose an edge to Flip. Print in black and white ...

Words: 7329 - Pages: 30

Free Essay

Unit 1 Excercise 1

...Lab 1.1 review 1.Convert the decimal value 127 to binary. Explain the process of conversion that you used. 64 32 16 8 4 2 1 1 1 1 1 1 1 1 127-64= 63-32=31-16=15-8=7-4=3-2=1-1=0 127=1111111 2. Explain why the values 102 and 00102 are equivalent. The values are equivalent because it’s de same numerical meaning. Everything else after the one is a zero and there is no need to show the zero. 3. Based on the breakdown of the decimal and binary systems in this lab, describe the available digit values and the first four digits of a base 5 numbering system. You can use the binary system as a reference, where the available digit values are 0 and 1 and the first four digits are 1, 2, 4, and 8. In base 5, we use only 5 digits 0, 1, 2, 3 , and 4. The first four digits would be 1, 5, 25, and 125 4-Using the Internet and the Help files in Excel, explain why creating a converter from decimal to binary would be more difficult to construct. Hint: you should consider the conditional evalua- tion of whether the decimal value remaining is larger than the binary digit value. There are many converters already build into to excel itself. =DEC2BIN (9, 4) is a decimal to binary converter for the number 9 and it will show 4 places. If you leave the 4 out of the parentheses and it will only give you the places necessary to give you the number LAB 1.2) review 1. Determine the result of 100100002 + 11011102. Show the...

Words: 1606 - Pages: 7

Free Essay

Chapter Review

...End of Chapter Review and Programming Exercises 10212010 LIST OF REVIEW AND PROGRAMMING EXERCISES PER CHAPTER CHAPTER 1: ASSIGNED REVIEW AND PROGRAMMING EXERCISES Please complete these end of chapter review and programming exercises. They were selected because they are relevant to the competencies you must develop to complete the performance assessment. Complete R1.6, R1.7, R1.11, R1.13, R1.14, R1.18. Complete P1.1, P1.8, P1.10 CHAPTER 2: ASSIGNED REVIEW AND PROGRAMMING EXERCISES Please complete these end of chapter review and programming exercises. They were selected because they are relevant to the competencies you must develop to complete the performance assessment. Complete R2.1, R2.3, R2.4, R2.9, R.2.14, R.2.15 Complete P2.1, P2.2, P2.4, P2.5, P2.8, P2.9, P2.12, P2.13, P2.14, P2.19 CHAPTER 3: ASSIGNED REVIEW AND PROGRAMMING EXERCISES Please complete the following end of chapter review and programming exercises. They were selected because they are relevant to the competencies you must develop to complete the performance assessment. Complete R3.2, R3.3, R3.4, R3.7, R3.8, R3.9, R3.10, R3.11, R3.13, R3.18, R.3.21 Complete P3.1, P3.2, P3.3, P3.4, P3.5, P3.6, P3.9, P3.10, P3.12, P3.14, P.3.17, P3.23, P3.25 End of Chapter Review and Programming Exercises 10212010 CHAPTER 4: ASSIGNED REVIEW AND PROGRAMMING EXERCISES Please complete the following end of chapter review and programming exercises. They were selected because they are relevant to the competencies...

Words: 1463 - Pages: 6

Premium Essay

South Africa

...When you open a document in Word 2013, the ribbon’s Home tab is displayed. This tab contains many of the most frequently used commands in Word. Manage your files Click File to open, save, print, and manage your Word files. Need help? Click here or press F1 for help. Navigation pane Press Ctrl+F to show the Navigation Pane. You can reorganize a document by dragging its headings in this pane. Or use the search box to find your way around long documents. Press Ctrl+H to open the Find and Replace dialog box. Word count Look here to see the word count. Select some text to see the word count in the selection. Contextual ribbon tabs Some tabs appear on the ribbon only when you need them. For example, if you select a table, you’ll see Table Tools, which includes two extra tabs — Design and Layout. Dialog box launchers If you see this icon next to any group of ribbon commands, you can click it to see a box with more options. Minimize the ribbon Click here to close the ribbon and show only the tab names. Switch views Switch to Read view, Print view, or Web view. Zoom in or out Move the slider to adjust the view magnification. Quick Start Guide When you first open Word 2013, you’ll see that you have several choices for getting started — using a template, a recent file, or a blank document. Search for online templates Type keywords into the search box to find templates online at Office.com. Suggested searches Click...

Words: 1284 - Pages: 6

Free Essay

Analyst

...PHP PHP code can be included alone inside a file or can be embedded inside the html code and runs on webserver. The PHP files have extension of .php. The PHP code syntax is: <?php ‘code goes here’ ?> We have to use semi colon at the end of each command/line. If we only have php code in a file, then we need to make sure that there is no space before the opening php tags or after the closing php tag. If the file extension is .php then we can only view that file through web browser where php is installed even if the file does not have any php code. On our local servers we need to store the files in the root folder, which for WAMP is C:\wamp\www. We also need to make sure that the local server is running. The local port is 80, if we are using a different port than standard then we need to specify that e.g. http://localhost:8888/. We can have as many blocks of php codes inside html as we want. However, we cant nest one php code inside another. We can also insert php code above the html code and that works perfectly fine. The php code directly works with the database so if we are not outputting anything in html the code above html code works just fine. . Period: Period is used to concatenate two strings. Variable: In PHP all variable name start with ‘$’ sign e.g. $name = ‘Ali’;. Remember ‘$this’ is a reserved variable so don’t use this. Some people use parenthesis around variable but it is completely optional to use. String: The php string works the same way...

Words: 5458 - Pages: 22

Premium Essay

Related Literature

...SOFTWARE AND SYSTEMS PROGRAMMING INTRODUCTION: SOFTWARE is defined as a program or set of instruction that tells the computer what to do. TWO CLASSES OF SOFTWARE: 1. SYSTEM SOFTWARE – these programs are used to manipulate the basic operations of a computer system. Examples of these basic operations are: ▪ System software tells the computer to accept the input from the keyboard and output the character to the monitor. ▪ System software locates free disk space in a hard disk when a file needs to be saved. ▪ System software sends the document to the printer when it needs to be printed. ▪ System software locates a program in the hard disk, loads it in the main memory, and executes it. SOME OF THE BENEFITS OF SYSTEM SOFTWARE ARE: ▪ They hide the “ugly” details of computer operations from the user. ▪ Computer programmer can write programs without knowing the details on how the computer hardware works. ▪ System software such as an operating system controls the execution of programs. System software supports all application programs. For example, a user using an application program such as Microsoft Word clicks on the save icon to tell Word to save a document. In this process, Word does not communicate with the printer, but rather request the operating system to print the document. A block diagram of this process is illustrated in the figure. Examples of...

Words: 1565 - Pages: 7

Premium Essay

Rayban

...of Form Looking for mobile apps?Go to AppCrawlr * * * free microsoft word document(368 programs) SOFTONIC ADS * Find Bandwidth Bottlenecks! Download a FREE Trial of SolarWinds Bandwidth Analyzer Pack Create your ad FILTER BY: License * All (368) * Only free (88) Language Operating system Advertisement Sort by: Relevance Sponsored links * Download Office Plus Last Version Available Free. Download Office Plus Here!  www.officeplus.es/en * About Microsoft Word Search multiple engines for about microsoft word  www.Webcrawler.com * Times Of India News Get Latest updates on News Online. Best News Site. View Now!  timesofindia.indiatimes.com 1. SPONSORED REACHit Access all the files on your PCs and mobile devices from anywhere – all in one free app. Free English 22,338 Total downloads - Softonic rating 8.9 User rating * Download 2. SPONSORED 1stBrowser Customize your browsing experience and quickly download and share media from around the web Free English 393,855 Total downloads - Softonic rating 6.4 User rating * Visit website 3. Microsoft Office 201315.0.4763.1002 Free 30-day trial of Microsoft Office 2013 Professional Plus....documents easier Microsoft ... Productivity Suites Trial version English 14,330,708 Total downloads 8 Softonic rating 6.2 User rating * Download * Buy now 4. Office 2016 16.0.4229.1004 Microsoft is modernizing their office...

Words: 1139 - Pages: 5

Free Essay

Chapter 7 Solutions

...Review Questions 1. You have just installed a new disk on a Windows Server 2008 server. Which of the following do you do first to prepare the disk for use? Answer: a. partition the disk 2. The _____ partition or volume contains the operating system files, such as the files in the \Windows folder. Answer: boot 3. You have just upgraded from Windows Server 2003 to Windows Server 2008. Now you are trying to recover a set of databases that you backed up on DVDs in Windows Server 2003 before you started the upgrade, but the Windows Server Backup tool gives you an error message. What is the problem? Answer: c. The Windows Server Backup tool is not compatible with backups made from the Windows Server 2003 Backup tool. 4. Your company is considering installing an iSCSI SAN, but one of the department heads mentions that he has heard Windows Server 2008 does not have a management tool for an iSCSI SAN. What is your response? Answer: d. This is not true because you can install Storage Manager for SANs. 5. You are consulting for a company that has been performing full backups every night for its Windows Server 2008 servers. A problem they have been experiencing is that the backups are taking longer and longer. What is your recommendation for this company? Answer: b. Use a custom backup that enables you to use a combination of full and incremental backups. 6. Dynamic disks support RAID levels _____, _____...

Words: 2918 - Pages: 12