Organizer Advantage is powerful yet easy to use database manager for Windows.
Advantage Designer lets you modify our solutions or easily create new databases.
Take control of your data with our simple or buinsess database software solutions.


 |  Organizer Advantage HowTo/Help  |  Designer HowTo/Help  | 


Advantage Help > Add Data > How To > How to use paste from clipboard?


How to use paste from clipboard?

In this help topic you will learn:

  • how to copy the content of the webpage and paste it into Organizer Advantage.
  • how to use short commands: CTRL + C (copy text), CTRL + V (paste text), CTRL + A (select all).
  • how to build the script that will paste your formatted data into your Organizer Advantage solution.

Open the Library of Congress web page. Execute the search by title, ISBN number, or author. Display the webpage with the item details. To select the content of the webpage use Ctrl + A short cut command or display popup menu and choose Select All.

Use CTRL+A to select the text in the web search result (Library Of Congress)

copy and paste data from the web search result into your data table, book catalog sample, select search result

Copy the selected content into the Windows clipboard. To review how the text content is stored in the Windows clipboard you can paste it into the Windows Notepad. In Notepad use CTRL+V shortcut or select Paste from the popup menu commands. Different browsers don't always copy and paste the webpage content in the same way.

Review the results in Windows Notepad, use CTRL+V or select Paste from the popup menu. Below is the result from Google Chrome browser.

copy and paste data from the web search result into your data table, book catalog sample, review text in notepad

Review the results in Windows Notepad, use CTRL+V or select Paste from the popup menu. Below is the result from Internet Explorer browser.

copy and paste data from the web search result into your data table, book catalog sample, review text in notepad, 2nd result

Open Organizer Advantage and click New. right clicking on the record form opens a popup menu (1), choose Paste Into Record From Clipboard (2).

copy and paste data from the web search result into your data table, book catalog sample, start advantage

To create a template file enter a new file name into the Template File box (1) (use txt extension). Click the Save & Review button (2).

copy and paste data from the web search result into your data table, book catalog sample, enter template name, save file

Choose command in the Template Commands box (1) and click on the Include button (2) to list the command in the Template box (3). Delete text and field name from commands and replace with real values (field names from the table and text from clipboard). Choose a field name from the popup menu or type it in. To save changes and review the result click the Save & Review button (4). Review how the template script processes the clipboard content (5). The review box lists the field name and the value.

copy and paste data from the web search result into your data table, book catalog sample, hot to enter parsing and transfer commands

The first part of the script includes:
FIND:"Personal Name"
SKIP-LINE:
COPY:AUTHOR:"":NEW-LINE

To create this:
1. Select FIND in Template Commands, click Include, replace Text with Personal name
2. Select SKIP-LINE in Template Commands, click Include.
3. Select COPY in Template Commands, click Include, replace field name with AUTHOR, delete from text (just leave ""), and replace until text with NEW-LINE.
The script's first line finds Personal name in the clipboard and positions the cursor after the found text. The second line will move the cursor to the beginning of the next line and the third line will copy the text into AUTHOR from the cursor position ("") to the end of the line (NEW-LINE). The cursor is positioned at the end of the line.

In a similar way new commands are added. They move the cursor to the start of the content then the content is copied into the corresponding data field (1). After all changes click the Save & Review button to save (2). To copy the data into the new record click Paste (3).

copy and paste data from the web search result into your data table, book catalog sample, the whole processing script

Data from the clipboard is processed and entered automatically into the data fields (1) as defined in the script file.

copy and paste data from the web search result into your data table, book catalog sample, data transferred from the web page into the record

Hint: you can select a data field name from the Template's popup menu.

copy and paste data from the web search result into your data table, book catalog sample, use fields

Copyright © 2024 · All Rights Reserved · PrimaSoft PC