Categories
View Replies (35)

Resolved image import

  1. iozo
    iozo
  2. RO CSVI
  3. Friday, 24 October 2014
  4.  Subscribe via email
Hello again,

I need to import images to K2.
The stream is coming with an image field as follows :

mc2/StillLife_10_140.gif
mc2/Syberia_10_140.gif
microapp/7816_140.gif

images are stored on a remote server with a known root url, let's say

http://media.remotesite.com/images/games

I want to grab the images :

http://media.remotesite.com/images/games/mc2/StillLife_10_140.gif
http://media.remotesite.com/images/games/mc2/Syberia_10_140.gif
http://media.remotesite.com/images/games/microapp/7816_140.gif

and store it locally in my Joomla images folder, ideally in a dedicated subfolder.
I'm expecting to see in the K2 media manager something like :

/images/games/mc2/StillLife_10_140.gif
/images/games/mc2/Syberia_10_140.gif
/images/games/microapp/7816_140.gif

I'm also expecting the appropriate K2 image field to be filled with the right image.

I described the image information in the field mapping. Here is what the analyser displays :

CSV fields Top

Big image
Product Name

CSV data Top
If you see any unreadable characters in this table, your file is not UTF-8 encoded. Make sure your file is UTF-8 encoded so special characters like ë are imported correctly.
1 2
mc2/StillLife_10_140.gif Still Life
mc2/Syberia_10_140.gif Syberia
microapp/7816_140.gif Scratches

How to setup CSVI pro for that :

1. Where to indicate the root remote URL
2. I checked the import image to yes,What else should I do to ?

thanks,
0
Responses (35)
rolandd
rolandd
Accepted Answer Pending Moderation
If I look at the file you posted here and the screenshot of the fieldmap above, they don't match. The order of the fields in the file is different than what you have in the fieldmap.

If you have changed the file, you must upload it again in the fieldmap to redo the mapping with the new order.

The Big image field is 2nd in the file but 2nd to last in the screenshot.
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. # 21
iozo
iozo
Accepted Answer Pending Moderation
I'm using the same file since I started these tests.
This is the one catalog_export_20141027_094933_2014-10-29.csv

I used the same file to generate the field mapping and the template.
I use also the same file to test the import.

Now I understand that something goes wrong with the mapping process.
the order is the inverse of the CSV file order.
I did it several times to check and I can see that in my file, the field 'status' is the last field and in the mapping it's the first.

Therefore all the data is mixed up.

Can you reproduce the issue ?
Attachments (1)
catalog_export_20141027_094933_2014-10-29.csv
  1. more than a month ago
  2. RO CSVI
  3. # 22
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

I have tried a number of things but I can't reproduce it. You state that the order is inverse but that is not the case either if I look at the file and the screenshot, the fields are all mixed up. This did give me an idea that the database might be returning the records in random order in your case.

Load this patch file and check if the fields are now in order as it forces a sorting. Once the fields are in the correct order, you can create a new template.

Let me know how it goes.
Attachments (1)
patch_map_20141030.zip
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. # 23
iozo
iozo
Accepted Answer Pending Moderation
I loaded the patch, did reset, rescanned the available fields.
I verified the list of available fields for K2. That looks OK.

I checked my CSV file with the analysis tab. Looks OK as well.

I deleted my field mapper and tried to recreate a brand new one.
Parameters K2, import, items.
When I press save I see no fields in the list.

I double checked in the 'Available field' tab. If I select K2/item I see a list of available field.
Something must be broken in the Filed mapping process
  1. more than a month ago
  2. RO CSVI
  3. # 24
rolandd
rolandd
Accepted Answer Pending Moderation
When I press save I see no fields in the list.
Just to be sure, you did upload the CSV file?

Something must be broken in the Filed mapping process
The only change is to list the fields in the order they are saved.
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. # 25
iozo
iozo
Accepted Answer Pending Moderation
Just to be sure, you did upload the CSV file?

of course, I create a new field mapping (I erased all previous ones)
I set the name, the sample CSV, adjust settings to K2, import.
When I get the red message I press save and previously at this stage the list of fields is displayed.

The only change is to list the fields in the order they are saved.


That's frustrating. When I open the analysis tab the fields are displayed as explected. But no more in the mapping tab.

Should I restart from 0. Uninstall everything and reinstall patch1 then patch 2 ?
  1. more than a month ago
  2. RO CSVI
  3. # 26
iozo
iozo
Accepted Answer Pending Moderation
I can confirm, I did it again like that.

Uninstall CSVI
Reinstall V 5.19
Update available fields
Create test field mapping
set name, CSV, K2, import, Save
=> I see the list of fields (wrong order)

Load K2 patch (patch_k2_20141028)
Reset
Create test field mapping
set name, CSV, K2, import, Save
=> I see the list of fields (wrong order)

Load map order patch (patch_map_20141030)
Reset
Create test field mapping
set name, CSV, K2, import, Save
=> the list of available fields is empty
  1. more than a month ago
  2. RO CSVI
  3. # 27
rolandd
rolandd
Accepted Answer Pending Moderation
I can confirm, I did it again like that.
I followed your process but still see the CSVI fields being populated. The only time I managed to have them empty is when I selected CSVI as component.

The other thing I tried is to change the Operation type. Do you even get the operation type? There seems to be no mention of it.

Another thing you can do is enable the Joomla! debug system option, if there is any database error it should show up there. You can do that via Site -> Global configuration -> System -> Debug System change to Yes and save the configuration. If you now create the map, if there is any database error, it will show up.
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. # 28
iozo
iozo
Accepted Answer Pending Moderation
The other thing I tried is to change the Operation type. Do you even get the operation type? There seems to be no mention of it.


Yes the settings are K2, import, item import with the same CSV file as usual. If I try other settings like operation = category import instead of item import or if I change component, I still get an empty list.

With the original version or the first K2 image patch everything works as expected.

Another thing you can do is enable the Joomla! debug system option, if there is any database error it should show up there. You can do that via Site -> Global configuration -> System -> Debug System change to Yes and save the configuration. If you now create the map, if there is any database error, it will show up.


I turned the debug on and here is the debug log I get.

csvidebuglog.txt

If you feel you could get to solution faster with a more interactive testing session we could use skype or teamviewer. I can PM you the details.
Attachments (1)
csvidebuglog.txt
  1. more than a month ago
  2. RO CSVI
  3. # 29
rolandd
rolandd
Accepted Answer Pending Moderation
I checked the log and all looks normal there. Add me on Skype and we can check further, the name is csvimproved
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. # 30
iozo
iozo
Accepted Answer Pending Moderation
ok done, you should see my request on skype. thanks.
  1. more than a month ago
  2. RO CSVI
  3. # 31
rolandd
rolandd
Accepted Answer Pending Moderation
Not sure if you added me already but I don't see a request.
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. # 32
iozo
iozo
Accepted Answer Pending Moderation
just did it again. do you see me now ?
  1. more than a month ago
  2. RO CSVI
  3. # 33
iozo
iozo
Accepted Answer Pending Moderation
skype support was awesome. The field mapping issue is now fixed. It needed another patch to work. But everything's fine now.

the missing patch was here

http://www.csvimproved.com/forum?view=topic&catid=24&id=31895&start=6#41122
  1. more than a month ago
  2. RO CSVI
  3. # 34
iozo
iozo
Accepted Answer Pending Moderation
image import works fine now.
  1. more than a month ago
  2. RO CSVI
  3. # 35
  • Page :
  • 1
  • 2


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