1. regme_rojo
  2. RO CSVI
  3. Sunday, 26 June 2022
  4.  Subscribe via email
Importing contact data to Joomla! I wonder if it's possible to tell RO CSVI to use a custom field as index for an entry.
I have the

<LSRMitarb>
<LSR_ID></LSR_ID>
...
</LSRMitarb>

LSR_ID as unique value in every entry. This value is obviously not in the Joomla! database, so I added it as custom field.
Can I tell RO CSVI to use this field as identifier for each entry? Would make matching / updateing values much easier.

Thanks!
Chris
Accepted Answer Pending Moderation
Actually, the more I think about it, the more I come to the conclusion that this would solve a lot of problems. :)
If there were a "plugin" I could tell that this specific value / field is my unique identifier, updateing items would be without problems. In my case: the change of the category path (eg. change of department) would not create a second contact item but only update the existing one.
This is what I need, and I guess it would be useful for others, too.
If that kind of functionality does not exist, could you give me a quote?

Thanks you again!
Chris
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hello Chris,

In all these years I am doing RO CSVI, you managed to come up with yet a new request :D Now I see your point and I see the use-case for it. There is nothing of the likes in RO CSVI because nobody has asked for it as it is also more of something that is only usable once you configured your site to work in a certain way.

Agree, if we are going to do something like this it should be abstract in a way that you could have a processor for primary key, processor for alias, processor for a custom field, processor for if it rains :p etc.

Let me have a closer look at what this entails and I can come back to you with a quote. Just want to make sure we can give you something that allows you to update to newer versions without having to patch each update.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Thanks for your reply, RolandD!

Somehow I'm glad I came up with something new, somehow I'm sad because this is crucial for my use case and I expected RO CSVI could do something like this. And I did not plan any budget for that :p
I'm also surprised nobody would have the need for such a functionality, because it seems so "simple" and obvious.

I "just" need to add contact data for persons that eventually move from one department to another (eg. contact categories). Or have name changes due to marriage, or drop out and new one move in, etc. So basically synchronize contacts from an external file on a regular basis. If it where only to import the data once I'd be quicker (and already finished) by putting in all data manually :D

I have some more pieces of data to be to synchronized after the contacts, and I guess I'll have the same need. So please have a look on this.

Thank you very much!
Chris
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
There's another thing I found, that's probably connected with this: The INT custom field is perhaps not the best option for what I need to do. I have 8digits ID numbers for each contact. If I use the INT custom field
a) it does not show the actual database content but always "1". I can see that the data is correctly imported to the database and the custom field, but in the backend it allways schows "1" (like "one";).
b) it always shows a dropdown (which makes it unusable in backend) - I should have seen this in the Joomla! documentation.
c) There seems to be a nasty bug if I define the field with values between 1 and 1000000 (in steps of 1): I can't edit the contact anymore.

Basic line - and that's why I write this down - : I guess I need to index a Joomla! custom _text_ field.
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello Chris,

For the past couple of days I have been looking into this and I have reached a conclusion. The all-inclusive option I am working on is not something that will be ready/implemented soon, soon as in days. This is going to take some weeks. I understand that you cannot wait for that so the alternative solution is to use an import override in this case.

The INT field is only useful if you have a full integer, any number with preceding 0s are trimmed as well. So let's say you have the value 001, 002, this will then be stored as 1, 2 and so next time you check it thinks it does not exist because 001 is not the same as 1. A text field in this case will be better.

There seems to be a nasty bug if I define the field with values between 1 and 1000000 (in steps of 1): I can't edit the contact anymore.
That will be because you are going to get a dropdown with 1 million entries ;) Your browser most likely won't be able to render it :)

I will send an email with the quote for the custom import routine.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Thanks!
Looking forward to hear from you.

Meanwhile I posted a bug report on the Joomla! tracker, but I understood that the problem was me using INT for a wrong purpose. A textfield with integer filter is much better. No errors. Learning, learning, learning .... constant learning :p
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hello Chris,

The email was sent earlier today.

constant learning :p
There is no end to it, for us as well :o
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
I was going through all my issues, and I found this as "unresolved".
Well, somehow, yes.
So I ask two questions:

  • Any news on this new feature?
  • Should I make this thread as resolved or leave it open to "remember"?

Best regards!
Chris
  1. one week ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
Hello Chris,
Any news on this new feature?

We provided you an override for supporting this feature as a custom job. If the question is about if we have plans to include this feature in core RO CSVI then we are looking into this feature not just for contacts but also for Joomla content.

Should I make this thread as resolved or leave it open to "remember"?

You can set this to resolved if your issue has been solved.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. one week ago
  2. RO CSVI
  3. # 9
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!