PXWIN via My PX database

[Tetyana Yavdoshchyna]

Hello!

I just tested PXWIN's work. 

Where should the PX database folder be placed? Are there any strict placement requirements?

For example, if our database's path look like:

 D:\PxWin\Resources\Databases\Regio

Is it possible to detail the description of the structure of the database path? What do the components of this description mean?

For example, the following example is given in PXWIN guide:

\\scb\program\\PxWin\Resources\Databases\A_Folkhalsodata

I would be grateful for clarification.

Regards

Tetyana Yavdoshchyna

Lviv, Ukraine

[Petros Likidis]

Hi Tetyana,

Nice to hear from you, I hope you are ok despite the circumstances.

I believe that if the path to the PX database (Menu.xml and PX files)  are D:\PxWin\Resources\Databases\Regio the your databases.config should look like this

<?xml version="1.0" encoding="utf-8" ?>
<databases>
<database id=”mypxdb” type="PX" name="My PX database">
<params>
  <path>D:\PxWin\Resources\Databases\Regio</path>
  </params>
</database>
</databases>

In other words the Path you be the set to the file system path. 

The \\scb\program\PxWin\Resources\Databases\A_Folkhalsodata is maybe not the best example since \\scb\program is a network share at our premises. 

Kind regards

Petros

--
You received this message because you are subscribed to the Google Groups "pcaxis" group.
To unsubscribe from this group and stop receiving emails from it, send an email to pcaxis+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/pcaxis/7b943a83-deab-4860-ad08-8ce50f11685cn%40googlegroups.com.

[y...@ukr.net]

Hi Petros,

Thanks a lot for your reply.

Re - ...I believe that if the path to the PX database (Menu.xml and PX files)  are D:\PxWin\Resources\Databases\Regio the your databases.config should look like this...

I also indicated the same path as you in your answer. My demo database contains few folders with menu.xml (that was created under PxWeb) and px files, but something does not work properly and as a result, it gives an error.

Therefore, I had the idea that the path to my database needs to be clarified.

Of course, I could open our px files through the PXWIN File system. The px files open normally, and I think everything is OK with the menu.xml file.

But at the stage of development our Concept of Municipal Statistics, we wanted to show how easy it is to use PX products, in particular through the tree of our regional PX database in PXWIN.

We would like to demonstrate the same to the students of our Faculty of Statistics while introducing PX products to them.

However, something has not gone as expected so far.

Warm regads,

Tetyana

24 червня 2024, 12:34:42, від "Petros Likidis" <petros....@gmail.com>:

You received this message because you are subscribed to a topic in the Google Groups "pcaxis" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/pcaxis/HrlbMKZQvAU/unsubscribe.
To unsubscribe from this group and all its topics, send an email to pcaxis+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/pcaxis/CANduG-s9iRr9igUxdi0PzGvdVzwiNk8moRNGm6GqyFsxLsY2Wg%40mail.gmail.com.

[Petros Likidis]

Are you able to share the Menu.xnl file. If so maybe I can try verify the cause of the error message.

Kind regards 

Petros 

To view this discussion on the web visit https://groups.google.com/d/msgid/pcaxis/1719318262.0789362000.mqef75gp%40frv34.fwdcdn.com.

[Hans Baumgartner]

Hi,

I just tested  PxWin with a file database and it also needed the menu.xml-file in the database directory to work as a database. So  “D:\PxWin\Resources\Databases\Regio\” should work if you have a menu.xml in the regio directory

OK … The database should be under PxWin  like this D:\PxWin\Resources\Databases\
The database is in this case regio (can be anything for example “my database”) with the sub directories subdirectory1, subdirectory2  (named any way you like …
No px files in the regio (my database) directory … only the menu.xml file.
The px-files in the subdirectories 1, 2 …
The menu xml can be generated with the program PxMenuMaker (my favorite for this) or with with PxWeb.

You can find the PxMenuMaker in the root directory of my full px-family tutorial package:
https://pxweb2.stat.fi/px-family-tutorial.zip
I think the source code is also available in GitHub

My test uses the demo database from the zip-tutorial package.
The MENU.XML in the demo database is NOT GENERATED FOR THE DATABASE, BUT IT WORKS FOR TESTING PURPOSES.
There is no physical px-files corresponding to the menu.xml file, but it shows a great tree in the PxWin program.

<database id="small database22" type="PX" name="small_multilingual_database">
<params>
<path>C:\Users\baumgart\Desktop\PX-Win\Resources\databases\Small_Multilingual_Database\</path>
</params>
</database>



I think you can link any directories and subdirectories under the ..\PX-Win\Resources\databases\ in the filesystem itself.

Is an NTFS junction point?

Junction Points (also commonly referred to as NTFS Junction or Directory Junction) are a type of reparse point which contains link to a directory that acts as an alias of that directory. Junction point work similar to a symbolic link but only for directories.
In LINUX you can do the same … if I remember correctly

I got it working …

I hope this helps you in a small way …

Hans Baumgartner
PxWeb admin

Lähettäjä: pca...@googlegroups.com <pca...@googlegroups.com> Puolesta Tetyana Yavdoshchyna
Lähetetty: perjantai 21. kesäkuuta 2024 11.14
Vastaanottaja: pcaxis <pca...@googlegroups.com>
Aihe: PXWIN via My PX database

--

[Hans Baumgartner]

HI,

As I indicated earlier you will need the backslash in the end of the path:
D:\PxWin\Resources\Databases\Regio\
I wonder really why???

Hans

Lähettäjä: pca...@googlegroups.com <pca...@googlegroups.com> Puolesta y...@ukr.net
Lähetetty: tiistai 25. kesäkuuta 2024 16.26
Vastaanottaja: pca...@googlegroups.com
Aihe: Re[2]: PXWIN via My PX database

To view this discussion on the web visit https://groups.google.com/d/msgid/pcaxis/1719318262.0789362000.mqef75gp%40frv34.fwdcdn.com.

[y...@ukr.net]

Dear Petros and Hans!

Thanks a lot for all your advices and detailed clarifications. I analyzed everything again It looks like the reason was because of xml. I created menu.xml once more. Now everything works.

Warm regards,

Tetyana

26 червня 2024, 09:15:21, від "Hans Baumgartner" <hans.bau...@stat.fi>:

To view this discussion on the web visit https://groups.google.com/d/msgid/pcaxis/AS4PR10MB604019A70EB66C78668DE1BA91D62%40AS4PR10MB6040.EURPRD10.PROD.OUTLOOK.COM.