Support has been upgraded!
The Support Forum is closed. Not to worry! Providing the top quality support you expect and we're known for will continue! We're not ending support, just changing where you submit requests. This will provide you with the best experience possible.
Have you purchased an addon for Connections such as one of our premium templates or extensions with a valid license and you need help?
Please open a Support Ticket in your user account.
Are you using the free Connections plugin? Don't worry, you are still very important to us! We are still providing you with the same high quality support that we're known for.
Please open a new support topic in the WordPress support forums for Connections.
04/04/2019 at 10:57 am #488871
I am trying to import a lot of listings for a business directory under one particular category. When I go to Tools, select Import, choose a CSV file, then click upload, nothing appears to happen. The next step, which is being presented with the CSV mapping options, according to the documentation, does not materialize.
Am I doing something wrong? I need your assistance please.
Thank you.04/04/2019 at 1:58 pm #488881
Are you trying to import new entries or new categories (only)?
Assuming you are just importing categories…
As for the mapping step not showing, it sounds like an error is occuring during the processing that occurs after uploading the CSV file but before the mapping is displayed.
A lost of things may cause that to occur from a bad file to plugin / theme conflicts.
My first suggestion is to make sure the CSV being uploaded is a properly formatted CSV file.
Since this is a category import, the CSV file should contain only the following headers of which the last three are optional:
Name, Slug, Parent, Description
The exact names are not important since they can be mapped, but if you use the above names, they will be mapped automagically.
If you’ve already have done the above, the please try:
If that does not correct it, then move on to the conflict checks:
Hope this helps, let me know.04/05/2019 at 2:00 pm #488938
Okay here’s what I’m trying to do and you can tell me the best way to handle it:
I have a website that has multiple directories, each directory his it’s own category ID. I’m importing the directory listings for each category as a CSV file. I originally used the CSV import option but each of the categories have hundreds of listings. If I use CSV import I am having to open each entry and manually update the category ID which will take lots of time with hundreds of entries. Is there a way to have the CSV file import the entries with the correct category ID? Do I use CSV import? Do I use the import tab under Tools? What is the best way to import?
Thanks.04/05/2019 at 5:05 pm #48894704/08/2019 at 9:58 am #489088
RE: I’m importing the directory listings for each category as a CSV file.
You should use the CSV Import addon to import entries, not the bulk Category Import tool.
The bulk Category import tool only imports categories, nothing else … it can not associated imported categories to entries, for example.
RE: I originally used the CSV import option but each of the categories have hundreds of listings. If I use CSV import I am having to open each entry and manually update the category ID which will take lots of time with hundreds of entries.
If I understand correctly… when the entries were imported, they were not imported with their assigned categories. Is that correct? And now you wish add those category associations to the imported entries?
Probably the easiest solution is to export the entries using the Export All tool found on the Connections : Tools admin page under the Export tab at the bottom.
You would then edit the exported file to include the the categories that each entry should be assigned to. Then import that modified CSV file.
If I recall correctly, the import should update the existing entries with the associations to the categories.
I recommend doing a test import of only a row or two to verify if you get the desired result or not.
Hope this helps!04/09/2019 at 3:52 pm #489226
Doing the All Export did help by making it easier to edit the categories via CSV but when I imported the edited CSV file, the edited entries did not copy over the previous entries, creating duplicate listings for every entry. I need to do this process again because I have multiple categories to add entries for so is there a way to make sure the old entries are copied over?
Thanks.04/09/2019 at 4:11 pm #489227
RE: the edited entries did not copy over the previous entries
Did you remove the Entry ID column from the exported CSV file or not map it on import? That column must exist and those IDs must match the entry ID in the directory in order for the entry to be updated.04/09/2019 at 4:35 pm #489233
I did not remove the entry ID column. All of the fields appeared to be mapped correctly. The only thing I updated was the category for the listings that needed to be in the ‘restaurants’ category. I do have to do this process again for the other five categories I have entries for. I will see if this happens again.04/09/2019 at 4:46 pm #489234
Ok, you’ll know what it is doing by the status updates during imports. It say how entries added or updated.03/31/2020 at 6:21 pm #515790Jaclyn BrandtParticipant
Steven, how will this work if we have multiple categories for the same person? Should we include Name, Slug, Parent, Description multiple times, or can we put them in the same csv field, separated by commas?
I have been manually assigning categories after upload but I run 4 websites and they each send me a new member list each month and it’s just too much for me to update.
You must be logged in to reply to this topic.