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.
Site Changed to SWGCRAFT.ORG Resources won't download
Moderator: Forum Moderator
Site Changed to SWGCRAFT.ORG Resources won't download
Agida - Rebel Ace - Master Shipwright - Flurry
Shop near Nashal /wp 4636 4459

http://www.swg-piloten.com/html/agida_s ... _shop.html
Shop near Nashal /wp 4636 4459

http://www.swg-piloten.com/html/agida_s ... _shop.html
-
- 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
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
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
Facebook:
Official Save Star Wars Galaxies
Official Save Star Wars Galaxies
Re: Site Changed to SWGCRAFT.ORG Resources won't download
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.
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

http://www.swg-piloten.com/html/agida_s ... _shop.html
Shop near Nashal /wp 4636 4459

http://www.swg-piloten.com/html/agida_s ... _shop.html
Re: Site Changed to SWGCRAFT.ORG Resources won't download
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 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.
Re: Site Changed to SWGCRAFT.ORG Resources won't download
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

http://www.swg-piloten.com/html/agida_s ... _shop.html
Shop near Nashal /wp 4636 4459

http://www.swg-piloten.com/html/agida_s ... _shop.html
Who is online
Users browsing this forum: No registered users and 1 guest