The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
 Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 XML reader settings and automation		  New Topic  Reply to Topic
 Printer Friendly
Author  Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

AKazak

Russia
1237 Posts
Posted - 02/01/2026 :  12:31:39 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
OriginPro 2026b (64-bit) Beta2 10.3.5.62
Windows 10 Pro for Workstations 22H2

Greetings!



How do I get just a single column from the target XML file?

How can I automate this behavior and save it as template for many XML files to used with Import from File?

What does B(Y.1) notation mean?
How should I work with this?

Thank you.


---
Andrey

YimingChen

1696 Posts
Posted - 02/04/2026 :  09:30:43 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Andrey,

There is currently no support for partial import in the XML Connector. One workaround is to use a worksheet script to delete unwanted columns after the import. Would this be acceptable?

The number in the column designation notation simply represents the index of the current Y column. This helps users quickly identify which spectrum it corresponds to.

Thank you
Yiming
Go to Top of Page

AKazak

Russia
1237 Posts
Posted - 02/04/2026 :  12:19:01 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
quote:
Originally posted by YimingChen

Hi Andrey,

There is currently no support for partial import in the XML Connector. One workaround is to use a worksheet script to delete unwanted columns after the import. Would this be acceptable?

The number in the column designation notation simply represents the index of the current Y column. This helps users quickly identify which spectrum it corresponds to.

Thank you
Yiming




Dear Yiming,

Yes, delete unwanted columns after the import will work for me.
How do you suggest to implement it: after-import script or somehow else?

In general: how do I import an XML file and remove the connector at all, since my XML is static and then run an LT script to remove unnescessary columns?

As for the B(Y.1) notation: it is clear now.

---
Andrey
Go to Top of Page

minimax

367 Posts
Posted - 02/05/2026 :  05:14:44 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Andrey,

quote:
In general: how do I import an XML file and remove the connector at all, since my XML is static and then run an LT script to remove unnescessary columns?


Would you mind to check if the paragraph "Run Script After Import" on page below helps?

https://www.originlab.com/doc/Origin-Help/Data-Connector#Run_Script_After_Import

After one sheet is ready, select Data menu - Clone Import to pick other files.
--> all others should import as 1 single column too.

PS, would you mind to send us a sample xml and which column do you want to keep?
Go to Top of Page
   Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000