EasyPopulate 4.0 Support Thread

[mc12345678]

Hi Everyone...

I need some help understanding what I am doing here. I've got the Easy Populate module installed and it seems to be working. I downloaded a FullEP set and added some products and it all seemed to load just fine. My issue is that I am selling downloadable products and would like to be able to add the zip file field right to the same spreadsheet and upload it. I already have my option names and option values set up in the store as Download 1 - Zip 1 (radio button).

My question is: Can I simply add the fields for my zip file onto the same spreadsheet as all my other product info? and if so...
What do I list the fields as and where do I add the zip file name?

Thanks so much...

So, I must say a good question. First would say that as a result of the appropriate fields not showing up, that it may take a little more to turn around and get the desired data back into your database. Typically the field name in your spreadsheet file is the field name in the database with v_ prepended. So would have to identify what the field name(s) are that would be needed to hold the information you are looking to include. The other part of that is what table(s) hold that additional information. My thought is that some additional coding would be necessary to accomplish the task. The functions file under the full section of the set file layout would need to include the additional lookup info in the sql command, and then I think in the import area some more coding may be necessary to properly upload/import the new data to the correct table(s).

[mc12345678]

Hi Everyone...

I need some help understanding what I am doing here. I've got the Easy Populate module installed and it seems to be working. I downloaded a FullEP set and added some products and it all seemed to load just fine. My issue is that I am selling downloadable products and would like to be able to add the zip file field right to the same spreadsheet and upload it. I already have my option names and option values set up in the store as Download 1 - Zip 1 (radio button).

My question is: Can I simply add the fields for my zip file onto the same spreadsheet as all my other product info? and if so...
What do I list the fields as and where do I add the zip file name?

Thanks so much...

So, I must say a good question. First would say that as a result of the appropriate fields not showing up, that it may take a little more to turn around and get the desired data back into your database. Typically the field name in your spreadsheet file is the field name in the database with v_ prepended. So would have to identify what the field name(s) are that would be needed to hold the information you are looking to include. The other part of that is what table(s) hold that additional information. My thought is that some additional coding would be necessary to accomplish the task. The functions file under the full section of the set file layout would need to include the additional lookup info in the sql command, and then I think in the import area some more coding may be necessary to properly upload/import the new data to the correct table(s).

Basically, I might have been able to edit my last post, but doubtful within the time allowed, so thought I would answer the questions asked a little more specifically.

Yes you can eventually have the related information added to your table, but I think you will have to have additional coding to handle it. The zip file location would be a path much like the photo path. I thought I remembered seeing download attribute information though in the attribute(s) file(s). So it would take a series of download/upload to get all of the info into the database the way desired.

I haven't personally looked into that attribute of it yet, but I seem to remember seeing the additional fields addressed in the code. If that is the case (and I'll take a quick look in the near future to see if I'm right), then you would work with the appropriate attributes file after the product description/details were uploaded.

[mc12345678]

Basically, I might have been able to edit my last post, but doubtful within the time allowed, so thought I would answer the questions asked a little more specifically.

Yes you can eventually have the related information added to your table, but I think you will have to have additional coding to handle it. The zip file location would be a path much like the photo path. I thought I remembered seeing download attribute information though in the attribute(s) file(s). So it would take a series of download/upload to get all of the info into the database the way desired.

I haven't personally looked into that attribute of it yet, but I seem to remember seeing the additional fields addressed in the code. If that is the case (and I'll take a quick look in the near future to see if I'm right), then you would work with the appropriate attributes file after the product description/details were uploaded.

Okay, so had an opportunity to look at the code from a computer. The detailed attributes file is the way that EP4 is currently setup to handle/address the attributes that you are looking for. If you download a version of that file now, you should see examples of how to format and upload additional attributes. One reason that I think this is setup this way is that you can have multiple files associated with a single product, therefore, a format like how the attributes files work is the path to go. As said previously, this would require working with two different files. The full file for all of the data associated with/specific to the item, and then an attributes file to link the download file information to the product.

Specifically, the fields: v_products_attributes_filename, v_products_attributes_maxdays, and v_products_attributes_maxcount would at least be applicable. with your zip file filename listed in the first field designator shown here.

[amandavz]

Okay...So I downloaded the attributes files and set it up with the following fields:

v_products_model
v_products_options_name
v_products_options_type
v_products_options_values_name
v_products_attributes_filename
v_products_attributes_maxdays
v_products_attributes_maxcount

I then added only 1 product to test this and imported the information. In doing so I get this error:

File Import Completed with issues.
An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer

Do I not need to add the

v_products_options_name
v_products_options_type
v_products_options_values_name

To the file since they are already set up in the store? I am not sure I completely understand how this works but I do appreciate your helping me. Thanks so much. :)

[amandavz]

I GOT IT!!! :)

Thanks for all your help!!! :)

Okay...so I tried multiple ways to get this thing right. I ended up downloading the Basic Products Attributes and added the fields you mentioned above. I was trying to create it with JUST the fields above, I left the Basic Attributes in tact and added the fields you specified, uploaded, imported and it worked!!!

I am going to run a test purchase just to make sure I got it all correctly done...thank you so much for your help. My customer will be very happy. :)

[amandavz]

UPDATE:

So I ran the test purchase and everything "looks" like it is there, t shows me the attributes attached to the product, but there is no actual zip file t download at the end of the checkout.

It only takes me to a page that says: "Please notify me of updates to these products" if I go into My Account, it does not show the download button there either.

I feel that I am so close to getting this, I am just not there yet and not sure what I am missing.

If you want to take a look, the site is: http://studiorockcreek.com/shop/ and it's the product marked FREE.

Thanks. :)

[mc12345678]

UPDATE:

So I ran the test purchase and everything "looks" like it is there, t shows me the attributes attached to the product, but there is no actual zip file t download at the end of the checkout.

It only takes me to a page that says: "Please notify me of updates to these products" if I go into My Account, it does not show the download button there either.

I feel that I am so close to getting this, I am just not there yet and not sure what I am missing.

If you want to take a look, the site is: http://studiorockcreek.com/shop/ and it's the product marked FREE.

Thanks. :)

What were the results of downloading the detailed attributes file? It seemed that there were more fields in there that would accomplish what you are trying to do, and the way the code appears to be written it includes download (and subsequent upload) of the information needed to populate/activate the download. Perhaps another question is, the file that is "linked" to the product, does it exist where it is supposed to be and named the way it is supposed to be on the server?