Resolved problems with k2

Perfect! Thanks so much!
Once again great support, great component ...your help was much appreciated!

Hello,

There was a typing mistake in the file. Please use the attache file and it should be good to go.

Hi, Many thanks again for your help! Really appreciate your time on this for me, Ill have no hesitation in recommending your component/service or using it again in future projects.

Regarding the patch, (thanks again) but really sorry to say its not working, its showing me the following error and not importing or modifying any articles, ..sorry for the bad news .... also I wanted to remind you that you already modified this file in an earlier patch for the alias to be created from the title, im sure you had remembered though!

Oops something went wrong.

Let me try to show the warning below here. If nothing shows up then I didn't get any data, sometimes this is caused by faulty plugins.

Cancel the import and check if all settings are correct and try the import again. Status error: 200 Status message: OK
Fatal error: Call to a member function getQuery() on a non-object in /homepages/43/d445035053/htdocs/clickandbuilds/Joomla/Luxury_Flatshares/administrator/components/com_csvi/models/com_k2/import/itemimport.php on line 131

Hello,

I have seen where the problem is and there is no easy way arond this so I have created a quick fix for you also because there will not be any new releases of CSVI 5. This change will be fine and an integrated solution will be made for CSVI 6.

Load the attached patch file and existing entries should be updated now.

Ok please see attached for the last few import logs.. here is the order of most recent at the top

1438178563
1438177694
1438177036
1438175440

Thanks again!

Jimmy,

Please post it as a zip attachment, the text is way too long to be pasted into a message as it is cut off.

Thanks again!

<removed debug log>

Jimmy,

Please post your debug log as requested at the top of the page, so I can see what happens during the import. The item should be updated based on the alias field.

Since the first title did not have a space and now it does. Check if the aliases are the same. Otherwise run the import again and check if it really adds it or this was a one-time off.

Thanks again for your help! Great support! Great component!

Imports working great now, only thing is when reimporting it creates all new k2 articles rather than updating ones that currently exist, how can I get it to update the k2 articles that exist?

You can compare the template against the tutorials I linked earlier, the majority of the problems was the incorrect order of the fields and the dual purpose of the 3 fields.

To add the space, you can modify the title field and set the combine character to a space.

Many thanks for your help Roland, much appreciated.. im curious to know how you did it/what i didn't do? but dont want you to spend extra time explaining.

Just one last thing... I just need a space inbetween the fields that combine to make the title ... currently there are no spaces inbetween... many thanks again!

Hello,

Asking for the details was going to be my next question Send me a private message with the login details and I will take a look. Also include FTP details please in case I need to figure out why it isn't working.

Hi, Still cant get it, dont know how long I have spent on this now.

For the combine fields I see you have set the Template field name, that is incorrect. That needs to be emptied.

I removed this now, but there are now no settings for the combine field ..nothing to associate it with the field I need.

Any chance (to save anymore of these posts) you can quickly login to my admin and sort this out, Im sure its the smallest detail thats incorrect.

Afraid to say I still cant get the combines title field working (im no idiot! lol), currently its importing no title.

Don't be afraid, I won't hit you

So the images gives me some ideas. For the combine fields I see you have set the Template field name, that is incorrect. That needs to be emptied. You didn't include an image of all the fields you setup but the custom field should be place in the list where you have the PropertyPostcode field and same for the ID field.

For example your CSV looks like this:
Title,Postcode,ID,Room8Price
My,2342,2343,80
You want to combine the first 3 fields, your template should have this field layout:
Title
combine
combine
Room8Price

So, don't create new fields but put the combine field in the existing location of the postcode and id field.

Hopefully that is clear.

ALSO i wanted to ask if theres a way to get items/records that dont appear on the CSV but were previously (and are on the frontend of the site) to be deleted or unpublished?

ALSO i wanted to ask if theres a way to get items/records that dont appear on the CSV but were previously (and are on the frontend of the site) to be deleted or unpublished?

You will need to run an export of all your items and then re-import them with the published field set to N or 0.

Afraid to say I still cant get the combines title field working (im no idiot! lol), currently its importing no title.

Please see screenshots for the settings, would really appreciate your advice on where im going wrong?




ALSO i wanted to ask if theres a way to get items/records that dont appear on the CSV but were previously (and are on the frontend of the site) to be deleted or unpublished?
Otherwise it would be a matter of having a 'published' column on the csv and values for 1 for published or 0 for unpublished for each record, right?

Hello Jimmy,

So I believed the instructions were idiot-proof

im trying to use 3 fields in the title to ensure its not duplicated

Show me how you have setup your fields. The PropertyArea should be the title field and the other two must be the combine fields. After that you must select the two combine fields in the title field.

Hi, Ok thanks, as the duplicate alias is an issue, im trying to use 3 fields in the title to ensure its not duplicated (PropertyArea, PropertyPostcode & PropertyID) but i really cant work out how to do this after spending much time on it and following this guide http://www.csvimproved.com/en/support/questions-and-answers/873-combine-multiple-fields-into-one

In the tutorial I see no fields or anything assigned to the combine field, I dont see what purpose this has, to be honest id really appreciate some idiot-proof instructions, thanks

If you have 2 identical titles, you will get identical aliases. Which will result in the latter updating the former. In K2, you can't have duplicate aliases either as you won't be able to save the item.

In a future release I will deal with duplicate aliases as well.

Many thanks! Looks to be working good.. im just doing some further testing and will let you know.

My only concern is, if there are 2 identical titles, will the aliases also be identical? which would obviously cause an issue.

Hello Jimmy,

Attached is the patch file that turns the title into an alias on import. You can load the patch file and then run your import and the alias should be created from the title.

Let me know how it goes.