Import listing

This topic contains 5 replies, has 3 voices, and was last updated by  Paolo 8 years, 10 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
  • Author
    Posts
  • October 26, 2016 at 9:02 pm #292400

    jnicolas
    Expired Member
    Post count: 2

    Hi,

    I got this error when trying to import a csv:

    

    Total 185 item(s) found.
185 / 185 item(s) could not be added due to blank/invalid address(city, region, country, latitude, longitude).
33 / 185 item(s) could not be added due to blank title/invalid post type/invalid characters used in data.
    

    Any idea?
    

    Thanks!
    

		
	
    


    

			
				

    

	
    

		October 26, 2016 at 10:12 pm

		
		#292478

		
		
		
	
    


    


    

	
    

		
		
    Guust
    Moderator
    
		
		
     Post count: 29970
    
	
    

	
    

		
		
    You must have missed some mandatory data or it is in the wrong format.
    
https://wpgeodirectory.com/docs/core-export/#mandatory
    

    If you attach the file we can have a quick look for you.
    

		
	
    


    

			
				

    

	
    

		October 27, 2016 at 8:20 am

		
		#292678

		
		
		
	
    


    


    

	
    

		
		
    jnicolas
    Expired Member
    
		
		
     Post count: 2
    
	
    

	
    

		
		
    I switched to OpenOffice to export to CSV.
    

    It has been a little better:
    

    

    Total 185 item(s) found.
46 / 185 item(s) added.
139 / 185 item(s) could not be added due to blank/invalid address(city, region, country, latitude, longitude).
    

    I attach the file.
    

    Another question, How can I add a default image for all imported listings?
    

		
	
    


    

			
				

    

	
    

		October 27, 2016 at 10:16 am

		
		#292716

		
		
		
	
    


    


    

	
    

		
		
    Guust
    Moderator
    
		
		
     Post count: 29970
    
	
    

	
    

		
		
    You should not change the order of the columns: https://wpgeodirectory.com/docs/core-export/#important
    

    To add a default image: GD > Design > Listings tab > Upload listing no image
    

		
	
    


    

			
				

    

	
    

		October 27, 2016 at 1:04 pm

		
		#292870

		
		
		
	
    


    


    

	
    

		
		
    jnicolas
    Expired Member
    
		
		
     Post count: 2
    
	
    

	
    

		
		
    I put all the columns in order and now get the same error:
    

    

    Total 185 item(s) found.
46 / 185 item(s) added.
139 / 185 item(s) could not be added due to blank/invalid address(city, region, country, latitude, longitude).
    

    See atached the new file.
    

    Thanks.
    

		
	
    


    

			
				

    

	
    

		October 27, 2016 at 3:01 pm

		
		#292962

		
		
		
	
    


    


    

	
    

		
		
    Paolo
    Site Admin
    
		
		
     Post count: 31211
    
	
    

	
    

		
		
    Hi,
    

    several mandatory fields have no data in it.
    

    I checked both addresses and cities. There could be other missing.
    

    Make sure to fill them all in before trying to import it again.
    

    Thanks
    

		
	
    


    

			
		
	
    • 

	
  • 

		
    Author
    

		
    

			
				Posts
			
		
    

	
    • 





			



	


		Viewing 6 posts - 1 through 6 (of 6 total)
	


	


		
	





		
				

			

				

					
We have moved to a support ticketing system and our forums are now closed.

					Open Support Ticket
				

			

		

		
	
	


			

			


		
	


		

	

	


















	
	
			
			
			
			
                        
            
            
                
                

                    

                        20% Discount Offer
                        
                        
                    

                    

                        Hurry! Get your 20% discount before it expires.
                        Get 20% Discount