Merchant Archive

Thread: Merchant Email to XML Program Now Available

PepeGSay
Sat Nov 29, 2003 1:30 am
#14

Hey,


The program is definitely in the Alpha state. Right now, by biggest concern is exactly what you are talking about where the program thinks an email is vendor email when in fact it is not. I haven't had a chance to test all types of emails. The format is not a standard format so I am having to make very specific parsers. If it thinks it is a vendor email when it isn't it is very likely it will blow up. Could you send me a copy of the mail that was blowing up at [email protected] then I can add that email type to the exclusions?


To get the date translation you take the Unix epoch (1/1/19700 and the add the time number to it in seconds. In .net it's something like Convert.ToDate("1/1/1970").AddSeconds(NumberOfSecondsSinceEpoch)


Thanks,
Tiquor




Tiquor Canche - Intrepid
Stim City: Naboo, Moenia 5326 -4084 Meds & A Ton of Other Merchants
Proud Member of SIN (Strength In Numbers)

+20 Medical, Combat Medical & Chef Experimentation
"When your HAM is looking shi&&y, you'll be glad you shopped at Stim City"
Merchant Email Processor available at http://www.thedotcommakesitfunny.com/swg/ Now on Alpha 11.

banditxx99
Sat Nov 29, 2003 2:53 pm
#15

PepeGSay,


Nice to see another .net programmer. C#? If you need a hand, let me know. For an example of work I've done see www.project-xbot.com.


Great idea too.

PepeGSay
Sat Nov 29, 2003 7:07 pm
#16

Yep, C# - been doing ASP for years, nice to get a more mature programming language to do web apps in, and the occassional desktop app too.



Tiquor Canche - Intrepid
Stim City: Naboo, Moenia 5326 -4084 Meds & A Ton of Other Merchants
Proud Member of SIN (Strength In Numbers)

+20 Medical, Combat Medical & Chef Experimentation
"When your HAM is looking shi&&y, you'll be glad you shopped at Stim City"
Merchant Email Processor available at http://www.thedotcommakesitfunny.com/swg/ Now on Alpha 11.

Snosrap
Sat Nov 29, 2003 10:57 pm
#17

This is great... nicely done! Not only is it great to see some .NET developers here, it's great to see some people trying to apply reporting and analytics solutions to their in-game businesses.




ï Re'ji ð
Jedi | Colonel - Rebel Alliance

StarWorker
Sun Nov 30, 2003 4:22 am
#18

Did some post-processing of the xml file....


Here is an easy way of getting the xml data into a spreadsheet Make an xsl sheet that transforms the xml data into csv


Put in a reference to the xsl sheet into the xml sheet


View the xml page in your browser, select all the text, save the text in a text file


Open the text file in a spreadsheet (import from CSV)







Chilastra: K'yp Darron
Core Resources power vendor: Tusk'ens Bane (-4530, -5915)

TC-Prime: Leno, Bamih and Locin We-Eda
PepeGSay
Sun Nov 30, 2003 6:29 am
#19

hey, if you send me the XSL you used I'll add it to the app. [email protected]


-Tiquor




Tiquor Canche - Intrepid
Stim City: Naboo, Moenia 5326 -4084 Meds & A Ton of Other Merchants
Proud Member of SIN (Strength In Numbers)

+20 Medical, Combat Medical & Chef Experimentation
"When your HAM is looking shi&&y, you'll be glad you shopped at Stim City"
Merchant Email Processor available at http://www.thedotcommakesitfunny.com/swg/ Now on Alpha 11.

ResourceMan
Sun Nov 30, 2003 8:14 pm
#20

After I unzip the files from the download, I get the following error when I try to run the SWGEmailMerchantProcessing file:

The application failed to initianize properly (0xc0000135). Click on OK to terminate the application.


Any idea what the prob could be? It is working for other people, so I must be doing somethign wrong.




C O R E .. R E S O U R C E S
E N E R G Y .. M I N E R A L S .. C H E M I C A L S .. G A S .. W A T E R .. O R G A N I C S
C H I L A S T R A ......... T A L U S ......... A V I A N .. C I T Y ......... W P : - 6 0 5 0 ...35 0
StarWorker
Sun Nov 30, 2003 10:38 pm
#21

Did you install the .NET component from Microsoft Update?



Chilastra: K'yp Darron
Core Resources power vendor: Tusk'ens Bane (-4530, -5915)

TC-Prime: Leno, Bamih and Locin We-Eda
banditxx99
Mon Dec 01, 2003 12:21 pm
#22

The two most common error messages that show up when the .NET Framework is not installed are:


"Required .DLL file, MSCOREE.DLL, was not found." or "The application failed to initialize properly (0xc0000135). Click on OK to terminate the application."


So, it would appear that the problem is as you said StarWorker.

PepeGSay
Tue Dec 02, 2003 12:03 pm
#23

/bump



Tiquor Canche - Intrepid
Stim City: Naboo, Moenia 5326 -4084 Meds & A Ton of Other Merchants
Proud Member of SIN (Strength In Numbers)

+20 Medical, Combat Medical & Chef Experimentation
"When your HAM is looking shi&&y, you'll be glad you shopped at Stim City"
Merchant Email Processor available at http://www.thedotcommakesitfunny.com/swg/ Now on Alpha 11.

Draznar
Tue Dec 02, 2003 12:28 pm
#24

Want me to add this to my next release of the guide???



~ ECLIPSE Power k DRAZNAR'S Resources ~
______________________________________________________________________________
Powering the Eclipse Galaxy at 1.5 credits per unit of harvester power from 6 Locations!
u Isle of Misfits, Dantooine 3529, 5761 u Xanadu Bay, Naboo -70, 5222 u Coronet, Corellia 172, -5444 u
u Bestine, Tatooine -970, -4350 u In Caliga, Rori -2710, -2460 u TBA, Lok xxxx, xxxx u
Resources available from Eclipse Resource Corporation at the Isle of Misfits & Cornet Branches

PepeGSay
Tue Dec 02, 2003 4:30 pm
#25

That would be great Draznar.




Tiquor Canche - Intrepid
Stim City: Naboo, Moenia 5326 -4084 Meds & A Ton of Other Merchants
Proud Member of SIN (Strength In Numbers)

+20 Medical, Combat Medical & Chef Experimentation
"When your HAM is looking shi&&y, you'll be glad you shopped at Stim City"
Merchant Email Processor available at http://www.thedotcommakesitfunny.com/swg/ Now on Alpha 11.

PepeGSay
Tue Dec 02, 2003 5:24 pm
#26

Hey Draznar, why am I on your ignore list? I sent you a PM and it said I was on your ignore list... did I do something to piss you off? Or is the forum just fuabar'd?? Just wondering.



Tiquor Canche - Intrepid
Stim City: Naboo, Moenia 5326 -4084 Meds & A Ton of Other Merchants
Proud Member of SIN (Strength In Numbers)

+20 Medical, Combat Medical & Chef Experimentation
"When your HAM is looking shi&&y, you'll be glad you shopped at Stim City"
Merchant Email Processor available at http://www.thedotcommakesitfunny.com/swg/ Now on Alpha 11.

Page 2 of 3