Jump to content
VJ

Easy Populate & Products Attributes

Recommended Posts

OK. Well, only other thing that comes to mind is that when I look at my copy of easypopulate.php, I have

<code>

manufacturers_id="' . $v_manufacturer_id

</code

not

<code>

manufacturers_id=' . $v_manufacturer_id

</code

 

Ok, here's what I get when I put that " in;

 

File uploaded. 
Temporary filename: /tmp/phpnXYZRl
User filename: Inventory1.txt
Size: 38137
| 7406 | | 7406 | IC - TTL - | | 3.99 | 0.05 | 0000-00-00 | | 10 | various | Parts | Integrated | 74 Series | GST/HST/PS | Active | KGS | CM | 2 | 1 | 0.5 | 0 Updated
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '83")' at line 4

UPDATE products SET products_price="3.99" ,products_image="", products_weight="0.05", products_weight_type="kgs", products_dim_type="CM", products_length="2", products_width="1", products_height="0.5", products_ready_to_ship="0", products_tax_class_id="2", products_date_available= "0000-00-00 00:00:00", products_date_added= CURRENT_TIMESTAMP, products_last_modified=CURRENT_TIMESTAMP , products_quantity="10" ,manufacturers_id="10 , products_status=1 WHERE (products_id = "83")

 

I checked again, using the easypopulate.php file from the original archive, and there is no " where you indicate in my copy.

 

Perhaps you should show me that whole section in your copy so I can compare it with my modified copy as the file I have might have been a pre-error correction one.

 

I'm willing to consider anything at this point :'(

 

Again, thatnk you for al the time you're taking with this,

 

Richard


No Good Deed EVER Goes Unpunished

Share this post


Link to post
Share on other sites
Ok, here's what I get when I put that " in;

 

File uploaded. 
Temporary filename: /tmp/phpnXYZRl
User filename: Inventory1.txt
Size: 38137
| 7406 | | 7406 | IC - TTL - | | 3.99 | 0.05 | 0000-00-00 | | 10 | various | Parts | Integrated | 74 Series | GST/HST/PS | Active | KGS | CM | 2 | 1 | 0.5 | 0 Updated
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '83")' at line 4

UPDATE products SET products_price="3.99" ,products_image="", products_weight="0.05", products_weight_type="kgs", products_dim_type="CM", products_length="2", products_width="1", products_height="0.5", products_ready_to_ship="0", products_tax_class_id="2", products_date_available= "0000-00-00 00:00:00", products_date_added= CURRENT_TIMESTAMP, products_last_modified=CURRENT_TIMESTAMP , products_quantity="10" ,manufacturers_id="10 , products_status=1 WHERE (products_id = "83")

 

I checked again, using the easypopulate.php file from the original archive, and there is no " where you indicate in my copy.

 

Perhaps you should show me that whole section in your copy so I can compare it with my modified copy as the file I have might have been a pre-error correction one.

 

I'm willing to consider anything at this point :'(

 

Again, thatnk you for al the time you're taking with this,

 

Richard

 

now there is an open quote before the manufacturer is value which is not closed after it, so this is not that

 

suggestion: try to echo the query, instead of injecting in the database, to see what is passed

 

find at line 1812

 

	$result = tep_db_query($query);

 

and replace by

 

$result = echo $query ."<br>";

 

and see what kind of queries are injected.

after that you can copy the string and run it in a mysql window and see if there is an error... or if the string is actually malformed

Share this post


Link to post
Share on other sites
now there is an open quote before the manufacturer is value which is not closed after it, so this is not that

 

suggestion: try to echo the query, instead of injecting in the database, to see what is passed

 

find at line 1812

 

	$result = tep_db_query($query);

 

and replace by

 

$result = echo $query ."<br>";

 

and see what kind of queries are injected.

after that you can copy the string and run it in a mysql window and see if there is an error... or if the string is actually malformed

 

Ok, cutting and pasting that gave me a nice white screen with

 

Parse error: parse error, unexpected T_ECHO in /home/vintagecomputerparts/catalog/admin/easypopulate.php on line 1812

 

when I tried to access easypopulate.php


No Good Deed EVER Goes Unpunished

Share this post


Link to post
Share on other sites
Ok, cutting and pasting that gave me a nice white screen with

 

Parse error: parse error, unexpected T_ECHO in /home/vintagecomputerparts/catalog/admin/easypopulate.php on line 1812

 

when I tried to access easypopulate.php

 

ooops sorry it's late

 

not

 

$result = echo $query ."<br>";

 

but

 

echo $query ."<br>";

Share this post


Link to post
Share on other sites
ooops sorry it's late

 

not

 

$result = echo $query ."<br>";

 

but

 

echo $query ."<br>";

 

And the result was.....................................

 

Easy Populate 2.76c-MS2 - Default Language : English(1) 

File uploaded. 
Temporary filename: /tmp/phpB1eZGI
User filename: Inventory1.txt
Size: 38137
| 7406 | | 7406 | IC - TTL - | | 3.99 | 0.05 | 0000-00-00 | | 10 | various | Parts | Integrated | 74 Series | GST/HST/PS | Active | KGS | CM | 2 | 1 | 0.5 | 0 Updated
UPDATE products SET products_price="3.99" ,products_image="", products_weight="0.05", products_weight_type="kgs", products_dim_type="CM", products_length="2", products_width="1", products_height="0.5", products_ready_to_ship="0", products_tax_class_id="2", products_date_available= "0000-00-00 00:00:00", products_date_added= CURRENT_TIMESTAMP, products_last_modified=CURRENT_TIMESTAMP , products_quantity="10" ,manufacturers_id=10 , products_status=1 WHERE (products_id = "83")
| 7407 74 | 7408 74 | 7410 74 | 7411 74 | 7414 74 | 7416 74 | 7417 74 | 7425 74 | 7428 74 | 7430 74 | 7432 74 | 7437 74 | 7438 74 | 7440 74 | 7442 74 | 7446 74 | 7447 74 | 7448 74 | 7453 74 | 7454 74 | 7474 74 | 7476 74 | 7486 74 | 7490 74 | 7493 74 | 74107 7 | 74112 7 | 74116 7 | 74121 7 | 74123 7 | 74143 7 | 74148 7 | 74150 7 | 74150 7 | 74151 7 | 74166 7 | 74175 7 | 74191 7 | 74192 7 | 74193 7 | 74367 7 | 74368 7 | 75462 7 | 75463 7 | 75472 7 | 75477 7 | 75478 7 | 75491 7 | 75492 7 | 76477 7 | 325572-0 | 6N136 6 | 720DC 7 | 733DC 7 | 74AS174 | 74C00 7 | 74C74 7 | 74C90 7 | 74C93 7 | 74C107 | 74C902 | 74C925 | 74F32 7 | 74F74 7 | 74F153 | 74F253 | 74H00 7 | 74HC943 | 74LS00 | 74LS04 | 74LS05 | 74LS09 | 74LS10 | 74LS11 | 74LS13 | 74LS14 | 74LS20 | 74LS22 | 74LS27 | 74LS30 | 74LS32 | 74LS38 | 74LS42 | 74LS47 | 74LS48 | 74LS51 | 74LS54 | 74LS55 | 74LS73 | 74LS74 | 74LS75 | 74LS76 | 74LS83 | 74LS85 | 74LS86 | 74LS90 | 74LS92 | 74LS93 | 74LS95 | 74LS107 | 74LS109 | 74LS112 | 74LS113 | 74LS123 | 74LS126 | 74LS133 | 74LS136 | 74LS138 | 74LS139 | 74LS148 | 74LS151 | 74LS151 | 74LS155 | 74LS156 | 74LS157 | 74LS158 | 74LS160 | 74LS161 | 74LS163 | 74LS164 | 74LS165 | 74LS166 | 74LS169 | 74LS173 | 74LS174 | 74LS175 | 74LS189 | 74LS190 | 74LS191 | 74LS192 | 74LS193 | 74LS194 | 74LS195 | 74LS240 | 74LS242 | 74LS243 | 74LS244 | 74LS245 | 74LS251 | 74LS253 | 74LS257 | 74LS258 | 74LS259 | 74LS266 | 74LS273 | 74LS293 | 74LS299 | 74LS322 | 74LS365 | 74LS367 | 74LS368 | 74LS373 | 74LS377 | 74LS390 | 74LS393 | 74LS629 | 74LS670 | 74S00 7 | 74S04 7 | 74S05 7 | 74S08 7 | 74S32 7 | 74S40 7 | 74S74 7 | 74S86 7 | 74S138 | 74S139 | 74S175 | 74S280 | 74S299 | 8088-2 | 8237-5 | AM26LS32 | AM26LS33 | AM27LS03 | AM9016 | C010444 | C014895 | CA3046 | CA3051 | CA3059 | CA3086 | CA3146 | D444C-1 | DM81LS86 | DRAM256K | FDC1793- | FDC1793B | KB3600-P | MC6845 | MK4102/T | SC77527 | Z80-CTC |

 

Looks about the same to me, but, it's late here too LOL


No Good Deed EVER Goes Unpunished

Share this post


Link to post
Share on other sites
And the result was.....................................

 

Easy Populate 2.76c-MS2 - Default Language : English(1) 

File uploaded. 
Temporary filename: /tmp/phpB1eZGI
User filename: Inventory1.txt
Size: 38137
| 7406 | | 7406 | IC - TTL - | | 3.99 | 0.05 | 0000-00-00 | | 10 | various | Parts | Integrated | 74 Series | GST/HST/PS | Active | KGS | CM | 2 | 1 | 0.5 | 0 Updated
UPDATE products SET products_price="3.99" ,products_image="", products_weight="0.05", products_weight_type="kgs", products_dim_type="CM", products_length="2", products_width="1", products_height="0.5", products_ready_to_ship="0", products_tax_class_id="2", products_date_available= "0000-00-00 00:00:00", products_date_added= CURRENT_TIMESTAMP, products_last_modified=CURRENT_TIMESTAMP , products_quantity="10" ,manufacturers_id=10 , products_status=1 WHERE (products_id = "83")
| 7407 74 | 7408 74 | 7410 74 | 7411 74 | 7414 74 | 7416 74 | 7417 74 | 7425 74 | 7428 74 | 7430 74 | 7432 74 | 7437 74 | 7438 74 | 7440 74 | 7442 74 | 7446 74 | 7447 74 | 7448 74 | 7453 74 | 7454 74 | 7474 74 | 7476 74 | 7486 74 | 7490 74 | 7493 74 | 74107 7 | 74112 7 | 74116 7 | 74121 7 | 74123 7 | 74143 7 | 74148 7 | 74150 7 | 74150 7 | 74151 7 | 74166 7 | 74175 7 | 74191 7 | 74192 7 | 74193 7 | 74367 7 | 74368 7 | 75462 7 | 75463 7 | 75472 7 | 75477 7 | 75478 7 | 75491 7 | 75492 7 | 76477 7 | 325572-0 | 6N136 6 | 720DC 7 | 733DC 7 | 74AS174 | 74C00 7 | 74C74 7 | 74C90 7 | 74C93 7 | 74C107 | 74C902 | 74C925 | 74F32 7 | 74F74 7 | 74F153 | 74F253 | 74H00 7 | 74HC943 | 74LS00 | 74LS04 | 74LS05 | 74LS09 | 74LS10 | 74LS11 | 74LS13 | 74LS14 | 74LS20 | 74LS22 | 74LS27 | 74LS30 | 74LS32 | 74LS38 | 74LS42 | 74LS47 | 74LS48 | 74LS51 | 74LS54 | 74LS55 | 74LS73 | 74LS74 | 74LS75 | 74LS76 | 74LS83 | 74LS85 | 74LS86 | 74LS90 | 74LS92 | 74LS93 | 74LS95 | 74LS107 | 74LS109 | 74LS112 | 74LS113 | 74LS123 | 74LS126 | 74LS133 | 74LS136 | 74LS138 | 74LS139 | 74LS148 | 74LS151 | 74LS151 | 74LS155 | 74LS156 | 74LS157 | 74LS158 | 74LS160 | 74LS161 | 74LS163 | 74LS164 | 74LS165 | 74LS166 | 74LS169 | 74LS173 | 74LS174 | 74LS175 | 74LS189 | 74LS190 | 74LS191 | 74LS192 | 74LS193 | 74LS194 | 74LS195 | 74LS240 | 74LS242 | 74LS243 | 74LS244 | 74LS245 | 74LS251 | 74LS253 | 74LS257 | 74LS258 | 74LS259 | 74LS266 | 74LS273 | 74LS293 | 74LS299 | 74LS322 | 74LS365 | 74LS367 | 74LS368 | 74LS373 | 74LS377 | 74LS390 | 74LS393 | 74LS629 | 74LS670 | 74S00 7 | 74S04 7 | 74S05 7 | 74S08 7 | 74S32 7 | 74S40 7 | 74S74 7 | 74S86 7 | 74S138 | 74S139 | 74S175 | 74S280 | 74S299 | 8088-2 | 8237-5 | AM26LS32 | AM26LS33 | AM27LS03 | AM9016 | C010444 | C014895 | CA3046 | CA3051 | CA3059 | CA3086 | CA3146 | D444C-1 | DM81LS86 | DRAM256K | FDC1793- | FDC1793B | KB3600-P | MC6845 | MK4102/T | SC77527 | Z80-CTC |

 

Looks about the same to me, but, it's late here too LOL

 

you are right: whay don't you start over tomorrow from the initial EP, adding the new fields one by one only and see how it goes each time you add a field

Share this post


Link to post
Share on other sites
you are right: whay don't you start over tomorrow from the initial EP, adding the new fields one by one only and see how it goes each time you add a field

 

Yeah, I might as well, and might as well go to 2.90 as well

 

Thanks again, for all the help and I'll let you know what happens

 

Richard


No Good Deed EVER Goes Unpunished

Share this post


Link to post
Share on other sites

While we're waiting for Richard to try that... will anyone PLEASE take a moment and tell me how to use (or if I *can* use) EP given product options? With only a couple dozen defined so far, EP maxes out the max number of columns allowed in a spreadsheet.

Share this post


Link to post
Share on other sites

My EP is working okay, but.....

 

I get an error message because I've exceeded the "product_model" length. I've used MySQL to extend the field length. So via Admin I can enter 'Not Available" (13 digits & space) as the "product_model". Everything is fine, except if I download and re-import!

 

The error message is...

13not available... ERROR! - Too many characters in the model number.

12 is the maximum on a standard OSC install.

Your maximum product_model length is set to 12

You can either shorten your model numbers or increase the size of the field in the database.

So I need help on where in Admin can I increase the field length of the "product_model" as I must be going blind and can't see where to do it :(

 

Thanks in advance :)


____________________________________________________________________

____________________________________________________________________

Share this post


Link to post
Share on other sites
My EP is working okay, but.....

 

I get an error message because I've exceeded the "product_model" length. I've used MySQL to extend the field length. So via Admin I can enter 'Not Available" (13 digits & space) as the "product_model". Everything is fine, except if I download and re-import!

 

The error message is... So I need help on where in Admin can I increase the field length of the "product_model" as I must be going blind and can't see where to do it :(

 

Thanks in advance :)

 

