Download
(2 MB)
Download
Updated: 01/22/19 09:18 PM
Pictures
File Info
Compatibility:
Wrathstone (4.3)
Updated:01/22/19 09:18 PM
Created:11/14/14 11:59 PM
Monthly downloads:538
Total downloads:155,852
Favorites:109
MD5:
Categories:Auction House & Vendors, Utility Mods
Guild Sales Assistant for Master Merchant  Popular! (More than 5000 hits)
Version: 3.9.1
by: dopiate, hawkeye1889
Guild Sales Assistant 3.9.1



Have you tried Guild Sales Master? It's the perfect companion to GSA!

"Using Master Merchant like you should be? Awesome, how about an offline analysis tool! No login necessary. Great way of keeping track of what you're selling in guild stores and helping you then go and craft more."

Quoted From TESO: Essential Addons version2

"Want to go Nerd in Nirn? – then get Guild Sales Assistant for Master Merchant and build an offline database with a great analytic tool set so you can really track what you are selling in your guild stores."

Quoted From The Merchants Guide
...More reviews just below......More reviews just below......More reviews just below......More reviews just below......More reviews just below......More reviews just below......More reviews just below...







Reviews From Around The Web...

And tonight have just added one called 'Guild Sales Assistant' which is a really REALLY good way of keeping track of what you're selling in guild stores and helping you then go and craft more.*

Master Merchant + Guild Sales Assistant are great add-ons.*

100% agree!*

Recommended Addons!*

If you do not use a banking/store app - i would recommend adding one. I personally use Master Merchant which also integrates with Guild Sales Assistant for offline storage of your merchant data.*

What are the best addons to use?*










You MUST have GSA and MM both enabled if you wish to get any new sales offline.

GSA no longer has an in game GUI.

The default GUI has been changed to Master Merchant

To get the offline component working.

1 - make sure you have the latest GSA and MM installed
2 - run the game so GSA and MM can gather your sales
3 - Play for a minute or two and then you can log out (or just keep playing)
4 - then ONLY after you have logged out the FIRST TIME - follow the steps in this video (yes the number of files in the zip has changed.



Thanks to the hard work of Philgo68 we were able to make it possible to run GSA and Master Merchant together.

------------------


If you have trouble with the video the steps are...
  1. Browse to your AddOns folder (open up GuildSalesAssistant folder)
  2. Run the Guild Sales Assistant program
  3. Follow the directions :-)
I do realize this isn't much information but it really is that easy


Reminder: You must have .Net installed if you plan to use the offline tool. If you aren't sure if you have it you can get the latest here - it will not hurt anything to install it or upgrade to the latest one. I am letting everyone know now so there are no bug reports because you didn't get .Net Framework installed!
3.9.1 - fixed a bug introduced in a previous version and API bump

3.9 - minor fixes, tried future proofing a bit more - this is the LAST version. Unless there is a program ending bug, this is it!



