Resolved Import from K2 to Form2contact

dave_logic
RO CSVI
Wednesday, 17 January 2018
Subscribe via email

Hi,

Firstly, I wish you had a pre-sales section on your forum that potential customers could question the import / export possibilities prior to purchase as I could not find a defined answer in your documentation. Anyway, paid for a subscription now based on my observations on what this can do.

The scenario:

* I need to convert around 1000 K2 items into Form2content articles.
* The extra fields in K2 are already mirrored in F2Content as fields within the particular content-type. The type of fields also match.
* I also use Styleware K2 Map plugin with K2 to geocode maps.

I can see that com_content and K2 components are supported and I can see that in the previous version change log you state that Styleware Map is also supported although not on your official list on your site.

Question 1 - Can I do this ?

1 - Export the Header and Pitch fields from Styleware Map into K2 two new K2 extra fields.
2 - Once this is done export the K2 items and extra fields (including the above) into a CSV.
3 - Import the exported K2 CSV data into Form2content to copy the extra fields to F2C fields and the K2 items to F2C articles?

Maybe there is an easier way, if so please advise.

Joomla 3.83
K2 2.80
F2Content 6.16.0
Styleware K2 Maps - Latest version

Regards,

Dave

Responses (20)

tharuna

Accepted Answer Pending Moderation

Hello Dave,

Firstly, I wish you had a pre-sales section on your forum that potential customers could question the import / export possibilities prior to purchase as I could not find a defined answer in your documentation. Anyway, paid for a subscription now based on my observations on what this can do.

Any pre sale queries can be posted on CSVI contact form page or can be sent as an email to contact@csvimproved.com.

I can see that com_content and K2 components are supported and I can see that in the previous version change log you state that Styleware Map is also supported although not on your official list on your site.

Yes, CSVI supports com_content, K2 and also Form2Content. We also support Styleware may for K2 which you can download from CSVI downloads page.

1 - Export the Header and Pitch fields from Styleware Map into K2 two new K2 extra fields.

You can do that by exporting Styleware map fields from K2 item export operation and import it back as extra fields.

2 - Once this is done export the K2 items and extra fields (including the above) into a CSV.

You can use K2 item export operation so to get the k2 items into a CSV file.

3 - Import the exported K2 CSV data into Form2content to copy the extra fields to F2C fields and the K2 items to F2C articles?

CSVI supports both K2 and Form2Content import and export operations. Make sure that you have CSVI K2 addon extension and CSVI Form2Content addon installed along with CSVI main package on your site. You can find these extensions on CSVI Pro Extensions section in Downloads page. You can then export the needed details from K2 and import the file in to Form2Content.

Let us know if you need any more details.

Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

more than a month ago
RO CSVI
# 1

dave_logic

Accepted Answer Pending Moderation

Hi Tharuna,

Thank you for the prompt response. I must say I love this component.

I haven't quite grasped the concepts yet as I cant get the Field Mapping working.

To be clear, am I supposed to use the Field Mapping to map one component (K2) column names into the other (F2C) column ? When I do this with a small extract of the K2 export it detects the column names, I then map to F2C column names however when I save with a Field Map title nothing appears but does display the 'Item saved' message however if I check the XXX_csvi_maps table in MySQL the records are there.

Regards,

Dave

more than a month ago
RO CSVI
# 2

tharuna

Accepted Answer Pending Moderation

Hello Dave,

To be clear, am I supposed to use the Field Mapping to map one component (K2) column names into the other (F2C) column ?

Yes, that correct.

When I do this with a small extract of the K2 export it detects the column names, I then map to F2C column names however when I save with a Field Map title nothing appears but does display the 'Item saved' message however if I check the XXX_csvi_maps table in MySQL the records are there.

What i see from the message is that you have done the field mapping correct. When you go to CSVI Field mapper main page, Do you see the field mapper you saved? If yes, you can now create a import template by clicking the Create template link. Please have a look at Field mapper document on details.

Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

more than a month ago
RO CSVI
# 3

dave_logic

Accepted Answer Pending Moderation

Hi Tharuna,

That's my point. There is nothing there. Its says saved using the standard Joomla 'Item saved' message however there is no record available to click on the Create Template link as per your documentation. If I look intto the ...csv1_maps table in MySQL it is there however not in the Joolma CSVI GUI. I'vev tried different browsers just in case and made sure that there are no known conflicting 3DP plugins enabled.

Regards,