at the begining of a 2.9 version, there is a portion of code that looks like this:

 

[/code]

while ($product_definition=tep_db_fetch_array($table_definition_query)){

if ($product_definition[Field]=='products_model'){

if (substr($product_definition[Type],0,7)=='varchar'){

$modelsize=substr($product_definition[Type],8,strlen($product_definition[Type]));

$modelsize=substr($modelsize,0,(strlen($modelsize)-1));

}

}

}

 

looks like changing this 7 and 8 would do the trick ;)

Share this post


Link to post
Share on other sites
you are right: whay don't you start over tomorrow from the initial EP, adding the new fields one by one only and see how it goes each time you add a field

 

Ok, this is interesting.....

 

I removed the modified easypopulate.php file and the function file and replaced them with the files from the original archive, made the configuration changes, exported the stuff I had in the store, immediately tried to import it back into the store and guess what I got?

 

Easy Populate 2.76c-MS2 - Default Language : English(1) 

File uploaded. 
Temporary filename: /tmp/phpTXKgnO
User filename: EP2006Nov04-1010.txt
Size: 11288
| 4024 | | 4024 | IC - CMOS | | 3.99 | 0.05 | 0000-00-00 | 2006-11-02 | 1 | various | Parts | Integrated | 40/45 Seri | GST/HST/PS | Active Updated
| 4023 402 | 4022 402 | 4020 402 | 40001 40 | 4002 400 | 4007 400 | 4008 400 | 4011 401 | 4012 401 | 4013 401 | 4015 401 | 4016 401 | 4017 401 | 765 765 | 6507 650 | 6532 653 | 7805 780 | 7812 781 | 7912 791 | 8048 804 | 8085 808 | 8088 808 | 8253 825 | 8259 825 | 8279 827 | 8865 886 | 9216 921 | 9636 963 | 9639 963 | 4025 402 | 4028 402 | 4030 403 | 4040 404 | 4042 404 | 4043 404 | 4044 404 | 4046 404 | 4050 405 | 4052 405 | 4053 405 | 4066 406 | 4069 406 | 4082 408 | 4099 409 | 40106 40 | 4503 450 | 4511 451 | 4517 451 | 4528 452 | 4558 455 | 7400 740 | 7402 740 | 7404 740 | 7406 740 | 7407 740 |


No Good Deed EVER Goes Unpunished

Share this post


Link to post
Share on other sites
Ok, this is interesting.....

 

I removed the modified easypopulate.php file and the function file and replaced them with the files from the original archive, made the configuration changes, exported the stuff I had in the store, immediately tried to import it back into the store and guess what I got?

 

Easy Populate 2.76c-MS2 - Default Language : English(1) 

File uploaded. 
Temporary filename: /tmp/phpTXKgnO
User filename: EP2006Nov04-1010.txt
Size: 11288
| 4024 | | 4024 | IC - CMOS | | 3.99 | 0.05 | 0000-00-00 | 2006-11-02 | 1 | various | Parts | Integrated | 40/45 Seri | GST/HST/PS | Active Updated
| 4023 402 | 4022 402 | 4020 402 | 40001 40 | 4002 400 | 4007 400 | 4008 400 | 4011 401 | 4012 401 | 4013 401 | 4015 401 | 4016 401 | 4017 401 | 765 765 | 6507 650 | 6532 653 | 7805 780 | 7812 781 | 7912 791 | 8048 804 | 8085 808 | 8088 808 | 8253 825 | 8259 825 | 8279 827 | 8865 886 | 9216 921 | 9636 963 | 9639 963 | 4025 402 | 4028 402 | 4030 403 | 4040 404 | 4042 404 | 4043 404 | 4044 404 | 4046 404 | 4050 405 | 4052 405 | 4053 405 | 4066 406 | 4069 406 | 4082 408 | 4099 409 | 40106 40 | 4503 450 | 4511 451 | 4517 451 | 4528 452 | 4558 455 | 7400 740 | 7402 740 | 7404 740 | 7406 740 | 7407 740 |

 

