|
|
Posted by Afan@Afan.Net on 03/18/05 20:35
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]
|