- Posts: 1
 - Thank you received: 0
 
Import Placemarks from Excel File/CSV
- elitewebstl
 - Topic Author
 - Offline
 - New Member
 - 
            
         
        Less
        More
        
            
    
        
            
        
                13 years 4 months ago                #905
        by elitewebstl
    
    
            
            
            
            
            
                                
    
                                                
    
        Import Placemarks from Excel File/CSV was created by elitewebstl            
    
        I am working on a real estate project for a client, where they display properties bought/sold on the map as little placemarkers.  I have a large excel file with the addresses of all of the properties, and was wondering if there was a way to import these as placemarks, or if the addresses have to be added one by one.  Thanks!    
    Please Log in or Create an account to join the conversation.
- Dima
 - 
            
				
                                 - Offline
 - Platinum Member
 - 
            
         
            
        
                13 years 4 months ago                #907
        by Dima
    
    
            
Don't forget support my developments: post review in JED , donate , help with translation
        
    
            
            
            
            
            
                                
    
                                                
    
        Replied by Dima on topic Re: Import Placemarks from Excel File/CSV            
    
        Hi.
If you have knowledge MySql then yes, you can prepare insert clauses and execute it to load data into placemarks table
            If you have knowledge MySql then yes, you can prepare insert clauses and execute it to load data into placemarks table
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.
- twinbo
 - Offline
 - Junior Member
 - 
            
         
        Less
        More
        
            
    
        - Posts: 20
 - Thank you received: 0
 
            
        
                13 years 3 months ago                #1091
        by twinbo
    
    
            
            
            
            
            
                                
    
                                                
    
        Replied by twinbo on topic Re: Import Placemarks from Excel File/CSV            
    
        Great... I've an other question... and if I want change at runtime the icon placement ? I need to identify a placements shops with different icons Open/Close depend from date and time
thanks
    thanks
Please Log in or Create an account to join the conversation.
- twinbo
 - Offline
 - Junior Member
 - 
            
         
        Less
        More
        
            
    
        - Posts: 20
 - Thank you received: 0
 
            
        
                13 years 3 months ago                #1092
        by twinbo
    
    
            
            
            
            
            
                                
    
                                                
    
        Replied by twinbo on topic Re: Import Placemarks from Excel File/CSV            
    
        I can't find any xxx_zhgooglemaps_placemarks table  
    
    Please Log in or Create an account to join the conversation.
- Dima
 - 
            
				
                                 - Offline
 - Platinum Member
 - 
            
         
            
        
                13 years 3 months ago                #1093
        by Dima
    
    
            
Don't forget support my developments: post review in JED , donate , help with translation
        
    
            
            
            
            
            
                                
    
                                                
    
        Replied by Dima on topic Re: Import Placemarks from Excel File/CSV            
    
        Not placemarks, markers
I'll write a little tutorial after weekend about how you can load.
            I'll write a little tutorial after weekend about how you can load.
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.
- Dima
 - 
            
				
                                 - Offline
 - Platinum Member
 - 
            
         
            
        
                13 years 3 months ago                #1095
        by Dima
    
    
            
Don't forget support my developments: post review in JED , donate , help with translation
        
    
            
            
            
            
            
                                
    
                                                
    
        Replied by Dima on topic Re: Import Placemarks from Excel File/CSV            
    
        You can't dynamically change icons, it is rare case and I don't create this ability    
            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.
        Time to create page: 0.207 seconds