items import

[Ememjr]

I am working on items import and will be ready for testing on my system this weekend, and hopefully ready to import into emu next week
i will be starting with simpler and smaller sets

first one i will be doing is bags there are only 399 total bags in census and we seem to have 354 of them

here is where i need input from developement team

1. Fact-- DO not want to change existing item id's( becuase that whould screw up so much effort and work on whats already in content
2. existing items that have changed stats
a. do we want the updated to the new stats
b. do we keep them at the stats they had when imported last time
* i will be doing a lookup of each item when i import on my system to see if it already exists in the db( based on SOE item id) if (a.) above then i will update the item with updated info from census. if (b.) above ill skip the item
3. if its a new item i will add the item to the db
once i confirm the new items are working as intendedi will then
if (a.) above export all item table to JAB so that he may meraculousy run the sql script to update the emu database for all items, this will keep existing itemids in tact so no changes to other systems will be necessarry
if (b.) above i will just export the new items and associated changes and to Jab for import

i do not plan on any db structure changes during this time

please let me know your thoughts

[Jabantiz]

1) Keep our current id's. Changing them could break scripts or other parts that rely on the id's.

2) I would keep them as they were at import as it is less work. Eventually there will be a full editor for items so they can be changed if needed. Also keep in mind the item id's on SoE can change so you may want to search by item name as well.

3) I would export only the new items and then pm it to either me or Cynnar as we can both put it up on the server. We do have to do this through a phpmyadmin so large files are troublesome and that is why I say to only export the new items

[Ememjr]

i same thoughts exactly as yours

here is a little table on how item ids for our items are determined
start = starting item number for a particular item type
finish = ending item number for a particular item type
itemlimt = the current limit of items keeping with the same itemid scheme
total items = are the total # of items i was able to see on census for each type
continuation itemid once the inital space is filled ie itemsets is 1000 then the overflow will start its id at 422000
used = whether or not the continueation space needs to be used this go around

items.JPG