cabsandy

Lee, Thanks for that -) Fenton-many thanks for the file-I'm now going to go away and see what I can come up.No doubt I'll be back asking more questions! cheers cab

Hi guys, Cheers for the replies-firstly I'm on FM 8.5.I noticed I hadn't updated my profile-which I'm trying to find now! I'm sure I put the info on the boxes when I posted but it's definitely 8.5 . On the first point of getting the data in, is this the same idea of the transpose function in Excel? So rather than having SID Good Codewords Correctable Codewords UnCorrectable Codewords it would be SID Good C Corr C UnCorr C ?? That makes sense-I'd done a few scripts in FM so I'll have a go at that-cheers On Fenton's point-yes-it's a good question.If I keep them all, I'm going to have a huge bank of records when I view it in Excel, which is not desirable.Do you think there could be a compromise where I only keep the last 3 sets of text files? That way, I get the data and have a confidence factor that the data is coming in in the right order. cheers cab

All, Sorry if the title seems a bit confusing and hopefully I have it in the right forum-if not, please feel free to move/suggest. I'm not looking to be spoon fed on this one, but to explore if the concept is viable.I have attached 3 files, 2 text files of the same type, and my miserable attempt at what I want to do in Excel Here's the idea-I'm puling stats off some routers that show errors on customer devices-these are the text files. These can be pulled every hour or as frequently as we like. The text files are repeating with 4 rows for each device SID Good Codewords Correctable Codewords UnCorrectable Codewords The idea is to have a running total of the rows with the words "Codewords" in them. What I hope to achieve is to identify those that have the most errors (these would be the two marked Correctable and UnCorrectable), and do a delta, from the first set of records, to the most recent.A rolling delta, if you like. The main identifer is the SID row-this is the number by which we identify the erroring device. As can be seen by the xls file, I can do this manually but its a pain to cut and paste every time we get a dump from the router. The idea is also hampered by one major flaw which kicks Excel into touch-the SID row.The routers have new devices that come online, so the text files can change, with the SID row changing-by that, I mean the SID number you see on row 300 might be on row 304 on th next update because a new device has come online.So I need some way to "glue" the files together by the SID, then do the maths, and finally present it in a meaningful format.Plus have the ability (through a script I guess?) to continually import new text files and update. Is it possible-if so, I'd love a steer in the right direction and then I can crack on thanks cab cpe_fec_25th_Aug.zip

David, The problem is that this is the way a) the data is presented off the machines the data has to remain this way, after any analysis, manipulation etc so I cant move it about-well, not that I would know how and then bring it back to way it was before it was manipulated Thanks for the reply anyway Cheers Sandy

Hi all, First post for a while (that's what CCNA studying does for you).Can anybody help? I've done a bit of searching across the forums but my problem seems to be unique-if anybody DOES know of a solution, then point me in the right direction and I will gladly follow -) Please see the attached file-it is a snapshot of a larger one-I have omitted some details as it is customer senstive but the main parts are in there Basically, there are 4 columns. Column A is a location identifier, column B is a card slot no., column C is a position within the card and column D is a configuration on that C position.So an example is acto 3/0 0 33.6 acto 3/0 1 36.8 acto 3/0 2 22 acto 3/0 3 33.6 acto 3/0 4 36.8 acto 3/0 5 28.8 The way these cards are set up, and the file gives you a greater example, is that they are "bundled" together-that is, card positions 0,1 & 2 should be mirrored on 3,4 & 5.In the above example, they are not (position 2 on bundle 0,1 & 2 is different from position 5 on bundle 3,4 & 5)-which is my problem.Is there any way in FM that I can pick this sort of anomilay saying TRUE (meaning both bundles are mirrored) or FALSE (meaning they are different)? Thanks for any guidance Sandy up_example_1.zip

Fenton, Works like a charm-thank you very much.Thanks to all who responded. Sandy

Soren, Many thanks for the response-I've been playing with the solutions offered above and it all seems to work.But I'd like to throw down a challenge-is it possible to use or adapt any of these to get, where possible, 2 duplicates, rather than the one? The reason is , as you've mentioned, the " boil" number can be quite low, especially on those sheets where the original record number is low to start with.And I only have FP6 so I dont know if the above file will work for me :-( Thanks Sandy

Ok-I've found out what my mistake was.Thanks for the help :-) Sandy

Hi all, I want to find/keep only one record of recurring duplicates-please see attatched. In column RF node, the first 3 records are all the same-I want to get to a point where I only keep the first one of the 3.The next 3 again are all the same-I only want to keep one.The next 8 are the same-I only want to keep one-and so on. Could somebody advise me on the best way to do this-the aim is to have an exportable summary file that contains only one record of each, rather than multiples. Thanks Sandy testfile.zip

Rod, I've tested this out and it looks to have done the job-thanks.One further question-I've noticed that if you continually paste into the text header field and then rerun the script, you can get all your records in-just takes a bit of time.I dont suppose there is a way to automate the loop script to "ask" for new sets of records? I see this as a way to overcome the FP ver 6 text limit size? Sandy

Rodin, Ahh-this looks good! You know I'm going to ask for tweeks.My complete amount of records has 1507-that 1507 x 4 lines. What is the limitation you mention in terms of text field size limit? Can the file be ammended to include an import records, rather than a cut and paste? I've managed to get the export working-this is the important part for me as once I have the records out, then I can apply my other scripts-which are looking good at the moment.Let me know what you think. Thanks Sandy

