Joomla! Discussion Forums

Brilliant, moustik510 (do you have a name?). Thanks very much. Anyone else?

Moustik (mosquito) is my nickname and moustik510.net is my website so I use it anytime

Thanks to Jix I imported sections, categories, content and comments from B2Evolution. I used a homemade php utility to convert B2Evolution database to the needed CSV files.

On my free time I'll share the PHP utility (DBExport.php) and write an article 'From B2Evolution to Joomla using DBExport.php and Jix'

Hi, I am having the same problem. I have a list of just over 5000 users I need to import into my Joomla! 1.5 site. I tested JIX successfully with 5 names, so I fed it the whole list. That didn't work. The records were created, but I couldn't log in with any of the usernames. I cleared jos_users of the records I imported and tried again with 500 names. Again, it appeared to work, but I still can't log in with any of the usernames.

I started to suspect the password encryption (my list is using plain text in the password field). When I used phpMyAdmin to look at the existing users versus the imported users, the length of the encrypted passwords were significantly different. Those from the JIX import were extremely short by comparison.

Any ideas as to why this would be happening and what I can do to fix it? The new site is waiting in the wings, with this being last piece to figure out. My boss is getting very cranky about the delay.

Thanks,
Paul

Michael,

If you'd like to send me a copy of your CSV file (with confidential info obscured, of course), I'll have a look at it for you.

Hi Pete,

Fantastic component! I hope to get my head around it soon (you're making me think).

I'm test driving it right now and experiencing the following error when trying to import your sample contact_details_044.csv:

Error 200: Contacts in row 2 not found in SELECT `id`, `title` FROM #__categories;

Everything else worked fine up until that point. Any ideas?

Thanks!

Matt

This means that Jix is expecting that under Components->Contacts->Categories, there is a Category called "Contacts". Pretty sure this is standard in the Joomla default configuration.

Just add the category "Contacts" and see what happens.

My apologies. In retrospect, that should have been obvious. Once the category of Contacts was created, it worked fine. I guess shouldn't being trying these kinds of things at 2:30am.

I see, based on the example files provided, that a user must exist before it's associated contact record can be. Would it be possible to import Contact details without requiring the user to exist by simply eliminating the user_id field?

I'm looking at doing a mass-import of Contact records for a site. My initial approach was to do an SQL query to append the Contacts table, but long-term I see that this tool could be very handy and convenient (once I get my head wrapped around it).

Thanks for your help and this fantastic contribution!

Matt

Matt,

I haven't done it but you should be able to delete the user_id field OK (it's not mandatory).

Or you just enter contacts - which I think might be a neater way of doing it.

I have somewhat the same problem as moustik510 had. When I import content in verbose mode all date fields are set to 1970-01-01 01:33:29. In my import file these fields are set as 2009-02-06 13:32:01. And nothing gets imported!

Can someone please help me, I have to import a lot of articles and this extension seems perfect for the job.

ps. I've added all content table fields from the mysql database. (e.g. created,publish_up etc......)

*edit:

I've changed some code in jix.php, after that the import goes fine:

Pete,

Thanks! I'm still waiting for my data, but when I get it I'll give that a shot.

Best,

Matt

Pete,

I'm sorry, but I must be dense. I'm trying to install and use Jix locally to test before using on my production. I can't, however, do anything past the installation. I see 4 tabs: configuration, tables, indexes and fields. And that's it.

What's the next step? Your introduction pdf displays other tabs, like contact details (which is what I'm trying to import), etc., but not my install. Is there something I missed somewhere? What's to complete after installation?

Thanks

Yes, you have missed something.

On the download page, it says:-

Note!: Jix configuration files (jix_tables_044.csv, jix_fields_044.csv & jix_indexes_044.csv) required to import Joomla user data are included in the administrator\components\com_jix\import\jix_users folder of the zip file.

Well, there you go.

Thanks, Pete. I plan on making a donation soon, BTW, you've done great work.

I'm having a similar problem as others. I imported my users and they came in fine. But only the very first password in the CSV works. All the others didn't come across.

Is there a solution?

Do I have to delete my users and try again? I unfortunately didn't notice this and have already used Acajoom for my users to sign up for newsletters, etc. I would hate to lose all of that. I've tested importing users with another component using a development site and it works fine, but it won't update users, just create them.

@wbaccus:
Puzzling!

If you have access to phpMyAdmin via CPanel or similar, please check whether the passwords have been imported (they will be encoded).

If passwords have been imported at all it's very unlikely that the passwords were wrong.

If you can do the import again, set the Verbose parameter and see if you can diagnose anything.

Good luck!

That's the weird thing. There is data there.

Also, I was using Jix 0.014 to do this.

I noticed that there's a Jix 0.020, so I downloaded that. But after installing it, there's no tab in Jix for Users and Contacts anymore... just the Tables, Fields, and Indexes.

How do I attempt an import of users_044.csv with Jix 0.020?

I did a verbose import and here's what I got:

All imported successfully.

But I notice that the first 5 users' encrypted password displays as being this long:
6d602f0371bfd238ec2379bacda154a1

And the other 631 are this long:
8RTsRaQU6UrB

The shorter ones won't work. (this was with Jix 0.014)

Yes, Joomla does an extra process that lengthens (and strengthens the password). To quote from another threadThe first password you quote is the salted password - the others were generate by Jix.

The other point is that Jix 0.014 was superseded some time ago by V0.020. Many people have imported user data (as you are) with 0.020.

An idea: Email me one or two unencrypted passwords (choose from the short Jix style passwords) and I'll encode them and send them back to you. This should be exactly what you've got in the database.

Note: Please do not send me any identifying data - passwords only no user names.

Pete: Thanks for all of the help. I actually have been trying to import the users using Jix 0.020, but I can't figure out how. The user and contact panes are gone. In Jix 0.020 on both my live and development servers. In the YouTube video, I see them in the interface, but they don't appear on my end.

I can just blow all the user data away and start over, my original concern about people already having set up some options didn't make much sense when I thought about it—If they can't login, then they can't have set up options in other components.

Unencrypted passwords:
GOQYDZ
NR7T92

A couple of posts up I answered that one:-I'll have a look at thos passwords when I get home from work.

Thank ntol, You've saved me

Hi all,

I hate to be the barrier of bad news but the website is down!?

Please confirm.
www.jix.com.au/

Regards

Hi CloneLab,

Seems that I'm the bearer of good news . . . the website's up - at least for me!

Important Security Issue!

All released versions of Jix have a security issue that requires your immediate attention.

Jix does not automatically delete Jix conguration files from the following directories on your web site:-

administrator/components/com_jix/export;
administrator/components/com_jix/import.

These files may then be accessed by non-authorised people.

I recommend that you either:-

delete any such files immediately or
uninstall Jix after use.

I'm sorry but I can still not access page.

Server not found.

I am hoping someone here can help.

I have tried everything I can think of, even getting the hosting company to check and/or turnoff any Mod_Sec that the script may be hitting.

This:
"On the download page, it says:-

Note!: Jix configuration files (jix_tables_044.csv, jix_fields_044.csv & jix_indexes_044.csv) required to import Joomla user data are included in the administrator\components\com_jix\import\jix_users folder of the zip file."

Doesn't resolve the issue, I am already doing that. I downloaded the 'com_jix0023.zip' file and these files were not included, but were easily found on the website as separate downloads for 'Users' and 'Content'. When I upload and import, it adds the new rows to the tables, but doesn't update the admin and/or create the new tables.

This is what the admin always say's, no mater what I try:

Configuration | Jix Tables | Jix Fields | Jix Indexes

It will not add new ones.

I would like to be able to upload some content from csv files. I've tried everything as shown in the pdf and the videos. Is there a way of downloading an older version of jix? Maybe this newest version has an issue. The security concern doesn't bother me, I can uninstall after each use if I need to, or manually delete the exposed files, I just want it to work.

Thanks.

Making some headway here. The previous issue was resolved with a manual install of Joomla instead of the Fantastico auto-install.

I can create all the tables now, but when I try to import the 'content' csv I get the following error:

"Error 200: Jix Section in row 2 not found in SELECT `id`, `title` FROM `#__sections` UNION SELECT SUBSTR(`link`, AS `id`, SUBSTR(`link`, AS `title` FROM `#__components` WHERE `link` LIKE ""option=%"" ORDER BY `title`;
Failed"


I have manually changed the 'Jix Section' in the Sections table to row 2, ID 2 etc... this didn't seem to make any difference. I looked in the 'components' table and found the following entry:

51 Jix option=com_jix 0 0 Jix com_jix 0 .....etc

I will translate Jix to Spanish_CL, i try to make neutral spanish to Latinamerica, (except Argentina that guys reivented the spanishhhh ).

Related to the Spanish, i detected some problems with Jix import data with accents (´), i have categories with accents and when import contacts get the following error:

Error 200: 'Unidad Tecnolog�as de la Informaci�n' in row 2 not found in SELECT `id`, `title` FROM #__categories;

i make test without the accents and works fine... but that is not a solution for me...
now i tried to found the way to import data with accents....

Regards!!

By the way!! Excellent Utility!!!

PD: i hope understand my poor english...

Sorry didn't see this until now.

There was a problem in this area with this cell in the file jix_fields_044.csv supplied for content import.

Try the latest version and see how you go.

Thank you so much for your help.

The download worked perfectly!