Kunena 7.0.4 Released

The Kunena team has announce the arrival of Kunena 7.0.4 [K 7.0.4] in stable which is now available for download as a native Joomla extension for J! 5.4.x/6.0.x. This version addresses most of the issues that were discovered in K 6.2 / K 6.3 / K 6.4 and issues discovered during the last development stages of K 7.0

Question Migration From Forum Skyportal.net (asp, MSSQL)

More
16 years 9 months ago #24950 by MDQdam
Migration From Forum Skyportal.net (asp, MSSQL) was created by MDQdam
Hello people, I wish to migrate from an old forum ( www.skyportal.net/ ) in asp and access that handles the date format of the varchar 20041014210729 Kunena int (11) 1190342548? that format is and how can I migrate it?
I have a friend who helped me with the script migracion but we stayed with the date format.
Any ideas for moving forward?

Translate from spnish by google.

Please Log in or Create an account to join the conversation.

More
16 years 9 months ago #25007 by sozzled
Replied by sozzled on topic Re:Migration From Forum Skyportal.net (asp, MSSQL)
G'day MDQdam. That's an interesting idea. You state that your MS SQL "dates" are of type varchar and not as type datetime. It should be possible to convert them into MySQL type int(11).

I would investigate dumping your part-converted MS SQL database into an Excel spreadsheet and work on a method to change the date/time strings into MySQL's date format. You should then be able to put the data back into a form that is suitable for importing into your MySQL database. That's the theory.

There are also commercially-available packages to convert MS SQL databases into MySQL.
Blue Eagle vs. Crypsis reference guide
Read my blog and
[img

Please Log in or Create an account to join the conversation.

More
16 years 9 months ago #25022 by MDQdam
Replied by MDQdam on topic Re:Migration From Forum Skyportal.net (asp, MSSQL)
Thanks sozzled for your interest in my problem.
My friend does not dominate MySQL.
Then copy the fields of Kunena on Access.
Then place this script to migrate data.
It worked OK.
But with value 0 in the (Time).
Code:
-- INSERT PORTAL_TOPICS IN JOS_FB_MESSAGES -- insert into dbo.jos_fb_messages_2007 (id, parent, thread, catid, name, userid, email, subject, time, ip, topic_emoticon, locked, hold, ordering, hits, moved, modified_by, modified_time, modified_reason) select TOPIC_ID, 0 as parent, 0 as thread, FORUM_ID, MSG_AUTHOR, T_AUTHOR, pm.m_email, T_SUBJECT, 0 as time, T_IP, T_MSGICON, 1 as locked, 0 as hold, 0 as ordering, T_VIEW_COUNT, 0 as moved, null as modified_by, null as modified_time, null as modified_reason -- CAT_ID, T_STATUS, T_MESSAGE, T_REPLIES, T_LAST_POST, T_LAST_POSTER, T_LAST_POST_AUTHOR, T_INPLACE, T_POLL, T_NEWS, T_SIG, MSG_AUTHOR from dbo.portal_topics pt join dbo.portal_members pm on pt.t_author = pm.member_id -- INSERT PORTAL_TOPICS IN JOS_FB_MESSAGES_TEXT -- insert into dbo.jos_fb_messages_text_2007 select TOPIC_ID, T_MESSAGE from dbo.portal_topics pt -- INSERT PORTAL_REPLY IN JOS_FB_MESSAGES -- insert into dbo.jos_fb_messages_2007 (id, parent, thread, catid, name, userid, email, subject, time, ip, topic_emoticon, locked, hold, ordering, hits, moved, modified_by, modified_time, modified_reason) select REPLY_ID + 1000, pr.TOPIC_ID as parent, 0 as thread, pr.FORUM_ID, pm.m_name, r_AUTHOR, pm.m_email, 'Re: ' + pt.T_SUBJECT, 0 as time, R_IP, R_MSGICON, 1 as locked, 0 as hold, 0 as ordering, pt.T_VIEW_COUNT, 0 as moved, null as modified_by, null as modified_time, null as modified_reason -- CAT_ID, T_STATUS, T_MESSAGE, T_REPLIES, T_LAST_POST, T_LAST_POSTER, T_LAST_POST_AUTHOR, T_INPLACE, T_POLL, T_NEWS, T_SIG, MSG_AUTHOR from dbo.portal_REPLY pr join dbo.portal_members pm on pr.r_author = pm.member_id join dbo.portal_topics pt on pr.TOPIC_ID = pt.TOPIC_ID -- INSERT PORTAL_TOPICS IN JOS_FB_MESSAGES_TEXT -- insert into dbo.jos_fb_messages_text_2007 select REPLY_ID + 1000, R_MESSAGE from dbo.portal_reply pr

Please Log in or Create an account to join the conversation.

Time to create page: 0.267 seconds