Location data being lost when importing items into ITDB

[computerman-13]

I noticed an issue when importing data into the database using the import function.
When I attempt to import a file, the location information is populated pre import check, but once the data is imported and I list the items, the location field is blank. Additionally, if there is information in the area field in the csv file, that is entered into the database.

[kalanUM]

Hi computerman-13, Check out the file import.php - find "INSERT into items" query, change this:

           //'locationid'=>$locationid,
           'locationid'=>$locid,

Or find the two "$locid" vars and change them to $locationid (note, don't change the 'locid' array tags):

    $lr=getlocidsbynames($cols[$name2fno['location']],$cols[$name2fno['area']]);
    if ($lr[0]<0) {
        echo "Location/locarea non existent: {$cols[$name2fno['location']]}/{$cols[$name2fno['area']]}<br>";
        $locid="";
        $locareaid="";
    }
    else {
        $locid=$lr['locid'];
        $locareaid=$lr['locareaid'];
    }

• K

[computerman-13]

I first tried the first change changing 'locationid'=>$locid, which I saw a few days ago in your othe post, but that did not correct the issue.
I also tried changing $lr=getlocidsbynames($cols[$name2fno['location']],$cols[$name2fno['area']]); if ($lr[0]<0) { echo "Location/locarea non existent: {$cols[$name2fno['location']]}/{$cols[$name2fno['area']]}
"; $locid=""; $locareaid=""; } else { $locid=$lr['locid']; $locareaid=$lr['locareaid']; }

to $locationid but that did not work either.

[computerman-13]

I just did some additional testing. I found that If I put in an area as well as the location, then the location is imported into the database correctly. If there is only a location in the itdb database, then the information isn't imported because it appears to be referencing the locareaid table. I looked at the table and nothing is created in the table unless an area is filled in for each location.

[nikband]

Location (example London with floor 1,2,3 have different locationid) have problem with actual import procedure.

I try to solve this in my fork but I not able to fix... @sivann can you help with this location-floor-area import problem?

info: There is a check if SN is present into items? for skip just imported items or done an UPDATE (i prefer a skip)