Dave

more than a month ago
RO CSVI
# 4

tharuna

Accepted Answer Pending Moderation

Hello Dave,
May i know which version of CSVI you are running? Can you send me the file you used in field mapper along with few screenshots on how you tried to map the fields? I will run the test here and check.

Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

more than a month ago
RO CSVI
# 5

dave_logic

Accepted Answer Pending Moderation

Hi Tharuna,

I am using CSVI Pro 7.4.0 with Joomla 3.83. I'm not even getting the mapping stage now which was working before. Please see attachments including the file uploading plus the export log. There is also a screen shot of the MySQL table showing the records.

Regards,

Dave

more than a month ago
RO CSVI
# 6

tharuna

Accepted Answer Pending Moderation

Hello Dave,
Let me help you here to go step by step on this. The export file you have posted is not a UTF-8 encoded file, you can see three weird characters at the starting of the file. First thing you need to do is to Save csv file as UTF-8 file as explained in the document. Once that is done, you need to go to Field mapper and upload the export file, give a title to the field mapper. The action, component and operation field you have entered are correct as per your screenshot. Save the field mapper. CSVI will read your uploaded field and the column headers in your file and will show the list of fields to be mapped on the right hand side of field mapper page as shown in the attached screenshot. Map the fields and Save them again. Send me the screenshot of the page and what you see on the main field mapper page.

If you are still having problem send me your administrator login details as a private message. I will have a look at your site.

Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

more than a month ago
RO CSVI
# 7

dave_logic

Accepted Answer Pending Moderation

Hi Tharuna,

Ok. It must have been the UTF-8 encoding causing the secondary issue however the mapping record still does not appear in the GUI. I have saved as UTF-8 and can now map the fields however the mapping does not appear in the Joomla backed. Please see attached.

I will send you a PM with my details - Thanks.

Regards,

Dave

more than a month ago
RO CSVI
# 8

tharuna

Accepted Answer Pending Moderation

Hello Dave,
Thank you for sending the requested details. As expected there was a missing field in #__csvi_maps table which was breaking the display of field mapper page. I fixed it on your site. Can you check now?

Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

more than a month ago
RO CSVI
# 9

dave_logic

Accepted Answer Pending Moderation

Hi Tharuna,

Yes thanks. I have created a template from this now which is an import template. Is this correct?

I have tried to import this using a subset of my content. I thought I would do a single category to prevent time outs etc. I have gone through process, fields detected all ok and columns all look fine however I get this message on every line. The category alreadsy exists in com_content.

You are missing the required field(s):
- projectid or projecttitle

Obviously, this is a pretty clear message however my question is - Which field or fields in K2 would be mapped to these projectid or projecttitle F2C fields?

Regards,

Dave

more than a month ago
RO CSVI
# 10

dave_logic

Accepted Answer Pending Moderation

Attached debug log..

more than a month ago
RO CSVI
# 11

tharuna

Accepted Answer Pending Moderation

Hello,

Yes thanks. I have created a template from this now which is an import template. Is this correct?

Yes thats correct.

I have tried to import this using a subset of my content. I thought I would do a single category to prevent time outs etc. I have gone through process, fields detected all ok and columns all look fine however I get this message on every line. The category alreadsy exists in com_content.

Please update CSVI to 7.4.1 version as there was a small issue with F2C importing categories and that is fixed with this version. Don't forget to update your CSVI F2C addon extension as well.
If you still have issues, post a sample of your import file along with the latest import debug log. It will also be good if you can post your template XML file, to get the template XML file go to CSVI maintenance menu, select CSVI Pro in first option and Backup templates in second option. Select the import template and click continue. Post the downloaded XML file.

You are missing the required field(s):
- projectid or projecttitle

Obviously, this is a pretty clear message however my question is - Which field or fields in K2 would be mapped to these projectid or projecttitle F2C fields?

CSVI is looking for Content type title in F2C article import and that is what is said as projecttitle or projectid. As per my knowledge it should be mapped to the K2 Extra fields group name.

Screen Shot 2018-01-22 at 11.07.45 AM.png

Screen Shot 2018-01-22 at 11.07.45 AM.png

Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

more than a month ago
RO CSVI
# 12

dave_logic

Accepted Answer Pending Moderation

Hi Tharuna,

After much playing about I have managed to successfully import one K2 category into Form2content using the import function. The only issue left is that it neither re-creates the thumbnails when the option is chosen nor does it add any reference to the DB tables regarding the K2 Image. Is there a process I am missing here ?

