Mr C

  • Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Mr C

  • Rank
  1. Thought I should post an experience I had with using EasySync (which I love by the way), and pasted text containing hidden characters, that can cause an issue with synchronized data. The issue observed :: Upon doing an initial sync, I noticed some fields in the recipient db had text in fields that did not correspond with that in the master database. Looking at the master data, I noticed a "notes" field contained text that looked like it was pasted from another source (in most fields I control the text input, cleaning it to remove things like, formating and spaces and returns at the end of single line data fields). This "notes" text was part of the data that was ending up in fields it should not have been in, so that was where I started. I then copied the text into my favourite text editor (currently TextWrangler), and noticed an upsidedown ? in the spot where line returns should have been, and these were in the spot where the text was breaking up, and ending up in the wrong fields. Using the FileMaker Data Viewer, I pasted the character into a ' Code ( "?" ) ' calculation [ ? = copied/pasted text ], this showed the Value to be 8232. The following calculation ' Substitute ( NoteText ; Char ( 8232 ) ; Char ( 13 ) ) ' when run on the text fixed the problem. All following sync's put the data into the correct fields. Conclution :: The text turned out to have been copied from an email recieved. The ' Char (8232) ' characters were the line returns in the email text. So it would appear some characters can cause undesirable effects in EasySync. I have since put the calculation into a text cleaning function, applied to multiline text fields in the db. It would also be good if anyone with better knowledge of the internal workings of EasySync, could enlighten me (us) to what other characters could cause problems, they could be added to the text cleaning function. Best Regards Mark Chettle Australia
  2. I don't know if I am missing something, but I cannot seem to find any method for converting a fp6 multi-file db solution into a fp7 single file one. Does anyone know if this can be done, and how? If it is not possible with FM7 without a thirdparty plugin then I consider this a major omission on the part of the team at FM. ("now you can store all your tables in one file", but oh! you can only do this by recreating your solution all over again. ?!* ). And while I am at it, there also does not appear to be any way of duplicating a table within a single file FP7 db solution either. I use a number of basic fields in a "template" table, but to build this in FM7 I will have to create a template file with many, manually defined tables, and fields, ...great!#* FileMaker Version: 7 Platform: Mac OS X Panther