Differant XML Hierarchy

Hello,

With this style of XML, you will find that Magic Parser does not auto-detect the best format string fro accessing all the information. This is because there are lots of OZL fields, so this is the element that is detected.

Looking at your XML, it looks like you need to use the following format string:

Click here to see your XML being parsed using this format string.

If you then use the "Generate PHP Source", you will see how to use this format string in your call to MagicParser_parse().

Hope this helps!
Cheers,
David.

Thank you David for quickly response.But i have problem with this style.

xml|INDEXGRUP/KATEGORI/GRUP/URUN/

this style dont includes , tag and values.Yes i can read all products details with your style but i need some modification for category information.

i need to import this data to my mysql db.

can you suggest anyway for this category problem?

Hi,

Because the information you want is not described by element names, you best way to handle this is to loop through $record, and construct an array of categories ($ozellik) by looking for "TANIM" and "DEGER" within each item in $record.

Once you have constructed the array, you can then insert values from the new $ozellik into MySQL as normal. Here is an example to show you what I mean:

Here is the output running on this server (first record only)

At the point where you see this code:

This is where you could insert the values into MySQL, for example the network interface value would be in the array variable:

And of course, you can use other variables from the main $record array, such as:

So, your code to insert into MySQL might look like this (but with more fields!)

Always use mysql_escape_string() when constructing SQL from variables so that the content does not break the structure of the SQL.

Hope this helps!
Cheers,
David.

David i realize now my previous message is missing.

i want to said that i need a solution for category and group tags.

my source:

All products of same categories are in just one category label.

When i import xml to mysql, i need a filter:

i should filter all data with CATEGORY and GROUP variable.How can i define category and group variable?

Please pay attention this status :

Hello,

Ah - I see what you want to get now. Unfortunately, this is quite complicated as Magic Parser is not designed to be a full-hierarchical parser; it is designed to make it easy to access lots of records at the same level.

However, it cam be done; but what you need to do is first parse your file at the higher level of INDEXGRUP/KATEGORI/ and build up an array to map products (by code) to category and group code.

So, the first part is to build up an array of kods $kods, like this:

Click here to see the output of this script.

Now what you need to do is combine this code with the first script, so you can see the category code and group code for each product, like this:

I'm sorry this is not ideal, but if you want to use Magic Parser for this sort of XML this is the only way to do it. Don't forget, if you decide you cannot use Magic Parser for this you can of course have your money back.

Hope this helps!

Cheers,
David.

Hi David,

i trying to use this code

i can add data from xml to my products table.but my products table has a product_id field and it has auto_increment feature.
when i add this products category information from xml to products_category table i should use this id value.
How can i do?

and can you give me a filter code?(like just show <KATEGORI KOD="IDX1012" products?

i hope its clear.

Best Regards and Thank you for all
S. Ozgur CANKURT

Hi,

Because you have actual product IDs (the URON-KODs), I would carry on using these instead of the auto-increment ID value.

This would mean that you don't necessarily have to update your products_category table whenever you update the products table, for example.

For your filter; instead of using the $kategorui, you should specify the field name, for example:

Hope this helps!
Cheers,
David.

Hi
i guess i could not explain.

please show this result : http://www.pdtedarik.com/entegrasyon/xml/test.php

you can see all categories and products data.

but i want to see just products in a category,i need a filter with kategori_kod and group_kod variables.
(kategori_kod] => IDX1012 [grup_kod] => 1250)

Thanks,

test.php source:

Hello,

I think I understand now.

You can filter it by "return"ing from myUrunRecordHandler if the product is not in the category and group that you want, using this code:

...here it is in your test.php:

Hope this helps!
Cheers,
David.

Hi David,
Thank you for all help.i need a last help.i have a headache for that. :)

you already now my xml structure.

i need importing my data with this database style.

IC-202W-G1 || GKB IP CAMERA - IC SERIES(yellow)

and i create this file with your help but its not completed.

Thank you for everythings.

Best Regards,
S. Ozgur CANKURT

Hi,

The first problem I think I can see - you have this code:

As this stands, it will delete every record in product_descriptions and products_categories
- is this what you want to do?

...but to make these only delete the current product, you need product_id from your products table.

However, since product_code is also unique, have you thought about making product_code the primary
key, then you don't need to get product_id for the current product? Then, these queries would be:

Does that make sense?

Cheers,
David.

Hi David,
i understand your suggestion its right but i dont have product_code in product_categories and product_descriptions tables.
maybe it can be that:

But my real problem about inserting products,categories and descriptions data from xml.

Best Regards,
S. Ozgur CANKURT

Hi David,
i try to use that.

