<HTML>
<HEAD>
<TITLE>Re: [EmData] Help with importing problems</TITLE>
</HEAD>
<BODY>
<FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>Hi Ariana,<BR>
<BR>
There were some issues with file selectability in earlier versions of Xdata for Quark 7. These have been addressed in more recent releases; you might want to try the latest:<BR>
<BR>
<a href="http://www.emsoftware.com/products/xdata/beta/">http://www.emsoftware.com/products/xdata/beta/</a><BR>
<BR>
Regarding the import problems, it is really impossible to say without seeing your actual files, though it sounds like it is either a problem with your fields statement, or (shudder) something in your logic. Anyhow, if you could zip up and send us your quark document/Xdata prototype and your data file (please be sure that the data file as a header row so that we know what we are looking at), we can have a look.<BR>
<BR>
Regards,<BR>
<BR>
Joe Mathia<BR>
Em Software Support / <a href="support@emsoftware.com">support@emsoftware.com</a> / www.emsoftware.com<BR>
(+1) 740 284 1010, fax (+1) 740 284 1210<BR>
<BR>
<BR>
<BR>
<BR>
On 6/23/08 11:24 AM, "Ariana Grant" <<a href="agrant@Artcraft.com">agrant@Artcraft.com</a>> wrote:<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><SPAN STYLE='font-size:11pt'><FONT FACE="Arial">Hi all,<BR>
I am working on an Xdata template<BR>
the issues are arising when the data is being imported.<BR>
I can only get one file to appear, and not all the time, only with certain excel/text/csv files.<BR>
not all and not all of the data will show up, the new box character does show up in the "empty fields"<BR>
but none of the information is there<BR>
</FONT><FONT FACE="Calibri, Verdana, Helvetica, Arial"> <BR>
</FONT><FONT FACE="Arial">does anyone have any suggestions???<BR>
here is my prototype if that helps:<BR>
</FONT><FONT FACE="Calibri, Verdana, Helvetica, Arial"> <BR>
</FONT><FONT FACE="Helvetica, Verdana, Arial">«fields fullname, title, businessunit, legalentity, address1, address2, city, state, zipcode, tel, fax, direct, mobile, webaddress, email<BR>
<BR>
«if fax is empty<BR>
<BR>
«put "" into PH2<BR>
<BR>
«else<BR>
<BR>
«if fax is not empty<BR>
<BR>
«put " " & "fax +1 " & fax & return into PH2<BR>
<BR>
«endif<BR>
<BR>
«if direct is empty<BR>
<BR>
«put "" into PH3<BR>
<BR>
«else<BR>
<BR>
«if direct is not empty and fax is not empty<BR>
<BR>
«put "direct +1 " & direct & " " into PH3<BR>
<BR>
«else if direct is not empty and fax is empty<BR>
<BR>
«put "direct +1 " & direct & " " & return into PH3<BR>
<BR>
«endif<BR>
<BR>
«if mobile is empty<BR>
<BR>
«put "" into PH4<BR>
<BR>
«else<BR>
<BR>
«if mobile is not empty and fax is empty and direct is empty then put "mobile +1 " & mobile & return into PH4<BR>
<BR>
«else if mobile is not empty and fax is not empty and direct is not empty then put "mobile +1 " & mobile into PH4<BR>
<BR>
«endif»«endif»«fullname»<BR>
<BR>
«if trim(title) is not empty»«title»<BR>
<BR>
«endif»«if trim(businessunit) is not empty»«businessunit»«endif»<BR>
<BR>
<BR>
<BR>
«if trim(legalentity) is not empty»«legalentity»<BR>
<BR>
«endif»«if length(address1) + length(address2) >50<BR>
<BR>
«address1» «address2»<BR>
<BR>
«city» «state» «zipcode»<BR>
<BR>
«else if length(address1) + length(address2) <=50<BR>
<BR>
«if address1 is not empty and address2 is not empty»«address1» «address2» «city» «state» «zipcode»<BR>
<BR>
«else if address1 is not empty and address2 is empty»«address1» «city» «state» «zipcode»<BR>
<BR>
«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»<BR>
<BR>
«endif»«if trim(email) is not empty»«email»«endif»«if trim(webaddress) is not empty» «webaddress»<BR>
<BR>
«endif»«endif»«endif»«endif»<BR>
</FONT><FONT FACE="Calibri, Verdana, Helvetica, Arial"><BR>
<BR>
<BR>
Ariana Grant<BR>
***************************<BR>
Prepress Department<BR>
The Artcraft Company, Inc.<BR>
<a href="agrant@artcraft.com">agrant@artcraft.com</a><BR>
<BR>
<HR ALIGN=CENTER SIZE="3" WIDTH="95%"></FONT></SPAN><FONT SIZE="2"><FONT FACE="Consolas, Courier New, Courier"><SPAN STYLE='font-size:10pt'>_______________________________________________<BR>
Data-users mailing list<BR>
<a href="Data-users@emsoftware.com">Data-users@emsoftware.com</a><BR>
<a href="http://mail.emsoftware.com/mailman/listinfo/data-users">http://mail.emsoftware.com/mailman/listinfo/data-users</a><BR>
</SPAN></FONT></FONT></BLOCKQUOTE>
</BODY>
</HTML>