item selection by using import or copy and past into app

[Anonymous]

Hey Experts 

I made a QV App which is showing our inventories.

As our external partners are sending list with item numbers per mail or by attaching a excel spread sheet, to request our current stock situation, it would be great if i could add something like a import function to my app. it would safe a lot of time, if not every item has to be entered one by one.

Whats the best way to get the function to the App?

Thanks

[miguelbraga]

If the excel files have the same name structure and have the same fields in every mail that you receive, then you can put those files in one folder and within the Reload, you can make a for each loop to read every excel file

[miguelbraga]

Something like this:

FOR EACH Filein FileList('youPathToFolder\excel structure *.xlsx')

  NewData:

  LOAD *

  FROM

  $(File)

  (ooxml, embedded labels, table is [sameSheetInExcelFiles]);

NEXT File

Make a variable with the name File and put the first path to the first excel file received by e-mail.

This sould work for you!

Regards,

MB

[Anonymous]

First of all sorry for my poor explenation in the previous post.

My idea was more to simplyfie the app to endusers, by adding a button (upload item) . By pushing on the button, it will open the folder and you can select the excel for upload, which you previously save on that location. The excel would include just a single column with the item no. This would be very user friendly. But im not sure whether is possible.

Even better it would be if there is a way just to copy a list (column) of item no. from Excel and just past in qlikview to get the details about the wished items... Do you know whether this is possible? It would be a great help.

Many thanks

[Anonymous]

Can anybody help on this?

would be great

Many thanks

[Anonymous · Accepted solution]

Herewith the solution i found as turn around

using this syntax: „(Item1|Item2|Item3|...)“ in the list box of the item

This string can be generated in excel by using this formula, it is not very user friendly but it works

Much better solution could be to generate something like a input box in QV, where the item can be listed and QV would generate the needed string and perform a selection by clicking one button.

For now i will add the Excel solution as correct.

Many thanks