36 replies to this topic

[kuwaz]

Autobuyer List Creation
Using notepad++, regex, Jellyneo

Okay, this is some pretty basic regular expression that can help make
lists easier, don't know if people are using this method or not, but here's my method:

1) Go to Jellyneo and filter out your items like usual:
*) Jellyneo.net's Item Database

2) Get notepad++ or any advanced notepad program:
*) .:: NOTEPAD++ ::.

3) Copy and paste the raw data from Jellyneo into notepad++

Maverick Plushie
49,000,000 NP     Darkest Faerie Plushie
Darkest Faerie Plushie
35,000,000 NP     Ski Lodge Mutant Kacheek Plushie
Ski Lodge Mutant Kacheek Plushie
25,000,000 NP     NeoQuest Plushie
NeoQuest Plushie
25,000,000 NP     Ylana Skyfire Plushie
Ylana Skyfire Plushie
20,000,000 NP
Sophix II Plushie
Sophix II Plushie
20,000,000 NP     Smugglers Cove Pirate Plushie
Smugglers Cove Pirate Plushie
20,000,000 NP     MSPP Plushie
MSPP Plushie
20,000,000 NP     Fauna Plushie
Fauna Plushie
20,000,000 NP     Island Kacheek Plushie
Island Kacheek Plushie
15,000,000 NP
Jerdana Plushie
Jerdana Plushie
14,500,000 NP     Fish Negg Plushie

4) Ctrl+H for find/replace

5) Find: ^[0-9](.*)\sNP
*) Replace:
*) //basically replace with blank
*) Search Mode: regular expression

*) Press Replace All

Maverick Plushie
     Darkest Faerie Plushie
Darkest Faerie Plushie
     Ski Lodge Mutant Kacheek Plushie
Ski Lodge Mutant Kacheek Plushie
     NeoQuest Plushie
NeoQuest Plushie
     Ylana Skyfire Plushie
Ylana Skyfire Plushie

Sophix II Plushie
Sophix II Plushie
     Smugglers Cove Pirate Plushie
Smugglers Cove Pirate Plushie
     MSPP Plushie
MSPP Plushie
     Fauna Plushie
Fauna Plushie
     Island Kacheek Plushie
Island Kacheek Plushie

Jerdana Plushie
Jerdana Plushie
     Fish Negg Plushie

6) Find: \s\t
*) Replace:
*) //basically replace with blank
*) Search Mode: regular expression

*) Press Replace All

Maverick Plushie
Darkest Faerie Plushie
Darkest Faerie Plushie
Ski Lodge Mutant Kacheek Plushie
Ski Lodge Mutant Kacheek Plushie
NeoQuest Plushie
NeoQuest Plushie
Ylana Skyfire Plushie
Ylana Skyfire Plushie

Sophix II Plushie
Sophix II Plushie
Smugglers Cove Pirate Plushie
Smugglers Cove Pirate Plushie
MSPP Plushie
MSPP Plushie
Fauna Plushie
Fauna Plushie
Island Kacheek Plushie
Island Kacheek Plushie

Jerdana Plushie
Jerdana Plushie
Fish Negg Plushie

7) In your menu, go to TextFX > TextFX Tools
*) Check +Sort only outputs UNIQUE (at column) lines

*) In your menu, go to TextFX > TextFX Tools
*) Press Sort line case sensitive (at column)

Darkest Faerie Plushie
Fauna Plushie
Fish Negg Plushie
Island Kacheek Plushie
Jerdana Plushie
MSPP Plushie
Maverick Plushie
NeoQuest Plushie
Ski Lodge Mutant Kacheek Plushie
Smugglers Cove Pirate Plushie
Sophix II Plushie
Ylana Skyfire Plushie

8) Can probably just write an AJAX script to do this automatically
and output to file, since its the same format every time, but I'm lazy.

Note: Since ABer's search functions are usually in a while/for loop
chronologically scrolling the list and break when it finds a match to purchase,
putting the items in order of worth is better...

When matching by alphabetical the function will always try to go for the
first match and break out of the while/for loop... thus put your list in order of
worth to get better results, and always the highest profit item every restock.

---

Let me know if you find this helpful, looking to make more basic tech guides.

Edited by channel_49, 25 July 2009 - 06:45 PM.

[ShadowLink64]

I can't wait until we can do this here with the items DB.

[kuwaz]

I can't wait until we can do this here with the items DB.

Yeah that would help A LOT, their filter systems is very limiting
and their database search functions are really flawed in terms of what
you can do, I think maybe they want to limit it? perhaps thats the
reason, but it drives me nuts when I have to reorder things manually haha.

[Waser Lave]

Yeah that would help A LOT, their filter systems is very limiting
and their database search functions are really flawed in terms of what
you can do, I think maybe they want to limit it? perhaps thats the
reason, but it drives me nuts when I have to reorder things manually haha.

Feel free to make some suggestions on what kind of functionality you would want on this part.

[jcrdude]

If I were to generate a list for auto-buying, one of the prime items I would want in said list is estimated profit. Once the item database is up and running, and people are out there restocking it should be a matter of finding the difference... but then again, it shouldn't take a large amount of reasoning to figure out that if an item is selling for 80k, it's pretty profitable, and if one's selling for 286k it's very profitable.

That's just speed math there.

But the reason that I would want "profit sorting" would be to properly organize said list for optimal stocking

[Waser Lave]

If I were to generate a list for auto-buying, one of the prime items I would want in said list is estimated profit. Once the item database is up and running, and people are out there restocking it should be a matter of finding the difference... but then again, it shouldn't take a large amount of reasoning to figure out that if an item is selling for 80k, it's pretty profitable, and if one's selling for 286k it's very profitable.

