<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
p.yiv2402909844msonormal, li.yiv2402909844msonormal, div.yiv2402909844msonormal
{mso-style-name:yiv2402909844msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.yiv2402909844msochpdefault, li.yiv2402909844msochpdefault, div.yiv2402909844msochpdefault
{mso-style-name:yiv2402909844msochpdefault;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.yiv2402909844msohyperlink
{mso-style-name:yiv2402909844msohyperlink;}
span.yiv2402909844msohyperlinkfollowed
{mso-style-name:yiv2402909844msohyperlinkfollowed;}
span.yiv2402909844emailstyle17
{mso-style-name:yiv2402909844emailstyle17;}
p.yiv2402909844msonormal1, li.yiv2402909844msonormal1, div.yiv2402909844msonormal1
{mso-style-name:yiv2402909844msonormal1;
margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
span.yiv2402909844msohyperlink1
{mso-style-name:yiv2402909844msohyperlink1;
color:blue;
text-decoration:underline;}
span.yiv2402909844msohyperlinkfollowed1
{mso-style-name:yiv2402909844msohyperlinkfollowed1;
color:purple;
text-decoration:underline;}
span.yiv2402909844emailstyle171
{mso-style-name:yiv2402909844emailstyle171;
color:#1F497D;}
p.yiv2402909844msochpdefault1, li.yiv2402909844msochpdefault1, div.yiv2402909844msochpdefault1
{mso-style-name:yiv2402909844msochpdefault1;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:10.0pt;
font-family:"Times New Roman","serif";}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
span.EmailStyle29
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-GB link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Hi Martin,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Type in a scheme where you want to save the loaded OS Mastermap files (myITN for example).<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Then you need to click on … in front of Input and point to where your gz or gml file(s) are located and then press OK.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>To load the data on the map canvas, in QGIS, from the main menu > Database > DB Manager > DB Manager<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>In the new Window, from Tree, PostGIS > test > myITN<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Right-click on the layer you want to see and select Add to canvas.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Hope that helps.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Regards,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Saber<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Saber Razmjooei<br><b>Lutra Consulting</b><br><a href="http://www.lutraconsulting.co.uk/" target="_blank" title="This external link will open in a new window">www.lutraconsulting.co.uk</a><br><br><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Martin Sullivan [mailto:martinsullivan4x4@yahoo.co.uk] <br><b>Sent:</b> 08 June 2015 11:06<br><b>To:</b> Saber Razmjooei; QGIS-user@lists.osgeo.org<br><b>Subject:</b> Re: [Qgis-user] Loading OS Mastermap Data into QGIS<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><div id="yui_3_16_0_1_1433537176821_17100"><p class=MsoNormal style='background:white'><span style='font-size:7.5pt;font-family:"Helvetica","sans-serif";color:black'>Thank you Saber,<o:p></o:p></span></p></div><div id="yui_3_16_0_1_1433537176821_17284"><p class=MsoNormal style='background:white'><span style='font-size:7.5pt;font-family:"Helvetica","sans-serif";color:black'><o:p> </o:p></span></p></div><div id="yui_3_16_0_1_1433537176821_17359"><p class=MsoNormal style='background:white'><span style='font-size:7.5pt;font-family:"Helvetica","sans-serif";color:black'>I have installed the Postgresql, following you instructions as best I could. However when I open the addin in QGIS I am unable to change the Connection box, which while I was playing earlier I had entered 'Test'. I have tried un installing the add in shutting down and starting again - but I am still unable to change it from test.<o:p></o:p></span></p></div><div id="yui_3_16_0_1_1433537176821_18049"><p class=MsoNormal style='background:white'><span style='font-size:7.5pt;font-family:"Helvetica","sans-serif";color:black'><br><br><o:p></o:p></span></p></div><div id="yui_3_16_0_1_1433537176821_18107"><p class=MsoNormal style='background:white'><span style='font-size:7.5pt;font-family:"Helvetica","sans-serif";color:black'>I am very new to QGIS and struggling with these new concepts...<br><br><o:p></o:p></span></p></div><div id="yui_3_16_0_1_1433537176821_17792"><p class=MsoNormal style='background:white'><span style='font-size:7.5pt;font-family:"Helvetica","sans-serif";color:black'><br><br><o:p></o:p></span></p></div><div id="yui_3_16_0_1_1433537176821_18043"><p class=MsoNormal style='background:white'><span style='font-size:7.5pt;font-family:"Helvetica","sans-serif";color:black'>Screen print attached.<br><br><o:p></o:p></span></p></div><div id="yui_3_16_0_1_1433537176821_17359"><p class=MsoNormal style='background:white'><span style='font-size:7.5pt;font-family:"Helvetica","sans-serif";color:black'> <o:p></o:p></span></p></div><p class=MsoNormal style='background:white'><span style='font-size:7.5pt;font-family:"Helvetica","sans-serif";color:black'><o:p> </o:p></span></p><div><p class=MsoNormal style='margin-bottom:12.0pt;background:white'><span style='font-size:7.5pt;font-family:"Helvetica","sans-serif";color:black'><o:p> </o:p></span></p></div><div><div><div><div><p class=MsoNormal style='background:white'><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:black'>On Friday, 5 June 2015, 17:23, Saber Razmjooei <<a href="mailto:saber.razmjooei@lutraconsulting.co.uk">saber.razmjooei@lutraconsulting.co.uk</a>> wrote:</span><span style='font-family:"Helvetica","sans-serif";color:black'><o:p></o:p></span></p></div><p class=MsoNormal style='margin-bottom:12.0pt;background:white'><span style='font-family:"Helvetica","sans-serif";color:black'><o:p> </o:p></span></p><div><div id=yiv2402909844><div><div><div><p class=MsoNormal style='background:white'><span style='font-size:11.0pt;font-family:"Helvetica","sans-serif";color:black'>Hi Martin,</span><span style='font-family:"Helvetica","sans-serif";color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='font-size:11.0pt;font-family:"Helvetica","sans-serif";color:black'> </span><span style='font-family:"Helvetica","sans-serif";color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='font-size:11.0pt;font-family:"Helvetica","sans-serif";color:black'>OS Translator II can load your files. But you need to install and configure a PostGIS connection:</span><span style='font-family:"Helvetica","sans-serif";color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='font-size:11.0pt;font-family:"Helvetica","sans-serif";color:black'><a href="http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut01" target="_blank">http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut01</a></span><span style='font-family:"Helvetica","sans-serif";color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='font-size:11.0pt;font-family:"Helvetica","sans-serif";color:black'> </span><span style='font-family:"Helvetica","sans-serif";color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='font-size:11.0pt;font-family:"Helvetica","sans-serif";color:black'>Once PostGIS is installed, you need to create a connection to your database in QGIS. OS Translator II can be then used to load all your data into PostGIS:</span><span style='font-family:"Helvetica","sans-serif";color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='font-size:11.0pt;font-family:"Helvetica","sans-serif";color:black'><a href="http://www.lutraconsulting.co.uk/blog/2015/02/23/loading-mastermap-free-easy-fast/" target="_blank">http://www.lutraconsulting.co.uk/blog/2015/02/23/loading-mastermap-free-easy-fast/</a></span><span style='font-family:"Helvetica","sans-serif";color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='font-size:11.0pt;font-family:"Helvetica","sans-serif";color:black'> </span><span style='font-family:"Helvetica","sans-serif";color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='font-size:11.0pt;font-family:"Helvetica","sans-serif";color:black'>Hope that helps.</span><span style='font-family:"Helvetica","sans-serif";color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='font-size:11.0pt;font-family:"Helvetica","sans-serif";color:black'> </span><span style='font-family:"Helvetica","sans-serif";color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='font-size:11.0pt;font-family:"Helvetica","sans-serif";color:black'>Cheers,</span><span style='font-family:"Helvetica","sans-serif";color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='font-size:11.0pt;font-family:"Helvetica","sans-serif";color:black'>Saber</span><span style='font-family:"Helvetica","sans-serif";color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='font-size:11.0pt;font-family:"Helvetica","sans-serif";color:black'> </span><span style='font-family:"Helvetica","sans-serif";color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='font-size:11.0pt;font-family:"Helvetica","sans-serif";color:black'> </span><span style='font-family:"Helvetica","sans-serif";color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='font-size:11.0pt;font-family:"Helvetica","sans-serif";color:black'>Saber Razmjooei<br><b>Lutra Consulting</b><br><br><a href="http://www.lutraconsulting.co.uk/" target="_blank" title="This external link will open in a new window">www.lutraconsulting.co.uk</a><br>Tel: +44 (0)1444 848012<br>Mob: +44 (0)7568 129733</span><span style='font-family:"Helvetica","sans-serif";color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='font-size:11.0pt;font-family:"Helvetica","sans-serif";color:black'> </span><span style='font-family:"Helvetica","sans-serif";color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='font-size:11.0pt;font-family:"Helvetica","sans-serif";color:black'> </span><span style='font-family:"Helvetica","sans-serif";color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='font-size:11.0pt;font-family:"Helvetica","sans-serif";color:black'> </span><span style='font-family:"Helvetica","sans-serif";color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='font-size:11.0pt;font-family:"Helvetica","sans-serif";color:black'> </span><span style='font-family:"Helvetica","sans-serif";color:black'><o:p></o:p></span></p></div><div id=yiv2402909844yqt54163><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><div><p class=MsoNormal style='background:white'><b><span lang=EN-US style='font-size:10.0pt;font-family:"Helvetica","sans-serif";color:black'>From:</span></b><span lang=EN-US style='font-size:10.0pt;font-family:"Helvetica","sans-serif";color:black'> <a href="mailto:qgis-user-bounces@lists.osgeo.org">qgis-user-bounces@lists.osgeo.org</a> [<a href="mailto:qgis-user-bounces@lists.osgeo.org">mailto:qgis-user-bounces@lists.osgeo.org</a>] <b>On Behalf Of </b>Martin Sullivan<br><b>Sent:</b> 05 June 2015 17:06<br><b>To:</b> <a href="mailto:QGIS-user@lists.osgeo.org">QGIS-user@lists.osgeo.org</a><br><b>Subject:</b> [Qgis-user] Loading OS Mastermap Data into QGIS</span><span style='font-family:"Helvetica","sans-serif";color:black'><o:p></o:p></span></p></div></div></div><div><p class=MsoNormal style='background:white'><span style='font-family:"Helvetica","sans-serif";color:black'> <o:p></o:p></span></p></div><div style='margin-bottom:12.0pt'><p class=MsoNormal style='margin-bottom:12.0pt;background:white'><span style='font-family:"Helvetica","sans-serif";color:black'>OS Masterdata. ITN files in the format .gz<br><br>I am struggling, as a new user to load all of these files into QGIS 2.8.<br><br>I can load files one at a time (or select all the files in a sub-folder), each time getting a new window asking which vector layers to add (Road, RoadLink, RoadNode - which appear to be all that any of the files contain) and then having to hit Select All and OK. Each one of these then creates a new layer.<br><br>I've searched the internet and found several solutions (so called) that say they can load OS data but I cannot find one that works. (add in OS Translator II, and a few other external programs that I have now lost track of).<br><br>Surely there is a way to load all these files without having to do Select All and OK, fo each single file, and to create one single layer?<br><br><br>Thanks for any help.<br><br>Martin Sullivan<br><br><br><br><br><br><br><o:p></o:p></span></p></div></div></div></div><div><p class=MsoNormal style='margin-bottom:12.0pt;background:white'><span style='font-family:"Helvetica","sans-serif";color:black'><o:p> </o:p></span></p><div class=MsoNormal align=center style='text-align:center;background:white'><span style='font-family:"Helvetica","sans-serif";color:black'><hr size=2 width="100%" align=center></span></div><div><p class=MsoNormal style='background:white'><span style='font-size:7.5pt;font-family:"Arial","sans-serif";color:#999999'>This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.<o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='font-size:7.5pt;font-family:"Arial","sans-serif";color:#999999'>Whilst reasonable care has been taken to avoid virus transmission, no responsibility for viruses is taken and it is your responsibility to carry out such checks as you feel appropriate.<o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='font-size:7.5pt;font-family:"Arial","sans-serif";color:#999999'>If this email contains a quote or offer to sell products, carry out work or perform services then our <a href="http://www.lutraconsulting.co.uk/downloads/Lutra%20Consulting%20Standard%20Terms%20and%20Conditions.pdf" target="_blank">standard terms and conditions</a> shall apply unless explicitly stated otherwise.<o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='font-size:7.5pt;font-family:"Arial","sans-serif";color:#999999'>Saber Razmjooei and Peter Wells trading as Lutra Consulting.<o:p></o:p></span></p></div><p class=MsoNormal style='margin-bottom:12.0pt;background:white'><span style='font-family:"Helvetica","sans-serif";color:black'><o:p> </o:p></span></p></div></div><p class=MsoNormal style='background:white'><span style='font-family:"Helvetica","sans-serif";color:black'><o:p> </o:p></span></p><div id=yqt74186><p class=MsoNormal style='background:white'><span style='font-family:"Helvetica","sans-serif";color:black'>_______________________________________________<br>Qgis-user mailing list<br><a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><o:p></o:p></span></p></div><p class=MsoNormal style='margin-bottom:12.0pt;background:white'><span style='font-family:"Helvetica","sans-serif";color:black'><o:p> </o:p></span></p></div></div></div></div></div></div></body></html>