[StefanM]

Originally Posted by Jiaz

Excel informs you that JSON value is a List or Record, the type and you have to query which information of that value you're intersted in...

Thanks for the enlightenment!

I checked settings.json and found the correct strings there. So, another 'problem' created by Excel's 'features'.

There are many examples for unwanted 'conversion' etc.

E.g. I want to open a csv file which contains Corona figures for age groups:

0-4
5-9
10-14
15-19
...

What does Excel do?

0-4
05. Sep
Oct 14
15-19
...

Haven't found a way to turn these automatic 'helpers' off.
If you format all columns to Text, Excel won't remember...

Same with the tsv settings file, created by mgpai's script:
Doubleclicking for opening it in Excel results in corruption of some strings.
So, you have to import it, select UTF-8,...

Also haven't found a way to tell Excel that I want to open all files as UTF-8.


Question 1:
You seem to be pretty familiar with Excel, too.
Any ideas, e.g. how to let Excel treat all *.txt, *.csv, *.tsv, ... as UTF-8?

Question 2:
If you format all columns to Text, Excel won't remember...
Do you know how to tell Excel to use text formatting as default? This would solve some problems such as my age group example.

Then I could open csv files from RKI using doubleclick instead of time consuming import of each and every file...

[Jiaz]

Originally Posted by StefanM

Same with the tsv settings file, created by mgpai's script:
Doubleclicking for opening it in Excel results in corruption of some strings.
So, you have to import it, select UTF-8,...

Also haven't found a way to tell Excel that I want to open all files as UTF-8.


Question 1:
You seem to be pretty familiar with Excel, too.
Any ideas, e.g. how to let Excel treat all *.txt, *.csv, *.tsv, ... as UTF-8?

I don't even have/use Excel I just google those answers
Please see:
lukemiller.org/journal/2005/03/changing-default-text-import-origin.html
smallbusiness.chron.com/open-utf8-excel-63726.html

It seems Excel does support BOM, see
superuser.com/questions/911369/excel-change-default-encoding-file-origin-of-text-import-wizard-to-utf-8-650
@mgpai: see stackoverflow.com/questions/4389005/how-to-add-a-utf-8-bom-in-java, just have to add the BOM character at the beginning of the string should do it, for example

'\ufeff' + string

[Jiaz]

Originally Posted by StefanM

Question 2:
If you format all columns to Text, Excel won't remember...
Do you know how to tell Excel to use text formatting as default? This would solve some problems such as my age group example.

I'm sorry but I have not found a way to change/define the default formatter of new sheets.

[StefanM]

Originally Posted by Jiaz

I don't even have/use Excel I just google those answers

I googled already for ages...

But the BOM issue, I haven't found myself.
Will check it out. Thanks a lot!
EDIT:
No, this doesn't help! As you still have to use import. What I want to do is open files in Excel with doubleclick without corrupting anything.



The ultimate solution, however, would be to be able to configure Excel in such a way, that it uses certain start settings.

E.g. I often use 'text to columns'. But it's a pain in the ass, that every time you start Excel, it is reset to it's default settings and it is enabled.

[Jiaz]

Originally Posted by StefanM

I googled already for ages...

But the BOM issue, I haven't found myself.
Will check it out. Thanks a lot!
EDIT:
No, this doesn't help! As you still have to use import. What I want to do is open files in Excel with doubleclick without corrupting anything.

have you tried to change default encoding via registry ?

[StefanM]

Originally Posted by Jiaz

have you tried to change default encoding via registry ?

Yes, long time ago already. And in Win10 there is also an option to enable UTF-8 (still called experimental). Both won't help.

But I set Windows notepad to UTF-8 via Registry, also long time ago. That works.

[Jiaz]

Originally Posted by StefanM

Yes, long time ago already. And in Win10 there is also an option to enable UTF-8 (still called experimental). Both won't help.

I'm not talking about Win10, the links are especially about default encoding for Excel.
What excel version are you using? Just tested on Excel 16 on my college computer and UTF-8 was default encoding.

[StefanM]

Originally Posted by Jiaz

