Data Importing
Asked Modified Viewed 1,182 times
daimonbok1
daimonbok1 13
Into The Nebula! Is it Science or Science Fiction?
- Senior Member, joined since
- Contributed 626 posts on the community forums.
- Started 141 threads in the forums
- Started this discussions
Just a thought....Some of us have large link lists, it's a major pain adding them one at a time....If there was a way to import this type of data into Fusion's database it would be nice.
answered
Please grasp some very little SQL knowledge. This is the best way you can do it with custom data.
Once you're satisfied with the print dump, comment the print, and uncomment the dbquery_insert. Refresh and it will insert all 100k data you have.
Code Download source
$result = dbquery("SELECT <your columns> FROM <your old table>");
if (dbrows($result)) :
while ($data = dbarray($result) :
$new_insert_data = array(
'<new data column name>' => $data[<your old column name>],
'<new data column name>' => $data[<your old column name>],
'<new data column name>' => $data[<your old column name>],
'<new data column name>' => $data[<your old column name>],
'<new data column name>' => $data[<your old column name>],
'<new data column name>' => $data[<your old column name>],
'<new data column name>' => $data[<your old column name>],
'<new data column name>' => $data[<your old column name>],
'<new data column name>' => $data[<your old column name>],
);
print_p($new_insert_data);
//dbquery_insert(<your new table>, $new_insert_data, 'save');
endwhile;
endif;
Once you're satisfied with the print dump, comment the print, and uncomment the dbquery_insert. Refresh and it will insert all 100k data you have.
daimonbok1
daimonbok1 13
Into The Nebula! Is it Science or Science Fiction?
- Senior Member, joined since
- Contributed 626 posts on the community forums.
- Started 141 threads in the forums
- Started this discussions
Thanks Chan, I'll set up a new instance of fusion and give it a shot...Practice will make perfect.
Category Forum
Modifications and Requests - 9Labels
None yet
Statistics
- Views 0 views
- Posts 2 posts
- Votes 0 votes
- Topic users 2 members
2 participants
Chan 0
Lead Developer of PHP-Fusion
- Super Admin, joined since
- Contributed 3,842 posts on the community forums.
- Started 232 threads in the forums
- Answered 6 questions
daimonbok1 13
Into The Nebula! Is it Science or Science Fiction?
- Senior Member, joined since
- Contributed 626 posts on the community forums.
- Started 141 threads in the forums
- Started this discussions
Notifications
Track thread
You are not receiving notifications from this thread.
Related Questions