Jump to content
Sign in to follow this  
davidrichards

TCP import in FM8.5

Recommended Posts

I am updating a database from filemaker 5 to 8.5. In the prior version I use TCPit to import sales records from our website directly into filemaker.

TCPit does not work with the new intel macs (yet). Any other suggestions?

Thank you.

Share this post


Link to post
Share on other sites

Using a web viewer to bring in the data would be one option. Other plugins you could use would include the smartpill PHP plugin, which I believe is intel mac compatible.

Share this post


Link to post
Share on other sites

If your web site can provide a XML source, I believe that would be the simplest route.

Share this post


Link to post
Share on other sites

I'm not sure I understand. The data is on our website as a delimited text file. My goal is to import the file and parse the data. How can I use the web browser to accomplish?

Unfortunatly, the file is not XML compatible.

Share this post


Link to post
Share on other sites

You would point your web viewer to the URL of the file. Then grab the content (of the entire file) using GetLayoutObjectAttribute(), and parse it out to individual records/fields.

If AppleScript is an option, you could use that to download the file, then import it into Filemaker - that would save the need for parsing.

Share this post


Link to post
Share on other sites

OK, I like the idea of using the webviewer to capture the file. I can assign the ftp address to get to the data, how do I structure the GetLayoutObjectAttribute to return data? My calculation, GetLayoutObjectAttribute("webdatafiles";"content") where webdatafiles is the name of the web viewer, did not return anything.

Thank you

Share this post


Link to post
Share on other sites

Most interesting. It appears you cannot get the content of a text file. It sort of makes sense, because in Safari the option of View Source is grayed out, too. So it's not a Filemaker issue, I think.

Share this post


Link to post
Share on other sites

what if you rename the files with the .html extension? They will display poorly in a browser, but then you should be able to get the content.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Who Viewed the Topic

    2 members have viewed this topic:
    WTM  ltwimberly 
×
×
  • Create New...

Important Information

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