Integration - Bulk Edits is there a CB_JUICE

After taking a look at the pgm that wanted $15 for basic scripting, I took a look and made a few mods that overlays the Juice Files. The attached JUICE version works with the current Joomla and CB version and has a few more fields added. I cannot promise it is perfect, but significantly better than the previous release. This version includes a mapping to the core CB table and built in email notifications.

Note that the text file now needs the $username,$password,$lastname,$firstname,$address,$email, $cb_primaryacct,$cb_occupation,$cb_homephone fields within it. Feel free to modify it for your own use as I did document it a little better than what was there previously and do not plan on supporting it as much as share with the rest of us.

I believe this would be a great enhancement to the standard CB or Joomla build.

Please use the revised version of the script minus my email accounts as I was spammed by 2k emails this evening. Thanks. - billt

Post edited by: billt, at: 2006/12/07 02:27

Sorry people but i have some problem to use this com:

I tried to import 3 test users but it's what happen:

ID name username email password

65 postmaster@telani.com test test@foo.foo 7e188043fdda8bf35f939f7b07e2fa2d registered 0 0 18 2006-12-17

66 mauro@telani.com tc001mt tc001mt@foo.foo 39bcd1cd5b541e3782af201d5eed4c32 registered 0 0 18 2006-12-17

where CSV was
test;dea404003c3a80819f73187842f5d1de;reg@belarus.it;;
tc001mt;39bcd1cd5b541e3782af201d5eed4c32;mauro.telani@belarus.it;;

or
test;dea404003c3a80819f73187842f5d1de;reg@belarus.it;;
tc001mt;39bcd1cd5b541e3782af201d5eed4c32;mauro.telani@belarus.it

if i try to move fields nothing change ...

some ideas???

Post edited by: tc001mt, at: 2006/12/17 00:50

try commas and not semi colons?

I have taken Billt's code and extended it. The problem problem that you are having is that split does not work well with complex files. It is almost useless for CSVs with fields containing embedded commas. I completely replaced the split part by using fgetcsv. I am about 75% finished with an almost complete rewrite of Juice to manage the extra CB profile fields and do a bulk replace from a CSV file. I am working on the code today to generalize it to arbitrary fields. I may even add a bulk edit if I get enough time. I will follow up with another message when I have posted the component.