importusing

[Peter Guerrini]

Try deleting the final "+¬+" after the last "importcell(12)".
It looks like it passed Panorama's procedure syntax check, but I don't  
think you really want it.

Peter


On Feb 4, 2008, at 6:45 20AM, Barry Kahn wrote:

> 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
>
>
>
>
>
> _______________________________________________
> Qna mailing list
> Qna at provue.com
> http://provue.com/mailman/listinfo/qna

Peter Guerrini
peterg at sonic.net



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