ANYONE EXPORTING THERE .CSV FILE FROM...

User 103173 Photo


VP of Software Development
0 posts

That .csv also opened just fine for me. I had to edit it in Excel again to remove the images, but it imported just fine.
Attachments:
Learn the essentials with these quick tips for Responsive Site Designer, Responsive Email Designer, Foundation Framer, and the new Bootstrap Builder. You'll be making awesome, code-free responsive websites and newsletters like a boss.
User 447551 Photo


Ambassador
139 posts


Here is the way I've overcome that problem in the past

Click the Windows Start menu.
Open Control Panel.
Open the Regional and Language Options dialog box.
Click the Customize this Format (I think it's Regional settings in Windows 98 if anyone still has this)
Open it and scroll down to List separator
Type a new separator in the List separator box. (Replace , with ","
Click OK twice.
Good to go

This is a universal change and will be reflected in any and everything you export so you might want to go back and change it back again when you've completed your export.

I had to reteach myself this several times as I never used it that often and forgot how to do it between times. I'd suggest you do it a few times to give the smart brain in your mouse hand a chance to learn and retain it.

Good Luck and I really hope this works as I'm going to need it too myself in a couple of days.
User 2118376 Photo


Registered User
43 posts

Scott what version of excell are you using maybe this is my problem because I could import your file but as soon as I made a change and saved it I get the column errors:

Column 16 not valid.
Reason: This field is a different size than the header.

Column 17 not valid.
Reason: This field is a different size than the header.

Column 18 not valid.
Reason: This field is a different size than the header.

Column 19 not valid.
Reason: This field is a different size than the header.

The only change I made to it was changed New Tires1 to Riken



Dave
User 103173 Photo


VP of Software Development
0 posts

I have used Numbers, Excel 2008 and 2010 as well as Google Documents. All seem to work for me.
Learn the essentials with these quick tips for Responsive Site Designer, Responsive Email Designer, Foundation Framer, and the new Bootstrap Builder. You'll be making awesome, code-free responsive websites and newsletters like a boss.
User 289442 Photo


Registered User
161 posts

Scott Swedorski wrote:
I have used Numbers, Excel 2008 and 2010 as well as Google Documents. All seem to work for me.


You can add Open Office 3 as well, opens the files without problem.
User 103173 Photo


VP of Software Development
0 posts

Any luck David getting your csv file to work?
Learn the essentials with these quick tips for Responsive Site Designer, Responsive Email Designer, Foundation Framer, and the new Bootstrap Builder. You'll be making awesome, code-free responsive websites and newsletters like a boss.
User 2118376 Photo


Registered User
43 posts

No I am still getting the:

Column 16 not valid.
Reason: This field is a different size than the header.

Column 17 not valid.
Reason: This field is a different size than the header.

Column 18 not valid.
Reason: This field is a different size than the header.

Column 19 not valid.
Reason: This field is a different size than the header.

Errors importing the attached file... What exactly does this error mean? "This field is a different size than the header.
"

Dave
Attachments:
User 103173 Photo


VP of Software Development
0 posts

You need a new hobby David. ;)

The CSV file worked fine for me. No errors at all. I did have to update it again to remove the image references so I could import it.

Attached is the updated one.
Attachments:
Learn the essentials with these quick tips for Responsive Site Designer, Responsive Email Designer, Foundation Framer, and the new Bootstrap Builder. You'll be making awesome, code-free responsive websites and newsletters like a boss.
User 2118376 Photo


Registered User
43 posts

Bill Dutcher wrote:

Here is the way I've overcome that problem in the past

Click the Windows Start menu.
Open Control Panel.
Open the Regional and Language Options dialog box.
Click the Customize this Format (I think it's Regional settings in Windows 98 if anyone still has this)
Open it and scroll down to List separator
Type a new separator in the List separator box. (Replace , with ","
Click OK twice.
Good to go

This is a universal change and will be reflected in any and everything you export so you might want to go back and change it back again when you've completed your export.

I had to reteach myself this several times as I never used it that often and forgot how to do it between times. I'd suggest you do it a few times to give the smart brain in your mouse hand a chance to learn and retain it.

Good Luck and I really hope this works as I'm going to need it too myself in a couple of days.


Hey Bill thanks for the tip... I tried it changed it to the "," and to the Pipe Sign | and still no luck I just dont understand the error it giving me...

Column 16 not valid.
Reason: This field is a different size than the header.

Column 17 not valid.
Reason: This field is a different size than the header.

Column 18 not valid.
Reason: This field is a different size than the header.

Column 19 not valid.
Reason: This field is a different size than the header.
User 103173 Photo


VP of Software Development
0 posts

For me, using Excel, Numbers or Google Documents always creates a valid .csv file. I never had to make any of those changes suggested by Bill.

Did my fixed csv file work for ya?
Learn the essentials with these quick tips for Responsive Site Designer, Responsive Email Designer, Foundation Framer, and the new Bootstrap Builder. You'll be making awesome, code-free responsive websites and newsletters like a boss.

Have something to add? We’d love to hear it!
You must have an account to participate. Please Sign In Here, then join the conversation.