Snippits not working on a new install

ptrongo

I just installed SQLPROMPT10.6.16.21150 on a new machine.  everything seems to be working, except Snippit Manager.
Its not recognizing any existing snippits in my team's shared folder. I Can see the folder, can see the scripts, can edit the scripts, but not in Prompt.

Victoria W

Hi @ptrongo

Please can you check the folder where the snippet files are stored (usually: \User\AppData\Local\Red Gate\SQL Prompt 10\Snippets) to see if they have all been converted to the new JSON file format? Or are there any duplicates in here?

Could you also check C:\Userl\AppData\Local\Red Gate\SQL Prompt 10\Styles, could you send a screenshot of the files located in that folder if any? 

ptrongo

@Victoria W
It looks like they were converted.  Here is one example. Jason files are in there with the original name and a unique identifier. 

There is nothing in the mentioned Styles folder. Additionally, the Tab History isn't working either. 

Old File (from a directory I copied off prior to upgrade)

stat.sqlpromptsnippet
=======================================================

<?xml version="1.0" encoding="utf-8"?>

<CodeSnippets>

  <CodeSnippet Format="1.0.0">

    <Header>

      <Title>stat</Title>

      <Shortcut>stat</Shortcut>

      <Description>Set Statistics on</Description>

      <Author />

      <SnippetTypes>

        <SnippetType>Expansion</SnippetType>

      </SnippetTypes>

    </Header>

    <Snippet>

      <Declarations />

      <Code Language="sql"><![CDATA[set statistics io on 

go

set statistics time on]]></Code>

    </Snippet>

  </CodeSnippet>

</CodeSnippets>

New File
stat-fa1100dc-3891-447c-9182-1af333162cc9.json
========================================================

{

  "id": "fa1100dc-3891-447c-9182-1af333162cc9",

  "prefix": "stat",

  "description": "Set Statistics on",

  "body": "set statistics io on \ngo\nset statistics time on"

}

Jessica R

Thanks @ptrongo!

Can I just check if you are you getting any errors when typing a query?

What location is your Snippets pointing to? By any chance do both your Styles and Snippets folders exist as subfolders of that location?

Can you please share more detail on how Tab History isn't working? Is it throwing any errors?

Thank you!