Resolved K2 Extra Fields/CSVI v. 5.11 Pro

Hello,

Let's clear something up

Are you importing the extra fields as part of the item import or are you adding the Extra fields to your system?

The item import is currently not able to add the extra fields on import, I am working on a patch for that.

Hi,

Sorry for not being more clear hmy:

The extra K2 fields already exist in the K2 setup of my Joomla site.

What I would like to do now is import content from a CSV file into these fields…

Hope this makes sense.

Thanks again!

Hello,

That is all clear. Please give me a day or two to finalize the patch and I will post back here when I have it ready.

Wow, thanks!

I'll check back…

Hello,

The patch is ready and attached and can be loaded.

After the patch is loaded, go to Available Fields and click on Update. Now CSVI will know which extra fields are available for import.

In your import file you can use the Extra fields just like you would any other field. Currently the following field types are supported

• Date
• Multiple Select
• Radio
• Link
• Textfield
• Labels

For the multiple select, multiple values need to be separated by a pipe-symbol, |. The same goes if you want to import a link, the text, url and window are separated by pipe symbol.

Let me know how it goes.

Roland,

Thanks so much for the patch! I was able to load it successfully per your instructions.

However, my CSV file still won't import my extra fields.

After hitting "Process", the log tells me that two of my fields are unsupported -- and indeed they are my extra fields -- Part Number and Price. Both are simple text fields.

In the header of my CSV file, I represent Price as simply "price" and I tried both "part_number" and "partnumber" for Part Number.

So I have the feeling there is something simple and silly that I am neglecting.

Enlighten me??

Always grateful for your help!

Accidentally double-posted… my bad!

Hello,

You need to run the Update available fields after you added extra fields to K2, this is needed so you tell CSVI that there are new fields.

Please do the update and run your import again. If it doesn't process the extra fields, please post your debug log.

Thanks.

[EDIT] I found an issue with the extra fields import that needed addressing. Please find an updated patch attached. You can load it over the existing one.

[EDIT2] An updated patch, for importing new items

Hi, just for the record, I did indeed run the Update Available Fields command…

I will install the new version of your patch, do another test import, and get back to you with the results.

Stay tuned…

Okay, I installed the patch -- and ran Update Available Fields -- and I come up with the same results. It still doesn't seem to like the two fields I have designated as extra fields.

And so I am attaching both a screenshot of the error log and the CSV test file I am trying to import.

Thanks as always.

Hello,

Please post your debug log also for me to check. You can see these extra fields in the list of available fields for the Item import?

If so, make sure the capitalization is also matches. The field partnumber is not the same as Partnumber.

Hi, Roland:

I solved my initial problem -- indeed, it was a case issue. I assumed the field headers in my CSV file needed to be lower case, but once I matched the case with how the extra fields were represented in K2, I was home free.

Now, I have stumbled upon another issue:

My title and category data import just fine, but my extra field (Price, Part Number) data won't import. These are just text fields, so they shouldn't be a big deal.

I've done the following:

1. Made sure the appropriate extra field group is associated with the category.


2. Updated Available Fields in CSVI.


3. Under Import Options, I added my two extra fields and made sure the Template Field Name extra_fields was associated with them.

Attached are my latest test CSV file and debug log.

What am I doing wrong?

Hello,

I believe you have an older patch, there was a problem when inserting new items with custom fields. The custom fields would process but reset before insertion. Please check if you have the correct patch file that I posted here. You may want to re-upload the patch file to be sure.

Hi,

Indeed I installed the newer patch the first time around and I just re-installed it for good measure. I'm afraid I still get the same results -- my extra fields are empty. Is it possible you accidentally attached the older patch?

Attached is a new debug log in case you need it although I suspect it has the same info as the last one.

BTW also ran the Update Available Fields command…

Thanks.

Hello,

Is it possible you accidentally attached the older patch?

I did check that and it is the correct patch.

Something else, I see you have set Autodetect delimiters to Yes but your CSV file only contains a field delimiter not a text enclosure. Try setting the Autodetect delimiters to No and fill in a comma as field delimiter. Run the import again to see if that helps. If not, we can add some debug info for the import process.

Hi,

I did as you suggested and I'm afraid I still get the same results. No data imported into the extra fields.

Attached is my debug log from the last import.

Hello,

I am really surprised because I used this same code on another site and that imported fine. In addition ran it on my test server and it imported too.

What I have done is, removed the code that sets the default value for empty fields and let's see what happens then.

I am so sorry, I'm afraid I'm getting the same result -- my extra fields are still empty.

The *only* other thing I can think of is, although my extra fields are text fields, they contain numerical values (i.e., Part Number and Price). Would that be what is confusing things?

Attached is the log…

Hello,

The *only* other thing I can think of is, although my extra fields are text fields, they contain numerical values (i.e., Part Number and Price). Would that be what is confusing things?

That is not a problem, I imported your file also and this was just fine.

I am starting to think that the patch file is not in place. Do you see this line

					//$this->extra_fields = '[]';

in the file administrator\components\com_csvi\models\com_k2\import\ ?

The only other thing I can think of is the PHP version, I see you are on PHP 5.4.17, I am on 5.4.10, maybe that is a difference.

Hi,

When I load the patch, I get a "success" message (see attached screenshot).

However, I look in the file path you point me to (I assume the file you want me to open is extrafieldimport.php), I run a search, and I don't see the string you speak of. I am attaching the extrafieldimport.php file I looked in so you will know right away whether or not it is the one associated with your most recent patch…

Thanks and sorry for all the hassle.