Last post 41 min ago

Posts last week 141

Average response time last week 4 hours 42 min

All time posts 67778

All time tickets 10473

All time avg. posts per day 21

Helpdesk is open from Monday through Friday CET

Please create an (free) account to post any question in the support area.

Please check the development versions area. Look at the changelog, maybe your specific problem has been resolved already!

All tickets are private and they cannot be viewed by anyone. We have made public only a few tickets that we found helpful, after removing private information from them.

#5630 – Import from CSV or TXT

Posted in ‘sh404SEF’

This is a public ticket. Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Tuesday, 26 February 2019 19:03 UTC

mark.l

Trying and failing to import URL metadata from spreadsheet application. The import is unforgiving. Saving as a TXT or CSV fails. It seems like the TXT will work on one and only one condition: every single piece of data is surrounded in double quotes. I have tried 4 different spreadsheet applications (Excel, Google Sheets, Apple Numbers, and LibreOffice). Not a single one exports TXT or CSV with double quotes on every field. Of course, they all use double quotes on text. But even when I convert all the cells to text format, the apps remove double quotes.

So my question is, how exactly are users of sh404sef supposed to manage urls and metadata in a spreadsheet application and then import that into sh404sef. I am clearly doing something wrong, but I have no idea how to make it work.

Thanks for any guidance.

Wednesday, 27 February 2019 12:17 UTC

wb_weeblr

Hi

I used to use OpenOffice for that and also a small utillity called CSVFileView (from here). It will load your existing CSV file and then you can resave it under a suitable format.

First load your file, then select all the lines you want to export then select File -> Save Selected elements and choose "Custom delimited file" as the file type.

I agree this is cumbersome, I have added a tracker item to try revisit this. The matter is actually a bit complex because there's no such thing as a standard format for CSV. EXcel for instance will use a different delimite (, or ; usually) depending on the country you are in and there's no easy way to change that.

Best regards

Thursday, 14 March 2019 05:34 UTC

system

This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.

This ticket is closed, therefore read-only. You can no longer reply to it. If you need to provide more information, please open a new ticket and mention this ticket's number.