Lee, Many thanks for the reply-I appreciate the help.But this would have been a process for many files, over a cosiderable period of time.The manual manipulation will take up too much time-I was hoping all this work could have been achieved internally within FP.So I'll reckon I'll have to pass on using Filemaker and find another solution-if one exists. On another level, I find it surprising that FP does not have the flexibility to get round this sort of problem as searching through the forums would indicate that there are a few others who have files to manipulate, that are preseted in this format. Thanks again Sandy

Lee, It's what I'm looking for all right-confirm for me that the following ar the right steps 1. Save as text file 2. Import into Excel and save as .csv file 3. Import .csv file into FP and use as desired I'm not sure if I'm doing too much in that I should be able to import tab files directly? How did you get the raw text? Sandy

Lee,Jerry, Thanks for the reply-I didn't think this would be easy.I've done some work on it whilst waiting to see if somebody knew a quick answer.Could you take a look at my feeble attempt and let me know if there is no way that the info from the number count field could be added to its respective field? The information from the router will always be in this format.What I cant work out if there is a scrip step or loop that will allow me to say "in the sid field, take the first record from the number count field and insert.Then move to record 5 of the number count field and insert into sid field" and so on.I would need to follow this process for each field. Sandy fec.zip

Hi, I've been away for a while so excuse me-I've attached an example of what I'm trying to import if this makes things easier. From the text, which comes from a router we use, I'd like to import the information into FMP ver 6 in the "normal" format-this is, 4 field columns named Sid, Good, Corrected & Uncorrected. From that, I can set up my relationships and export functions which I've got a handle on, due in no small part to these forums. Unfortunately, when I try to import now, I just end up with one long field column which I cant use Can it be done? Thanks Sandy cmfecexample.txt

Mike-or anybody for that matter, Being thick-whats a calcsum? I can find no mention of it within internal FP help and there is only one mention of it through the search facility (back in 2000). Can somebody tell me where it is/ information on it?

Hi, Sorry about this-I know I should know this but I'm stuck. See attatched-both in fp and.csv format.I have made a concatination field of 4 existing fields. What I am trying to do is find how many entries of the same description occur over a certain time period (normally 30 days). So if Gateshead ubr01jarr Cable4/0 Upstream2 appears 6 times (as it does), I want to know that without having to type that single description in on a seperate find.As I have hundreds of this unique records within this one field, but all apearing 2,3 4 up to 20 times, it would be very timeconsuming. I've tried Find, summary and calculation fields but to no avail.I suppose what I'm looking for is a quick way of identifying my big hitters over this time frame- a script which I can then button on the layout. Can anybody help? Sandy Version: v6.x Platform: Windows 2000 snr export.zip

Hi all, THanks to Ralph I've got my database up and running-I've experimented a bit with subtotals and Grand Totals-is there a way then you can do a Find on the Top 10 (could be any number) subtotals? So I have a 100 indivdual subtotals but I want to see those with the highest amount of grouped entries? Sandy

Hi all, Looking for a bit of help on what is probably a simple problem-nothing in my FM Bible so here goes... The attached file is a set of example records-we update the file on a daily basis.We are looking for trends off recurring records-this will help us to spot our most troublesome technical areas.So we want to see , in the order of Region/UBR/cable, if the same combination appears for more than one day at a time.So if Aztec UBRO9 cable5/0 appeared on 3 days out of 10, we want to know about it so we can action on it.I deally we'd like to graph it but I guess that Export to Excel will be the easiest way for this part I'm guessing that scripts will be involved which I have a grip on the basics of-really I'm looking for ideas on the best way to approach it. I'd appreciate some input Sandy Version: v6.x Platform: Windows 2000 snrfind.zip

First of all, Ray, thanks for the detailed description-now I understand how it works, it makes trying to fix it so much easier. To everybody else who answered, thank you very much. I spent about 4 hours over a hot laptop and my FMP Bible trying to work out what I had wrong but gave up, through sore eyes -), and decided to ask the experts. 2 things Ive learned-the importance of quotation marks and using the inbuilt functions of FMP rather than copying word for word Thanks again Sandy

Ray, Hit a few problems-on the script line: If ["PatternCount(gNodeList_txt & "

Ray, Not tried a looping script beofre so here goes -) I'll put it in and let you know how I go-thanks for the help.And the export wil be less than 10,000 records so no probs there. Sandy

Hi all, Happy New Year first of all ;-) See my attached example file-I have .csv files which are of customer records-I want to Find on the RF node field-I have multiple entries in some cases. I only want to export , at a maximum, 2 duplicate entries in each case-but the duplicate entries change as you go down the list (I know, sounds wierd but the file explains it hopefully). I've tried the ! command but that will only show in the Find set 1 of each entry-as this exported file will eventually be imported into a customer managment system, we need more than 1 entry for each part of the network to get a good coverage. I reckon there must be some way of scriting this , with multiple Find ! commands but cant work out how. Can anybody help? Sandy raw example.zip

Robert, Appreciate the quick reply-but I very quickly ran into an issue-some of the fields (detailed description is one example) have multiple lines-which shoves all the other lines down and corrupts the script.So backto the drawing board for me -)

Hi, I've got some raw faults ticket data (ext is.rep normally) which I'd like some views on if I can use in FM.I've attached a small dummy sample. I just want to do the normal stuff-find, sort etc but the way the data is presented is rather strange-each "complete" record is seperated from the next by a space.Look at the text file and I'd appreciate some views as it's something I've never seen before and excel cant import the whole file because it has too many lines Thanks in advance Sandy ITSD4_small.txt