Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Database/World Building

Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc.

Reply
 
Thread Tools Display Modes
  #1  
Old 02-17-2019, 06:50 PM
calasoren
Fire Beetle
 
Join Date: Oct 2008
Location: alberta
Posts: 23
Default HeidiSQL export and import csv issue

Hi Everyone,

I am hoping someone can assist with this, I am trying to export the merchantlist to a file *currently I have been attempting an Export grid rows with delimited text* Example of first 2 lines below

merchantid;slot;item;faction_required;level_requir ed;alt_currency_cost;classes_required;probability
27;1;50011;-100;0;0;65535;100

After this I add my addition lines with the same format and attempt to do an import CSV file back to the table with a replace (duplicates). I have attempted many adjustments to the settings between the export and import with no luck. Below is an error that I am seeing.

LOAD DATA LOW_PRIORITY LOCAL INFILE 'C:\\Users\\Andrew\\Desktop\\Merchantlistlatest.cs v' REPLACE INTO TABLE `peq`.`merchantlist` FIELDS TERMINATED BY ' ;' ESCAPED BY '"' LINES TERMINATED BY '\r\n' IGNORE 1 LINES (`merchantid`, `slot`, `item`, `faction_required`, `level_required`, `alt_currency_cost`, `classes_required`, `probability`);
/* SQL Error (1265): Data truncated for column 'merchantid' at row 1 */


I apologize for the question but I am very new to trying to read the error being produced and cant seem to come up with the possible issue. Is anyone able to recognize the issue or do you have a better method of me adding larger amounts of database table entries quickly?

Thanks so much for your assistance
Reply With Quote
  #2  
Old 02-17-2019, 11:46 PM
superpally1
Sarnak
 
Join Date: Jul 2018
Location: Tennessee
Posts: 33
Default

Maybe heidi is having issues with the .csv format.
I always export with the .sql extension without issue.
One of these links can help convert your file.

http://convertcsv.com/csv-to-sql.htm


or

https://sqlizer.io/#/
Reply With Quote
  #3  
Old 02-18-2019, 12:37 AM
Uleat's Avatar
Uleat
Developer
 
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
Default

I see semi-colons..are you importing with the correct delimiter?
__________________
Uleat of Bertoxxulous

Compilin' Dirty
Reply With Quote
  #4  
Old 02-18-2019, 03:46 AM
calasoren
Fire Beetle
 
Join Date: Oct 2008
Location: alberta
Posts: 23
Default

Thanks Guys, Yes I had tried adjusting delimiters but was not having any luck.

Super Pally I think I can make that do the trick, I have a little learning to do with the csv to sql converter tool but atleast in a new table it looks like I can process the whole thing with no issues from what I can tell. If I can figure out how to merge instead of creating a whole new table which I am sure I can that should do even speed me up more.

Thanks again this will be a huge help
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 02:59 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3