Anyway to reduce size of pdf using python script.

2013-02-01 Thread accessnewbie
I have a batch file that exports ArcGIS pdf maps to a directory. I would like to include a step in the script where the pdf file is reduced in size instead of manually opening each file in Acrobat X Pro after the script has run and doing it there. Can this be done using python scripting or does

Merge pdf files using information from two files

2017-09-08 Thread accessnewbie
I have two files (right now they are spreadsheets but I can export them to any format). File1 has StoreID (unique) in one column and a pdf map location in the second column. (Names not really sequenced numerically) 1 C:/maps/map1.pdf 2 C:/maps/map2.pdf 3 C:/maps/map3.pdf 4 C:/m

Merging pdf files based on a value in a field

2017-09-08 Thread accessnewbie
The StoreID (unique) is in Column1, a pdf map location in Column2, and the file name is "Warehouse1" (this will vary). (names not really sequenced numerically) County1 C:/maps/map1.pdf County1 C:/maps/map2.pdf County2 C:/maps/map1.pdf County2 C:/maps/map3.pdf County3 C:/maps/

Re: Merging pdf files based on a value in a field

2017-09-15 Thread accessnewbie
Suggestions to use pyPDF2 to append files did not pan out. I had to go with the arcpy module. pyPDF2 does NOT merge correctly when trying to output multiple files based on a a similar value or key (essentially the group by concept). import csv import arcpy from arcpy import env

Grab metadata from images and save to file, batch mode

2016-04-01 Thread accessnewbie
I have a directory (and sub-directories) full of images that I want to cycle through and grab certain metadata values and save those values to a single row in a cvs file. I would like to tack on the full path name to the row as a separate value. Folder C:\Images\Family Brother.jpg Sister.jpg Mo

Looking for sample python script using Tkinter

2015-01-02 Thread accessnewbie
I have a script that I trying to go from command line entry to interface entry. I am tinkering with Tkinter and want to review some Tkinter interface building scripts. Really basic stuff covering file selection and making some of the data captured required I am learning how to use Tkinter (Pytho

Calling macro from python script bombs out when custom table style is used

2014-04-02 Thread accessnewbie
I have a python script (2.7.5) that calls a macro from an excel template. Both scripts ran fine until i tried to apply a custom table style within excel. I suspect this has something to do with the win32.com client application not recognizing custom table styles. Does anyone have a work around s

Adding new lines to word document using zipfile module within python 2.7?

2013-08-27 Thread accessnewbie
Writing text to a word document (word 2007) using the zipfile module via python coding (python 2.7). Below if the section of code I am using to do this. I can't figure out what character I need to use to get it to add new lines to the zipfile. if Count: blurb = "\r\nINSERT TABLE HERE\r\n\r\

Working with Access tables and python scripts

2015-04-14 Thread accessnewbie
I have an existing extensive python script that I would like to modify slightly to run a different variation on a process. I also have all the variables I need to run this script (about 20 in total)stored in an Access 2010 64 bit database. Is it possible to create a button on an Access form (o

Re: Can I Import table from txt file into form letter using Python?

2013-02-21 Thread accessnewbie
On Thursday, February 21, 2013 2:12:12 PM UTC-8, WorkerBee wrote: > Very new to python but diving in with both feet here. > > > > I am trying to extend a python script to include automating a response form > letter by including the results from a text file in tabular format into the > letter.

Re: Can I Import table from txt file into form letter using Python?

2013-02-21 Thread accessnewbie
On Thursday, February 21, 2013 2:12:12 PM UTC-8, WorkerBee wrote: > Very new to python but diving in with both feet here. > > > > I am trying to extend a python script to include automating a response form > letter by including the results from a text file in tabular format into the > letter.

Grouping on and exporting to csv files

2013-03-19 Thread accessnewbie
My current Test_Sort.csv looks like this (which constantly changes-although never more than 4 records, thus far anyway): RecNo,Count,District,Fruit,StoreNo 1,100,0,oranges,1254 2,30,3,apples,654 3,100,0,bananas,21 4,0,4,grapes,478 I wrote the following python 2.7 script (stuck with 2.7) ---

Coding issue with XML for word document

2017-02-06 Thread accessnewbie
I am constructing a sentence to insert into a word xml template. My code is below #Create a list if len(myList) > 0: if len(myList) > 1: testText = list_format(myList) + " dealers." else: myText = myList[0] + " dealer." #Contruct sentence #m

Re: Coding issue with XML for word document

2017-02-08 Thread accessnewbie
> myBlurb = "My Favorite Cars - > My favorite cars are available at " + > myText + " > > What am I missing here? Sorry about posting in python group. My XML coding was embedded in python script. I will do better next time. The problem was with placement of tags. The following worked: myB