Importing Patents from a Spreadsheet
Patents can be imported into AcclaimIP from data sent to you in spreadsheets or text files, such as emails and word processing documents. You import patents into a research folder which can be shared with other users in your workgroup (company) or with external AcclaimIP users from other organizations.
Steps to Import Patents into AcclaimIP
- Create a research folder to hold the patents, or use one of your existing research folders.
- Highlight the folder you just created (or the existing folder) and choose the Import button from your Research Folders window's toolbar.
- Alternatively, choose the Import button first and select the folder from the drop down menu into which you want to import the patents.
- Go to your spreadsheet program and copy the patent or application numbers (any collection AcclaimIP supports). You can copy the whole column including headers (usually column A).
- Paste the column into the Document Numbers box in the AcclaimIP Import window.
- Choose the Import button.
- The results will be reported to you telling you how many were imported, how many were not recognized and how many were duplicate numbers.
If AcclaimIP can't recognize a patent number, or it is a duplicate, it will be skipped, and the balance of the documents will be imported. Skipped patent numbers will be reported in the Import Result window's Documents Not Imported tab.
Once your documents are imported, in the Research Folders window click the folder icon for the folder you selected and view the documents in the normal Search Result window.
Create Research Folder
- Open the Research Folders window by clicking the icon on the AcclaimIP desktop.
- Click the New button (1) from the Research Folders window's toolbar.
- Complete the form (2) and click the Save button.
Open Import Window
Highlight the folder you want to import into by single clicking the folder in the Research Folders window.
Click the Import button (1) and the Import window (2) will open.
Copy Patent Numbers from Excel, other Spreadsheets or a Text File
- Select the column by clicking the header (Column A in this example) and choosing Copy option.
- The column of numbers will now be in your copy buffer.
Paste Document Numbers into AcclaimIP
- Paste the document numbers into the Import window's Document Numbers field (1) in AcclaimIP.
- Click the Import button (2).
Notes on Number Formats:
When importing US documents, the rules are fairy simple.
- You do not need the Country Code prefix (US) before each patent or application number, and you do not need a Kind Code suffix. The reason is that all US document numbers are unique, so there is no possibility of importing a document with the same number and a different kind code. You may include the US prefix or leave it out. If you leave it out we assume you want to import the US document.
- Commas (,), slashes (/), and hyphens (-) are ignored so you can leave them in or take them out.
- Do not include any spaces in your numbers. US8123456B2 is correct, US 8123456 B2 is not correct and will fail on import.
- Examples of valid document numbers are 8123456, US8123456, 8123456B2, US8123456B2, US2015000001, US2015/000001, 2015/000001
- One exception are document numbers begining with RE (Re-issued patents). In this case AcclaimIP requires the US prefix, e.g. USRE45256. You may include the E1 kind code suffix if you choose, but it is not required. USRE45256E1 will import correctly as well.
When importing Non-US documents the rules are a little more restrictive
EP, JP and other jurisdictions re-use document numbers in a serial family and append the unique publications with different kind codes. As a result, the country code prefix is required, and if you leave off the kind code, all matching family members will be imported.
- Country Code prefix is required. If you leave it off, AcclaimIP will try to match a US document.
- A Kind Code suffix is not technicaly required, but if you leave it off, AcclaimIP will import all matching members of the patent's family sharing this same root number.
- Remove all spaces in your numbers.
Review Import Results
- The result of your import is reported in the Import Result window (1).
- Unrecognized, and duplicated documents will be reported in the Documents Not Imported tab (2).
- In this example 20 documents were imported into the Manual Research folder, and 0 were not recognized.
Depending on your membership plan, the maximum number of documents you can import per folder will vary.
Open Folder and Manipulate Patents
- View the imported patents in the specific research folder (1) by double clicking on the folder or search in the Research Folders (2) window.
- Search within this set using keywords and field codes to create complex searches within the folder using the Query field (3).
- Notice one of the filtering criteria for the list is the Research Folders ID (RFID) number (4).
- The imported list is faceted automatically, and all of the Filter Results (5) will work just like any other search result.