I'm not talking about Win10, the links are especially about default encoding for Excel.
What excel version are you using? Just tested on Excel 16 on my college computer and UTF-8 was default encoding.

I said both, Win 10 settings and Registry patch, did not help.
I run Excel 2019.

So, how did you test it:
Did you open a csv or tsv file with UTF-8 encoding by doubleclicking on it and Excel displayed 'special' characters like this one '↓ At the bottom' correctly?

I'm not talking about importing such a file, as I don't want to do that:
Too many clicks:

1. Clicking on 'Data'
2. Then on 'From Text/csv'
3. Then browse for the file you want to open
4. Then select the file origin from some 100 lines as UTF-8,
5. Then confirm once again the separator,
6. Then load,
7. Then copy everything to a new sheet,

Doubleclicking is just one 'click'

PS Notes:
answers.microsoft.com/en-us/msoffice/forum/all/how-to-set-excel-to-default-to-utf-8-when-opening/c05ac760-b9e8-4cad-b188-6c0b4d3d2926

superuser.com/questions/911369/excel-change-default-encoding-file-origin-of-text-import-wizard-to-utf-8-650
And also this is only about text import as explained in those 7 steps (click marathon) I tried to explain.

[Jiaz]

Originally Posted by StefanM

I'm not talking about importing such a file, as I don't want to do that:
Too many clicks:

1. Clicking on 'Data'
2. Then on 'From Text/csv'
3. Then browse for the file you want to open
4. Then select the file origin from some 100 lines as UTF-8,
5. Then confirm once again the separator,
6. Then load,
7. Then copy everything to a new sheet,

Doubleclicking is just one 'click'

I'm sorry. I was talking about "From Text/CSV" button. But as this is nothing I would do once a day/minute/hour..I would not mind the extra steps/clicks for a proper CSV import

[StefanM]

Originally Posted by Jiaz

I'm sorry. I was talking about "From Text/CSV" button. But as this is nothing I would do once a day/minute/hour..I would not mind the extra steps/clicks for a proper CSV import

I do this several times a day (not regarding JD). Still working as a volunteer on IT issues and topics, preparing quite a view documents and statistics. And - as I said - even figures from institutions like RKI or LZG come in csv format and Excel cannot handle them properly by just doubleclicking on them.

I was looking for a solution in general, not only for JD issues. But never mind, I've been searching for ages and could not find solutions.

But thanks for trying!
I really appreciate this!

[Dockel]

Hello mgpai,

when I click "Toggle sound notification"


the selected items are sent to history ("Move to history") suddenly


Is there any way to correct that?

[Jiaz]

Originally Posted by StefanM

I was looking for a solution in general, not only for JD issues. But never mind, I've been searching for ages and could not find solutions.

Have you tried LibeOffice/other SpreadSheet Tools? Even maybe Online Services/Tools?

[Jiaz]

Originally Posted by Dockel

Hello mgpai,
when I click "Toggle sound notification"
the selected items are sent to history ("Move to history") suddenly
Is there any way to correct that?

Check your scripts in Eventscripter! They must check on action name!

[Dockel]

Sorry, what does that mean, what action name? Where is it? What do I have to do exactly?

[Jiaz]

@Dockel: those are scripts in your Eventscripter. You have to check Settings->Eventscripter and search the script and make sure that it only runs on correct action name.

[Dockel]

Sorry, do not understand what / where the action is.

[Jiaz]

@Dockel: those rightclick context menu items are scripts in your Settings->Eventscripter.
There you must have setup those on Tigger/Event "Downloadlist Contextmenu Button Pressed"
then click on edit and make sure that the script does check for correct name, something like

