JnF's SWGCTool v2.0.2 - Official Thread

Ideas and discussions on third party tools and utilities

Moderator: Forum Moderator

User avatar
panino76
Intermediate Crafter
Posts: 184
Joined: Mon May 19, 2008 1:26 pm
Location: Italy

Re: JnF's SWGCTool v2.0.2 - Official Thread (UPDATED)

Post by panino76 » Thu Jul 09, 2009 11:18 pm

agida wrote:Hi all,

Was thinking of what it takes to add a new schematic to the SWGCtool and thought I'd start researching the best way to do that. This Excel 2007 spreadsheet is the first stage of the spreadsheet that only looks up the schematic and all the fields that are in the Schematic spreadsheet.

See this is just a look-up sheet any ideas or thoughts are welcome. BTW even though you could add a schematic unless Panino or I modify the behind the scenes VBA to handle added schematics. From what I've seen from Panino's modified code it looks like he takes into account changes to the schematic.

The other item that need updates in the other spreadsheets or required and optional components.

Stage II will be to actually add a new schematic to the sheet.
Stage III will be to add the required and optional components to the sheet(s).
Stage IV Check all the existing VBA code and coordinate with Panino if this is something we can add to the SWGCTool.

So for all those interested here's the spreadsheet http://www.swg-piloten.com/Schema_Maintenance_V0.1.zip
I could implement a small function to import data submitted from the community inside the spreadsheet for new schematics, btw implementing it in excel 2007 is of no help (at least for me), actually I'm not going to change the version of the file anytime soon....this would require everyone to upgrade to excel 2007, since compatibility is not bidirectional (you can still adapt an old worksheet to a new version of the application, but you can't open a 2007 worksheeet with excel 2003).

Anyway, the best way to import data inside the worksheet (using an automated function) is using a txt file with formatted text (comma separated), and not another worksheet, since opening a worksheet in the background is a bit more complicated (you have to avoid it remains open, so you have to close it properly, you have to check the sheets inside are what you're expecting, you have to validate the cells excc.....)

Artax Wavingwalker
__________________________________________
The NEW Jenner and Fooman Tool

User avatar
Sobuno
Developer
Posts: 2589
Joined: Sun Mar 25, 2007 2:17 am
Contact:

Re: JnF's SWGCTool v2.0.2 - Official Thread (UPDATED)

Post by Sobuno » Thu Jul 09, 2009 11:37 pm

panino76 wrote:(you can still adapt an old worksheet to a new version of the application, but you can't open a 2007 worksheeet with excel 2003).
Actually, you can open 2007 files in excel 2003, but that would require the users to install convertors/compatibility add-ins as this link says: http://office.microsoft.com/en-us/excel ... Converters

User avatar
panino76
Intermediate Crafter
Posts: 184
Joined: Mon May 19, 2008 1:26 pm
Location: Italy

Re: JnF's SWGCTool v2.0.2 - Official Thread (UPDATED)

Post by panino76 » Thu Jul 09, 2009 11:45 pm

Sobuno wrote:
panino76 wrote:(you can still adapt an old worksheet to a new version of the application, but you can't open a 2007 worksheeet with excel 2003).
Actually, you can open 2007 files in excel 2003, but that would require the users to install convertors/compatibility add-ins as this link says: http://office.microsoft.com/en-us/excel ... Converters
Yeah, you're right Sabuno, forgot to add this part, btw

1) I don't know how it's converted (macro compatibility and so on, I wouldn't be surprised if a bunch of errors would pop up)
2) After you convert, you're goin to save it in 2003 version anyway

Artax Wavingwalker
__________________________________________
The NEW Jenner and Fooman Tool

User avatar
Sobuno
Developer
Posts: 2589
Joined: Sun Mar 25, 2007 2:17 am
Contact:

Re: JnF's SWGCTool v2.0.2 - Official Thread (UPDATED)

Post by Sobuno » Fri Jul 10, 2009 12:05 am

panino76 wrote:
Sobuno wrote:
panino76 wrote:(you can still adapt an old worksheet to a new version of the application, but you can't open a 2007 worksheeet with excel 2003).
Actually, you can open 2007 files in excel 2003, but that would require the users to install convertors/compatibility add-ins as this link says: http://office.microsoft.com/en-us/excel ... Converters
Yeah, you're right Sabuno, forgot to add this part, btw

1) I don't know how it's converted (macro compatibility and so on, I wouldn't be surprised if a bunch of errors would pop up)
2) After you convert, you're goin to save it in 2003 version anyway
Yeah, it was not meant as a criticism or anything, just pointing it out :P

User avatar
panino76
Intermediate Crafter
Posts: 184
Joined: Mon May 19, 2008 1:26 pm
Location: Italy

Re: JnF's SWGCTool v2.0.2 - Official Thread (UPDATED)

Post by panino76 » Fri Jul 10, 2009 12:57 am

Sobuno wrote:
panino76 wrote:
Sobuno wrote:
Actually, you can open 2007 files in excel 2003, but that would require the users to install convertors/compatibility add-ins as this link says: http://office.microsoft.com/en-us/excel ... Converters
Yeah, you're right Sabuno, forgot to add this part, btw

1) I don't know how it's converted (macro compatibility and so on, I wouldn't be surprised if a bunch of errors would pop up)
2) After you convert, you're goin to save it in 2003 version anyway
Yeah, it was not meant as a criticism or anything, just pointing it out :P
Appreciated, as always 8)

