Developer forum

Forum » PIM » Simple import in PIM

Simple import in PIM

Aki Ruuskanen
Aki Ruuskanen
Reply

Hi,

I am trying to get a very simple product import from Excel to work. 

I have an Excel file with three columns. ProductLanguageID, ProductID and ProductName.

I click on the "Import products" in a product group in PIM.

I choose the Excel file and select "Excel" as "Source file type".

When clicking next I et the screen in the attached file "ExcelImport.png". It tells me to select source in the "Table / Sheet" field. But it's empty. 

What am I doing wrong?

Regards / Aki

ExcelImport.png

Replies

 
Søren Jensen Dynamicweb Employee
Søren Jensen
Reply
This post has been marked as an answer

Hi Aki,

I have just tried to import your attached Excel file "ImportTest.xlsx", on my DW9.8 solution.

It works fine for Me.

If you still have problems, please contact support

 

Best regards

Søren

 

Import_sd.png
Votes for this answer: 1
 
Aki Ruuskanen
Aki Ruuskanen
Reply

I saw now that the OLEDB drivers are not installed on the server. Got that server error when I tried to create a regular Data Integration from Excel. 

I thought that it was because first I tried to export from PIM and the import the same file and the worked just fine.

Appearently that feature does not use the OLEDB to access the Excelfile. 

/Aki

 
Aki Ruuskanen
Aki Ruuskanen
Reply

I can confirm that the problem was with the OLDDB drivers. yes

It was a very silent error though. Maybe some kind of error message would be good. 

/Aki

 

You must be logged in to post in the forum