Task Import Error

[Nash9991]

Hi,
I get below error when trying to move Tasks and Apps to a new Qlik sense server(May2023)

2023-11-07T15:10:22.348Z debug: GET APP BY ID: Starting get app from QSEoW for app id 01dedb7e-b11e-4987-92ed-e7f79d971ea2
2023-11-07T15:10:22.410Z debug: GET APP BY ID: Result=200
2023-11-07T15:10:22.411Z debug: GET APP BY ID: App details: [object Object]
2023-11-07T15:10:22.415Z verbose: App exists: ID=01dedb7e-b11e-4987-92ed-e7f79d971ea2. App name="DeBeers - 00 - QVF - Checklist Loads QS6"
2023-11-07T15:10:22.415Z debug: Looking up ID for tag named "DeBeers"
2023-11-07T15:10:22.416Z debug: Looking up ID for tag named "Move to new server"
2023-11-07T15:10:22.416Z verbose: (1) PARSE TASKS FROM FILE: 2 schema event(s) for task "00 - DeBeers - Reload Checklists"
2023-11-07T15:10:22.417Z verbose: (1) PARSE TASKS FROM FILE: No composite events for task "00 - DeBeers - Reload Checklists"
2023-11-07T15:10:22.417Z debug: Get task with name 1
2023-11-07T15:10:22.462Z debug: GET TASK BY NAME: Result=200
2023-11-07T15:10:22.463Z debug: GET TASK BY NAME: Task details: []
2023-11-07T15:10:22.466Z error: PARSE TASKS FROM FILE 1: Error: Task "1" does not exist in QSEoW and cannot be updated. Please specify a valid task ID or task name in the source file.
2023-11-07T15:10:22.470Z error: IMPORT TASK: Error: Task "1" does not exist in QSEoW and cannot be updated. Please specify a valid task ID or task name in the source file.
    at C:\snapshot\ctrl-q\build.cjs:283:6839
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)

Below is the code i used for the import:
./ctrl-q task-import
--log-level debug --auth-type cert
--host --auth-cert-file ./cert/client.pem
--auth-cert-key-file ./cert/client_key.pem --auth-user-dir Anglo
--auth-user-id arama --file-type excel
--file-name reload-tasks-test.xlsx --sheet-name "Ctrl-Q task export"
--update-mode create --import-app
--import-app-sheet-name "Ctrl-Q app export"`

[mountaindude]

It's a bit difficult to read that log file given the lack of line breaks, but from what I can see it seems your input Excel with (containing task definitions) does not contain data in the format expected by Ctrl-Q.

Very difficult to tell what's wrong in the Excel file by just looking at the log output, you really need to have the Excel file and log output side by side to understand what needs to be changed. Sorry :/

[mountaindude]

I'll reformat the log output a bit, to make it more readable.

[mountaindude]

... but on a related note - Ctrl-Q should not throw an error like that.
Better error handling should be implemented - noted.

[Nash9991]

Hi,
So i figured out what the issue was.
reload-tasks-test.xlsx

I highlighted the columns in the attached.

So firstly I had to add the column "Import options" and specify the values. Also I had to set values for "Partial reload" and "Manually triggered". So on QMC Partial Reload is set to "No" so i set the value to FALSE.

[Nash9991]

Hi Göran Sander,

Just wanted to ask something as well:
Can the following article be added to Ctrl-q?

https://community.qlik.com/t5/Official-Support-Articles/How-to-transfer-an-app-with-its-bookmarks-from-an-environment-to/ta-p/1710467

[mountaindude]

Sure, quite possible to add an app moving command. Parts of it is already there (app export/import).
Bookmarks handling would have to be added.

No immediate plans for this right now.
If additional up-votes are made that decision may change :)

[mountaindude]

Version 3.14 was just released (download here), it contains (among other things) changes related to this ticket.

[Nash9991]

Hi Göran Sander,
Thanks so much for this. looking forward to testing this out.