[Randy Carpadus]

Ok got the upload to work and it uploaded a jumbled mess. Names and organizations don’t match categories or email address. Completely wrong. Oh, and about 20-30 duplicated names on other peoples information!

Had to delete all 200+ entries (oh, and the “select all” check box doesn’t work!). Any idea why? Or how I get the entries to show up organization style?

[Steven Zahm]

@ Randy

I spun up a clean install of Connections and CSV Import, downloaded the last file that was attached and imported it. I used the mapping shown in the screen capture (my best guess). The import did occur fine, all 265 imported. I did a spot check, randomly, 10% of them, and the data was correct. There is only one issue, and that was with the source CSV data, line 199, Rock B. Valley Yellow Pages, has an invalid date of 00/00/0000. This invalid date seems to throw PHP for a loop and stops the page load. This is why the select all didn’t work for you. The script never had an opportunity to load because of the error. After removing that date, the page did load fine. I suggest you edit the entry, it should be visible on the manage page, and remove the dates. After you do, the select all will work.

A valid date is checked for during import, invalids are supposed to be tossed. Not sure why this invalid date was permitted to import. I’ll have to check that in the morning and release a bug fix.

My suggestion … delete your data and do the import again. Make sure you have no filters set on the Connections : Manage admin page when you delete the existing entries.

My best guess is that all the entries were not deleted from any previous attempts to import a CSV file. That would account for duplicates. Also since you were mapping the ID to the Entry ID in previous attempts, that would also explain why you had mixed data in the entries (because of previously existing data which was not deleted).

Attachments:

You must be logged in to view attached files.

[Randy Carpadus]

Thanks for the info. I had deleted everything, it was empty so not sure what happened there. I managed to get it loaded up. There were some other possible issues and I got those cleaned up.

Two questions. 1) Is there a search function other than selecting letter of the alphabet? Right now it’s sorted by the member’s name but people may want to search by business. 2) Is there a way to change as a whole form individual to organization or do I have to do it one at a time?

Thanks for everything.

[Steven Zahm]

@ Randy

Good to hear you have it going fine now!

re: Is there a search function other than selecting letter of the alphabet?
Yes. Many of the premium templates come with a user selectable category filter and keyword search. cMap is bar far the most popular template.

re: Is there a way to change as a whole form individual to organization or do I have to do it one at a time?
The one in the admin when adding an entry, yes? What can be done is set the Organization as the default entry type.

Install the Code Snippets plugin.
Add a new snippet with the following code:

function cn_default_entry_type( $atts ) {
		
	$atts['default']['type'] = 'organization';
		
	return $atts;
}

add_filter( 'cn_admin_metabox_publish_atts', 'cn_default_entry_type', 11 );

Save and Activate the snippet.

Now the default entry type should be Organization.

Hope that helps!

[Randy Carpadus]

Thanks for the info. I already have the 260 some odd companies and their representatives uploaded so does this script change all of them or do I have to go in and change them all to organization individually?

re: Is there a search function other than selecting letter of the alphabet?
Yes. Many of the premium templates come with a user selectable category filter and keyword search. cMap is bar far the most popular template.

Is this a template for the results or for the entire WP site? So as installed, there is no search function?

[Steven Zahm]

@ Randy

re: Is this a template for the results or for the entire WP site?
The search feature that is part of the template only searches the data within Connections, not the entire WordPress site. WordPress comes with its own basic search to perform that function.

re: So as installed, there is no search function?
The free Connection plugin includes keyword search only in the admin. Filtering by character, city, state and zip are included. The region filters can be enabled on the Connections : Settings admin page under the Advanced tab. Enabling these will turn those respective parts of the address within entries to link that when clicked by a users will filter the results based on the region that was clicked.

Hope that helps!

[Author]

Posts