Data Source(Import Data from external XML)

serbill
(@serbill)

12 years, 10 months ago

Hi! First of all congrats for the excellent work!
I made some tests for the xml import so here is the problem.

I am using the plugin Version 0.3.3. I have a test table called wp_dbt_goodys. Fields is goodysID name price.
–goodysID int(11)AUTO_INCREMENT
–name text
–price text
I am able to edit and read the database fields using the shortcode inside a post and everything works great.

I need to go one step further and import XML data from http://www.w3schools.com/xml/simple.xml into wp_dbt_goodys table.
Settings I have in tab data source:
Source URL: http://www.w3schools.com/xml/simple.xml
Root Node: breakfast_menu
Table Field Source Field
goodysID BLANK
name —–name
price —–price

Data Source Call: http://www.i-contact.gr/xml/dt_intfc51e532251612d/import

When trying to run the import URL from browser I get this
“Not Found
The requested URL /xml/dt_intfc51e532251612d/import was not found on this server.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.”

When trying to run from linux terminal:
wget -O – http://www.i-contact.gr/xml/dt_intfc51e532251612d/import
–2013-07-18 11:56:11– http://www.i-contact.gr/xml/dt_intfc51e532251612d/import
Resolving http://www.i-contact.gr… 94.75.229.115
Connecting to http://www.i-contact.gr|94.75.229.115|:80… connected.
HTTP request sent, awaiting response… 404 Not Found
2013-07-18 11:56:11 ERROR 404: Not Found.

I am not sure where to check for the problem…
Any ideas?
http://ww.wp.xz.cn/extend/plugins/db-toolkit/

Viewing 8 replies - 1 through 8 (of 8 total)

Thread Starter serbill
(@serbill)

12 years, 10 months ago

I was trying to short this out but there was no result.
I think this is a developer’s issue…

Thread Starter serbill
(@serbill)

12 years, 10 months ago

I am not able to find a solution.

Dear Developer is there any update you can give me about this?
I know that import is experimental but do you have any estimation about this?

Thanks in advance!:-)

Plugin Author David Cramer
(@desertsnowman)

12 years, 10 months ago

What is the site where wordpress is installed?

Thread Starter serbill
(@serbill)

12 years, 10 months ago

Hi David!

http://www.i-contact.gr/xml
http://www.i-contact.gr/xml/wp-admin
admin
123

feel free to play to do anything you need. This is a test installation

Plugin Author David Cramer
(@desertsnowman)

12 years, 10 months ago

The XML import requires permalinks to be set.
I set them and its now working.

Thread Starter serbill
(@serbill)

12 years, 10 months ago

Oh sorry about that I wasn’t aware. Thanks!

Is there a setting I can change in order to update the existing fields instead of writing new entries in the db?

Or is this something that requires development by your side?

Thread Starter serbill
(@serbill)

12 years, 10 months ago

Forgive me if the bellow are mistaken I am not a programmer but I can read some code.
I just had a look at your code. data_report\class.php

echo $in + $not . ” entries inserted.\r\n”;
echo “=========================================\r\n”;
echo $in . ” entries captured.\r\n”;
if (!empty($not)) {
echo $not . ” entries exclude. (failed or already captured)”;
}
exit;

I think echo $not . ” entries exclude. (failed or already captured)”;
should be active in my case the second time I am running
http://www.i-contact.gr/xml/dt_intfc51e532251612d/import
from my browser.

I also haven’t found $not anywhere else in your files so maybe there is no “checking if already captured code” written?

Plugin Author David Cramer
(@desertsnowman)

12 years, 9 months ago

I’ll really need to go oever it again before I can answer correctly.
I’ll try to update asap.

Viewing 8 replies - 1 through 8 (of 8 total)

The topic ‘Data Source(Import Data from external XML)’ is closed to new replies.