Categories
View Replies (7)

Resolved J3.4.3 CSVI Pro 6.1.0 File Extension Help Needed

  1. yorkshireladdie
    yorkshireladdie
  2. RO CSVI
  3. Wednesday, 02 December 2015
  4.  Subscribe via email
Hi,
I am using J3.4.3 CSVI Pro 6.1.0 File.
I used same number of fields and same orders in export and import template.
I just exported successfully and trying to modify and import the same file.
I am on WINDOWS 8 office 2007.I opened the csv into xls sheet and edited it.
Finally i saved it into .csv(MS-DOS) and .xls(Excel 97-2003 Workbook) and trying to import.
I am getting following error while uploading "No supported fields have been found in the import file"
I am attaching the file i made after getting it from export.
0
Responses (7)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

If you have set "Use column headers for configuration" to Yes in your template it won't work. That is because your column headers are not using the CSVI fieldnames.

There are 2 things you can do. First change the column headers in your file or set the Use column headers for configuration to No in your template and add the fields to your template in the same order as they are in your import file.
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. # 1
yorkshireladdie
yorkshireladdie
Accepted Answer Pending Moderation
Thanks for your reply.I just edited the xls sheet and edited import template.
Please check attachedment.
I attached edited ProductExportSampleCSVByHasan.xls to be imported,import template fields order "Import-Template.png" and the error i am getiing while uploading "Error-With-Xls-Import.jpg"
Please help me.
Thanks again.
Hasan
Attachments (2)
ProductExportSampleCSVByHasan-2.xls
Error-With-Xls-Import.jpg Error-With-Xls-Import.jpg
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Hasan,

I see another issue in your screenshot, that is the Warning. Please update CSVI first to version 6.4.2 as this contains more fixes. If you still get the message after that, post also screenshots of how you have setup your template.

I have no issues seeing your fields in the preview.
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. # 3
yorkshireladdie
yorkshireladdie
Accepted Answer Pending Moderation
Thanks for your reply.
Here is the template i have setup and the xls sheet i prepare.
Please let me know if you get anything wrong.
Kind Regards
Hasan
Attachments (2)
ProductExportSampleCSVByHasan-3.xls
Template-fields.jpg Template-fields.jpg
  1. more than a month ago
  2. RO CSVI
  3. # 4
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Hasan,

You actually don't have to fill the Column Header, CSVI will take the field name as column header. The Default Values don't make much sense to me. These should be values that are used when nothing is found in the database.

I meant the import template settings, the one you edit when you go to Templates -> Templates.
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. # 5
yorkshireladdie
yorkshireladdie
Accepted Answer Pending Moderation
Thanks for your reply.
So what are you suggesting now? Should i remove column header and default value from template? Or should i remove column header from xls sheet.Please advise me.
Kind Regards
Hasan
  1. more than a month ago
  2. RO CSVI
  3. # 6
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Hasan,
So what are you suggesting now? Should i remove column header and default value from template? Or should i remove column header from xls sheet.Please advise me.

Yes remove the column header and default value from the template and set Use column headers for configuration option to No in your template settings.
Kind regards,

Tharuna

=========================
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. # 7
  • Page :
  • 1


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