On the Confirm window, click Proceed to start the data export.Click Next when your settings are complete. If you do not wish to include a TimeStamp Pattern, simply erase the settings in this field. If you want a timestamp automatically appended to the filename in your output, include the TimeStamp pattern you prefer (yyyyMMddHH) in the TimeStamp pattern field.In the File name pattern field, enter a filename for the report you are running.If you would like to know more about why you could not find One Drive, please contact CUL Desktop Services. The Directory field should populate with this path. If you do not have a One Drive - Cornell University folder, choose your Desktop folder instead, and continue to follow the set of instructions below for using the Share feature to send yourself the file. On Output Settings, click the orange folder icon and navigate to your C:\Users\\OneDrive - Cornell University\Desktop folder.Right-click on any part of the results set shown in the bottom right side of the window and choose Export data.You can export your query results to CSV if you would like to use them in Excel. sql extension, such as "loans_and_renewals_counts_olin.sql" Right-click on the name of the default script (here, the name is "Script-1"), then choose Rename File.To show results for just the Olin library location, go to the SELECT statement under WITH and enter Olin in the single quote marks next to items_effective_location_filter.To show results for the period of 6/1/21 through 6/15/21, go to the SELECT statement under WITH and enter those start and end dates within the single quote marks.In the SELECT statement under WITH, look for the start and end date parameters to set the date.Return to the query in your Virtual DBeaver window.Follow steps above to Select the Report Query to Run, and choose the CR100 query. Here is an example of setting date and location filters in the CR100 loans_and_renewals_counts query. Just above your query, make sure the ldp_cornell data source has been selected.Continue adjusting your filters as needed using the same approach.Run your query and review the results in the bottom half of the window.In the SELECT statement under WITH, enter filters within the single quote marks.Look for the WITH statement near the beginning of the query.Return to the query in your Virtual DBeaver window.Review your results in the bottom half of your windowįilters allow you to refine your query to give you results that are limited by certain criteria, such as location.From the SQL Editor menu, choose Execute SQL Script to run your query.From the File menu, select Save to save this query in DBeaver with a filename and the ".sql" file extension.Click Ctrl+V to paste the text of the query into the New SQL script window.Click Ctrl+A then Ctrl+C to select and copy all the text of the query.Click Raw in the top right corner of the window.Click the query code link (e.g., CR100).To select the report query you would like to run, go to the FOLIO Canned Reports Directory. From the SQL Editor menu, choose New SQL script.If this is your first time connecting, please follow the instructions to " Configure Your Connection to the Reporting Database in Virtual DBeaver." Click the DBeaver shortcut on the desktop to open DBeaver.At the "Enter your credentials" prompt, enter your full Cornell email address in the Username field and your email password in the Password field, then click Submit.At the "Access local resources" prompt, click Allow.Open a web browser window and go to the Virtual DBeaver URL.Also, the Chrome web browser works best with Virtual DBeaver on Windows, and the Safari web browser works best on Macs. If you experience this, it may help to log out of Virtual DBeaver, clear the cache in your web browser, and log back in. Users have been reporting problems with the copy and paste functions in their web browsers.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |