| T O P I C R E V I E W |
| AKazak |
Posted - 07/11/2022 : 08:59:07 AM
OriginPro 2022b (64-bit) SR1 9.9.5.167
Windows 7 Pro SP1 x64
Greetings!
How do I configure a CSV Connector to stop renaming workbook and worksheet into file name?
I couldn't find the answer in the following references:
https://www.originlab.com/fileExchange/details.aspx?fid=508
https://www.originlab.com/doc/Quick-Help/Change-Data-When-Connector-Used
https://www.originlab.com/doc/Quick-Help/Not-Use-Data-Connector-When-Drag-n-Drop
Thank you.
---
Andrey |
| 6 L A T E S T R E P L I E S (Newest First) |
| AKazak |
Posted - 08/13/2022 : 06:52:21 AM
quote:
Originally posted by snowli
Hi Andrey,
In Origin 2023 beta4 we just announced, we added Other Options button in CSV connector to keep book/sheet name.
There are Sparkline and post script settings there as well.
Also Sparkline and Rename settings can be set as default.
Could you try and give feedback?
Best, Snow
Dear Snow,
It works as expected in OriginPro 2023 (64-bit) Beta 4 10.0.0.83.
Thank you.
---
Andrey |
| snowli |
Posted - 08/12/2022 : 3:29:56 PM
Hi Andrey,
In Origin 2023 beta4 we just announced, we added Other Options button in CSV connector to keep book/sheet name.
There are Sparkline and post script settings there as well.
Also Sparkline and Rename settings can be set as default.
Could you try and give feedback?
Best, Snow
|
| YimingChen |
Posted - 07/19/2022 : 09:34:23 AM
Yes, I can reproduce the issue. I created the report jira ORG-25526.
James |
| AKazak |
Posted - 07/19/2022 : 03:03:04 AM
quote:
Originally posted by YimingChen
You can use Data connecter with Import Filter.
1. Create an import filter file.
-> Import Wizard to import the data file.
-> In the File Name Options page, uncheck the boxes to rename worksheet/workbook.
-> In the Save Filters page, check Save filter box. Give it a filter name and save it to User Files Folder.
2. Start a new workbook, select from menu Data-> Connect to File -> Import Filter. Choose the data file, then choose the import filter and import.
James
Dear James,
I followed the step and created the following OIF to connect a CSV file:
https://my.originlab.com/ftp/forum_and_kbase/Images/IJ%20Histogram%20CSV.oif
However, it still renames workbook into partial file name.
Can you reproduce the issue?
Thank you.
---
Andrey |
| AKazak |
Posted - 07/15/2022 : 02:25:52 AM
quote:
Originally posted by YimingChen
You can use Data connecter with Import Filter.
1. Create an import filter file.
-> Import Wizard to import the data file.
-> In the File Name Options page, uncheck the boxes to rename worksheet/workbook.
-> In the Save Filters page, check Save filter box. Give it a filter name and save it to User Files Folder.
2. Start a new workbook, select from menu Data-> Connect to File -> Import Filter. Choose the data file, then choose the import filter and import.
James
Dear James,
Got it.
Is there a way to change import filter to the currently connected CSV file?
---
Andrey |
| YimingChen |
Posted - 07/11/2022 : 09:44:24 AM
You can use Data connecter with Import Filter.
1. Create an import filter file.
-> Import Wizard to import the data file.
-> In the File Name Options page, uncheck the boxes to rename worksheet/workbook.
-> In the Save Filters page, check Save filter box. Give it a filter name and save it to User Files Folder.
2. Start a new workbook, select from menu Data-> Connect to File -> Import Filter. Choose the data file, then choose the import filter and import.
James |
