conveniencable / microsoft_project_connector

10 stars 3 forks source link

Decimal number format #25

Open otirado-isotrol opened 1 year ago

otirado-isotrol commented 1 year ago

Hi, we are having problems since the company is international and both people from Spain and the USA are using the plugin and as I have read, the format of the decimal numbers in MS Project depends on the configuration in Windows, so when synchronizing the field "Estimated Time", for users in one country it works perfectly, but for users in the other it does not parse well the decimal number that comes from redmine and adds 00 to it, touching the code of the redmine plugin if I change the parsing it sends. The MS Project is fixed for some users, but not for those in the other country. According to what I have learned, it is not possible to configure in MS Project which value determines the decimals, do you know if there is any way to correct this?

It was proposed to standardize the formats, but it affects the rest of the applications.

Thank you very much, greetings.

conveniencable commented 1 year ago

Maybe this can help: https://support.microsoft.com/en-us/office/change-the-date-format-in-project-desktop-3c92bc51-6fd4-4c2c-aae7-0dde6cae4358

And in redmin, the users can change her/his language which changes the date format accordingly.


发件人: otirado-isotrol @.> 发送时间: 2023年9月29日 15:48 收件人: conveniencable/microsoft_project_connector @.> 抄送: Subscribed @.***> 主题: [conveniencable/microsoft_project_connector] Decimal number format (Issue #25)

Hi, we are having problems since the company is international and both people from Spain and the USA are using the plugin and as I have read, the format of the decimal numbers in MS Project depends on the configuration in Windows, so when synchronizing the field "Estimated Time", for users in one country it works perfectly, but for users in the other it does not parse well the decimal number that comes from redmine and adds 00 to it, touching the code of the redmine plugin if I change the parsing it sends. The MS Project is fixed for some users, but not for those in the other country. According to what I have learned, it is not possible to configure in MS Project which value determines the decimals, do you know if there is any way to correct this?

It was proposed to standardize the formats, but it affects the rest of the applications.

Thank you very much, greetings.

― Reply to this email directly, view it on GitHubhttps://github.com/conveniencable/microsoft_project_connector/issues/25, or unsubscribehttps://github.com/notifications/unsubscribe-auth/ARMVRYBFH4T3GP44Q5MZWG3X4Z4NLANCNFSM6AAAAAA5MCJFWY. You are receiving this because you are subscribed to this thread.Message ID: @.***>

otirado-isotrol commented 1 year ago

Sorry, I don't think I explained myself well, I'm not telling you the format of the dates but rather the decimal numbers, in the USA region the decimal number is indicated with "," and in Europe with "."

For example, in the USA "12.5" and in Europe "12.5"

conveniencable commented 1 year ago

Please try the latest MS project plugin version V1.0.22.

otirado-isotrol commented 1 year ago

Sorry for the delay in answering. I have installed the Redmine plugin in a test environment to the most recent version and the MS project plugin to version 1.0.22 and it does not work. When I get the estimated time it doesn't parse it well and from 100 it goes to 10,000 for example in any type of format in Windows.

And one more question, what other changes have happened from 1.0.18 to the most recent one? To prove it.

Thank you so much.

conveniencable commented 11 months ago

Sorry for the delay in answering. I have installed the Redmine plugin in a test environment to the most recent version and the MS project plugin to version 1.0.22 and it does not work. When I get the estimated time it doesn't parse it well and from 100 it goes to 10,000 for example in any type of format in Windows.

And one more question, what other changes have happened from 1.0.18 to the most recent one? To prove it.

Thank you so much.

Sorry for busy these days. The changes are: https://github.com/conveniencable/RedmineConnectorRelease/releases

I didn't change anything about estimated time, be careful it's days in Redmine but minutes in MS Project.

pesseba commented 3 months ago

Sorry for busy these days. The changes are: https://github.com/conveniencable/RedmineConnectorRelease/releases

I didn't change anything about estimated time, be careful it's days in Redmine but minutes in MS Project.

The version 1.0.22 still have this problem @conveniencable. The duration adds 00 when loads from Redmine. I did a comment here about this: https://github.com/conveniencable/microsoft_project_connector/issues/28#issuecomment-2312255429

I'm considering to buy the plugin license, but with this problem I can't

otirado-isotrol commented 1 month ago

Hi, after testing version 1.0.23 it seems to work, but doing other tests gives me an error. For example, when trying to load some templates that we have defined, it says 'Theme cannot be blank', when it shows that the Name column is filled. imagen

I have looked at the redmine application log and it seems that no value from any field is reaching the controller.

Regards.

otirado-isotrol commented 1 month ago

I forgot to mention that if I do 'Load' and any changes it does work and sends the data. I've only seen that it fails when I click 'Save' to load the template.

conveniencable commented 1 month ago

Hi, after testing version 1.0.23 it seems to work, but doing other tests gives me an error. For example, when trying to load some templates that we have defined, it says 'Theme cannot be blank', when it shows that the Name column is filled. imagen

I have looked at the redmine application log and it seems that no value from any field is reaching the controller.

Regards.

Hi, if I am not wrong, you didn't load the theme field to MS Project, so its values are blank in the new rows (not loaded from Redmine), and then it raised errors when you save them.

otirado-isotrol commented 1 month ago

Hi, Maybe I didn't explain myself well or I didn't understand your answer very well. The procedure I followed is that we have a MS Project template, and when we have a new project in Redmine what we do is load the tasks from MS Project. Therefore, when opening the template in MS Project, opening the add-in and clicking "Save" it gives the error of the theme. When the "Theme" column is A "Task Name" which as you can see in the image is filled in.

conveniencable commented 1 month ago

Hi, But the errors is "tema no puede estar en blanco", not the "nombre de tarea", do you have a custom field "tema" and it was not loaded(not checked in the right sidebar) to Ms Project?

otirado-isotrol commented 6 days ago

Hi, the translation of the 'Subject' field of the task is 'Tema', that's why the error appears. As you can see, the check is marked and corresponds to Name ('Nombre de la tarea) tema