Formula Fill Timing Issue (Robert Ameeti)

Wed Feb 6 11:05:43 PST 2008

200k records

Today's Topics:

   1. Re: Formula Fill Timing Issue (Robert Ameeti)
 ----------------------------------------------------------------------

Message: 1
Date: Wed, 6 Feb 2008 08:04:35 -0800
From: Robert Ameeti <Robert at Ameeti.net>
Subject: Re: Formula Fill Timing Issue
To: "Panorama Questions & Answers \(Discussion\)" <qna at provue.com>
Message-ID: <p0624082bc3cf8acfd306@[10.0.1.200]>
Content-Type: text/plain; charset="us-ascii" ; format="flowed"

At 10:50 AM -0500, 2/6/08, Ken Doucet wrote:

>I run this on a 200k table

Is the 200,000 records or 200 kb of data.

>P.S. How do I respond properly to keep thread links going.

If you are receiving individual messages, just hit Reply. If you are
on Digest, I don't know.
--

<><><><><><><><><><><><><><><><><><>
Robert Ameeti

In all affairs it's a healthy thing now and then to hang a question mark on
the things you have long taken for granted.
            -- Bertrand Russell
<><><><><><><><><><><><><><><><><><>

-
>
>
>
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Qna mailing list
> Qna at provue.com
> http://provue.com/mailman/listinfo/qna
>

------------------------------

Message: 3
Date: Wed, 6 Feb 2008 11:32:35 -0500
From: "Ron Southwick" <ronald.southwick at tojfarm.com>
Subject: RE: How to export CSV with embedded commas?
To: "'Panorama Questions & Answers $Discussion$'" <qna at provue.com>
Message-ID: <000001c868dd$e206b290$010b210a at pecinc.com>
Content-Type: text/plain;	charset="us-ascii"

> I have a chunk of information that holds a paragraph of description. If
> the first sentence says, "We bought apples, bananas, and cherries", the
> commas in that sentence become delimiters and apples, bananas, and
> cherries are separated in the exported text.  I thought I had read that
> info within quotes would be somehow held as a unit; that didn't work for
> me. So when I have NO option  other than CSV, and I MUST export a block
> of text with commas used as punctuation, what do I do?

When I export from Pan 4.02 (Win) using the SaveAs command and choosing
comma output, the data from any cell with commas in it is automatically
encased in quotes. You don't have to add the quotation marks first. (When I
made a field that was already in quotation marks, the data was exported with
double quotation marks ""2, 3"".)

This type of output is similar to what I have seen from Excel when I save a
worksheet as CSV.

I can't speak for the wizard's output.

Ron

------------------------------

Message: 4
Date: Wed, 6 Feb 2008 10:42:11 -0600
From: David Thompson <dthmpsn1 at uiuc.edu>
Subject: Re: How to export CSV with embedded commas?
To: steve at tyrongraphicdesign.com,	"Panorama Questions & Answers
	\(Discussion\)" <qna at provue.com>
Message-ID: <p06240800c3cf910a595e@[130.126.130.116]>
Content-Type: text/plain; charset="us-ascii" ; format="flowed"

>I have a chunk of information that holds a paragraph of description. If
>the first sentence says, "We bought apples, bananas, and cherries", the
>commas in that sentence become delimiters and apples, bananas, and
>cherries are separated in the exported text.  I thought I had read that
>info within quotes would be somehow held as a unit; that didn't work for
>me. So when I have NO option  other than CSV, and I MUST export a block
>of text with commas used as punctuation, what do I do?

The quotes have to enclose the entire contents of the field, not just
the first sentence. When the text file is imported the quotes are
stripped.

If you choose SaveAs... from the File menu, and check the Text Only
radio button, a new dialog will appear when you click the Save
button. You would use that dialog to select the fields you want to
export, and to choose commas as the delimiter. If the text in a field
contains delimiters, such as commas, tabs or quotes, then enclosing
quotes will be added automatically, and any embedded quotes will be
doubled.

Dave

------------------------------

Message: 5
Date: Wed, 6 Feb 2008 09:43:53 -0700
From: David Groover <photographer at thegoldenthread.net>
Subject: Re: How to export CSV with embedded commas?
To: steve at tyrongraphicdesign.com,	"Panorama Questions & Answers
	\(Discussion\)" <qna at provue.com>
Message-ID: <E202A9CB-7746-42F9-8F69-1B1EE25220F3 at thegoldenthread.net>
Content-Type: text/plain; charset=WINDOWS-1252; delsp=yes;
	format=flowed

I haven't puzzled this through yet, but I would think there is an
example in the reference wizard on Replace(.

I don't know how many records you are exporting each time. Assuming
you have several orders with data that has commas in it then I might
first identify that actual record separator, possibly a return
character. If that record separator was also a comma then I would
replace all instances of that character with a unique name. Then I
would replace all the commas  with brackets and quotation marks and
pluses. I imagine it something like this:

lvplaceholder = {, }

//starts with the data:
"We bought apples, bananas, and cherries",
"We bought apples, bananas, and cherries",
"We bought apples, bananas, and cherries"

//Then replaces the separator:
"We bought apples, bananas, and cherries" + lvplaceholder
"We bought apples, bananas, and cherries" + lvplaceholder
"We bought apples, bananas, and cherries"

//Then breaks up the text and commas into a readable and still
exportable CSV file.
"We bought apples"+{, } + "bananas"+{, } + "and cherries"  +
lvplaceholder
"We bought apples"+{, } + "bananas"+{, } + "and cherries"  +
lvplaceholder
"We bought apples"+{, } + "bananas"+{, } + "and cherries"  +
lvplaceholder

Perhaps it is the import that is the problem and this is still
missing the point? I wanted to give it a shot though, Hope it helps.

David Groover

On Feb 6, 2008, at 9:15 AM, Steve Tyron wrote:

> Barry, let me clarify. I have used the export wizard with commas as
> the
> delimiter, but here's what happens:
>
> I have a chunk of information that holds a paragraph of
> description. If
> the first sentence says, "We bought apples, bananas, and cherries",
> the
> commas in that sentence become delimiters and apples, bananas, and
> cherries are separated in the exported text.  I thought I had read
> that
> info within quotes would be somehow held as a unit; that didn't
> work for
> me. So when I have NO option  other than CSV, and I MUST export a
> block
> of text with commas used as punctuation, what do I do?
>
> Steve
>
>
>
> Barry Kahn wrote:
>> The text export wizard allows you to select tab or comma as the
>> delimiter. There are fancier ways that I'm just learning to use, but
>> the wizard makes it very easy.
>>
>> bk
>>
>>
>> On Feb 6, 2008, at 10:51 AM, Steve Tyron wrote:
>>
>>> I have never cared for CSV text, preferring tab-sep text instead.
>>> I must
>>> have missed some detail because I never learned how to export CSV
>>> text
>>> when some of the information requires a comma? I have tried
>>> replacing
>>> existing commas with a strange character (?), then ding a find/
>>> replace
>>> after the data is in its new location, but that just seems tedious!
>>>
>>> I have to upload a CSV file to an online shopping cart; I have no
>>> choice
>>> but CSV. What is my method?
>>>
>>> Thanks,
>>>
>>> Steve
>>>
>>>
>>> _______________________________________________
>>> Qna mailing list
>>> Qna at provue.com <mailto: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 <mailto:barryk at caravanbeads.net>
>>
>>
>>
>>
>>
>> ---------------------------------------------------------------------
>> ---
>>
>> _______________________________________________
>> Qna mailing list
>> Qna at provue.com
>> http://provue.com/mailman/listinfo/qna
>>
>
> _______________________________________________
> Qna mailing list
> Qna at provue.com
> http://provue.com/mailman/listinfo/qna

------------------------------

Message: 6
Date: Wed, 6 Feb 2008 10:57:13 -0600
From: Jeff Bruss <jeffb at colepublishing.com>
Subject: Anyone from Minnesota?
To: "Panorama Questions & Answers $Discussion$" <qna at provue.com>
Message-ID: <197D0ED8-041D-477C-99EB-C139110ADD40 at colepublishing.com>
Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed

Is there anyone on this list from Minnesota? If so, can you respond
off list to jeffb at colepublishing.com?

Thanks,
Jeff

------------------------------

Message: 7
Date: Wed, 6 Feb 2008 10:02:12 -0700
From: Elon Close <erclose at dakotacom.net>
Subject: Re: Field data Assignment
To: "Panorama Questions & Answers \(Discussion\)" <qna at provue.com>
Message-ID: <EA4EA7B6-CFFA-46E2-A68C-6F05BF705A92 at dakotacom.net>
Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed

Thank you Dave for the pointers!

I know that a variable is simply a static location from which and
into which data is put. A ShortCall can use all the variables
declared in the containing procedure. I also tend to declare
FileGlobal and Global in any procedure in which they are used, though
once declared that is not necessary. Just left over from other
languages, and a way to keep track of what is available.

A Field name is a dynamic item, it has to fetch and store in a
"movable" storage location, the current, active cell. That Panorama
correctly does that, even when the name is fetched from a variable's
storage location is quite impressive. I thought it might know enough
to realize that when the item in the storage location was a Field
name, it would do what it had to do. Obviously, a variable is a
simple storage location, period. To store in a Field something extra
is needed that can do the dynamic processing, eg. the Cell, or Set
commands which I missed seeing, or looking into.

So once again, Thanks Dave, and a Gold Star to Panorama for having
the tools.

Elon
erclose at dakotacom.net

As usual I didn't look deep enough and panorama had the tools.
On Feb 6, 2008, at 7:24 AM, David Thompson wrote:

> Nothing will turn a variable that isn't already
> local, into a local. What lead you to the
> conclusion that this was happening?
>

------------------------------

Message: 8
Date: Wed, 6 Feb 2008 10:33:08 -0500
From: "Pete" <trackmanpete at comcast.net>
Subject: RE: Newbie question re synchonizing address lists (Ken
	Doucet)
To: "'Panorama Questions & Answers \(Discussion\)'" <qna at provue.com>
Message-ID: <000801c868d5$944260c0$6501a8c0 at TrackmanPete>
Content-Type: text/plain;	charset="us-ascii"

Ken Thompson is quite good, as he helped me quite a bit with some html
coding for Panorama.  His suggestion should work for you, but will take a
little bit of time for you to learn.  My other thought was to sort the two
databases by id number and then make copies of each, but only doing a
smaller grouping.  So say your id numbers run from 000000 to 250000.  Copy
the original file, select the first 50,000 records and discard the others
and save that file as file 2. Then do a formulafill on only those 50,000.
Then do the same for the next 50,000 and so fourth.  When you have done all
of them, which should take about 25 minutes, you can then do one whole
database attaching each of the partial ones.  Just another thought.  I
wonder how long it would take in Alpha.  I might try doing the zip code
addition on there to compare the two.  Perhaps when the California guys wake
up, one will get some more ideas.  Dave is from the Univ of Ill.

Pete

------Original Message-----
-From: qna-bounces at provue.com [mailto:qna-bounces at provue.com] On Behalf Of
-Ken Doucet
-Sent: Wednesday, February 06, 2008 8:55 AM
-To: qna at provue.com
-Subject: Newbie question re synchonizing address lists (Ken Doucet)
-
-
-
-I have been following the math/formula fill to populate content of field
-with values from another table using:
-
-lookup("CMEMAILV",RECID,RECID,Valid,"",0) and then wait..... At this stage
-I
-am trying to populate 1 field from CMEMAILV but I will need to do several.
-I
-waited 40 minutes and still nothing - my apple activity monitor is showing
-cpu around 100% and Panorama not responding in Process column(I am on
-macbook pro intel) and the colour wheel is spinning .
-
-This is giving me more grief than I would have expected as all I am trying
-to do eventually is join 2 tables so that I have the original address
-fields
-along with the revised ones coming back from mailing house so I could
-analyze them.
-
-Thanks
-
-Ken
-
-PS how do I respond so that this will flow into thread (is it just by
-keeping subject line identical? I wanted to reply to Michael's response to
-my first post.
-_______________________________________________
-Qna mailing list
-Qna at provue.com
-http://provue.com/mailman/listinfo/qna

------------------------------

Message: 9
Date: Wed, 6 Feb 2008 13:19:48 -0500
From: Barry Kahn <barryk at caravanbeads.net>
Subject: Re: How to export CSV with embedded commas?
To: steve at tyrongraphicdesign.com,	"Panorama Questions & Answers
	\(Discussion\)" <qna at provue.com>
Message-ID: <48CFC692-1691-4E3B-92B4-46EDC94A73BE at caravanbeads.net>
Content-Type: text/plain; charset="windows-1252"

It'll add a step, but you could temporarily change all the commas in
the field with the paragraph of description to some symbol that's not
used in the database at all--*,%,#, at --or whatever. Then use the
wizard to export it as comma delimited, open it up with a text editor
(I usually use Tex-Edit) and search and replace the symbol with commas.

bk

On Feb 6, 2008, at 11:15 AM, Steve Tyron wrote:

> Barry, let me clarify. I have used the export wizard with commas as
> the
> delimiter, but here's what happens:
>
> I have a chunk of information that holds a paragraph of
> description. If
> the first sentence says, "We bought apples, bananas, and cherries",
> the
> commas in that sentence become delimiters and apples, bananas, and
> cherries are separated in the exported text.  I thought I had read
> that
> info within quotes would be somehow held as a unit; that didn't
> work for
> me. So when I have NO option  other than CSV, and I MUST export a
> block
> of text with commas used as punctuation, what do I do?
>
> Steve
>
>
>
> Barry Kahn wrote:
>> The text export wizard allows you to select tab or comma as the
>> delimiter. There are fancier ways that I'm just learning to use, but
>> the wizard makes it very easy.
>>
>> bk
>>
>>
>> On Feb 6, 2008, at 10:51 AM, Steve Tyron wrote:
>>
>>> I have never cared for CSV text, preferring tab-sep text instead.
>>> I must
>>> have missed some detail because I never learned how to export CSV
>>> text
>>> when some of the information requires a comma? I have tried
>>> replacing
>>> existing commas with a strange character (?), then ding a find/
>>> replace
>>> after the data is in its new location, but that just seems tedious!
>>>
>>> I have to upload a CSV file to an online shopping cart; I have no
>>> choice
>>> but CSV. What is my method?
>>>
>>> Thanks,
>>>
>>> Steve
>>>
>>>
>>> _______________________________________________
>>> Qna mailing list
>>> Qna at provue.com <mailto: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 <mailto:barryk at caravanbeads.net>
>>
>>
>>
>>
>>
>> ---------------------------------------------------------------------
>> ---
>>
>> _______________________________________________
>> Qna mailing list
>> Qna at provue.com
>> http://provue.com/mailman/listinfo/qna
>>
>
> _______________________________________________
> 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/20080206/8b30321f/attachment.htm
l

------------------------------

_______________________________________________
Qna mailing list
Qna at provue.com
http://provue.com/mailman/listinfo/qna

End of Qna Digest, Vol 2, Issue 13
**********************************