CSV input

This topic contains 44 replies, has 10 voices, and was last updated by  phonebook 9 years, 3 months ago.

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

Open Support Ticket

Tagged: ,

  • 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 potiji@gmail.com 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
Viewing 15 posts - 16 through 30 (of 45 total)

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

Open Support Ticket