Holy cow! that doesn't go better. maybe your image names with no .jpg having the same values as your model numbers are responsible?

Share this post


Link to post
Share on other sites
Holy cow! that doesn't go better. maybe your image names with no .jpg having the same values as your model numbers are responsible?

 

Actually, the two items that have the same number are the v_products_model and the v_products_name_1,

the image name is just blank.

 

I'm going to try the original easypopulate.php (not so easy as one would like, it seems) without changing any of the options from default other than the path to the temp file.

 

Now I'm really at a loss as to what the problem might be.


No Good Deed EVER Goes Unpunished

Share this post


Link to post
Share on other sites
Actually, the two items that have the same number are the v_products_model and the v_products_name_1,

the image name is just blank.

 

I'm going to try the original easypopulate.php (not so easy as one would like, it seems) without changing any of the options from default other than the path to the temp file.

 

Now I'm really at a loss as to what the problem might be.

 

Nope, same thing on trying to import a just exported file


No Good Deed EVER Goes Unpunished

Share this post


Link to post
Share on other sites
want my 2.9? ;-)

 

I have 2.9, it's just that it has sooo much stuff in it that I don't need that I'm hesitant to use it, but, it looks like I have no choice.


No Good Deed EVER Goes Unpunished

Share this post


Link to post
Share on other sites
I have 2.9, it's just that it has sooo much stuff in it that I don't need that I'm hesitant to use it, but, it looks like I have no choice.

 

Ok, I installed 2.9, imported the update sql, tried an import and got the "1054 - Unknown column 'p.products_price1_qty' in 'field list'" error. I think I recall seeing a fix for that somewhere. I take it it will correct the error?


No Good Deed EVER Goes Unpunished

Share this post


Link to post
Share on other sites
Ok, I installed 2.9, imported the update sql, tried an import and got the "1054 - Unknown column 'p.products_price1_qty' in 'field list'" error. I think I recall seeing a fix for that somewhere. I take it it will correct the error?

 

that's because you don't have quantity discount mod installed. You can either remove all occurences to the price1, price 2, etc.. or just run a sql that adds these fields to your products table (quicker)

Share this post


Link to post
Share on other sites
that's because you don't have quantity discount mod installed. You can either remove all occurences to the price1, price 2, etc.. or just run a sql that adds these fields to your products table (quicker)

 

I think I'll just take the time to remove them seeing as I have no intention of offering quantity discounts on my site.

 

Be back in a couple of hours LOL


No Good Deed EVER Goes Unpunished

Share this post


Link to post
Share on other sites
I think I'll just take the time to remove them seeing as I have no intention of offering quantity discounts on my site.

 

Be back in a couple of hours LOL

 

