Site Changed to SWGCRAFT.ORG Resources won't download

[agida]

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.

[Zimoon]

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

[agida]

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.

[panino76]

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.

[agida]

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.