WordPress.org

Ready to get started?Download WordPress

Forums

Supra CSV
[resolved] Importing tab-delimited files (7 posts)

  1. titush
    Member
    Posted 1 year ago #

    Hi there,

    I have a problem, in that my CSV file is actually a tab-delimited file, as the text contains multiple-line text with commas.

    Another problem I have is that I use the plugin "Types" to manage my custom post types, however it creates it's data in an own table of the db, so post_meta won't work. I'll tackle this once I get my data into WordPress first, though.

    Could you let me know what the CORRECT syntax of the CSV file should be?

    Thanks, Titus

    http://wordpress.org/extend/plugins/supra-csv-parser/

  2. titush
    Member
    Posted 1 year ago #

    sorted it out, just used the default MS Excel CSV format.
    However, while the import is saying "Successfully imported...", the only thing imported is the post title, everything else is empty (I have a lot of custom fields...).

    What could this be?
    Thanks!

  3. Joseph Persie
    Member
    Plugin Author

    Posted 1 year ago #

    limit the record count in your csv file to two or three toggle the debug ingestion mode and paste the ouput here. but the likely cause is due to the fact postmeta is stored in its own table and not using the wordpress convention. an edit like this would entail adding the functionionality to the xmlrpc api
    secondly i will have the ability to designate seperators, delimiters and encoding in a future version

  4. Joseph Persie
    Member
    Plugin Author

    Posted 1 year ago #

    update your plugin to the latest version as it now has option to designate delimiter, enclosure and escape characters

  5. titush
    Member
    Posted 1 year ago #

    O.k., so here is what I did. First of all thanks for the plugin update, I did the update as requested.

    Below is the text that I am importing, as you can see it is comma separated, with quotation marks as enclosure.

    Aruba”,”Central America”,”"107,635 (July 2012 est.)"“,”Oranjestad”,”"Caribbean, island in the Caribbean Sea, north of Venezuela"“,”tropical marine; little seasonal temperature variation”,”flat with a few hills; scant vegetation”,”"a flat, riverless island renowned for its white sand beaches; its tropical climate is moderated by constant trade winds from the Atlantic Ocean; the temperature is almost constant at about 27 degrees Celsius (81 degrees Fahrenheit)"“,”"Discovered and claimed for Spain in 1499, Aruba was acquired by the Dutch in 1636. The island's economy has been dominated by three main industries. A 19th century gold rush was followed by prosperity brought on by the opening in 1924 of an oil refinery. The last decades of the 20th century saw a boom in the tourism industry. Aruba seceded from the Netherlands Antilles in 1986 and became a separate, autonomous member of the Kingdom of the Netherlands. Movement toward full independence was halted at Aruba's request in 1990."“,”"Papiamento (a Spanish-Portuguese-Dutch-English dialect) 66.3%, Spanish 12.6%, English (widely spoken) 7.7%, Dutch (official) 5.8%, other 2.2%, unspecified or unknown 5.3% (2000 census)"“,”"Roman Catholic 80.8%, Protestant 7.8% (Evangelist 4.1%, Methodist 1.2%, other Protestant 2.5%), Jehovah's Witnesses 1.5%, Jewish 0.2%, other 5.1%, none or unspecified 4.6%"“,”parliamentary democracy”,”"Flag Day, 18 March (1976)"“,”"blue, with two narrow, horizontal, yellow stripes across the lower portion and a red, four-pointed star outlined in white in the upper hoist-side corner; the star represents Aruba and its red soil and white beaches, its four points the four major languages (Papiamento, Dutch, Spanish, English) as well as the four points of a compass, to indicate that its inhabitants come from all over the world; the blue symbolizes Caribbean waters and skies; the stripes represent the island's two main ""industries"": the flow of tourists to the sun-drenched beaches and the flow of minerals from the earth"“,”Tourism and offshore banking are the mainstays of the small open Aruban economy. Oil refining and storage ended in 2009. The rapid growth of the tourism sector over the last decade has resulted in a substantial expansion of other activities. Over 1.5 million tourists per year visit Aruba with 75% of those from the US. Construction continues to boom with hotel capacity five times the 1985 level. Tourist arrivals rebounded strongly following a dip after the 11 September 2001 attacks. The government has made cutting the budget and trade deficits a high priority.”,”"tourism, transshipment facilities, banking"

    Now, in Supra CSV Configuration he DOES actually show me the custom post type "country" (I was mistaken earlier, it IS in the post_meta table).

    I selected

    Supra CSV Configuration
    =======================

    USERNAME / PASSWORD OF AUTHOR USER

    (X) DEBUG INGESTION
    (X) REPORT ISSUES
    POST TYPE: country (from pulldown)

    DELIMITER: ,
    ENCLOSURE: "
    ESCAPE \

    DEFAULT TITLE: none
    DEFAULT DESCRIPTION: none

    => UPDATE OPTIONS

    UPLOAD
    ======
    I upload the text file with 3 records. No issues. Successful upload is confirmed.

    POST INFO
    =========

    Now this is strange: as opposed to your video tutorial, the fields for mapping do not appear. All I see is:

    Post Meta Suggestions for Post Type 'country'
    meta key random value

    What I did is to create the mapping manually, regardless of that issue. However I do feel that the problem lies here, as I can manage to import the posts, however none of my custom fields are populated during the import, so I guess the mapping doesn't work. What do you think?

    INGESTION
    =========
    Previously, this actually allowed me to map the fields and conduct the import. Now it's empty and I can't select any option from the mapping presets and the only field (again I can't select anything) is "Title", with an empty pulldown menu.

    Any idea what could be the issue?

    Thanks so much for your help, your plugin looks like it's very well designed and I'd love to use it..

    Just fyi, I uus the latest WP 3.4.1 on a dedicated server with PHP 5.2.6 and have full control over php execution time, upload limits etc, which are all set to very high values for testing purposes.

    Thanks!
    T.

  6. Joseph Persie
    Member
    Plugin Author

    Posted 1 year ago #

    the commas need to be escaped with : / Papiamento (a Spanish-Portuguese-Dutch-English dialect) 66.3%, Spanish 12.6%, English (widely spoken) 7.7%, Dutch (official) 5.8%, other 2.2%, unspecified or unknown 5.3% (2000 census). Also as discussed beofre post type table must store post_meta for the post_info to parse correctly. I could further trouble shoot the issue but i would need development access. Dont hesitate to provide a link to the csv file as well.

  7. titush
    Member
    Posted 1 year ago #

    O.k., I figured Excel wasn't saving the CSV conform with standards...

    Can I PM or email this to you? My email is titus X hanke Y gmail.com
    The X is dot, the y the @.

    Thanks!

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags