Qna Digest, Vol 2, Issue 7

Donald A. Gardiner dagardiner at comcast.net
Mon Feb 4 08:14:04 PST 2008 

For Gary and Robert:
	Thank you both very much.  The problem was a corrupted file.  I don't  
know how many records may have been involved.
	Following your suggestions, I went back to the original data file  
that had been imported in Excel format.  I translated that into text  
format, imported that to Panorama and the problem did not reoccur.   
The 699 members of the East Tennessee Golf Association now have a  
schedule of 54 outings that will entertain them over the spring and  
summer.  I'm sure they are grateful, too.
On Feb 4, 2008, at 10:22 AM, qna-request at provue.com wrote:

> Send Qna mailing list submissions to
> 	qna at provue.com
>
> To subscribe or unsubscribe via the World Wide Web, visit
> 	http://provue.com/mailman/listinfo/qna
> or, via email, send a message with subject or body 'help' to
> 	qna-request at provue.com
>
> You can reach the person managing the list at
> 	qna-owner at provue.com
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Qna digest..."
>
>
> Today's Topics:
>
>   1. Re: Crashing/nonresponding (Robert Ameeti)
>   2. Re: importusing (Barry Kahn)
>   3. Re: importusing (Mark Terry)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Mon, 4 Feb 2008 07:14:39 -0800
> From: Robert Ameeti <Robert at Ameeti.net>
> Subject: Re: Crashing/nonresponding
> To: "Panorama Questions & Answers \(Discussion\)" <qna at provue.com>
> Message-ID: <p06240864c3ccdc0278dc@[10.0.1.200]>
> Content-Type: text/plain; charset="us-ascii" ; format="flowed"
>
> At 2:56 PM -0500, 2/2/08, Donald A. Gardiner wrote:
>
>> I could use some help.
>
> Sounds to me like a corrupted record. If you do a loop down starting
> at the first record, you will find at which record the corruption
> exists as that will either halt the loop or crash Panorama when it
> gets there. Either way you then can deal with removing that single
> record by select all others and removing Unselected.
> -- 
>
> <><><><><><><><><><><><><><><><><><>
> Robert Ameeti
>
> All truth passes through three stages. First, it is ridiculed.  
> Second, it is violently opposed. Third, it is accepted as being self- 
> evident.
> -- Arthur Schopenhauer
> <><><><><><><><><><><><><><><><><><>
>
>
> ------------------------------
>
> Message: 2
> Date: Mon, 4 Feb 2008 10:20:13 -0500
> From: Barry Kahn <barryk at caravanbeads.net>
> Subject: Re: importusing
> To: "Panorama Questions & Answers \(Discussion\)" <qna at provue.com>
> Message-ID: <39D6EB47-7D66-4156-BF64-D7C686784972 at caravanbeads.net>
> Content-Type: text/plain; charset="iso-8859-1"
>
> 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-0001.html
>
> ------------------------------
>
> Message: 3
> Date: Mon, 4 Feb 2008 10:21:52 -0500
> From: Mark Terry <mark at abernackie.com>
> Subject: Re: importusing
> To: "Panorama Questions & Answers \(Discussion\)" <qna at provue.com>
> Message-ID: <402AC7AE-D892-443C-B5B6-5AA773F48C55 at abernackie.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> 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.html
>
> ------------------------------
>
> _______________________________________________
> Qna mailing list
> Qna at provue.com
> http://provue.com/mailman/listinfo/qna
>
>
> End of Qna Digest, Vol 2, Issue 7
> *********************************

Donald


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

More information about the Qna mailing list