osCommerce (Page 2 of 3)

I think so, write method is the right one to store item_cart content to database .
BTW htmlspecialchars_decode is PHP5 only function, so we use html_entity_decode instead to support PHP4. I forgot details why in db_escape()  htmlspecialchars is used and not htmlentities, but this works right.

Janusz

I get an error when I try to run the import.  In my log says:

[Wed Jul 22 23:05:19 2009] [error] [client XX.XX.XX.123] 0:admin:ui_lists.inc:23: Non-static method reserved_words::get_all() should not be called statically, referer: http://www.XXXXX.com/frontaccount/modules/osc/osCommerce.php?
[Wed Jul 22 23:05:21 2009] [error] [client XX.XX.XX.123] 0:admin:ui_lists.inc:23: Non-static method reserved_words::get_all() should not be called statically, referer: http://www.XXXXX.com/frontaccount/modules/osc/osCommerce.php
[Wed Jul 22 23:05:21 2009] [error] [client XX.XX.XX.123] 0:admin:osCommerce.php:488: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource, referer: http://www.XXXXX.com/frontaccount/modules/osc/osCommerce.php
[Wed Jul 22 23:05:21 2009] [error] [client XX.XX.XX.123] 0:admin:osCommerce.php:491: mysql_free_result(): supplied argument is not a valid MySQL result resource, referer: http://www.XXXXX.com/frontaccount/modules/osc/osCommerce.php
[Wed Jul 22 23:05:21 2009] [error] [client XX.XX.XX.123] 0:admin:osCommerce.php:494: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource, referer: http://www.XXXXX.com/frontaccount/modules/osc/osCommerce.php
[Wed Jul 22 23:05:21 2009] [error] [client XX.XX.XX.123] 0:admin:osCommerce.php:496: mysql_free_result(): supplied argument is not a valid MySQL result resource, referer: http://www.XXXXX.com/frontaccount/modules/osc/osCommerce.php
[Wed Jul 22 23:05:21 2009] [error] [client XX.XX.XX.123] 0:admin:ui_lists.inc:934: Non-static method reserved_words::get_all_numeric() should not be called statically, referer: http://www.XXXXX.com/frontaccount/modules/osc/osCommerce.php
[Wed Jul 22 23:05:21 2009] [error] [client XX.XX.XX.123] 0:admin:date_functions.inc:127: date() [<a href='function.date'>function.date</a>]: It is not safe to rely on the system's timezone settings. Please use the date.timezone setting, the TZ environment variable or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/Denver' for 'MDT/-6.0/DST' instead, referer: http://www.XXXXX.com/frontaccount/modules/osc/osCommerce.php
[Wed Jul 22 23:05:21 2009] [error] [client XX.XX.XX.123] 0:admin:date_functions.inc:128: date() [<a href='function.date'>function.date</a>]: It is not safe to rely on the system's timezone settings. Please use the date.timezone setting, the TZ environment variable or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/Denver' for 'MDT/-6.0/DST' instead, referer: http://www.XXXXX.com/frontaccount/modules/osc/osCommerce.php
[Wed Jul 22 23:05:21 2009] [error] [client XX.XX.XX.123] 0:admin:date_functions.inc:129: date() [<a href='function.date'>function.date</a>]: It is not safe to rely on the system's timezone settings. Please use the date.timezone setting, the TZ environment variable or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/Denver' for 'MDT/-6.0/DST' instead, referer: http://www.XXXXX.com/frontaccount/modules/osc/osCommerce.php
[Wed Jul 22 23:05:21 2009] [error] [client XX.XX.XX.123] 0:admin:date_functions.inc:140: date() [<a href='function.date'>function.date</a>]: It is not safe to rely on the system's timezone settings. Please use the date.timezone setting, the TZ environment variable or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/Denver' for 'MDT/-6.0/DST' instead, referer: http://www.XXXXX.com/frontaccount/modules/osc/osCommerce.php
[Wed Jul 22 23:05:22 2009] [error] [client XX.XX.XX.123] 0:admin:ui_lists.inc:23: Non-static method reserved_words::get_all() should not be called statically, referer: http://www.XXXXX.com/frontaccount/modules/osc/osCommerce.php?action=cimport
[Wed Jul 22 23:05:22 2009] [error] [client XX.XX.XX.123] 0:admin:osCommerce.php:282: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource, referer: http://www.XXXXX.com/frontaccount/modules/osc/osCommerce.php?action=cimport

Can anyone help?

I have downloaded and Installed the osCommerce integration module. It imports customers and sales orders from osCommerce accurately. Although I have one question. The items created in osCommerce how are they being integrated with FA. Do I create the items in FA or osCommerce, and how do I sync the items on both applications. Thank you.

Joe,

I am updating the oscommerce module for FA22 and have a question about security areas:

$security_areas['SA_OSCIMPORT'] = array(SS_SALES|100, "osCommerce Customer / Order Import");

I looked at other modules but do not see any hint at rules for the array values.

In the above statement I used 100, but do those have to be unique for all entries?
for the SS_SALES group? etc

tom

I wonder if it would be easy to check the values in setup when enabling roles. (Since they are all listed on that page)

Hello Tom,

You can use sucurity area codes starting from 100 for extension module.They are anyway rewritten during installing extension, and you will never use SA numeric codes directly, only string security areas identifiers like 'SA_OSCIMPORT'.
All this is explained in FrontAccounting access control system basics article. If some info is missing feel free to update the documentation.
Janusz

Hi guys,

I had a go at using this today and tried to import the customers and it says customers found, but nothing is imported.

Exact steps i took was to install the Australian Chart of accounts which sets up the tax codes and the I went back into osCommerce and set tax codes and classes to agree with FA. Then I made sure the default tax class was set for the customers.

I have the customer categories add on so I have different prices for retail and wholesalers etc. Would this have an impact?

Rod

I looked in FA but your script says none are added. I just checked the SQL table for 0_debtors_master too!

What table to you store your next numbers to process in?

You can set the customerID range by changing:

Starting osC Customer ID:   
Ending osC Customer ID:

before you click [Import osC Customers]

Tom, That is what was in your default file and I have not changed it. Fairly steep learning curve for one day for me. I'll have a good look at once I get my head around FA a bit better.

OK Tom, I am ready to tackle this now as I have made a commitment to use FA from her on.

I see a green bar that says customers found, 0 customers imported. How can I debug this? Can I get FA to print some messages on the screen about what it finds?

t could be my setup as I have added a module to OsC that allows me to have multiple price breaks whihc are each asociated with a tax type. It is possible your module is not looking deep enough in the OsC data files on my setup due to this.

Can you clarify this?

osc:

products_id in products table

should match

FrontAccount:

id in item_codes table

Is that correct?