Resolved NEW Feature: Random value for CSVI Multireplace

Hello Steffen,
Sorry for sending the patch file so late but unique ID has been added as an option to CSVI Multi replace plugin. Please install the attached modified CSVI Multi replace plugin using Joomla extension manager. You should then see Unique ID as an option in Multi replace rule. Please test and let me know how it goes.

plg_multireplace_modified.zip

Hello Steffen,

This is something we can add in CSV Improved. Do you mean the PHP function uniqid() because unique() is not a function in PHP.

Of course you can already do so yourself by either modifying this plugin or creating your own plugin.

Hello Roland,

Of course, "uniqid ()" is meant. Sorry, I'm not a php specialist.

Nevertheless, I've just been working on the topic of writing a plugin for CSVI improved and have inspected the files of the existing plugins.

With the conditional.php I am at the end with my knowledge. The risk is too high to break something here.

Could you integrate this feature into CSVI improved?


I thought about it. One could certainly integrate this most sensibly in CSVI Conditional.
In the subform under "Replace with" you can then select "uniqid ()" and under "Field / Value" you could even pass a prefix for the function.

Does it make sense?

I would probably need a whole week for this without any prospect of success, but for you as professionals .......B)

Best regards
Steffen

Hello,

Could you integrate this feature into CSVI improved?

It is on the todo list for the next release.

Having the unique ID can be part of both the multi-replace and the conditional plugin. Although the suggestion of "misusing" the Field/Value is not something I am fond of. If you prefix the value, I wonder what the use-case is. This prefix takes it a step further again. The prefixing can already be done by using the combine plugin. It is a longer way round but this is possible.

What are you actually trying to achieve?

Good morning Roland,

I do not need a Prafix for my case. This was just an idea to make sense of the field / value field for uniqid () in the conditional plug-in. Alternatively, of course, the field at the selection uniqid () can be disabled.

What are you actually trying to achieve?

I have built an application in Joomla that allows me to maintain and extend a product database. This product table is based on an XLS file, which has a precise structure. The structure resulted from a year-long XLS export of an ERP system. This XLS file is used to automatically populate a product catalog (approximately 300 pages) in Adobe InDesign. The connection between InDesign and the ERP system is the product ID of the ERP system.

Our company has now changed the ERP system. An XLS export with the new ERP system works, but the product IDs are no longer available to me. The connection to InDesign is broken.
In order not to have to make everything new, I do the maintenance with my application in Joomla on the MySQL database. My product IDs are kept and new products get a new ID via uniqid () (only for linking to InDesign). From the MySQL I can then make an XLS export, which works with InDesign to 100%.

In order to make the processing (> 2000 products) a little easier for the colleagues (editing with Excel), I would like to be able to update products via export / import and import new ones. The update routine works already, only when importing new products do I need the uniqid () function to create an ID for linking to InDesign.

I hope this was understandable.
For me, the feature is incredibly valuable in this case. Possibly, but I'm also the only one who ever needs this in the next few years. :unsure:

When do you expect the next version? Gladly I test the plugin for you also in advance.

MANY THANKS and kind regards
Steffen

Hello Steffen,

Interesting story

My product IDs are kept and new products get a new ID via uniqid () (only for linking to InDesign).

Do the products not get an auto-increment ID from the database?

When do you expect the next version?

There is no set deadline yet because we only just released a new version.

Hello Roland,

after all, you get that, but in a different column than InDesign uses for linking.

An example:
Product A used to receive the ID "1000012345" from the ERP system. (And that's exactly what the IDs look like in this ERP system). This ID is the key to link to InDesign.
This ID is now in a text field (var) in MySQL. Products can be customized, the ID remains the same.
For new products, I use the uniqid () to create a unique ID in this field. Since letters are always included here, there will be no conflicts with existing IDs.

Hence the desire for this feature for CSVimproved so I can add new articles to the database via import.

Kind regards
Steffen

Hello Steffen,

All clear, thank you for the explanation. Next week we will be able to provide you with a patch for testing and update this thread.

Hello Tharuna,

the plug-in works perfectly. The value of the assigned field is replaced by a unique value.

I miss at this point a filter that I needed. The unique value should only be set if the field is empty.

I could also solve this by a detour with a temporary field. It's not the cleanest way though and the configuration confuses you a bit.
You could help me a lot with that. Thanks alot.

But if you say, a filter would be good and you want to optimize "unique ID" I would very much welcome.
I also like to do a test for you - no problem ;-)

Perfect support - I love this tool.
Respectfully, Steffen

Hello Steffen,

I could also solve this by a detour with a temporary field. It's not the cleanest way though and the configuration confuses you a bit.
You could help me a lot with that. Thanks alot.

You can solve it by using temporary field and conditional rule plugin. You can set the condition, if product_sku is empty use field value from another field and that should be set to your temporary field. This should fix your issue.

Hello Tharuna

That's exactly how I did it.

Thanks Steffen

Hello Steffen,
So did that solve your problem?

Good morning Tharuna,

Thank you, my problem is solved.

Greetings Steffen