Post by zupermanzito » Tue Feb 21, 2012 10:36 am

well i have finally set the export/import extension on my webpage.

however i dont know how to import a cvs file


i mean what are values i have to set?



right now im using latest opencart/export/import extension.

any help ill apreciate

try to explain as simple as possible since my english isnt good

Newbie

Posts

Joined
Tue Feb 21, 2012 10:32 am

Post by kevtheirish » Tue Feb 21, 2012 10:41 am

IMO best thing to do would be load a test product, then download with your csv extension to see how that is formatted

Active Member

Posts

Joined
Mon Jan 16, 2012 2:58 am

Post by zupermanzito » Tue Feb 21, 2012 10:57 am

well i have thinkg about that. i deleted every product, then added a single one..
then exported and i got this:

------------------------------

<b>Warning</b>: set_time_limit() has been disabled for security reasons in <b>/home/a6597259/public_html/admin/controller/tool/export.php</b> on line <b>76</b>ÐÏࡱá;þÿ þÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ »
ÌAB°=¼%r8X"1ÈÿArial1ÈÿArial1ÈÿArial1ÈÿArial1ÈÿArial1ȐArial¤
######0.00¥##0.00¦@àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À à À à À à¤#À à@À à¥#À ঠÀ “€ÿ’â8ÿÿÿÿÿÿÿÿÿÿÿÿ€€€€€€€€€ÀÀÀ€€€™™ÿ™3fÿÿÌÌÿÿffÿ€€fÌÌÌÿ€ÿÿÿÿÿÿ€€€€€ÿÌÿÌÿÿÌÿÌÿÿ™™Ìÿÿ™ÌÌ™ÿÿÌ™3fÿ3ÌÌ™ÌÿÌÿ™ÿfff™–––3f3™f333™3™3f33™333…Ô

Categories…ÌProducts…”Options…J
Attributes…ûSpecials…¬ Discounts…zRewardsü_zIcategory_id parent_idnametopcolumns
sort_order
image_name
date_added
date_modifiedlanguage_idseo_keyworddescriptionmeta_description
meta_keywords store_idslayoutstatus
enabledLos + Vendidostrue2012-02-20 20:51:32#+vendidos
vendidos
lo mas vendido
product_id
categoriesskuupclocationquantitymodelmanufacturerrequires
shippingpricepointsdate_availableweightunitlengthwidthheightlength
unittax_class_idviewedadditional image namesstock_status_idrelated_idstagssubtractminimumadministracionPearsonyes2012-02-20 17:44:262012-02-20 20:46:14
2012-02-19kgcmno_image.jpgoptiontypevaluerequiredprice
prefix
points
prefix
weight
prefixattribute_groupattribute_nametextcustomer_grouppriority
date_startdate_endDefault Wholesale
»
ÌAU}¸}¸}¸}

¸!}¸!}¸!}

¸} ¸}¸}¸}¸
}¸}¸}¸}¸!}¸
}¸*+‚Áƒ„&è?'è?(ð?)ð?¡"dXXà?à?ý
----------------------

Newbie

Posts

Joined
Tue Feb 21, 2012 10:32 am

Post by kevtheirish » Tue Feb 21, 2012 12:21 pm

you need something like CSVed, OpenOffice Calc, or excel to read it properly and you have to set the values correct to view it (CSV is short for coma separated values)
it should show up in a spread sheet similar to this if everything is correct
Image

Active Member

Posts

Joined
Mon Jan 16, 2012 2:58 am
Who is online

Users browsing this forum: No registered users and 2 guests