Jump to content
Sign in to follow this  
expert

SUPPORT : XML Export contribution

Recommended Posts

I was wondering if there is a XML export mod. that will export your products with their respective .htaccess modified SEF URLs?

 

Hmmm... I know I need one!

 

I am sure their has to be others that need it also...

 

Looks like I am going to have to build one if its not developed already...

 

Expert...

 

Think you could give me a hand with your code so I could format the XML output to build the URL in the same pattern the Ultimate SEO url contrib uses?

 

Could be a great project... you have most of it written... just need to format the output...

 

if it is not already availible...

 

Adam

 

Actually adding full product path using SEO URL mode would be usefull. You can add it if you can, or stay tuned I will look at that.

Share this post


Link to post
Share on other sites

hi

 

great contribution .. works out of the box. Now i'm trying to validate it with some online xml checkers .. one at http://www.cogsci.ed.ac.uk/~richard/xml-check.html gives me following error

 

Warning: Document has no DTD, validating abandoned

(detected at end of prolog of document http://www...../exportfile.xml)

Error: Input error: Illegal UTF-8 byte 2 <0x65> at file offset 690

in unnamed entity at line 14 char 10 of http://www..../exportfile.xml

 

this first one is the one that worries me .. second one will be solved with full transaltion to utf charset .. i guess

 

thanx in advance

Share this post


Link to post
Share on other sites

DTD validation shouln't be a problem. I've check my export XML and it says Ok.

 

Anybody else encounters same DTD validation problem?

 

Btw, much improved version of XML Export is coming soon. Following iprovements are almost done;

 

- Running in standard admin interface

- Static texts are now in seperate langulage file

- Full product URL is now added into XML (SEO URL can be implemented but SEO class is not in admin, so some extra work is needed to run SEO in Admin (I don't want to move export script file in catalog side due to some possible unauthorized access from anybody - In addition to that please see my note below about your data security)

- Code is now more in osC code syntax

- Warning and success messages are now displayed in current osC $messagestack style at top.

 

XML Data Security warning: Please note that your generated XML can be accessed anybody from /dataexport/ folder. In order to avoid to stole your XML data please change /dataexport/ folder name in script and also don't use default exportfile.xml filename. And I strongly advice you to use .htaccess in that folder to avoid public folder listing.

Share this post


Link to post
Share on other sites
Sure. You have products data. You can use it in another format as well as XML tags that we used here.

 

Sample:

 

$csv_file = $product['model'] . '|' . $product['name'] . '|' . $product['description'] . '\n';

 

Hi,

I tried to modify the file .... No success. The output file is not in txt format. Erhan, I'm not a programmer. :blush:. Can you help me to do those modifications?

The .txt file must be in the following format:

 

3049|Accesorii laptop|Acer|8 cell 4400mAh Lithium-Ion|Baterie Acer Lithiu-Ion 8 celule, 4400mAh.                                                   |596.07|RON cu TVA|prin curier|12|http://www.oktal.ro/detalii_accesorii laptop_acer_8 cell 4400mah lithium-ion_3049_4|http://www.oktal.ro/produse/foto/3049_acer.jpg
2227|Accesorii laptop|HP|Secondary Travel Battery (PB993A)|Dubleaza timpul de operare a laptopului dvs. fara sa reincarcati acumulatorul. Cu incarcare si descarcare controlata aveti intotdeauna acumulatorul laptopului dvs. aproape incarcat.                                               |528.13|RON cu TVA|prin curier|12|http://www.oktal.ro/detalii_accesorii laptop_hp_secondary travel battery (pb993a)_2227_4|http://www.oktal.ro/produse/foto/2227_Secondary-Travel-Battery.jpg
2835|Accesorii laptop|HP|Carepack 3years Pick Up & Return HW Support|Prelugeste garantia laptopului dumneavoastra de la 1 an la 3 ani. Se poate achizitiona oricand in perioada de garantie a produsului. Exclusiv pentru produsele achizitionate de la firma Oktal Computers!                              |523.53|RON cu TVA|prin curier|36|http://www.oktal.ro/detalii_accesorii laptop_hp_carepack 3years pick up & return hw support_2835_4|http://www.oktal.ro/produse/foto/2835_HPCarePack.JPG
3054|Accesorii laptop|Toshiba|Warranty Extension( SE5003I-PDB)|Warranty Extension from 1 to 3 years, Notebooks with 1 year standard warranty           |495.12|RON cu TVA|prin curier|12|http://www.oktal.ro/detalii_accesorii laptop_toshiba_warranty extension( se5003i-pdb)_3054_4|http://www.oktal.ro/produse/foto/3054_toshiba.jpg
3059|Accesorii laptop|Toshiba|Notebook Car Adapter (PX1188E-1NPO)|Notebook Car Adapter - 120W, 15V, 8A - black, Satellite/Pro 2410/5xxx/A10/A40/A50/M30/A80/M60 ; Portégé 20xx/3500/40xx/R100 ; Tecra 9100/M1/M2/S1/A3/S2/M3 ; Qosmio -F10/-G10/-G20/-F20      |600.88|RON cu TVA|prin curier|12|http://www.oktal.ro/detalii_accesorii laptop_toshiba_notebook car adapter (px1188e-1npo)_3059_4|http://www.oktal.ro/produse/foto/3059_adaptor.jpg
3060|Accesorii laptop|Toshiba|Notebook Car Adapter(PX1189E-1NPO)|Notebook Car Adapter - 120W, 19V, 6.3A - black, Satellite/Pro 19xx/A30/A60/P10/P20/M30X/L10            |600.88|RON cu TVA|prin curier|12|http://www.oktal.ro/detalii_accesorii laptop_toshiba_notebook car adapter(px1189e-1npo)_3060_4|http://www.oktal.ro/produse/foto/3060_no.jpg
2543|Antivirus|Computer Associates|eTrust Antivirus v7.1 ETRAVE7105BPMX|eTrust Antivirus v7.1 - 5 Users - Includes Antivirus protection for the Desktop, Server, Gateway, Groupware, and PocketPC - Product only                  |746.65|RON cu TVA|prin curier|0|http://www.oktal.ro/detalii_antivirus_computer associates_etrust antivirus v7.1 etrave7105bpmx_2543_4|http://www.oktal.ro/produse/foto/2543_et_antivirus.jpg
2544|Antivirus|Computer Associates|eTrust Antivirus v7.1 ETRAVE7110BPMX|eTrust Antivirus v7.1 - 10 Users - Includes Antivirus protection for the Desktop, Server, Gateway, Groupware, and PocketPC - Product only                              |1493.30|RON cu TVA|prin curier|0|http://www.oktal.ro/detalii_antivirus_computer associates_etrust antivirus v7.1 etrave7110bpmx_2544_4|http://www.oktal.ro/produse/foto/2544_et_antivirus.jpg
2545|Antivirus|Computer Associates|eTrust Antivirus v7.1 ETRAVE7125BPMX|eTrust Antivirus v7.1 - 25 Users - Includes Antivirus protection for the Desktop, Server, Gateway, Groupware, and PocketPC - Product only                                          |3733.24|RON cu TVA|prin curier|0|http://www.oktal.ro/detalii_antivirus_computer associates_etrust antivirus v7.1 etrave7125bpmx_2545_4|http://www.oktal.ro/produse/foto/2545_et_antivirus.jpg
2548|Antivirus|Computer Associates|eTrust Antivirus v7.1 ETRAVE7110BPUX|eTrust Antivirus v7.1 - 10 Users - Upgrade from any previous version of eTrust InoculateIT - Includes Antivirus protection for the Desktop, Server, Gateway, Groupware, and PocketPC - Product only|895.88|RON cu TVA|prin curier|0|http://www.oktal.ro/detalii_antivirus_computer associates_etrust antivirus v7.1 etrave7110bpux_2548_4|http://www.oktal.ro/produse/foto/2548_et_antivirus.jpg
2549|Antivirus|Computer Associates|eTrust Antivirus v7.1 ETRAVE7125BPUX|eTrust Antivirus v7.1 - 25 Users - Upgrade from any previous version of eTrust InoculateIT - Includes Antivirus protection for the Desktop, Server, Gateway, Groupware, and PocketPC - Product only      |836.47|RON cu TVA|prin curier|0|http://www.oktal.ro/detalii_antivirus_computer associates_etrust antivirus v7.1 etrave7125bpux_2549_4|http://www.oktal.ro/produse/foto/2549_et_antivirus.jpg
1544|Antivirus|McAfee|McAfee Active Virus Defense SMB Edition (incl. Protection Pilot) 5 USERS Perpetual Licence Pack with 1 yr Gold Support|McAfee Active Virus Defense SMB Edition (incl. Protection Pilot) 5 USERS Perpetual Licence Pack with 1 yr Gold Support ADM80M005TAA                            |1491.96|RON cu TVA|prin curier|0|http://www.oktal.ro/detalii_antivirus_mcafee_mcafee active virus defense smb edition (incl. protection pilot) 5 users perpetual licence pack with 1 yr gold support_1544_4|http://www.oktal.ro/produse/foto/1544_mcafee_logo.jpg
1545|Antivirus|McAfee|McAfee Active Virusscan SMB Edition (incl. Protection Pilot) 5 USERS Perpetual Licence Pack with 1 yr Gold Support|McAfee Active Virusscan SMB Edition (incl. Protection Pilot) 5 USERS Perpetual Licence Pack with 1 yr Gold Support SVM80M005TAA                                       |755.67|RON cu TVA|prin curier|0|http://www.oktal.ro/detalii_antivirus_mcafee_mcafee active virusscan smb edition (incl. protection pilot) 5 users perpetual licence pack with 1 yr gold support_1545_4|http://www.oktal.ro/produse/foto/1545_mcafee_logo.jpg
2686|Antivirus|Symantec|Norton Antivirus 2006 (NAV 2006 12.0 IN SMO 5 USR)|Norton Antivirus 2006 (NAV 2006 12.0 IN SMO 5 USR) – full product SY-10432459-IN                                          |711.09|RON cu TVA|prin curier|0|http://www.oktal.ro/detalii_antivirus_symantec_norton antivirus 2006 (nav 2006 12.0 in smo 5 usr)_2686_4|http://www.oktal.ro/produse/foto/2686_symantec_logo.jpg
2687|Antivirus|Symantec|Norton Antivirus 2006 (NAV 2006 12.0 IN SMO 5 USR UPG)|Norton Antivirus 2006 (NAV 2006 12.0 IN SMO 5 USR UPG)                                      |547.36|RON cu TVA|prin curier|0|http://www.oktal.ro/detalii_antivirus_symantec_norton antivirus 2006 (nav 2006 12.0 in smo 5 usr upg)_2687_4|http://www.oktal.ro/produse/foto/2687_symantec_logo.jpg

 

Thank you

Edited by auro

Share this post


Link to post
Share on other sites

Hello.

 

I was just wondering how far the import of the xml is? I al looking the whole day after some module or contrib, to do this, but had no luck... So basically you're my last chance.

 

Cheers!

Share this post


Link to post
Share on other sites
Hi,

I tried to modify the file .... No success. The output file is not in txt format. Erhan, I'm not a programmer. :blush:. Can you help me to do those modifications?

 

Thank you

 

Erhan, can you help me?

Tnx.

Share this post


Link to post
Share on other sites
Erhan, can you help me?

Tnx.

 

Sorry, text export format is not my intention. You can find several contributions which allow text format export.

Share this post


Link to post
Share on other sites

Hello,

This is a great contribution, thanks to the author! I need to display the price including taxes in the exportfile! How can I do that? Can anyone help please?

Thanks!

pietonul.

Share this post


Link to post
Share on other sites
Hello,

This is a great contribution, thanks to the author! I need to display the price including taxes in the exportfile! How can I do that? Can anyone help please?

Thanks!

pietonul.

 

Hi Expert.

 

Can you please advise where you are with XML IMPORT.

Is there any alternative you can advise what I am looking for.

 

My Trading company is offering XML services, which can show Live Stock update on my Site. and Also system to check update product images every night. and so many live XML services, but my main intention is above two.

 

 

Can you please advise any contribution on XML import. or how long it will take for release of your contribution.

 

Regards

 

Zee

Share this post


Link to post
Share on other sites

Expert,

 

There is an issue with the xml export in that if there is an "&" in the image file name or brand (mfr) name, it will not change it to & which is the appropriate xml display of an "&", causing the file to fail if you parse it.

 

Just letting you know.


Rich

SmartFeed Product Feed Manager

Share this post


Link to post
Share on other sites

Hi, this is a great module and I was able to get it going without any troubles... my only question is when I do an export, it creates the initial file, but I'd like to be able to overwrite the file with the same name. Right now I have to manually delete the file in order to create a new version of the same name. Is there a way to do this?

 

Many thanks,

Janet

Share this post


Link to post
Share on other sites

Hi, I have problems with product price special. On some products with special price, instead of special price is just "1.00".

Does anybody else also has that problem ?

 

BTW tnx for this contribution!

Share this post


Link to post
Share on other sites

Dear Expert,

Please explain in little more detail as I am a newbie, as to how to use your contribution, as it appears to be quite valuable. But I couldn't configure it correctly. I have copies the files & created a link explained in this section for xml_export.php. But I am getting the following error on clicking the link.

 

PHP Fatal error: Cannot redeclare do_magic_quotes_gpc() (previously declared in E:\Program Files\Ensim\WEBppliance\SiteData\Domains\cbsindia.in\ROOT\Inetpub\wwwroot\orissaitbazaar\admin\includes\functions\compatibility.php:18) in E:\Program Files\Ensim\WEBppliance\SiteData\Domains\cbsindia.in\ROOT\Inetpub\wwwroot\orissaitbazaar\admin\includes\functions\compatibility.php on line 18

 

I have also edited two files first - admin\includes\boxes\catalog.php by including this line

'<a href="' . tep_href_link(FILENAME_XML_EXPORT) . '" class="menuBoxContentLink">' . BOX_XML_EXPORT . '</a><br>' . // XML EXPORT

second file is \admin\includes\filenames.php by including this line

define('FILENAME_XML_EXPORT', 'xml_export.php');

 

Please help.

 

 

This is support threat of XML Export contrib. Please post any query here if you need any assistance or help or comment,

 

Basicaly this contrib helps you creating XML feed for products in your db. You can export whole db or you can select any categories to export.

You can easily modify XML structure.

 

You can donwload it from http://www.oscommerce.com/community/contributions,5354

 

Now I'm focusing on XML Import feature. Importing XML is a little bit tedious for me but its time to create alternative for Easy Populate since Vendors start feeding in XML. Better to implement some XML maps to import from various vendor feeds. If there is any contributer to give me a hand it would be really apreciated.

Edited by pkjoshi

Share this post


Link to post
Share on other sites

is there a way to export by language? i want to export a file for english, for frenche...etc

 

right now, only export the xml in spanish (my default language)

 

thanks

 

Luis

Share this post


Link to post
Share on other sites
is there a way to export by language? i want to export a file for english, for frenche...etc

 

right now, only export the xml in spanish (my default language)

 

thanks

 

Luis

 

no, this works only for default language. I didn't plan to make it multi language. but can be done.

Share this post


Link to post
Share on other sites
Dear Expert,

Please explain in little more detail as I am a newbie, as to how to use your contribution, as it appears to be quite valuable. But I couldn't configure it correctly. I have copies the files & created a link explained in this section for xml_export.php. But I am getting the following error on clicking the link.

 

PHP Fatal error: Cannot redeclare do_magic_quotes_gpc() (previously declared in E:\Program Files\Ensim\WEBppliance\SiteData\Domains\cbsindia.in\ROOT\Inetpub\wwwroot\orissaitbazaar\admin\includes\functions\compatibility.php:18) in E:\Program Files\Ensim\WEBppliance\SiteData\Domains\cbsindia.in\ROOT\Inetpub\wwwroot\orissaitbazaar\admin\includes\functions\compatibility.php on line 18

 

I have also edited two files first - admin\includes\boxes\catalog.php by including this line

'<a href="' . tep_href_link(FILENAME_XML_EXPORT) . '" class="menuBoxContentLink">' . BOX_XML_EXPORT . '</a><br>' . // XML EXPORT

second file is \admin\includes\filenames.php by including this line

define('FILENAME_XML_EXPORT', 'xml_export.php');

 

Please help.

 

I don't have any idea about this problem. Did you place all the files correctly? This error generally occurs when you add accidentaly any of main file into language folder. Because names are the same.

Edited by expert

Share this post


Link to post
Share on other sites

Howdy,

 

Thanks for posting this excellent utility.

 

Out of interest, I would like to change the encoding to UTF8 but am struggling to ind where you set it to windows 1254. How is the xml encoding configured?

 

Kind Regards,

 

Stu


A crash reduces your expensive computer to a simple stone.

Share this post


Link to post
Share on other sites

It can be changed here:

 

  if (tep_db_num_rows($products_query)) {
$xml_file.="<?xml version=\"1.0\" encoding=\"windows-1254\"?>\n";

 

Howdy,

 

Thanks for posting this excellent utility.

 

Out of interest, I would like to change the encoding to UTF8 but am struggling to ind where you set it to windows 1254. How is the xml encoding configured?

 

Kind Regards,

 

Stu


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

Regards,

 

Snowbird

Share this post


Link to post
Share on other sites

Soon powerfull XML import engine is on the way


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

Regards,

 

Snowbird

Share this post


Link to post
Share on other sites

It is ready actually, but my posts have been deleted related XML Core System Engine bu admins.

Actually they don't realize that this engine will extend usage of osCommerce very efficiently.

 

I need wordwide XML data feederd to add modules for this engine.

 

Please provide me some XML samples from suppliers. erhanas@gmail.com

 

http://english.duzgun.com for more information

 

Regards,


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

Regards,

 

Snowbird

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×