Error: CSV upload does not work
This topic contains 20 replies, has 4 voices, and was last updated by Max Batt 6 years, 1 month ago.
We have moved to a support ticketing system and our forums are now closed.
Open Support Ticket-
AuthorPosts
-
August 27, 2019 at 12:32 am #505001
Hello,
After attempting an upload, I receive the following error:
“Not a valid CSV file” – even though this was exported from Google Sheets.
Thoughts?
Thank you!
Max
August 27, 2019 at 1:49 am #505014Please see https://wpgeodirectory.com/docs-v2/geodirectory/settings/import-export/#not-a-valid-csv-file
Thanks
PS: we recommend using LibreOffice or OpenOffice to edit CSV files.
August 27, 2019 at 4:30 am #505049Thank you so much for your quick reply, Guust.
So, we have followed your directions: installed the required plugin, and also installed on our machine Office Libre. When we save from OfficeLibre, we get a warning that we may be using improper characters from CSV – and when we upload this CSV to WordPress, it works, but we can a new error that says “post type missing”
Can you please advise on next steps? Thank you!
Max
August 27, 2019 at 6:48 am #505068Hi Max Batt,
Thanks for your reply. Could you please zip your CSV file and attach it on your next reply so that we could check this out for you?
August 27, 2019 at 7:23 am #505076This reply has been marked as private.August 27, 2019 at 7:33 am #505081Hello,
neither of these files will import correctly because they are not formatted correctly.
To get the correct format, log in to you site and add a listing or two. Fill in all the fields with representative data.
Then go and export the listings. That will give you a CSV file with the correct format.
Using Open or Libre office, merge your data into that file, being careful to preserver column headers and the order of the columns.
https://wpgeodirectory.com/docs-v2/geodirectory/settings/import-export/#recommended
August 27, 2019 at 7:37 am #505084Thank you, and to confirm this line you wrote:
To get the correct format, log in to you site and add a listing or two. Fill in all the fields with representative data.1.)…you mean, using custom fields, correct?
2.) Is there a place I can create these custom fields globally, so they *always* appear on a new “place” – I am asking because we will likely have hundreds of entires, and it would be great that, for new entries, these fields are just automatically seen on the backend rather than having to recreate all the custom fields (for each new entry).
Thanks!
MaxAugust 27, 2019 at 8:04 am #505093Custom fields are per CPT. Instructions are here:
https://wpgeodirectory.com/docs-v2/places/custom/When you add the field it will then show on the add listing page so you can fill it in.
August 29, 2019 at 6:24 pm #505582Thank you Alex,
I am looking to add the fields to the *backend* so that an admin can see and use these fields. In other words places > add new, this is where I would need the fields to show up.
I tried the instructions you shared, but it it does not add the fields to the backend, only something called the “place listing form”
Thanks!
MaxAugust 29, 2019 at 10:19 pm #505610Hello,
when you add a field, it will show in the backend editor form and the frontend editor form.
If that isn’t working for you, please share site credentials in a private reply and we will check it out.
Be sure to include more information like which CPT you are working with and which field is causing an issue.
Thanks
August 29, 2019 at 10:52 pm #505621This reply has been marked as private.August 29, 2019 at 11:36 pm #505630Can you check the password please?
ThanksAugust 29, 2019 at 11:45 pm #505634Just reset it – should work now!
August 30, 2019 at 1:09 am #505642You have renamed the title to “Program Name”, so in the backend that is still the Title field.
On the frontend “Title” is changed to “Program Name”.August 30, 2019 at 1:09 am #505643This reply has been marked as private. -
AuthorPosts
We have moved to a support ticketing system and our forums are now closed.
Open Support Ticket