Thanks Rodrigo,
I am sure I could find it. I was just trying to do it the progress way. I am a progress developer in training. I think these tasks are to help me learn writing programs and whatnot. Sometimes I hunt for the answers and find them after I have come up with a not so graceful...
I have some data that was embedded into a html table and stored into a field in the database.
Does anyone have advice on a strategy to do that?
I am doing this to work with Magento, so we are just bringing the data in and outputting it to a csv for Magento import. So it is just a matter of...
Sorry I was unclear. I have resolved this in a way, but I still would like to understand this better. I am having difficulty understanding how to take data from 3 or 4 different xml files and patch them all together in a graceful way. This company that I am getting data from, they have a file...
Good Afternoon,
I am working with SAX, I have 3 different XML files that I need to parse into temp-tables.
I have gotten that to work fine.
I want to get all that data together to do stuff with it. I have had issues trying to get just one program to parse more than one file, so if you have...
They may just want me to do it the other way I had mentioned and code it to do it at a certain time for now. I am not sure. I hope so. It is just pictures and what products a vendor carries and prices, I guess they can't do that much damage with that info. It isn't customer info or anything like...
I believe it is just ftp. I always forget when I am getting the data from the other vendor because we always use SFTP and I forget to change the setting for them and it does not work. I have not gotten the credentials for this vendor yet, just a sample. The address it mentioned was...
Hey Tom, I do think the static way will serve me better especially at my skill level. And YES it is going to be a PITA because I don't think I can change things.
I don't understand how much work an automation can do. I am supposed to make it an automated process to update the prices and...
Hey Tom,
Do you know of any good examples of READ-XML()??? I have been looking for a while now and have not found an awesome example. I have the section in the documentation on it. I tried testing it out with the xml from another example in the doc. I am going to play with it some more, but...
Hey Greg, there are 3 DIFFERENT xml files. I am going to have to parse them each in because the product info has the retail price(MSRP), but not the price it is. I am going to at least use the category file so I can correspond the items to my categories.
Also, I wouldn't think about doing my...
I am not sure what a well formed xml file would look like. I will give you some examples:
Here is a snippet of the categories:
<?xml version="1.0" encoding="ISO-8859-1"?>
-<AcuSport_Consumer_Categories table="xchlib.WCPP100U">
-<row>
<LEVEL1 typename="char" type="1">ACCESSORIES </LEVEL1>...
I was thinking about using it, but the stuff I read said it did not do well with large files. I might just try it and see how it does. I am not sure how big the full file is, but I am sure that there are a lot. The other vendor they use had close to 17,000 products. I don't know how many this...
Hello, it is me again.
I am working on parsing xml into a temp-table and working with it, then output it to a csv file for a magento load.
I have gotten the main one to work, but I am confused as to how to handle several going into one big temp-table.
This company has a category file, a...
Thanks Cecil! He ended up giving that to the seasoned developer. I am sure it was not hard, but I have a bigger project on my plate, so I was glad to avoid that.
I am sure there will be a need for it in the future though. Toolbox stuff!
Thanks Tom. I think the PDF thing may be for later. I got the first part done. I am not great at progress, but I am a clutz when it comes to writing scripts and stuff in linux. I feel out of my element. I am learning though. I am not really sure why that would matter. I know that I am going to...
Hi my name is Tracy and I am new to progress. I was asked to set up progress to make reports on what files are actually being ran during sessions and I need to eventually get them to be saved as a PDF. I am in a unix system and I guess I am putting this in the script file that the user is...
I don't know why I get so confused by this. When parsing a xml file in sax, do you have to have a temp-table field for each incoming piece of data? I am getting the error: Invalid handle. Not initialized or points to a deleted object. (3135) I am pretty sure it has to do with the way I am...
Hey Greg, I am sure how I posted it was kind of confusing. The upload box does not accept xml files. Thank you Stefan, I think my problem was that I forgot to save before I tried again and since the file was getting called by the first one, I would get an error because the changes were not saved.
This bit of code is the second part of the example of SAX-PARSE an XML file to a temp-table. The original code used the connection to the Sports2000 db and defined the temp-table like customer. The objective I am working on I am importing an XML file to a temp-table for some further...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.