Using Importer.php: WSN Support

Using Importer.php
Some Links Not Importing

Using Importer.php

BarbaraF
Beginner

Usergroup: Member
Joined: Jul 31, 2004
Total Topics: 1
Total Posts: 3

Posted 10/19/04 - 02:16 PM:	#1
I have over 4000 links in a XLS that I want to add to WSNLinks. I have exported 20 of them into a sample.txt to try out importer.php. Out of the 20 links, only 10 are importing. I tried another file with just 6 links (ones that didn't import.) And none of those 6 are being imported. I get the correct response in my browser (Adding BLAHBLAH to category XX) but the records are NOT being added to the MySQL database. Any help or suggestions will be appreciated. Thanks,

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 55
Total Posts: 5726

Posted 10/20/04 - 09:58 AM:	#2
Have you checked to be sure the separators you've specified in importer.php are consistently being used by all links in your file? You could also try the spreadsheet/phpmyadmin method described in the manual.

BarbaraF
Beginner

Usergroup: Member
Joined: Jul 31, 2004
Total Topics: 1
Total Posts: 3

Posted 10/20/04 - 02:07 PM:	#3
>>>Have you checked to be sure the separators you've specified in importer.php are consistently being used by all links in your file? .. Yes.. the sample file is very small,,, so this is pretty easy. >>>You could also try the spreadsheet/phpmyadmin method described in the manual. MyPHPAdmin doesn't seem to let me upload a text file. I even tried MySQL LOAD DATA INFILE command at the shell prompt...but wasn't able to get my permissions right ... It said "access denied"

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 55
Total Posts: 5726

Posted 10/22/04 - 02:17 AM:	#4
I can't find a csv upload option either... I don't know what mrkarron used, then.

BarbaraF
Beginner

Usergroup: Member
Joined: Jul 31, 2004
Total Topics: 1
Total Posts: 3

Posted 10/22/04 - 08:56 AM:	#5
Paul, On the 2.1.0 version of PHPMyAdmin used on my server, in the table view (that is click on wsnlinks_links) there is a link titled "Insert textfile into table." This form builds a mySQL "Load Data Infile" statement for you. But then I get a response saying basically "that command is not allowed on this version of MySQL." In researching this, I see that some installations do NOT allow "Load Data Infile" for security reasons.... #!@#@@ I don't actually know if that is my particular problem, or whether it's something else. As I said, when I try the "Load Data infile" statement directly at my mysql prompt, I get a message about improper permissions for my username. So... I'm back to trying to figure out why importer.php is inserting only about 40% of my sample links. Why doesn't it like the others?

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 55
Total Posts: 5726

Posted 10/22/04 - 01:50 PM:	#6
Text file means a .sql file, doesn't it? Not a csv. So... I'm back to trying to figure out why importer.php is inserting only about 40% of my sample links. Why doesn't it like the others? Well, perhaps if I knew what data you were and what importer.php you were using using it would make it more possible to comment.

tradenet
Experienced

Usergroup: Customer
Joined: Oct 14, 2004
Total Topics: 16
Total Posts: 55

Posted 10/27/04 - 11:25 AM:	#7
Can someone tell me what format this file has to be in to use importer.php? It asking for a URL to a file. I'm just not sure what format it has to be in. Thnx

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 55
Total Posts: 5726

Posted 10/28/04 - 02:48 AM:	#8
importer.php is designed to handle a number of formats. You need to edit it to specify.

You don't have permission to post.