Resolved Can't add fields to template

Hello,

I have installed CSVI Pro, have created a template, and gone into Maintenance|Available Fields|Update and everything shows up fine. However when I go to Templates|Template Fields and try either the New or Quick Add buttons, the Field Name box shows nothing!

Do you see fields when you go to available fields page or is it empty over there too? Do you see any error while updating available fields? Check if you get any Javascript error on your template fields page using firebug console. Post screenshots on what you see in console tab.

Also - since I'm asking a question already - once we get this working, is there a way to filter the list of Field Names to choose from so I will only see the Field Names in the Products table?

You would see the field name of products table if you select Product as operation in your template. You have not given enough information here on which extension your are using, if its VirtueMart or HikaShop and which import/export you are trying to do. Without these details it is hard for us to help.

I am attaching login info in a txt file.

Joomla admin details in the text file dont work.

Sorry, here are the correct details.

Hello,
You have created a template with Component as CSVI Pro and operation as custom tables in your template and so you are not seeing any fields, this selection would be for doing any custom table import/export. Since you are trying to do VirtueMart Product export you have to select component as VirtueMart and Operation as Product in your template. I have corrected your template and the fields show up now.

Hi -

Thanks for that. Everything seems to be working fine, but for some reason the Width fields are not appearing of Inner, Outer or Assembled. Can you please look into this?

Thanks,

Brandon

Also, some fields (like Age Group) will have multiple values. How does CSVI handle this?

Hello Brandon,

but for some reason the Width fields are not appearing of Inner, Outer or Assembled.

Where are they not appearing?

Also, some fields (like Age Group) will have multiple values.

Multiple values will be pipe-symbol separated.

They are not appearing in Quick Add

Hi - I've just done a test export and the file is completely garbled. Some some reason it's producing two lines for just one product, and the data in columns in many cases does not correspond to the column headers. For example Bar Code is appearing under Age Group, Age Group is appearing under Bullet 6, Short Description is appearing under Bar Code... I could go on and on. Please help!!! I was supposed to deliver this website last Friday and the client is getting very upset.

Hello,

Hi - I've just done a test export and the file is completely garbled. Some some reason it's producing two lines for just one product, and the data in columns in many cases does not correspond to the column headers. For example Bar Code is appearing under Age Group, Age Group is appearing under Bullet 6, Short Description is appearing under Bar Code... I could go on and on. Please help!!! I was supposed to deliver this website last Friday and the client is getting very upset.

You need to use text enclosure in your export. Go to your export template settings on File tab give " in text enclosure field, save the template and try the export. That should solve your issue.

They are not appearing in Quick Add

Are these VirtueMart custom fields? If they are added new, you need to Update your available fields so you see them.

Now it just says No data has been found for the selections made

Hello,
Please post your export debug log to check. If you don't know how to get the debug log check Where to get the debug information? section on top of this page.

Hello,
Also, i missed something in your previous post.

Some some reason it's producing two lines for just one product

For duplicates, try adding Group by and Sort by fields to your export template.

Here is the log. Also I noticed when I tried another export that under Processed it says 0.

Hello,
You have set "Shopper group name price" filter on Options tab to All shopper groups in your export template, What if you set it to Don't use and try the export?

OK now we're getting somewhere. The CSV is formatted correctly and the data is in the correct columns. I do need to export price data, however... how would I do that?

Here is the login info again if you want to have a look:

http://209.200.104.34/administrator
MindSpyder
!Snowman1*

Hello,

I do need to export price data, however... how would I do that?

The basic price fields for product are available with Product export template you are doing now. You can add them to your template and export. Or if you need to export more price related fields which are not in product export, you can create another template where you select Component as VirtueMart and Operation as Price, add the export fields you need and do a export.

Then why is that option there, especially if it causes the export to fail? My client is not going to be happy about having to create two separate files.

Hello,
You need to add price fields to your export template fields so to export price data, Go to template fields page >> Select your product export template >> Add the price fields there. The filter you had selected is for exporting shopper group name price which was looking for Shopper group id to be 0 or Null, you may not be having records with this shopper group id and so it was not exporting anything. This has nothing to do with exporting price fields.

OK - and thanks for all your help so far, you've been great - now how to export the prices for each shopper group? I found something called shopper_group_name_price but that just puts in the word Guest. I need one Price column for each of the shopper groups.

Hello,
Try adding product_price and shopper_group_name fields to your template fields, this should get you the product prices for shopper groups.