Joomla! Discussion Forums



It is currently Thu Nov 26, 2009 10:43 am (All times are UTC )

 


Forum rules

Global Rules
Additional Rules for this forum <------- Please read before posting



Post new topic Reply to topic  [ 115 posts ]  Go to page Previous  1, 2, 3, 4  Next
Author Message
Posted: Fri Apr 24, 2009 9:40 am 
User avatar
Joomla! Explorer
Joomla! Explorer
Offline

Joined: Sat Jul 05, 2008 3:56 am
Posts: 331
Location: Melbourne, Australia
Brilliant, moustik510 (do you have a name?). Thanks very much. Anyone else?

_________________
Pete Nurse
http://www.jix.com.au
Jix: The Joomla Import Export & Update Utility


Top
   
 
Posted: Sat Apr 25, 2009 9:17 am 
Joomla! Fledgling
Joomla! Fledgling
Offline

Joined: Thu Apr 23, 2009 8:02 am
Posts: 4
PtrNrs wrote:
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 :D

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'


Top
  E-mail  
 
Posted: Fri May 08, 2009 3:29 pm 
Joomla! Fledgling
Joomla! Fledgling
Offline

Joined: Mon Oct 06, 2008 3:13 pm
Posts: 1
PtrNrs wrote:
Michael, I've just checked it out again and it works OK for me.

Is it possible you entered the Name rather than the Username into the login form?


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


Top
  E-mail  
 
Posted: Sun May 10, 2009 10:22 am 
User avatar
Joomla! Explorer
Joomla! Explorer
Offline

Joined: Sat Jul 05, 2008 3:56 am
Posts: 331
Location: Melbourne, Australia
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.

_________________
Pete Nurse
http://www.jix.com.au
Jix: The Joomla Import Export & Update Utility


Top
   
 
Posted: Wed May 27, 2009 2:35 am 
User avatar
Joomla! Explorer
Joomla! Explorer
Offline

Joined: Wed Feb 28, 2007 5:40 am
Posts: 444
Location: Connecticut, USA
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

_________________
web • print • identity • creative
http://www.betweenbrain.com

Now listed on The Joomla Resources Directory™ -
http://resources.joomla.org/directory/other-services/consulting/betweenbrain.html


Top
  E-mail  
 
Posted: Wed May 27, 2009 10:16 pm 
User avatar
Joomla! Explorer
Joomla! Explorer
Offline

Joined: Sat Jul 05, 2008 3:56 am
Posts: 331
Location: Melbourne, Australia
betweenbrain wrote:
Error 200: Contacts in row 2 not found in SELECT `id`, `title` FROM #__categories;
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.

_________________
Pete Nurse
http://www.jix.com.au
Jix: The Joomla Import Export & Update Utility


Top
   
 
Posted: Thu May 28, 2009 12:44 pm 
User avatar
Joomla! Explorer
Joomla! Explorer
Offline

