DEV Community: Ricardo Costa

Raven.Studio.zip Index.html not available

Ricardo Costa — Wed, 10 Oct 2018 14:52:19 +0000

I had RavenDb embedded in a aspnet.core web api and I was getting this error when I tried to reach Raven Studio: The following file was not available: index.html. Please make sure that the Raven.Studio.zip file exist in the main directory (near the Raven.Server.exe).

The solution was to copy Raven.Studio.zip to the root directory of the web api.

The post Raven.Studio.zip Index.html not available appeared first on Blog IT.

git-askpass.exe: No such file or directory. Visual Studio

Ricardo Costa — Thu, 06 Sep 2018 12:57:44 +0000

I was getting an error when I tried to sync to my Git BitBucket repository with Visual Studio 2017:

git-askpass.exe: No such file or directory.

To resolve this I had to:

Remove Git from Control Panel -> Uninstall
Remove Git Windows Credential Manager from Control Panel -> Uninstall
With Visual Studio 2017 Installer, remove Git for Windows
Install Git
Install Git Windows Credential Manager
With Visual Studio 2017 Installer, install Git for Windows

The post git-askpass.exe: No such file or directory. Visual Studio appeared first on Blog IT.

RavenDB embedded with ASP NET Core web API

Ricardo Costa — Tue, 04 Sep 2018 21:38:46 +0000

This post describes how you can set up a simple ASP NET Core web API with Visual Studio 2017 to use an embedded RavenDB. This is a step by step tutorial.

a) You need to create a new ASP.NET Core Web Application with Visual Studio 2017

b) Choose .NET Core; ASP.NET Core 2.1; API

c) Right click the new project -> Manage NuGet packages

d) You have to add a new package source. Settings. New package source.

Name: MyGet

Source: https://www.myget.org/F/ravendb/api/v3/index.json

e) Choose the new source. Add:

RavenDB.Embedded – 4.1.1-nightly-20180904-0430

RavenDB.Client – 4.1.1-nightly-20180904-0430

f) Create a DocumentStoreHolder class

internal class DocumentStoreHolder
{ 
    private static Lazy<IDocumentStore> store = new Lazy<IDocumentStore>(CreateStore); 

    public static IDocumentStore Store => store.Value; 

    private static IDocumentStore CreateStore() 
    { 
        var serverOptions = new ServerOptions() 
        { 
            ServerUrl = "http://127.0.0.1:60956/", 
        }; 

        EmbeddedServer.Instance.StartServer(serverOptions); 

        return EmbeddedServer.Instance.GetDocumentStore("MyRavenDBStore"); 
    }
}

g) And that’s it

The post RavenDB embedded with ASP NET Core web API appeared first on Blog IT.

Azure Search Index with 2 datasources

Ricardo Costa — Fri, 10 Nov 2017 15:24:02 +0000

Recently I had the need to index documents stored in Azure Storage Blobs. Additionally I wanted to use the blob storage metadata also to add some information to those documents. Because I needed rich text information on the metadata I could use blob storage metadata directly. Se here why.

So I had to use 2 different data sources. One for the documents and another to the metadata. So I chose Azure Blob Storage and Azure Table Storage. This is the full diagram of the final solution:

The indexers are responsible for updating the index with the contents of the 2 different data sources. There is a very important field that in my case it’s called the UniqueIdentifier field because this field is marked with the key property. This is the field that uniquely identifies each document on the Azure Search Index.

And it’s this field that is responsible for correlating the items that come from one data source (documents from blob storage) and items that come from the other data source (records from table storage).

Every document inserted in blob storage has a custom metadata property named also UniqueIdentifier that will have a table storage record associated with the corresponding metadata.

// Retrieve storage account from connection string.
CloudStorageAccount storageAccount = CloudStorageAccount.Parse( CloudConfigurationManager.GetSetting("StorageConnectionString"));

// Create the blob client.
CloudBlobClient blobClient = storageAccount.CreateCloudBlobClient();

// Retrieve a reference to a container.
CloudBlobContainer container = blobClient.GetContainerReference("mycontainer");

// Create the container if it doesn't already exist.
container.CreateIfNotExists();

// Add some metadata to the container.container.
Metadata.Add("UniqueIdentifier", "bla bla bla");

The table storage records have these values stored on the RowKey and the indexer have a mapping instruction to map the origin (RowKey) to the destination (UniqueIdentifier). You can check this mapping instruction later in the indexer schema.

