OpenProject in Subfolder

[misterpfister12]

I believe since version 0.5.23 (autofill project formular by complete url) it's not possibile to use the sync workbook if openproject is installed in a subfolder like https://mydomain.com/openproject/
0.5.22 is working well

[misterpfister12]

I just moved openproject into my root folder - but get still the same error message:

[bpetraus]

Hi @misterpfister12 ,

does the problem still occur?

Best

Bernd

[misterpfister12]

Hi @bpetraus

I figured out that the problem also exist when I move openproject to the root folder of my webserver. I think it's a problem with the OpenProjectAPI-Excel and my Office 365 Excel Version. The only solution that helped was the hint from Brearne:

/copy_start

Hello,

Initially I also had difficulties using this feature. I eventually got it working by using the following:

1. Enter the URL, API key and project (name).

2. If a workpackages popup appears (the one containing the ‘Download workpackages’, ‘Upload/update workpackages’ and ‘Show chosen project), close it. It seems that after clicking any of these options, data from new columns cannot be exchanged.

3. A blank spreadsheet should appear. To add columns, click in a header. A second dropdown arrow should appear on the right -hand side. This is the dropdown menu that will allow for the selecting of columns.
   a. To enable a parent/child scenario, a parent column must be selected. It may be convenient to place the ‘Parent’ column where the ‘Subject’ column is. To do this, first, click on the column header. Then, click on the second arrow to the right to enable the dropdown menu. From this menu, select ‘parent’. Do the same with the next column to the right, only select ‘Subject’. Note that a ‘Subject’ column is necessary.

4. Once all of the desire columns are added, press ctrl+b to show the workpackages popup. First click on the ‘Download workpackages’ option to download the data. Then again press ctrl+b to again show the workpackages popup. This time, click ‘Upload/update workpackages’ option. This will synchronise the data in the spreadsheet with the data in the portal. Note that the columns labelled ‘Updatestatus’, ‘Lock Version’ and ‘ID’ should autopopulate.

/copy_end

[bpetraus]

hi @misterpfister12 ,

I dont see, how the quote relates to your question. Anyway, the quote is basicalley right of how to use the tool. Out of curiosity, where did you find it?

Your problem is due to the autofill feature, which assumes root domains, and so would not consider any subfolder. (basically anything between "http[s]://" and the first apperaing "/" would be considered as OpenProject instance. In your case (https://mydomain.com/openproject/), that would be "https://mydomain.com/". Thats why yours "https://mydomain.com/openproject/" is auto-"corrected" in a false way. Sorry, I didnt had your use case in mind, when developing the Excel tool.

I did a quick fix. Can you please test the current version? Ignore the autofill-field and just fill in your data like this:

Best

Bernd

[bpetraus]

By the way, can you please play a little bit around with possibly "wrong" inputs, like:

"https://mydomain.com/openproject"
"https://mydomain.com/openproject//"
"mydomain.com/openproject/"
ect.

[misterpfister12]

Hello Bernd
Thanks for your response. I just tried the new version 0.6.2 - but it isn't working... I immediately receive an "Error parsing JSON" like in the screenshot above. (My openproject-Installation is currently in the root folder of my webserver - will move it later today.)
Did I something wrong?
Regards

[bpetraus]

Hello @misterpfister12

have you activated the debug option? Can you have a look in the created file?

Best

Bernd

[misterpfister12]

Hello Bernd

My Testing Instance URL: https://www.mydomain.com/op

I can enter now the Instance URL also with subfolder and download the work packages. What seems to be wrong (not sure!) is that all "Übergeordnetes Arbeitspaket"-Dependencies are called like "/op35". It looks to me that the subfolder name is now part of the dependency-number what maybe causes the following error if I try to sort the work packages by hierarchy (CTRL+N Menue):

[bpetraus]

Hi @misterpfister12 ,

that one I can not reproduce.... I'll take a look on it at weekend.

Have played a little bit around with possibly "wrong" inputs, like:

"https://mydomain.com/openproject"
"https://mydomain.com/openproject//"
"mydomain.com/openproject/"
ect.

Best

Bernd

[misterpfister12]

Hi Bernd

Out of curiosity, where did you find it?

It's a comment here:
https://www.openproject.org/synchronize-excel-openproject/
Brearne says: July 8, 2020 at 12:33 pm

Have played a little bit around with possibly "wrong" inputs, like:

"https://mydomain.com/openproject"
"https://mydomain.com/openproject//"
"mydomain.com/openproject/"

I haven't had the time to do it because of Project pressure. :-) Will do it later this week. (Need to reconfigure OpenProject first.)

Regards!