Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

xml data imports problems again


This topic is 6963 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

HI all, as I moved to ver 8 I can no longer import the previous xml database to FMP. The "array" fields no loger appear in my import window.

I include here the original .xml file (as test.xml.txt) I am trying to import and the xsl file (as test.xsl.txt) I used succesfully previously.

For instance filemaker dosent seem to like the following string:

the message being:

XML parsing error

An exception occurred!Type: NetAccessorException, Message:Could not connect to the socket for URL'{(0)'.Error={1}

Line number 2

Column Number 112

the line and number are either inthe XML input whic is:

or in the XSL file which is:

if I earase these files FMP8 imports the data except the array fields.

What am I doing wrong again?

Thanks a lot

Dan

test.xml.txt

test.xsl.txt

Posted

I don't think it's FileMaker 8 per se. I'm importing it fine with 8. I've gotten that "Could not connect to the socket" error when I tried to use a local xsl file for an http xml file (ie., an Amazon URL or similar). In that case you have to use a remote xsl, not a local one (which seems as if it should work, but doesn't; don't know why).

As I said, yours works OK for me if both xml and xsl files are local. I'm not on Tiger however, still 10.3.9. There are a few fields missing in the xsl however; not in the Metadata, but in the sections below: MyRating, Rating, Region. I think that's it. Then it works fine and everything lines up. Here's a fixed xsl.

(P.S. I should say they are in the Metadata, but were missing in the sections below.)

AppleFilm_xsl.zip

Posted

Hi Fenton, thanks again for your help, however I still get that error unless I erase the "http" line from the xml data. Still I am unable to import the names and roles fields.

You might be correct however, as I am using Tiger and I trust your tests.

In any case how should I modify the "http" data which gives me the error to a local one? Can I do this in BBedit before importing it in FMP?

Regards

Posted

I don't really know what's going on with "http" line. I get no error from it. One thing you might want to look at in BBEdit is to turn on invisibles, and see if you have any extra characters you're not aware of.

Here is my version of the files. I added a "strip tabs and returns" auto-enter calculation for the names and roles fields, which are otherwise loaded with them.

AppleFilm_xml.zip

Posted

Hi Fenton, thanks a lot again.

You are right, the problem must be a Tiger problem because (except for the http line which works fine as I take it off) in Panther 139 everything works again.

At this point I don't understyand who I should complain to. FileMaker? Apple? all this software costs money and it's ridicoulus not to be able to have it working.

I have another (small) problem which goes as follows.

As you know, I collect information mainly from Amazon and IMDB, these sites use latin only encodings, in my own FMP database I add everything original I can gather from the web. This includes titles, but also translation for talent name.

I would like to be able to link my "International Names db" with the Film Database

These are the fields I created in the "International Names db"

(all the following has no data just the fi8eld names, as this forum will turn in question marks everything non latin)

Example:

1)International Name :) Francois Truffaut

2)Local Name (also latin names are different as they have accents and so forth) François Truffaut

3)Traditional Chinese Name ??? 楚浮

4)Hong Kong Name:

5)Simplified Chinese Name:

6)Japanese Name:

7)Russian Name:

8)Farsi Name:

9)Hebrew Name;

then I created a relationship so each time the film database reads "Al Pacino" it should input it automatically any of the translations I have in the "International Names db" in a table I created for this purpose,

Both Database should link on the "international name" field which is exactly the same for both. However the link leads to nothing.

To solve the problem I create a series of search scripts (find Francois Truffaut) and set the the various fields as they find any translation in the "International Names db".

However this is really time consuming. Why my tables don't work?

Is there something I am missing?

Thanks again

Dan

This topic is 6963 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.