That's just speed math there.

But the reason that I would want "profit sorting" would be to properly organize said list for optimal stocking

Yep we already planned to have ordering by profit AND/OR price.

[jcrdude]

Yep we already planned to have ordering by profit AND/OR price.

Well then I'm fresh out of ideas. I only have basic ones ATM... I'd have to toy with execution before anything of great merit would come out.

Glad to know you folks are already on top of this

[kuwaz]

Yep we already planned to have ordering by profit AND/OR price.

One thing that would be important is multiple queries of any column,
for example, more then one category can be queried, or more than one
rarity. It would also be nice to sort not only a range, but by ranged
that can exclude certain things.

Best explained through a query haha.

SELECT * FROM items WHERE category IN ("a","b","c","d","e") OR name IN ("a","b","c","d","e");
SELECT * FROM items WHERE (rarity BETWEEN 60 AND 70) OR (rarity BETWEEN 90 AND 100);

Would be nice if the items were also sorted by which shop they can
be purchased from, jelly has that but you can't query specifically
for restockable items.

Feature that can output a sql dump of a specific column or multiple
columns can help with making lists not just for restock but other things
as well, similar to a sql gui export.

That's all I have for now, but that pretty much covers mostly all
multiple queries in general.

Edited by channel_49, 06 July 2009 - 09:10 AM.

[Waser Lave]

One thing that would be important is multiple queries of any column,
for example, more then one category can be queried, or more than one
rarity. It would also be nice to sort not only a range, but by ranged
that can exclude certain things.

Best explained through a query haha.

SELECT * FROM items WHERE category IN ("a","b","c","d","e") OR name IN ("a","b","c","d","e");
SELECT * FROM items WHERE (rarity BETWEEN 60 AND 70) OR (rarity BETWEEN 90 AND 100);

Would be nice if the items were also sorted by which shop they can
be purchased from, jelly has that but you can't query specifically
for restockable items.

Feature that can output a sql dump of a specific column or multiple
columns can help with making lists not just for restock but other things
as well, similar to a sql gui export.

That's all I have for now, but that pretty much covers mostly all
multiple queries in general.

I don't think a lot of that is necessary tbh. Because it's for creating restock lists you wouldn't need to search categories or by item names, the main search field would be the mainshop which the item stocks in. Rarity will have a range which you can search though.

And I don't think we'll want to produce sql dumps of our data...

[kuwaz]

I don't think a lot of that is necessary tbh. Because it's for creating restock lists you wouldn't need to search categories or by item names, the main search field would be the mainshop which the item stocks in. Rarity will have a range which you can search though.

And I don't think we'll want to produce sql dumps of our data...

Oh, what hydro told me was that the aber works based on the database
anyways, so sorting might not be an issue. All I wanted to see is that
the aber shops by margin of profit, which is going to be implemented
anyways, so maybe not needed for the manual queries.

Since the aber is not going to use a list anyways, it won't matter much
when it connected to the db and check for prices or profit, then searches
priority based on those.

Edited by channel_49, 06 July 2009 - 11:16 AM.

[whatwhat]

I just use the 'simple' view option on the items database here, and crop out the extra info in notepad. It works like a charm.

[swerving2win]

There is a way to prevent it from breaking the profit list sequence when you alphabetize the list

Follow the first two original steps: search a DB by profit or price, copy raw data into notepad++


-Select All
-First make sure TextFX -> TextFX Tools -> +Sort only outputs UNIQUE (at column) lines (I do this step first but I am unsure if it needs to be)

-Next Make sure everything is still selected. hit Ctrl+H and do the query channel_49 shared:
Find: ^[0-9](.*)\sNP
Replace:
Using regular expression etc...
*You may have to repeat this step twice depending on what DB you use.

-Make sure everything is still selected, Ctrl+H and just query:
Find: \t
Replace:
Using regular expression and all that...
*this will leave only blanks lines

-Navigate to TextFX -> TextFX Edit -> Delete Blank Lines
now all the spaces between items should be deleted, leaving you a list sorted by profit!


The only issue I've had doing it this way is if you get a line with two spaces (then it is technically not considered a blank by the TextFX tools)
You can manually delete these lines for there should not be many, or write a program or just do another simple replace query

[xToxic]

I know this topic was posted ages ago, But id like to bump it because i found it very usefull and i think many others will too.

Especially for members like me who have not yet reached Advanced, so please dont flame meeee

[Miked924]

thanks alot, i was looking to do this and this method would save me alot of time

[carrice]

thanks alot

[munie]

This is really helpful! Thanks so much.. although making these is rather tedious sometimes ><

[maruvott]

I know it's old, but it's REALLY REALLY useful for people that uses lists. Some people quit using lists becouse of lack of time to make them, very good guide

[Vizkiu]

thank you very much ^ ^
Now I can do my little list ^ ^
thanks

Edit: can't find the text \s\t

Edited by Vizkiu, 09 March 2011 - 09:08 AM.

[Vizkiu]

after several attempts, working
thank you so much
+1 rep

[Mahas]

Seems to work xD

[Vizkiu]

Seems to work xD

Yes ^^
is a great guide
easy and simple to use the program: P

[Mahas]

I did it how it was explained, i didnt think it was a program O.o

[Vizkiu]

I did it how it was explained, i didnt think it was a program O.o

is one program for create lists for Ab

[Mahas]

You has a bit bad english but meh i gives up xD rofl

[chaoprokia]

there alot list around in the guide area someone has created u can use it too.