First of all I created the Index:

(I’ve highlighted the UniqueIdentifier field wiht the Key property set to TRUE )

{
  "@odata.context": "https://something.search.windows.net/$metadata#indexes/$entity",
  "@odata.etag": "\"0x8D477848BDEFA50\"",
  "name": "full-index",
  "fields": [
    {
      "name": "ClientCode",
      "type": "Edm.String",
      "searchable": false,
      "filterable": true,
      "retrievable": true,
      "sortable": true,
      "facetable": true,
      "key": false,
      "indexAnalyzer": null,
      "searchAnalyzer": null,
      "analyzer": null
    },
    {
      "name": "UniqueIdentifier",
      "type": "Edm.String",
      "searchable": false,
      "filterable": true,
      "retrievable": true,
      "sortable": false,
      "facetable": false,
      "key": true,
      "indexAnalyzer": null,
      "searchAnalyzer": null,
      "analyzer": null
    },
    {
      "name": "ETag",
      "type": "Edm.String",
      "searchable": false,
      "filterable": false,
      "retrievable": false,
      "sortable": false,
      "facetable": false,
      "key": false,
      "indexAnalyzer": null,
      "searchAnalyzer": null,
      "analyzer": null
    },
    {
      "name": "Timestamp",
      "type": "Edm.DateTimeOffset",
      "searchable": false,
      "filterable": false,
      "retrievable": false,
      "sortable": false,
      "facetable": false,
      "key": false,
      "indexAnalyzer": null,
      "searchAnalyzer": null,
      "analyzer": null
    },
    {
      "name": "Key",
      "type": "Edm.String",
      "searchable": false,
      "filterable": false,
      "retrievable": false,
      "sortable": false,
      "facetable": false,
      "key": false,
      "indexAnalyzer": null,
      "searchAnalyzer": null,
      "analyzer": null
    },
    {
      "name": "Opportunity",
      "type": "Edm.String",
      "searchable": true,
      "filterable": false,
      "retrievable": true,
      "sortable": false,
      "facetable": false,
      "key": false,
      "indexAnalyzer": null,
      "searchAnalyzer": null,
      "analyzer": "pt-Pt.lucene"
    },
    {
      "name": "OpportunityCode",
      "type": "Edm.String",
      "searchable": false,
      "filterable": false,
      "retrievable": true,
      "sortable": false,
      "facetable": false,
      "key": false,
      "indexAnalyzer": null,
      "searchAnalyzer": null,
      "analyzer": null
    },
    {
      "name": "DocumentExtension",
      "type": "Edm.String",
      "searchable": false,
      "filterable": true,
      "retrievable": true,
      "sortable": false,
      "facetable": true,
      "key": false,
      "indexAnalyzer": null,
      "searchAnalyzer": null,
      "analyzer": null
    },
    {
      "name": "DocumentType",
      "type": "Edm.String",
      "searchable": false,
      "filterable": true,
      "retrievable": true,
      "sortable": false,
      "facetable": true,
      "key": false,
      "indexAnalyzer": null,
      "searchAnalyzer": null,
      "analyzer": null
    },
    {
      "name": "ClientName",
      "type": "Edm.String",
      "searchable": true,
      "filterable": true,
      "retrievable": true,
      "sortable": true,
      "facetable": true,
      "key": false,
      "indexAnalyzer": null,
      "searchAnalyzer": null,
      "analyzer": "pt-Pt.lucene"
    },
    {
      "name": "Year",
      "type": "Edm.Int32",
      "searchable": false,
      "filterable": true,
      "retrievable": true,
      "sortable": true,
      "facetable": true,
      "key": false,
      "indexAnalyzer": null,
      "searchAnalyzer": null,
      "analyzer": null
    },
    {
      "name": "Path",
      "type": "Edm.String",
      "searchable": false,
      "filterable": false,
      "retrievable": true,
      "sortable": false,
      "facetable": false,
      "key": false,
      "indexAnalyzer": null,
      "searchAnalyzer": null,
      "analyzer": null
    },
    {
      "name": "LocalPath",
      "type": "Edm.String",
      "searchable": false,
      "filterable": false,
      "retrievable": true,
      "sortable": false,
      "facetable": false,
      "key": false,
      "indexAnalyzer": null,
      "searchAnalyzer": null,
      "analyzer": null
    },
    {
      "name": "Name",
      "type": "Edm.String",
      "searchable": true,
      "filterable": false,
      "retrievable": true,
      "sortable": true,
      "facetable": false,
      "key": false,
      "indexAnalyzer": null,
      "searchAnalyzer": null,
      "analyzer": "pt-Pt.lucene"
    },
    {
      "name": "content",
      "type": "Edm.String",
      "searchable": true,
      "filterable": false,
      "retrievable": false,
      "sortable": false,
      "facetable": false,
      "key": false,
      "indexAnalyzer": null,
      "searchAnalyzer": null,
      "analyzer": "pt-Pt.lucene"
    },
    {
      "name": "metadata_storage_content_type",
      "type": "Edm.String",
      "searchable": false,
      "filterable": false,
      "retrievable": true,
      "sortable": false,
      "facetable": false,
      "key": false,
      "indexAnalyzer": null,
      "searchAnalyzer": null,
      "analyzer": null
    },
    {
      "name": "metadata_storage_size",
      "type": "Edm.Int64",
      "searchable": false,
      "filterable": false,
      "retrievable": true,
      "sortable": false,
      "facetable": false,
      "key": false,
      "indexAnalyzer": null,
      "searchAnalyzer": null,
      "analyzer": null
    },
    {
      "name": "metadata_storage_last_modified",
      "type": "Edm.DateTimeOffset",
      "searchable": false,
      "filterable": false,
      "retrievable": true,
      "sortable": false,
      "facetable": false,
      "key": false,
      "indexAnalyzer": null,
      "searchAnalyzer": null,
      "analyzer": null
    },
    {
      "name": "metadata_storage_content_md5",
      "type": "Edm.String",
      "searchable": false,
      "filterable": false,
      "retrievable": true,
      "sortable": false,
      "facetable": false,
      "key": false,
      "indexAnalyzer": null,
      "searchAnalyzer": null,
      "analyzer": null
    },
    {
      "name": "metadata_storage_name",
      "type": "Edm.String",
      "searchable": false,
      "filterable": false,
      "retrievable": true,
      "sortable": false,
      "facetable": false,
      "key": false,
      "indexAnalyzer": null,
      "searchAnalyzer": null,
      "analyzer": null
    },
    {
      "name": "metadata_storage_path",
      "type": "Edm.String",
      "searchable": false,
      "filterable": false,
      "retrievable": true,
      "sortable": false,
      "facetable": false,
      "key": false,
      "indexAnalyzer": null,
      "searchAnalyzer": null,
      "analyzer": null
    },
    {
      "name": "metadata_author",
      "type": "Edm.String",
      "searchable": false,
      "filterable": false,
      "retrievable": true,
      "sortable": false,
      "facetable": false,
      "key": false,
      "indexAnalyzer": null,
      "searchAnalyzer": null,
      "analyzer": null
    },
    {
      "name": "metadata_content_type",
      "type": "Edm.String",
      "searchable": false,
      "filterable": false,
      "retrievable": true,
      "sortable": false,
      "facetable": false,
      "key": false,
      "indexAnalyzer": null,
      "searchAnalyzer": null,
      "analyzer": null
    },
    {
      "name": "metadata_creation_date",
      "type": "Edm.DateTimeOffset",
      "searchable": false,
      "filterable": false,
      "retrievable": true,
      "sortable": false,
      "facetable": false,
      "key": false,
      "indexAnalyzer": null,
      "searchAnalyzer": null,
      "analyzer": null
    },
    {
      "name": "metadata_last_modified",
      "type": "Edm.DateTimeOffset",
      "searchable": false,
      "filterable": false,
      "retrievable": true,
      "sortable": false,
      "facetable": false,
      "key": false,
      "indexAnalyzer": null,
      "searchAnalyzer": null,
      "analyzer": null
    }
  ],
  "scoringProfiles": [],
  "defaultScoringProfile": "",
  "corsOptions": null,
  "suggesters": [
    {
      "name": "temp-suggester",
      "searchMode": "analyzingInfixMatching",
      "sourceFields": [
        "ClientCode",
        "Opportunity",
        "ClientName",
        "Name"
      ]
    }
  ],
  "analyzers": [],
  "tokenizers": [],
  "tokenFilters": [],
  "charFilters": []
}

