Bulk language import error

I am trying to do a bulk Spanish import with the attached import worksheet.
I keep getting an error that says “500 - Sorry, something unexpected just
went wrong, and we’re very sorry about it.” Any ideas what the error is?
We have Spanish set up as a second language, have not made any changes to
the application either. Thanks

USBP WE Baseline Translation-3-28-16.xlsx (28.5 KB)

Hi Jason,

Try removing all of the formatting in each tab in your excel document
(highlights, text color, content alignment, etc) to make everything
uniform, save and attempt the upload again. Give us an update on if this
resolves the issue!

Best,

Lauren

Lauren N. Fox
Dimagi, Inc.
Maputo, Mozambique

Moz: +258 82 78 49 245
dimagi.com http://www.dimagi.com/ *| *commcarehq.org

··· On Wed, Mar 30, 2016 at 12:56 AM, Jason wrote:

I am trying to do a bulk Spanish import with the attached import
worksheet. I keep getting an error that says “500 - Sorry, something
unexpected just went wrong, and we’re very sorry about it.” Any ideas what
the error is? We have Spanish set up as a second language, have not made
any changes to the application either. Thanks


You received this message because you are subscribed to the Google Groups
"commcare-users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

I removed all of the formatting and now I get the following error. App
Translation Failed! Please make sure you are using a valid Excel 2007 or
later (.xlsx) file. Error details: “There is no item named
‘xl/workbook.xml’ in the archive”.

Attached is the updated import worksheet. Any ideas?

USBP WE Baseline translation import 3.30.16.xlsx (27 KB)

··· On Wednesday, March 30, 2016 at 1:15:44 AM UTC-7, Lauren Fox wrote: > > Hi Jason, > > Try removing all of the formatting in each tab in your excel document > (highlights, text color, content alignment, etc) to make everything > uniform, save and attempt the upload again. Give us an update on if this > resolves the issue! > > Best, > > Lauren > > *Lauren N. Fox* > Dimagi, Inc. > Maputo, Mozambique > > Moz: +258 82 78 49 245 > dimagi.com *| *commcarehq.org > > On Wed, Mar 30, 2016 at 12:56 AM, Jason <jru...@gmail.com > wrote: > >> I am trying to do a bulk Spanish import with the attached import >> worksheet. I keep getting an error that says "500 - Sorry, something >> unexpected just went wrong, and we're very sorry about it." Any ideas what >> the error is? We have Spanish set up as a second language, have not made >> any changes to the application either. Thanks >> >> -- >> You received this message because you are subscribed to the Google Groups >> "commcare-users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to commcare-user...@googlegroups.com . >> For more options, visit https://groups.google.com/d/optout. >> > >

​Hi Jason,

Are you using an older version of Excel? I would try uploading with an
Excel 2007 or higher workbook and seeing if that solves the issue.

Best,
Robin Selwitz

··· On Wed, Mar 30, 2016 at 11:39 AM, Jason wrote:

I removed all of the formatting and now I get the following error. App
Translation Failed! Please make sure you are using a valid Excel 2007 or
later (.xlsx) file. Error details: “There is no item named
’xl/workbook.xml’ in the archive”.

Attached is the updated import worksheet. Any ideas?

On Wednesday, March 30, 2016 at 1:15:44 AM UTC-7, Lauren Fox wrote:

Hi Jason,

Try removing all of the formatting in each tab in your excel document
(highlights, text color, content alignment, etc) to make everything
uniform, save and attempt the upload again. Give us an update on if this
resolves the issue!

Best,

Lauren

Lauren N. Fox
Dimagi, Inc.
Maputo, Mozambique

Moz: +258 82 78 49 245
dimagi.com http://www.dimagi.com/ *| *commcarehq.org

On Wed, Mar 30, 2016 at 12:56 AM, Jason jru...@gmail.com wrote:

I am trying to do a bulk Spanish import with the attached import
worksheet. I keep getting an error that says “500 - Sorry, something
unexpected just went wrong, and we’re very sorry about it.” Any ideas what
the error is? We have Spanish set up as a second language, have not made
any changes to the application either. Thanks


You received this message because you are subscribed to the Google
Groups “commcare-users” group.
To unsubscribe from this group and stop receiving emails from it, send
an email to commcare-user...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


You received this message because you are subscribed to the Google Groups
"commcare-users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

I am not sure how that worked but it did. I resaved the .xlsx file as
another .xlsx file and it worked. Case closed.

··· On Wednesday, March 30, 2016 at 8:59:55 AM UTC-7, rselwitz wrote: > > ​Hi Jason, > > Are you using an older version of Excel? I would try uploading with an > Excel 2007 or higher workbook and seeing if that solves the issue. > > Best, > Robin Selwitz > > On Wed, Mar 30, 2016 at 11:39 AM, Jason <jru...@gmail.com > wrote: > >> I removed all of the formatting and now I get the following error. App >> Translation Failed! Please make sure you are using a valid Excel 2007 or >> later (.xlsx) file. Error details: "There is no item named >> 'xl/workbook.xml' in the archive". >> >> Attached is the updated import worksheet. Any ideas? >> >> On Wednesday, March 30, 2016 at 1:15:44 AM UTC-7, Lauren Fox wrote: >>> >>> Hi Jason, >>> >>> Try removing all of the formatting in each tab in your excel document >>> (highlights, text color, content alignment, etc) to make everything >>> uniform, save and attempt the upload again. Give us an update on if this >>> resolves the issue! >>> >>> Best, >>> >>> Lauren >>> >>> *Lauren N. Fox* >>> Dimagi, Inc. >>> Maputo, Mozambique >>> >>> Moz: +258 82 78 49 245 >>> dimagi.com *| *commcarehq.org >>> >>> On Wed, Mar 30, 2016 at 12:56 AM, Jason wrote: >>> >>>> I am trying to do a bulk Spanish import with the attached import >>>> worksheet. I keep getting an error that says "500 - Sorry, something >>>> unexpected just went wrong, and we're very sorry about it." Any ideas what >>>> the error is? We have Spanish set up as a second language, have not made >>>> any changes to the application either. Thanks >>>> >>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "commcare-users" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to commcare-user...@googlegroups.com. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> -- >> You received this message because you are subscribed to the Google Groups >> "commcare-users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to commcare-user...@googlegroups.com . >> For more options, visit https://groups.google.com/d/optout. >> > >