4 posts in this topic
When updating any 360works-plug-in it is deactivated after any update. Sometimes it does not even is replaced.
I have created batch-scripts to shut off FileMaker and then remove any 360works-plug-in.
After that my user(s) have to restart the application again and the new version of (any) 360works plug-in is installed correctly and activated automatically.
I also use other plug-ins by Troi, Dacons en Goya simultaniously and these work perfectly fine and also will be updated and activated when a newer version is being installed. Only the 360works-plug-ins fail to update everytime.
I use the script-step "Install plug-in file" so nothing exotic is done there.
The problems occur on windows 7, 8, 8.1, 10, 2008 and 2012. On the 32 and 64 bits versions (2012 - 64-bit only)
Any suggestions or anyone else has the same trouble?
I am using Scribe to extract text from a pdf. The pdf has a filesize of 705542 so it is fairly large. The Scribe result is fairly good but it has a serious problem: a space is inserted into words; see example of words like NE W YORK AND NEW JERSEY, airp orts, Inte rnational, Internat ional
Why does Scribe do this? Is there a way to fix it? (It is close to a dealbreaker if you can extract text but then not use the text that's extracted)
Many thanks in advance for your replies, as I certainly hope I can use Scribe since I've used 360Works products for years and Textractor before Scribe.
I am using Excel 365 on desktop and FileMaker Pro Advanced 15 with FileMaker Server.
I am able to connect to FileMaker from Excel using ODBC to read all records in a table or matching it to a hard coded name. Sample:
Select work FROM "Student Time Import" WHERE badgename="Patrick Dollar"
What I'd like to do is add a where clause where it selects hours worked based on the date in the Excel spreadsheet. The cell's date is B12 and so on. I know my syntax is wrong, but after several attempts, I haven't been able to solve it. Here is my syntax:
Select work FROM "Student Time Import" WHERE badgename="Patrick Dollar" and date = TimeSHeet(Select * FROM[SHRA Temp Timesheet.Range("B12).Value])
I am using FileMaker Pro 12. I wrote a script to look at a field and if the value is less or equal to .70 it will run the report. I have it set to Auto open an EXCEL spreadsheet. When the script runs I see that it finds the records but then my EXCEL spreadsheet is empty. Here is the script:
Perform Find [Restore] Save Records as Excel["TotalAttendance.xls";Automatically open;Records being browsed] Go to Layout[original layout] Show All Records In the Perform Find [Restore] I have the following coded:
Find Records PersonnelRecords::PercentDaysAttended:[<_ .70] That is suppose to be less than and equal to. Did not know how to show it with the keyboard.
I have 4 Tables of Sales Records (1 per Store) for the same 1000 products (each sold in the 4 Stores). Table1 (T1) has 30,000 records T2 has 50,000 records T3 has 10,000 records T4 has 10,000 records The fields in the 4 Tables have different names and contain similar “core” content. Tables are added to each month with additional records (imported into FM 14 Pro Advanced from Excel). Unfortunately the same Products are named slightly differently in each of the 4 tables. Each store / table has a (text) Product-ID but (for the same product) it is different per store. I do want to rectify this “naming problem” (perhaps in a Table #5?) so I can produce a report showing sales for each of the 1000 products across all 4 stores (grouped by date etc.) I’m not sure how to structure/carry-out this in Filemaker most effectively. Any ideas? Ultimately, when the data is clean, I want to upload ALL the records (e.g. 100,000 records) in one export into one Excel spreadsheet so I can run a Pivot Table (Cross-Tab) report. Do I need to combine the 4 Tables into 1 Master Table before doing an Export on the Master Table? If so, how would I do this? Thanks for any ideas about this?