You are here: Re: problem with csv file - SOLVED :) « PHP « IT news, forums, messages
Re: problem with csv file - SOLVED :)

Posted by Afan@Afan.Net on 03/18/05 21:26

problem solved.
while getting info from csv file I limited myself with 1000 charcters:
$data = fgetcsv($handle, 1000);

:)



afan@afan.net wrote:

> My marketing department create a csv file which later upload into
> database. Everything was working fine - until upload they tried to
> make two days ago. In that file there were few of products that drive
> me crazy. The file is here: http://www.afan.net/7V_2005.csv The file
> has just "troublemakers".
> When you look at them with excel or any text editor - it looks just
> fine. Can't see anything wrong.
>
> But, when you display them using print_r() or foreach() or while()
> functions the products will be splitted into 2 arrays:
>
> This is product 07V0120 (index 0):
> Array ( [0] => 07V0120 [1] => Ultra Cotton Heavyweight Tee [2] => 6.1
> ounce, 100% cotton pre-shrunk jersey. Comfortable European cut with
> double-needle topstitched neckline, double stitched sleeve and waist
> hems. Seamless collar with taped neck & shoulders. Sizes S-2X. 3X, 4X
> and 5X in select colors. [3] => Neutrals - **White, *Natural |
> Heathers - **Ash, **Sport Grey | Colors - Leaf, Eggplant, *Stone Blue,
> *Cardinal Red, Lime, *Kelly Green, Vegas Gold, Lt Pink, Ice Grey,
> *Gold, *Texas Orange, Sapphire, Jade Dome, **Navy, *Forest Green,
> Steel, **Black, *Orange, *Sand, Olive, **Red, *Charcoal, **Royal,
> Pine, *Prairie Dust, *Lt Blue, Azalea, *Blue Dusk, *Indigo Blue,
> *Purple, *Maroon, Chestnut, Violet, *Daisy | Color/ Size key:
> *available up to 3X, **available up to 5X [4] => Price includes
> 1-color screened imprint. Screen charge, add $24.00(g) per color, per
> location. Additional imprint colors add $.42(c) per color per
> location. Add $1.33(c) per 2X - 5X. [5] => 12 [6] => 24 [7] => 48 [8]
> => 72 [9] => 144 [10] => Screened - neutrals [11] => 5.29 [12] => 5.2
> [13] => 5.15 [14] => 5.11 [15] => 3.69 [16] => [17] => [18] => [19] =>
> [20] => [21] => [22] => Screened - heathers [23] => 5.89 [24] => 5.79
> [25] => 5.73 [26] => 5.68 [27] => 4.26 [28] => [29] => [30] => [31] =>
> [32] => [33] => [34] => Screened - colors [35] => 6.49 [36] => 6.37
> [37] => 6.32 [38] => 6.26 [39] => 4.82 [40] => [41] => [42] => [43] =>
> [44] => [45] => [46] => 5c [47] => [48] => 5c [49] => [50] => 5c [51]
> => [52] => 46, [53] => [54] => [55] => [56] => [57] => [58] => 3 [59]
> => 15 [60] => 2006 )
>
> Array has alway 61 element. Index 0 is product ser. number and always
> start with '07V0' and last element, index 60, is alway '2006'.
>
> But, when I list it using print_r() function I'll get this:
>
> Array ( [0] => 07V0120 [1] => Ultra Cotton Heavyweight Tee [2] => 6.1
> ounce, 100% cotton pre-shrunk jersey. Comfortable European cut with
> double-needle topstitched neckline, double stitched sleeve and waist
> hems. Seamless collar with taped neck & shoulders. Sizes S-2X. 3X, 4X
> and 5X in select colors. [3] => Neutrals - **White, *Natural |
> Heathers - **Ash, **Sport Grey | Colors - Leaf, Eggplant, *Stone Blue,
> *Cardinal Red, Lime, *Kelly Green, Vegas Gold, Lt Pink, Ice Grey,
> *Gold, *Texas Orange, Sapphire, Jade Dome, **Navy, *Forest Green,
> Steel, **Black, *Orange, *Sand, Olive, **Red, *Charcoal, **Royal,
> Pine, *Prairie Dust, *Lt Blue, Azalea, *Blue Dusk, *Indigo Blue,
> *Purple, *Maroon, Chestnut, Violet, *Daisy | Color/ Size key:
> *available up to 3X, **available up to 5X [4] => Price includes
> 1-color screened imprint. Screen charge, add $24.00(g) per color, per
> location. Additional imprint colors add $.42(c) per color per
> location. Add $1.33(c) per 2X - 5X. [5] => 12 [6] => 24 [7] => 48 [8]
> => 72 [9] => 144 [10] => Screened - neutrals [11] => 5.29 [12] => 5.2
> [13] => 5.15 [14] => 5.11 [15] => 3.69 [16] => [17] => [18] => [19] =>
> [20] => [21] => [22] => S )
> ------------------------------------------------------------------------
> Array ( [0] => creened - heathers [1] => 5.89 [2] => 5.79 [3] => 5.73
> [4] => 5.68 [5] => 4.26 [6] => [7] => [8] => [9] => [10] => [11] =>
> [12] => Screened - colors [13] => 6.49 [14] => 6.37 [15] => 6.32 [16]
> => 6.26 [17] => 4.82 [18] => [19] => [20] => [21] => [22] => [23] =>
> [24] => 5c [25] => [26] => 5c [27] => [28] => 5c [29] => [30] => 46,
> [31] => [32] => [33] => [34] => [35] => [36] => 3 [37] => 15 [38] =>
> 2006 )
>
> The array is splitted into 2 arrays. As you ca see, this one is
> splitted right in the middle of the content S*|*creened - heathers.
> And, when I try to upload this into database I'll get error because
> code's trying to insert 'creened - heathers' fro 2nd array as product
> ser. number.
>
> But, funny thing is it looks like it cut right after certain number of
> characters of WHOLE ROW? As far as I was able to calculate, it breaks
> between 951st and 993rd character.?
>
> Also, if I delete certain number of characters from first array - same
> number of characters will be pulled from 2nd to 1st array. If I delete
> e.g., "neutrals" (8 characters) from [10] =>Screened - neutrals from
> 1st array, first 8 characters from 2nd array, "creened ", from [0] =>
> creened - heathers, will be moved to 1st array, and the array will
> look now:
>
>
> Array ( [0] => 07V0120 [1] => Ultra Cotton Heavyweight Tee [2] => 6.1
> ounce, 100% cotton pre-shrunk jersey. Comfortable European cut with
> double-needle topstitched neckline, double stitched sleeve and waist
> hems. Seamless collar with taped neck & shoulders. Sizes S-2X. 3X, 4X
> and 5X in select colors. [3] => Neutrals - **White, *Natural |
> Heathers - **Ash, **Sport Grey | Colors - Leaf, Eggplant, *Stone Blue,
> *Cardinal Red, Lime, *Kelly Green, Vegas Gold, Lt Pink, Ice Grey,
> *Gold, *Texas Orange, Sapphire, Jade Dome, **Navy, *Forest Green,
> Steel, **Black, *Orange, *Sand, Olive, **Red, *Charcoal, **Royal,
> Pine, *Prairie Dust, *Lt Blue, Azalea, *Blue Dusk, *Indigo Blue,
> *Purple, *Maroon, Chestnut, Violet, *Daisy | Color/ Size key:
> *available up to 3X, **available up to 5X [4] => Price includes
> 1-color screened imprint. Screen charge, add $24.00(g) per color, per
> location. Additional imprint colors add $.42(c) per color per
> location. Add $1.33(c) per 2X - 5X. [5] => 12 [6] => 24 [7] => 48 [8]
> => 72 [9] => 144 [10] => Screened - neutrals [11] => 5.29 [12] => 5.2
> [13] => 5.15 [14] => 5.11 [15] => 3.69 [16] => [17] => [18] => [19] =>
> [20] => [21] => [22] => Screened )
> ------------------------------------------------------------------------
> Array ( [0] => - heathers [1] => 5.89 [2] => 5.79 [3] => 5.73 [4] =>
> 5.68 [5] => 4.26 [6] => [7] => [8] => [9] => [10] => [11] => [12] =>
> Screened - colors [13] => 6.49 [14] => 6.37 [15] => 6.32 [16] => 6.26
> [17] => 4.82 [18] => [19] => [20] => [21] => [22] => [23] => [24] =>
> 5c [25] => [26] => 5c [27] => [28] => 5c [29] => [30] => 46, [31] =>
> [32] => [33] => [34] => [35] => [36] => 3 [37] => 15 [38] => 2006 )
>
> Any ideas what's going on???
>
> I tried to explain as better as I can, but you can laugh to my English :)
>
> -afan
>
>
>
>

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация