Importing more then one line in post_content column

This topic contains 14 replies, has 5 voices, and was last updated by  Paolo 9 years, 9 months ago.

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

Open Support Ticket
  • Author
    Posts
  • #34098

    MJJ Dam
    Expired Member
    Post count: 64

    Hi,

    It seems like I can’t import more then one line in the post_content column when using a .csv file. Is there a way to solve this?

    It does not work either if I use the example .csv file with multiple lines.

    Thanks.

    Matthijs

    #34102

    Guust
    Moderator
    Post count: 29970

    Hi Matthijs, just put everything on the one line. It will wrap once displayed on your site. You can use html, so just add a <br/> where you want a line break.

    #34142

    MJJ Dam
    Expired Member
    Post count: 64

    Hi Guust,

    It seems to work when adding <br/> but the strange thing is that I didn’t have to do this before.. Is there a way to fix this? Otherwise I will have to add +500 times a <br/>….

    #34154

    Paolo
    Site Admin
    Post count: 31206

    Hi,

    can you please provide an example of an imported listing were the description was automatically formatted?

    As far as I can see GD never created any formatting on CSV upload, so I’d be surprised to see one…

    Let me know,

    Thanks

    #34166

    MJJ Dam
    Expired Member
    Post count: 64
    This reply has been marked as private.
    #34176

    Paolo
    Site Admin
    Post count: 31206

    Hi,

    I’ve flagged this for developers to test.

    Thanks

    #34183

    MJJ Dam
    Expired Member
    Post count: 64

    Thanks

    #35005

    kcmarine
    Buyer
    Post count: 36

    I have the same issue and 9,000 listing. Any updates on the fix please Paolo.
    Thanks

    #35089

    Paolo
    Site Admin
    Post count: 31206

    Hi,

    this has been reported has fixed and tested since 1.4.0:

    https://wpgeodirectory.com/change-logs/#v1.4.0
    CSV upload not supports formatting in description – FIXED

    Did you test after the latest updates?

    Let us know,

    Thanks

    #35119

    MJJ Dam
    Expired Member
    Post count: 64

    Hi Paolo,

    I updated geodirectory and just tried it. It doesn’t work yet for my .csv file…

    -Matthijs

    #35120

    MJJ Dam
    Expired Member
    Post count: 64
    This reply has been marked as private.
    #35124

    Paolo
    Site Admin
    Post count: 31206

    Hi,

    this what the developers says:

    Description in formatting is supported with CSV upload.
    It is also working with sample csv file “place_listing.csv” and also tested with some other big size csv files.

    Attached CSV file “Zoekhulp-DE-database-WPGeodirectory-Orthopedie-database-september-2014-1.csv” has not valid csv format.

    It works fine when file opened and saved.

    I just read back your message and saw ” google spreadsheet”.

    You can’t use google spreadsheet for CSV files. Just like you shouldn’t use Excel.

    Only software like openoffice and libreoffice will work and keep correct CSV format.

    Thanks

    #35497

    MC1171611
    Full Member
    Post count: 180

    I’ve imported over 5,000 listings at different times using Google Docs to export the CSV and have never had a single problem. I wonder why that is…

    #35502

    MJJ Dam
    Expired Member
    Post count: 64

    I’ve always used Google Docs too and I never had any problem importing a .csv
    It worked perfectly. I think I will just use another program for it from now on, but if the programmers find what caused the error I’ll be happy to hear it.

    #35551

    Paolo
    Site Admin
    Post count: 31206

    The programmer confirms that only open office and libreoffice should be used to elaborate CSV files.

    (This information is available here : http://docs.wpgeodirectory.com/core-general/#csv since the very beginning)

    With any other softwares we can’t guarantee it will work.

    Thanks

Viewing 15 posts - 1 through 15 (of 15 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