After the index was created I’ve created the container and uploaded my files. This is the corresponding data source:

{
  "@odata.context": "https://something.search.windows.net/$metadata#datasources/$entity",
  "@odata.etag": "\"0x8D526E01DDB35F4\"",
  "name": "opportunities-datasource",
  "description": "",
  "type": "azureblob",
  "subtype": null,
  "credentials": {
    "connectionString": null
  },
  "container": {
    "name": "opportunities",
    "query": null
  },
  "dataChangeDetectionPolicy": null,
  "dataDeletionDetectionPolicy": null
}

I’ve also create the Table Storage and inserted the metadata records. This is the data source:

{
  "@odata.context": "https://something.search.windows.net/$metadata#datasources/$entity",
  "@odata.etag": "\"0x8D526E01DB70AF2\"",
  "name": "ecmcreatemeta",
  "description": "",
  "type": "azuretable",
  "subtype": null,
  "credentials": {
    "connectionString": null
  },
  "container": {
    "name": "opportunities",
    "query": null
  },
  "dataChangeDetectionPolicy": null,
  "dataDeletionDetectionPolicy": null
}

And these are the indexers. The documents indexer:

{
  "@odata.context": "https://something.search.windows.net/$metadata#indexers/$entity",
  "@odata.etag": "\"0x8D477862D23289E\"",
  "name": "full-indexer-blob",
  "description": "",
  "dataSourceName": "opportunities-datasource",
  "targetIndexName": "full-index",
  "schedule": null,
  "parameters": {
    "batchSize": 10,
    "maxFailedItems": 10,
    "maxFailedItemsPerBatch": 10,
    "base64EncodeKeys": false,
    "configuration": {
      "dataToExtract": "contentAndMetadata",
      "failOnUnsupportedContentType": false,
      "indexedFileNameExtensions": ".pdf, .docx, .doc, .xlsx, .xls, .pptx, .ppt, .msg, .html, .htm, .xml, .zip, .eml, .txt, .json, .csv"
    }
  },
  "fieldMappings": [],
  "disabled": null
}

