Magento 2.2.1 Unable to save shipping information. Please check input data
I'd say that it's exporting but to the same directory and then overwriting or tripping up on the first iteration of listdir
.. best to do all of it in one pass of listdir
:
import arcpy, os
arcpy.CheckOutExtension('Spatial')
arcpy.env.overwriteOutput = True
arcpy.env.qualifiedFieldNames = False
folders=r'E:\Sheyenne\Landsat_8\spatial'
out=r'E:\Sheyenne\Landsat_8\just_field_cells'
for folder in os.listdir(folders):
if os.path.isdir(os.path.join(folders,folder)): # only folders (directories) in folders
outDir = os.path.join(out,folder) # keep track of where it's going
os.makedirs(outDir) # doesn't matter if it does or doesn't exist, make sure it's there
arcpy.env.workspace=os.path.join(folders,folder)
arcpy.AddMessage("Workspace is {0}, exporting to {1}".format(arcpy.env.workspace,outDir)) # follow the changing workspace
shapefiles=arcpy.ListFeatureClasses('*.shp')
for shape in shapefiles:
name=shape[:-4]
arcpy.AddMessage("Shapefile {0}".format(shape))
arcpy.MakeFeatureLayer_management(shape, "lyr")
arcpy.SelectLayerByAttribute_management ("lyr", "NEW_Selection", "FID_ in (233,604,887,959,1686,1731,1753,1798,2058)")
arcpy.FeatureClassToFeatureClass_conversion("lyr", outDir, name)
When you use os.listdir() it will return all files and folders in the given path, your use of os.path.isdir() is incorrect and should be done like:
if os.path.exists(path):
if os.path.isdir(path):
First for checking if something exists and then finding out if the existing object is a folder, not for checking if a folder (path) exists.
No! Service Workers also run in origin context, just as normal JavaScript. So, for a Service Worker registered for a domain cannot really interact with Service Worker registered for another domain. Furthermore, they do not have access to the DOM, unlike JavaScript.
And, as long as you visit a site, it doesn’t need SW to track your activities within that site (compared to your Threat Model). So, it really provides no advantages over tracking.
And about open question, it does no harm simply registering a SW as it has tremendous impact over performance and such. They do restrict it to HTTPS to avoid SW registered over MITM attacks, and as already mentioned in the comment, SW are disabled in Incognito mode.
For your example, all you want is
SELECT
min(pk),
id,
array_agg(value ORDER BY value)
FROM foo
GROUP BY id;
min | id | array_agg
------+-----+------------------
pk1 | id1 | {A1,A2,A3,A4,A5}
pk10 | id2 | {B1,B2,B3,B4,B5}
(2 rows)
If you need the array_agg
to be unwrapped, you can do,
SELECT pk, id, a[1] AS v1, a[2] AS v2, a[3] AS v3, a[4] AS v4, a[5] AS v5
FROM (
SELECT
min(pk),
id,
array_agg(value ORDER BY value)
FROM foo
GROUP BY id
) AS t(pk, id, a);
pk | id | v1 | v2 | v3 | v4 | v5
------+-----+----+----+----+----+----
pk1 | id1 | A1 | A2 | A3 | A4 | A5
pk10 | id2 | B1 | B2 | B3 | B4 | B5
Note, in all future examples please don't use id1
and pk1
. You're sample values should preferably be just 1
and 2
. As you can see here, we're struggling with getting pk10
instead of pk6
and that's a problem only because of the sort order.