Answered
Hi all,
Is there any reason why i cannot export to xml correctly from a response file. It seems like they are not mapping correctly, if i open the pdf file from within the response file, and export out as xml, it works perfectly.
When importing into excel, each field goes into a different row in the spreadsheet.
Please, please help as this is driving me insane :-(
I have been doing my project on an intel Mac running parellels with windows and osx and working with Acrobat on the PC platform. The main problem was that i was using characters suck as \ / _ in the field names, and as my keyboard is a mac keyboard, those characters was not liked by the PC side and through the whole imported xml file out! The two keyboards vary slightly and this caused me huge problems as the PC side couldn't handle those characters. For example on the mac if you typed shift-2, you would get the @ symbol but when working in the PC environment you would get speech marks ("). When i created the form on a standard PC or a standard Mac this worked perfectly.
Alot of you might know this, but i also realised that it wasn't really worth putting those characters in, i would recommend and think this is a safer option, instead of having field names like Field_one i would close the word up like FieldOne instead and this will make doubly sure that it will import ok.
One last thing i found that was also causing me problems, was it did not like field names with the words "ID" at the beginning like IDLiftCode as it treated it as 2 fields when importing and the wrong data was being imported!
This sounds very odd but was true in my case, 4t i'd share it with you all incase anybody else has encounted the same problem and was completely baffled as much as i was.
Hope this helps somebody out there