And the metadata indexer:

{
  "@odata.context": "https://something.search.windows.net/$metadata#indexers/$entity",
  "@odata.etag": "\"0x8D47784D3CE80DF\"",
  "name": "full-indexer-meta",
  "description": "",
  "dataSourceName": "ecmcreatemeta",
  "targetIndexName": "full-index",
  "schedule": null,
  "parameters": {
    "batchSize": null,
    "maxFailedItems": 0,
    "maxFailedItemsPerBatch": 0,
    "base64EncodeKeys": false,
    "configuration": {}
  },
  "fieldMappings": [
    {
      "sourceFieldName": "PartitionKey",
      "targetFieldName": "ClientCode",
      "mappingFunction": null
    },
    {
      "sourceFieldName": "RowKey",
      "targetFieldName": "UniqueIdentifier",
      "mappingFunction": null
    }
  ],
  "disabled": null
}

That is the RowKey UniqueIdentifier mapping function. That is how Azure Search will map the records from table storage to documents inside the index.

The post Azure Search Index with 2 datasources appeared first on Blog IT.

Azure Blob Storage Metadata 400 Bad Request

Ricardo Costa — Fri, 10 Nov 2017 13:52:28 +0000

I was getting a 400 Bad Request when inserting blobs in Azure Blob Storage because I was setting metadata with non-ASCII characters.

// Retrieve storage account from connection string. 
CloudStorageAccount storageAccount = CloudStorageAccount.Parse( CloudConfigurationManager.GetSetting("StorageConnectionString")); 

// Create the blob client. 
CloudBlobClient blobClient = storageAccount.CreateCloudBlobClient(); 

// Retrieve a reference to a container. 
CloudBlobContainer container = blobClient.GetContainerReference("mycontainer"); 

// Create the container if it doesn't already exist.
container.CreateIfNotExists(); 

// Add some metadata to the container. 
container.Metadata.Add("docType", "textDocuments");

According to Microsfot documentation:

“You will receive a 400 Bad Request if any name/value pairs contain non-ASCII characters. Metadata name/value pairs are valid HTTP headers, and so must adhere to all restrictions governing HTTP headers. It is therefore recommended that you use URL encoding or Base64 encoding for names and values containing non-ASCII characters.”

https://docs.microsoft.com/en-us/azure/storage/blobs/storage-properties-metadata

The post Azure Blob Storage Metadata 400 Bad Request appeared first on Blog IT.