3.8.7 murk - API bump for Murk patch
3.8.7a2 - API bump (just updating it to be courteous) reuploaded to fix folder name mistake
3.8.7a - API bump (just updating it to be courteous)
3.8.7 - API bump (just updating it to be courteous)
3.8.6 - No functional changes / just cosmetic typos and misaligned sections (optional update - not a necessary one)
3.8.5 - corrected a minor bug with furniture and linked my bands full catalog from the options menu (all of it's free)
3.8.4 - API bump
3.8.3 - fixed a text bug that was bothering me

3.8.1a - just an API bump
3.8.1 -- tweaks, minor fixes
3.8 -- in one of my previous updates I removed the left and right navigation bars (they have been put back)
-- this version has a more modern look now (I could use a new logo if anyone has the skills)


3.7.6 - Fixed an issue handing some new items
3.7.5 - Removed LUA Memory feature no longer supported by the new client
3.7.4 - API bump + minor code changes
3.7.2 - API bump
3.7.1a - API bump
3.7.1 - fixed issue with item sorting by date being applied to time-frame summaries
3.7.1 - fixed issue with days being skipped when browsing using the < and > buttons

3.7 -- tightened up some core routines (mainly just optimizing)
3.6 -- just an API bump
3.5 -- I have added a section to the options screen to keep data for:

*Forever
*90 days
*60 days
*30 days

This was added as option so your database doesn't get too big with sales that are no longer relevant.


Old Stuff:

New Look! Large sections of code re-written!
  1. Future Patch Protection
  2. Duplicate Proof
  3. Faster (in all aspects)
  4. Database Maintenance & Health Checks on Start Up

reminder: don't forget about the options menu!





version 2.2.2 (1) - No functional changes just made my manifest file Fast API compatible.
version 2.2.3 - "protection mode" - I'm getting bad data from MM and I am trying to protect your DB so this release will only let you view your history until Phil and I can get things worked out.
version 2.2.4 - updated to work with the new patch - some history will be missing but should be picked up in the next version.
version 2.5.0 - transitioning to new format while supporting the old still. Nothing function has changed, it's all under the hood. Preparing for the future.



old change log info......

11/15/2014 - Initial release Version: v.08 (just the LUA engine for users to start collecting data).
------------- Version will be in sync at release, both programs will be 1.0
11/17/2014 - Cleaned up UI issues I didn't notice plus I added back in the key bind option
------------- I wasn't planning on any updates till 1.0 but I didn't realize the key bind was gone
11/24/2014 - Full version of GSA 1.0 the entire suite is released
------------- Please read the directions, watch the video and enjoy the offline tool
11/26/2014 - Added some items to the offline component that should have been in v 1.0
------------- Changed Average Price (in item selection) to Average Price Per Unit
------------- In the Options added the ability to factor in the 8% Guild Sales Tax to all your totals
------------- Added the ability to "uninstall" GSA so it goes through the 'first run' routine again (if needed)
12/01/2014 - Added in the two most requested features
------------- You can now filter by guild - it will show only results for the guild selected
------------- You can now get sales for a date range and not a single date
12/01/2014 - Bug fix and feature
------------- fixed issue where data range selection can go haywire
------------- added feature to backup your database
12/07/2014 - Utility release
------------- added a stand-alone tool to reset GSA (along with source)
12/11/2014 - Offline component optimized and given a "face lift"
------------- as stated in the forums this is a totally optional update.
12/17/2014 - Two new features added both make the program easier to use
------------- 1) on any "report screen" - daily, calendar chosen, etc - you can now double click the line
------------ item and it will take you directly to the detailed history for that product.
------------- 2) on the options screen you can now choose to ALWAYS have results sorted by
------------- date with newest sales listed first (no more double clicking the column header!
12/17/2014 - sorting code had opposite effect in sales reports - I have fixed it :-)
12/26/2014 - Report exporting to csv added
------------- Will use whatever program csv is associated to in Windows.
------------- Due to reports being hard to see I have reverted back to a simpler look
12/29/2014 - Report exporting to csv had a bug in the title it auto selected if you went from range to single date
------------- fixed the grid lines issue

I have multiple machines and this is how my grid (listview) lines look on different ones! (btw never use listview - GRIDVIEW only for those future .NET programmers).

example 1 (home pc)


example 2 (work pc)


It's nuts - well I figured out a solution - on the options page is a button you can toggle Gray or White

so at work I toggle Gray



and I get this now?!?!



I don't know whats up with .NET and the XP Visuals or No XP visuals or whatever but I'm sorry if you have not grid lines for a long time. I actually didn't know.

ok that is what's fixed in 1.5b - along with the report title issue.

(ps there is no difference betweeen 1.5a and 1.5b only, that it was slow enough for me to run our enterprise code analyzer on my app and make some optimization changes. Plus, fix some of my old VB6 style coding to better, more efficient syntax.)

