Help Creating Formatted CSV Files For Use

[DetectorX]

Is there any way, anyone could provide a bullshit csv formatted in a way that can be used properly by plugin?

I know shit about this end of things and it would be of great help....

Thanks dX

[DetectorX]

Ok, so each complete post is plsced in one cell! just seperate title, body and so on with commas.

I was creating headers for each post element in row 1, then placing susiquent text under each post header created in row one. Which worked, but when proccessed I was getting double posts of each post.

still a formatted .cvs example file would be nice, if possible.

Thanks for the reply

dX

[nickmattern]

Ok, so each complete post is plsced in one cell! just seperate title, body and so on with commas.

I was creating headers for each post element in row 1, then placing susiquent text under each post header created in row one. Which worked, but when proccessed I was getting double posts of each post.

still a formatted .cvs example file would be nice, if possible.

Thanks for the reply

dX


Any properly formatted CSV (Comma separated values) file can be used.

Check here for a description of how CSV files work: http://en.wikipedia.org/wiki/Comma-separated_values

[DetectorX]

Here is a good example of some csv that wont work.


"Metal Detector","Description / Specifications","Price Range","Detector Use"
"Minelab Quattro MP","“Most metal detectors on the market operate on a single (or dual) frequency, ranging from 1 to 70 kilohertz (kHz). Although this technology has served the industry well for years, Minelab's scientists found that a frequency that worked well in one area would often offer only marginal performance when used in another location. One detector specialized to find your treasures. Powered by Minelab's ultimate FBS multiple frequency technology, this is the detector for anyone who wants simplicity and performance! Ready for parks, beaches or the battlefields. Only Minelab's FBS technology metal detectors will provide outstanding performance even on saltwater beaches!”","Suggested Retail: $1075.00
","“All Purpose: Coin, Jewelry, Relic, Beach”"


This imports one post, up tp suggested retail : $1075.00. The description is not imported or displayed nor anything else. I am formatiing this wrong?

I formatted in Excel, then saved in text so you could see, but each area of post hasb its own column, with header. Detector Name , Description ans so on and on row two under each according header is appropriate content.

I read and followed documentationn online. Hope you can help.

dX

[nickmattern]

Here is a good example of some csv that wont work.

dX

The CSV above is malformed.

Throw your raw data in Excel, get rid of the quotes in the 2nd and 4th columns, then save it in Excel as CSV, let Excel do the formatting. Should work. (In my example below, I simply copy/pasted your data in Notepad, saved, brought it up in Excel (Data > Import External Data > Text), removed the quotes, then saved the file as CSV and imported. I forgot to remove quotes from the 4th column, but you get the idea.)

http://carebrite.com/?p=2235

[DetectorX]

Thank you much will give er a run...

[medicalhumor]

and make sure that the first row contains the field names:

"Name","address","city","state";

[DetectorX]

Works like a charm, thank you