Importing fixed length text

  • hauman

    (@hauman)


    5 years, 8 months ago

    I’d like to import fixed-length text files, where each field starts and ends at the same place in every record. Is there a way to do so in WP, or do I have to covert to CSV beforehand?

    • This topic was modified 5 years, 8 months ago by Jan Dembowski.
Viewing 4 replies - 1 through 4 (of 4 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    5 years, 8 months ago

    It would depend what plugin you’re using to do the import. Typically, they want XML, XLS, or CSV.

    Thread Starter hauman

    (@hauman)

    5 years, 8 months ago

    Yes, I’m aware they normally want that. Unfortunately, that’s not how I’m getting the data.

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    5 years, 8 months ago

    So open the data with your favorites spreadsheet and save it back out as a CSV file.

    Thread Starter hauman

    (@hauman)

    5 years, 8 months ago

    It’s a bit of a pain when the file is updated regularly and has more lines than most spreadsheets are capable of handling (inventory updating, over a million SKUs).

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Importing fixed length text’ is closed to new replies.