How to Import csv gift codes?

Hi,

The component works great!
But now i need to import some gift certificate codes.
Insert coupon codes with a csv file, was not a problem.
But i don't now how to import the gift certificate codes.
I become errors by importing. (not enoughe collums to .....)
Can you tell me how much collums you need in the csv file, and wich are these collums?

I use Joomla 2.5.4 and AwoCoupons Pro 2.0.6

Thanks,
Walko

Hi Walko,

The file format is listed on the imports page and it requires the first 8 columns. The easiest way to get a valid csv import is to go to reports, run the coupon list and export it.

Hi Seyi,

Sorry, but maybe i'm doing something wrong.

These are the fields i have in the csv-file.
If i use these fields with import, coupons. That works.

~ID, Couponcode, Gepubliceerd, Functie Type, Functie Type 2, Percentage of bedrag, Kortingstype, Waarde, Waardedefinitie, Aantal gebruikt, Aantal gebruikt, Minimum waarde, Aanvangsdatum, Verloopdatum, Klanten, Klanten, Eigenschap, Eigenschap, Eigenschap 2, Eigenschap 2, Sluit speciale produkten uit, Sluit cadeaubonprodukten uit, Admin commentaar, Klanten, Eigenschap, Eigenschap 2


But if i use the first 8 colums ( ~ID, Couponcode, Gepubliceerd, Functie Type, Functie Type 2, Percentage of bedrag, Kortingstype, Waarde) by Giftcards, codes, import, then i become errors.

The csv-input is:
1 SuperSportDeal01 actief Coupon Produkt Bedrag Specifiek 30

These are the errors:
ID: 1;SuperSportDeal01;actief;Coupon;Produkt;Bedrag;Specifiek;30
-- Niet genoeg kolommen om te verwerken

ID: 2;SuperSportDeal02;actief;Coupon;Produkt;Bedrag;Specifiek;30
-- Niet genoeg kolommen om te verwerken

and that for all the ID's.

But do i wrong??

Gr. Walko

by default csv uses comma as the delimiter. So it is seeing "1;SuperSportDeal01;actief;Coupon;Produkt;Bedrag;Specifiek;30" as one column. Go to awocoupon->configuration and change the csv delimiter to ";".