PM me with your email if you need me to send you my 2.9 with my 3 extra fields already in place (a search and replace should be pretty fast)

Share this post


Link to post
Share on other sites
PM me with your email if you need me to send you my 2.9 with my 3 extra fields already in place (a search and replace should be pretty fast)

 

Isn't there a nice, simple, easy-to-modify contrib that just lets you add fields and import and export inventory?

 

EP is way more than I need and, with all the contribs imbedded in it (stuff I'll never use), and no way to easily turn them off, it's way too complicated for my needs.

 

None of my items have attributes, nor will they, I'm not offering quantity discounts, and all I REALLY need is something that will let me add fields to accomodate the Canada Post with Dimensions parameters (products_weight_type, products_dim_type, products_length, products_width, products_height, products_ready_to_ship)

 

I thought that EP would save me time, but, I've been screwing around with it for 2 weeks and I could have put everything in manually in that time.


No Good Deed EVER Goes Unpunished

Share this post


Link to post
Share on other sites
Isn't there a nice, simple, easy-to-modify contrib that just lets you add fields and import and export inventory?

 

EP is way more than I need and, with all the contribs imbedded in it (stuff I'll never use), and no way to easily turn them off, it's way too complicated for my needs.

 

None of my items have attributes, nor will they, I'm not offering quantity discounts, and all I REALLY need is something that will let me add fields to accomodate the Canada Post with Dimensions parameters (products_weight_type, products_dim_type, products_length, products_width, products_height, products_ready_to_ship)

 

I thought that EP would save me time, but, I've been screwing around with it for 2 weeks and I could have put everything in manually in that time.

 

 

unfortunately, no: you will have to customize your EP. Personally, I have 5 different versions from 2.8 to 3.0 that I use depending on the store I'm working on. If you want extra fields to be managed, they need to be declared in your EP code...

Share this post


Link to post
Share on other sites
at the begining of a 2.9 version, there is a portion of code that looks like this:

while ($product_definition=tep_db_fetch_array($table_definition_query)){
  if ($product_definition[Field]=='products_model'){
 if (substr($product_definition[Type],0,7)=='varchar'){
   $modelsize=substr($product_definition[Type],8,strlen($product_definition[Type]));
   $modelsize=substr($modelsize,0,(strlen($modelsize)-1));
 }
  }
}

looks like changing this 7 and 8 would do the trick ;)

Hi Hugh :)

 

Thanks for the lead. mine isn't 2.9, but an earlier version. However whilst searching for the code you posted, I came across this

global $modelsize;

$modelsize = 12;

so increased the 12 to 14, and I have success :D

 

Thanks

 

Steve


____________________________________________________________________

____________________________________________________________________

Share this post


Link to post
Share on other sites
unfortunately, no: you will have to customize your EP. Personally, I have 5 different versions from 2.8 to 3.0 that I use depending on the store I'm working on. If you want extra fields to be managed, they need to be declared in your EP code...

 

Ok, different method of attacking this until I can work with 2.9 long enough to get the feel for it.

 

I imported the text file of my inventory in Excel and saved it out as a CSV file as my MySQL database will import CSV files.

 

Now, I'm using phpMyAdmin and the CSV options are as follows;

 

CSV optionsReplace table data with file
Ignore duplicate rows
Fields terminated by ,
Fields enclosed by "
Fields escaped by \
Lines terminated by (box with Auto in it)
Column names (blank)

 

Obviously, I need to know what the lines are terminated by and what it expects in the columns space. I don't, so, it's not importing.

 

Any help here?

 

Thanks


No Good Deed EVER Goes Unpunished

Share this post


Link to post
Share on other sites
Ok, different method of attacking this until I can work with 2.9 long enough to get the feel for it.

 

I imported the text file of my inventory in Excel and saved it out as a CSV file as my MySQL database will import CSV files.

 

Now, I'm using phpMyAdmin and the CSV options are as follows;

 

CSV optionsReplace table data with file
Ignore duplicate rows
Fields terminated by ,
Fields enclosed by "
Fields escaped by \
Lines terminated by (box with Auto in it)
Column names (blank)

 

Obviously, I need to know what the lines are terminated by and what it expects in the columns space. I don't, so, it's not importing.

 

Any help here?

 

Thanks

 

importing directly in mysql is possible, however, you may be in trouble with orphan products (not linked to their categories) because each product has a category ID and is linked by ID to the category ID: the category name is not a field of the products table. So you will need to know all your categories ID before you import them, otherwise, they won't show up in your storefront

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×