Jump to content

Auch info

Members
  • Content Count

    11
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Auch info

  • Rank
    member

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. The problem was effectively coming from Excel. Now it is working. Thank you for your help.
  2. Hello, I have data to import into a text field from excel or csv files. As samples, I have : 978.510 978.510.21 These are reference numbers. They should not be changed. The problem comes with the first sample as fm converts it into a number. It removes the last zero and change the dot to a coma (local culture info). The field is declared as text, indexed, not null and unique. 978.510 => 978,51 - not ok 978.510.21 => 978.510.21 - ok Thanks.
  3. Auch info

    Exporting fields' headers

    I have a look. Thank you to all.
  4. Auch info

    Exporting fields' headers

    This one : http://www.filemaker.com/help/12/fmp/html/add_view_data.4.48.html [Records menu > Replace Field Contents] does not exist in WebDirect 14
  5. Auch info

    Exporting fields' headers

    The feature seems not present in WebDirect. I had to work with what has been designed 10 years ago... And I don't have the possibility to re-engineer it. For the fields, there is a lot because some are common, some are specifics following the item type (painting, sculpture, tools...), and the designer putted everything in one table...
  6. Auch info

    Exporting fields' headers

    Excellent, I will have a look. Thank you.
  7. Auch info

    Exporting fields' headers

    Well, this is a museum inventory with more than 15000 records and 100 fields in one table. They currently proceed to update data to collections. Each item has an inventory number. Some collections are small so they update directly in WebDirect. Some are big (like the Mochica collection with 112 items), so they extract items they need in an excel file, then they update a field with the same value to all records (by dragging the mouse in the excel column), then they import back the file. The employees are not computer's friends... I has to be simple. And I have to find a solution to avoid them to enter the same value 112 times (or more). We use extraction as well to send data to the national museum agency or to print the annual mandatory paper version of the inventory. Only one employee works at a time on one collection, so there will (should) be no problem with overwritten data. In any case we have a daily backup. Finally as a solution I wrote a little tool to convert from '.mer' to Excel. I found another strange thing : when I export data to '.mer' format from WebDirect menu, I get it in UTF-8. That's fine. But if I want to export data to '.mer' file from within a script, I have only the ANSI or Windows encoding format ! Is it possible from a script to export data locally to the server, then run the tool to convert the file to finally download it to the user ? This would be a very good solution for me. Thank you I tried but there are problems within the ';' character that can be found in the data itself, letting excel thinking that it is a column separator.
  8. Auch info

    Exporting fields' headers

    I will write a tool to convert .mer files to excel. It is the easiest way for me. Thank you.
  9. Auch info

    Exporting fields' headers

    With FMP 8.5, they were exporting to Excel format. But WebDirect does not export to Excel.
  10. Auch info

    Exporting fields' headers

    Thank you for your answer. This is effectively 15,000 records for the moment. Should go to 23,000 when the base will be complete. Each record has around a hundred fields. This is a museum database where operators will extract a whole collection for inventory to add the same data in some fields using excel, then import it back to update the database. They used to proceed like that because they have big collections, avoiding a long update process. Excel does not open the .mer file correctly because the data can have ';' inside. and " is replaced with "". Thomas.
  11. Auch info

    Exporting fields' headers

    Hello, We have a table with more than 15000 rows (museum inventory application). We used to export large amount of rows (some times like 900) to modify several fields in every rows then import it back (with version 8.5 of fmp). Now that we migrated on FMS14, it appears that it is not possible to export the fields' names in the tab file as first line. Is there a way to get the headers in the exported file ? if not please consider adding the possibility in next release. Thank you Thomas.
×

Important Information

By using this site, you agree to our Terms of Use.