xml to xls converter

Post Reply
joernr
Posts: 112
Joined: 24.02.2008, 23:17
Location: Nümbrecht

xml to xls converter

Post by joernr » 29.09.2009, 22:01

I would like to create some reports, for example about the switches, sensors ...My idea was to convert the xml to an excel sheet xls. But I couldn't find a free product. Does anybody know, what I can take, or how to create simple printable reports?

Joern

dadolphs
Posts: 1426
Joined: 22.02.2008, 06:45
Location: Solingen
Contact:

Post by dadolphs » 30.09.2009, 06:08

Hi Jörn,

are the existing reports not sufficient for printing?

If not, what is missing?

You can use the CSV format to import data to Excel and it it should be quite easy to generate it with a stylesheet. Have you ever tried to open the XML (copy) directly with Excel?


Best regards,
Dirk :rr_cap:

joernr
Posts: 112
Joined: 24.02.2008, 23:17
Location: Nümbrecht

Post by joernr » 30.09.2009, 15:42

Hi Dirk,
I know only some html pages, are there other reports in rocrail? I need a report where I can select the columns (f.e. Sensor_name, sensor_id, Adress) because a lot of columns not interesting for me.
Open it with excel is not comfortable. How can I generate an csv file from xml?

Best regards

Jörn

vennekoe
Posts: 16
Joined: 22.02.2008, 15:15
Location: OWL, Germany

Post by vennekoe » 30.09.2009, 15:51

Hi Jörn.

In Excel you can save it as Type .csv

Matthias

joernr
Posts: 112
Joined: 24.02.2008, 23:17
Location: Nümbrecht

Post by joernr » 30.09.2009, 17:43

another disadvantage is that:
The count of fields for a line of rocrail objects is different for the same object type. I need a converter, which sorts the objects by field type and not field number.

eroncelli
Posts: 350
Joined: 11.01.2009, 19:09
Location: Bergamo - Italy

Post by eroncelli » 02.10.2009, 15:37

Hi folks
Excel 2003 (and newer releases) can manage xml files (in and out): after a few "trial and error" it's easy to do the job.
If any difficulty, let me say
Eugenio

dadolphs
Posts: 1426
Joined: 22.02.2008, 06:45
Location: Solingen
Contact:

Post by dadolphs » 03.10.2009, 09:54

Hi Jörn,
joernr wrote: The count of fields for a line of rocrail objects is different for the same object type. I need a converter, which sorts the objects by field type and not field number.
can you explain that a little bit more in detail please?

It should not be a big challenge to use one of the exisiting xsl files (located in the stylesheets directory) to create a csv file with the required information.
The only disadvantage of csv files is that you can not provide a proper formatting, but this can be established for example with a recorded macro.

Best regards,
Dirk :rr_cap:

joernr
Posts: 112
Joined: 24.02.2008, 23:17
Location: Nümbrecht

Post by joernr » 04.10.2009, 19:04

Hi Dirk,

I don't have any experience with xsl. Is it true, that I can generate a html report with xsl stylesheet and my xml file? What I have to do? What is the procedure? If I have a html report, I don't need xls or csv files.

Thank you for your support.
Joern

ron&bram
Posts: 2460
Joined: 11.06.2008, 19:34
Location: Heemskerk, Netherlands

Post by ron&bram » 04.10.2009, 19:40

Hi Joern,

Check this wiki page (hint: doc option)http://wiki.rocrail.net/doku.php?id=rocrail-cmdln-en

Best regards, Ronald

joernr
Posts: 112
Joined: 24.02.2008, 23:17
Location: Nümbrecht

Post by joernr » 07.10.2009, 20:45

Hi Ronald,
rocrail -doc generates a html file with a rocrail object description. I need a documentation with the values of my planfile. (objectname: my value)
regards
Joern

dadolphs
Posts: 1426
Joined: 22.02.2008, 06:45
Location: Solingen
Contact:

Post by dadolphs » 07.10.2009, 21:36

Hi Jörn,

I meant the functionality described in http://wiki.rocrail.net/doku.php?id=gui-reports-de.

I will be quite busy until end of next week but then I should be able to support you in creating some additional (CSV) reports (if still needed).

Best regards,
Dirk :rr_cap:

joernr
Posts: 112
Joined: 24.02.2008, 23:17
Location: Nümbrecht

Post by joernr » 18.10.2009, 20:04

Hi Dirk,

I found the button "create documentation". But the result is my original xml file.
What is my mistake? I will upload my files.

Regards

joern
You do not have the required permissions to view the files attached to this post.

dadolphs
Posts: 1426
Joined: 22.02.2008, 06:45
Location: Solingen
Contact:

Post by dadolphs » 18.10.2009, 21:29

Hi Jörn,

I don't understand what you really did ...

When I open your plan file and use Tables --> Routes --> Documentation,
IE gets launched and shows the report (see attachment).

Do you see any chance to join the round table? There we would be able to prepare a report live ...

Best regards,
Dirk :rr_cap:
You do not have the required permissions to view the files attached to this post.

joernr
Posts: 112
Joined: 24.02.2008, 23:17
Location: Nümbrecht

Post by joernr » 20.10.2009, 19:19

Hi Dirk,

now it's working and the report is very good. This is the
"How to" for xml beginners like me:

1. open rocrail, go to table tab, look for your rocrail-object (feedbacks) and press "Documentation"
2. the generated file f.e. "feedbacks-doc.xml" is under your rocrail-home directory:
f.e. /home/userX/rocrail/feedbacks-doc.xml
3. copy stylesheets directory from /opt/rocrail to your rocrail-home
directory
f.e.
cd /opt/rocrail
cp stylesheets /home/userX/rocrail

4. open your xml file with firefox (konqueror does not work)

If you have problems look for the "href=" entry in your xml file. There is an entry what xsl file the browser will use.


P.S.
Actually I don't know if I have time to visit the roundtable. I hope I can.

Joern

Post Reply

Return to “Documentation”