Resolved Problem combining fields when custom importing

Hello Steve,

The combine field is indeed not available in the custom fields import. What you can try is to add the combine field to the database yourself and check if this works for you.

You can execute this command in PhpMyAdmin:

INSERT INTO `jos_csvi_available_fields` (`csvi_name`, `component_name`, `component_table`, `component`) VALUES ('combine', 'combine', 'jea_properties', 'com_csvi');

Only thing you need to change is the jos_ to match your own prefix. After this the combine field should be available in the list of fields.

It worked like a dream. Thank you very much!! Perhaps you can put this ability into the next update?

Perhaps you can put this ability into the next update?

The code has been added for the next update, so the combine, skip and custom field will be there too.

Hi again, I have now come back to this project, and now need to make another two fields combine together. I'm assuming you can do more then one different combination per import?

If so, the trouble I am having is the fact I have lost the 'combine' field on my 'custom import'.

I've attached a few screenshots, I would like to combine number 53 with 65, and when they are combined I would like to apply some replacements.

When I click on field 53, in the list of 'field name's I can't see the combine field. I can see a combine ID though. I'm not sure if there is something I am doing wrong here. Could you please help?


I'm thinking perhaps I need to run the php code above?

Many thanks

I'm assuming you can do more then one different combination per import?

That shouldn't be a problem.

If so, the trouble I am having is the fact I have lost the 'combine' field on my 'custom import'.

Did you do an update, maybe the DB change early on got lost? Run the code again and check if it is back.

I see a lot of fields called access in your template, this means that CSVI can't find the field you assigned to it so it takes the first one.

Thanks rolandd, re-running the code did bring it back.

I was also having trouble replacing the text "Per Annum £5,000" with 'RENTING'. It looks like when the string went into the field without the replacement, it would only say "Per Annum ", notice the space after it and no '£5,000'. It looks like the £ sign was causing it to forget the rest of the field? Anyway, to solve my problem I just needed to replace the text "Per Annum " with 'RENTING'. But for future reference is this the case?

Much appreciated

Stephen

Hello Stephen,

But for future reference is this the case?

This is a classical problem of a file that contains extended characters, like the pound sign, but is not a UTF-8 file. If the file is a UTF-8 file, the rest of the text would be imported as well.