Best way to deal with XML - Allround Automations forums

Register Log In

Forums Products PL/SQL Developer Best way to deal with XML

Print Thread

Page 2 of 3

1

2

3

Re: Best way to deal with XML RickS #65350 02/05/24 10:05 AM
Joined: Aug 1999 Posts: 22,206 Marco Kalter Member
Marco Kalter Member Joined: Aug 1999 Posts: 22,206	It should work. Can you let me know how exactly you defined Notepad++ as your default app for XML? Can you also let me know your exact PL/SQL Developer version? Marco Kalter Allround Automations

Re: Best way to deal with XML RickS #65351 02/05/24 01:56 PM
Joined: Oct 2022 Posts: 14 R RickS OP Member
OP RickS Member R Joined: Oct 2022 Posts: 14	The PL/SQL Developer version is 15.0.2.2054. In Windows settings, under Apps > Default Apps, I set the default app for .xml files to Notepad++.

Re: Best way to deal with XML RickS #65352 02/05/24 02:02 PM
Joined: Jan 2006 Posts: 39 J jhughes Member
jhughes Member J Joined: Jan 2006 Posts: 39	Never did ask this last time, but if you have a .xml file saved on disk and double click it, does it open in Notepad++?

Re: Best way to deal with XML RickS #65353 02/05/24 02:03 PM
Joined: Oct 2022 Posts: 14 R RickS OP Member
OP RickS Member R Joined: Oct 2022 Posts: 14	Yes.

Re: Best way to deal with XML RickS #65367 02/06/24 11:20 AM
Joined: Aug 1999 Posts: 22,206 Marco Kalter Member
Marco Kalter Member Joined: Aug 1999 Posts: 22,206	Can you try the following? Save the following text as xml_auto_file.reg: Code Windows Registry Editor Version 5.00 [HKEY_CURRENT_USER\Software\Classes\xml_auto_file] [HKEY_CURRENT_USER\Software\Classes\xml_auto_file\shell] [HKEY_CURRENT_USER\Software\Classes\xml_auto_file\shell\open] [HKEY_CURRENT_USER\Software\Classes\xml_auto_file\shell\open\command] @="\"C:\\Program Files (x86)\\Notepad++\\notepad++.exe\" \"%1\"" [HKEY_CURRENT_USER\Software\Classes\.xml] [HKEY_CURRENT_USER\Software\Classes\.xml\OpenWithProgids] "xml_auto_file"="" If your Notepad++ installation directory differs from C:\Program Files (x86)\Notepad++ you will need to modify this accordingly. Import this registry with regedit.exe and try again. Marco Kalter Allround Automations

Re: Best way to deal with XML Marco Kalter #65369 02/06/24 01:56 PM
Joined: Oct 2022 Posts: 14 R RickS OP Member
OP RickS Member R Joined: Oct 2022 Posts: 14	It does open the XML in Notepad++ now, which is great. Thank you. The problem now is that it isn't saving my edits. It brings up a file in Notepad++ called plstemp.xml. When I change a value in the XML and save the file, it doesn't save the XML to the database. When I query the XML the old values are still there.

Re: Best way to deal with XML RickS #65371 02/07/24 09:41 AM
Joined: Aug 1999 Posts: 22,206 Marco Kalter Member
Marco Kalter Member Joined: Aug 1999 Posts: 22,206	If the result set in edit mode (padlock unlocked) and you open an XML column value in Notepad++, make some changes, and save the file in Notepad++, you should get an "Import data from modified file?" question. After clicking "Yes" you can post the changed record to the database. I tested this scenario and it seems to work fine. If the result set is in read-only mode, changes made in Notepad++ will be ignored. Marco Kalter Allround Automations

Re: Best way to deal with XML RickS #65375 02/07/24 11:06 PM
Joined: Oct 2022 Posts: 14 R RickS OP Member
OP RickS Member R Joined: Oct 2022 Posts: 14	I do have the padlock unlocked, but when I save the file in Notepad++ I don't get an "Import data from modified file?" question.

Re: Best way to deal with XML RickS #65379 02/08/24 10:59 AM
Joined: Aug 1999 Posts: 22,206 Marco Kalter Member
Marco Kalter Member Joined: Aug 1999 Posts: 22,206	Can you go to Preferences > User Interface > Options, press the "DSA Dialogs" button, and check if there is a line like this? ColumnEditorImportModifiedFile=7 If this line exists, remove it and try again. Marco Kalter Allround Automations

Re: Best way to deal with XML RickS #65380 02/08/24 11:04 AM
Joined: Aug 1999 Posts: 22,206 Marco Kalter Member
Marco Kalter Member Joined: Aug 1999 Posts: 22,206	Can you also check that the plstemp.xml file is closed in Notepad++ before you edit the XML column in PL/SQL Developer? Marco Kalter Allround Automations

Page 2 of 3

1

2

3

Moderated by support

Link Copied to Clipboard

Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)

Responsive Width:

PHP: 7.1.33 Page Time: 0.123s Queries: 16 (0.061s) Memory: 2.5589 MB (Peak: 3.0380 MB) Data Comp: Off Server Time: 2024-04-29 17:40:18 UTC
Valid HTML 5 and Valid CSS