Jump to content

kathygriffin

Members
  • Posts

    33
  • Joined

  • Last visited

kathygriffin's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. Actually I did that wrong It will look like this. <?xml version="1.0" encoding="UTF-8"?> <add> <doc><field name="id">something</field> <field name="other1">something2</field> <field name="other3">something3</field> <field name="other4">something4</field> <field name="other5">something5</field> <field name="other6">something6</field> <field name="other7"><![CDATA[something7]]></field> <field name="other8"><![CDATA[something8]]></field> <field name="other9"><![CDATA[something9.jpg]]></field> <field name="other10a"><![CDATA[<p></p>]]></field> <field name="other10">something10</field> <field name="other11">something11</field> <field name="other12">something12</field> <field name="other13">something13</field> <field name="other14">something14</field> <field name="other16">something15</field> <field name="other16">something16</field> <field name="other18">something17</field> <field name="other18">something18</field> <field name="other18">something19</field></doc> </add>
  2. Well that still doesn't explain why it only queried half of the items. Because it did keep on querying.But on the old stuff..So that one I have yet to figure out. It works now and I am happy. Is there any log anywhere that might say? thank you
  3. Its the same exact query that I am sure of. Its 5.1.73 For some reason when I added another 20,000 items it never queried everything. Only the old stuff. So I deleted the even then readded it. Any suggestions or ideas where to look or what to do besides upgrading mysql? Thanks
  4. Thank you for letting me. Ok Here is what I am dealing with. Only its about 200,000 items. <?xml version="1.0" encoding="UTF-8"?> <add> <doc><field name="id">something</field> <field name="other1">something2</field> <field name="other3">something3</field> <field name="other4">something4</field> <field name="other5">something5</field> <field name="other6">something6</field> <field name="other7"><![CDATA[something7]]></field> <field name="other8"><![CDATA[something8]]></field> <field name="other9"><![CDATA[something9.jpg]]></field> <field name="other10a"><![CDATA[<p></p>]]></field> <field name="other10">something10</field> <field name="other11">something11</field> <field name="other12">something12</field> <field name="other13">something13</field> <field name="other14">something14</field> <field name="other15">something15</field> <field name="other16">something16</field> <field name="other17">something17</field> <field name="other18">something18</field> <field name="other19">something19</field></doc> </add>
  5. Wow thats exactly what it was. Turns out whenever you add more rows of data you have to go in and delete the old event then add it again. I am using 5.1 something i believe. Is this a bug or is this how mysql events are suppose to be ?
  6. I went ahead and deleted the event then added in a new one... I will keep eveyone posted.
  7. ok so I had this database of 20,000 items. My part numbers I had to add a gg in front of all them then add them into the same database. So I had the old part numbers that looked like this 33344 and new part numbers that looked like this gg33344. Now for some reason it is only totaling up the old numbers and not the new numbers. The same exact query with a recently new database was built and seems to have no issue with the letters being in front. So my guess is that if you insert new items into database you have to readd the event? Anyone have any ideas or input? example of new database after query ran for total my query is something like this total = (stock ny+ stock nc ) part number - stock ny - stock nc - total 33344 5 6 11 gg33344 5 6 0 34344 5 6 11 gg34344 5 6 0 36344 5 6 11 gg36344 5 6 0 thanks
  8. Sorry.. Heres what I am working with USE things; LOAD XML LOCAL INFILE 'C:/Users/computer/Documents/items.xml' INTO TABLE everything ROWS IDENTIFIED BY '<doc>'; /g Now in the xml file I have more than one field name that is named the same thing. For example I have 3 stuff2 and 4 stuff3s In my mysql table with the code I am using about it inserts only the first field of stuff2 and first field of stuff3s. So I setup stuff2 then stuff2a then stuff2b how would I get it setup to into the mysql column names that do match.
  9. How would I extract xml to go into the correct rows where the xml stuff1 is in there 4 times. I can't use stuff1 in mysql column because it will not allow me to use the same name... Any suggestions?
  10. Actually I just tried USE stuffdb; LOAD XML LOCAL INFILE 'C:/Users/computeruser/Desktop/stuff.xml' INTO TABLE stuff_load ROWS IDENTIFIED BY '<doc>' ; /g I will find out in about 4 hours if it worked..
  11. I did look at what you sent you but I am a bit confused here so if I have it right I would have to use it like this >>> USE stuffdb; LOAD XML LOCAL INFILE 'C:/Users/computeruser/Desktop/stuff.xml' INTO TABLE stuff_load (stuff1,stuff2, stuff3, stuff4, stuff5, stuff6, stuff7, stuff8, stuff9) ROWS IDENTIFIED BY '<doc>' /g Correct?
  12. A. Some files are 100 mb some others are about 200 mb. Some part numbers contains more data then others. B. I'm not seeing row anywhere. I have provided a example below. Thanks <doc><field name="id">22439789</field><field name="prtnmbr">22439789</field><field name="subprtnmbr">22439930</field><field name="mannmbr">00955tr</field><field name="listprc">370.95</field><field name="updatedate">2014-01-01T01:56:03Z</field><field name="iname"><![CDATA[TIRE 190/55 ZR17 PILOT ROAD3 B]]></field><field name="vname"><![CDATA[MICHELIN]]></field><field name="atrribute"><![CDATA[BIAS / RADIAL, RADIAL]]></field><field name="atrributevalueid">11</field><field name="atrribute"><![CDATA[SPEED RATING, (W)-&GT;168 MPH]]></field><field name="atrributevalueid">118</field><field name="atrribute"><![CDATA[LOAD INDEX, 75-853 LBS]]></field><field name="atrributevalueid">154</field><field name="producttype"><![CDATA[TIRES]]></field><field name="atrribute"><![CDATA[FADE, REAR]]></field><field name="atrributevalueid">464</field><field name="atrribute"><![CDATA[TUBE TYPE, TUBELESS]]></field><field name="atrributevalueid">556</field><field name="atrribute"><![CDATA[TIRE INNER DIAMETER, 17 INCH]]></field><field name="atrributevalueid">561</field><field name="atrribute"><![CDATA[WIDTH, 190 MM]]></field><field name="atrributevalueid">588</field><field name="atrribute"><![CDATA[ASPECT RATIO, 55]]></field><field name="atrributevalueid">593</field><field name="atrribute"><![CDATA[PURPOSE, STREET]]></field><field name="atrributevalueid">608</field><field name="atrribute"><![CDATA[TIRE LINE, PILOT ROAD]]></field><field name="atrributevalueid">677</field><field name="atrribute"><![CDATA[TIRE BRAND, MICHELIN]]></field><field name="atrributevalueid">689</field><field name="atrribute"><![CDATA[VERSION, LOADED/TWO-UP]]></field><field name="atrributevalueid">692</field></doc>
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.