Page 1 of 1

Trading Post Feature: Mass Upload Tool?

Posted: 23 Nov 2018, 17:23
by Ulrik
I will echo others in saying the mods you are creating are game changers. They have really added a lot to the game.

I have a feature request for the trading post. It is very tedious to have to add buy orders one at a time for the server post. Would it be possible to set up a tool to allow uploading of a list (in tab delimited or some other format) of items the server trading post is buying with type, price, etc. that could then be run as a database script to upload a whole batch of items at one time? A mass upload tool.

At the moment it can take hours to fully set up a main post for purchasing items to get coin into the economy.

Love the mods - keep them coming!

Re: Trading Post Feature: Mass Upload Tool?

Posted: 23 Nov 2018, 18:18
by Nyuton
It kind of already exists. Open your database in HeidiSQL and open nyu_tradepost_market table. Then select Tools > Import CSV file and uncheck the ID column on bottom right. Then you can just import a CSV file with comma separated values in each line:

TradeType,ObjectTypeID,Quality,Quantity,Durability,Price

Remarks:
TradeType - can be "buy" or "sell"
ObjectTypeID - Object ID from objects_types table
Quantity - 0 means infinite
Price - in copper coins

Excel can save tables in CSV format, so that should work fine. Maybe you have to adjust the control characters in the import dialog.

Re: Trading Post Feature: Mass Upload Tool?

Posted: 25 Nov 2018, 18:09
by Ulrik
So this would add items to the Server Trading Post? and not to guild ones, correct?

Thanks again!

Re: Trading Post Feature: Mass Upload Tool?

Posted: 25 Nov 2018, 19:47
by Nyuton
yeah, _market table is for the server market only.

Re: Trading Post Feature: Mass Upload Tool?

Posted: 02 Apr 2019, 13:30
by sylverlyf
I have tried this. Even using an export CSV file directly from that table and have been unsuccessful in getting it load to that exact file back up :) I wonder if i have something checked or unchecked incorrectly.