Artax Wavingwalker
__________________________________________
The NEW Jenner and Fooman Tool

User avatar
agida
Apprentice Crafter
Posts: 79
Joined: Thu Nov 15, 2007 4:59 am

Re: JnF's SWGCTool v2.0.2 - Official Thread (UPDATED)

Post by agida » Fri Jul 10, 2009 2:04 am

panino76 wrote:
agida wrote:Hi all,

Was thinking of what it takes to add a new schematic to the SWGCtool and thought I'd start researching the best way to do that. This Excel 2007 spreadsheet is the first stage of the spreadsheet that only looks up the schematic and all the fields that are in the Schematic spreadsheet.

See this is just a look-up sheet any ideas or thoughts are welcome. BTW even though you could add a schematic unless Panino or I modify the behind the scenes VBA to handle added schematics. From what I've seen from Panino's modified code it looks like he takes into account changes to the schematic.

The other item that need updates in the other spreadsheets or required and optional components.

Stage II will be to actually add a new schematic to the sheet.
Stage III will be to add the required and optional components to the sheet(s).
Stage IV Check all the existing VBA code and coordinate with Panino if this is something we can add to the SWGCTool.

So for all those interested here's the spreadsheet http://www.swg-piloten.com/Schema_Maintenance_V0.1.zip
I could implement a small function to import data submitted from the community inside the spreadsheet for new schematics, btw implementing it in excel 2007 is of no help (at least for me), actually I'm not going to change the version of the file anytime soon....this would require everyone to upgrade to excel 2007, since compatibility is not bidirectional (you can still adapt an old worksheet to a new version of the application, but you can't open a 2007 worksheeet with excel 2003).

