Joe/LJ, Found out, some of the field labels have carriage return at the end which cause the invalid format error. Thanks for your inputs.
Regards, Jay Sytangco CAI Outsourcing IT Equipment and Process Team Phone: 63.2.5819240 Email: [EMAIL PROTECTED] ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Friday, August 22, 2008 5:35 AM To: arslist@ARSLIST.ORG Subject: Re: Exported data from AP Trouble Ticket form cannot be imported back to the same form (using Import Tool) - returning "Invalid AR Export format file" error ** These '?' characters also could be a result of accented characters when you export them from a database containing such characters.. I'm not sure where I came across this but I think it was the data contained in one of the CFG cities or country forms where one of the countries have an accented character in its name.. Joe ----- Original Message ---- From: LJ Longwing <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Thursday, August 21, 2008 5:03:00 PM Subject: Re: Exported data from AP Trouble Ticket form cannot be imported back to the same form (using Import Tool) - returning "Invalid AR Export format file" error Jay, I would say that the export is converting 'hidden' characters into ?'s when creating the arx. The most common time when I see this type of behavior is when someone copies something out of Email, or Word and pasts it into a char field or maybe even a diary...MS is horrible about putting control codes and non ASCII code page characters all over the place. I bet if you put the field(s) in question through a 'wash' you may find that your problem goes away....what I mean by a 'wash' is to copy them from point a, paste them into a new (never used before) notepad window, which is not capable of handling most extended characters, and then close the file, re-open it, copy out of the notepad window, and paste back into original location...that's about my best suggestion -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jay Sytangco Sent: Thursday, August 21, 2008 12:37 AM To: arslist@ARSLIST.ORG Subject: Exported data from AP Trouble Ticket form cannot be imported back to the same form (using Import Tool) - returning "Invalid AR Export format file" error Hi All, Have anyone experienced exporting records from a form but the exported arx file cannot be imported back to the same form? I found out that the arx file contains a number of "?" characters scattered within the data and I'm not sure what causing these characters to be included in the exported data. This only happen to one particular form, exporting and importing data from other forms work ok. Thanks, Jay __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"