importusing

[Barry Kahn]

I'm venturing into new territory for me and need help as usual.

I have a tab-delimited text file which I want to bring into an  
existing pan database. The text file has some extra fields which I  
don't need. I've been using the text import wizard to do this till  
now and it works perfectly, but now I'd like to automate the process.

So I've created a .Initialize procedure (my first time to try this  
also, very exciting!) which begins with this:

importusing
importcell(1)+ ¬ +
importcell(2)+ ¬ +
importcell(4)+ ¬ +
importcell(5)+ ¬ +
importcell(6)+ ¬ +
importcell(7)+ ¬ +
importcell(8)+ ¬ +
importcell(9)+ ¬ +
importcell(10)+ ¬ +
importcell(11)+ ¬ +
importcell(12)+ ¬ +

openfile "&Dell_shared:bin_locs_etc.txt"

As far as I can tell when I run this, the procedure is ignoring the  
importcell part and just bringing in the text file unchanged. Or it's  
doing the importcell part, and then overwriting it when it hits  
openfile etc.

I noticed in the Pan documentation that the example shows comma  
delimited fields. Does this make any difference? Also do I need to do  
anything special about the fields in the text file that I don't need,  
or does importusing automatically skip them if they are not listed?

Thanks!
bk






Barry Kahn
Caravan Beads, Inc.
915 Forest Ave
Portland ME 04103
800-230-8941
fax: 207-874-2664
www.caravanbeads.net
barryk at caravanbeads.net





-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://provue.com/pipermail/qna/attachments/20080204/94e8b455/attachment.html