importusing

[Barry Kahn]

That was it--thanks a million!

bk


On Feb 4, 2008, at 9:59 AM, Peter Guerrini wrote:

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

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/a8bc17fb/attachment.html