Joined: Wed Feb 28, 2007 5:40 am
Posts: 444
Location: Connecticut, USA
:-[ 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

_________________
web • print • identity • creative
http://www.betweenbrain.com

Now listed on The Joomla Resources Directory™ -
http://resources.joomla.org/directory/other-services/consulting/betweenbrain.html


Top
  E-mail  
 
Posted: Fri May 29, 2009 8:48 am 
User avatar
Joomla! Explorer
Joomla! Explorer
Offline

Joined: Sat Jul 05, 2008 3:56 am
Posts: 331
Location: Melbourne, Australia
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.

_________________
Pete Nurse
http://www.jix.com.au
Jix: The Joomla Import Export & Update Utility


Top
   
 
Posted: Tue Jun 02, 2009 11:39 am 
Joomla! Fledgling
Joomla! Fledgling
Offline

Joined: Tue Jun 02, 2009 11:26 am
Posts: 1
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:

Code:
   function GetSQLDataString($Data, $DataType)
   {
      //Get the delimiter for this field (either "'" or "":
      switch ($DataType)
      {
         case 'char':
         case 'varchar':
         case 'tinytext':
         case 'text':
         case 'mediumtext':
         case 'longtext':
            $RetVal = "'".addslashes($Data)."'";
            break;
         case 'date':
         case 'datetime':
         case 'timestamp':
         case 'time':
/*            $RetVal = "'".date('Y-m-d H:i:s', $Data)."'";*/
            $RetVal = "'".date($Data)."'";
        break;
         default:
            $RetVal = $Data;
            break;
      }
      return $RetVal;
   }


Last edited by ntol on Tue Jun 02, 2009 1:55 pm, edited 1 time in total.

Top
  E-mail  
 
Posted: Tue Jun 02, 2009 1:38 pm 
User avatar
Joomla! Explorer
Joomla! Explorer
Offline

Joined: Wed Feb 28, 2007 5:40 am
Posts: 444
Location: Connecticut, USA
Pete,

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

Best,

Matt

_________________
web • print • identity • creative
http://www.betweenbrain.com

Now listed on The Joomla Resources Directory™ -
http://resources.joomla.org/directory/other-services/consulting/betweenbrain.html


Top
  E-mail  
 
Posted: Mon Aug 03, 2009 3:40 pm 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Sun Mar 16, 2008 6:07 pm
Posts: 15
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


Top
  E-mail  
 
Posted: Tue Aug 04, 2009 1:38 pm 
User avatar
Joomla! Explorer
Joomla! Explorer
Offline

Joined: Sat Jul 05, 2008 3:56 am
Posts: 331
Location: Melbourne, Australia
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.

_________________
Pete Nurse
http://www.jix.com.au
Jix: The Joomla Import Export & Update Utility


Top
   
 
Posted: Tue Aug 04, 2009 2:08 pm 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Sun Mar 16, 2008 6:07 pm
Posts: 15
Well, there you go.

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


Top
  E-mail  
 
Posted: Wed Aug 05, 2009 10:13 pm 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Wed Apr 29, 2009 7:02 pm
Posts: 16
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.


Top
  E-mail  
 
Posted: Thu Aug 06, 2009 8:29 am 
User avatar
Joomla! Explorer
Joomla! Explorer
Offline

Joined: Sat Jul 05, 2008 3:56 am
Posts: 331
Location: Melbourne, Australia
@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!

_________________
Pete Nurse
http://www.jix.com.au
Jix: The Joomla Import Export & Update Utility


Top
   
 
Posted: Thu Aug 06, 2009 2:05 pm 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Wed Apr 29, 2009 7:02 pm
Posts: 16
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?


Top
  E-mail  
 
Posted: Thu Aug 06, 2009 2:20 pm 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Wed Apr 29, 2009 7:02 pm
Posts: 16
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)


Top
  E-mail  
 
Posted: Thu Aug 06, 2009 8:51 pm 
User avatar
Joomla! Explorer
Joomla! Explorer
Offline

Joined: Sat Jul 05, 2008 3:56 am
Posts: 331
Location: Melbourne, Australia
Yes, Joomla does an extra process that lengthens (and strengthens the password). To quote from another thread
Quote:
Joomla! 1.5 uses md5 to hash the passwords. When the passwords are created, they are hashed with a 32 character salt that is appended to the end of the password string. The password is stored as {TOTAL HASH}:{ORIGINAL SALT}.
The 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 Nurse
http://www.jix.com.au
Jix: The Joomla Import Export & Update Utility


Top
   
 
Posted: Thu Aug 06, 2009 10:02 pm 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Wed Apr 29, 2009 7:02 pm
Posts: 16
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


Top
  E-mail  
 
Posted: Fri Aug 07, 2009 4:04 am 
User avatar
Joomla! Explorer
Joomla! Explorer
Offline

Joined: Sat Jul 05, 2008 3:56 am
Posts: 331
Location: Melbourne, Australia
A couple of posts up I answered that one:-
Quote:
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.
I'll have a look at thos passwords when I get home from work.

_________________
Pete Nurse
http://www.jix.com.au
Jix: The Joomla Import Export & Update Utility


Top
   
 
Posted: Sun Aug 30, 2009 12:58 am 
Joomla! Fledgling
Joomla! Fledgling
Offline

