Thanks Strongbow!

You've made my life a lot easier.

YOu need to change the Days Limit field at the top of the SWGCParsed Worksheet.

If you left it at the default 7 days then the Insect meat has been excluded from the import because it has been around 12-25 days on Chimaera (according to what folks have posted in the SWG Craft database online)

Hi Strogbow,

I'm trying to get this information for you, however there's something I need to know.... What's a breakpoint??? :p :D

Thanks,

Zad MacLeod
Master Weaponsmith
Gorath

A breakpoint is a pre-defined stopping point in the execution of a program. When the program reaches that line of code, the program freezes and enters a debug mode where you are able to manually step thru the execution process to check for bugs or other logic problems.

To set a break point in VBA, open the code module thru the VB Editor (Tools-->Macros)

Find the line of code in question, and then in the far left margin of the code space, right-click and select Set Breakpoint.

Hi again Strongbow,

I was referring to the nubers within the "Where can I find it" column. (sometimes it's a decimal ex. 4.2, 10.5, etc...) not the Days in Spawn column. Are they the same thing?

Regards,

Zad MacLeod
Master Weaponsmith
Gorath

Hello again Strongbow,

I followed your instructions, however it didn't work. It would seem like it's not getting to the breakpoint. Sorry to be such a bother man... I'm not very good at this stuff so I wouldn't put it past me that I'm doing something wrong. To resume, what happens is:

1. I get an error that says "The tool encountered an error trying to download the status file from SWGCraft.com. Attempt to get the resources anyway?"
2. After clicking OK on the above, I get the prompt to download the new CSV file.... After clicking OK
3. Error: "An error ocurred while reading the data file"

Might be worth mentioning that it seems to "get" the CSV file from SWGCraft.com because I notice that now it's there, where it wasn't before. Also, as I mentioned on the original e-mail, this doesn't happen with version 1.66.91.

Thanks for all the effort and the great support.

Regards,

Zad MacLeod
Master Weaponsmith
Gorath

Yes, they are basically the same. The Days in Spawn column is the minimum number of days the reosurce has been present on any of the planets. In the Where Can I Find it Column, you can see how many days it has been on each planet independently.

Thanks buddy!

Zad MacLeod
Master Weaponsmith
Gorath

I will try to locate a computer at work that I can install Excel 2000 (if I can still pull it down from MSDN) on and try it out. I will test on Excel XP as well. I am nearly convinced that the new download code exceeds the capabilities of Excel 2000. However, I am troubled that the first message you get is in regards to the status file; that section of code was not touched at all in my updates.

Runtime error 9
 

Hello Strongbow!

Let me first say this tool is awesome and I think its great you smart people continue the development of it.

I am experiencing the runtime 9 error when i try to pull up any schematic. I am running excel 2003. I have tried several fresh starts and cannot seem to get it to work. Here is what happens:

1. I load all the professions I want into the tool.
2. I then restore my resources from a backup of 1.66.91
3. Then I try to select a schematic and I get "Run-time error '9':Subscript out of range."
4. The Debug flags the following line of code in the "SchematicFunctions" Module:

If Worksheets("Resources").Cells(k, swgSchematic.SchematicSet(i).Column).Value = 1 Then
l = l + 1
swgSchematic.SchematicSet(i).PResource(l).Class = Worksheets("Resources").Cells(k, 1).Value
swgSchematic.SchematicSet(i).PResource(l).name = Worksheets("Resources").Cells(k, 2).Value

The code in yellow is the line.

Any ideas on what I am doing wrong?

Thanks,

Waka

Could someone please help me get a working copy of the most recent version? I can't seem to d/l anything from here (always gives me "corrupt file") and when I got to the other site I can't find it......

Please? :)

Got the same problem after i've imported the data from the Sloejack 1.66.9 tool - seems the format changed a little for the backup data or something like this. When i used copy - paste special , only inserting the data, I dont get this error. There is also a problem if you have more than around 215 resources in your resource sheet, the new versions only works with the resources up to line 215 in the resource sheet, after line 215 you dont have the drop down list anymore to select the kind of resource and also the formulas/macros dont use any resource after line 215 for the calculations of schematics and the WTH sheet.

Because I have around 340 resources its pretty useless for me and i stick to the "old" sloejack version of the tool, still works fine for the stuff I am building.

Cu
Issk

what is the purpose of:

.TextFilePlatform = 437
&
.TextFileTrailingMinusNumbers = True
in the function ImportSWGCdata() ?

This stuff causes errors and triggers CloseandDump()