I can see in the debugs that it cannot locate the image.

2018-02-04	14:12:38	12	[DEBUG]	Process field type Image

2018-02-04	14:12:38	12	[QUERY]	SELECT `name` FROM `logic_f2c_fieldtype` AS `ft` LEFT JOIN `logic_f2c_projectfields` AS `pf` ON `pf`.`fieldtypeid` = `ft`.`id` WHERE `pf`.`fieldname`='Image' AND `pf`.`projectid`=6

2018-02-04	14:12:38	12	[DEBUG]	No filename found for field Image. Values are 3d4417dea4b5985d283b0a7dfa9861de.jpg

Should I be using the IMAGE URL field instead ?

Regards,

Dave

more than a month ago
RO CSVI
# 13

rolandd

Accepted Answer Pending Moderation

Hello Dave,

Are you using the Joomla categories import as Form2Content doesn't have it's own categories?

The log you posted indicates you are importing a field of the type Image. The format of the field seems to be incorrect and this should be at minimum:

filename:3d4417dea4b5985d283b0a7dfa9861de.jpg

CSV Improved will assign the image to the folder /images/stories/com_form2content/p<projectid>/f<formid>/. This is a fixed path and cannot be changed because that is how Form2Content works.

I see we do not have this clearly documented, so we will work on this.

Let me know how it goes.

Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

more than a month ago
RO CSVI
# 14

dave_logic

Accepted Answer Pending Moderation

Hi Roland,

Ref: filename:3d4417dea4b5985d283b0a7dfa9861de.jpg

Thanks for the response. Am I supposed to edit the CSV and add the "filename:" prefix in or can a Rule do this? (I haven't explored these yet)?

Ref: /images/stories/com_form2content/p<projectid>/f<formid>/.

Yes, I am aware of this however nothing gets created. No folders or images. Maybe this is because the image cannot be found in the previous step?

Regards,

Dave

more than a month ago
RO CSVI
# 15

tharuna

Accepted Answer Pending Moderation

Hello Dave,

Thanks for the response. Am I supposed to edit the CSV and add the "filename:" prefix in or can a Rule do this? (I haven't explored these yet)?

You can either edit the CSV file or create a replace rule using CSVI Multi replace plugin to put the filename: in front of your image name. The rule can be created as attached image.

Yes, I am aware of this however nothing gets created. No folders or images. Maybe this is because the image cannot be found in the previous step?

Yes, try putting the image in the above format and see if it works.

Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

more than a month ago
RO CSVI
# 16

dave_logic

Accepted Answer Pending Moderation

Hi,

I have modified the CSV an appended the 'image' column with 'filename'. I now have at least entries in the SQL table however no images show up nor are the folders / thumbnails created as previously discussed.

Image table contents: -

{"filename":"3d4417dea4b5985d283b0a7dfa9861de.jpg","title":"Bernays Grove","alt":"Bernays Grove"}

A working example

{"filename":"Arodene_Road-A.jpg","widthThumbnail":640,"heightThumbnail":400,"width":1234,"height":768,"alt":"","title":""}

Regards,

Dave

more than a month ago
RO CSVI
# 17

rolandd

Accepted Answer Pending Moderation

Hello Dave,

I now have at least entries in the SQL table however no images show up nor are the folders / thumbnails created as previously discussed.

I think we have a misunderstanding here. The image doesn't show up because the file doesn't exist and for that same reason the thumbnail is not created.

You have to copy the actual image files from K2 to the Form2Content folders. Now the image doesn't exist and so nothing happens.

Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

more than a month ago
RO CSVI
# 18

dave_logic

Accepted Answer Pending Moderation

Hi Roland,

OK, I thought that might be the case. Just to be clear, do I have to create the folder for the main image AND the thumbnail folder or does this folder get created when the thumbnail is created?

Regards,

Dave

more than a month ago
RO CSVI
# 19

tharuna

Accepted Answer Pending Moderation

Hello Dave,
You need to create folder for the main image and put the images in it. For thumbnail check if Automatic thumbnail creation is set to Yes in your template settings and on Image tab. This will create thumbs folder during import.

Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

more than a month ago
RO CSVI
# 20

Page :
1

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

Please login to post a reply

You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »

Forgot Password?

Resolved Import from K2 to Form2contact

RO CSVI

RO Payments

RO Users

RO Single Sign On