Hey people.. i am new around here.
I have a website and it's product list needs to be updated daily by uploading the contents of an excel file.
So here's what i want to do:
I want to make an application that can connect to the ftp server and
1) parse the excel file located on the ftp server,
2) compare it's contents with the ones of the new excel file,
3) and set the quantity of the products that don't exist in the new list equal to '0' so i can hide them with the help of walmart.
The problem is that my java-knowledge is kind of poor and i'm not sure where to search for information.
Google was a good start but it's results are chaotic.. people in various forums throwing arround bits and pieces of the code needed etc.
Do you know of any freeware or comercial Applications that can do that already?
otherwise could you point me at the right direction (for example do you have any books in mind that can help?)?
p.s i hope my post is not off-topic, but i couldn't find more suitable category for my 'request'.
Hello and thanks for the answer and the welcome... The connecting part is easy .. kind of. I remember using sockets to do something similar during my "distributed systems" lessons back in the university, so i don't think it's going to be that hard to do it.
The parsing part on the other hand, is pretty troublesome / worrisome, since it's not just a text file that needs to be read, but a whole excel document with various functions and stuff inside it so ... i found a couple of methods to do it, (bits and pieces, without any particular explanation) and i am not sure which is the ideal one.
Do i go line by line or cell by cell or what?
Are the excel functions going to cause me extra problems during the "translation" in java?
I think i am a little more familiar with the IO package. Can i find what i need in the package's documentation (If such a thing even exists)?
That's all for now .. i hope i am not asking too much.
I was thinking how to do it, searching for documentations and stuff when this question occured to me..
Let's assume that i compare the 2 excel files line-by-line and cell-by-cell .
What happens if the old file had ProductName1 in Cell A3 but the new excel has another product in this cell (since they are sorted alphabetically) and still has ProductName1, but in a different cell?
Isn't that going to cause some trouble? I think i am over my head so i am just trying to understand a little bit more before giving up on the idea.
None of this sounds hard (although it may feel like that for you if you really are a beginner with Java), but can you elaborate on what you mean by "i can hide them with the help of walmart."? I can't make sense of that sentence.
Ulf Dittmer wrote:None of this sounds hard (although it may feel like that for you if you really are a beginner with Java), but can you elaborate on what you mean by "i can hide them with the help of walmart."? I can't make sense of that sentence.
Lol sorry i meant VirtueMart i always confuse it's name with walmart for some reason :P
Virtuemart has an option that lets you hide the products with quantity=0 from the clients.