i commented those things with "rem" and import appears to be OK. I am running it with Excel2000

I can help you out if someone hasn't already, remind me in game when you're on next please.

i recommended a change back when jenner was supporting the tool, so far nothing happened about it, so here i go again, hehe:

its a small change of the wtht sheet.
resources i marked on my resource tab as not to be used as generic type should also be skipped when compared to a generic resource on the wtht sheet.
small example:
vendusii chyrstal armorphouse gemstones are used for ris armor
amorphous gemstones are used for varius schematics.
so it happens on my server that an vendusii chrystal gems is the best amorphous i have on stock.
now i miss every good spawn of amorphous gemstones since my vendusii gems are in that spot. the tool tells me every current stuff is worse then the best i have on stock.
thats right, but i only have 5k of it on stock and i need a lot more to make all those layers i need the armorphous ones in.
by glancing over the sheet and looking for green and red highlights it appears i missed a lot of resources recently
with having like 100 diffrent resources on the wtht sheet i am not willing to compare them once again manually.

PS: i am still looking after the missing resource issue, didnt find any more so far.
if i run into any, i'll save the swgcraft snapshot and send it over to you.

First, I want to say this is an invaluable tool to the crafting community and "Kudos" for keeping it alive and updated. :cool:

What I'm posting is just a "hypothetical" and is just an idea for discussion.

I have the sheet set up for Doctor Resouces and I was looking at the way it calculates what my "Best" resources are. For a Doctor, all the organic resources look for 66%OQ and 33%PE and in some cases DR. As for inorganics, the ones that matter are OQ, UT, and DR.

When searching for the best resource on the "find resource" page of SWGCraft.com, I search by Experimental Value and input the percentages for several stats. I get back a number higher than 100 for the best resource.

So I guess my question is: Is it a possible to get experimental percentages to add up over 100% when calculating the best resource? For example, one of the resources for a buff pack is avian meat. The values that the avian meat carries that are in-line with what the schematic looks for are 66%OQ, 33%PE, and 60%DR. All those added up would give a "perfect" resource a score of 159. I'm just thinking outside of the box. I, by no means, know or understand the programming genius that is required to put something like this tool together so I...

/salute

everyone that has put programming time into this.

Need a new D/L link.

Forgive my intrusion, and not going back through the posts, but I finally got a working D/l of the 1.7 (i think) tool, and when I try to d/l to update the resources I get error messages saying it couldn't be found, etc....

Could someone point me in to the fix that is needed to correct this? Anyone else having trouble with it?

Works like a champ for me. Did you update the downloads directory in the tool to a valid directory? Also did you put the zlib.dll file in your C:\Windows\system32 directory ? What version of Excel are you using, some people with older versions appear to be having problems.

I"m using excel 2000, and I did move the directory and that got me further, when I get to d/l the file it now says "error reading file"

lol, "almsot" there

Folks,

I've made the decision to Cancel my SWG account, so my subscription will lapse at the end of this month.

This latest publish has pretty much taken the wind out of my sails. This screwy "snappier movement" thing makes me dizzy as all get out. The new Monthly Story is an absolute joke pretending to be content. And the rush by the Devs to attempt to introduce an economy breaking Vendor update last month was only barely thwarted by a massive outcry from the crafter community.

I simply have no interest in the game anymore. I will only log into the game 1 more time this week to load up my vendor (MEC Guild Hall, just SW of Mos Eisley, Intrepid) and place all of my items (components, rare and grind resources, finished weapons, crystals, etc.) up for sale at 1 Credit each.

Whomever would like to pick up the ball with the SWGC Tool is more than welcome. The version on my weblink (1st message in thread) is complete in regards to the updates I have made. I'll look in from time to time and see what is up.

Ouch! The community will miss you Strongbow.. you did a good job updating the tool.

Sorry to see you go
 

Strongbow - sorry to see you go with support of the great tool. Hopefully you'll find another way to enjoy the MMORG. We'll surely miss your help with the tool.

Agida - Corbantis

Thanks for all you've done for this community. You will be missed.

Sponser the lastest of Strongbow's
 

Hello Strongbow,

Thanks for such a great help in keeping this tool up-to-date. I have placed a link below to my web-site where I can keep this tool and a couple others I really find handy.

One is the Merchant Friend - a Client tool - this tool has been abandoned but even in Beta it's awesome. There's one out there that is web based but I'm not crazy about having a link between my pc and a server that I don't know about.

Also, a while ago I found a lot management spreadsheet that I fould usefull too. They are all on the link below. This too has been abandoned by the developer.

Here's the link
http://swg-ucl.com/Foomans_SWGCToolv1_2.html

Tharre - Wookie Creature Handler on Flurry

Sorry to see you go man! Though I must say I'm not surprised. I feel the same way and may follow suit soon. I won't go on a rant here, this is your post and I wouldn't want it to be closed, but I sure can relate!

Farewell friend and have fun!

Zad MacLeod
Master Weaponsmith
Gorath

Great increase to the speed. Wonderful job. Your other two additions have already seen some good use by me.

A Suggestion for future upgrades: There is extra room on the WTH Summary as compared to other sheets in the book. As many people are Resources miners, perhaps your price per unit formulas could be applied and stated on this page next to all currently spawned resources as well as it's current location allowing people to possibly find and mine resources based on that information.

2nd Suggestion: I see that resources in your price per unit formulas are always rated for max stats as a specific resource, not allowing for them to be compared for use as a common resource. Example: Desh Copper Max 372 SR, Mythra Copper Max 706 SR. All Desh Copper is compared against max stats of Desh Copper as Mythra is for Mythra. What I suggest is adding a selector/additonal columns for pricing Desh Copper for use as a Desh Copper/ Copper/ Non-Ferrous Metal/ Metal/ Mineral. Reasoning: While currently it compares what something would be worth as a specific resources, some have a great use as a filler for spots such as "Metal" in a schematic where as something that has great use as a specific resource could have little use as a general resource such as metal, and as such unless it's a specific resource for a greatly used schematic by crafters then it might not be worth near as much. Perhaps adding an additonal weight of it's use as a general resources would work as well.

i would like to point out, i'm unable to download the tool. which would be nice for me to get, because the sorting function on my older version doesn't work, i get a runtime error.

Anyone have a working link?

I have put this link here and I can get to it and download the tool let me know if it works if not I could email it to you.

Tharre

http://swg-ucl.com/Foomans_SWGCToolv1_2.html

Cant D/L it,get the "Page cannot be displayed" message..any help?

Got it! Thanks!

Many thanks Tharre.

Just a head's up folks, I was getting a runtime error 9 everytime I tried to select a schematic like many others.

I figured out how to get around the runtime error, sort your resource list and you should be able to select schematics again without the runtime error.

It works everytime for me, I hope this helps. :cool:

Strongbow, I'm saddened to hear that you are leaving SWG. These tools are absolutely great! Your time and effort are immensely appreciated.

I am having a problem with this last one. When trying to get the resources from my old JnF v 1.60 database into this new one I get a runtime error 6.

If lReturn <> 0 Then
Open Trim(OpenFile.lpstrFile) For Input As #1
Worksheets("Resources").Range("A10:R1031").ClearContents
i = 10
Application.Calculation = xlCalculationManual
Do Until EOF(1)
Line Input #1, strTemp

j = 0
k = 0

Do
j = InStr(j + 1, strTemp, ",")
k = k + 1
Loop Until j = 0

Select Case k

Am I doing something wrong? I just hit restore backup file and choose the only file I find on my hard drive.

Thanks in advance,

Nevermind. I think I found the problem and its in JnF 1.60

When making a backup of my data it just writes it in a screwy format that won't import into the new tool. I'm going to have to do it manually again. :eek:

Drathos, did you ever get this resolved? I am getting the exact same error message and am wondering how to fix it.

BrandonMontana

nope never have gotten it to work....

this thing will rock if I ever get it to work and get my 300+ resources installed <laugh> when/if I have time to do it lol

error with v1.70.02
 

I get the following error when d/l from swg craft:


Private Function UncompressFile(ByVal sSource As String, ByVal sDestination As String)

Dim hFile As Long
Dim sBuffer As String * 2048
Dim sContents As String
Dim lBytesRead As Long

hFile = gzopen(sSource, "rb")

Do While True
lBytesRead = gzread(hFile, sBuffer, Len(sBuffer))
If Not CBool(lBytesRead) Then Exit Do
sContents = sContents & Left$(sBuffer, lBytesRead)
Loop

hFile = FreeFile
Open sDestination For Output As hFile
Print #hFile, sContents
Close (hFile)

End Function



the blue part is what is highlighted in debugger... I'm not a coder, so any ideas on what's wrong??

Thanks

That error will occur if you don't put zlib.dll into the Windows\System32 directory, as described in the tool's Control Panel pane under "FIRST TIME USE INTRUCTIONS" :)

The popup-box you get with the "Debug" button should also indicate that it can't find that file.