Joined: Sat Aug 29, 2009 3:01 am
Posts: 4
Thank ntol, You've saved me

ntol wrote:
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:

Code:
   function GetSQLDataString($Data, $DataType)
   {
      //Get the delimiter for this field (either "'" or "":
      switch ($DataType)
      {
         case 'char':
         case 'varchar':
         case 'tinytext':
         case 'text':
         case 'mediumtext':
         case 'longtext':
            $RetVal = "'".addslashes($Data)."'";
            break;
         case 'date':
         case 'datetime':
         case 'timestamp':
         case 'time':
/*            $RetVal = "'".date('Y-m-d H:i:s', $Data)."'";*/
            $RetVal = "'".date($Data)."'";
        break;
         default:
            $RetVal = $Data;
            break;
      }
      return $RetVal;
   }


Top
  E-mail  
 
Posted: Wed Sep 09, 2009 8:32 pm 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Fri Mar 28, 2008 11:36 am
Posts: 21
Hi all,

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

Please confirm.
www.jix.com.au/

Regards


Top
  E-mail  
 
Posted: Thu Sep 10, 2009 6:09 am 
User avatar
Joomla! Explorer
Joomla! Explorer
Offline

Joined: Sat Jul 05, 2008 3:56 am
Posts: 331
Location: Melbourne, Australia
CloneLab wrote:
I hate to be the barrier of bad news but the website is down!?

Hi CloneLab,

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

_________________
Pete Nurse
http://www.jix.com.au
Jix: The Joomla Import Export & Update Utility


Top
   
 
Posted: Fri Sep 11, 2009 12:45 am 
User avatar
Joomla! Explorer
Joomla! Explorer
Offline

Joined: Sat Jul 05, 2008 3:56 am
Posts: 331
Location: Melbourne, Australia
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.

_________________
Pete Nurse
http://www.jix.com.au
Jix: The Joomla Import Export & Update Utility


Top
   
 
Posted: Fri Sep 11, 2009 7:08 pm 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Fri Mar 28, 2008 11:36 am
Posts: 21
I'm sorry but I can still not access page.

Server not found.


Top
  E-mail  
 
Posted: Tue Sep 29, 2009 5:42 am 
Joomla! Fledgling
Joomla! Fledgling
Offline

Joined: Mon Sep 28, 2009 6:10 pm
Posts: 3
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.


Top
  E-mail  
 
Posted: Thu Oct 01, 2009 4:52 am 
Joomla! Fledgling
Joomla! Fledgling
Offline

Joined: Mon Sep 28, 2009 6:10 pm
Posts: 3
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`, 8) AS `id`, SUBSTR(`link`, 8) 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


Top
  E-mail  
 
Posted: Thu Oct 01, 2009 2:06 pm 
Joomla! Fledgling
Joomla! Fledgling
Offline

Joined: Thu Oct 01, 2009 1:50 pm
Posts: 1
Quote:
Jix Translators Needed!

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... 8)
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... :)


Top
  E-mail  
 
Posted: Tue Oct 06, 2009 9:19 am 
User avatar
Joomla! Explorer
Joomla! Explorer
Offline

Joined: Sat Jul 05, 2008 3:56 am
Posts: 331
Location: Melbourne, Australia
jooWhat wrote:
"Error 200: Jix Section in row 2 not found in SELECT `id`, `title` FROM `#__sections` UNION SELECT SUBSTR(`link`, 8) AS `id`, SUBSTR(`link`, 8) AS `title` FROM `#__components` WHERE `link` LIKE ""option=%"" ORDER BY `title`;
Failed"
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.

_________________
Pete Nurse
http://www.jix.com.au
Jix: The Joomla Import Export & Update Utility


Top
   
 
Posted: Thu Oct 08, 2009 4:15 pm 
Joomla! Fledgling
Joomla! Fledgling
Offline

Joined: Mon Sep 28, 2009 6:10 pm
Posts: 3
Thank you so much for your help.

The download worked perfectly!


Top
  E-mail  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 115 posts ]  Go to page Previous  1, 2, 3, 4  Next

Quick reply

 



Who is online

Users browsing this forum: Dupi, KPA, pe7er and 31 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group