csv import problem from v1.4 to 1.6

[jaysondotph]

Hi 

 

image below is the sample cases screen shot, that i need your help and i can't solve this alone.  i need to import the following /categories, suppliers and so on.. / and now how do i solve this problem or what should i do first? 

 

 

 

 

 

[Dh42]

It looks like you might be using the wrong delimiter and maybe over using  " " too. Also, it looks as though your category id's are not correct as well. 

[jaysondotph]

so.. do you have any idea, what should i do?

[Dh42]

Reformat the file. Post the file so we can look at it. Also what import settings are you using, take a screenshot of the page right before you press the import button. 

[jaysondotph]

Thank you for you quick response and what do you mean by reformat? and i use csv file. 

 

 

here is the right side:

 

ID;Active;Name;Parent Category;Description;Meta-title;Meta-keyword;Meta-description;URL rewritten;Image URL
1;1;Home;0;;;;;home
15;1;NOTEBOOKS;104;;;;;processors
16;1;DESKTOP PC;104;;;;;memory
17;1;PRINTERS;1;;;;;printers
18;1;MONITORS;1;;;;;scanners
21;0;EMACHINES;15;;;;;samsung
22;0;GATEWAY;15;;;;;gateway
23;0;NEO;15;;;;;neo
24;0;EMACHINES;16;;;;;emachines
25;1;HP;16;;;;;hp
27;1;APPLE;53;;;;;apple
30;1;NETBOOKS;104;Netbooks;NETBOOK;NETBOOK;NETBOOK;netbooks
31;1;DIY;1;;;;;diy
32;1;SOFTWARE;1;;;;;software
33;1;PROJECTORS;34;;;;;projectors
34;1;PERIPHERALS;1;;;;;peripherals
35;1;ACCESSSORIES;1;;;;;accesssories
36;1;CONSUMABLE;1;;;;;consumable
37;1;PROCESSOR;31;;;;;processors
38;1;MOTHERBOARD;31;;;;;motherboards
39;1;MEMORY MODULES;31;;;;;memory-modules
40;1;FLASH DRIVE;31;;;;;flash-drives
41;1;MEDIA CARD;31;;;;;media-cards
42;1;VIDEO CARD;31;;;;;video-cards
43;0;AUDIO CARD;31;;;;;audio-cards
44;1;HARD DISK ( INTERNAL & EXTERNAL TYPE);31;;;;;hard-disk-internal-and-external-type-
45;1;CASING;31;;;;;casing
46;1;POWER SUPPLY;31;power-supply
47;1;NETWORKING DEVICES;31;networking-devices
48;1;SINGLE FUNCTION PRINTERS;17;single-function-printers
49;1;MULTI FUNCTION PRINTERS;17;multi-function-printers
50;1;DOT MATRIX PRINTERS;17;dot-matrix-printers
51;1;SCANNER;34;scanners
52;1;FAX MACHINE;34;fax-machine
53;1;TABLET;104;TABLET;TABLET;TABLET;TABLET;tablet
54;1;KEYBOARD;34;;;;;keyboards;
55;1;MOUSE;34;;;;;mouse;
56;1;WEBCAM;34;;;;;webcams;
57;1;GAME'S CONTROLLER;34;;;;;game-controllers;
58;0;Card Readers;34;;;;;card-readers;
59;1;AVR AND UPS;35;;;;;avr-ups;
60;1;HEADSETS AND HEADPHONES;35;;;;;headsets-headphones;
61;1;HEADSET WITH MIC;35;;;;;microphones;
62;1;POWER INVERTERS;35;;;;;power-inverters;
63;1;USB HUBS;35;;;;;usb-hubs;
64;1;BATTERIES AND CHARGERS;35;BATTERIES AND CHARGERS;BATTERIES AND CHARGERS;BATTERIES AND CHARGERS;BATTERIES AND CHARGERS;batteries-and-chargers;
65;1;CABLES;35;;;;;cables;
66;1;MOUSEPADS;35;;;;;mousepads;
67;1;BAGS;35;;;;;bags;
68;1;SPEAKERS;35;;;;;speakers;
69;1;CABLE TIES;35;;;;;cable-ties;
70;1;LAPTOP COOLER;35;;;;;laptop-coolers;
71;1;KEYBOARD PROTECTOR;35;;;;;keyboard-protectors;
72;1;SCREEN PROTECTOR;35;;;;;screen-protectors;
73;1;IPAD ACCESSORIES;35;;;;;ipad-accessories;
74;1;COMPUTER COVER;35;;;;;computer-covers;
75;1;TONER AND INK CARTRIDGES;36;;;;;inks;
76;1;MEDIA PAPERS;36;;;;;media-papers;
119;1;OPERATING SYSTEM;32;OPERATING SYSTEM;OPERATING SYSTEM;OPERATING SYSTEM;operating-system;
78;1;CLEANING KIT;36;;;;;cleaning-kit;
79;1;MEDIA DISC;35;;;;;media-discs;
80;1;ACER;15;;;;;acer;
81;1;ACER;30;;;;;acer;
82;1;ASUS;30;;;;;asus;
83;0;EMACHINES;30;;;;;emachines;
84;1;LENOVO;30;;;;;lenovo;
85;1;SAMSUNG;30;;;;;samsung;
86;0;TOSHIBA;30;;;;;toshiba;
87;1;HP;30;;;;;hp;
88;1;NEO;30;;;;;neo;
89;1;SONY;30;;;;;sony;
90;1;ASUS;15;;;;;asus;
91;0;COMPAQ;15;;;;;compaq;
94;0;FUJITSU;15;;;;;fujitsu;
95;1;HP;15;;;;;hp;
96;1;TOSHIBA;15;;;;;toshiba;
97;1;LENOVO;15;;;;;lenovo;
98;1;SAMSUNG;15;;;;;samsung;
99;1;ACER;16;;;;;acer;
100;1;COMPAQ;16;;;;;compaq
105;1;LCD MONITORS;18;;;;;lcd-monitors
102;1;ACER;53;;;;;a
103;1;ASUS;53;;;;;a
104;1;COMPUTERS;1;;;;;computers
106;1;LED MONITORS;18;;;;;crt-monitors
107;1;GENIUS;53;genius
109;1;ASUS;16;Asus Desktop;Asus Desktop;Asus Desktop;Asus Desktop;asus;
110;1;LENOVO;16;LENOVO;lenovo;
111;1;SAMSUNG;16;SAMSUNG;samsung;
112;1;MOBILE ACCESSORIES;35;IPHONE ACCESSORIES;IPHONE ACCESSORIES;IPHONE ACCESSORIES;iphone-accessories;
113;1;ONY;15;NOTEBOOK SONY;NOTEBOOK SONY;NOTEBOOK SONY;NOTEBOOK SONY;sony;
114;0;GIGABYTE;15;GIGABYTE;GIGABYTE;GIGABYTE;GIGABYTE;gigabyte;
115;1;SAMSUNG;53;SAMSUNG TABLIT;SAMSUNG TABLIT;SAMSUNG TABLIT;SAMSUNG TABLIT;samsung;
116;1;FAN;31;;fan;fan;fan;fan;
117;1;SONY;16;SONY;SONY;SONY;SONY;sony;
118;1;CARD READER;31;Card Reader;;;;card-reader;
120;1;ANTIVIRUS;32;;antivirus;antivirus;antivirus;antivirus;
121;1;PHOTOSHOP;32;;PHOTOSHOP;PHOTOSHOP;PHOTOSHOP;photoshop;
122;1;OFFICE;32;;office;office;office;office;
123;1;OTHER;32;;other;other;other;other;
124;1;HOME THEATER;34;;HOME THEATER;HOME THEATER;HOME THEATER;home-theater;
125;1;LED/LCD TV;18;LED/LCD TV;LED/LCD TV;LED/LCD TV;LED/LCD TV;led-lcd-tv;
127;1;COBY;53;COBY;COBY;COBY;COBY;coby;
128;1;SKYWORTH;53;SKYWORTH;SKYWORTH;SKYWORTH;SKYWORTH;skyworth;
129;1;JAZZ;53;JAZZ;JAZZ;JAZZ;JAZZ;jazz;
130;1;IVIEW;53;IVIEW;IVIEW;IVIEW;IVIEW;iview;
131;1;PEN TABLET;34;PEN TABLET;PEN TABLET;PEN TABLET;PEN TABLET;pen-tablet;
132;1;DIGITAL CAMERA;31;DIGITAL CAMERA;DIGITAL CAMERA;DIGITAL CAMERA;DIGITAL CAMERA;digital-camera;
133;1;SONY;32;SONY;SONY;SONY;SONY;sony;
134;1;CANON;132;CANON;CANON;CANON;CANON;canon;
135;1;EXPANSION CARDS;31;EXPANSION CARDS;EXPANSION CARDS;EXPANSION CARDS;EXPANSION CARDS;expansion-cards;
136;1;OLYMPUS;132;OLYMPUS;OLYMPUS;OLYMPUS;OLYMPUS;olympus;
138;1;OTHERS;53;OTHERS;OTHERS;OTHERS;OTHERS;others;
139;0;MOBILE;1;MOBILE;MOBILE;MOBILE;MOBILE;mobile;
140;1;MOBILE;104;MOBILE;MOBILE;MOBILE;MOBILE;mobile;
141;1;LENOVO;53;LENOVO;LENOVO;LENOVO;LENOVO;lenovo;

[Dh42]

Actually can you post the whole csv file some where, where it can be downloaded and checked. I cannot tell anything about it there

[jaysondotph]

here is:

 

http://www.megafileupload.com/en/file/532186/Categories-en-csv.html