Re: Witango-Talk: T2k Mac to Wt 5.5 PC Conversion
Although I have edited taf files directly before (to fix T3 to T2K file conversion bugs), I hadn't really looked into it yet for this conversion project. Thanks for the tips. -> Kent Customer Support wrote: Kent, There will be a few steps to convert the file. All the steps can be done with a global find and replace of strings with a text editor like TextWrangler on OS X or TextPad on Windows. You need to convert the databases with FileMaker first. Then remove the spaces from the table names if there are any. The Tables are what you will reference in the taf file not the Layouts. Also note down what the layout name was and what table it is mapped to from within FileMaker. Before you start make a backup of all your files first. 1. Remove the space from the datasource names. Just a precaution. e.g. Look for DSID="Telephone Directory" and replace it with DSID="TelephoneDirectory" Look for Telephone Directory and replace it with TelephoneDirectory 2. Change the data source type to ODBC: Look for FileMaker and replace with ODBC Look for ´ and replace with Look for # and replace with 3. Convert Layouts to the table names used in FM8 Look for THE LAYOUT NAME and replace with PUT THE FM8.x TABLE NAME HERE 4. Record_ID is not exposed through the ODBC interface. It is now ROWID. Look for record_id and replace it with ROWID. You should now be able to use the taf files with a FM 8 database through the xDBC interface. You can also use the JDBC driver by changing ODBC to JDBC in step 2 above. Regards Witango Support On 09/12/2006, at 9:28 AM, Kent Swisher wrote: Nice to be back on the list after several years absence. I am converting a number of applications from FM4/T2000 all on MacOS9 to FMSA8/Witango 5.5 all on WinServer2003 (ODBC). Filemaker has a lot of good info on the database conversions from 4 to 7/8. Not doing so good finding info on Witango side. In a pre-sales email directly with Phil Wade, he said: “We have a simple procedure to convert taf files that were based on FM 5/6 connectivity to xDBC based taf files.” Unfortunately, Phil never got back to me when I requested a copy of his procedure. Have figured out a process myself. First TAF conversion went pretty well. Search and replace Layout_0, scrub actions and search criteria for layout_0 references. Change data sources in actions. Create custom column in search criteria (upper()) to deal with new case sensitivity. Check tags that have modified behavior since T2K for compatibility. Only 50 more TAFs to go… Questions: Would help to see a list of issues/gotchas that others have discovered when doing similar conversions to see what I missed or have not encountered yet. Anybody have such a list? Can any of you provide Phil’s procedure? Also seen mentioned when searching the list archives is reference to Phil’s presentation on T2000 to Witango 5.0 Mac conversion issues (high-ascii vs low-ascii character problem? and Yen character?). Do these T2k Mac to Wt5 Mac problems also apply to Mac to PC conversions? Is there a way to make FMSA8 odbc case insensitive by default? Know about the custom column in search criteria (upper()) to deal with new case sensitivity. Would be easier if could ignore case globally. -> Kent Swisher Engineering Services -> Alcatel-LucentApplication Support Engineer -> Wireline Access Products [EMAIL PROTECTED] -> Petaluma, CA 707-792-7116 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Re: Witango-Talk: Studio Beta?
Phil, That's good to hear. Thanks, Jason. On 13/12/2006, at 11:16 PM, Phil Wade wrote: On 13/12/2006, at 9:16 AM, Dan Stein wrote: I have heard from reliable source it is not EOL of the release of 5.5 beta and 6 are forthcoming. That said it would seem that the community is way way overdue for an update. Yes there is another release of the 5.5 server coming before Christmas. It is a maintenance release and will include a version for OS X on Intel Macs. We had a few internal issues with the build that we had to rectify before we released it. The rewritten Dev Studio v6 is currently in private testing and we are making good progress on the v6 server which will be released in Q2 2007. Regards Phil WITH IMAGINATION Planning, Implementation and Management of Web Applications Level 1, 44 Miller Street North Sydney NSW Australia 2060 phone + 612 9929 9229 fax + 612 9460 4770 web - www.wi.com.au email - [EMAIL PROTECTED] -- This message has been scanned for viruses and dangerous content by ESVA, and is believed to be clean. TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Re: Witango-Talk: Studio Beta?
Right I missed that saw server and read Studio. Phil can we assume that this will include a release of Studio to fix long outstanding issues? -- Dan Stein FileMaker 7 Certified Developer Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Cell: 610-256-2843 Fax 413-410-9682 FMP, WiTango, EDI,SQL 2000, MySQL, CWP [EMAIL PROTECTED] www.dss-db.com Men do not care how nobly they live, but only how long they live, although it is within the reach of every man to live nobly, but within no man's power to live long. Brian Haig Private Sector From: Robert Garcia <[EMAIL PROTECTED]> Reply-To: "witango-talk@witango.com" Date: Wed, 13 Dec 2006 09:33:42 -0800 To: "witango-talk@witango.com" Subject: Re: Witango-Talk: Studio Beta? What about a version of 5.5 studio that works, I think 5.75 was mentioned? -- Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 13653 West Park Dr Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 [EMAIL PROTECTED] - [EMAIL PROTECTED] http://bighead.net/ - http://eventpix.com/ On Dec 13, 2006, at 4:16 AM, Phil Wade wrote: > > On 13/12/2006, at 9:16 AM, Dan Stein wrote: > >> I have heard from reliable source it is not EOL of the release of 5.5 beta >> and 6 are forthcoming. That said it would seem that the community is way way >> overdue for an update. > > Yes there is another release of the 5.5 server coming before Christmas. It is > a maintenance release and will include a version for OS X on Intel Macs. We > had a few internal issues with the build that we had to rectify before we > released it. > > The rewritten Dev Studio v6 is currently in private testing and we are making > good progress on the v6 server which will be released in Q2 2007. > > > Regards > > Phil > > > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Re: Witango-Talk: caution for Parallels users
I had many issues with parallels networking, and used bridged, and have now always used bridged, without issue. -- Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 13653 West Park Dr Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 [EMAIL PROTECTED] - [EMAIL PROTECTED] http://bighead.net/ - http://eventpix.com/ On Dec 13, 2006, at 10:24 AM, Jason Pamental wrote: Hi all- I wrote a couple weeks ago about a weird phenomenon with file corruption and I had it happen again today. I've finally figured out the issue, and the answer is quite a surprise. There was nothing wrong with the files, even after the WIndows crash within Parallels on my MacBook Pro. The problem appeared only in the files once I transferred them via FTP. So I updated my copy of WS-FTP and reinstalled. No luck. Then I had a hunch. I was working in Starbucks yesterday, making use of the WiFi hotspot. In order to have both the Mac and Windows apps online at the same time you need to use Shared Networking so that Windows traffic comes and goes as if it were from the host OS. If you use Bridged Networking (the default) it appears as two machines getting online, so you would have to pay twice, or it just doesn't work. So I was still set to Shared Networking. I shut down Parallels and switched the VM back to Bridged Networking and uploaded the file again. No problems at all. When I did compare the files by downloading a problem file from the server I was finding a lower case letter b appended on the last line of the file outside the tag. But I never would have seen it looking at the files on my machine prior to uploading as it was only during the process of uploading that the file was being corrupted. Hopefully this won't happen with the next version of Parallels - I haven't tried the beta yet. Cheers all, and happy holidays Jason - Jason Pamental Director of Web Services North Sails Office: 401.643.1415 Fax: 401.643.1420 Mobile: 401.743.4406 Email: [EMAIL PROTECTED] __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: caution for Parallels users
Hi all- I wrote a couple weeks ago about a weird phenomenon with file corruption and I had it happen again today. I've finally figured out the issue, and the answer is quite a surprise. There was nothing wrong with the files, even after the WIndows crash within Parallels on my MacBook Pro. The problem appeared only in the files once I transferred them via FTP. So I updated my copy of WS-FTP and reinstalled. No luck. Then I had a hunch. I was working in Starbucks yesterday, making use of the WiFi hotspot. In order to have both the Mac and Windows apps online at the same time you need to use Shared Networking so that Windows traffic comes and goes as if it were from the host OS. If you use Bridged Networking (the default) it appears as two machines getting online, so you would have to pay twice, or it just doesn't work. So I was still set to Shared Networking. I shut down Parallels and switched the VM back to Bridged Networking and uploaded the file again. No problems at all. When I did compare the files by downloading a problem file from the server I was finding a lower case letter b appended on the last line of the file outside the tag. But I never would have seen it looking at the files on my machine prior to uploading as it was only during the process of uploading that the file was being corrupted. Hopefully this won't happen with the next version of Parallels - I haven't tried the beta yet. Cheers all, and happy holidays Jason - Jason Pamental Director of Web Services North Sails Office: 401.643.1415 Fax: 401.643.1420 Mobile: 401.743.4406 Email: [EMAIL PROTECTED] TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Re: Witango-Talk: Studio Beta?
What about a version of 5.5 studio that works, I think 5.75 was mentioned? -- Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 13653 West Park Dr Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 [EMAIL PROTECTED] - [EMAIL PROTECTED] http://bighead.net/ - http://eventpix.com/ On Dec 13, 2006, at 4:16 AM, Phil Wade wrote: On 13/12/2006, at 9:16 AM, Dan Stein wrote: I have heard from reliable source it is not EOL of the release of 5.5 beta and 6 are forthcoming. That said it would seem that the community is way way overdue for an update. Yes there is another release of the 5.5 server coming before Christmas. It is a maintenance release and will include a version for OS X on Intel Macs. We had a few internal issues with the build that we had to rectify before we released it. The rewritten Dev Studio v6 is currently in private testing and we are making good progress on the v6 server which will be released in Q2 2007. Regards Phil __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Re: Witango-Talk: Studio Beta?
Yeah, Good news. The Maintenance release is really welcomed. Happy to hear 6 is moving along. Thanks for the update. -- Dan Stein FileMaker 7 Certified Developer Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Cell: 610-256-2843 Fax 413-410-9682 FMP, WiTango, EDI,SQL 2000, MySQL, CWP [EMAIL PROTECTED] www.dss-db.com "There is a larger frame to the painting than the one that bounds our life's events." From: Phil Wade <[EMAIL PROTECTED]> Reply-To: "witango-talk@witango.com" Date: Wed, 13 Dec 2006 23:16:08 +1100 To: "witango-talk@witango.com" Subject: Re: Witango-Talk: Studio Beta? On 13/12/2006, at 9:16 AM, Dan Stein wrote: > I have heard from reliable source it is not EOL of the release of 5.5 beta > and 6 are forthcoming. That said it would seem that the community is way way > overdue for an update. Yes there is another release of the 5.5 server coming before Christmas. It is a maintenance release and will include a version for OS X on Intel Macs. We had a few internal issues with the build that we had to rectify before we released it. The rewritten Dev Studio v6 is currently in private testing and we are making good progress on the v6 server which will be released in Q2 2007. Regards Phil TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Studio Beta?
Phil, Thanks for the update Ted From: Phil Wade [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 13, 2006 7:16 AM To: witango-talk@witango.com Subject: Re: Witango-Talk: Studio Beta? On 13/12/2006, at 9:16 AM, Dan Stein wrote: I have heard from reliable source it is not EOL of the release of 5.5 beta and 6 are forthcoming. That said it would seem that the community is way way overdue for an update. Yes there is another release of the 5.5 server coming before Christmas. It is a maintenance release and will include a version for OS X on Intel Macs. We had a few internal issues with the build that we had to rectify before we released it. The rewritten Dev Studio v6 is currently in private testing and we are making good progress on the v6 server which will be released in Q2 2007. Regards Phil TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Re: Witango-Talk: Studio Beta?
On 13/12/2006, at 9:16 AM, Dan Stein wrote: I have heard from reliable source it is not EOL of the release of 5.5 beta and 6 are forthcoming. That said it would seem that the community is way way overdue for an update. Yes there is another release of the 5.5 server coming before Christmas. It is a maintenance release and will include a version for OS X on Intel Macs. We had a few internal issues with the build that we had to rectify before we released it. The rewritten Dev Studio v6 is currently in private testing and we are making good progress on the v6 server which will be released in Q2 2007. Regards Phil TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf