Page 1 of 1
DOL Merchant Inventory Builder
PostPosted: Wed Mar 15, 2017 9:20 pm
by tegstewart
After putting together the INSERT statements for one merchant by hand, I decided I never want to do that again. So I banged out this quick and dirty tool late last night to do it for me.
Put in the ItemListID, pick a page number, and enter your ItemTemplateIDs in the text boxes. When you're finished, hit generate and it will copy the statements to the clipboard and display them in a textbox so you can inspect them and copy them out if the clipboard copy fails. Click Next Page to increment the page number and empty the ItemTemplateIDs for the next batch.
https://sourceforge.net/projects/dolmer ... tory/files
Re: DOL Merchant Inventory Builder
PostPosted: Thu Mar 16, 2017 8:25 am
by HunabKu
Thanks tegstewart.
Can you share the sources please ?
Re: DOL Merchant Inventory Builder
PostPosted: Thu Mar 16, 2017 8:43 am
by Graveen
Thank you !!
Do you had a look at CreatorSuite (previously ItemCreator) from Merec ? This is a consistent tool that allows you to create/update stuff for DOL.
This is exactly such a tool that i'd like to see being improved.
I'm not sure Merec released the sources publicly, honestly
edit: CS url link:
http://www.dolserver.net/viewtopic.php?f=13&t=17029
Re: DOL Merchant Inventory Builder
PostPosted: Thu Mar 16, 2017 8:47 am
by Graveen
I'll try to see what tools are availables and make a quick point to see what maintains, what improve, what discard.
Re: DOL Merchant Inventory Builder
PostPosted: Thu Mar 16, 2017 8:56 am
by HunabKu
Yep really sad Merec publish MapCreator sources but not CreatorSuite.
Re: DOL Merchant Inventory Builder
PostPosted: Thu Mar 16, 2017 8:37 pm
by tegstewart
Thanks tegstewart.
Can you share the sources please ?
Honestly, it's like 3 hours work and incredibly sloppily coded, so I'm kind of embarassed by it.
I'll put the code up anyway.
Re: DOL Merchant Inventory Builder
PostPosted: Thu Mar 16, 2017 8:42 pm
by tegstewart
Thank you !!
Do you had a look at CreatorSuite (previously ItemCreator) from Merec ? This is a consistent tool that allows you to create/update stuff for DOL.
This is exactly such a tool that i'd like to see being improved.
I'm not sure Merec released the sources publicly, honestly
edit: CS url link:
http://www.dolserver.net/viewtopic.php?f=13&t=17029
I noticed it when I came on here to post this, and took a quick look. I haven't done much with it yet, though.
I'm really finicky about doing things in the db by hand and storing all the statements I used to do so. When I finish my DB changes, I want to wipe and redo the DB from scratch, run all the .sql files to add the changes, and then upload that so I know any mistakes I made during development don't end up in the final product.