Using KeywordQuery with CSOM SharePoint Online

Ricardo Costa — Wed, 25 Oct 2017 14:27:12 +0000

string username = "***********";
string pwd = "*********";
string siteURL = "**********";

ClientContext context = new ClientContext(siteURL);
Web web = context.Web;
SecureString pass = new SecureString();
foreach (char c in pwd.ToCharArray()) pass.AppendChar(c);
context.Credentials = new SharePointOnlineCredentials(username, passWord);
try
{
    KeywordQuery query = new KeywordQuery(context);
    query.QueryText = "ContentType:Factura AND PrecoOWSCURR>10000";

    query.RowLimit = 10;
    query.RowsPerPage = 10;
    SearchExecutor search = new SearchExecutor(context);
    ClientResult<ResultTableCollection> results = search.ExecuteQuery(query);
    context.ExecuteQuery();

    foreach (var resultRow in results.Value[0].ResultRows)
    {
        Console.WriteLine("{0}", resultRow["Title"]);
    }
}
catch (Exception e)
{
    Console.WriteLine(e.ToString());
    Console.ReadKey();
}

The post Using KeywordQuery with CSOM SharePoint Online appeared first on Blog IT.

Move modules – Remove IPP – OutSystems

Ricardo Costa — Tue, 01 Aug 2017 13:02:46 +0000

I needed to move some modules from one infrastructure to another so first I needed to remove IPP (Intellectual Property Protection).

1 – In Service Studio, open your module and goto Module -> Export -> Save As…

Export OML

2 – Navigate to Intellectual Property Protection (IPP) Rights Validation

Here you need to enter your email, the destination activation code for your target infrastructure, and upload your OML

IPP Validation

3 – You will receive an email with the OML file without IPP protection. Download the file.

4 – In Service Studio goto Module -> Open File…

Open module

5 – Publish your module

The post Move modules – Remove IPP – OutSystems appeared first on Blog IT.

No data type ‘TYPE’ could be found – OutSystems Combo Box

Ricardo Costa — Tue, 02 May 2017 10:40:12 +0000

I was trying to set up a Combo Box bounded to a static entity and I got this error when I published the website:

Internal Error 
No data type 'Status' could be found. 
Exception Details:
[1] Internal Error: No data type 'Status' could be found.
at OutSystems.HubEdition.Compiler.WebWidgets.ComboBox.dumpEntityDeclaration(TextWriter res)
 at OutSystems.HubEdition.Compiler.WebWidgets.ComboBox.DumpDataBindingCode(TextWriter writer)
 at OutSystems.HubEdition.Compiler.AbstractServerWebWidget.DumpOnDataBinding(TextWriter writer, NodeViewState viewState)
 at OutSystems.HubEdition.Compiler.AbstractServerWebWidget.DumpHandler(TextWriter writer, NodeViewState viewState)
 at OutSystems.HubEdition.Compiler.WebWidgets.ComboBox.DumpHandler(TextWriter res, NodeViewState viewState)
 at OutSystems.HubEdition.Compiler.Nodes.WebScreen.Dump(TextWriter writer)
 at OutSystems.HubEdition.Compiler.Flows.WebFlow.Dump()
 at OutSystems.HubEdition.Compiler.WebFlows.WebHandler.Dump(IEnumerable`1 webFlows)
 at OutSystems.HubEdition.Compiler.ESpace.Dump()
 at OutSystems.HubEdition.Compiler.Compiler.InnerCompile(CompilationContext context)
 at OutSystems.HubEdition.Compiler.Compiler.Compile(CompilationContext context)
 at OutSystems.HubEdition.Compiler.Utils.CompilerUtils.WithOverridenSettings(IDictionary`2 settingsOverride, Action body)
 at OutSystems.HubEdition.Compiler.Compiler.<>c__DisplayClass3.<Compile>b__1()
 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
 at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
 at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
 at System.Threading.ThreadHelper.ThreadStart()

But TrueChange didn’t show me any errors or warnings. I got this error only when I tried to publish the application.

The problem was that the variable that I defined to hold the value entered by the user was of the Static Entity type instead of the Static Entity Identifier type.

That variable “Status” was defined like this:

And must be defined like this:

It must be a Status Identifier instead of the Status (static entity).

The post No data type ‘TYPE’ could be found – OutSystems Combo Box appeared first on Blog IT.