Um... I see it already... no subfolders within the TCX file... should be just a zipped folder with the JS and XML files right inside. Basically, don't add the folder to a zip, add the files to a zip and then rename.
<ScriptExtensionGroup Name="TristaanOgre Community Extensions">
<Category Name="TristaanOgre Community Extensions">
<ScriptExtension Name="SQL Utilities" Author="Robert Martin" Version="3.0" HomePage="bitbucket.org/account/user/privateteamogre/projects/CSE">
<Script Name="SQLUtilities.js">
<Option Name = "SQLType" DefaultValue = "MSSQL"/>
<Option Name = "SecurityType" DefaultValue = "INTEGRATED"/>
<RuntimeObject Name="SQLUtilities">
<Method Name="NewSQLQuery" Routine="sqlQuery">Creates an SQL object based upon a string and a set of parameter objects</Method>
<Method Name="FormatDateForSQL" Routine="FormatDateForSQL">Takes an integer as an offset date in days, adds it to the current date, and returns a string formatted as YYYY-MM-DD</Method>
<Method Name="SetSQLType" Routine="setSQLType">Sets the SQL Type script option to the indicated string value. Currently supports MSSQL and MYSQL_351</Method>
<Method Name="SetSQLSecurityType" Routine="setSecurityType">Sets the SQL Login type. Enter either INTEGRATED or PROMPT.</Method>
<Method Name="NewQueryObject" Routine="queryObject">Creates a query object for building SQL Query</Method>
<Property Name="DatabaseName" GetRoutine="getDatabaseName" SetRoutine="setDatabaseName">The name of the SQL Database against which SQL queries will be run</Property>
<Property Name="SQLServerName" GetRoutine="getSQLServerName" SetRoutine="setSQLServerName">The name of the SQL server against which SQL queries will be run</Property>
<Property Name="ConnectionString" GetRoutine="getConnectionString">The Connection String used for SQL Query operations</Property>
<Property Name="SQLUserName" GetRoutine="getUserName" SetRoutine="setUserName">The SQL user name for the database connection if needed</Property>
<Property Name="SQLPassWord" GetRoutine="getPassWord" SetRoutine="setPassWord">The SQL Password for the database connection. WARNING! It is unencrypted</Property>
<Description>A runtime object providing a wrapper for several SQL Query related functions used in automation tests. If they don't exist, will create a DatabaseName and SQLServerName project variables</Description>
</RuntimeObject>
</Script>
<Description>A Set of Runtime objects used for SQL Operations</Description>
</ScriptExtension>
</Category>
</ScriptExtensionGroup>Above is the XML file in question. It may look familiar ;)
Well, yes... yes it does.
So, the intellisense should show SQLUtilities as the object with the different methods available.
Let's check something... Go to File | Install Script Extensions and see if the extension shows up there. If not, click the "Reload" button and then check again.
unfortunately it is not showing up. :(
here is the .tcx
here is the .tcx
OK.... let's look at several things then.
1) The project that you have open... do you have a code unit called SQLUtilities in the project itself? If so, a script extension with the same object name as the code unit cannot exist. If this is the case, try removing the SQLUtilities code unit from your project and reload the extensions
If that doesn't work...
2) Let's look at the contents of the TCX file. Copy it to an different folder, change the extension from TCX to ZIP, and then open it and show me a screenshot. The contents SHOULD include both the Description.xml file and the SQLUtilities.js file. If not, we may need to repackage.
If that doesn't work...
3) Let's compare the contents of SQLUtilities.js with the Description.xml. It's possible that if you have method, property, etc., names different in the actual code than is what is in the extension, the extension could "error" and you won't see it. Please upload the ZIP file and I'll take a look. See, I see that the TCX file has a modified date of today's date... so, I don't trust that it is EXACTLY as the extension is when you download the TCX file from my repository (which I just did and tried myself and it works). So, something is not matching between the XML and the code file so let's see if we can figure that out.
If that doesn't work... perhaps we'll have to take this off forum and actually have something more on the lines of a phone call or something to debug it.
Um... I see it already... no subfolders within the TCX file... should be just a zipped folder with the JS and XML files right inside. Basically, don't add the folder to a zip, add the files to a zip and then rename.
