thx

Hi!

I have what has become a one time or short term 50,000 record use for CB. So I know a little now about this process.

CBJuice2 can handle as much as your server will allow. I tried a 10,000 records and got to 4200 installed before a time out. That is not the real question or issue! It is managing the file upload errors. Right now there is a problem on firstname, lastname. middlename with in CBJuice2. (The Script is not a bad idea in itself. I like it for what it does.) It is probably suffering from all the version changes going on right now.

If there is a space in the name and not hyphenated as in a lastname; it will not import that record. You have to tag it and correct it in a new file to make it acceptable.

Also the turn OFF emails to user switch is not working. You will have to disable your email address in Joomla backend. I suggest not having any emails to upload. Its just to scary. As it will email everyone of your valuable members with a spam emailing. (Not Cool!) Also it generates an invalid.com email for any records with empty email fields. (What if you do not want email addresses?) So in other words if you have a newsletter plugin adapted with CB, you will now have 10,000 false emails as prescribed members to you newsletter. (That is not cool at all.) What if you want to do a search on members with email addresses? I tried turning off every switch imaginable including those in CBGoJive. But the CBJuice2 still loaded it all into my newsletter! (Bummer!)

I need rock solid accessible use of my files in a relational database. CB is really fine for a beginning development with larger flat files and it has features for linking with other tables. I like that feature a lot. What I love about CB is you can develop an integration of software packages from the Joomla side of your server as a pro-consumer. It will in effect accomplish everything that you might want. You have to find the time to piece it together and learn the programs.

But if you have 10,000 records. (Really if even 1000!) I would want to look into how a program such as Access or maybe OpenOffice.org would be able to update this file from the actual server side.

And certainly, I would want to not install invalid emails as a requirement. etc. This is a huge limitation and annoyance that the casual user will not enjoy. As a result you will need to look at other tools to implement your database. And then find a way to link it using other tools.

I hope this helps you skoegler!

Hopefully the CB team will come up with a very refined export-import feature that addresses these important needs. I know they are working on it now for this year some time.

Please any suggestions from more seasoned users of Joomla or CB.

Thanks!

Thanks TC Tops !

I think you hit it... my list has plenty of space-separated names. Fortunately I should be able to resolve that and reimport... again.

One twist; I have Acymailing connected, and on the first import, the plugin inserts a bogus value for the name field (gets the email address correct). I found that importing a second time replaces the bogus name with the real name.

So this combination of spaces and bogus names at least gives me somewhere to go.

Thanks again. I'm certain that will take care of it... I'll report back with results.

As krileon said, CBJ questions should be asked in the CBJuice forum.

Regarding email upon user addition... this is a Joomla issue... Nant has issued a workaround here

Regarding spaces in names...are your fields enclosed in quotes in the import file?

Thank you Wolvertine! What does Nant mean by his statement? In the work around. Does he mean comment OUT those two lines?