01/15/2015 --All columns are now sortable, this now includes all monetary columns.
01/31/2015 --Updated backup option for archive data
------------- --Minor bug fixes on export csv names (there was a bug)
02/03/2015 --Fix a very hard to find bug that added new sales twice when you hit "reload data"
-------------- --Added arrows to the single day view so you can use buttons to browse easier
-------------- --very simple < previous day, > next day icons
02/05/2015 --added check for Patch 6 - this version should not be run with Patch 6
------------- --This version will protect you from harming your database
------------- --I have the Patch 6 version ready to go but I can not release until the patch
02/19/2015 -- the online component has been retired
------------- --Master Merchant is the new GUI / Data Collector for GSA
04/17/2015 -- Fixed a long standing issue with not all guilds being listed for sorting
------------- -- Added option to skip the ESO intro videos
Archived Files (61)
File Name
Version
Size
Uploader
Date
3.9
2MB
dopiate
01/05/19 01:04 PM
3.8.7 murk
2MB
dopiate
10/22/18 02:06 PM
3.8.7b
2MB
hawkeye1889
08/16/18 10:47 PM
3.8.7b
2MB
hawkeye1889
08/16/18 10:10 PM
3.8.7a2
2MB
hawkeye1889
06/02/18 09:42 PM
3.8.7a
2MB
hawkeye1889
06/02/18 06:48 PM
3.8.7
2MB
hawkeye1889
02/21/18 04:49 PM
3.8.6
2MB
dopiate
10/31/17 06:41 AM
3.8.5
2MB
dopiate
10/29/17 02:24 PM
3.8.4
2MB
dopiate
10/23/17 08:12 AM
3.8.3
2MB
dopiate
09/20/17 04:50 PM
3.8.1a
2MB
dopiate
08/22/17 06:41 PM
3.8.1
2MB
dopiate
07/25/17 08:24 PM
3.8
2MB
dopiate
07/23/17 06:46 AM
3.7.6
864kB
dopiate
07/11/17 04:59 AM
3.7.5
864kB
dopiate
05/23/17 02:55 AM
3.7.4
865kB
dopiate
05/22/17 05:32 AM
3.7.2
865kB
dopiate
02/06/17 05:34 PM
3.7.1a
865kB
dopiate
10/05/16 05:01 PM
3.7.1
865kB
dopiate
09/08/16 08:24 AM
3.7
865kB
dopiate
08/20/16 12:33 PM
3.6
865kB
dopiate
07/30/16 03:46 PM
3.5
865kB
dopiate
07/13/16 06:44 PM
3.4
864kB
dopiate
06/18/16 03:13 PM
3.3c
859kB
dopiate
05/03/16 08:22 AM
3.3b
859kB
dopiate
05/02/16 01:40 PM
3.3a
859kB
dopiate
03/08/16 12:34 PM
3.3
859kB
dopiate
01/01/16 08:02 AM
3.2.1
858kB
dopiate
12/23/15 12:45 PM
3.2
858kB
dopiate
12/12/15 08:24 AM
3.1
858kB
dopiate
11/29/15 02:36 PM
3.0
857kB
dopiate
11/24/15 07:02 PM
2.5.0
850kB
dopiate
11/07/15 03:17 PM
2.2.4
849kB
dopiate
11/04/15 07:48 AM
2.2.3
851kB
dopiate
11/03/15 05:23 AM
2.2.2a
850kB
dopiate
10/28/15 04:43 PM
2.2.2 (1)
850kB
dopiate
09/22/15 02:57 AM
2.2.2
850kB
dopiate
09/21/15 05:26 PM
2.2.1
848kB
dopiate
09/17/15 10:06 AM
2.2.0
848kB
dopiate
09/16/15 04:53 PM
2.1.2
847kB
dopiate
09/01/15 05:03 AM
2.1.1
930kB
dopiate
04/17/15 08:06 PM
2.1.0
930kB
dopiate
04/17/15 10:45 AM
2.0 for Update
930kB
dopiate
03/03/15 01:23 PM
2.0
930kB
dopiate
02/19/15 05:10 PM
 GSA
1.6a
908kB
dopiate
02/05/15 02:05 PM
 GSA
1.6
908kB
dopiate
02/03/15 08:01 PM
 GSA
1.5d
909kB
dopiate
01/31/15 10:58 AM
 GSA
1.5c
907kB
dopiate
01/15/15 01:57 PM
1.5b
907kB
dopiate
12/29/14 12:29 PM
 GSA
1.5
908kB
dopiate
12/26/14 03:44 PM
 GSA
1.4a
907kB
dopiate
12/17/14 11:18 AM
 GSA
1.4
907kB
dopiate
12/17/14 09:28 AM
 GSA
