- Posts: 34
- Thank you received: 0
[SOLVED] Exportation in Excel sheet
- babu1965
- Topic Author
- Offline
- Junior Member
Less
More
8 years 10 months ago - 8 years 10 months ago #8107
by babu1965
[SOLVED] Exportation in Excel sheet was created by babu1965
Hi,
I’m using Zh component and module, so I’d like export in a Excel sheet the following fields from every placemark in the map :
Title – Description – Latitude - Longitude – category
I’ve try export by phpMyAdmin the DB to an Excell file but I can’t find the fields of mine interest.
I’ve search for solution on the Zh documentation but I can’t find it.
Anybody have an idea about?
Thanks in advance
I’m using Zh component and module, so I’d like export in a Excel sheet the following fields from every placemark in the map :
Title – Description – Latitude - Longitude – category
I’ve try export by phpMyAdmin the DB to an Excell file but I can’t find the fields of mine interest.
I’ve search for solution on the Zh documentation but I can’t find it.
Anybody have an idea about?
Thanks in advance
Last edit: 8 years 10 months ago by babu1965.
Please Log in or Create an account to join the conversation.
- babu1965
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 34
- Thank you received: 0
8 years 10 months ago #8115
by babu1965
Replied by babu1965 on topic Exportation in Excel sheet
I probably found the right system to get what is required in my post. In fact exporting from phpMyAdmin table DB zhgooglemaps_markers get all data of my interest.
Thanks anyway
Thanks anyway
Please Log in or Create an account to join the conversation.
- Dima
- Offline
- Platinum Member
8 years 10 months ago #8116
by Dima
Don't forget support my developments: post review in JED , donate , help with translation
Replied by Dima on topic Exportation in Excel sheet
Hi
Sorry for delay. Yes. It is table, where I store placemark's data
Sorry for delay. Yes. It is table, where I store placemark's data
Don't forget support my developments: post review in JED , donate , help with translation
Please Log in or Create an account to join the conversation.
- babu1965
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 34
- Thank you received: 0
8 years 10 months ago #8233
by babu1965
Replied by babu1965 on topic Exportation in Excel sheet
Hi Dima,
thanks anyway for your wonderful component.
Can you indicate me if is possible have the same placemark in 2 different maps, without make one per map?
Thanks in advance
thanks anyway for your wonderful component.
Can you indicate me if is possible have the same placemark in 2 different maps, without make one per map?
Thanks in advance
Please Log in or Create an account to join the conversation.
- Dima
- Offline
- Platinum Member
8 years 10 months ago #8234
by Dima
Don't forget support my developments: post review in JED , donate , help with translation
Replied by Dima on topic Exportation in Excel sheet
Hi.
Yes. If you have placemarks on different maps, and want to show it in a new one you can do it a few ways:
1 - call plugin and pass to it your placemarks
* Only one placemark
wiki.zhuk.cc/index.php?title=Zh_GoogleMa...how_Map_by_Placemark
* One or more than one on special map
wiki.zhuk.cc/index.php?title=Zh_GoogleMa...ap_by_Placemark_List
* If you want to show placemarks assigned to some categories
wiki.zhuk.cc/index.php?title=Zh_GoogleMa...Show_Map_by_Category
* or assigned to some groups
wiki.zhuk.cc/index.php?title=Zh_GoogleMa...p_by_Placemark_Group
2 - for menu item (component call) you can also define what placemarks, groups, categories you want to show. In this case all filter fields works by AND
Yes. If you have placemarks on different maps, and want to show it in a new one you can do it a few ways:
1 - call plugin and pass to it your placemarks
* Only one placemark
wiki.zhuk.cc/index.php?title=Zh_GoogleMa...how_Map_by_Placemark
* One or more than one on special map
wiki.zhuk.cc/index.php?title=Zh_GoogleMa...ap_by_Placemark_List
* If you want to show placemarks assigned to some categories
wiki.zhuk.cc/index.php?title=Zh_GoogleMa...Show_Map_by_Category
* or assigned to some groups
wiki.zhuk.cc/index.php?title=Zh_GoogleMa...p_by_Placemark_Group
2 - for menu item (component call) you can also define what placemarks, groups, categories you want to show. In this case all filter fields works by AND
Don't forget support my developments: post review in JED , donate , help with translation
Please Log in or Create an account to join the conversation.
- babu1965
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 34
- Thank you received: 0
8 years 10 months ago #8238
by babu1965
Replied by babu1965 on topic [SOLVED] Exportation in Excel sheet
Thanks a lot Dima,
I think the better way for me is the second one.
To be exact I don't need of 2 maps,(I had thought 2 because at the first time I had thought a different solution with 2 maps, one of they visible on fronend and one invisible) but really I need one only visible map, where there are for example the category placemark A B C visible and other categories Y Z invisible, so later when I'll export the placemark from the sql DB I'll have all categories of they in my file CSV and I will be able sort or filter they by category
I think the better way for me is the second one.
To be exact I don't need of 2 maps,(I had thought 2 because at the first time I had thought a different solution with 2 maps, one of they visible on fronend and one invisible) but really I need one only visible map, where there are for example the category placemark A B C visible and other categories Y Z invisible, so later when I'll export the placemark from the sql DB I'll have all categories of they in my file CSV and I will be able sort or filter they by category
Please Log in or Create an account to join the conversation.
Time to create page: 0.188 seconds