Hi Guys
So I tried my best to research my issue and to be honest have tried everything everyone has mentioned on the subject and after breaking the site a few times and restoring it or changing code back have still gotten nowhere.
I installed a fresh Zencart v1.5.6c, made some changes here and there. Added Easy Populate 4.0.36.ZC - 07-05-2016 and started uploading CSV's.
I noticed after importing the CSV there are alot of red question marks inside a red diamond in the admin.
The front end cuts off any further characters of product name and specs after this symbol.
http://www.gotitall.co.za/index.php?...oducts_id=7860
I read it had to do with CHAR sets and changing database to UTF8 and I have tried all of this, without success.
I also change the code in various files as per different possible solutions.
I have copied the original specs from supplier pricelists in Notepad++ and can see that some of the original character is degrees, plus and minus ± etc etc.
For some reason I am unable to get Zencart/EasyPopulate/Database to see these characters.
Below is an example of the symbol that is replacing the special character.
Any help would be greatly appreciated.
Import Results
Filename: TarsusDistributionEpsonHardwareResellersPricelist02July2020.csv
WARNING! - Model: V11H921540 P390 - Products name: "EB-1480Fi, Projectors, Ultra short distance, Full HD, 5.000�lumen- 3.500�lumen�(economy), 5.000�lumen - 3.500�lumen�(economy), Over 2.500.000�: 1, USB 2.0 Type A (2x), Powered USB, RS-232C, Ethernet interface (100 Base-TX / 10 Base-T), Wireless LAN IEEE 802.11a/b/g/n/ac (WiFi 5), Wi-Fi Direct, VGA in (2x), VGA out, HDMI in (3x), HDMI out, Component in, Miracast, Stereo mini jack audio out, Stereo mini jack audio in (3x), Microphone input, Finger-touch interface, Multi-Touch interface, USB 2.0 Type B (2x), Sync. in, Sync. out, 9,8�kg, 16�W, Stereo:�Stereo, Linux, Mac OS 10.10.x, Mac OS 10.7.x, Mac OS 10.8.x, Mac OS 10.9.x, Ubuntu 14.10, Ubuntu 15.04, 2 x Pen tip(Teflon), 4 x Pen tip(Felt), CD Manual, Cable cover, Interactive pens, Lens cap, Pen Holder/Stand, Power cable, Remote control incl. batteries, Replacement pen tips" exceeds max. length: 64
UPDATED! - Model: V11H921540 P390 | 1 | | EB-1480Fi, | EB-1480Fi, | | | | | 71794.492 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | | | 0 | Epson | Projectors | Taxable Go | 1 | 0 | 0 | 0 | 0 | 0 | | | |
WARNING! - Model: V11H942940 P390 - Products name: "EB-L1050U, Projectors, Installation/Large venue, WUXGA, 1920 x 1200, 16:10, 4K enhancement, 7.000�lumen- 4.900�lumen�(economy) in accordance with IDMS15.4, 7.000�lumen - 4.900�lumen�(economy) in accordance with ISO 21118:2012, Over 2.500.000�: 1, USB 2.0 Type B (Service Only), RS-232C, WLAN (2x), VGA in, DVI in, HDMI in, BNC in, HDBaseT, Stereo mini jack audio out, Stereo mini jack audio in (3x), Ethernet interface (100 Base-TX / 10 Base-T), Wireless LAN IEEE 802.11a/b/g/n (optional), VGA out, HDMI (HDCP 2.2)" exceeds max. length: 64
UPDATED! - Model: V11H942940 P390 | 1 | | EB-L1050U, | EB-L1050U, | | | | | 73994.412 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | | | 0 | Epson | Projectors | Taxable Go | 1 | 0 | 0 | 0 | 0 | 0 | | | |
WARNING! - Model: V11H940840 P390 - Products name: "EB-L1075U, Projectors, Installation/Large venue, WUXGA, 1920 x 1200, 16:10, 4K enhancement, 7.000�lumen- 4.900�lumen�(economy) in accordance with IDMS15.4, 7.000�lumen - 4.900�lumen�(economy) in accordance with ISO 21118:2012, Over 2.500.000�: 1, Stereo mini jack audio out, VGA out, RS-232C, HDMI (HDCP 2.2), HDMI in, WLAN (2x), HDBaseT, VGA in, USB 2.0 Type B (Service Only), Stereo mini jack audio in (3x), DVI in, Ethernet interface (100 Base-TX / 10 Base-T), BNC in, Wireless LAN IEEE 802.11a/b/g/n (optional), 16,9�kg, CD Manual, Cable cover, Lens cap, Power cable, Quick Start Guide, Remote control incl. batteries" exceeds max. length: 64
UPDATED! - Model: V11H940840 P390 | 1 | | EB-L1075U, | EB-L1075U, | | | | | 101513.972 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | | | 0 | Epson | Projectors | Taxable Go | 1 | 0 | 0 | 0 | 0 | 0 | | | |
WARNING! - Model: V11H940940 P390 - Products name: "EB-L1070U, Projectors, Installation/Large venue, WUXGA, 1920 x 1200, 16:10, 4K enhancement, 7.000�lumen- 4.900�lumen�(economy) in accordance with IDMS15.4, 7.000�lumen - 4.900�lumen�(economy) in accordance with ISO 21118:2012, Over 2.500.000�: 1, HDBaseT, VGA in, USB 2.0 Type B (Service Only), Stereo mini jack audio in (3x), DVI in, Ethernet interface (100 Base-TX / 10 Base-T), BNC in, Wireless LAN IEEE 802.11a/b/g/n (optional), Stereo mini jack audio out, VGA out, RS-232C, HDMI (HDCP 2.2), HDMI in, WLAN (2x), 16,9�kg, CD Manual, Cable cover, Lens cap, Power cable, Quick Start Guide, Remote control incl. batteries" exceeds max. length: 64
UPDATED! - Model: V11H940940 P390 | 1 | | EB-L1070U, | EB-L1070U, | | | | | 101513.972 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | | | 0 | Epson | Projectors | Taxable Go | 1 | 0 | 0 | 0 | 0 | 0 | | | |
WARNING! - Model: V11HA16140 P390 - Products name: "EB-L1495U Projectors, Installation/Large venue, WUXGA, 1920 x 1200, 16:10, 4K enhancement, 9.000�lumen- 6.300�lumen�(economy) In accordance with IDMS15.4, 9.000�lumen -6.300�lumen�(economy) In accordance with ISO 21118:2012, 2.500.000�: 1, Stereo mini jack audio in (3x), Stereo mini jack audio out, HDBaseT, BNC in, HDMI in, DVI in, VGA out, VGA in, Ethernet interface (100 Base-TX / 10 Base-T), RS-232C, USB 2.0 Type B (Service Only), HD-SDI, Wireless LAN b/g/n (2.4GHz) (optional), 23,8�kg, CD Manual, Cable cover, VGA cable, Power and signal cable (3 m), Quick Start Guide, Remote control incl. batteries" exceeds max. length: 64
UPDATED! - Model: V11HA16140 P390 | 1 | | EB-L1495U | EB-L1495U | | | | | 207058.732 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | | | 0 | Epson | Projectors | Taxable Go | 1 | 0 | 0 | 0 | 0 | 0 | | | |
WARNING! - Model: V11HA16040 P390 - Products name: "EB-L1490U Projectors, Installation/Large venue, WUXGA, 1920 x 1200, 16:10, 4K enhancement, 9.000�lumen- 6.300�lumen�(economy) In accordance with IDMS15.4, 9.000 lumen - 6.300�lumen�(economy) In accordance with ISO 21118:2012, 2.500.000�: 1, Stereo mini jack audio in (3x), Stereo mini jack audio out, HDBaseT, BNC in, HDMI in, DVI in, VGA out, VGA in, Ethernet interface (100 Base-TX / 10 Base-T), RS-232C, USB 2.0 Type B (Service Only), HD-SDI, Wireless LAN b/g/n (2.4GHz) (optional), 23,8�kg, CD Manual, Cable cover, VGA cable, Power and signal cable (3 m), Quick Start Guide, Remote control incl. batteries" exceeds max. length: 64
UPDATED! - Model: V11HA16040 P390 | 1 | | EB-L1490U | EB-L1490U | | | | | 207058.732 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | | | 0 | Epson | Projectors | Taxable Go | 1 | 0 | 0 | 0 | 0 | 0 | | | |
WARNING! - Model: V11H981040 P390 - Products name: "EB-E20, Projectors, Mobile, XGA, 1024 x 768, 4:3, HD ready, 3.400�Lumen- 2.200�Lumen�(economy), 3.400�Lumen - 2.200�Lumen�(economy) In accordance with ISO 21118:2013, 15.000�: 1, USB 2.0 Type A, RS-232C, VGA in (2x), VGA out, HDMI in, Composite in, Stereo mini jack audio out, Stereo mini jack audio in (2x), Cinch audio in, USB 2.0 Type B, 3,1�kg, 5�Watt, Computer cable, Main unit, Power cable" exceeds max. length: 64
UPDATED! - Model: V11H981040 P390 | 1 | | EB-E20, Pr | EB-E20, Pr | | | | | 8849.36 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | | | 0 | Epson | Projectors | Taxable Go | 1 | 0 | 0 | 0 | 0 | 0 | | | |
WARNING! - Model: V11H988040 P390 - Products name: "EB-992F, Projectors, Mobile/Large venue, Full HD 1080p, 1920 x 1080, 16:9, Full HD, 4.000�Lumen- 2.400�Lumen�(economy), 4.000�Lumen - 2.400�Lumen�(economy) In accordance with ISO 21118:2013, 16.000�: 1, USB 2.0 Type A, USB 2.0 Type B, RS-232C, Ethernet interface (100 Base-TX / 10 Base-T), VGA in (2x), VGA out, HDMI in (2x), Composite in, Stereo mini jack audio out, Stereo mini jack audio in (2x), Cinch audio out, Microphone input, Wireless LAN IEEE 802.11b/g/n, Miracast, 3,1�kg, 16�Watt, Computer cable, Main unit, Power cable, Remote control incl. batteries, User manual, Warranty document, Wireless LAN unit" exceeds max. length: 64
UPDATED! - Model: V11H988040 P390 | 1 | | EB-992F, P | EB-992F, P | | | | | 19303.746 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | | | 0 | Epson | Projectors | Taxable Go | 1 | 0 | 0 | 0 | 0 | 0 | | | |
WARNING! - Model: V11H978040 P390 - Products name: "EB-FH52, Projectors, Mobile, Full HD 1080p, 1920 x 1080, 16:9, Full HD, 4.000�Lumen- 2.400�Lumen�(economy) In accordance with ISO 21118:2013, 4.000�Lumen - 2.400�Lumen�(economy) In accordance with ISO 21118:2013, 16.000�: 1, USB 2.0 Type A, USB 2.0 Type B, Wireless LAN IEEE 802.11b/g/n, VGA in, HDMI in (2x), Composite in, Cinch audio in, Miracast, 3,1�kg, 16�Watt, Carrying Case, Computer cable, Main unit, Power cable, Remote control incl. batteries, User's Manual Set, Warranty Documents" exceeds max. length: 64
UPDATED! - Model: V11H978040 P390 | 1 | | EB-FH52, P | EB-FH52, P | | | | | 15518.244 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | | | 0 | Epson | Projectors | Taxable Go | 1 | 0 | 0 | 0 | 0 | 0 | | | |
WARNING! - Model: V11H983040 P390 - Products name: "EB-W49, Projectors, Mobile, WXGA, 1280 x 800, 16:10, 3.800�Lumen, 3.800�Lumen In accordance with ISO 21118:2013, 16.000�: 1, USB 2.0 Type A, USB 2.0 Type B, RS-232C, Ethernet interface (100 Base-TX / 10 Base-T), Wireless LAN a/n (5GHz) (optional), VGA in (2x), VGA out, HDMI in (2x), Composite in, Stereo mini jack audio out, Stereo mini jack audio in (2x), Cinch audio in, 2,7�kg, 5�Watt, Computer cable, Power cable, Quick Setup Guide, Remote control incl. batteries, Warranty card" exceeds max. length: 64
UPDATED! - Model: V11H983040 P390 | 1 | | EB-W49, Pr | EB-W49, Pr | | | | | 13000.764 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | | | 0 | Epson | Projectors | Taxable Go | 1 | 0 | 0 | 0 | 0 | 0 | | | |
WARNING! - Model: V11H914040 P390 - Products name: "EF-100W Portable laser projector, white. HD ready, 0.59 inch LCD panel, Contrast: 2.500.000:1 Aspect ratio 16:10, Laser light source, Screen size 30-150 inches, USB 2.0 Type A, USB 2.0 Type B, HDMI in, Stereo mini jack audio out, Bluetooth, Power consumption: 172 Watt, 115 Watt (economy), 0,4 Watt (standby), Heat dissipation: 584,8 BTU/hour (max), Dimensions 210x230x92mm, Weight 2.7kg Room Type / Application: Gaming, Home Cinema, Home Office, Home Photo, Huddle space / Portable, Sports, Streaming, TV & Box sets." exceeds max. length: 64
UPDATED! - Model: V11H914040 P390 | 1 | | EF-100W Po | EF-100W Po | | | | | 10918.404 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | | | 0 | Epson | Projectors | Taxable Go | 1 | 0 | 0 | 0 | 0 | 0 | | | |
WARNING! - Model: V11H914040 P390 - Products name: "EF-100W Portable laser projector, white. HD ready, 0.59 inch LCD panel, Contrast: 2.500.000:1 Aspect ratio 16:10, Laser light source, Screen size 30-150 inches, USB 2.0 Type A, USB 2.0 Type B, HDMI in, Stereo mini jack audio out, Bluetooth, Power consumption: 172 Watt, 115 Watt (economy), 0,4 Watt (standby), Heat dissipation: 584,8 BTU/hour (max), Dimensions 210x230x92mm, Weight 2.7kg Room Type / Application: Gaming, Home Cinema, Home Office, Home Photo, Huddle space / Portable, Sports, Streaming, TV & Box sets." exceeds max. length: 64
UPDATED! - Model: V11H914040 P390 | 1 | | EF-100W Po | EF-100W Po | | | | | 10918.404 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | | | 0 | Epson | Projectors | Taxable Go | 1 | 0 | 0 | 0 | 0 | 0 | | | |
WARNING! - Model: C11CG07402SA P390 - Products name: "Epson WorkForce Pro WF-M5299DW, WorkForce Pro. Maximum duty cycle: 45000 pages per month, Maximum resolution: 1200 x 1200 DPI, Standard printer languages: ESC/P-R,PCL 5e,PCL 6,PDF 1.7,PostScript 3. Print speed (black, normal quality, A4/US Letter): 34 ppm, Time to first page (black, normal): 4.8 s, Duplex print speed (ISO/IEC 24734, A4) black: 15 ppm. Standard input capacity: 250 sheets, Maximum input capacity: 251 sheets. Standard output capacity: 150 sheets. Maximum ISO A-series paper size: A4, Standard tray media types: Letterhead,Plain paper,Postcard,Recycled paper, ISO A-series sizes (A0...A9): A4,A5,A6 12�months�Carry in" exceeds max. length: 64
UPDATED! - Model: C11CG07402SA P390 | 1 | | Epson Work | Epson Work | | | | | 5266.107 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | | | 0 | Epson | Printers a | Taxable Go | 1 | 0 | 0 | 0 | 0 | 0 | | | |
WARNING! - Model: C11CH72403SA P390 - Products name: "Epson L15150 MEAF, Inkjet Printers, Consumer/Multi-fuction/Ink tank system, A3+, 4 Ink Cartridges, CMKY, Print, Scan, Copy, Fax, Yes (A4/A3, plain paper), Touchscreen, 4.800�x�2.400�dpi, 22�pages/min�Colour (plain paper), 32�pages/min�Monochrome (plain paper), 250�Sheets�Standard, 2.400�dpi x 1.200�dpi (Horizontal x Vertical), 50�pages, LCD screen: Type: Colour, Touchscreen, Diagonal:�10,9�cm, WiFi, Ethernet, USB, USB host, Wi-Fi Direct, Mac OS X 10.6.8 or later, Windows 10 (32/64 bit), Windows 7 (32/64 bit), Windows 8 (32/64 bit), Windows 8.1 (32/64 bit), Windows Server 2008 R2, Windows Server 2012 R2, Windows Server 2016, Windows Vista (32/64 bit), Windows XP Professional x64 Edition SP2 or later, Windows XP SP3 or later (32-bit), Windows Server 2003 R2, Windows Server 2003 SP2 or later, 1 set of ink (1x 127ml BK, 3x 70ml CMY), Main unit, Power cable, Quick Start Guide, User manual, 12�months�Carry in, 150.000�pages" exceeds max. length: 64
UPDATED! - Model: C11CH72403SA P390 | 1 | | Epson L151 | Epson L151 | | | | | 15736.446 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | | | 0 | Epson | Printers a | Taxable Go | 1 | 0 | 0 | 0 | 0 | 0 | | | |
Finished Processing Import File
Bookmarks