CLI Import from CSV


#1

Hi,

I am just after some help in using the SquidEx CLI to import some data from a CSV File.

I have setup the configuration to talk to SquidEx Cloud.

I have created a simple Schema with 3 fields (DealerName, DealerCode, State).

I have a CSV File with 3 columns (DealerName, DealerCode, State).

I’m trying to use

sq.exe content import dealers dealerlist2.csv --fields=DealerName,DealerCode,State

But all I get are blank entries in SquidEx.

I’m assuming I’m not doing something right with the Field Definition - any help or guidance would be greatly appreciated!

Thanks

Chris


#2

Looks good I think. Would you send me your CSV file so that I can test it?


#3

Thanks Sebastian, Sample CSV link below

http://s000.tinyupload.com/index.php?file_id=95870795135904682914


#4

In the Schema I have DealerCode set as an Integer (all other values are strings) - could that be impacting anything?


#5

I will find out, whats going on


#6

Hi, you have used the wrong delimiter (there is an option for that), but I have also pushed a new version with a fix and an error if a field cannot be found.


#7

Thanks Sebastian, I downloaded the new release (1.6) and added

–delimiter=,

All working - thanks for your help!

Chris