[EmData] Help with importing problems

[Ariana Grant]

Hi all,
I am working on an Xdata template
the issues are arising when the data is being imported.
I can only get one file to appear, and not all the time, only with certain excel/text/csv files.
not all and not all of the data will show up, the new box character does show up in the "empty fields"
but none of the information is there
 
does anyone have any suggestions???
here is my prototype if that helps:
 
«fields fullname, title, businessunit, legalentity, address1, address2, city, state, zipcode, tel, fax, direct, mobile, webaddress, email

«if fax is empty

«put "" into PH2

«else

«if fax is not empty

«put " " & "fax +1 " & fax & return into PH2

«endif

«if direct is empty

«put "" into PH3

«else

«if direct is not empty and fax is not empty

«put "direct +1 " & direct & " " into PH3

«else if direct is not empty and fax is empty

«put "direct +1 " & direct & " " & return into PH3

«endif

«if mobile is empty

«put "" into PH4

«else

«if mobile is not empty and fax is empty and direct is empty then put "mobile +1 " & mobile & return into PH4

«else if mobile is not empty and fax is not empty and direct is not empty then put "mobile +1 " & mobile into PH4

«endif»«endif»«fullname»

«if trim(title) is not empty»«title»

«endif»«if trim(businessunit) is not empty»«businessunit»«endif»

 

«if trim(legalentity) is not empty»«legalentity»

«endif»«if length(address1) + length(address2) >50

«address1» «address2»

«city» «state» «zipcode»

«else if length(address1) + length(address2) <=50

«if address1 is not empty and address2 is not empty»«address1» «address2» «city» «state» «zipcode»

«else if address1 is not empty and address2 is empty»«address1» «city» «state» «zipcode»

«endif»tel «tel» «trim(PH2 & PH3 & PH4)»«if tel is not empty OR fax is not empty OR direct is not empty OR mobile is not empty»

«endif»«if trim(email) is not empty»«email»«endif»«if trim(webaddress) is not empty» «webaddress»

«endif»«endif»«endif»«endif»

 
 
Ariana Grant
***************************
Prepress Department
The Artcraft Company, Inc.
agrant at artcraft.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://emsoftware.com/pipermail/data-users/attachments/20080623/cad96e3b/attachment.html