Re: Export/Write rows from DBF to CSV
Re: Export/Write rows from DBF to CSV
am 13.03.2009 15:01:51 von Phpster
--0016e647ee2aeb1e040465008a27
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
On Fri, Mar 13, 2009 at 9:56 AM, Rahul S. Johari <
sleepwalker@rahulsjohari.com> wrote:
> Ave,
>
> I'm trying to retrieve data from a DBF database and write it to a CSV file
> in a comma delimited format. I'm able to get the data and write it to CSV,
> but it only writes the last row/record ... not all the records. I know I
> don't have the correct code and I'm hoping someone can help me...
>
> _____________
> #CREATE CSV
> $date = date('mdy');
> $_file = 'CSV/TransferData_'.$date.'.csv';
> $_fp = @fopen( $_file, 'w' );
>
> #SELECT DBF TO OPEN - READ ONLY
> $db = dbase_open("mydata.dbf", 0);
> #PULL UP RECORD
> if ($db) {
> $record_numbers = dbase_numrecords($db);
> for ($i = 1; $i <= $record_numbers; $i++) {
> $row = dbase_get_record_with_names($db, $i);
>
> #WRITE ROWS TO VARIABLE
> $_csv_data =
> trim($row['PHONE']).",".trim($row['DATE']).","."\n"; <-- THIS is where my
> problem is! This only writes the last row!!
> }
> }
>
> #WRITE TO CSV
> @fwrite( $_fp, $_csv_data );
> @fclose( $_fp );
> _____________
>
> Thanks!
>
> ---
> Rahul Sitaram Johari
> Founder, Internet Architects Group, Inc.
>
> [Email] sleepwalker@rahulsjohari.com
> [Web] http://www.rahulsjohari.com
>
>
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
You are overwriting the variable ($csv_data) that holds the row, add a
period (concatenator) operator to build the up the data
#WRITE ROWS TO VARIABLE
$_csv_data .=
trim($row['PHONE']).",".trim($row['DATE']).","."\n";
<-- THIS is where my problem is! This only writes the last row!!
--
Bastien
Cat, the other other white meat
--0016e647ee2aeb1e040465008a27--
Re: Export/Write rows from DBF to CSV
am 13.03.2009 15:17:28 von Rahul Sitaram Johari
On Mar 13, 2009, at 10:01 AM, Bastien Koert wrote:
> On Fri, Mar 13, 2009 at 9:56 AM, Rahul S. Johari <
> sleepwalker@rahulsjohari.com> wrote:
>
>> Ave,
>>
>> I'm trying to retrieve data from a DBF database and write it to a
>> CSV file
>> in a comma delimited format. I'm able to get the data and write it
>> to CSV,
>> but it only writes the last row/record ... not all the records. I
>> know I
>> don't have the correct code and I'm hoping someone can help me...
>>
>> _____________
>> #CREATE CSV
>> $date = date('mdy');
>> $_file = 'CSV/TransferData_'.$date.'.csv';
>> $_fp = @fopen( $_file, 'w' );
>>
>> #SELECT DBF TO OPEN - READ ONLY
>> $db = dbase_open("mydata.dbf", 0);
>> #PULL UP RECORD
>> if ($db) {
>> $record_numbers = dbase_numrecords($db);
>> for ($i = 1; $i <= $record_numbers; $i++) {
>> $row = dbase_get_record_with_names($db, $i);
>>
>> #WRITE ROWS TO VARIABLE
>> $_csv_data =
>> trim($row['PHONE']).",".trim($row['DATE']).","."\n"; <-- THIS is
>> where my
>> problem is! This only writes the last row!!
>> }
>> }
>>
>> #WRITE TO CSV
>> @fwrite( $_fp, $_csv_data );
>> @fclose( $_fp );
>> _____________
>>
>> Thanks!
>>
>> ---
>> Rahul Sitaram Johari
>> Founder, Internet Architects Group, Inc.
>>
>> [Email] sleepwalker@rahulsjohari.com
>> [Web] http://www.rahulsjohari.com
>>
>> --
>> PHP General Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>
> You are overwriting the variable ($csv_data) that holds the row, add a
> period (concatenator) operator to build the up the data
>
> #WRITE ROWS TO VARIABLE
> $_csv_data .=
> trim($row['PHONE']).",".trim($row['DATE']).","."\n";
> <-- THIS is where my problem is! This only writes the last row!!
>
> --
>
> Bastien
>
> Cat, the other other white meat
AH!!! The Simplest Solution!! It works!!!! Absolutely 100% Perfect!!
Much Thanks :)
---
Rahul Sitaram Johari
Founder, Internet Architects Group, Inc.
[Email] sleepwalker@rahulsjohari.com
[Web] http://www.rahulsjohari.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: Export/Write rows from DBF to CSV
am 13.03.2009 16:44:31 von Shawn McKenzie
Rahul S. Johari wrote:
>
> On Mar 13, 2009, at 10:01 AM, Bastien Koert wrote:
>
>> On Fri, Mar 13, 2009 at 9:56 AM, Rahul S. Johari <
>> sleepwalker@rahulsjohari.com> wrote:
>>
>>> Ave,
>>>
>>> I'm trying to retrieve data from a DBF database and write it to a CSV
>>> file
>>> in a comma delimited format. I'm able to get the data and write it to
>>> CSV,
>>> but it only writes the last row/record ... not all the records. I know I
>>> don't have the correct code and I'm hoping someone can help me...
>>>
>>> _____________
>>> #CREATE CSV
>>> $date = date('mdy');
>>> $_file = 'CSV/TransferData_'.$date.'.csv';
>>> $_fp = @fopen( $_file, 'w' );
>>>
>>> #SELECT DBF TO OPEN - READ ONLY
>>> $db = dbase_open("mydata.dbf", 0);
>>> #PULL UP RECORD
>>> if ($db) {
>>> $record_numbers = dbase_numrecords($db);
>>> for ($i = 1; $i <= $record_numbers; $i++) {
>>> $row = dbase_get_record_with_names($db, $i);
>>>
>>> #WRITE ROWS TO VARIABLE
>>> $_csv_data =
>>> trim($row['PHONE']).",".trim($row['DATE']).","."\n"; <-- THIS is
>>> where my
>>> problem is! This only writes the last row!!
>>> }
>>> }
>>>
>>> #WRITE TO CSV
>>> @fwrite( $_fp, $_csv_data );
>>> @fclose( $_fp );
>>> _____________
>>>
>>> Thanks!
>>>
>>> ---
>>> Rahul Sitaram Johari
>>> Founder, Internet Architects Group, Inc.
>>>
>>> [Email] sleepwalker@rahulsjohari.com
>>> [Web] http://www.rahulsjohari.com
>>>
>>> --
>>> PHP General Mailing List (http://www.php.net/)
>>> To unsubscribe, visit: http://www.php.net/unsub.php
>>>
>>>@fwrite( $_fp, $_csv_data );
>> You are overwriting the variable ($csv_data) that holds the row, add a
>> period (concatenator) operator to build the up the data
>>
>> #WRITE ROWS TO VARIABLE
>> $_csv_data .=
>> trim($row['PHONE']).",".trim($row['DATE']).","."\n";
>> <-- THIS is where my problem is! This only writes the last row!!
>>
>> --
>>
>> Bastien
>>
>> Cat, the other other white meat
>
>
> AH!!! The Simplest Solution!! It works!!!! Absolutely 100% Perfect!!
>
> Much Thanks :)
Or even simpler and won't build a huge string if you have millions of
rows, just move your fwrite() up into the loop to write each record to
the csv:
#WRITE ROWS TO VARIABLE AND WRITE LINE TO CSV
$_csv_data = trim($row['PHONE']).",".trim($row['DATE']).","."\n";
@fwrite( $_fp, $_csv_data );
--
Thanks!
-Shawn
http://www.spidean.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: Export/Write rows from DBF to CSV
am 13.03.2009 18:40:48 von Rahul Sitaram Johari
On Mar 13, 2009, at 11:44 AM, Shawn McKenzie wrote:
> Rahul S. Johari wrote:
>>
>> On Mar 13, 2009, at 10:01 AM, Bastien Koert wrote:
>>
>>> On Fri, Mar 13, 2009 at 9:56 AM, Rahul S. Johari <
>>> sleepwalker@rahulsjohari.com> wrote:
>>>
>>>> Ave,
>>>>
>>>> I'm trying to retrieve data from a DBF database and write it to a
>>>> CSV
>>>> file
>>>> in a comma delimited format. I'm able to get the data and write
>>>> it to
>>>> CSV,
>>>> but it only writes the last row/record ... not all the records. I
>>>> know I
>>>> don't have the correct code and I'm hoping someone can help me...
>>>>
>>>> _____________
>>>> #CREATE CSV
>>>> $date = date('mdy');
>>>> $_file = 'CSV/TransferData_'.$date.'.csv';
>>>> $_fp = @fopen( $_file, 'w' );
>>>>
>>>> #SELECT DBF TO OPEN - READ ONLY
>>>> $db = dbase_open("mydata.dbf", 0);
>>>> #PULL UP RECORD
>>>> if ($db) {
>>>> $record_numbers = dbase_numrecords($db);
>>>> for ($i = 1; $i <= $record_numbers; $i++) {
>>>> $row = dbase_get_record_with_names($db, $i);
>>>>
>>>> #WRITE ROWS TO VARIABLE
>>>> $_csv_data =
>>>> trim($row['PHONE']).",".trim($row['DATE']).","."\n"; <-- THIS is
>>>> where my
>>>> problem is! This only writes the last row!!
>>>> }
>>>> }
>>>>
>>>> #WRITE TO CSV
>>>> @fwrite( $_fp, $_csv_data );
>>>> @fclose( $_fp );
>>>> _____________
>>>>
>>>> Thanks!
>>>>
>>>> ---
>>>> Rahul Sitaram Johari
>>>> Founder, Internet Architects Group, Inc.
>>>>
>>>> [Email] sleepwalker@rahulsjohari.com
>>>> [Web] http://www.rahulsjohari.com
>>>>
>>>> --
>>>> PHP General Mailing List (http://www.php.net/)
>>>> To unsubscribe, visit: http://www.php.net/unsub.php
>>>>
>>>> @fwrite( $_fp, $_csv_data );
>>> You are overwriting the variable ($csv_data) that holds the row,
>>> add a
>>> period (concatenator) operator to build the up the data
>>>
>>> #WRITE ROWS TO VARIABLE
>>> $_csv_data .=
>>> trim($row['PHONE']).",".trim($row['DATE']).","."\n";
>>> <-- THIS is where my problem is! This only writes the last row!!
>>>
>>> --
>>>
>>> Bastien
>>>
>>> Cat, the other other white meat
>>
>>
>> AH!!! The Simplest Solution!! It works!!!! Absolutely 100% Perfect!!
>>
>> Much Thanks :)
>
> Or even simpler and won't build a huge string if you have millions of
> rows, just move your fwrite() up into the loop to write each record to
> the csv:
>
> #WRITE ROWS TO VARIABLE AND WRITE LINE TO CSV
> $_csv_data = trim($row['PHONE']).",".trim($row['DATE']).","."\n";
> @fwrite( $_fp, $_csv_data );
>
> --
> Thanks!
> -Shawn
> http://www.spidean.com
Very, Very Interesting Snippet - works perfectly fine and I agree,
more efficient!
Thanks!!
---
Rahul Sitaram Johari
Founder, Internet Architects Group, Inc.
[Email] sleepwalker@rahulsjohari.com
[Web] http://www.rahulsjohari.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php