View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] Multiple Update - ProjeQtOr
 

[SOLVED] Multiple Update

More
11 Apr 2022 07:50 #1 by chandrashekhar
Multiple Update was created by chandrashekhar
Hi Expert,

I want to replace the existing name in all activities by adding some words before the name.
i.e. existing activity name is as follows:
1. Wages Module
2. Leave Module
I want to update the above two items with the following :
1. Doc.Wages Module
2. Doc.Leave Module

I tried to find in Our Multiple Update Feature but I couldn't get it. If We are being able to do that, It will be a very helpful feature.
Please guide me if it is already available in Projeqtor.

Please Log in or Create an account to join the conversation.

More
11 Apr 2022 11:36 #2 by babynus
Replied by babynus on topic Multiple Update
You cannot through multiple update.
Multiple update will allow to Change the name to a new value, but not "add" some text before existing.

But you can easily do this with export / import :
  • On activity screen apply filter so that only activities you want to update appear.
  • Export result to CSV : you just need to export fields id and name
  • Open exported file with Excel and change name (you can use formula or macro in Excel).
    Take care to keep the id unchanged
  • Re-mport the file : it's done
Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
11 Apr 2022 12:30 #3 by chandrashekhar
Replied by chandrashekhar on topic Multiple Update
Thank you for reply.

I tried as you instructed , but I didn't find any option to re-import those two fields ! I have checked import data , but it gives messages for other fields. Please Guide me more.

Please Log in or Create an account to join the conversation.

More
11 Apr 2022 13:47 #4 by babynus
Replied by babynus on topic Multiple Update
Import Data.
Select Activity (if you exported Activities)
If you kept the ID, just having ID and name is enough to update the name.
Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
11 Apr 2022 14:10 - 11 Apr 2022 14:14 #5 by chandrashekhar
Replied by chandrashekhar on topic Multiple Update
Import data is showing these many fields (as per attached screenshot) , where else you are asking to import data ?! (i.e. I have CSV file with id & name only)
Attachments:
Last edit: 11 Apr 2022 14:14 by chandrashekhar. Reason: image not showing proper in message box

Please Log in or Create an account to join the conversation.

More
25 Aug 2022 11:37 #6 by chandrashekhar
Replied by chandrashekhar on topic Multiple Update
Hi,
I appreciate your continuous support.

I tried as you guided, but still i don't get my purpose solved. Please refer attachments.

Please Log in or Create an account to join the conversation.

Moderators: babynus, protion
Time to create page: 0.034 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.

Login Form