Site Changed to SWGCRAFT.ORG Resources won't download

Ideas and discussions on third party tools and utilities

Moderator: Forum Moderator

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

Site Changed to SWGCRAFT.ORG Resources won't download

Post by agida » Mon May 04, 2009 2:41 pm

Hi was wondering - the download of resources gets an error. Do we need to change the VBA again to point to the new website resources? Or can we have a parameter that can be modified to handle this.

I assume we go to the Get Resources (hidden) tab and change the download spot. But, I remember that there was some code in the VBA.
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
Zimoon
Forum Moderator
Posts: 4817
Joined: Mon May 14, 2007 6:55 am
Location: Stockholm, SE
Contact:

Re: Site Changed to SWGCRAFT.ORG Resources won't download

Post by Zimoon » Mon May 04, 2009 2:53 pm

You do not say which application your question is about, or whatever.

In SWGAide you go to Options >> SWGCraft and unlock the Base URL and edit the domain accordingly. But the new version, posted yesterday, has the new domain as its default URL.

/Zimoon

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

Re: Site Changed to SWGCRAFT.ORG Resources won't download

Post by agida » Mon May 04, 2009 3:29 pm

Sorry it was JNF 2.0 version.

I found the places that need to be changed. In the VBA it is this for the Status.txt load.

Public Function DownloadTimeStamp()
Dim hFileLocation As String

hFileLocation = Worksheets("GetFromSWGCraft").Cells(4, 6).Value & "\status.txt"
'panino76 - Old location
'DownloadBinaryFromURL "http://www.swgcraft.com/sendfile.php?file=status.txt", hFileLocation
DownloadBinaryFromURL "http://www.swgcraft.org/dev/public/status.txt", hFileLocation
'DownloadBinaryFromURL "http://www.swgcraft.co.uk/dev/public/status.txt", hFileLocation

The following worksheet also need modification.
GetFromSWGCraft

Replace the resource files to these:
http://www.swgcraft.org/dev/sendfile.ph ... azi.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... fin.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... ria.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... tra.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... era.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... tis.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... pse.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... tar.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... rry.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... ath.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... ity.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... pid.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... uri.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... oor.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... wca.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... tus.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... ant.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... lla.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... ire.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... der.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... ner.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... nas.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... ime.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... est.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... ter.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... cyn.csv.gz

I think that's all I changed to get it to work.
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
panino76
Intermediate Crafter
Posts: 184
Joined: Mon May 19, 2008 1:26 pm
Location: Italy

Re: Site Changed to SWGCRAFT.ORG Resources won't download

Post by panino76 » Mon May 04, 2009 4:13 pm

agida wrote:Sorry it was JNF 2.0 version.

I found the places that need to be changed. In the VBA it is this for the Status.txt load.

Public Function DownloadTimeStamp()
Dim hFileLocation As String

hFileLocation = Worksheets("GetFromSWGCraft").Cells(4, 6).Value & "\status.txt"
'panino76 - Old location
'DownloadBinaryFromURL "http://www.swgcraft.com/sendfile.php?file=status.txt", hFileLocation
DownloadBinaryFromURL "http://www.swgcraft.org/dev/public/status.txt", hFileLocation
'DownloadBinaryFromURL "http://www.swgcraft.co.uk/dev/public/status.txt", hFileLocation

The following worksheet also need modification.
GetFromSWGCraft

Replace the resource files to these:
http://www.swgcraft.org/dev/sendfile.ph ... azi.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... fin.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... ria.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... tra.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... era.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... tis.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... pse.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... tar.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... rry.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... ath.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... ity.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... pid.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... uri.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... oor.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... wca.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... tus.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... ant.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... lla.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... ire.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... der.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... ner.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... nas.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... ime.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... est.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... ter.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... cyn.csv.gz

I think that's all I changed to get it to work.
As I said in the original thread, I'll upload late tonight the new version with the data modified and some minor bugs fixed.

Artax Wavingwalker
__________________________________________
The NEW Jenner and Fooman Tool

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

Re: Site Changed to SWGCRAFT.ORG Resources won't download

Post by agida » Tue May 05, 2009 4:01 am

Actually I think I'm using version 2.0 with mods for the crafting sheet that meet my needs. It's not as elegant as I'd like but it works for me. Thanks for keeping this tool updated.
Agida - Rebel Ace - Master Shipwright - Flurry
Shop near Nashal /wp 4636 4459
Image
http://www.swg-piloten.com/html/agida_s ... _shop.html

Post Reply

Who is online

Users browsing this forum: No registered users and 5 guests