×

Notice

The forum is in read only mode.
Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Importing comments from JomComment, Am I doing it right ?

Importing comments from JomComment, Am I doing it right ? 15 years 3 weeks ago #7579

  • Khalid A
  • Khalid A's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 9
  • Thank you received: 0
Hello,

I used JomComment for a while and then changed to JoomlaComment, after a couple of months of use i wanted to import my old comments from JomComment database.

When i try and hit "Import All" it just go to the home page and no comments get imported, is this because there is an ID conflict between tables ? because i thought JoomlaComment would automatically change or adapt the IDs from the old comment?

Anyway, is this the cause or there something else ?

Best regards.

Importing comments from JomComment, Am I doing it right ? 15 years 3 weeks ago #7580

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
if you send me a dump with jomcomment's comments I could try to import them locally and tell you if everything is fine, or if you have to change something

Importing comments from JomComment, Am I doing it right ? 15 years 3 weeks ago #7581

  • Khalid A
  • Khalid A's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 9
  • Thank you received: 0
Hello Daniel

So there shouldn't be an ID conflict ? even if an old comment has an id of 34 "in JomComment" and there is a new comment already with the ID of 34 "JoomlaComment" ?

I'm thinking of changing all of the IDs of JomComment manually.

Importing comments from JomComment, Am I doing it right ? 15 years 3 weeks ago #7582

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
To be honest, I don't know. I have to test it and see how the comments are imported.
I guess that we should not take the id of jomcomment, but who knows???(I didn't write the import function)

Importing comments from JomComment, Am I doing it right ? 15 years 3 weeks ago #7611

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
Ok, I tested it with your dump file.
For me the import went without any problem.

Joomlacomment adapted the ids. Actually the ids of jomcomment were saved in the importid field not in the id filed. And joomlacomment just added new ids for jomcomment.

After clicking importAll I got a message saying - import successful.

Importing comments from JomComment, Am I doing it right ? 15 years 3 weeks ago #7635

  • Khalid A
  • Khalid A's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 9
  • Thank you received: 0
Hello Daniel,

Thanks for the test.

Can you please PM me a dump of JomComment rows from Joomlacomment table so i can import them directly via phpmyadmin ?

The import is not working for me from Joomlacomment admin.

Importing comments from JomComment, Am I doing it right ? 15 years 3 weeks ago #7637

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
K, I will send you a dump on Tuesday(I'm on the road again :))

Importing comments from JomComment, Am I doing it right ? 15 years 3 weeks ago #7638

  • Khalid A
  • Khalid A's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 9
  • Thank you received: 0
Alright, take your time.

Thanks.

Importing comments from JomComment, Am I doing it right ? 15 years 2 weeks ago #7691

  • Khalid A
  • Khalid A's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 9
  • Thank you received: 0
Daniel, you haven't forget about me have you. :)

Importing comments from JomComment, Am I doing it right ? 15 years 2 weeks ago #7707

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
Guilty :(

Can you PM me your e-mail? I just made an export and I hope that it will work for you. It took me 50minutes to figure out how to export just the fields I want from phpmyadmin :)

Importing comments from JomComment, Am I doing it right ? 15 years 2 weeks ago #7711

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
K, e-mail sent. As I wrote in my e-mail: be carefull! test it first on a localhost or so.
  • Page:
  • 1
Time to create page: 0.131 seconds