CSV input

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

Open Support Ticket

Tagged: export, import

Author

Posts
April 27, 2014 at 8:32 pm #874

stroudsco
Expired Member

Post count: 121

I do keep coming across issues to be honest but then with some fiddling and going back to the original download csv I can upload places…

The biggest problem is to remove the block on requirement of city, region, zip etc…

If you do not have all of these completed the install will fail – I don’t have all this information and I think most won’t but I do have all my 7k listings geo coded..

I found even if i put in the words city under the city column and region under region etc I could then put my uncompleted address in the address field and complete the geo code and the place will upload.

I am still working on this and will update.

d

April 28, 2014 at 6:09 am #885

Vikas
Full Member

Post count: 1128

Hi NiteFader,

Will u please add that file which u tried to import ? or send me your site wp-admin login detail. You can add them in a message here and ‘Set as private reply’. I will be able to see that only.

Thanks

April 28, 2014 at 12:53 pm #911

stroudsco
Expired Member

Post count: 121

Ok…

I have cheated a little as i did before… I have got all my 7,000 companies into the new plugin…

The things I would recommend..

1) Only import 250 at a time.

2) You must have all the address and geo location columns filled in

3) It took me a night of playing around to get all the addresses in so its not to bad

I cheated as I would have had to have gone through my whole database and found the city, region, postcode etc for every listing which I don’t have and time would be against me.

I do have part address which I included in the address field and then just put the words ‘city’ in the city column ‘region’ in the region column etc and i will remove these from being shown in the listing.

I DID have all my listings geo coded though which is required to show the listing on the map!

Mine was a quick fixed to get all my listings live and then I can take time when I have it to correctly do things.

My site generates a fair amount of money so I had to do it this way.

I will update as and when I find that i have done things wrong 😉

Cheers

April 28, 2014 at 12:53 pm #912

nitefader
Expired Member

Post count: 86

This reply has been marked as private.

April 28, 2014 at 12:56 pm #914

nitefader
Expired Member

Post count: 86

Stroudsco: Mine is that after I choose the file. in the file dialog text box I see NULL…

Also any advice you can give me on how you generated such a buzzing business would be great. Please email me at [email protected] much appreciated!

Thanks!

April 28, 2014 at 1:01 pm #915

stroudsco
Expired Member

Post count: 121

nitefader,

Its all about content and not having a niche market, we have been in our industry for 25 years – we offer free listings and we publish content daily.

There is potential in these directory sites for over £100,000 a year with a lot of hard work.

I will try and post some do’s and don’ts that i have found if the admins want me to about the business side over the next few days.

Cheers

April 28, 2014 at 2:12 pm #922

nitefader
Expired Member

Post count: 86

Stroudsco… That would be greatly appreciated. Would you mind sharing your link to your site?

April 28, 2014 at 2:14 pm #923

stroudsco
Expired Member

Post count: 121

This is the staging site:

http://floordirectory.staging.wpengine.com

April 28, 2014 at 4:04 pm #926

nitefader
Expired Member

Post count: 86

Thanks @ stroudsco!

@Vikas any luck with my site CSV issue?

April 28, 2014 at 4:07 pm #927

stroudsco
Expired Member

Post count: 121

Nitefader whats your issue buddy?

Have you downloaded the sample csv?

You just then keep to populate that making sure to fill in address, city, region, postcode, country and lat and long the other fields I found were not required so much – then save it in open office (must use open office) then upload 250 at a time (no more or have problems).

🙂

April 29, 2014 at 4:47 am #947

Vikas
Full Member

Post count: 1128

Hi,

Please send me ur site link, wp-admin login detail and ftp if possible.
Mark the message as ‘Set as private reply’, i will be able to see that only.

Thanks

April 29, 2014 at 11:59 pm #1009

Rob F
Free User

Post count: 1

Hi,
I’m unable to import records, including the sample csv provided. I receive this notice:
Data inserted successfully.
Total of 0 records inserted.
Total of 3 records not inserted due to invalid address.
Please trasfer all images in ‘/wp_content/uploads /2014/04 ‘ folder.

I’ve tried editing the file and uploading only a single record many times without success. I’ve also tried many file formats including Excel CSV, .txt, CSV(Macintosh), and CSV(MS-DOS). Suggestions?

April 30, 2014 at 5:26 am #1023

Vikas
Full Member

Post count: 1128

Hi,

Make sure that u have enabled multilocation adons, if not then u can import data for default city only.

Please advise ?
Thanks

April 30, 2014 at 6:12 am #1031

Vikas
Full Member

Post count: 1128

Hi nitefader,

Plz send me ur site ftp userid and password too.

Thanks

April 30, 2014 at 11:14 am #1039

stroudsco
Expired Member

Post count: 121

YOU cannot use excel it doesn’t save in the correct format.

Download open office which is free.

I use a mac as well.
Author

Posts