Difference between revisions of "SDC Platinum (Wiki)"
Adliebster (talk | contribs) |
Adliebster (talk | contribs) |
||
Line 54: | Line 54: | ||
==Potential Errors== | ==Potential Errors== | ||
+ | If you are opening a custom report and the rpt file you are looking to use to extract doesn't appear, there was a mistake in your choice of database. For example, when attempting to pull data relating to funds or rounds you sometimes have to chose Portfolio Companies in the VentureXpert database. Play around with choosing different filters within the database. Choice of which database to pull each type of data from can be found on the [[VentureXpert Data]] page. | ||
+ | |||
Occasionally an error will appear at the end of extraction which reads Out of Memory. This error does not occur because we do not have enough memory so do not delete anything. Rather, it occurs because of defective memory processing in the program itself especially when running a custom script. To fix this problem either completely restart SDC (maybe even log out of the RDP) and rerun the program. If this doesn't work, go into the rpt file that you are running and slightly change something. For example, change 6/17/2018 to 06/17/2018. This worked for me and my data was successfully extracted. | Occasionally an error will appear at the end of extraction which reads Out of Memory. This error does not occur because we do not have enough memory so do not delete anything. Rather, it occurs because of defective memory processing in the program itself especially when running a custom script. To fix this problem either completely restart SDC (maybe even log out of the RDP) and rerun the program. If this doesn't work, go into the rpt file that you are running and slightly change something. For example, change 6/17/2018 to 06/17/2018. This worked for me and my data was successfully extracted. | ||
If SDC won't shut down or reopens immediately if you restart RDP, go to Task Manager and force quit it. If this still does not work, you will need administration privileges to shut down SDC. Ask someone with this power, and your problem should be fixed. | If SDC won't shut down or reopens immediately if you restart RDP, go to Task Manager and force quit it. If this still does not work, you will need administration privileges to shut down SDC. Ask someone with this power, and your problem should be fixed. |
Revision as of 10:29, 29 June 2018
SDC Platinum (Wiki) | |
---|---|
Project Information | |
Project Title | SDC Platinum (Wiki) |
Owner | Ben Baldazo |
Start Date | |
Deadline | |
Keywords | Tool |
Primary Billing | |
Notes | |
Has project status | Complete |
Copyright © 2016 edegan.com. All Rights Reserved. |
How to use:
For example we want to obtain information about executives of portfolio companies which received last investments from November 2013 to November 2015.
Run SDC Platinum, and login in with User Initials "mc" (without quotes). Fill in project description. Select VentureXpert and select Portfolio Companies under Industry Resources. Select Search Menu in Navigation Method (never select Express Reports). Double click Company Area Cd under Portfolio Company. Double click All Canada and select all British Columbia rows by double clicking. Open Venture Related Deals under Investment Type and then select All Venture Related Deals. Under Investment Summary, open Date Company Rcvd its First Investment and set the dates. Exit search window and click on the Report button on the tool bar. Select Custom and find whatever information you want to display in the report, such as Company Name and Address, add them by double clicking. Click OK and click OK again on the right hand side of the window. Select No when asked to return to design mode. Input name for custom report and save. Choose Column Grid format and save as txt file. Click Execute on the top to generate the report.
Login Information
- User Initials: mc
- Enter project description
Create a New Project
- Enter Project Description
- Select a Database
- VentureXpert
- Choose Industry Resource
- Global New Issues Databases
- Mergers & Acquisitions
- VentureXpert
- Select Search Menu
- In Search Items:
- Select Moneytree Deals or Venture Related Deals
- Select all other filters needed for the analysis (i.e. dates or state)
- Fill out custom time frame for filters requiring dates
- In Express Report Items (Under report in top bar, create custom report):
- Select all variables for analysis (double click)
- Select OK on far right column
- Save custom report
- In report options: select 'Save As' from the row of tabs at the top
- Enter file name and save the report to a text file (.txt)
- Select Execute to generate a report
To Open the Report in TextPad
- Open Documents from Windows Menu
- Select Local Disk (C:)
- Select SDC
- Select 4.0.3.1
- Select Platinum
- Select USR
- left click on your text file, select open with TextPad
Potential Errors
If you are opening a custom report and the rpt file you are looking to use to extract doesn't appear, there was a mistake in your choice of database. For example, when attempting to pull data relating to funds or rounds you sometimes have to chose Portfolio Companies in the VentureXpert database. Play around with choosing different filters within the database. Choice of which database to pull each type of data from can be found on the VentureXpert Data page.
Occasionally an error will appear at the end of extraction which reads Out of Memory. This error does not occur because we do not have enough memory so do not delete anything. Rather, it occurs because of defective memory processing in the program itself especially when running a custom script. To fix this problem either completely restart SDC (maybe even log out of the RDP) and rerun the program. If this doesn't work, go into the rpt file that you are running and slightly change something. For example, change 6/17/2018 to 06/17/2018. This worked for me and my data was successfully extracted.
If SDC won't shut down or reopens immediately if you restart RDP, go to Task Manager and force quit it. If this still does not work, you will need administration privileges to shut down SDC. Ask someone with this power, and your problem should be fixed.