1.3
906kB
dopiate
12/11/14 08:36 AM
 GSA
1.2a(1)
901kB
dopiate
12/07/14 06:13 AM
 GSA
1.2a
818kB
dopiate
12/02/14 08:53 PM
1.2
818kB
dopiate
12/01/14 06:11 AM
1.1
813kB
dopiate
11/26/14 09:15 PM
1.0
813kB
dopiate
11/24/14 06:18 PM
v.08a
65kB
dopiate
11/17/14 07:55 PM
v.08
65kB
dopiate
11/14/14 11:59 PM


Post A Reply Comment Options
Unread 02/12/19, 05:09 PM  
dopiate
AddOn Author - Click to view AddOns

Forum posts: 142
File comments: 677
Uploads: 11
Originally Posted by RavenMind
Been getting the below error since MM updated yesterday. One of the authors in MM says they think it could be GSA's saved vars, and suggested I look for a function in GSA similar to /mm clean. Any ideas on this one? I'd sure hate to lose my beloved GSA!! Thanks!
Code:
user:/AddOns/GuildSalesAssistant/GuildSalesAssistant.lua:52: operator < is not supported for number < nil
stack traceback:
user:/AddOns/GuildSalesAssistant/GuildSalesAssistant.lua:52: in function 'GuildSalesAssistant:TrimHistory'
I stopped playing and do not have the game installed right now so I do not have good news, I'm sorry to say.

The issue is in the LUA portion of GSA which was originally written by Phil from MM. I was very grateful when he wrote it and maybe he will have a look at the errors?

I'm not great with LUA and I have not kept up with the ZOS changes .. I suspect it would be a 5 minute fix for someone fluent in the current changes.

GSA the program should continue to work just fine if that gets fixed.

Wish I had better news.

For now I guess just disable GSA.

-d
Report comment to moderator  
Reply With Quote
Unread 02/12/19, 04:58 PM  
RavenMind
 
RavenMind's Avatar