but its turn all records "1" why?

Hi,

It is making them all 1 because of this line:

The <> is a comparison operator, so it returns TRUE (1) or FALSE (0).

I think it should just be:

Cheers,
David.

Hi
$urunadi = $record["URUN-AD"];

i use already this code,but i guess i have mistake when i update my table.

Because it writes all records just last xml records.

my records :

how can i fix that?

Hi,
i use that but i can not fix my problem.i guess its about my mysql query.

it writes just last records data from xml.it should insert all data from xml.

Thanks,

Hi,

Is the primary key (id) field on your table set to auto-increment?

No primarykey is not auto_increment.

i use this sql query for inserting data.

i need to fill product field in product_descriptions table with $record["URUN-AD"].

Thanks

NO its not auto_increment.

i use that but it insert just on records. WHY?i want all records from xml.

finally i fixed this problem thanks. :)

and
you created a code for me.

i can use this codes with this style :

but i need a solution for /OZL label.i want to insert all data in /OZL label

for instance:

i want to insert data to mysql like that:

What is necessary solution for that,can i use your $ozellik function?

Thank you for all,

Best Regards,
S. Ozgur CANKURT

Hello,

The way I would do this; because I don't think you always know what the fields are is to have a separate table:

Table: ozl

...and then yes, you can use the same code; and you can have a loop to insert the data:

Hope this helps!
Cheers,
David.

Hi David,
Thank you for loop codes.but it insert just first $ozellik record

it works just first $ozellik Baskı Boyutu and $deger.But if i use echo $tanim; i can see all $ozellik data i guess i have a mistake when i importing?

what do you think about that?

Thank you for all.
Best Regards,
S. Ozgur CANKURT

Hi,

Can you post the part of your code importing in the loop, I will have a look...

Cheers,
David.

Hi David,

i use this.

Best Regards,
S. Ozgur CANKURT

Hi David,

Loop code is that :

Hi,

Do you mean after it has run, you only have 1 record (per product) in the ozl table?

Hi David,
i use that.

and result :

Baskı Boyutu is my first record in ozellik from xml.

i want insert all data in /OZELLIK label from xml to my db.

Best Regards,
S. Ozgur CANKURT

Hi David,

have you any solution about this problem?

Thanks,

Hi,

Could you perhaps post the entire function so I can see more of the code?

I am a bit confused with the field names etc.!

Thanks,
David.

Hi David,

im sending you my all codes.

Hi David,

im sending you my all codes.

i fixed many problem with your help.im at last now.you already know problem,i want to insert all /OZL fields.

Thanks,

Hi,

At first glance, your code looks fine.

So I am wondering, in your product_descriptions table, is product_code a Primary Key?

If so, it must be unique so only the first description will be inserted. This could cause it.

If that is what is wrong, you need to make another primary key field (id) using auto-increment,
and the product_code can still be indexed, but a normal index, NOT a unique index...!

Cheers,
David.

Hi David,

its my product_description table.What should i do?

Thanks for all.
S. Ozgur CANKURT

Hi,

Looking at your code; I think it looks like you only want 1 product_descriptions record
per product, so the table definition can stay as it is.

But then this needs to change:

Do you want to build up a long description from each of the TANIM = DEGER?

If so, you can do that like this instead:

Hope this helps,
Cheers,
David.

Hi David,
your code works perfectly.Thank you for all you are best.

i have a little problem for you i can not fix.i want to write all $sql variable to a txt file.(gorevler.sql)

it write just one record and after add a "\n" but i need all sql data.

it mean

'".mysql_real_escape_string($urunkodu)."' = its a variable from xml.(you already know my system)

i want to write

Thanks david,
i find a solution for my previous problem.(it was about fwrite func)

but i need really your help now about magicparser.

i have this codes.i want to use '$kategori','$grup' variables for all products records.But you already know my xml structure its not standart.you created this function for me but its not work.

how can i fix that?

Best Regards,
S. Ozgur CANKURT

Hi,

Apologies for the delay.

Could you describe a little more what is not working....

Are you just getting no values in the $kods array?

Thanks,
David.

Hi David,

im fixed all problems with your great help.But i should create a better algorithm for categories because it needs more time for parsing.

What should i do for faster process time? (my xml file 3mb but this process time 35 min.+)

i need a better way for function myKategoriRecordHandler($record).


function myKategoriRecordHandler($record){
}
function myUrunRecordHandler($record){
$kategori = $kods[$record["URUN-KOD"]]["kategori_kod"];
$grup = $kods[$record["URUN-KOD"]]["grup_kod"];
}


Best Regards,
S. Ozgur CANKURT