Page 1 of 1

Site Changed to SWGCRAFT.ORG Resources won't download

Posted: Mon May 04, 2009 2:41 pm
by 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.

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

Posted: Mon May 04, 2009 2:53 pm
by 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

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

Posted: Mon May 04, 2009 3:29 pm
by 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.

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

Posted: Mon May 04, 2009 4:13 pm
by panino76
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.

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

Posted: Tue May 05, 2009 4:01 am
by 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.