Forum posts: 6
File comments: 391
Uploads: 0
Thanks for the info xspertone.
Out of curiosity, besides the LUA error, what happens (or doesn't happen) if you run both addons together?
Report comment to moderator  
Reply With Quote
Unread 02/12/19, 06:20 AM  
xspertone

Forum posts: 0
File comments: 8
Uploads: 0
I removed GSA and saved vars. Reinstalled and this same error occurs. Only recourse for now is to disable this Addon until the author has a chance to review. If I don't disable, MM is entirely broken.

Originally Posted by RavenMind
Been getting the below error since MM updated yesterday. One of the authors in MM says they think it could be GSA's saved vars, and suggested I look for a function in GSA similar to /mm clean. Any ideas on this one? I'd sure hate to lose my beloved GSA!! Thanks!
Code:
user:/AddOns/GuildSalesAssistant/GuildSalesAssistant.lua:52: operator < is not supported for number < nil
stack traceback:
user:/AddOns/GuildSalesAssistant/GuildSalesAssistant.lua:52: in function 'GuildSalesAssistant:TrimHistory'
user:/AddOns/MasterMerchant/MasterMerchant.lua:3743: in function 'postfunc'
user:/AddOns/MasterMerchant/MasterMerchant.lua:1750: in function 'MasterMerchant:iterateOverSalesData'
user:/AddOns/MasterMerchant/MasterMerchant.lua:1723: in function 'Queue'
user:/AddOns/MasterMerchant/Libs/LibExecutionQueue/LibExecutionQueue.lua:33: in function 'LibExecutionQueue:Next'
user:/AddOns/MasterMerchant/Libs/LibExecutionQueue/LibExecutionQueue.lua:34: in function 'func'
EsoUI/Libraries/Globals/globalapi.lua:207: in function '(anonymous)'
Report comment to moderator  
Reply With Quote
Unread 02/12/19, 01:55 AM  
RavenMind
 
RavenMind's Avatar

Forum posts: 6
File comments: 391
Uploads: 0
Been getting the below error since MM updated yesterday. One of the authors in MM says they think it could be GSA's saved vars, and suggested I look for a function in GSA similar to /mm clean. Any ideas on this one? I'd sure hate to lose my beloved GSA!! Thanks!
Code:
user:/AddOns/GuildSalesAssistant/GuildSalesAssistant.lua:52: operator < is not supported for number < nil
stack traceback:
user:/AddOns/GuildSalesAssistant/GuildSalesAssistant.lua:52: in function 'GuildSalesAssistant:TrimHistory'
user:/AddOns/MasterMerchant/MasterMerchant.lua:3743: in function 'postfunc'
user:/AddOns/MasterMerchant/MasterMerchant.lua:1750: in function 'MasterMerchant:iterateOverSalesData'
user:/AddOns/MasterMerchant/MasterMerchant.lua:1723: in function 'Queue'
user:/AddOns/MasterMerchant/Libs/LibExecutionQueue/LibExecutionQueue.lua:33: in function 'LibExecutionQueue:Next'
user:/AddOns/MasterMerchant/Libs/LibExecutionQueue/LibExecutionQueue.lua:34: in function 'func'
EsoUI/Libraries/Globals/globalapi.lua:207: in function '(anonymous)'
Report comment to moderator  
Reply With Quote
Unread 01/24/19, 11:44 AM  
onasc

Forum posts: 0
File comments: 3
Uploads: 0
Re: Re: can not sort sellings

THX for your help.

I checked the data and i found a coruppted one.
I deleted it and all worked fine. I think it was a misstake by me, the user as I graped the data out of TESO.
Now it workes fine.
Thank you for your help.

Originally Posted by dopiate
Originally Posted by onasc
Hi,

I tryed to use thsi addon. It works fine but.....

If I started the tool, it shows me my sellings. fine.
Now I will check a timeperiod like 01..1 up to 23.01 and will see all my sellings the toll sohsw me nothing.
I can select every Item individual, but I am not able to get a complete report of all sellings for teh selected time.
Is there a step necessary to do to get a complete report to export it to Excel ?

THX

My first hunch is too much data that I didn't properly accommodate for, but without more info it's only a guess.

That being said I couldn't reproduce your error.

I did a 1 day export - no issues
I did a 7 day export - no issues (link is the .csv results from export)


Can you try a smaller range, confirm if that works (help rule out other issues) then try a larger one that you had previously fail.

Does it create the file at all? Is the file there but it's empty?

Let me know,
-d
Report comment to moderator  
Reply With Quote
Unread 01/24/19, 07:54 AM  
dopiate
AddOn Author - Click to view AddOns

Forum posts: 142
File comments: 677
Uploads: 11
Re: can not sort sellings

Originally Posted by onasc
Hi,

I tryed to use thsi addon. It works fine but.....

If I started the tool, it shows me my sellings. fine.
Now I will check a timeperiod like 01..1 up to 23.01 and will see all my sellings the toll sohsw me nothing.
I can select every Item individual, but I am not able to get a complete report of all sellings for teh selected time.
Is there a step necessary to do to get a complete report to export it to Excel ?

THX

My first hunch is too much data that I didn't properly accommodate for, but without more info it's only a guess.

That being said I couldn't reproduce your error.

I did a 1 day export - no issues
I did a 7 day export - no issues (link is the .csv results from export)


Can you try a smaller range, confirm if that works (help rule out other issues) then try a larger one that you had previously fail.

Does it create the file at all? Is the file there but it's empty?

Let me know,
-d
Report comment to moderator  
Reply With Quote
Unread 01/24/19, 06:30 AM  
onasc

Forum posts: 0
File comments: 3
Uploads: 0
can not sort sellings

Hi,

I tryed to use thsi addon. It works fine but.....

If I started the tool, it shows me my sellings. fine.
Now I will check a timeperiod like 01..1 up to 23.01 and will see all my sellings the toll sohsw me nothing.
I can select every Item individual, but I am not able to get a complete report of all sellings for teh selected time.
Is there a step necessary to do to get a complete report to export it to Excel ?

THX
Report comment to moderator  
Reply With Quote
Unread 01/23/19, 03:57 PM  
dopiate
AddOn Author - Click to view AddOns

Forum posts: 142
File comments: 677
Uploads: 11
Fixed

Originally Posted by Fistandantiilus
WOW that was quick!!
Updated to version 3.9.1 and GSA is now fully functional
Fantastic Thanks very much
The source was still open, from the previous update. I saw your post last night, so I just fixed it then.

Glad to hear it worked!

Enjoy,
-d
Report comment to moderator  
Reply With Quote
Unread 01/23/19, 10:49 AM  
Fistandantiilus

Forum posts: 0
File comments: 14
Uploads: 0
Originally Posted by dopiate
Originally Posted by Fistandantiilus
Having similar issues myself. On starting GSA presented with this message.
[Image Removed]

Files are here
[Image Removed]
Have done the Registry hack to correct but all that does is make me re-select the savedvariables folder.
Have logged into game multiple times, with items sold but DB file does not increase in size on timestamp change. and GSA states the initial startup message again.

Please help
I was able to reproduce the error and fix it.

It was a missing registry key that I forgot was still needed.

Uploading version 3.9.1 now ... fingers crossed it fixes your issue.

-d
WOW that was quick!!
Updated to version 3.9.1 and GSA is now fully functional
Fantastic Thanks very much
Report comment to moderator  
Reply With Quote
Unread 01/22/19, 09:08 PM  
dopiate
AddOn Author - Click to view AddOns

Forum posts: 142
File comments: 677
Uploads: 11
Originally Posted by Fistandantiilus
Having similar issues myself. On starting GSA presented with this message.


Files are here

Have done the Registry hack to correct but all that does is make me re-select the savedvariables folder.
Have logged into game multiple times, with items sold but DB file does not increase in size on timestamp change. and GSA states the initial startup message again.

Please help
I was able to reproduce the error and fix it.

It was a missing registry key that I forgot was still needed.

Uploading version 3.9.1 now ... fingers crossed it fixes your issue.

-d
Last edited by dopiate : 01/23/19 at 02:46 AM.
Report comment to moderator  
Reply With Quote
Unread 01/22/19, 04:00 PM  
Fistandantiilus

Forum posts: 0
File comments: 14
Uploads: 0
Having similar issues myself. On starting GSA presented with this message.


Files are here

Have done the Registry hack to correct but all that does is make me re-select the savedvariables folder.
Have logged into game multiple times, with items sold but DB file does not increase in size on timestamp change. and GSA states the initial startup message again.

Please help
Report comment to moderator  
Reply With Quote
Unread 01/05/19, 01:57 PM  
dopiate
AddOn Author - Click to view AddOns

Forum posts: 142
File comments: 677
Uploads: 11
re-do - best guess

Originally Posted by CarlBar
I've logged into the game several times since installing this, but when i try to run it, it keep telling me i need to login and let it collect data. Not sure whats wrong...
Have a look at this - it's what you're dealing with and how to fix it.

what happened to pics?

anyway go here - http://oi65.tinypic.com/11cgwef.jpg

and the video link is here: https://www.youtube.com/watch?v=210RTUcUeLE

that info will get you running

-d
Report comment to moderator  
Reply With Quote
Unread 11/29/18, 08:01 PM  
CarlBar

Forum posts: 0
File comments: 9
Uploads: 0
I've logged into the game several times since installing this, but when i try to run it, it keep telling me i need to login and let it collect data. Not sure whats wrong...
Report comment to moderator  
Reply With Quote
Unread 08/17/18, 08:10 PM  
NhojNesnomis
 
NhojNesnomis's Avatar

Forum posts: 0
File comments: 9
Uploads: 0
Re: just an api bump

Agreed! Thanks for keeping this going!


Originally Posted by hawkeye1889
Hi all,

just FYI all updates from now on will just be api bumps unless zos changes something
Report comment to moderator  
Reply With Quote
Unread 08/16/18, 10:49 PM  
hawkeye1889

Forum posts: 22
File comments: 59
Uploads: 0
Re: Re: just an api bump

Originally Posted by RavenMind
Originally Posted by hawkeye1889
Hi all,

just FYI all updates from now on will just be api bumps unless zos changes something
Thanks hawkeye! Love this very essential tool!
You're welcome just reuploaded because I made the same mistake as the last update its fixed now
Report comment to moderator  
Reply With Quote
Post A Reply



Category Jump: