Dbeaver import csv4/11/2023 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. 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 |