|
w3bsite building 101 (pg. 5)
|
View this Thread in Original format
| Lira |
| quote: | Originally posted by Orbax
whuhhh you can make CSVs from XSLTs?!?!?! |
Well, that's how imported all the data of a 20mb big XML file into a MySQL database :D
| quote: | Originally posted by Orbax
dude half my jobs is reports |
Reports? |
|
|
| LeopoldStotch |
| quote: | Originally posted by Orbax
whuhhh you can make CSVs from XSLTs?!?!?!
dude half my jobs is reports |
for sure. that's why microsoft implemented a way for the ability to save word and excel documents in xml files. :) . i love this, especially for people who love to input all their data in an excel file. i can easily traverse an excel file saved as an xml file to fetch some data. |
|
|
| Orbax |
yeah my job is taking stuff thats in a database and displaying it via web (these days) and sometimes through an internal client. but i like being able to utilize web and incoming database info if I can to generate a web page.
it all ends up as a report on some dudes desk and reports are in XLS or CSV. I need the ability to change the data from being in a database to a format that is recognizable as an excel worksheet.
Im still learning all this and know only how to manipulate application specific commands. but if I could make a php script to connect to the DB and pull the info and then XML/XSLT to transform it into a report ... man.
when i looked at the XSL stuff it didnt make sense. |
|
|
| Lira |
| quote: | Originally posted by Orbax
yeah my job is taking stuff thats in a database and displaying it via web (these days) and sometimes through an internal client. but i like being able to utilize web and incoming database info if I can to generate a web page.
it all ends up as a report on some dudes desk and reports are in XLS or CSV. I need the ability to change the data from being in a database to a format that is recognizable as an excel worksheet.
Im still learning all this and know only how to manipulate application specific commands. but if I could make a php script to connect to the DB and pull the info and then XML/XSLT to transform it into a report ... man.
when i looked at the XSL stuff it didnt make sense. |
Wait, Walker, why don't you export the content in the database (I suppose it's MySQL) directly to Excel? Php can do that. |
|
|
| Orbax |
aye. I just like having options though. Sometimes Im dealing more with XML stuff and writing a php script to convert it into something that can convert in CSV sounds like an extra step.
I am just stepping into my career as a web heavy database architect thing person and Id like to know multiple ways to do something in case one isnt working |
|
|
| Orbax |
yeah i just glanced at w3 and need to revisit it for sure. Ill check out that second link too.
right now im in an environment that doesnt allow for messing around and has no web access..
for now I just have to read and absorb without utilizing which means low learning levels :\ |
|
|
| Lira |
| quote: | Originally posted by UWM
To the Nerdmobile! |
 |
|
|
| Lira |
| quote: | Originally posted by Orbax
yeah i just glanced at w3 and need to revisit it for sure. Ill check out that second link too.
right now im in an environment that doesnt allow for messing around and has no web access..
for now I just have to read and absorb without utilizing which means low learning levels :\ |
Do what I did: I actually printed a manual with the relevant content from those websites :toothless |
|
|
| Orbax |
yeah this is a document i made for myself for webservices. images missing. you really gotta apply stuff or its meaninglessq
Web Service Creation
Web Services:
Web Services is an industry standard XML element sheet. It has 3 basic functions:
1. Create
2. Set
3. Get
In the Remedy Admin Tool this nomenclature is somewhat confusing. The Create function works as one would think. It creates a record. The Set function sets, and the Get function Gets.
The confusing part is where and how the Creation, Setting, and Getting take place.
Diagram Explanation:
We have a parent and a child. We want the parent to replicate itself onto the child. This is for SET operation only.
Steps to creating system:
1. Create a Web Service type “Set” on the form you want it to write to.
Note: Set functions can only write to the form which they are attached to.
2. Make the qualification below the Operation (as per this diagram)
'Request ID' = XPATH(/ROOT/Unique)
The reason for this will become clear.
3. The next step is preparing the WSDL for use:
Your browser may not support display of this image.
Here you can see a “made” WSDL. To get to this point you have to save the WSDL and set permissions. Make sure you have permission to the form or the WSDL will not load. The mid-tier sometimes takes a moment to load it up but should produce this look for you within 20 seconds.
Next, place the Handler URL into a web browser such as IE 6 and load the page. Save the page as a .wsdl.
4. Click the Input Mapping button
Your browser may not support display of this image.
Your browser may not support display of this image.
Here you can see that the primary key matching between the forms is “Request ID”
When you click “Generate and Map” it will automatically pair matching fields. Set the Unique value to match to request ID on the receiving form. The reason you cannot use the request ID from the sending form is due to the Primary Key mapping between ROOT and the Forms being off of Request ID.
Note: On “Set” and “Create” Operations, the data will flow from the right side of the map to the left side for the input mapping.
So in this screen, which is depicting the WSDL mapping, the information is going from ROOT (The WSDL) to AIT:Aperture (the child form).
5. Create a Filter. To call the Web Service, no matter what operation the Web Service performs, you must do a set fields action. This can sometimes be confusing.
In words:
The action location is dependant on where the information is flowing.
-If you are getting information from a form, the GET WSDL is attached to the form from which you wish to get the information. This is different from your average Active Link or Filter doing a Set Fields that sits on the requesting form and is pulling from the data containing form. It now is sitting on the Data Containing form and accepting requests.
-If you are pushing information to a form, you place the SET WSDL on the form you wish to SET to. Again, differing in the way it normally works due to a typical Set Fields originating on the data containing form and pushing to the empty container. The WSDL now sits on the empty form and accepts push actions which it passes along.
6. Now that the Filter screen is open, go to the IF Action. Select “Set Fields” from the drop down. Read the value from WEBSERVICE
Your browser may not support display of this image.
7. Now load the .wsdl file that was created from the browser into the “Choose WSDL” box.
8. Click “Load”
9. Choose the operation you wish it perform (in this case Set)
10. Click “Input Mapping”
Your browser may not support display of this image.
11. Now, this is technically the “first” step as far as the phases the server will go through in processing the request. Again, the data flows from Right to Left on a SET action. Map the fields you wish set and pay attention to your “Unique” field. Map it to the ROOT/Unique
Your browser may not support display of this image.
The filter and WSDL should be ready to use now.
Step by Step what the server is doing:
1. Once you trigger the filter the form sends its data to the ROOT/ in the WSDL.
2. The Unique ID/GUID is mapped to the ROOT/Unique on the “In” side of the WSDL.
3. On the “Out” side of the WSDL the ROOT/Unique passes to the receiving forms “Request ID” field.
4. The WSDL, as its qualifier is where the Request ID on the receiving form is matching to the ROOT/Unique, pushes to the form.
GET Requests:
1. The qualification line should not be request ID if the connection will not be using synchronized Request IDs. Again, using a Unique/GUID would be better.
2. On the Web Service side, the input is ignored. You can map it but it will not be checked.
3. The output mapping is simply what information you wish passed along to the requesting form. Realize that this output only goes as far as sending the information to the Web Service.
4. The filter is created with the set from web services action. Select the GET action.
5. Set the Input to be what the qualification on the Web Service is. I.e., if you want Request ID = xpath(root/Unique) map the ROOT/Unique to whatever field on the requesting form that contains the information.
6. The output section on the filter is what the web service will send to the requesting form. The output map on the web service may be all the fields on the form, but only the selected fields on the filter will make it to the form. |
|
|
| LeopoldStotch |
| lol good luck with that. the first step is getting the data into the excel spreadsheets. the next step is taking the data and creating graphs automatically. :( |
|
|
|
|
