importusing

[Mark Terry]

Another approach might be to just open the text file with Panorama,  
then save it to make a panorama database of it. Name the fields you  
want with the same names as the file you want to go into, then append  
using fieldnames. This builds in a lot of control, flexibility and  
eyeball error correction, and an undo feature as well. A good Plan B  
for onesies.

M

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

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