English > Support

[FAQ] Aargh.... file path not imported

(1/4) > >>

deazo:
 Hi me again sorry for all the posts but problems are piling up...
 
 Before I describe the problem let me describe the method I am following.
 PVD won't import an XLS file for an unknow reason and would give me an error everytime I try.
 So I am using CSV import instead and it works.

 I basically create an xml exportd file from my corrupted database, convert it into a csv file, delete the columns/fields that i do not need to import in the new database.
 Then when I import the csv file in the new database, for some reason the "file path" field gets populated with the field that is just before it in the csv file!

 I even tried to create a csv file that is two columns only, ID and File path.
 When I import (after having modified the csv import to limit it to ID and Path), the File path gets populated with the ID number!!

 I'm going crazy here, the delimiter is fine, the csv import configuration corresponds to the csv file and yet it does not take the path.

 Am I missing something here?
 aaaarh I need some fresh air.

buah:
Did you properly set up Excel importing plugin?

deazo:

 I think so yes, I did choose only two fields, ID and Path.
 In my xls (or csv) I have only two column, Num and Path.
 It should work, right?

nostra:
Maybe you should quote the values...

If it does not help submit your file here and I will have a look at it.

deazo:
 OK here is the csv file I use, the xls one is identical.
 In both CSV and Excel import configuration I have only two fields, ID and Path. also I use the ; delimiter.

[attachment deleted by admin]

Navigation

[0] Message Index

[#] Next page

Go to full version