Kamis, 06 Oktober 2011

RE: [MS_AccessPros] Error fault from CSV file

 


John,

My apology for the delayed responses. As you are aware I am involved
with a not-for-profit organisation and my team of 'helpers' has been
reduced to 40% by hospitalisations and overseas trips. The workload is immense.

To answer your question.

I have included one row each side of the suspect lines:

,File,Hits,Incomplete Requests,Visitors,Bandwidth (KB),,
30,http://www.rotary9790.org.au/ 4a/trf/ftp/chogm.pdf,189,0,159,"1,195",,1
31,http://www.rotary9790.org.au/
4a/yex/ftp/yexlongtermappn.pdf,"3,388","2,264",143,"195,137",,1
32,http://www.rotary9790.org.au/
4a/pr/ftp/newsletteraug.pdf,728,589,139,"138,941",,1
40,http://www.rotary9790.org.au/
4a/admin/ftp/fellowshipschairdirectoryjan2011.pdf,224,2,124,"36,708",,1
41,http://www.rotary9790.org.au/
4a/int/ftp/fellowshipadvancermay2011.pdf,"1,135","1,005",122,"125,188",,1
42,http://www.rotary9790.org.au/ 1011/ftp/march.pdf,238,31,122,"181,463",,1
49,http://www.rotary9790.org.au/ 1011/ftp/july.pdf,206,31,111,"236,105",,1
50,http://www.rotary9790.org.au/
info/ftp/mop2010.pdf,"5,070","2,644",110,"190,299",,1
51,http://www.rotary9790.org.au/
4a/trf/ftp/phfrecogandtferrequest.pdf,394,73,108,"27,904",,1
56,http://www.rotary9790.org.au/
1011/conf/ftp/febnewsletter.pdf,375,5,98,"26,879",,1
57,http://www.rotary9790.org.au/ clubs/bulletins/ftp2/
diamondcreek.pdf,"2,485","2,054",98,"214,748",,1
126,http://www.rotary9790.org.au/ 1011/ftp/december.pdf,736,314,56,"77,220",,1
127,http://www.rotary9790.org.au/
info/ftp/clubpresidentsmanual.pdf,"3,361","2,637",56,"258,542",,1
128,http://www.rotary9790.org.au/ forms/ftp/0910dataform.pdf,78,1,56,"3,776",,1
810,http://www.rotary9790.org.au/
0910/ftp/lifelinebookingform.pdf,1,0,1,"1,111",,1
,Total,"105,329","41,099",N/A,"20,130,092",,

I cannot see a consistency. An obvious problem with line 811 which is
ignored in the report because I take my own totals.

Regards,

Robin
At 6/10/2011 05:01 PM, you wrote:
>Robin-
>
>OK, what's in the Visitors column in rows 31, 41, 48, etc. ?? Look at the CSV
>file in Notepad.
>
>John Viescas, author
>Microsoft Office Access 2010 Inside Out
>Microsoft Office Access 2007 Inside Out
>Building Microsoft Access Applications
>Microsoft Office Access 2003 Inside Out
>SQL Queries for Mere Mortals
>http://www.viescas.com/
>(Paris, France)
>
>
>
>-----Original Message-----
>From: MS_Access_Professionals@yahoogroups.com
>[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Robin Chapple
>Sent: Thursday, October 06, 2011 1:52 AM
>To: MS_Access_Professionals@yahoogroups.com
>Subject: Re: [MS_AccessPros] Error fault from CSV file
>
>Bill,
>
>Yes my response is time stamped:
>
>At 5/10/2011 07:31 PM, Robin Chapple wrote:
>
>That is the day before your query. Repeated here:
>
>
>Thanks Bill,
>
>That gave me seven conversion errors:
>
>Error Field Row
>Type Conversion Failure Visitors 31
>Type Conversion Failure Visitors 41
>Type Conversion Failure Visitors 48
>Type Conversion Failure Visitors 50
>Type Conversion Failure Visitors 57
>Type Conversion Failure Visitors 127
>Type Conversion Failure Visitors 811
>
>What do I read into that?
>
>Regards,
>
>Robin
>
>
>
>At 6/10/2011 04:21 AM, you wrote:
> >Robin - Did you try my suggestion? This thread is getting rather
> >long so you might not have seen it.
> >
> >Bill
> >
> >--- In MS_Access_Professionals@yahoogroups.com, Robin Chapple
> ><robinski@...> wrote:
> > >
> > >
> > > Thanks Clive,
> > >
> > > My apology for the delay. I've been busy on other matters.
> > >
> > > I have now used the TYPE function and they are all type "1".
> > >
> > > Regards,
> > >
> > > Robin
> > >
> > > At 4/10/2011 08:30 PM, you wrote:
> > > >Hi Robin,
> > > >
> > > >To use the TYPE function enter it in the style
> > > >=TYPE(A1)
> > > >where A1 is the cell number.
> > > >
> > > >It comes under the category 'Information'.
> > > >
> > > >If you can't fix it, can you upload the .csv file
> > > >to the 2_AssistanceNeeded folder?
> > > >
> > > >Regards, Clive.
> > > >
> > > >--- In MS_Access_Professionals@yahoogroups.com, Robin Chapple
> > > ><robinski@> wrote:
> > > > >
> > > > >
> > > > > Thanks Graham,
> > > > >
> > > > > To test my theory I edited the CSV file and deleted the content. I
> > > > > them added the figures. The result was the same.
> > > > >
> > > > > Cheers,
> > > > >
> > > > > Robin
> > > > >
> > > > > At 4/10/2011 12:13 PM, you wrote:
> > > > > >Hi Robin
> > > > > >
> > > > > >You will get the #Num! error if the field is defined as
> > numeric, but there
> > > > > >is non-numeric data in the cell. Are you *certain* that
> > this is not the
> > > > > >case? Is it possible there is a problem with spaces in the
> > field value?
> > > > > >
> > > > > >Best wishes,,
> > > > > >Graham
> > > > > >
> > > > > > > From: MS_Access_Professionals@yahoogroups.com
> > > > > >[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of
> > > > Robin Chapple
> > > > > > > Sent: Tuesday, 4 October 2011 11:02
> > > > > > > To: MS_Access_Professionals@yahoogroups.com
> > > > > > > Subject: [MS_AccessPros] Error fault from CSV file
> > > > > > >
> > > > > > >
> > > > > > > I have a statistical report delivered as a CSV file
> which shows an
> > > > > > > error, - #Num! , in a limited number of cases, 7 out of 811, when
> > > > > > > linked to Access.
> > > > > > >
> > > > > > > The CSV file has all numbers recorded.
> > > > > > >
> > > > > > > Where do I look for a solution to the problem?
> > > > > > >
> > > > > > > Many thanks,
> > > > > > >
> > > > > > > Robin Chapple
> > > > > >
> > > > > >
> > > > > >
> > > > > >------------------------------------
> > > > > >
> > > > > >Yahoo! Groups Links
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > >
> > > >
> > > >
> > > >
> > > >------------------------------------
> > > >
> > > >Yahoo! Groups Links
> > > >
> > > >
> > > >
> > >
> >
> >
> >
> >
> >------------------------------------
> >
> >Yahoo! Groups Links
> >
> >
> >
>
>
>
>
>------------------------------------
>
>Yahoo! Groups Links
>
>
>
>
>
>------------------------------------
>
>Yahoo! Groups Links
>
>
>

__._,_.___
Recent Activity:
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___

Tidak ada komentar:

Posting Komentar