5 replies [Last post]
Kevstar
Kevstar's picture
Offline
Enthusiast
England
Last seen: 4 years 4 weeks ago
England
Timezone: GMT+1
Joined: 2012-07-20
Posts: 81
Points: 107

hi all.

I currently receive my CSV files from a third party provider with all listings from there site within it.

now they have there tabs as this.

***program_name merchant_id code description url start_date end_date region Date_Added***

but my site only allows me to upload these files as the following as the above will not work.

***SKU tagline post_author post_date post_content post_title post_excerpt post_type code Date_Added category description email end_date expires featured hits image images link merchant_id no_votes packageID package_access pexpires program_name region starts start_date style tagline type url yes_votes store ***

is there a program or a tool within excel that will automatically rename the files and add new ones to save me the time on editing them. as I have over 400 items it becomes very time consuming.

please can someone point me in the right direction? thanks.

Tags:
gary.turner
gary.turner's picture
Offline
Moderator
Dallas
Last seen: 21 hours 38 min ago
Dallas
Timezone: GMT-5
Joined: 2004-06-25
Posts: 9742
Points: 3821

what's (not) my line

It would have been nice of you to have used delimiters for those column headings. If I read it right, you have a potload more fields than your supplied data support.

Keep in mind that I may be talking through my hat here.

Set up a spreadsheet with headings that match the data. Now rename the appropriate headings to match what you already have set up. Now, insert new columns and headings to match existing fields, and re-order the columns to match your required fields. You should now have everything in order, and the additional fields will be empty.

Now export your spreadsheet to CSV. It should be ready to use. Data will match the existing fields, including those fields that are NULL. Empty fields will be represented by ,,

It was easier to see the process in my head than to put it to words.

cheers,

gary

If your web page is as clever as you can make it, it's probably too clever for you to debug or maintain.

Kevstar
Kevstar's picture
Offline
Enthusiast
England
Last seen: 4 years 4 weeks ago
England
Timezone: GMT+1
Joined: 2012-07-20
Posts: 81
Points: 107

hi thanks

thanks for this!

So is there no program that you know of that will re order this for me.

this does seem easy but when it comes to re editing it, it simply is not.

thanks,

gary.turner
gary.turner's picture
Offline
Moderator
Dallas
Last seen: 21 hours 38 min ago
Dallas
Timezone: GMT-5
Joined: 2004-06-25
Posts: 9742
Points: 3821

Can't think of any

In fact, the spreadsheet, e.g.Excel or Calc, is likely the ideal application for this. If you don't have Excel, install OO.org or Libre Office.

  1. Open a new file, and add headings, 1,2,3,4;
  2. import the csv file;
  3. insert new columns and headings, manny, moe, and jack;
  4. move the columns into the desired order, 4,jack,3,moe,2,manny,1;
  5. export as csv, 4,,3,,2,,1

I don't know how you'd make it simpler, unless you can persuade your source to do it. Smile

cheers,

gary

If your web page is as clever as you can make it, it's probably too clever for you to debug or maintain.

Kevstar
Kevstar's picture
Offline
Enthusiast
England
Last seen: 4 years 4 weeks ago
England
Timezone: GMT+1
Joined: 2012-07-20
Posts: 81
Points: 107

now I upload my files as

now I upload my files as this:

who, title, description, link

my provider has it as this:

who, description, link

the fact that I need to go down each and every description to get a title for it is the most time consuming thing I have to do. (as there are over 400 to edit)

This is what I want making easier. If my supplier adds a description then it would be easy.

as you described above will be easy if I had all the information necessary.

thanks

gary.turner
gary.turner's picture
Offline
Moderator
Dallas
Last seen: 21 hours 38 min ago
Dallas
Timezone: GMT-5
Joined: 2004-06-25
Posts: 9742
Points: 3821

Bummer

If the client has provided the incomplete content, either himself or by contracted source, you should reject it and insist on properly formatted and complete data. Explain that if you must re-create the data, it will add several hours additional billing for the site. Explain also that the delay on his part or the additional hours work on your part may result in your having to put his site on hold to take care of already scheduled work on other sites.

There is one terrible alternative: you contracted the source and provided the wrong specs. Well, then you just have to suck it up and either fix it yourself or pay your sub to fix it. If your specs are OK, he'll have to fix it or not get paid.

Sorry about that,

gary

If your web page is as clever as you can make it, it's probably too clever for you to debug or maintain.