Anyway, the best way to import data inside the worksheet (using an automated function) is using a txt file with formatted text (comma separated), and not another worksheet, since opening a worksheet in the background is a bit more complicated (you have to avoid it remains open, so you have to close it properly, you have to check the sheets inside are what you're expecting, you have to validate the cells excc.....)
The thought was more to add the worksheets to an existing version like 2.0.3 or something. This version is just so I can test it without affecting a current version and then put it into one of the versions 2.0.3 or later. Maybe this might be version 2.1.

The issue I've seen with the add schematic is that it is very hard to see all the data when it is on a long line where a form for adding or updating data is easier to make changes or add a new schematic.

I'll make sure that it is at least Excel 2003 compatible then.
Agida - Rebel Ace - Master Shipwright - Flurry
Shop near Nashal /wp 4636 4459
Image
http://www.swg-piloten.com/html/agida_s ... _shop.html

User avatar
agida
Apprentice Crafter
Posts: 79
Joined: Thu Nov 15, 2007 4:59 am

Re: JnF's SWGCTool v2.0.2 - Official Thread (UPDATED)

Post by agida » Fri Jul 10, 2009 2:13 am

Saved the spreadsheet as 2003 and it seemed to work. Just uploaded to the same link.

Such fun this is.
Agida - Rebel Ace - Master Shipwright - Flurry
Shop near Nashal /wp 4636 4459
Image
http://www.swg-piloten.com/html/agida_s ... _shop.html

User avatar
agida
Apprentice Crafter
Posts: 79
Joined: Thu Nov 15, 2007 4:59 am

Re: JnF's SWGCTool v2.0.2 - Official Thread (UPDATED)

Post by agida » Fri Jul 17, 2009 4:46 pm

Well all here's an "Alpha" version of the schematic update.

What is here:
On the Control sheet are three new buttons:
Add Schematic, Update Schematic and Reset.

1. Add Schematic adds a schematic to the "Data All"(Hidden) spreadsheet at the end.
Needed:
a. A sort by Profession
b. Validate the schematic is not present already more error trapping (Working 7/17/09 12:44pm pst)
c. Update Required and Optional components sheets (hidden)
d. Validate percentage
e. Add drop-down validations where possible.

2. Update Schematic currently only updates the information from the first row of the Schematic Mx sheet. (Working 7/17/09 12:44pm pst)

3. Reset - resets filters and application events

Welcome to suggestions and hints.

If you have any schematics that you would like to add or provide to me for testing it would be much appreciated.


http://www.swg-piloten.com/v2.x.0a%20Jn ... GCTool.zip
Agida - Rebel Ace - Master Shipwright - Flurry
Shop near Nashal /wp 4636 4459
Image
http://www.swg-piloten.com/html/agida_s ... _shop.html

User avatar
agida
Apprentice Crafter
Posts: 79
Joined: Thu Nov 15, 2007 4:59 am

Re: JnF's SWGCTool v2.0.2 - Official Thread (UPDATED)

Post by agida » Fri Jul 17, 2009 10:21 pm

spiglord wrote:Cheers Bro.

I was thinking more along the lines of adding functionality for individual users being able to update the tool with new 'recipes' between major releases of the tool, as well as alerting you to a new 'recipe'.

Anyway, here is my list of currently missing weaponsmith schematics:

A280 Blaster Rifle
C-10 "Dragoneye Reaper"
Corvert Retaliation
Darksting Assassin
Dawnsorrow Rifle
DC-15 Carbine
Deathrain D-50
Disruptor Pistol
DL-T Heavy Blaster Pistol
E11 Carbine MKII
Enhanced E11 Carbine
E-Web Rifle
Exemplar's Mark
Featherweight FWG5 Pistol
Grievance Striker
Ion Relic Pistol
Liquidsilver L7
Master Crafted DC-15 Rifle
Master Crafted EE-3 Carbine
Modified Republic Blaster
Modified X-1 Carbine
Nullifier X
Perfectly-Calibrated Pistol
Quicktrigger Countermand
Red Hydra Z-5
Retribution
Rhiss Mark-20
Rilctur Carbine
SFOR Republic Carbine
The Black Falcon
The Silencer
Trandoshan Hunting Rifle
Trandoshan Suppressor Pistol
Vershyi Sharpshooter

As I only work with ranged weapons, I am sure ther must be a similar list of Melee weapons that also need updating.

Thanks again, and I look forward to the next release.

Keep up the great work.
After reading this post I thought about it and have started making enhancements to the tool. I have an Alpha copy in a thread above and would love to know the contents of any of these schematics so I can use them as test items.

thanks in advance
Agida - Rebel Ace - Master Shipwright - Flurry
Shop near Nashal /wp 4636 4459
Image
http://www.swg-piloten.com/html/agida_s ... _shop.html

User avatar
agida
Apprentice Crafter
Posts: 79
Joined: Thu Nov 15, 2007 4:59 am

Re: JnF's SWGCTool v2.0.2 - Official Thread (UPDATED)

Post by agida » Sat Jul 18, 2009 4:39 pm

Zebri wrote:Not sure what, but something in that file has corrupted it, I am unable to Enter resources or configure the schematics, always get the error which says something along the lines of unable to set WeightBorderClass for the resources.

The attached file is what it exactly says, I think it may have something to do with the deleting of your resources?
Untitled.jpg
Hi Zebri,

Well, I just got that error on my sheet and what I did to fix it was to manually deleted the borders and then ran the update resources.
Agida - Rebel Ace - Master Shipwright - Flurry
Shop near Nashal /wp 4636 4459
Image
http://www.swg-piloten.com/html/agida_s ... _shop.html

User avatar
agida
Apprentice Crafter
Posts: 79
Joined: Thu Nov 15, 2007 4:59 am

Re: JnF's SWGCTool v2.0.2 - Official Thread (UPDATED)

Post by agida » Sat Jul 18, 2009 4:56 pm

Well, development is going - okay. The code is a little cluggy as I have not really done VBA from scratch so I'm learning as I go. Panino's code is really good and has helped me learn a lot as I go along.

So, now up to version 2.x.0c which is a little cleaner - and has validation checks now for the Experimentation %.

Latest update:
1. Add Schematic adds a schematic to the "Data All"(Hidden) spreadsheet at the end.
Needed:
a. A sort by Profession - to keep in line with Panino's logic.
b. Validate the schematic is not present already more error trapping (Working 7/17/09 12:44pm pst)
c. Update Required and Optional components sheets (hidden)
d. Validate percentage (Working 7/18/09 6:00pm pst)
e. Add drop-down validations where possible.

2. Update Schematic currently only updates the information from the first row of the Schematic Mx sheet. (Working 7/17/09 12:44pm pst)
a. Need to update Required and Optional components

3. Reset - resets filters and application events

4. General clean-up and documentation (comments) so if the code is retrofitted it will be easy to understand at least what I was trying to accomplish (LOL)
Welcome to suggestions and hints.

If you have any schematics that you would like to add or provide to me for testing it would be much appreciated.


http://www.swg-piloten.com/v2.x.0c%20Jn ... GCTool.zip
Agida - Rebel Ace - Master Shipwright - Flurry
Shop near Nashal /wp 4636 4459
Image
http://www.swg-piloten.com/html/agida_s ... _shop.html

spiglord
Novice Crafter
Posts: 4
Joined: Mon Jan 26, 2009 7:06 am

Re: JnF's SWGCTool v2.0.2 - Official Thread (UPDATED)

Post by spiglord » Thu Jul 23, 2009 5:00 am

agida wrote: I have an Alpha copy in a thread above and would love to know the contents of any of these schematics so I can use them as test items.
Here are the ones I know: -

C-10 "Dragoneye Reaper"
85 units of Kammris Iron
40 units of Copper
28 units of Polymer
1 Blaster-pistol Barrel
1 Ranged Weapon Core

Deathrain D-50
85 units of Plumbum Iron
40 units of Copper
28 units of Polymer
1 Blaster-pistol Barrel
1 Ranged Weapon Core

Disruptor Pistol
85 units of Ditanium Steel
40 units of Platinite Copper
28 units of Polymer
1 Blaster-pistol Barrel
1 Disruptor Pistol Coil
1 Ranged Weapon Core

Ion Relic Pistol
85 units of Kammris Iron
40 units of Polysteel Copper
28 units of Polymer
1 Blaster-pistol Barrel
1 Ion Relic Pistol Coil
1 Ranged Weapon Core

Liquidsilver L7
85 units of Kammris Iron
40 units of Copper
28 units of Polymer
1 Blaster-pistol Barrel
1 Ranged Weapon Core

Perfectly-Calibrated Pistol
85 units of Colat Iron
40 units of Copper
28 units of Polymer
1 Blaster-pistol Barrel
1 Ranged Weapon Core

Red Hydra Z-5
85 units of Kammris Iron
40 units of Copper
28 units of Polymer
1 Blaster-pistol Barrel
1 Ranged Weapon Core

Rhiss Mark-20
85 units of Duralloy Steel
40 units of Copper
28 units of Polymer
1 Blaster-pistol Barrel
1 Ranged Weapon Core

DC-15 Carbine
100 units of Kammris Iron
45 units of Aluminum
28 units of Polymer
1 Blaster-rifle Barrel
1 Ranged Weapon Core

Exemplar's Mark
100 units of Kammris Iron
45 units of Copper
28 units of Polymer
1 Blaster-rifle Barrel
1 Ranged Weapon Core

SFOR Republic Carbine
100 units of Ditanium Steel
45 units of Aluminum
28 units of Polymer
1 Blaster-rifle Barrel
1 Sfor Carbine Coil
1 Ranged Weapon Core

Covert Retaliation
130 units of Kammris Iron
70 units of Copper
28 units of Polymer
1 Blaster-rifle Barrel
1 Ranged Weapon Core

Darksting Assassin
85 units of Kammris Iron
40 units of Copper
28 units of Polymer
1 Blaster-pistol Barrel
1 Ranged Weapon Core

Dawnsorrow Rifle
130 units of Polonium Iron
70 units of Copper
28 units of Polymer
1 Blaster-rifle Barrel
1 Ranged Weapon Core

Trandoshan Hunter's Rifle
130 units of Link-Steel Aluminum
70 units of Non-Ferrous Metal
28 units of Polymer
1 Projectile Rifle Barrel
1 Trandoshan Hunter's Rifle Barrel
1 Ranged Weapon Core

Vershyi Sharpshooter
130 units of Kammris Iron
70 units of Copper
28 units of Polymer
1 Blaster-rifle Barrel
1 Ranged Weapon Core

Featherweight FWG5 Pistol
85 units of Daitanium Steel
50 units of Axidite Iron
28 units of Link-Steel Aluminium
1 Projectile Pistol Barrel
1 Ranged Weapon Core

Modified Republic Blaster
85 units of Plumbum Iron
40 units of Non-Ferrous Metal
28 units of Polymer
10 units of Diatium Copper
1 Blaster-pistol Barrel
1 Ranged Weapon Core

Quicktrigger Countermand
85 units of Carbonite Steel
40 units of Copper
28 units of Chemical
1 Blaster-pistol Barrel
1 Ranged Weapon Core

Enhanced E11 Carbine
100 units of Plumbum Iron
45 units of Non-Ferrous Metal
28 units of Polymer
1 Blaster-rifle Barrel
1 Ranged Weapon Core

E11 Carbine MKII
100 units of Kammris Iron
45 units of Platinite Copper
28 units of Polymer
1 Blaster-rifle Barrel
1 Ranged Weapon Core

Grievance Striker
100 units of Quadranium Steel
45 units of Copper
28 units of Polymer
1 Blaster-rifle Barrel
1 Ranged Weapon Core

Nullifier X
130 units of Quadranium Steel
70 units of Copper
28 units of Polymer
1 Blaster-rifle Barrel
1 Ranged Weapon Core

** - All above weapons have optional Scopes & Stocks

Schematics left to find:

A280 Blaster Rifle
DL-T Heavy Blaster Pistol
E-Web Rifle
Master Crafted DC-15 Rifle
Master Crafted EE-3 Carbine
Modified X-1 Carbine
Retribution
Rilctur Carbine
The Black Falcon
The Silencer
Trandoshan Suppressor Pistol

+ any other I may have missed

User avatar
agida
Apprentice Crafter
Posts: 79
Joined: Thu Nov 15, 2007 4:59 am

Re: JnF's SWGCTool v2.0.2 - Official Thread (UPDATED)

Post by agida » Thu Jul 23, 2009 6:45 am

Hi Spiglord,

Thanks, I'll try those out tomorrow. Or if you like you can try them too and see if they work or not. I still have some navigation issues and such like if you change the configuration of schematics (add/change/delete) from the profession and then use the change function and on the first change of profession the items may not be there but if you change profession and then go back to that profession the schematics will be built. I'll work on that logic next as it's a fairly easy call.
Agida - Rebel Ace - Master Shipwright - Flurry
Shop near Nashal /wp 4636 4459
Image
http://www.swg-piloten.com/html/agida_s ... _shop.html

User avatar
agida
Apprentice Crafter
Posts: 79
Joined: Thu Nov 15, 2007 4:59 am

Re: JnF's SWGCTool v2.0.2 - Official Thread (UPDATED)

Post by agida » Thu Jul 23, 2009 7:54 am

Hi Spiglord,

the only thing missing is the Experimentation which can be found on the swgcraft.com site. Although I noticed in my spreadsheet the "Data All" tab does not seem to contain the Required or Optional Components. I wonder if somewhere along the line I deleted them by mistake or they were eliminated by mistake, hmmmm.

Here's the data entry sheet in PDF format for review. These are all the fields on the current schematic sheet "Data All"
v2.x.0b JnF's SWGCTool Create Schematic.zip
Schematic page. Review all the fields as needed.
(90.56 KiB) Downloaded 229 times
Agida - Rebel Ace - Master Shipwright - Flurry
Shop near Nashal /wp 4636 4459
Image
http://www.swg-piloten.com/html/agida_s ... _shop.html

Mangorian
Novice Crafter
Posts: 3
Joined: Sun Sep 07, 2008 4:46 am

Re: JnF's SWGCTool v2.0.2 - Official Thread (UPDATED)

Post by Mangorian » Tue Aug 11, 2009 1:58 pm

Hello,
On page 7 of this thread, Celticwolf states he has the issue "cant find project or library". I see on page 8 you tell him to remove the check for the missing ref edit control. Can someone please tell me how to get that window up so I can try the same fix?

I am sorry I dont understand half the stuff written in these pages and I appreciate any help.

Thanks,
Mangorian

Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests