• From: Canada
  • Registered: 06/12/2010
  • Posts: 69

Topic: import paypal problem

Using frontaccounting 2.4.10 and import paypal module 2.4.0-2

When importing a paypal csv file I get this page:

Select payments' account

Nothing is on this page except an OK button and a back link.

Click on OK and get returned to the Banking and General Ledger page.

Nothing is imported.

The top of the paypal.log files shows:

[21-Nov-2021 17:42:37] file:paypal.CSV
[21-Nov-2021 17:42:37] Phase 2 start:454144
[21-Nov-2021 17:42:37] Memory, phase 2 process start:5667296
[21-Nov-2021 17:42:37] Second pass file: ../../tmp/tft_fa_adminpaypal.csv
[21-Nov-2021 17:42:37] Paypal act:3, withdrawal:4, sales:4000, tax:2150

then a long list of transactions contained in my csv file.

Even if I edit my csv file to eliminate payments, the same thing happens.

There is nothing in the errors.log file.

TIA for any help you can give me to get this working.

  • From: Canada
  • Registered: 06/12/2010
  • Posts: 69

Re: import paypal problem

With debugging I see this error:

Undefined index: Date in file: /srv/www/htdocs/frontaccounting/modules/import_paypal/import_paypal_update.php at line 264

Line 264 is this:

$date = $data["Date"];

Anything I read about "Undefined index" talks about using $_POST or $_GET in the line, but this seems to be a different usage.

I'm not all that familiar with coding. If anyone can suggest a solution I would appreciate it very much.

  • From: India, TN, Karur
  • Registered: 05/16/2014
  • Posts: 1,182

Re: import paypal problem

there are some errors i saw while installing the module,  @joe fix them on paypal_setup.php line no:23 

 if !defined('refresh_sys_prefs') {

to be 

 if (!defined('refresh_sys_prefs')) {


@ckrosco i feel your imported file doesn't have proper headers to continue.  Send me your top two lines from your CSV file. which you imported here .

Subscription service based on FA
HRM CRM POS batch Themes

kvvaradha's Website

4 Reply by ckrosco (edited by ckrosco 11/24/2021 05:34:26 pm)

  • From: Canada
  • Registered: 06/12/2010
  • Posts: 69

Re: import paypal problem

kvvaradha thanks for your help. Here are the first two lines of my csv file:

"Date","Time","TimeZone","Name","Type","Status","Currency","Gross","Fee","Net","From Email Address","To Email Address","Transaction ID","Shipping Address","Address Status","Item Title","Item ID","Shipping and Handling Amount","Insurance Amount","Sales Tax","Option 1 Name","Option 1 Value","Option 2 Name","Option 2 Value","Reference Txn ID","Invoice Number","Custom Number","Quantity","Receipt ID","Balance","Address Line 1","Address Line 2/District/Neighborhood","Town/City","State/Province/Region/County/Territory/Prefecture/Republic","Zip/Postal Code","Country","Contact Phone Number","Subject","Note","Country Code","Balance Impact"

"01/01/2021","02:32:38","EST","Rxxxxx Txxxxxxx","Express Checkout Payment","Completed","USD","120.20","-4.99","115.21","xxxxxxxx@gmail.com","xxxxxxxx@teafromtaiwan.com","5C638500WR1159345","Rxxxxx, Txxxxxxx, PO Box xxx, xxxxxxx, New South Wales, xxxx, Australia","Confirmed","Rui Feng Jin Xuan Milk Oolong Tea [101] Weight:: 75 grams, Dong Ding Ming Xiang Oolong Tea [2] Weight:: 75 grams, Four Season Oolong Tea [12] Weight:: 150 grams, Tsuei Luan Oolong Tea [14] Weight:: 150 grams, Shi Zuo Oolong Tea [13] Weight:: 75 grams","瑞峰金萱茶, 凍頂蜜香烏龍茶, 阿里山四季烏龍茶, 翠巒高級烏龍茶, 阿里山石棹烏龍茶","0.00","","0.00","","","","","","6120-1609486367-[TeaFromTaiwan]","EC-6120-1609486367","5","","221.56","PO Box xxx","","xxxxxxx","New South Wales","xxxx","Australia","xxxxxxxxx","Rui Feng Jin Xuan Milk Oolong Tea [101] Weight:: 75 grams","","AU","Credit"