if (name == "Split Packages") {

[Dockel]

OK, I will try it. Thank you!

[mgpai]

Originally Posted by StefanM

A column which indicates whether or not the default settings for a row have been changed. (e.g. DEFAULT / CUSTOM)

/*
    Export settings
    Trigger : none
*/

var rows = [];
var keys = [];
var file = JD_HOME + "/settings.tsv";
var settings = callAPI("config", "list", ".+", true, true, true, true);

settings.forEach(function(item) {
    var itemKeys = Object.keys(item);
    itemKeys.length > keys.length && (keys = itemKeys);
})

keys = keys.concat(["modified", "comment"]);
rows.push(keys.join("\t"));

settings.forEach(function(item) {
    var obj = {};
    var row = [];

    keys.forEach(function(key) {
        obj[key] = JSON.stringify(item[key]);
    })

    obj.modified = obj.value == obj.defaultValue ? "\"Default\"" : "\"Custom\"";

    for (key in obj) {
        if (key == "value" || key == "defaultValue") {
            row.push(JSON.stringify(obj[key]));
        } else {
            row.push(obj[key]);
        }
    }

    rows.push(row.join("\t"))
})

writeFile(file, rows.join("\n"), false);

Originally Posted by StefanM

... restore the settings from the saved tsv file,

/*
    Import Settings
    Trigger: None
*/
    
var file = JD_HOME + "/settings.tsv";
var text = readFile(file).trim().split("\n");
var keys = text.shift().split("\t");
var settings = [];

text.forEach(function(row) {
    var obj = {};

    row.split("\t").forEach(function(item, index) {
        try {
            obj[keys[index]] = JSON.parse(item);
        } catch (e) {
            obj[keys[index]] = null;
        }
    })

    settings.push(obj);
})

settings.forEach(function(item) {
    item.value != null && callAPI("config", "set", item.interfaceName, item.storage, item.key, item.value);
})

[StefanM]

Originally Posted by mgpai

/*
    Export settings
    Trigger : none
*/
...

Originally Posted by mgpai

/*
    Import Settings
    Trigger: None
*/
...

Hey, you really created a script to import settings!
And you also added the the CUSTOM/DEFAULT column!

Thank you so much for all the hard work!

Both scripts will really be very useful for me (and not only for me, I guess...)!
Will test later and let you know about the result.

You probably already read this!?
One working way to use Excel for the job of viewing/editing settings.tsv without corruption.

If you know a better way, please let me know.

[StefanM]

Originally Posted by StefanM

Hey, you really created a script to import settings!

I'm sorry, but import doesn't seem to work for me.
But maybe I'm doing something wrong.

Summary:
Starting the import did the same, as if I would have installed 7 extension modules, one after the other, without restarting until all 7 were installed.
The I restarted, and all those 7 modules were there.
But none of my settings had been imported.

Details:
This is how I tested:
I used a test installation with many custom settings, filters, ...
From this installation I created a tsv export.

Then I closed my test-JD and renamed cfg folder to force JD to create a new clean cfg folder, which it did after restarting JD.

In this clean installation I installed your import script and then I tried to import settings.csv. I confirmed the security prompt.

What happened you can see in the attached screenshot collection:

More than 10 windows popped up.

The last one (the one on top) asked me, if I really wanted to install shutdown extension module.

Please note that I never installed that module in my life.

I clicked on Yes, anyway.

This provoked another pop up: 'New update available'

I clicked on later

The next popup said: Please restart JDownloader to finish...

I clicked on later

The next popup asked me about installing infobar.

Please note that I never installed that module in my life.

I clicked on Yes, anyway.

Again the update info...

Again I clicked on later

Again 'Please restart...'

Again I clicked on later

Please see the screenshot collection for the next popups.



When I was through, I restarted JD.

Nothing had been imported

But all those modules had been installed.

Any ideas what went wrong, when trying to import settings.tsv?

[Sorphee]

Hello guys,

I need help for a event script :

Action : Restart the download when the status is "Connection Problems"

I have a timer about 5min to wait for a retry and I want a event scrip to avoid this.

Or someone can tell me how reduce the 5min to 30 sec.

Thanks all.
Sorphee

[pspzockerscene]

Merged EventScripter threads.

[Jiaz]

@StefanM: Please know that importing settings from extensions will only work when the extension is installed and enabled. JDownloader doesn't know anything of those settings when the extension is not loaded. As the cfg folder doesn't know about the installed extensions, JDownloader recognizes the installed extensions in libs folder and aks to install/finalize their installation. This *could* be optimized by showing a dialog with checkboxes instead, but that's more a "beauty optimization"

[StefanM]

@Jiaz, @mgpai

Originally Posted by Jiaz

@StefanM: Please know that importing settings from extensions will only work when the extension is installed and enabled. JDownloader doesn't know anything of those settings when the extension is not loaded. As the cfg folder doesn't know about the installed extensions, JDownloader recognizes the installed extensions in libs folder and aks to install/finalize their installation. This *could* be optimized by showing a dialog with checkboxes instead, but that's more a "beauty optimization"

No, you misunderstood me!
Apart from Event Scripter I had not extensions installed.
But when I tried to import the exported settings.tsv file to a clean JD with only default settings, the only thing that happened was:

What you can see in my screenshots collection.

I did not want to install any of those extensions, but starting the import script from mgpai obviously started the download/installation process for one extension after the other.

I was confronted with all those 'Are you sure...' popups. So I said yes to each of those prompts.

But that was all that happened.
Not a single setting had been imported in the end.
Instead only all those extension had been installed.

Did that import script work for you?
Have you tested it?

[Jiaz]

@StefanM; I've tested but NOT with a complete empty cfg folder but just tried to restore some modified settings by importing them from file. Will check by tomorrow

[StefanM]

@Jiaz, @mgpai

Originally Posted by Jiaz

@StefanM; I've tested but NOT with a complete empty cfg folder but just tried to restore some modified settings by importing them from file. Will check by tomorrow

I created that empty cfg folder by removing the cfg folder with many custom settings. (which I had exported to seetings.tsv before)

With cfg folder removed, JD created a new, empty cfg folder. However, if I remember correctly, Event Scripter was still installed!!!

But without any scripts.

So, I installed mgpai's import script and tried to import my settings.tsv with all those custom settings.

The result was, what I told you...

PS: I used settings.tsv with that special CUSTOM/DEFAULT column. Will have to verify if this could have caused the failure of the import script!?!?

[Jiaz]

@SefanM: Please check your tsv for following keyword InstallExtension
I just checked source and this can trigger the extension installation.
and also check update/versioninfo/JD/extensions.installed.json and extensions.requestedinstalls.json

[StefanM]

Originally Posted by Jiaz

@SefanM: Please check your tsv for following keyword InstallExtension
I just checked source and this can trigger the extension installation.
and also check update/versioninfo/JD/extensions.installed.json and extensions.requestedinstalls.json

Here you can see for yourself:
But this should be in any Advanced Settings export file.

	"Install Extension: Folder Watch"	"BOOLEAN"		"false"		"Extension"		"false"	"InstallExtensionFOLDERWATCH"	"Default"	
	"Install Extension: Scheduler"	"BOOLEAN"		"false"		"Extension"		"false"	"InstallExtensionSCHEDULER"	"Default"	
	"Install Extension: JD Shutdown"	"BOOLEAN"		"false"		"Extension"		"false"	"InstallExtensionSHUTDOWN"	"Default"	
	"Install Extension: AntiStandBy"	"BOOLEAN"		"false"		"Extension"		"false"	"InstallExtensionANTISHUTDOWN"	"Default"	
	"Install Extension: Info Bar"	"BOOLEAN"		"false"		"Extension"		"false"	"InstallExtensionINFOBAR"	"Default"	
	"Install Extension: Support Chat"	"BOOLEAN"		"false"		"Extension"		"false"	"InstallExtensionCHAT"	"Default"	
	"Install Extension: Translator"	"BOOLEAN"		"false"		"Extension"		"false"	"InstallExtensionTRANSLATOR"	"Default"	
	"Enable/Disable Extension: Archive Extractor"	"BOOLEAN"		"false"		"Extension"		"true"	"EnableExtractionExtension"	"Custom"	
	"Enable/Disable Extension: Event Scripter"	"BOOLEAN"		"false"		"Extension"		"true"	"EnableEventScripterExtension"	"Custom"

The other two I cannot find in my settings.tsv

[Jiaz]

@StefanM: Thanks for the feedback. This is the cause as the import results in installation of the extensions. I will check by tomorrow. Most likely value conversion issue. Either an issue within JDownloader or something that needs to be fixed with export/import script.

[mxl00]

Hi,

I'm looking for a script to add the download URL to the comments of a video file.

I see a thread with a similar request here:
https://board.jdownloader.org/showthread.php?t=83361
but the script itself is not included.

Any help is appreciated.

Thanks

[Jiaz]

Originally Posted by Jiaz

@StefanM: Thanks for the feedback. This is the cause as the import results in installation of the extensions. I will check by tomorrow. Most likely value conversion issue. Either an issue within JDownloader or something that needs to be fixed with export/import script.

Will be fixed with next core update

[pspzockerscene]

Originally Posted by mxl00

I'm looking for a script to add the download URL to the comments of a video file.

Do you mean the final (direct) download-URL or the browser-viewable "content URL".
E.g. if you were downloading images/videos from twitter:
content URL = twitter post URL
direct URL = direct URL to image inside twitter post

-psp-

[mxl00]

Originally Posted by pspzockerscene

Do you mean the final (direct) download-URL or the browser-viewable "content URL".
E.g. if you were downloading images/videos from twitter:
content URL = twitter post URL
direct URL = direct URL to image inside twitter post

-psp-

Ah, thanks for clarifying. I mean the content URL.

[StefanM]

Originally Posted by Jiaz

Will be fixed with next core update

Thanks for the info.
But, will this core update fix both problems?

Problem 1:
Running the import script results in prompting for installation of all available extensions, which have not been installed already.

Problem 2:
Running the import script does not import any customized settings from settings.tsv. Advanced Settings are the same as they were before running the script...
... apart from those extensions (Problem 1)

[pspzockerscene]

Originally Posted by mxl00

Ah, thanks for clarifying. I mean the content URL.

Okay.
Please keep in mind that I simply wanted to help clarify this.
I do not write EventScripter scripts for users so please wait for mgpai or another user to help with this.

Another question:
Do you want to simply have that URL in the "Comment" field in JD or somewhere in the metadata of the downloaded files?

[Jiaz]

Originally Posted by StefanM

Problem 1:
Running the import script results in prompting for installation of all available extensions, which have not been installed already.

Yes, this will be fixed

Originally Posted by StefanM

Problem 2:
Running the import script does not import any customized settings from settings.tsv. Advanced Settings are the same as they were before running the script...
... apart from those extensions (Problem 1)

I was not able to reproduce any issues, would be good to know which settings in particular failed to restore? an example? In my tests with 2 custom values it worked fine

[StefanM]

Originally Posted by Jiaz

I was not able to reproduce any issues, would be good to know which settings in particular failed to restore? an example? In my tests with 2 custom values it worked fine

I checked more thoroughly, what was imported and what wasn't:

Here are some examples, where I had quite a few custom settings:

• Right Click Menu Download Table, import failed 100 %
• Right Click Menu LinkGrabber Table, import failed 100 %
• MainToolbar (GUI), import failed 100 %
• LinkGrabber Filters, seem to have been imported correctly
• Three scripts from mgpai, seem to have been imported correctly

First I had only checked the first three GUI issues. That's why I had assumed, that nothing had been imported.

[Jiaz]

Originally Posted by StefanM

[*]Right Click Menu Download Table, import failed 100 %[*]Right Click Menu LinkGrabber Table, import failed 100 %[*]MainToolbar (GUI), import failed 100 %

Menus are not part of/available via advanced settings. You can find the json files in cfg/menus_v2 directory.
And at the moment there are no plans to make them available via advanced settings.
In headless mode there are no gui menus. And either you are using the full default menu or a full customized one.

[StefanM]

Originally Posted by Jiaz

Menus are not part of/available via advanced settings.

Wasn't aware of this. That explains it.
Just had in mind that (almost) all settings are (also) available in Advanced Settings.
Any other settings, which are not available there?

Originally Posted by Jiaz

And either you are using the full default menu or a full customized one.

I'm afraid I don't understand what you are referring to:

• What is a full default menu?
• What is a full customized one?

Can you please explain?