Import add on Excel XLST

Closed

Pre purchase question Updated 1 year ago 17 Replies

ED
Edwin asked 1 year ago on August 11, 2023 at 10:01 pm

We use Importer Pro. But we wanted to try the Add on EXcel XLST. I istall it, activate it, but you can’t select XLST files. an xlst file is still an invaid file.

What should I do to activate it more? it is an activated plugin though…   

Jump to latest response Sign in to Reply
J

James replied Support Agent

1 year ago on August 12, 2023 at 9:31 am

Hi Edwim,

Are you able to attach the xlst file to this ticket.

Looking at the xlst format, it says xlst is used to transform xml into html and other formats, if you have access to the xml file that it transforms this would be better to import.

James

ED

Edwin replied privately

1 year ago on August 16, 2023 at 1:00 pm

J

James replied Support Agent

1 year ago on August 16, 2023 at 1:38 pm

Thanks, i was a little confused by your mention of xlst.

can you confirm that you have the addon installed and activated: https://www.importwp.com/integrations/microsoft-xlsx-file-reader/

ED

Edwin replied

1 year ago on August 16, 2023 at 2:45 pm

O Yes! I did.

J

James replied Support Agent

1 year ago on August 17, 2023 at 8:44 pm

Hi Edwin,

Can you try installing and activating the attached version.

James

Attachments

ED

Edwin replied

1 year ago on August 17, 2023 at 10:16 pm

This helped a lot. the file is recognized and is readable. 

but dates are not wel converted to readable formates, see image

Attachments

J

James replied Support Agent

1 year ago on August 19, 2023 at 3:37 pm

I have tried the library that the plugin uses to convert the xlsx to csv and the dates are read as those strange numbers.

I wouild recommend instead exporting directly to csv from the xlsx editor that your use to make sure the data is in a readable format.

ﾃL

ﾃ］gel replied

1 year ago on November 30, 2023 at 9:18 am

Hello James,I have downloaded the add-in and activated, but when I give it to import a remote URL in Excel format, I only see the XML and CSV options. Should XLS also appear here?I look forward to your clarification. Thank you. 

Attachments

J

James replied Support Agent

1 year ago on November 30, 2023 at 9:34 am

Choose CSV

ﾃL

ﾃ］gel replied

1 year ago on November 30, 2023 at 9:41 am

Hi James,

I have tried, but this is what I find.

Do I have to change any options?

I look forward to your reply. Thank you.

 

Attachments

J

James replied Support Agent

1 year ago on November 30, 2023 at 9:43 am

The file format you have is xls , are you able to get it in xlsx instead?

ﾃL

ﾃ］gel replied

1 year ago on November 30, 2023 at 9:45 am

Hi James,No, I can't, it's a file from one of my suppliers, and they can't change it for me alone.Is there no other option?
J

James replied Support Agent

1 year ago on November 30, 2023 at 9:47 am

Let me have a look and see what is possible to support xls files, can you provide me with your servers php version.

ﾃL

ﾃ］gel replied

1 year ago on November 30, 2023 at 9:52 am

Hi James,

PHP 7.4.1

Thanks

 
J

James replied Support Agent

1 year ago on November 30, 2023 at 12:53 pm

Can you try the following attached version

Attachments

ﾃL

ﾃ］gel replied

1 year ago on November 30, 2023 at 4:51 pm

Hi James,

Yes, this work nice!. Will I be able to update the plugin?

Thanks a million for the solution.

Yours sincerely,

Angel.

J

James replied Support Agent

1 year ago on November 30, 2023 at 6:20 pm

Hi Ángel,

Both the xlsx and woocommerce addons have been updated to include the latest changes, and should be able to be updated going forward.

James