Importing more then one line in post_content column

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

Open Support Ticket

Tagged: csv file, import, post_content column

Author

Posts
March 16, 2015 at 9:54 am #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

March 16, 2015 at 11:18 am #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.

March 16, 2015 at 3:53 pm #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/>….

March 16, 2015 at 5:47 pm #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

March 16, 2015 at 6:23 pm #34166

MJJ Dam
Expired Member

Post count: 64

This reply has been marked as private.

March 16, 2015 at 6:46 pm #34176

Paolo
Site Admin

Post count: 31206

Hi,

I’ve flagged this for developers to test.

Thanks

March 16, 2015 at 7:39 pm #34183

MJJ Dam
Expired Member

Post count: 64

Thanks

March 23, 2015 at 10:34 pm #35005

kcmarine
Buyer

Post count: 36

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

March 24, 2015 at 7:05 pm #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

March 24, 2015 at 9:24 pm #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

March 24, 2015 at 9:24 pm #35120

MJJ Dam
Expired Member

Post count: 64

This reply has been marked as private.

March 24, 2015 at 9:35 pm #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

March 29, 2015 at 4:20 am #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…

March 29, 2015 at 9:35 am #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.

March 30, 2015 at 3:27 pm #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
Author

Posts