Cosmetic to table

[Roopesh Kumar]

Hi

 

can we get cosmetic layer lat/long in excel

--
Regards
Roopesh Kumar
+91 9784842818

[KTG Infotech]

Yes, you can use save cosmetic layers to tab file and later to any other form..

--
You received this message because you are subscribed to the
Google Groups "MapInfo-L" group.To post a message to this group, send
email to mapi...@googlegroups.com
To unsubscribe from this group, go to:
http://groups.google.com/group/mapinfo-l/subscribe?hl=en
For more options, information and links to MapInfo resources (searching
archives, feature requests, to visit our Wiki, visit the Welcome page at
http://groups.google.com/group/mapinfo-l?hl=en

--
Kalai Selvan
KTG Infotech
CAD/GIS/Geo spatial Services
Skypes- ktgcad

[Peter Doyle]

Save cosnetuv layer as a table and export said table as s csv. Open csv in ecxel.
Regards
Peter Doyle

Roopesh Kumar <mail.roo...@gmail.com> wrote:

--

[David Reid]

Cosnetuv layer huh?   Frosty mug got your fingers numb?  Step away from the keyboard and finish your beer Peter!

 

A; "yes Ociffer" will do fine.

 

-Dave

---

From: mapi...@googlegroups.com [mailto:mapi...@googlegroups.com] On Behalf Of Peter Doyle
Sent: Friday, February 10, 2012 2:36 AM
To: mapi...@googlegroups.com
Subject: Re: [MI-L] Cosmetic to table

[Roopesh Kumar]

Hi

 

I have drawn line between two Lat/Long in cosmetic layer, i have saved the same and when i am trying to take export in csv,it showing only zero. 

[Roopesh Kumar]

It only shows zero when open the excel...

[priyabrata mohapatra]

Hi,

Open the tab in word pad. I think the issue might be solved.

-- 
Thanks & Regards
Priyabrata

[Roopesh Kumar]

not solved it shows the following message

!table

!version 300

!charset WindowsLatin1

Definition Table

Type NATIVE Charset "Neutral"

Fields 1

ID Integer ;

[Spencer Simpson]

Nobody told you how to get coordinates out of the graphic objects and into attribute fields, which are the only things that will show up in an export to Excel.

 

The method for doing this depends on the type of object, and can involve a lot of steps.  So whether it's worth explaining depends on why you want the coordinates in Excel.

 

A shortcut for doing this *just the once* is to export the table to MIF/MID, open the MIF file in a text editor, and copy/paste the coordinates out of there.    

---

Spencer

[CDR Group]

Or you could use the Co-ordinate Extractor tool from the Tool Manager.

Really simple to update a table with the co-ordinates in the projection of your choice.

 

John Ievers

CDR Group
www.cdrgroup.co.uk
www.browse-a-map.co.uk
Tel: 01433 621282
Fax: 01433 621292
Specialists in Geographic Information Systems

CDR Group is the trading name of Contract Data Research Ltd.
Registered address Eccles House, Eccles Lane, Hope, Hope Valley, S33 6RW.
Registration No. 1972326
VAT No. GB373 3117 67

[Spencer Simpson]

Except that Coordinate Extractor works only with points, not lines like Roopesh mentioned.  We don't even know if by "lines" he meant polylines….

 

---

Spencer

[Roopesh Kumar]

Hi

 

The main reason for getting these lines not polylines in excel is that i had made a plan of connecting sites in cosmetic and saved it.

 

Now i want to share the same with customer and they require in excel

I have made the plan in blue color.now if i use co-ordinate extractor it only extracts lat/long,but do not provide the data in link format so that i can make lines again or same can be done by customer.

 

 

Regards
Roopesh Kumar
+91 9784842818

--

[Peter Horsbøll Møller]

Sorry, but was there a question somewhere in this message?
I would strongly recommend that you try to be a bit more precise when posting questions

Peter Horsbøll Møller

onsdag den 15. februar 2012 skrev Roopesh Kumar <mail.roo...@gmail.com>:
> Hi
>  
> The main reason for getting these lines not polylines in excel is that i had made a plan of connecting sites in cosmetic and saved it.
>  
> Now i want to share the same with customer and they require in excel
> I have made the plan in blue color.now if i use co-ordinate extractor it only extracts lat/long,but do not provide the data in link format so that i can make lines again or same can be done by customer.
>  
>  

> </mail/u/0/s/?view=att&th=1357fd43136f4ec7&attid=0.1&disp=emb&realattid=ii_1357fd1ffb56d19e&zw>

--
Peter Horsbøll Møller
Pitney Bowes Software

[Roopesh Kumar]

Hi

 

The question is same to convert cosmetic layer in excel.

Regards
Roopesh Kumar
+91 9784842818

[Bo Victor Thomsen]

• Download a mapbasic compiler (If you don't have one already)
  
• Compile the program attached to this message
• Set-up your MapInfo so the mapper-window with your cosmetic layer with lines has the focus.
• run the program. It will produce a csv file "Lines.csv" in the same directory where the creaLines.mbx� program resides
  The csv file has 4 columns with xstart, ystart, xfinish, yfinish
  

regards
Bo Victor Thomsen

Den 15-02-2012 08:05, Roopesh Kumar skrev:

Hi

�

The main reason for getting these lines not polylines in excel is that i had made a plan of connecting sites in cosmetic and saved it.

�

Now i want to share the same with customer and they require in excel

I have made the plan in blue color.now if i use co-ordinate extractor it only extracts lat/long,but do not provide the data in link format so that i can make lines again or same can be done by customer.

�

�

Regards
Roopesh Kumar
+91 9784842818

On Fri, Feb 10, 2012 at 11:05 PM, Spencer Simpson <ssim...@baltometro.org> wrote:

Except that Coordinate Extractor works only with points, not lines like Roopesh mentioned.� We don't even know if by "lines" he meant polylines�.

�

---

Spencer

�

From: CDR Group [mailto:sa...@cdrgroup.co.uk]
Sent: Friday, February 10, 2012 11:37 AM

To: mapi...@googlegroups.com
Subject: Re: [MI-L] Cosmetic to table

�

Or you could use the Co-ordinate Extractor tool from the Tool Manager.

Really simple to update a table with the co-ordinates in the projection of your choice.

�

John Ievers

CDR Group
www.cdrgroup.co.uk
www.browse-a-map.co.uk
Tel: 01433 621282
Fax: 01433 621292
Specialists in Geographic Information Systems

CDR Group is the trading name of Contract Data Research Ltd.
Registered address Eccles House, Eccles Lane, Hope, Hope Valley, S33 6RW.
Registration No. 1972326
VAT No. GB373 3117 67

----- Original Message -----

From: Spencer Simpson

To: mapi...@googlegroups.com

Sent: Friday, February 10, 2012 3:11 PM

Subject: RE: [MI-L] Cosmetic to table

�

Nobody told you how to get coordinates out of the graphic objects and into attribute fields, which are the only things that will show up in an export to Excel.

�

The method for doing this depends on the type of object, and can involve a lot of steps.� So whether it's worth explaining depends on why you want the coordinates in Excel.

�

A shortcut for doing this *just the once* is to export the table to MIF/MID, open the MIF file in a text editor, and copy/paste the coordinates out of there. ���

---

Spencer

�

From: Roopesh Kumar [mailto:mail.roo...@gmail.com]
Sent: Friday, February 10, 2012 5:26 AM
To: mapi...@googlegroups.com
Subject: Re: [MI-L] Cosmetic to table

�

not solved it shows the following message

!table

!version 300

!charset WindowsLatin1

Definition Table

Type NATIVE Charset "Neutral"

Fields 1

ID Integer ;

�

On Fri, Feb 10, 2012 at 3:22 PM, priyabrata mohapatra <pbmoh...@gmail.com> wrote:

Hi,

Open the tab in word pad. I think the issue might be solved.

�

--�
Thanks & Regards
Priyabrata

�

On Fri, Feb 10, 2012 at 2:46 PM, Roopesh Kumar <mail.roo...@gmail.com> wrote:

It only shows zero when open the excel...

�

On Fri, Feb 10, 2012 at 2:15 PM, David Reid <dwr...@hiwaay.net> wrote:

Cosnetuv layer huh?�� Frosty mug got your fingers numb?� Step away from the keyboard and finish your beer Peter!

�

A; "yes Ociffer" will do fine.

�

-Dave

�

---

From: mapi...@googlegroups.com [mailto:mapi...@googlegroups.com] On Behalf Of Peter Doyle
Sent: Friday, February 10, 2012 2:36 AM
To: mapi...@googlegroups.com
Subject: Re: [MI-L] Cosmetic to table

Save cosnetuv layer as a table and export said table as s csv. Open csv in ecxel.
Regards
Peter Doyle

Roopesh Kumar <mail.roo...@gmail.com> wrote:

Hi

�

can we get cosmetic layer lat/long in excel

--
Regards
Roopesh Kumar
+91 9784842818

--
You received this message because you are subscribed to the
Google Groups "MapInfo-L" group.To post a message to this group, send
email to mapi...@googlegroups.com
To unsubscribe from this group, go to:
http://groups.google.com/group/mapinfo-l/subscribe?hl=en
For more options, information and links to MapInfo resources (searching
archives, feature requests, to visit our Wiki, visit the Welcome page at
http://groups.google.com/group/mapinfo-l?hl=en

[Spencer Simpson]

Since you've confirmed that the objects are actual lines:

 

1.       Convert the cosmetic layer to an actual table

2.       Add four FLOAT columns (you can call them X1, X2, Y1, and Y2)

3.       Set the coordinate system

a.       Open the MapBasic window

b.      Set the map window's coordinate system to the desired system using Map->Options.  A line beginning with "set map coordsys" will appear in the MapBasic window

c.       Remove the word MAP from that line and hit ENTER.  It won't look like anything happened, but you just set the coordinate system

4.       Update each column in the table with the corresponding coordinate:

X1: ObjectGeography (obj, 1)

Y1: ObjectGeography (obj, 2)

X2: ObjectGeography (obj, 3)

Y2: ObjectGeography (obj, 4)

5.       Export to Excel

 

 

In the future draw new objects into a table, not the cosmetic layer.

 

Myślę, że musimy być bardziej nastawenie do ograniczeń językowych w przyszłości, albo będę nalegać, że wszystkie pytania są zadawane w języku polskim.

---

Spencer

 

From: Roopesh Kumar [mailto:mail.roo...@gmail.com]
Sent: Wednesday, February 15, 2012 3:19 AM
To: mapi...@googlegroups.com
Subject: Re: [MI-L] Cosmetic to table

 

<snip>

> Hi
>  
> The main reason for getting these lines not polylines in excel is that i had made a plan of connecting sites in cosmetic and saved it.
>  
> Now i want to share the same with customer and they require in excel
> I have made the plan in blue color.now if i use co-ordinate extractor it only extracts lat/long,but do not provide the data in link format so that i can make lines again or same can be done by customer.
>  
>  

<snipped some more>

>> ----- Original Message -----
>>
>> From: Spencer Simpson
>>

>> Nobody told you how to get coordinates out of the graphic objects and into attribute fields, which are the only things that will show up in an export to Excel.
>>
>> The method for doing this depends on the type of object, and can involve a lot of steps.  So whether it's worth explaining depends on why you want the coordinates in Excel.
>>

<snipped quite a bit of witty banter>

[Peter Horsbøll Møller]

>> Myślę, że musimy być bardziej nastawenie do ograniczeń językowych w przyszłości, albo będę nalegać, że wszystkie pytania są zadawane w języku polskim 

Why Polish, Spencer? 

I certainly would prefer Danish - and I'm sure there is a bunch of people that would prefer that language to Polish - maybe even our (former?) Norwegian Bill Thoen.

[Spencer Simpson]

<snark>

I don't know. Perhaps because It would be inconvenient for the largest number of people?

</snark>

 

---

Spencer

 

From: Peter Horsbøll Møller [mailto:mapi...@horsboll-moller.dk]
Sent: Wednesday, February 15, 2012 12:31 PM
To: mapi...@googlegroups.com
Subject: Re: [MI-L] Cosmetic to table

 

>> Myślę, że musimy być bardziej nastawenie do ograniczeń językowych w przyszłości, albo będę nalegać, że wszystkie pytania są zadawane w języku polskim 

[Bill Thoen]

We could try going back to the language of the educated that was so
popular before the "Renaissance Internet"... good old Latin (and Greek
for math). Once we got all the lame jokes out of everyone's system (like
"ubi sub ubi", etc) then we could all struggle with a second language
and MappaScientia-L would be the weirdest forum on the 'net.

We can't use Norwegian, because I know not of any web font for runes.

- Bill Thoen

On 2/15/2012 10:42 AM, Spencer Simpson wrote:
>
> <snark>
>
> I don't know. Perhaps because It would be inconvenient for the largest
> number of people?
>
> </snark>
>

> ------------------------------------------------------------------------
>
> Spencer
>
> *From:*Peter Horsbøll Møller [mailto:mapi...@horsboll-moller.dk]
> *Sent:* Wednesday, February 15, 2012 12:31 PM
> *To:* mapi...@googlegroups.com
> *Subject:* Re: [MI-L] Cosmetic to table
>
> />> Myślę, że musimy być bardziej nastawenie do ograniczeń językowych

> w przyszłości, albo będę nalegać, że wszystkie pytania są zadawane w

> języku polskim/

[Gentreau]

http://www.rune-fonts.co.uk/

- Bill Thoen

--

[Bill Thoen]

Amazing! A good font for when you DO have to write it in stone.

On Feb 15, 2012, at 6:57 PM, "Gentreau" <goo...@gentreau.com> wrote:

> http://www.rune-fonts.co.uk/
>
>
> -----Original Message-----
> From: mapi...@googlegroups.com [mailto:mapi...@googlegroups.com] On Behalf Of Bill Thoen
> Sent: 16 February 2012 05:31
> To: mapi...@googlegroups.com
> Subject: Re: [MI-L] Cosmetic to table
>

> We could try going back to the language of the educated that was so popular before the "Renaissance Internet"... good old Latin (and Greek for math). Once we got all the lame jokes out of everyone's system (like "ubi sub ubi", etc) then we could all struggle with second language and MappaScientia-L would be the weirdest forum on the 'net.