CSV Upload

Author	« Topic »
iaind Advanced Member 145 Posts Pre-sales questions only (More Details...)	Posted - 12/31/2018 : 00:25:58 Hi I've just done what I do every morning to update our stock numbers with a CSV file, but I've got this message and don't know why. You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 ERROR: Column list is: "#65533;#65533;pid,pinstock" Rows successfully updated 0 This page took: 0.0007 seconds Update Successful ! Please click here for the admin home page.
Andy ECT Moderator 95440 Posts	Posted - 12/31/2018 : 00:33:55 Hi Iain It looks like you may have some errant characters at the beginning of the file. Can you open that up in a text editor like Notepad++ and check that? Andy Please feel free to review / rate our software
iaind Advanced Member 145 Posts Pre-sales questions only (More Details...)	Posted - 12/31/2018 : 00:35:46 Hi Andy That was the first thing that I checked and the file looks like: pID,PInStock TBM1001,36 TBM1002,87 TBM1003,30 TBM1004,27 TBM1005,28 Went back a few days to when I know it was working and it looks the same
Andy ECT Moderator 95440 Posts	Posted - 12/31/2018 : 00:57:59 Can you open the file again in Notepad++ and then go to Encoding > Convert to UTF-8 without BOM and then save the file and try the upload again? Andy Please feel free to review / rate our software
iaind Advanced Member 145 Posts Pre-sales questions only (More Details...)	Posted - 12/31/2018 : 01:11:51 And this is why you don't have 4 weeks off work! Human error - I was in the wrong directory and choosing the unedited file to upload. Sorry Andy. Have a good New Year
Andy ECT Moderator 95440 Posts	Posted - 12/31/2018 : 01:24:13 Glad you were able to sort it out. Happy New Year Andy Please feel free to review / rate our software
	« Topic »